Dejardines Financial has provided a $53, 217 loan to Your Finished Inc. that earns interest at a rate of 6.5% compounded monthly. The loan is to be paid back in equal payments at the end of each month over a three-year term. In addition to the amortization schedule, how much interest was paid over the life of the loan? Complete the amortization table for the 3 years of the loan.

Dejardines Financial has provided a $53, 217 loan to Your Finished Inc. that earns interest at a rate of 6.5% compounded monthly. The loan is to be paid back in equal payments at the end of each month over a three-year term. In addition to the amortization schedule, how much interest was paid over the life of the loan? Complete the amortization table for the 3 years of the loan.

Essentials Of Investments

11th Edition

ISBN:9781260013924

Author:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Publisher:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Chapter1: Investments: Background And Issues

Section: Chapter Questions

Problem 1PS

See similar textbooks

Similar questions

Find the monthly payment on the loan. Assume that the term of the loan is 10 years. 57,500 at 7.9% interest; student graduates 2 years and 8 months after loan is acquired; payments deferred for 6 months after graduation. The monthly payment on this loan is S decimal places, if necessary. Round your answer to two
To pay for remodeling, the company will take out a $500,000 five-year loan at 9.5% interest, compounded quarterly. The terms of the loan have been entered in the Loan Analysis worksheet. In cell B8, calculate the quarterly payment on the loan based on the loan conditions already entered. Complete the amortization schedule in cells B11 through E30. Column B contains the interest payment for each quarter, and column C contains the principal payment. Column D contains the remaining principal at the start of each month. The initial principal remaining is $500,000. The subsequent remaining principal values are reduced by the principal payment made in the previous quarter. Calculate the ending balance in cell D31. Use the IPMT function in cell B11 to calculate the interest amount paid per period. Copy this formula to cell B30. Use the PPMT function in cell C11 to calculate the principal amount paid per period. Copy this formula to cell C30. Write a formula in cell D11 to indicate the…
To pay for remodeling, the company will take out a $500,000 five-year loan at 9.5% interest, compounded quarterly. The terms of the loan have been entered in the Loan Analysis worksheet. In cell B8, calculate the quarterly payment on the loan based on the loan conditions already entered. Complete the amortization schedule in cells B11 through E30. Column B contains the interest payment for each quarter, and column C contains the principal payment. Column D contains the remaining principal at the start of each month. The initial principal remaining is $500,000. The subsequent remaining principal values are reduced by the principal payment made in the previous quarter. Calculate the ending balance in cell D31. Use the IPMT function in cell B11 to calculate the interest amount paid per period. Copy this formula to cell B30. Use the PPMT function in cell C11 to calculate the principal amount paid per period. Copy this formula to cell C30. Write a formula in cell D11 to indicate the…
Create an amortization table for a $60,000 loan. We will assume payments are made monthly over 6 years at an interest rate of 4%. a.) First use a formula cell in your spreadsheet to calculate the monthly payment amount. b.) Create an amortization table for the 72 months. Your columns of your amortization table should include payment number, payment amount, interest paid each month, principle paid that month, amount paid on principal total, and the amount of principal remaining.
Determine A) Determine the monthly interest rate i charged by Coco-me-Loan B) How much is the principal repaid during the 4th month? C) What is the principal loan balance after 7th monthly amortization payment?
Create the amortization schedule for a loan of $5,600, paid monthly over two years using an APR of 8 percent. Enter the data for the first three months. Note: Round your answers to 2 decimal places. Month 1 2 3 Beginning Balance Total Payment Interest Paid Principal Paid Ending Balance
Alan borrows $100,000 at nominal interest rate 9% per annum which matures in 5years. Repayments are made monthly such that each monthly payment in the last 2years is twice that in the first 3 years.a) Calculate the monthly payments for this loan.b) Construct the amortization table for this loan which includes the following columnsInstallment, Interest payment, Principal payment, Outstanding balance.c) After 3 years, the market nominal interest rate falls to 6% per annum. Alan wantsto terminate the loan. The bank charges the termination fee which is 40% of thedifference in total remaining interest payment. Calculate the amount Alan needsto pay the bank (including outstanding balance and termination fee).d) Alan borrows the amount in part c) at 6% per annum. If he keeps to the currentmonthly payment, how long will he pay off everything ?e) What is Alan’s monthly payment if he decides to keep to his schedule of payingoff the debt in the next 2 years ?f) Suppose Alan follows the payment…
SportZ has negotiated a loan of $25 000 with interest at 7.6% per annum, to be paid as month-end payments of $2200.00 over the next year. Construct a loan amortization schedule to answer the following questions. i. How much interest is paid over the first two months? ii. How much of the principal is paid by the end of the first two months? iti. How much interest is paid over the term of the loan? iv. What is the amount of the final payment?]
A $23,970 loan is to be settled by making payments of $6,999 at the end of every six months. The interest is 7.58% compounded monthly. a) Find the number of payments in the term. N = b) Fill in the missing values of the amortization schedule below. Round off your answers to two decimal places. Enter a positive value for all answers. Payment Number 0 1 2 3 4 Payment Amount ($) PMT FA A A A Interest Portion ($) INT FA A $ Principal Portion ($) PRN $ A $ Loan Balance ($) BAL A A $23,970
You have a new 10 year Student loan for $16,500.00 that charges an interest rate of 5.35% compounded monthly. The Amortization Table below shows your activity for the first month's payment. Fill in The Interest Payment, Principle Payment, and New Balance after you make the second Payment in Month 2 Payment Payment Interest Payment Principle Payment New Balance amount $16,500.00 ---- $177.84 $73.56 $104.28 $16,395.72 $177.84 > Next Question
Complete the following from the first three lines of an amortization schedule for the following loan:You borrow $ 150000 with an annual interest rate of 8.75% over 15 years Starting principal = $ 150000New balance after month 1 payment = New balance after month 2 payment = New balance after month 3 payment =

