Question

In: Finance

Assume you have taken out a partially amortizing loan for $1,250,000 that has a term of...

Assume you have taken out a partially amortizing loan for $1,250,000 that has a term of 7 years but amortizes over 20 years. Calculate the balloon payment if the interest rate on this loan is 7.25%.

Solutions

Expert Solution

Yearly payment = [P × R × (1+R)^N ] / [(1+R)^N -1]
Using the formula:
Loan amount P $                                                       1,250,000
Rate of interest per period:
Annual rate of interest 7.2500000%
Frequency of payment = Once in 12 month period
Numer of payments in a year = 12/12 = 1
Rate of interest per period R 0.0725 /1 = 7.2500%
Total number of payments:
Frequency of payment = Once in 12 month period
Number of years of loan repayment =                                                                  20.00
Total number of payments N 20 × 1 = 20
Period payment using the formula = [ 1250000 × 0.0725 × (1+0.0725)^20] / [(1+0.0725 ^20 -1]
Yearly payment = $                                                    120,293.55
Loan balance = PV * (1+r)^n - P[(1+r)^n-1]/r
Loan amount PV = 1,250,000.00
Rate of interest r= 7.2500%
nth payment n= 7
Payment P= 120,293.55
Loan balance = 1250000*(1+0.0725)^7 - 120293.55*[(1+0.0725)^7-1]/0.0725
Loan balance =                                                                         991,278.35

Answer is:

991,278.35

Please rate.


Related Solutions

Suppose you have taken out a $175,000 fully amortizing fixed rate mortgage loan that has a...
Suppose you have taken out a $175,000 fully amortizing fixed rate mortgage loan that has a term of 15 years and an interest rate of 5.25%. After your first mortgage payment, how much of the original loan balance is remaining? Can you teach me how to do it on excel, please? I am confused on how to make it monthly compounding.
You have just taken out an amortized loan for $404,000. Assume that the loan will be...
You have just taken out an amortized loan for $404,000. Assume that the loan will be paid in 24 equal monthly installments of ​$18,345.62​ and that the first payment will be due 1 month from today. How much of your third monthly payment will go toward the repayment of​ principal? Fill in the worksheet below.   Month Interest Owing at End of Month​ ($) Principal Repayment​ ($) Principal Owing at End of Month​ ($) 1 2 3
Suppose you have taken out a $125,000 fully-amortizing fixed rate mortgage loan that has a term of 15 years and an interest rate of 6%.
Show work through excel formulas: please actually show how you do it   on excel exactly! 1. Suppose you have taken out a $125,000 fully-amortizing fixed rate mortgage loan that has a term of 15 years and an interest rate of 6%. After your first mortgage payment, how much of the original loan balance is remaining? 
 A. $1,054.82 B. $120,603.78 C. $124,570.18 D. $124,875.56 2. Assume you have taken out a partially amortizing loan for $325,000 that has a term of...
You have just purchased a car and taken out a $46000 loan. The loan has a​...
You have just purchased a car and taken out a $46000 loan. The loan has a​ five-year term with monthly payments and an APR of 6.5 % a. How much will you pay in​ interest, and how much will you pay in​ principal, during the first​ month, second​ month, and first​ year? (Hint: Compute the loan balance after one​ month, two​ months, and one​ year.) b. How much will you pay in​ interest, and how much will you pay in​...
You have just purchased a car and taken out a $50,000 loan. The loan has a...
You have just purchased a car and taken out a $50,000 loan. The loan has a 5-year term with monthly payments and an APR of 6%. How much will you pay in interest, and how much will you pay in principle, during the first month and second month? (Hint: construct an amortization table to show the breakdown of interest and principal paid in the first two months).
You have just purchased a car and taken out a $40,000 loan. The loan has a?...
You have just purchased a car and taken out a $40,000 loan. The loan has a? five-year term with monthly payments and an APR of 6.3 % a. How much will you pay in? interest, and how much will you pay in? principal, during the first? month, second? month, and first? year? (Hint: Compute the loan balance after one? month, two? months, and one? year.) b. How much will you pay in? interest, and how much will you pay in?...
You have just purchased a car and taken out a $41,000 loan. The loan has a​...
You have just purchased a car and taken out a $41,000 loan. The loan has a​ five-year term with monthly payments and an APR of 6.1%. a. How much will you pay in​ interest, and how much will you pay in​ principal, during the first​ month, second​ month, and first​ year? (Hint: Compute the loan balance after one​ month, two​ months, and one​ year.) b. How much will you pay in​ interest, and how much will you pay in​ principal,...
You have just purchased a car and taken out a $39,000 loan. The loan has a​...
You have just purchased a car and taken out a $39,000 loan. The loan has a​ five-year term with monthly payments and an APR of 5.5% . a. How much will you pay in​ interest, and how much will you pay in​ principal, during the first​ month, second​ month, and first​ year? (Hint: Compute the loan balance after one​ month, two​ months, and one​ year.) b. How much will you pay in​ interest, and how much will you pay in​...
You have just purchased a car and taken out a $37,000 loan. The loan has a​...
You have just purchased a car and taken out a $37,000 loan. The loan has a​ five-year term with monthly payments and an APR of 6.1%. a. How much will you pay in​ interest, and how much will you pay in​ principal, during the first​ month, second​ month, and first​ year? (Hint: Compute the loan balance after one​ month, two​ months, and one​ year.) b. How much will you pay in​ interest, and how much will you pay in​ principal,...
You have just purchased a car and taken out a $35,000 loan. The loan has a​...
You have just purchased a car and taken out a $35,000 loan. The loan has a​ five-year term with monthly payments and an APR of 5.7%. a. How much will you pay in​ interest, and how much will you pay in​ principal, during the first​ month, second​ month, and first​ year? (Hint: Compute the loan balance after one​ month, two​ months, and one​ year.) b. How much will you pay in​ interest, and how much will you pay in​ principal,...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT