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
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