Question: Financial Forecasting Example: Please use the attached financial statements to project the financial position for Dilbert Corp for 2019. Assume that sales grow YoY by

Financial Forecasting Example: Please use the attached financial statements to project the financial position for Dilbert Corp for 2019. Assume that sales grow YoY by 8%. Any external financing required will first be covered by the firm's cash and marketable securities. If this is insufficient, then the firm will issue equal portions of debt and equity to raise the remaining funds.

Financial Forecasting Example: Please use the attached financial statements to project thefinancial position for Dilbert Corp for 2019. Assume that sales grow YoYby 8%. Any external financing required will first be covered by the

2019 (F) 75 Dilbert Corp. Income Statement Units CAD$ mln Year 2018 (A) % Sales Sales 125 Cost of Goods Sold Gross Profit Sales, General and Admin Depreciation Earnings before Interest and Tax Interest Earnings before Tax Tax (20%) Net Income Dividends Paid Dilbert Corp. Balance Sheet Units CAD$ min 2018 (A) % Sales 2019 (F)* 2019 (F) Assets Cash and Equivalents Accounts Receivable Inventory Total Current Assets Property, Plant and Equipment Total Assets Liabilities and SHE Accounts Payable Long-Term Debt Total Liabilities Shareholders' Equity Total Liabilities and SHE 125 150 2018 (A) % Sales 2019 (F)* 2019 (F) 10 75 65 150 2019 (F) Dilbert Corp. Cash Flow Statement Units CAD$ mln Operating Activities Net Income Depreciation Accounts Receivable Accounts Payable Inventory Cash from Operating Activities Investing Activities Capital Expenditures Cash from Investing Activities Financing Activities Dividends Paid Sale or Purchase of Stock Increase in Long-Term Debt Cash from Financing Activities Change in Cash and Marketable Securities 2019 (F) 75 Dilbert Corp. Income Statement Units CAD$ mln Year 2018 (A) % Sales Sales 125 Cost of Goods Sold Gross Profit Sales, General and Admin Depreciation Earnings before Interest and Tax Interest Earnings before Tax Tax (20%) Net Income Dividends Paid Dilbert Corp. Balance Sheet Units CAD$ min 2018 (A) % Sales 2019 (F)* 2019 (F) Assets Cash and Equivalents Accounts Receivable Inventory Total Current Assets Property, Plant and Equipment Total Assets Liabilities and SHE Accounts Payable Long-Term Debt Total Liabilities Shareholders' Equity Total Liabilities and SHE 125 150 2018 (A) % Sales 2019 (F)* 2019 (F) 10 75 65 150 2019 (F) Dilbert Corp. Cash Flow Statement Units CAD$ mln Operating Activities Net Income Depreciation Accounts Receivable Accounts Payable Inventory Cash from Operating Activities Investing Activities Capital Expenditures Cash from Investing Activities Financing Activities Dividends Paid Sale or Purchase of Stock Increase in Long-Term Debt Cash from Financing Activities Change in Cash and Marketable Securities

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!