Financial & Managerial Accounting by Wild/Shaw - Ch 24 Bonus Excel Homework.

I tried both =PV(B16/12,7*12,0,C25) and =NPV(B16, C25) and it said I was wrong both times.

B16 = 18% - Project Life 7 yrs (C3)

Question: Enter the formula to compute the present value of an annuity of $1

Similar Issue with D28 - all the help on annuities are calculating retirement payments

Year(s) 1-7 23 24 Initial investment 25 Annual cost savings 26 Salvage value of the new machine 27 Total cash flows 28 Discount factor 29 Present value of the cash flows 30 Net present value 31 32 Use Excel's PV function to compute the present value of the future cash flows Now $ (2,205,000.00) 630,000.00 225,000.00 225,000.00 $ (2,205,000.00) 1.000 630,000.00 S ...Sheet1 ... + READY Attempt(s) 1/3 Step: Enter the formula to compute the present value of an annuity of $1