please answer Q 1b and solve it. use Excell formulas please with explanation.

I attached the notes from professor for Q 1b. I also attached how i calculated and was told is not correct. please help.

moths on both interest rate and period. For q 1b Use the figure you correctly determined in Q 1 as your PV and multiply by the monthly interest rate. In question 2 your PMT figures are wrong. You have again ignored the implication of 12 moths on both the rate and the periods. You are also not financing the full $500 000. Please fix. 000 x Condor Fora Cat Formatting as Tobie Styles Format Sort & Filter fx -736606.78*(7.28/12) B D F G H K L Questions 1. Marie, an employee at McCormick, has determined that she will need $5000 per month in retirement over a 30-year period. She has forecasted that her money will earn 7.2% compounded monthly Marie will spend 25 years working toward this goal investing monthly at an annual rate of 2.2%. How much should Marle's monthly payments be during her working years in order to satisfy her retirement needs? Hint: Find how much Marie must have at retirement, then find the monthly payments to reach that goal. What maximum amount could Marle withdraw each month so that her balance never decreases (nearest dollar)? 2. Kathy plans to move to Maryland and take a job at McCormick as the Assistant Director of HR. She and her husband Stan plan to buy a house in Garrison, MD and their budget is $500,000. They have $100,000 for the down payment and McCormick will pay for closing costs. They are considering either a 30 year mortgage at 4.5% annual rate or a 15 year mortgage at 4%. Calculate the monthly payment for each. Property taxes and insurance will add $1,000 per month to whichever mortgage they choose. What should Kathy and Stando? Answer Questions and 2 here. Show your calculations, N WYR PMT IFV PV PV PMT 360 0.60% -5000 0 $736,606.78 1 $736,606.78 $880.90 PV N VYR FV PMT 300 0.60% -736.606.78 $880.90 16 PMT $4,420 Hint: Consider the payment as perpetuity If she withdraws $4419.64 each month, the balance remains the same PMT- PV'/VA X Cut Calibri (Body 11 - A A Wrap Text General Copy Paste B 1 U- A. A F Merge & Cemer $ . % ) Insert Format DE Conditional Format Cell Formatting as Table Styles 133 . V fox B D E G 1 L Questions 2 3 4 5 6 7 8 1. Marie, an employee at McCormick, has determined that she will need $5000 per month in retirement over a 30-year period. She has forecasted that her money will earn 7.2% compounded monthly. Marie will spend 25-years working toward this goal investing monthly at an annual rate of 7.2%. How much should Marie's monthly payments be during her working years in order to satisfy her retirement needs? Hint: Find how much Marie must have at retirement, then find the monthly payments to reach that goal. What maximum amount could Marie withdraw each month so that her balance never decreases (nearest dollar)? 2. Kathy plans to move to Maryland and take a job at McCormick as the Assistant Director of HR. She and her husband Stan plan to buy a house in Garrison, MD and their budget is $500,000. They have $100,000 for the down payment and McCormick will pay for closing costs. They are considering either a 30 year mortgage at 4.5% annual rate or a 15 year mortgage at 4%. Calculate the monthly payment for each. Property taxes and insurance will add $1,000 per month to whichever mortgage they choose. What should Kathy and Stando? 9 10 1 2 3 4 5 6 7 8 Answer Questions 1 and 2 here. Show your calculations, 9 1 PV PMT 1 2 1b PMT Hint: Consider the payment as perpetuity, 11