Loan Payment Calculator
Date	10/1/2021	Rate	4.32%
Property	Beecher Street	Term in Months	360
Price	$ 350,000	Monthly Payment	$1,562.55
Down Payment	$ 35,000	Total Interest
Loan Amount		Total Cost

1. In cell B7 (Loan Amount), calculate the loan amount by entering a formula without using a function that subtracts the Down_Payment from the Price.

1. In cell D6 (Total Interest), enter a formula without using a function that multiples the Monthly_Payment (cell D5) by the Term_in_Months (cell D4), and then subtracts the Loan_Amt (cell B7) from the result to determine the total interest on the mortgage.
2. In cell D7 ( Total Cost), enter a formula without using a function that adds the Price (cell B5) to the Total_Interest (cell D6) to determine the total cost of the house.