Question: Need help finding out this form in excel, I need to know what statement should I used ? what numbers should I be entering on

Need help finding out this form in excel, I need to know what statement should I used ? what numbers should I be entering on this form ? My company is Apple and I need direction on putting together a 5 year cash flow statements ( like what statement should I used and number ? )Need help finding out this form in excel, I need to know

PROJECT EVALUATION Year 1 Year 2 Year 3 Year 4 Year 5 ASSUMPTIONS Initial Investment Incremental savings Savings #1 Savings #2 Savings #3 TOTAL INCOME Incremental expense Expense #1 Expense #2 Expense #3 Expense #4 TOTAL EXPENSE Earning Before Interest and Taxes Tax 35% Net Income Add back depreciation CASH FLOW Cost of capital 10% Cells highlighted in yellow are input cells Other cells are calculation cells so do not enter in those cells. $0 #NUM! NPV IRR Payback Period ROI #DIV/0! PROJECT EVALUATION Year 1 Year 2 Year 3 Year 4 Year 5 ASSUMPTIONS Initial Investment Incremental savings Savings #1 Savings #2 Savings #3 TOTAL INCOME Incremental expense Expense #1 Expense #2 Expense #3 Expense #4 TOTAL EXPENSE Earning Before Interest and Taxes Tax 35% Net Income Add back depreciation CASH FLOW Cost of capital 10% Cells highlighted in yellow are input cells Other cells are calculation cells so do not enter in those cells. $0 #NUM! NPV IRR Payback Period ROI #DIV/0

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