please upload the excel used and show all the formula and steps please

Acrobat Reader File Edit View Sign Window Help DO $ 43% Sat 6:34 PM Q . .. & Problem Set Number One Winter 2023 (1).pdf Home Tools Problem Set Num... midterm review W... A Sign In T 4 / 8 + 75% Y PROBLEM TWO (20 MARKS) Search 'Extract Page Rachel is 35 years old. She plans on retiring in 25 years when she will be 60 years old. Rachel believes she will live until she is 105. Convert In order to live comfortably, she needs a substantial retirement income. She wants to receive an 4 annual income during retirement. The payments will be made at the end of each year during her retirement. There will be a total of 45 payments. The first payment will be $150,000. She wants the annual payments to increase by 3% per year during retirement. Edit PDF Also, Rachel has pledged to donate $500 a week to her favorite charity during her retirement. The payments will be made at the end of each week. The last payment will be made when she dies. Create PDF In addition, she would like to establish a scholarship at Ryerson. The first payment from scholarship would be $120,000. The first scholarship payment would be made 10 year after she retires L'O Thereafter scholarship payments will be made every year. To keep pace with inflation, Rachel Comment would like the amount of scholarship payments to increase by 4% each year. She wants the payments to continue after her death, therefore the payments will go on forever. Combine Files Rachel has two children, Ashley age 2 and Elizabeth age 5. Rachel plans on giving each child $1,500,000 when the child turns 40 years old. Organize Pages v During retirement, Rachel expects to earn 6% per year compounded annually. Compress PDF She currently has $250,000 in investment account A, that earns 6% interest per year compounded A semi-annually. Rachel currently contributes $1,200 every month to an investment account B. These contributions are made at the end of each month and will continue until she retires at 60. Rachel Redact expects to earn 8% per year compounded annually on her monthly contributions to her retirement account. Protect a) How much money does she need when she retires at the age of 60? Be certain to include all her financial goals. Request E-signat... b) How much money will she have when she retires? c) How much is she short? [Hint: that would be the difference between the amounts in parts (a) Lu Fill & Sign and (6)] d) In order to finance any shortfall, Rachel will make weekly contributions into a new retirement account. This new retirement account will earn 7% per year compounded annually. The Convert, edit and e-sign PDF contributions will be made at the beginning of each week until she retires at 60. How much forms & agreements must she contribute each week to the new retirement account? Free 7-Day Trial