CAN YOU HELP ME WITH CORRECTING MY ANSWERS. I got the ones in red wrong and i have tried multiple ways. Could you please help me in how to do those, in a detailed but simple way. Please! I will like the answer.

K$42$

$f_x$

A

B

C

D

E

F

G

Create a formula.

In the Mortgage Calculator worksheet, the formula in cell D$6$ should calculate the total interest of the loan.

$6.$ In cell D$7,$ enter a formula without using a function that adds the Price to the Total$\_$Interest to determine the total cost of the house.

Create a formula.

In the Mortgage Calculator worksheet, the formula in cell D$7$ should calculate the total cost of the loan.

$7.$ Miranda wants to compare monthly payments for interest rates that vary from $4\mathrm{.}00$ to $4\mathrm{.}96$ percent and for terms of $180,240,$

$\frac{3}{6}$

and $360$ months. She has already set up the structure for a data table in the range A$11$:D$24.$

Create a two$-$variable data table as follows to provide the comparison that Miranda requests:

a$.$ In cell All, enter a formula without using a function that references the Monthly$\_$Payment amount because Miranda wants to compare the monthly payments.

b$.$ Based on the range A$11$:D$24,$ create a two$-$variable data table that uses the term in months $($cell D$4)$ as the row input cell and the rate $($cell D$3)$ as the column input cell.

$27$

$28$

$29$

$30$

$31$

$32$

$33$

$34$

$35$

$36$

$37$

$38$

$39$

Create a formula.

In the Mortgage Calculator worksheet, the formula in cell Al$1$ should compare the monthly payments.

Create a two$-$variable data table.

$8.$ In the list of interest rates $($range A$12$:A$24),$ create a Conditional Formatting Highlight Cells Rule to highlight the listed rate

$\frac{3}{6}$

that matches the rate for the Beecher Street house $($cell D$3)$ in Light Red Fill with Dark Red Text.

X Apply a conditional formatting rule.

In the Mortgage Calculator worksheet, a conditional formatting rule should be applied to the range A$12$:A$24$ that formats any value equal to cell D$3.$

Format a conditional formatting rule.

$9.$ Change the color of the left, right, and bottom borders of the range A$9$:D$24$ to Tan, Accent $4,$ to match the other outside

$\frac{0}{6}$

borders in the worksheet.

Add a border to a range.

$10.$ Miranda and Ricardo talked to three local banks about securing a mortgage for the Beecher Street house. With the first bank, they could borrow $$315,000$ at $4\mathrm{.}40$ percent annual interest and pay back the loan in $30$ years. She wants to determine the monthly payment with the first bank.

In cell G$9,$ enter a formula using the PMT function and the monthly interest rate $($cell G$5),$ the loan period in months $($cell G$7),$ and the loan amount $($cell G$3)$ to calculate the monthly payment with Bank $1.$

X Create a formula using a function.

In the Mortgage Calculator worksheet, the formula in cell G$9$ should use the PMT function to calculate the monthly payment with Bank $1.$

$11.$ With the second bank, Miranda and Ricardo could reduce their monthly payments to $$1,500$ but pay a higher annual interest

$\frac{6}{6}$

rate $(4\mathrm{.}56$ percent$)$ to pay back the loan in $30$ years. Miranda wants to know how much she can borrow with those conditions.

In cell $H3,$ insert a formula using the PV function and the monthly interest rate $($cell H$5),$ the loan period in months $($cell H$7),$ and the monthly payment $($cell H$9)$ to calculate the loan amount for Bank $2.$

X Create a formula using a function.

In the Mortgage Calculator worksheet, the formula in cell H $3$ should use the PV function to calculate the loan amount for Bank $2.$

$12.$ The third bank will allow Miranda and Ricardo to borrow $$337,500$ at an annual interest rate of $4\mathrm{.}56$ percent and a monthly

$\frac{0}{6}$

payment of $$1,500.$ Miranda wants to know the amount remaining on the loan after $20$ years, or the future value of the loan, so that she and Ricardo can start to pay it off more quickly at that point.

In cell I$10,$ insert a formula using the FV function and the monthly interest rate $($cell I$5),$ the loan period in months $($cell I$7),$ the monthly payment $($cell I$9),$ and the loan amount $($cell I$3)$ to calculate the future value of the loan with Bank $3.$

$43$

$44$

$45$

Create a formula using a function.

In the Mortgage Calculator worksheet, the formula in cell I$10$ should use the FV function to calculate the future value

of the loan with Bank $3.$

$13.$ Miranda plans to orint barts of the Mortaaqe Calculator workbook. Prepare for printing as follows:

Graded Summary Report

Documentation

Mortgage Calculator

Car Loan

Ready Accessibility: Investigate