Recommended textbooks for you

Essentials Of Investments

Finance

ISBN:

9781260013924

Author:

Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Publisher:

Mcgraw-hill Education,

FUNDAMENTALS OF CORPORATE FINANCE

Finance

ISBN:

9781260013962

Author:

BREALEY

Publisher:

RENT MCG

Financial Management: Theory & Practice

Finance

ISBN:

9781337909730

Author:

Brigham

Publisher:

Cengage

Foundations Of Finance

Finance

ISBN:

9780134897264

Author:

KEOWN, Arthur J., Martin, John D., PETTY, J. William

Publisher:

Pearson,

Fundamentals of Financial Management (MindTap Cou…

Finance

ISBN:

9781337395250

Author:

Eugene F. Brigham, Joel F. Houston

Publisher:

Cengage Learning

Corporate Finance (The Mcgraw-hill/Irwin Series i…

Finance

ISBN:

9780077861759

Author:

Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Jeffrey Jaffe, Bradford D Jordan Professor

Publisher:

McGraw-Hill Education

Essentials Of Investments

Finance

ISBN:

9781260013924

Author:

Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Publisher:

Mcgraw-hill Education,

FUNDAMENTALS OF CORPORATE FINANCE

Finance

ISBN:

9781260013962

Author:

BREALEY

Publisher:

RENT MCG

Financial Management: Theory & Practice

Finance

ISBN:

9781337909730

Author:

Brigham

Publisher:

Cengage

Foundations Of Finance

Finance

ISBN:

9780134897264

Author:

KEOWN, Arthur J., Martin, John D., PETTY, J. William

Publisher:

Pearson,

Fundamentals of Financial Management (MindTap Cou…

Finance

ISBN:

9781337395250

Author:

Eugene F. Brigham, Joel F. Houston

Publisher:

Cengage Learning

Corporate Finance (The Mcgraw-hill/Irwin Series i…

Finance

ISBN:

9780077861759

Author:

Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Jeffrey Jaffe, Bradford D Jordan Professor

Publisher:

McGraw-Hill Education

SEE MORE TEXTBOOKS