Please answee the bottom question. $5$ scenarios using an excel formula

Open the workbook Investment Options. Your financial advisor believes that if you buy mutual funds, you can earn a return on investment of 5% (which is the annual interest rate). In cell B6, enter the formula that will calculate how much your investment could earn you in five years based on the monthly payments specified in cell B5. Since you intend to also determine the value of your investment after five years on the basis of other monthly payment options, copy the formula to the right. What formula did you enter in cell B6 and copy to the other cells in the row? In anticipation of your future purchase, you also met a mortgage specialist. The bank could guarantee you an annual interest rate of 5.75% on a 20-year mortgage. In cell range B13:F13, enter the formulas that will calculate the value of the amount you could borrow from the bank based on monthly mortgage payments of different values between $1,000 and $1,600. What formula did you enter in cell B13 and copy to other cells in the row? oawlcc alculate the maximum value that you can invest in a property after five years, according to ifferent scenarios: Savings of $300 per month for five years, and monthly mortgage payments of $1,000 Savings of $350 per month for five years, and monthly mortgage payments of $1,150 Savings of $400 pe month for five years, and monthly mortgage payments of $1,300 Savings of $450 per month for five years, and monthly mortgage payments of $1 ,450 Savings of $500 per month for five years, and monthly mortgage payments of $1,600