I need help solving this problem in excel my answer is not coming out the way, I expect it to come out. I am trying to f

[answerhappygod]

I need help solving this problem in excel my answer is not coming out the way, I expect it to come out. I am trying to figure it out. can you help please.

I Need Help Solving This Problem In Excel My Answer Is Not Coming Out The Way I Expect It To Come Out I Am Trying To F 1 (271.78 KiB) Viewed 13 times

I Need Help Solving This Problem In Excel My Answer Is Not Coming Out The Way I Expect It To Come Out I Am Trying To F 2 (44.94 KiB) Viewed 13 times

A machine cost $550,000 to purchase and install and will provide $125,000 in annual benefits. The company plans to use the machine for 10 years and then will sell the machine for scrap, receiving $12,500. It the company's compound annual interest rate is 12%, what is the net present value? a. 710,303 b. -160.303 160.275 d. 303.303

12% 10 indiv pv NPV 0 $125,000 $125,000 $125,000 $125,000 $125,000 $125,000 $125,000 $125,000 $125,000 $125,000 1 2 3 4 5 6 7 8 9 10 $111,607.14 $99,649.23 $88,972.53 $79,439.76 $70,928.36 $63,328.89 $56,543.65 $50,485.40 $45,076.25 $40,246.65 $706,277.88