Do Part C) Don't use excel

You are trying to plan for retirement in 20 years and currently have $85,000 in a savings account and $25,000 in a mutual fund. In addition, you plan on adding to your savings account by depositing $1,500 at the end of each month for the next five years then $35,000 at the end of each year for the final fifteen years until retirement. B) If you expect to live for 30 years after you retire and at retirement you deposit all of your savings (including the value of the mutual fund) into an account paying interest of 7% compounded annually, how much can you withdraw at the beginning of each month? Question 2: Angela and Bill have just graduated from SMU and have started new jobs. They want to save for the down payment on the purchase of a new house in one year's time. They have met with their bank, who have indicated they will lend Angela & Bill 97% of the purchase price of their new home, which means Angela & Bill require a 3 % down payment To save for the down payment, Angela & Bill plan to invest $1500 in an investment account each month for one year (starting at the end of this month). The investment account has an APR of 8% compounded monthly. At the end of the year, all of these funds will be used for a down payment. a) Calculate what they are able to save as a down payment. b) Based on what they are able to save as a down payment, what is the maximum mortgage Angela & Bill can secure from the Bank? (Please round to the nearest dollar) c) Now that they know the amount of the mortgage (from part b), they must decide on the terms of the mortgage. They have been quoted a rate of 5% for a 5-year term but they are unsure of the amortization they should select. Bill wants to take a 25-year amortization so the payments will be lower, but Angela vaguely remembers something from her Finance class about a shorter amortization being better Here are the options: Option #1: 25-year amortization with monthly payments Option #2: 20-year amortization with monthly payments What are the monthly mortgage payments under option #1