need help with cash balance vs short/long term debt - due sunday 6/2
purplebed
ProForma1.xlsxSheet1
| Facts and Assumptions | ||||
| Year | 2015 | 2016 | 2017 | |
| Net sales | $ 12,650 | |||
| Growth rate in sales | 35% | 30% | ||
| Cost of goods sold/net sales | 86% | 86% | ||
| Gen., sell,, and admin. expenses/net sales | 12% | 11% | ||
| Long-term debt | $ 8,500 | $ 7,650 | $ 6,885 | Decrease -10% |
| Current portion long-term debt | $ 850 | $ 850 | $ 850 | Stays Constant |
| Interest rate | 10% | 10% | ||
| Tax rate | 45% | 45% | ||
| Dividend/earnings after tax | 50% | 50% | ||
| Current assets/net sales | 29% | 29% | ||
| Net fixed assets | 12,450 | $ 11,828 | $ 11,236 | Decrease -5% |
| Current liabilities/net sales | 14.5% | 14.4% | ||
| Owners' equity | $ 1,730 | |||
| INCOME STATEMENT | ||||
| Year | 2015 | 2016 | 2017 | |
| Net sales | $ 17,078 | $ 16,445 | ||
| Cost of good sold | 14,687 | 14,143 | ||
| Gross profit | 2,391 | 2,302 | ||
| Gen., sell,, and admin. exp. | 2,049 | 1,809 | ||
| Interest expense | 850 | 1,280 | ||
| Earnings before tax | (508) | (787) | ||
| Tax | (229) | (354) | ||
| Earnings after tax | (280) | (433) | ||
| Dividends paid | (140) | (216) | ||
| Additions to retained earnings | (140) | (216) | ||
| BALANCE SHEET | ||||
| Current assets | $ 4,952 | $ 4,769 | ||
| Net fixed assets | 11,828 | 11,236 | ||
| Total assets | 16,780 | 16,005 | ||
| Current liabilities | 2,476 | 2,368 | ||
| Long-term debt | 7,650 | 6,885 | ||
| Equity | 1,590 | (216) | ||
| Total liabilities and shareholders' equity | 11,716 | 9,037 | ||
| EXTERNAL FUNDING REQUIRED | $ 5,064 | $ 6,968 | ||
Locate this information for your company
Use this data to calculate 2016 based on 2015 actuals. Note: you will need to modify: Long-term Debt, Current long-term debt and Net Fixed Assets based on your company's data.
Complete the formulas to calculate 2017 estimates)
