Percent of Sales Technique Homework XYZ Company Income Statement For the Year En
ID: 2772412 • Letter: P
Question
Percent of Sales Technique Homework
XYZ Company Income Statement For the Year Ended 12/31/xxxx
Sales $140,000
Cost of Goods Sold 117,000
Gross Profit 23,000
Operating Expenses 12,830
EBIT 10,170
Interest Expense 4,610
EBT 5,560
Taxes @ 39% 2,168
Net Income 3,392
Dividend 1,018
Addition to Retained Earnings $2,374
XYZ Company Balance Sheet 12/31/xxxx
Assets
Current Assets
Cash $7,500
Accounts Receivable 12,100
Inventory 10,400
Prepaid Items 5,900
Other CA 4,300
Total Current Assets $40,200
Net Plant & Equipment 82,300
Total Assets $122,500
Liabilities & Equity
Current Liabilities
Accounts Payable $7,200
Wages Payable 3,600
Notes Payable 5,400
Taxes Payable 4,200
Total Current Liabilities $20,400
Long Term Debt 35,700
Total Liabilities $56,100
Common Stock 28,700
Retained Earnings 37,700
Total Liabilities & Equity $122,500
Homework Problem, cont’d
The projected sales for the forecast period is $165,000. Assume that the existing profit margin and payout ratio will be maintained in the forecast period. The firm estimates that additional net fixed asset investment of $18,000 will be required during the forecast period. Assume that all current assets are spontaneous except Other Current Assets which is assumed not to change. Assume that all current liabilities except Notes Payable are spontaneous. A. Prepare the pro forma Balance Sheet and pro forma Income Statement. The EFR will be a plug number that makes the balance sheet balance like in the class example. B. Using the existing financial statements as your basis, estimate firm XYZ’s EFR for the forecast period again, but this time using the cookbook model. Also based on the cookbook equation, how much funding is expected to come from each of the internal sources of funds (change in SL and retained earnings). If firm XYZ must maintain a minimum current ratio of 1.8 and a maximum debt ratio of 0.50, how would you propose the EFR be financed (how much short term debt, long term debt, and equity)? C. Based on your results in part B, prepare a Pro Forma Sources and Uses of Funds Statement to reflect the financing allocations that you decided on in part B. The only format change required is to break the total EFR down into the amounts of short term debt, long term debt, and new equity. You will have to use the numbers for CA, SL, addition to R.E., and EFR that you calculated in part B to make it balance, since they may be slightly different than those from part A. Explain the basis for your financing allocations.
Explanation / Answer
XYZ Company Income Statement For the Year Ended 12/31/xxxx Projection Sales $140,000 140000 165000.00 Cost of Goods Sold 117,000 117000 83.57% 137892.86 Gross Profit 23,000 23000 16.43% 27107.14 Operating Expenses 12,830 12830 9.16% 15121.07 EBIT 10,170 10170 7.26% 11986.07 Interest Expense 4,610 4610 3.29% 5433.21 EBT 5,560 5560 3.97% 6552.86 Taxes @ 39% 2,168 2168 2555.61 Net Income 3,392 3392 2.42% 3997.24 Dividend 1,018 1018 30.01% 1199.64 Addition to Retained Earnings $2,374 2374 2797.60 XYZ Company Balance Sheet 12/31/xxxx 12/31/xxxx %age on sales Increase Projection Assets Current Assets: Cash $7,500 7500 5.36% 1339.29 8839.29 Accounts Receivable 12,100 12100 8.64% 2160.71 14260.71 Inventory 10,400 10400 7.43% 1857.14 12257.14 Prepaid Items 5,900 5900 5900 Other CA 4,300 4300 4300 Total Current Assets $40,200 40200 28.71% 5357.143 45557.14 Net Plant & Equipment 82,300 82300 58.79% 18000 100300 Total Assets $122,500 122500 87.50% 23357.14 145857.1 Liabilities & Equity Current Liabilities Accounts Payable $7,200 7200 5.14% 8485.71 Wages Payable 3,600 3600 2.57% 4242.86 Notes Payable 5,400 5400 3.86% 6364.29 Taxes Payable 4,200 4200 3.00% 4950.00 Total Current Liabilities $20,400 20400 14.57% 24042.86 Long Term Debt 35,700 35700 25.50% 4805.56 40505.56 Total Liabilities $56,100 56100 40.07% 64548.42 Common Stock 28,700 28700 20.50% 12111.12 40811.12 Retained Earnings 37,700 37700 26.93% 2797.60 40497.6 Total Liabilities & Equity $122,500 122500 87.50% 14908.72 145857.1 Current Ratio (Current Assets/Current Liabilities) 1.97 1.89 Debt to equity Ratio 0.54 0.50
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.