Required: a) Construct an full amortization schedule for the scenerio below. Details to include pmt #, payment amount, interest portion and principal portion. b) Determine how much interest was paid over the term of the loan. Details: Kirkland Corporation obtained a $125,000 loan for a new business venture. The loan contract requires payments at the end of each quarter including interest at 3% compounded semi-annually. The loan is to be repaid by equal quarterly payments over a six year term.

Required: a) Construct an full amortization schedule for the scenerio below. Details to include pmt #, payment amount, interest portion and principal portion. b) Determine how much interest was paid over the term of the loan. Details: Kirkland Corporation obtained a $125,000 loan for a new business venture. The loan contract requires payments at the end of each quarter including interest at 3% compounded semi-annually. The loan is to be repaid by equal quarterly payments over a six year term.

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

onsider the following loan. Complete parts (a)-(c) below. n individual borrowed $65,000 at an APR of 5%, which will be paid off with monthly payments of $442 for 19 years. ... a. Identify the amount borrowed, the annual interest rate, the number of payments per year, the loan term, and the payment amount. The amount borrowed is $ 65000, the annual interest rate is 5%, the number of payments per year is 12, the loan term is 19 years, and the payment amount is $ 442. b. How many total payments does the loan require? What is the total amount paid over the full term of the loan? There are 228 payments toward the loan and the total amount paid is $ 100776 c. Of the total amount paid, what percentage is paid toward the principal and what percentage is paid for interest? The percentage paid toward the principal is% and the percentage paid for interest is%. (Round to the nearest tenth as needed.)
The payment necessary to amortize a 4.9% loan of $86,000 compounded annually, with 4 annual payments is $24,196.70. The total of the payments is $96,786.80 with a total interest payment of $10,786.80. The borrower made larger payments of $25,000.00. Calculate (a) the time needed to pay off the loan, (b) the total amount of the payments, and (c) the amount of interest saved. a. The time needed to pay off the loan with payments of $25,000.00 is _____ years. (Round up to the nearest year.) b. The total amount of the payments is $______ (Round to the nearest cent as needed.) c. The amount of interest saved is $______. (Round to the nearest cent as needed.)
The payment necessary to amortize a 4.5% loan of $81,000 compounded annually, with 5 annual payments is $18,451.12. The total of the payments is $92,255.60 with a total interest payment of $11,255.60. The borrower made larger payments of $19,000.00. Calculate (a) the time needed to pay off the loan, (b) the total amount of the payments, and (c) the amount of interest saved. Thank you~
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…
The following is an amortization schedule for a loan of $5000 to be repaid over two years at 7% compounded semiannually (depicted below in the table). Find the value of A, B, C, and D.
Locust Inc. owes $20,000.00 to be repaid by monthly payments of $510.00. Interest is 6% compounded monthly. (a) How many payments will Locust Inc. have to make? (b) How much interest is included in the 10th payment? (c) How much of the principal will be repaid in the 9th payment period? (d) Construct a partial amortization schedule showing details of the first three payments, the last three payments, and totals.
Complete the first three lines of an amortization schedule for the following loan. Assume monthly payments. amount, $6000; rate, 9%; time, eighteen months Fill out the amortization schedule below, assume monthly payments and round all values to the nearest cent. Payment Amount of Interest Applied to Number Payment Payment Principal 2 3 $ $ $ Balance $6000 $ $
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.
Determine the annual payment on a OMR 500,000 and 12 percent business loan from a commercial bank that is to be amortized over a five year period.
H

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