Loan Amortization Schedule |
|
You purchase a fully loaded Honda Accord with an MSRP of $32,000 for $27,000. |
|
You pay the 3% tax of $810 up front and put down $5,000. The dealer offers |
|
a simple interest installment loan with an annual rate of 5% for 3 years. The projected resale value of the car after 2 years is $17,000. |
|
Please show all calculations and complete monthly amortization schedule. |
Loan value = purchase price - down payment = $27,000 - $5,000 = $22,000
Monthly loan payment is calculated using PMT function in Excel :
rate = 5% / 12 (converting annual rate into monthly rate)
nper = 3*12 (3 year loan with 12 monthly payments each year)
pv = 22000 (loan amount)
PMT is calculated to be $659.36
Interest in any month = principal outstanding at beginning of month * 5% / 12
Principal portion of monthly payment = monthly payment minus interest portion of payment
principal outstanding at end of month = principal outstanding at beginning of month minus principal portion of monthly payment
Total interest = (monthly payment * total number of months) - loan amount
Total interest = ($659.36 * 3 * 12) - $22,000 = $1,736.95
Total cash outflow = tax + down payment + (monthly payment * total number of months)
Total cash outflow = $810 + $5,000 + ($659.36 * 3 * 12) = $29,546.95
The principal portion of the payment increases as the months progress.
The interest portion of the payment decreases as the months progress.
Loan Amortization Schedule You purchase a fully loaded Honda Accord with an MSRP of $32,000 for...
Amortization schedule with periodic payments. Moulton Motors is advertising the following deal on a used Honda Accord: "Monthly payments of $221.48 for the next 54 months and this beauty can be yours!" The sticker price of the car is $9,400. If you bought the car, what interest rate would you be paying in both APR and EAR terms? What is the amortization schedule of the first six payments?
Please can i get help solve this entire problem? Amortization schedule with periodic payments. Moulton Motors is advertising the following deal on a used Honda Accord: "Monthly payments of $178.29 for the next 60 months and this beauty can be yours!" The sticker price of the car is $8,200. If you bought the car, what interest rate would you be paying in both APR and EAR terms? What is the amortization schedule of the first six payments? If you bought...
10. The MSRP of a new Honda Civic is $21.500. Kate has decided to lease the car over 4 years. She will make a down payment of $3,000, monthly payments of $265 and a residual payout at the end of the lease. Calculate the amount of the residual payment using a rate of j12=3%.
Prepare the first row of a loan amortization schedule based on the following information. The loan amount is for $31,060 with an annual interest rate of 11.00%. The loan will be repaid over 28 years with monthly payments. a) What is the Loan Payment? b) What portion of this payment is Interest? c) What portion of this payment is Principal? d) What is the Loan balance after first monthly payment?
Amortization schedule with periodic payments. Moulton Motors is advertising the following deal on a new Honda Civic: "Monthly payments of $400.40 for the next 60 months and this beauty can be yours!" The sticker price of the car is $18,000. If you bought the car, what interest rate would you be paying in both APR and EAR terms? What is the amortization schedule of the first six payments? If you bought the car, what monthly interest rate would you be...
Question 12 1 pts When looking at a loan amortization schedule for a standard mortgage, car loan, etc., which of the following values increases as time goes on? Monthly payment Principal portion of monthly payment Interest portion of monthly payment Remaining principal balance on loan
b. Fill in the partial amortization schedule for the loan, rounding your answers to two decimal places. Holly received a loan of $36,000 at 3.5% compounded monthly. She had to make payments at the end of every month for a period of 5 years to settle the loan. a. Calculate the size of payments. 0.00 Round to the nearest cent Interest Principal Payment Principal Payment Portion Portion Balance Number $36,000.00 $0.00 $0.00 $0.00 $0.00 1 $0.00 $0.00 $0.00 $0.00 2...
Mortgage Amortization Complete the loan amortization schedule for a Mortgage that will be repaid over 360 months and answer the following questions (The details about the loan are shown below): Correct Answers 1. What is your monthly payment? 2. What is the total $ amount of payments made over the life of the loan Enter Answers Here. 3. How many months will it take to pay off the loan if you pay an extra $465.71 per month? Note: Enter the...
loan amortization schedule question OMAT 230 OS X Microsoft Office Home X B MATH 230 051 Amortization - x + ment/9286 Question 3 (6) Corey received a loan of $26,000 at 4.5% compounded semi-annually. He had to make payments at the end of every half-year for a period of 5 years to settle the loan. AB CLOSE DATE Sun, March 15th 11:59 pm Submit Print a. Calculate the size of payments. Save Progress 0.00 Round to the nearest cent b....
Problem 5-50 Amortization Schedule (LG5-9) Create the amortization schedule for a loan of $5,700, paid monthly over two years using an APR of 10 percent. Enter the data for the first three months. (Round your answers to 2 decimal places.) Beginning Balance Total Payment Interest Paid Principal Paid Ending Balance rences