Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed
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

blur-text-image

Get Instant Access with AI-Powered 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

Taxation Of Individuals And Business Entities 2019 Edition

Authors: Brian C. Spilker, Benjamin C. Ayers, John Robinson, Edmund Outslay, Ronald G. Worsham, John A. Barrick, Connie Weaver

10th Edition

1259918394, 978-1259918391

Students also viewed these Accounting questions