Reference no: EM132945802
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.
A What is the cell formula for B12 in the Excel model?
B What is the cell formula for C12 in the Excel model?
D What is the cell formula for D4 in the Excel model?
E What is the cell formula for D5 in the Excel model?
F What is the cell formula for D6 in the Excel model?
G What is the optimal value for x1 in the Excel model?
H What is the optimal value for x2 in the Excel model?
I What does the value of cell F4 represent in the Excel model?
J What does the value of cell B5 represent in the Excel model?