Answered step by step
Verified Expert Solution
Link Copied!

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

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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored 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

Surviving In General Management

Authors: Philip Berman, Pauline Fielding

1st Edition

9780333483145

More Books

Students also viewed these Finance questions

Question

I wasnt sure how to talk about this situation. It was too personal.

Answered: 1 week ago