Question

Jim Daniels Health Products has eight stores. The firm wants to expand by two more stores and needs a bank loan to do this. Mr. Hewitt, the banker, will finance construction if the firm can present an acceptable three-month financial plan for January through March. Following are actual and forecasted sales figures:

 

Actual			Forecast			Additional Information
November	$600,000		January	$680,000		April forecast	$730,000
December	620,000		February	720,000
			March	740,000

 

Of the firm's sales, 40 percent are for cash and the remaining 60 percent are on credit. Of credit sales, 30 percent are paid in the month after sale and 70 percent are paid in the second month after the sale. Materials cost 30 percent of sales and are purchased and received each month in an amount sufficient to cover the following month's expected sales. Materials are paid for in the month after they are received. Labour expense is 50 percent of sales and is paid in the month of sales. Selling and administrative expense is 8 percent of sales and is also paid in the month of sales. Overhead is $35,000 in cash per month; Amortization expense is $12,000 per month. Taxes of $9,900 will be paid in January and dividends of $5,500 will be paid in March. Cash at the beginning of January is $120,000, and the minimum desired cash balance is $115,000.

 

a. Prepare a schedule of monthly cash receipts for January, February and March.

 

Jim Daniels Health Products Cash Receipts Schedule

November

December

January

February

March

April

Sales

$

$

$

$

$

$

Credit sales

Cash sales

Collections in the month   after credit sales

Collections two months   after credit sales

Total cash receipts

$

$

$

 

b. Prepare a schedule of  monthly cash payments for January, February and March.

 

Jim Daniels Health Products Cash Payments Schedule
	January	February	March
