PV and FV functions in Excel / please do not answer if you are not 100% sure of the answer ! :) Also, PLEASE explain HOW you got your answer. I have to show my work in Excel so explain how I get my answer in excel.

4) You are saving for retirement in 20 years. Today, you place $100,000 in a bank account that pays 4% interest, compounded annually, leaving the funds on deposit for the entire 20 years. You also contribute $2,000 each year into your pension plan for 10 years, beginning this year. The pension plan grows at 7% a year. How much do you have available for retirement, 20 years from now? BE CAREFUL; this is a multi-step problem.