Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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.
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 SecuritiesStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started