calculations should be on excel !

2. You are planning for your pension plan that you will start to invest money, deposit first saving a year from today, last saving will be at 20th. year, and get retired after 20 years. You desire to take an immediate trip, costing approximately 15000 TL.(t=20) when you retire, and expect to live 25 more years, for which you need 6000 TL each year, starting from one year from retirement. Your savings will be equal and on annual basis. Savings will earn 10% annually. a. How much you should save each year to accomlish your goals? b. If your pension plan requires semiannual deposits, and stil earn 10% annually, what would be your each deposit