Problem 1:

A. 10 equal annual end-of-the-year payments of $82,500 per year beginning in 20 years will be received

B. One lump-sum of $1,000,000 in 30 years will be received

C. One payment of $200,000 in 10 years, a second payment of $200,000 in 20 years, and a third payment of $200,000 in 30 years will be received

Question: What is the present value of the policies at a discount rate of 4 percent?

Please show all work in excel and in financial calculator