Solution Problem 9-29 Instructions Use the MS Excel PV function to complete the table below Assumptions Amount now Annuity (9 years) Amount in 9 years $7,500 $2,200 $12,000 Present values Annuity (9 years) Amount received in 9 years 10% 11% FORMULA FORMULA FORMULA FORMULA Assuming you could earn 10 percent annually, which alternative should you choose? If you could earn 11 percent annually, would you still choose the same alternative