Payments for purchases	$	$	$
Labour expense
Selling and administrative expense
Overhead
Taxes
Dividends				Next > < Previous Sort answers by oldest Votes Oldest Newest Homework Answers Request Professional Answer Request Answer! We need at least 10 more requests to produce the answer. 0 / 10 The more requests, the faster the answer. Request! All students who have requested the answer will be notified once they are available. Know the answer? Add Answer to: Finance Question Your Answer: Post as a guest Your Name: What's your source? Earn Coins Log In Sign Up Post as anonymous Post Your Answer Similar Homework Help Questions Jim Daniels Health Products has eight stores. The firm wants to expand by two more stores... Jim Daniels Health Products has eight stores. The firm wants to expand by two more stores and needs a bank loan to do this. Mr. Hewitt, the banker, will finance construction if the firm can present an acceptable three-month financial plan for January through March. Following are actual and forecasted sales figures: Actual Forecast Additional Information November $240,000 January 260,000 February $320,000 April forecast 360,000 380,000 $370,000 December March Of the firm's sales, 40 percent are for cash and the... Jim Daniels Health Products has eight stores. The firm wants to expand by two more stores and needs a bank loan to... Jim Daniels Health Products has eight stores. The firm wants to expand by two more stores and needs a bank loan to do this. Mr. Hewitt, the banker, will finance construction if the firm can present an acceptable three-month financial plan for January through March. Following are actual and forecasted sales figures: November December Forecast Additional Information $350,000 January $450,000 April forecast $510.ece 0.000 February 500.000 March 520,000 Of the firm's sales, 30 percent are for cash and the remaining... Finance question im Daniels Health Products has eight stores. The firm wants to expand by two more stores and needs a bank loan to do this. Mr. Hewitt, the banker, will finance construction if the firm can present an acceptable three-month financial plan for January through March. Following are actual and forecasted sales figures: ActualForecastAdditional Information  November$520,000January$600,000April forecast$650,000    December540,000February640,000March660,000 Of the firm's sales, 50 percent are for cash and the remaining 50 percent are on credit. Of credit sales, 40 percent are paid in the... (Chapters 1,4,5) Submitted 80.37/100 Total points awarded Help E Explanation Show my answers January through March.... (Chapters 1,4,5) Submitted 80.37/100 Total points awarded Help E Explanation Show my answers January through March. Following are actual and forecasted sales figures: Actual Forecast Additional Information November $440,000 January $520,000 April $570,000 forecast December 460,000 February 560,000 March 580,000 ed of the firm's sales, 40 percent are for cash and the remaining 60 percent are on credit. Of credit sales, 30 percent are paid in the month after sale and 70 percent are paid in the second month after... Harry’s Carryout Stores has eight locations. The firm wishes to expand by two more stores and nee... Harry’s Carryout Stores has eight locations. The firm wishes to expand by two more stores and needs a bank loan to do this. Mr. Wilson, the banker, will finance construction if the firm can present an acceptable three-month financial plan for January through March. The following are actual and forecasted sales figures:      Actual Forecast Additional Information November $460,000 January $540,000 April forecast $470,000 December 480,000 February 580,000 March 480,000 Of the firm’s sales, 50 percent are for cash and the... Jim Daniels Health Products has eight stores. The firm wants to expand by two more stores... Jim Daniels Health Products has eight stores. The firm wants to expand by two more stores and needs a bank loan to do this. Mr. Hewitt, the banker, will finance construction if the firm can present an acceptable three month financial plan for January through March. Following are actual and forecasted sales figures: Actual Forecast November $440,000 January $520,000 December 460,000 February 560,000 March 580,000 Additional Information $570,000 forecast of the firm's sales, 40 percent are for cash and the...      Harry's Carryout Stores has eight locations, The firm wishes to expand by two more stores...      Harry's Carryout Stores has eight locations, The firm wishes to expand by two more stores and needs a bank loan to do this. Mr. Wilson, the banker, will finance construction if the firm can present an acceptable three-month financial plan for January through March. The following are actual and forecasted sales figures: Actual Forecast Additional Information November 360,000 January 440,000 April forecast December 380,000 February480,000 $420,000 March 430,000 Of the firm's sales, 50 percent are for cash and ther... please help Che Harry's Carryout Stores has eight locations. The firm wishes to expand by two... please help Che Harry's Carryout Stores has eight locations. The firm wishes to expand by two more stores and needs a bank loan to do this. Mr. Wilson, the banker, will finance construction if the firm can present an acceptable three-month financial plan for January through March. The following are actual and forecast sales figures: Actual Forecast Additional Information November $240, 8 January $320,000 April forecast $360,000 December 260,00 February 360,000 March 370,000 of the firm's sales, 60 percent are... Harry's Carryout Stores has eight locations. The firm wishes to expand by two more stores and... Harry's Carryout Stores has eight locations. The firm wishes to expand by two more stores and needs a bank loan to do this. Mr. Wilson, the banker, will finance construction if the firm can present an acceptable three-month financial plan for January through March. The following are actual and forecast sales figures: Actual Forecast Additional Information November $240,000 January $320,000 April forecast $360,000 December 260,000 February 360,000 March 370,000 Of the firm's sales, 60 percent are for cash and the... Harry's Carryout Stores has eight locations. The firm wishes to expand by two more stores and needs a bank loan to do t... Harry's Carryout Stores has eight locations. The firm wishes to expand by two more stores and needs a bank loan to do this. Mr. Wilson, the banker, will finance construction if the firm can present an acceptable three-month financial plan for January through March. The following are actual and forecast sales figures: Actual Forecast Additional Information November $240,000 January $320,000 April forecast $360,000 December 260,000 February 360,000 March 370,000 Of the firm's sales, 60 percent are for cash and the... ADVERTISEMENT Free Homework Help App Download From Google Play Scan Your Homework to Get Instant Free Answers Need Online Homework Help? Ask a Question Get Answers For Free Most questions answered within 3 hours. ADVERTISEMENT Share Your Knowledge Post an Article +5 Coins Post an Answer +5 Coins Post a Question with Answer +5 Coins Active Questions Where is the error in this code sequence? String s1 = "Hello"; String s2 = "ello";... Financial data for Joel de Paris, Inc., for last year follow: Joel de Paris, Inc. Balance... Consider this reaction:   Al2(SO4)3 (aq)+ BaCl3 (aq)  Al2Cl6 (aq)- + 3BaSO4(s) .   What is the... Suppose that Savneet is considering increasing her recent random sample from 20 car rentals to 40... Trucks arrive at an unloading terminal at an average rate of 120 per hour. Trucks arrive... Why are methanol and ethanol completely soluble in water while octanol is not very little soluble.... A facilities manager at a university reads in a research report that the mean amount of... When the CuSO4 is rehydrated by adding water to the anhydrous compound, is this an endothermic... A ray of sunlight is passing from diamond into crown glass; the angle of incidence is... A block of mass 0.249 kg is placed on top of a light, vertical spring of... how do the kidneys compensate in the presences of acidosis a) trigger hyperventilate b) reserve acid... Question 501 pts The rental rate of capital to the firm increases. Which of the following... ADVERTISEMENT DMCA About Contact Terms of Use Privacy Policy Academic Honesty Policy Homework Answer Scanner App © 2013-2022 HomeworkLib user contributions licensed under cc by-sa 4.0