Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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 ? )
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/0Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored 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