Try$-$it $1$

In this try$-$it$,$ you'll edit cells that will affect the monthly repayment amount.

Resources

You'll need the following resources for this try$-$it:

Open L$2\_$T$1\_$try$1\_$tractor$\_$price$\_$starter.xlsx in this lesson's Learning Activity Resources.

Instructions

The following are the general tasks that you must perform during this try$-$it:

$79.$ Examine the formula in cell B$5.$

$80.$ Edit the annual interest rate to $7\%$ and note the monthly repayment result in cell G$3.$

$81.$ Edit the annual interest rate to $6\%$ and note the monthly repayment result in cell G$4.$

$82.$ Edit the annual interest rate to $5\%$ and edit the loan period to $8$ years.

$83.$ Note the monthly repayment result in cell G$5.$

$84.$ Save the file as the same filename plus your initials.