In: Finance
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