Loan Amortization Schedule B Required: a) Construct an full amortization schedule for the scenerio below. Details to 5 include pmt #, payment amount, interest portion and principal portion. 7 b) Determine how much interest was paid over the term of the loan. 8. 9 Details: RBC has provided a $200,000 loan to Capilano Construction Inc. that earns 10 11 interest at a rate of 3.5% compounded monthly. The loan is to be paid back in 12 13 equal payments at the end of each month over a three-year term.

Loan Amortization Schedule B Required: a) Construct an full amortization schedule for the scenerio below. Details to 5 include pmt #, payment amount, interest portion and principal portion. 7 b) Determine how much interest was paid over the term of the loan. 8. 9 Details: RBC has provided a $200,000 loan to Capilano Construction Inc. that earns 10 11 interest at a rate of 3.5% compounded monthly. The loan is to be paid back in 12 13 equal payments at the end of each month over a three-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

An amortized loan: repays both the principal and the interest in one lump sum at the end of the loan term. requires the principal amount to be repaid in even increments over the life of the loan. requires that all payments be equal in amount and include both principal and interest. requires that all interest be repaid on a monthly basis while the principal is repaid at the end of the loan term. may have equal or increasing amounts applied to the principal from each loan payment.
Complete an amortization schedule for the following loan. The loan amount is $100,000 at 3. 5 % interest, amortized on a yearly basis over five (5) years. (I have two calculators. A BA2Plus and a Qualifier Plus IIIfx. Please provide the proper key strokes.) Thank you!
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.)
Chuck’s Publishing, Inc. borrows $30,000 from Citicorp to finance the purchase of a new office cooling system. The loan has an interest rate of 12% and Chuck’s will be required to make annual payments for the next 3 years. Fill in the following loan amortization schedule for this transaction.
An FI purchases a $9.982 million pool of commercial loans at par. The loans have an interest rate of 8 percent, a maturity of five years, and annual payments of principal and interest that will exactly amortize the loan at maturity. What is the duration of this asset? A. 2.122822 years. B. 3.072837 years. C. 3.528992 years. D. 2.846472 years. E. 5.000000 years.
1.18q Determine the payment to amortize the debt. (Round your answer to the nearest cent.) Quarterly payments on $17,500 at 3.9% for 6 years.
A lender lends $10000 which is to be repaid in annual payments of $2100 for 6 years. Which of the following shows the timeline of the loan from the lenders perspective?
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…
Givens, Hong, and Partners obtained a $8,100 term loan at 9.6% compounded annually for new boardroom furniture. Prepare a complete amortization schedule in which the loan is repaid by equal semiannual payments over three years. (Round your answers to the nearest cent. Do not round the intermediate calculations.) Payment Interest number Payment $ portion $ 0 DLN3 456 1 2 1624.80 1624.80 1624.80 1624.80 1624.80 1624.80 Principal portion $ Principal balance $ 8,100.00
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…
prepare an amortization schedule showing the first four payments for each loan. Large semitrailer trucks cost $110,000 each. Ace Trucking buys such a truck and agrees to pay for it by a loan that will be amortized with 9 semiannual payments at 8% compounded semiannually.

SEE MORE QUESTIONS

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