Question
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.
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
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started