31 32 33 2.( 45%) 34 Assume you have accumulated $600,000 in your pension account at the time of your retirement. You decide to withdraw your $600,000 at an equal amount per year ove 35 The annual interest rate of your pension fund investment is 5% 35 Please answer the follow 3 questions 37 38 a If you decide to make your first withdrawal on the first day of your retirement (payments happen at the beginning of each period). 39 How much will you receive every year? 40 Please put in the relavent numbers on the corospending cells, use financial functions to solve it and highlight the answer 41 PV 42 Term 43 Interest rate 44 PMT 45 46 b. If you decide to make your first withdeawal after one year of your retirement (payments happen at the end of each period) 47 How much will you receive every year? 48 Please put in the relavent numbers on the corospending cells, use financial functions to solve it and highlight the answer 49 PV s0 Term 51 Interest rate 52 PMT 53 54 c. If you decide to make your first withdrawal on the first day of your retirement, and you wish to get $60,000 per year for 25 years 55 How much do you need to have in your pension fund account? 56 Please put in the relavent numbers on the corospending cells, use "Goal Seek" to solve it and highlight the answer 57 PV 58 Term 59 Interest rate 60 PMT 61 62 Sheett Sheet2 Ready 31 32 33 2.( 45%) 34 Assume you have accumulated $600,000 in your pension account at the time of your retirement. You decide to withdraw your $600,000 at an equal amount per year ove 35 The annual interest rate of your pension fund investment is 5% 35 Please answer the follow 3 questions 37 38 a If you decide to make your first withdrawal on the first day of your retirement (payments happen at the beginning of each period). 39 How much will you receive every year? 40 Please put in the relavent numbers on the corospending cells, use financial functions to solve it and highlight the answer 41 PV 42 Term 43 Interest rate 44 PMT 45 46 b. If you decide to make your first withdeawal after one year of your retirement (payments happen at the end of each period) 47 How much will you receive every year? 48 Please put in the relavent numbers on the corospending cells, use financial functions to solve it and highlight the answer 49 PV s0 Term 51 Interest rate 52 PMT 53 54 c. If you decide to make your first withdrawal on the first day of your retirement, and you wish to get $60,000 per year for 25 years 55 How much do you need to have in your pension fund account? 56 Please put in the relavent numbers on the corospending cells, use "Goal Seek" to solve it and highlight the answer 57 PV 58 Term 59 Interest rate 60 PMT 61 62 Sheett Sheet2 Ready