Question: 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

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

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 Accounting Questions!