1. Project year 6 income statement and balance sheet
2. Compute the additional funds needed (AFN
Pizza by Mail Complete the forecasted financial statements below: (Round to the nearest integer.) ratios Year 6 Revenue Cost of Goods Sold SG and A Depreciation Expense EBIT Interest Expenses Earnings Before Taxes Income Taxes Net Income (Round to the nearest integer.) Year 5 7,068,828 3,981,761 2,769,395 190.149 127,523 41.209 86,314 27.077 59,237 Sales growth Cost of debt of last periods long-term debt Tax rate Depreciation rate Capital expenditures Hold goodwill & intagibles, and common stock constant No dividends 0.048 0.0555 0.35 0.1495 190,775 $ Year 4 Year 5 Selected ratios Cost of goods sold SG&A/sales Current assets to sales current liabilities/sales 0.563284465 0.391775695 0.32304266 0.15541275 2,278,913 1,058,252 681.255 4,018,420 2,283,533 1,054,115 676.190 4,013,838 ASSETS Total Current Assets Property, Plant and Equipment Intangible Assets Total Assets LIABILITIES AND STOCKHOLDERS' EQUITY Total Current Liabilities Long-term Debt (Plug number) Total Liabilities Stockholders' Equity Common Stock Retained Earnings Total Stockholders' Equity Total Liabilities and Stockholders' Equity a. From the forecasted financial statements, what are the additional funds needed (AFN) in Year 6? The additional funds needed are: 1,062,735 790.799 1,853,534 1,098,586 715.487 1,814,073 1,483,940 680.946 2.164.886 4,018,420 1,478,647 721,118 2.199.765 4,013,838 Pizza by Mail Complete the forecasted financial statements below: (Round to the nearest integer.) ratios Year 6 Revenue Cost of Goods Sold SG and A Depreciation Expense EBIT Interest Expenses Earnings Before Taxes Income Taxes Net Income (Round to the nearest integer.) Year 5 7,068,828 3,981,761 2,769,395 190.149 127,523 41.209 86,314 27.077 59,237 Sales growth Cost of debt of last periods long-term debt Tax rate Depreciation rate Capital expenditures Hold goodwill & intagibles, and common stock constant No dividends 0.048 0.0555 0.35 0.1495 190,775 $ Year 4 Year 5 Selected ratios Cost of goods sold SG&A/sales Current assets to sales current liabilities/sales 0.563284465 0.391775695 0.32304266 0.15541275 2,278,913 1,058,252 681.255 4,018,420 2,283,533 1,054,115 676.190 4,013,838 ASSETS Total Current Assets Property, Plant and Equipment Intangible Assets Total Assets LIABILITIES AND STOCKHOLDERS' EQUITY Total Current Liabilities Long-term Debt (Plug number) Total Liabilities Stockholders' Equity Common Stock Retained Earnings Total Stockholders' Equity Total Liabilities and Stockholders' Equity a. From the forecasted financial statements, what are the additional funds needed (AFN) in Year 6? The additional funds needed are: 1,062,735 790.799 1,853,534 1,098,586 715.487 1,814,073 1,483,940 680.946 2.164.886 4,018,420 1,478,647 721,118 2.199.765 4,013,838
