Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Must be in Excel formulae .. I have figured out all other formulas but struggling on the NPV. Thank you!! ASSET INVESTMENT $2,900,000 (Cell D6)

Must be in Excel formulae .. I have figured out all other formulas but struggling on the NPV. Thank you!!

ASSET INVESTMENT $2,900,000 (Cell D6)

ESTIMATED ANNUAL SALES $2,190,000 (Cell D7)

COSTS $815,000. (Cell D8)

TAX RATE 21%. (Cell D9)

PROJECT AND ASSET LIFE 3. (Cell D10)

REQUIRED RETURN 12% (Cell D11)

Sales - 2190000 (Cell D16)

Costs- 815000. (Cell D17)

Depreciation - 966667 (Cell D18)

EBT 408333 (Cell D19)

Taxes 85750 (Cell D20)

Net Income 322583 (Cell D21)

OCF 1289250 (Cell D23)

NPV ??? (Cell D25)

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

Students also viewed these Finance questions