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.

Fundamentals of Financial Management (MindTap Course List)

15th Edition

ISBN:9781337395250

Author:Eugene F. Brigham, Joel F. Houston

Publisher:Eugene F. Brigham, Joel F. Houston

Chapter12: Cash Flow Estimation And Risk Analysis

Section: Chapter Questions

Problem 5P: EQUIVALENT ANNUAL ANNUITY Faleye Consulting is deciding which of two computer systems to purchase....

See similar textbooks

Similar questions

Mf3. : An entity took UAH 100,000 loan for 5 at 26% of annual interest rate. Interests are paid annually. A bank is using annuity due scheme. Interest revenue for a bank in period 1 is: An entity took UAH 100,000 loan for 5 at 26% of annual interest rate. Interests are paid annually. A bank is using annuity due scheme. Principal, paid in the fourth period, is: Outstanding loan amount is USD 17,000.00. Annuity is USD 4,315.27, interest rate is 18%. The amount of principal, paid in the given period is: Outstanding loan amount is USD 22,000.00. Annual interest rate is 11%. Interest is paid at the end of each year. In the given period bank received USD 4,300.00 of principal payment. The annuity amount is:
H3. The interest rate on a $6400 loan is 7% compounded semi-annually, and the loan is to be repaid by monthly payments of $155. Construct a partial amortization schedule showing the last 2 payments. Determine the total amount paid to settle the loan. Show work, not just the answer. Determine the total principal repaid. Determine the total amount of interest paid. Show work, not just the answer.
1. Mark applied for a business loan of Php 100,000 to be amortized by equal payments at 4 years at 10% compounded monthly. How much is the amount of amortization? III. Construct the amortization table for test II.
1. Construct a partial amortization schedule showing the last 2 payments. PMT Setting N I/Y P/Y C/Y PV PMT FV Payment NumberPaymentInterest PaidPrincipal RepaidOutstanding Principal 2. Determine the total amount paid to settle the loan. Show work, not just the answer. 3. Determine the total principal repaid. 4. Determine the total amount of interest paid. Show work, not just the answer.
the payment necessary to amortize a 4.8% loan of $81000 compounded annually with 7 annual payments is $13897. The total of the payments is $97279.77 with a total interest payment of $16279.77. The borrower made larger payments of $14000.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. Question content area bottom Part 1 a. The time needed to pay off the loan with payments of $14,000.00 is (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.)
2.A certain loan was to be amortized based on the schedule below at 15% interest. What is the equivalent annual uniform payment of the loan? End of Year Payment 1 P 7,000 2 P 6,500 3 P 6.000 4 P 5,500 5 P 5.000 6 P 4,500 7 P 4,000 a. P 5365.80 b. P 5333.00 c. P 6475.12 d. P 5775.08 PLEASE SHOW YOUR SOLUTIONS. THANK YOU!
Correctly solve thisf Q)A debt of $13,700 with interest at 5% compounded semi-annually is repaid by payments of $1,950 made at the end of every 3 months. Construct an amortization schedule showing the total paid and the total cost of the debt.
f2. Subject :- Accounting Consider a $25,000, three-year loan at an interest rate of 5%, payments to be made monthly. What is the monthly payment using add-on interest?
4 Loan Amortization Table Prepare a Loan Amortization Table with a 30-year loan term, 3.5% interest rate, loan fee of 1.75%, $12,000,000 loan amount. Calculate the monthly loan payment, loan proceeds and the loan balance at the end of year 10.
IA - Receivable Financing 10. Problem Solving. A company pledged its entire accounts receivable amounting to P2,500,000 to a financing institution to a loan approved for P2,000,000. The term of the loan requires the company to pay the principal when it becomes mature 4 years from now and also to pay 12% annual interest every end of the year. Should the company has made no collateral for the loan, interest rate could have been 18%. Assuming the transaction occurred on January 1, 20A, compute the total amount of expense that should be deducted from the current year’s income of the company. Round off final answer to the nearest peso.
2. If a borrower repays RM 11430 at the end of two years, which includes RM 2430 interest at a rate of 13.5%, what was the principal of the loan. No use excel. Use S=P( 1+ rt ) formula.
que 3 You have been appointed as a financial consultant by the directors of Cochin Holdings. They require you to calculate the cost of capital of the company. The following information is available on the financing of the company: · R10 000 000, financial lease due in 5 years and the current yield-to-maturity is 10%. Prepare a loan amortization schedule Hint: the annuity factor is 3.7908