You are considering the purchase of a refrigerator and need to take out a loan in order to do so. The refrigerator sells for $1,250.99. Your one-year loan is at 12.5% interest and you will make monthly payments. You will use functions to prepare a payment schedule for the refrigerator.

Extend the payment numbers in column A for the length of the loan, by month.

Enter the functions needed to complete the worksheet. Be sure to show positive numbers.

In row 22, provide totals for columns C, D, and E.

Format the total row for bold with a double underline beneath the columns containing money. Place a label in column A.

Format column labels for bold and center them both horizontally and vertically.

Format the number of each payment in column A for center alignment.

Place the worksheet centered horizontally on the page with a 2" top margin. Print gridlines. In the header place your name and the date; in the footer place the sheet name and the file name.

Save the worksheet as Loan Payment Schedule.xlsx.

SHOW ALL FORMULAS