files from the Internet can contain viruses. Unless you need to edit, it's safer to stay in Protected View.

shelly Cashman Excel $2$UIY I Moavie $4$: SAM rroject la

$4.$ Liam needs to calculate the monthly payment for a loan to purchase the Charles Street property. Calculate the payment as follows:

a$.$ In cell D$6,$ start to enter a formula using the PMT function.

b$.$ For the rate argument, divide the Rate by $12$ to use the monthly interest rate.

c$.$ For the nper argument, use the Term$\_$in$\_$Months to specify the number of periods.

d$.$ For the pv argument, use the Loan$\_$Amount to include the present value.

e$.$ Insert a negative sign $(-)$ after the equal sign in the formula to display the result as a positive amount.

$5.$ In cell D$7,$ enter a formula without using a function that multiples the Monthly$\_$Payment by the Term$\_$in$\_$Months and then subtracts the Loan$\_$Amount from the result to determine the total interest.

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

$7.$ Liam wants to compare monthly payments for interest rates that vary from $3\mathrm{.}95\%$ to $5\mathrm{.}15\%$ and for terms of $120,180,$ and $240$ months. He has already set up the structure for a data table in the range A$12$:D$25.$

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

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

b$.$ Based on the range A$12$:D$25,$ create a two$-$variable data table that uses the term in months $($cell D$5)$ as the row invut cell and the rate $($cell D$4)$ as the column inout

${?}^2,$ Focus