Adjusting for annual periods

This exercise continues from the prior exercise, but will need to be adjusted to replace the interest rate with annual interest rate and the periods with years. Changing these values makes it easier to compare loans against each other, but formulas will need to be changed to accurately reflect the prorated terms.

The loan is a $500,000 principal at 6% annual interest rate for 5 years, paid monthly.