Answered step by step
Verified Expert Solution
Link Copied!

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.

image text in transcribedimage text in transcribedimage text in transcribed

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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Dynamics Of International Finance

Authors: Ruchi Mehrotra Joshi

1st Edition

1685078389, 978-1685078386

More Books

Students also viewed these Finance questions