Question

Prepare the first row of a loan amortization schedule based on the following information. The loan...

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?

0 0
Add a comment Improve this question Transcribed image text
Answer #1
Note 1 i=interest rate per month=11/12=0.92%
n=time in months= 28*12=336
Note2 Monthly installment= Loan Amount
Pvaf(i,n)
= 31060
Pvaf(0.92,336)
= 31060
103.69
=                299.55
Note3 Loan amortisation table
Terms Opening Balance Interest installment paid Principal closing balance
1             31,060.00          285.75                  299.55                  13.80            31,046.20

a. Loan payment i.e. installment paid is $299.55

b.Interest portion is $ 285.75

c. Principal portion $13.80

d. Loan balance after 1st installment is $31046.2

Add a comment
Know the answer?
Add Answer to:
Prepare the first row of a loan amortization schedule based on the following information. The loan...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • DeTuW DeIUW 2 PUMIS CACI AISwer 10 PUMIS TUldl) Q1) Prepare the first row of a...

    DeTuW DeIUW 2 PUMIS CACI AISwer 10 PUMIS TUldl) Q1) Prepare the first row of a loan amortization schedule based on the following information. The loan amount is for $46,859 with an annual interest rate of 07.00%. The loan will be repaid over 27 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?

  • Loan amortization schedule Personal Finance Problem Joan Messineo borrowed $46,000 at a 4% annual rate of...

    Loan amortization schedule Personal Finance Problem Joan Messineo borrowed $46,000 at a 4% annual rate of interest to be repaid over 3 years. The loan is amortized into three equal, annual end-of-year payments Calculate the annual end of year loan payment b. Prepare a loan amortization schedule showing the interest and principal breakdown of each of the three loan payments. c. Explain why the interest portion of each payment declines with the passage of time. a. The amount of the...

  • Loan amortization schedule  Personal Finance Problem   Joan Messineo borrowed ​$49 comma 00049,000 at a 66​% annual...

    Loan amortization schedule  Personal Finance Problem   Joan Messineo borrowed ​$49 comma 00049,000 at a 66​% annual rate of interest to be repaid over 3 years. The loan is amortized into three​ equal, annual,​ end-of-year payments. a.  Calculate the​ annual, end-of-year loan payment. b.  Prepare a loan amortization schedule showing the interest and principal breakdown of each of the three loan payments. c. Explain why the interest portion of each payment declines with the passage of time. a.  The amount of...

  • (Round to the nearest cent) Loan amortization schedule Personal Finance Problem Joan Messineo borrowed $46,000 at...

    (Round to the nearest cent) Loan amortization schedule Personal Finance Problem Joan Messineo borrowed $46,000 at a 4% annual rate of interest to be repaid over 3 years. The loan is amortized into three equal, annual, end-of-year payments. a. Calculate the annual, end-of-year loan payment. b. Prepare a loan amortization schedule showing the interest and principal breakdown of each of the three loan payments. c. Explain why the interest portion of each payment declines with the passage of time.

  • 8. Prepare the loan amortization schedule ($15) You borrow $1,000, and the loan is to be...

    8. Prepare the loan amortization schedule ($15) You borrow $1,000, and the loan is to be repaid in three equal payments at the end of each of the next three years. The lender charges a 6 percent interest rate on the loan balance that is outstanding at the beginning of each year. 1) Calculate the payment the firm must repay each year. 2) Prepare the loan amortization schedule (fill all the numbers in each cell). Beginning Amount Repayment of Remaining...

  • Loan Amortization Schedule You purchase a fully loaded Honda Accord with an MSRP of $32,000 for...

    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. Compute the loan value and monthly loan payments. (10 pts) Create a monthly amortization schedule over the entire loan period. (10...

  • Mortgage Amortization Complete the loan amortization schedule for a Mortgage that will be repaid over 360...

    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...

  • 8. Prepare the loan amortization schedule ($15) You borrow $1,000, and the loan is to be repaid in three equal paym...

    8. Prepare the loan amortization schedule ($15) You borrow $1,000, and the loan is to be repaid in three equal payments at the end of each of the next three years. The lender charges a 6 percent interest rate on the loan balance that is outstanding at the beginning of each year. 1) Calculate the payment the firm must repay each year. 2) Prepare the loan amortization schedule (fill all the numbers in each cell). Repayment of Remaining Principal Beginning...

  • 8. Prepare the loan amortization schedule ($15) You borrow $1,000, and the loan is to be repaid in three equal paym...

    8. Prepare the loan amortization schedule ($15) You borrow $1,000, and the loan is to be repaid in three equal payments at the end of each of the next three years. The lender charges a 6 percent interest rate on the loan balance that is outstanding at the beginning of each year. 1) Calculate the payment the firm must repay each year. 2) Prepare the loan amortization schedule (fill all the numbers in each cell). Beginning Amount Repayment of Principal...

  • AMORTIZATION SCHEDULE a. Complete an amortization schedule for a $34,000 loan to be repaid in equal...

    AMORTIZATION SCHEDULE a. Complete an amortization schedule for a $34,000 loan to be repaid in equal installments at the end of each of the next three years. The interest rate is 10% compounded annually. Round all answers to the nearest cent. Beginning Repayment Ending Interest ofPrincipal Balance Balance avment Interest Payment b. What percentage of the payment represents interest and what percentage represents principal for each of the three years? Round all answers to two decimal places. 96 Interest %...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT