Option D
Loan Principal=1312604.856
Number of months=12*30=360
Annual rate compounded monthly=((1+8%)^(1/12)-1)*12=7.721%
Monthly payment=9377.22
Loan Amortization Schedule
Payment | Loan beginning balance | Payment | Interest payment | Principal payment | Loan ending balance |
1 | 1312604.856 | $9,377.22 | $8,445.34 | $931.88 | $13,11,672.97 |
2 | $13,11,672.97 | $9,377.22 | $8,439.34 | $937.88 | $13,10,735.09 |
3 | $13,10,735.09 | $9,377.22 | $8,433.31 | $943.91 | $13,09,791.18 |
4 | $13,09,791.18 | $9,377.22 | $8,427.24 | $949.99 | $13,08,841.19 |
5 | $13,08,841.19 | $9,377.22 | $8,421.12 | $956.10 | $13,07,885.09 |
6 | $13,07,885.09 | $9,377.22 | $8,414.97 | $962.25 | $13,06,922.84 |
7 | $13,06,922.84 | $9,377.22 | $8,408.78 | $968.44 | $13,05,954.40 |
8 | $13,05,954.40 | $9,377.22 | $8,402.55 | $974.67 | $13,04,979.73 |
9 | $13,04,979.73 | $9,377.22 | $8,396.28 | $980.94 | $13,03,998.79 |
10 | $13,03,998.79 | $9,377.22 | $8,389.97 | $987.26 | $13,03,011.53 |
11 | $13,03,011.53 | $9,377.22 | $8,383.62 | $993.61 | $13,02,017.92 |
12 | $13,02,017.92 | $9,377.22 | $8,377.22 | $1,000.00 | $13,01,017.92 |
A loan is being amortized by means of level monthly payments at an annual effective interest...
An amortized loan is repaid with annual payments which start at $550 at the end of the first year and increase by $ 50 each year until a payment of $ 2,000 is made, after which they cease. If interest rate is 4% effective, find the amount of principal in the tenth payment. would prefer to understand the financial mathematics behind obtaining the solution, not using excel spreadsheet or financial calculator online
Explain without excel (3) An amortized loan is repaid with annual payments which start at $400 at the end of the first year and increase by $45 each year until a payment of $1,480 is made, after which they cease. If interest is 4% effective, find the amount of principal in the fourteenth payment.
Suppose that a loan is being repaid with 60 equal monthly payments, the first coming a month after the loan is made. If the rate of interest is 7.5 percent convertible monthly, and the amount of principal in the 22nd payment is 210, how much interest is in the 44th payment?
A loan of 100,000 is to be repaid in 4 level annual payments starting one year after the loan date. For the first 2 years, the annual interest rate is 8%; for the last 2 years, the annual interest rate is 4%. Find the annual payment and complete the loan amortization table. t Payment Interest Due Principal Repaid Outstanding Balance 0 100,000 1 2 3 4
Lori has a loan of 80,000 to be paid in 20 level annual payments. The interest and the principal repayment in the 13th payment are equal. Find the amount of principal repaid in the 6th payment.
** USE FORMULA TO SOLVE THIS PROBLEM (NO EXCEL PLEASE!!!) (3) An amortized loan is repaid with annual payments which start at $400 at the end of the first year and increase by $45 each year until a payment of $1,480 is made, after which they cease. If interest is 4% effective, find the amount of principal in the fourteenth payment
The following loan is a simple interest amortized loan with monthly payments. The following loan is a simple interest amortized loan with monthly payments. $289,000, 102%, 35 years (a) Find the monthly payment. (Give your answer to the nearest cent.) Payment $ (b) Find the total interest for the given simple interest amortized loan. (Give your answer to the nearest cent.) Total interest $
3. A $300,000 home loan is amortized by equal monthly payments for 25 years, starting one month from the time of the loan at a nominal rate of 7% convertible monthly. a. Find the monthly payment amount. b. Find the outstanding balance when 10 years of payments remain. c. Find the total interest paid during the last 10 years of the loan? 4. Eddie is repaying a 20-year loan of 10,000 with payments at the end of each year. Each...
A loan of $2000 is being repaid by equal monthly payments for an unspecified length of time. Interest on the loan is j2 = 15%. (Do not round intermediate calculations. Round your answers to 2 decimal places.) a) If the amount of principal in the 4th payment is $40, what amount of the 18th payment will be principal? b) Determine the regular monthly payment.
A loan is repaid with annual year-end payments of 15,000. The effective rate of interest is 3%. How much interest is paid in the final payment? Note: you are not given the original amount of the loan nor are you given the number of payments. This problem, however, can be solved.