oys for You, a manufacturing company, has been growing quickly but has found that its financial situation is continually under pressure. Production has fluctuated to meet demand in an attempt to provide first-class service, resulting in larger inventory positions. Also, the collection of accounts has worsened to approximately 60 days, which is well above the terms of 30 days. To address the financial concerns, Toys for You has proposed level production and an effort by the credit department to bring the average collection period down to 35 days. Estimated sales for the upcoming months are: July $1,957,500 August 2,070,000 September 2,205,000 October 2,362,500 November 2,475,000 December 2,565,000 Sales for May were $1,732,500 and will be approximately $1,845,000 for the current month of June. It is projected that the current collection period of 60 days will be reduced to 50 days for July and August, 42 days for September and October, and will meet the target of 35 days in November and December. Purchases are forecast to be $585,000 a month beginning in July. In May they were $675,000, and in June they are expected to be $607,500. The purchases are paid in 40 days. Labour expense will be paid as incurred and will be $195,000 a month. Other expenses of manufacturing will also be paid as incurred and are expected to be $375,000 a month. Cost of goods sold has regularly been 70 percent of sales. Amortization is $38,000 per month. Selling and administrative expenses are expected to be 13 per- cent of sales. The tax rate is 42 percent. There will be payments on notes of $675,000 in each of August and November. Interest of $270,000 and income taxes of $338,000 are both due in October. Dividends of $22,500 are payable in July and October. Toys For You Balance Sheet (estimated) June 30, 2016 ($ thousands) Assets Current assets: Cash $666 Accounts receivable 3,578 Inventory 8,231 Total current assets 12,475 Capital assets: Plant and equipment 11,273 Less: Accmulated amortization 4,784 6,489 Total assets $18,964 Liabilities and Shareholders Equity Current liabilities Accounts payable $945 Notes payable 3,700 Accrued liabilities 2,596 Total current liabilities 7,241 Long-term debt 4,725 Common stock 4,500 Retained earnings 2,498 Total liabilities and shareholders' equity $18,964 Using the information above, prepare pro forma statements for Toys for You for the three months ending September and December 2016. Also construct a cash budget for the six-month period and identify any need for short-term financing. There are no changes in accounts not mentioned above. Comment on the policy changes and examine the consequences if the collection period remains at 60 days. Assume capital assets are sufficient for increased sales. Show all calculations.
IF YOU HAVE ANY DOUBTS COMMENT BELOW
ANSWER:
EXPLANATION:
Cash Budget till December | |||||||||
May | June | July | August | Sept | oct | Nov | Dec | Remarks | |
Sales | 1732500 | 1845000 | 1957500 | 2070000 | 2205000 | 2362500 | 2475000 | 2565000 | |
Purchases | 675000 | 607500 | 585000 | 585000 | 585000 | 585000 | 585000 | 585000 | |
Cash Collection | |||||||||
Sales of May (60 days) | 1732500 | ||||||||
Sales of June (60 days) | 1845000 | ||||||||
Sales of July (50 days) | 652500 | 1305000 | 10 days sales is expected to be collected in next month | ||||||
Sales of August (50 days) | 690000 | 1380000 | 10 days sales is expected to be collected in next month | ||||||
Sales of September (42 days) | 1323000 | 882000 | 18 days sales is expected to be collected in next month | ||||||
Sales of October (42 days) | 1417500 | 2362500 | 18 days sales is expected to be collected in next month | ||||||
Sales of November (35 days) | 2062500 | 25 days sales is expected to be collected in next month | |||||||
Total Cash inflow | 1732500 | 2497500 | 1995000 | 2703000 | 2299500 | 4425000 | |||
* Considered that sales are linear during the month | |||||||||
* DSO is mentioned in the brackets | |||||||||
Expenses | |||||||||
Suppliers (40 Days) | 630000 | 592500 | 585000 | 585000 | 585000 | 585000 | 20 days purchase in payable in next month and 10 days in m+2 | ||
Labour Expenses | 195000 | 195000 | 195000 | 195000 | 195000 | 195000 | |||
Other Expenses | 375000 | 375000 | 375000 | 375000 | 375000 | 375000 | |||
SG&A (13%) | 254475 | 269100 | 286650 | 307125 | 321750 | 333450 | |||
Payment of Notes | 675000 | 675000 | |||||||
Interest Payment | 270000 | ||||||||
Income Taxes | 338000 | ||||||||
Dividend Payable | 22500 | 22500 | |||||||
Total Cash Outflow | 1476975 | 2106600 | 1441650 | 2092625 | 2151750 | 1488450 | |||
Culumative Cash Balance | 666000 | 921525 | 1312425 | 1865775 | 2476150 | 2623900 | 5560450 | ||
* Considered that sales are linear during the month |
oys for You, a manufacturing company, has been growing quickly but has found that its financial...
Company X, a manufacturing company, has been growing quickly but has found that its financial situation is continually under pressure. Production has fluctuated to meet demand in an attempt to provide first-class service resulting in larger inventory positions. Also, the collection of accounts has worsened to approximately 60 days which is well above the terms of 30 days. To address the finanical concerns, Toys for You has proposed level production and an effort by the credit department to bring the...
FORECASTING ASSIGNMENT- Peel Inc. Assume you are the Financial Analyst for Peel Inc., and it is the end of December 2019. Peel Inc., a manufacturing company, has been growing quickly, but it has found that its financial situation is continually under pressure. Production has fluctuated to meet demand in an attempt to provide first-class service, resulting in larger inventory positions. Also, the collection of accounts has worsened to approximately 60 days, which is well above the terms of 30 days....
FORECASTING ASSIGNMENT- Peel Inc. Assume you are the Financial Analyst for Peel Inc., and it is the end of December 2019. Peel Inc., a manufacturing company, has been growing quickly, but it has found that its financial situation is continually under pressure. Production has fluctuated to meet demand in an attempt to provide first-class service, resulting in larger inventory positions. Also, the collection of accounts has worsened to approximately 60 days, which is well above the terms of 30 days....
Big Sound, a merchandising company specializing in home computer speakers, budgets its monthly cost of goods sold to equal 70% of sales. Its inventory policy calls for ending inventory at the end of each month to equal 20% of the next month's budgeted cost of goods sold. All purchases are on credit, and 25% of the purchases in a month is paid for in the same month. Another 60% is paid for during the first month after purchase, and the...
The controller of Bridgeport Housewares Inc. instructs you to prepare a monthly cash budget for the next three months. You are presented with the following budget information: September October November Sales $114,000 $140,000 $189,000 Manufacturing costs 48,000 60,000 68,000 Selling and administrative expenses 40,000 42,000 72,000 Capital expenditures _ _ 45,000 The company expects to sell about 10% of its merchandise for cash. Of sales on account, 70% are expected to be collected in the month following the sale and...
can you please show the work as well. Cash Budget The controller of Bridgeport Housewares Inc. instructs you to prepare a monthly cash budget for the next three months. You are presented with the following budget information: September October November Sales $111,000 $132,000 $179,000 Manufacturing costs 47,000 57,000 64,000 Selling and administrative 39,000 40,000 68,000 expenses Capital expenditures 43,000 The company expects to sell about 10% of its merchandise for cash. Of sales on account, 70% are expected to be...
Cash Budget The controller of Bridgeport Housewares Inc. instructs you to prepare a monthly cash budget for the next three months. You are presented with the following budget information: September October November Sales $121,000 $155,000 $201,000 Manufacturing costs 51,000 67,000 72,000 Selling and administrative 42,000 47,000 76,000 expenses Capital expenditures 48,000 The company expects to sell about 10% of its merchandise for cash. Of sales on account, 70% are expected to be collected in the month following the sale and...
Cash Budget The controller of Bridgeport Housewares Inc. instructs you to prepare a monthly cash budget for the next three months. You are presented with the following budget information: September October November Sales $96,000 $114,000 $153,000 Manufacturing costs 40,000 49,000 55,000 Selling and administrative expenses 34,000 34,000 58,000 Capital expenditures _ _ 37,000 The company expects to sell about 10% of its merchandise for cash. Of sales on account, 70% are expected to be collected in the month following the...
Colerain Corporation is a merchandising company that is preparing a budget for the third quarter of the calendar year. The company's balance sheet as of June 30 is shown below: COLERAIN CORPORATION Balance Sheet June 30 Assets Cash Accounts receivable Inventory Plant and equipment, net of depreciation 95,000 141,000 67,000 350,000 Total assets $ 653,000 Liabilities and Shareholders' Equity Accounts payable Common shares Retained earnings 76,000 450,000 127,000 Total liabilities and shareholders' equity $653,000 Colerain's managers have made the following...
The controller of Bridgeport Housewares Inc. instructs you to prepare a monthly cash budget for the next three months. You are presented with the following budget information: September October November Sales $142,000 $169,000 $224,000 Manufacturing costs 60,000 73,000 81,000 Selling and administrative expenses 50,000 51,000 85,000 Capital expenditures _ _ 54,000 The company expects to sell about 10% of its merchandise for cash. Of sales on account, 70% are expected to be collected in the month following the sale and...