1.Solve the following financial problems using the time value of money functions in Excel (PV, FV, PMT, NPER, RATE, EFFECT) OR using your financial calculator.

oAssume you deposit $3,000 today, and $300 at the end of each year, in an account earning 4% per year for 20 years. What is the future value?

oGeneral Electric has an unfunded pension liability of $300 million that must be paid in 15 years. The CFO deposits $10 million in account today to help meet this goal, and will also deposit $8 million at the end of the next 15 years, to meet this liability. What annual rate of interest must the account earn to meet the liability?

oWhat is the present value of an ordinary annuity that promises $20,000 per year for 20 years if the appropriate discount rate is 5%?