What is the net present value of the investment in the furnace? (Do not round intermediate calculations. Round your answer to the nearest whole dollar.)b. What is the IRR? (Do not round intermediate calculations. Enter your answer as a percent rounded to 2 decimal places.)c. What is the payback period? (Do not round intermediate calculations. Round your answer to 2 decimal places.)d. What is the equivalent annual cost of the furnace? (Do not round intermediate calculations. Round your answer to 2 decimal places.)e. What is the equivalent annual savings derived from the furnace?

a) NPV = $65,034.65

b) IRR = 27.71%

c) Payback period = 3.85 years

d) Equivalent annual cost = -$4,815.84

e) Equivalent annual saving = $12,454.79

Explanation:

The first part of the question is missing, so I looked it up:

"A new furnace for your small factory will cost $41,000 to install and will require ongoing maintenance expenditures of $3,500 a year. But it is far more fuel efficient than your old furnace and will reduce your consumption of heating oil by 3,800 gallons per year. Heating oil this year will cost $3 a gallon; the price per gallon is expected to increase by $.50 a year for the next 3 years and then to stabilize for the foreseeable future. The furnace will last for 20 years, at which point it will need to be replaced and will have no salvage value. The discount rate is 10%."

since the question is a little bit long, I prepared an excel spreadsheet:

i think it is sales-oriented, but i am not sure

answer; erp systems;