Answered step by step
Verified Expert Solution
Question
1 Approved Answer
On the '2020 forecasted SCF' tab, you have been provided with the actual 2019 and forecasted 2020 balance sheet and income statement. Please notice that
On the '2020 forecasted SCF' tab, you have been provided with the actual 2019 and forecasted 2020 balance sheet and income statement. Please notice that the spreadsheet uses formulas to do the addition and subtraction. In this exercise we want to make sure that you use Excel for what it is intended to do - math. Do not use Excel as a Word document where you do the calculations on your calculator and then input the results in to a cell in the worksheet. Your assignment is to prepare a forecasted 2020 Statement of Cash Flows that is dynamic - that is, it will change based on how assumptions (in those green boxes) are changed. STEP ONE - REVIEW Please review the formulas in the financial statements in the '2020 forecasted SCF' tab to make sure that you understand which variables related to which cells. STEP TWO - FORECASTING THE SCF Beginning down below cell 'B75' you are to create a dynamic forecasted statement of cash flows. There is no one specific format that you are to use (though your format should be similar to those used in class.) We will then change the assumptions in the green boxes to determine if your forecasted SCF is functioning properly
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered 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