Title

$8.$ In the list of interest rates $($range A$12$:A$24),$ create a Conditional Formatting...

Description

$8.$ In the list of interest rates $($range A$12$:A$24),$ create a Conditional Formatting Highlight Cells Rule to highlight the listed rate that matches the rate for the Beecher Street house $($cell D$3)$ in Light Red Fill with Dark Red Text. $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 borders in the worksheet. $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.11.$ With the second bank, Miranda and Ricardo could reduce their monthly payments to $$1,500$ but pay a higher annual interest 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 H$3,$ insert a formula using the PV function and the monthly inte 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.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 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.13.$ Miranda plans to print parts of the Mortgage Calculator workbook. Prepare for printing as follows: a$.$ Set row $2$ as the print titles for the worksheet. b$.$ Set the range F$2$:I$13$ as the print area. $14.$ Hide the Listings worksheet, which contains data Miranda wants to keep private. $15.$ Go to the Car Loan worksheet, which contains details about a loan Miranda and Ricardo took out for a new car. The worksheet contains two errors. Make sure Excel is set to check all types of errors, and then resolve the ones on the Car Loan worksheet as follows: Now House Mortgage Calculator