Question: EncryptCo has a project that has a $35,000 first cost that returns $7,500 per year over its 12 year life. The salvage value after 12
EncryptCo has a project that has a $35,000 first cost that returns $7,500 per year over its 12 year life. The salvage value after 12 years is $5,000. The MARR is 4% nominal annual compounded quarterly.
(a) Calculate the present value of this project and check with Excel. Copy the Excel output into your assignment.
(b) Calculate the annual worth of this project and check with Excel. Copy the Excel output into your assignment.
(c) Calculate the payback period of this project.
(d) Calculate the discounted payback period of this project using Excel. Copy the Excel output into your assignment.
please also show the formulas used for the excel table thank u
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
