Calculate the balloon payment after 5 years on a $100,000 loan with an 10% interest rate,...

Calculate the balloon payment after 5 years on a $100,000 loan with an 10% interest rate, a 20-year amortization and monthly payments of $965.02

Solutions

Expert Solution

Calculate the balloon payment using excel function

=FV(rate,nper,pmt,pv)

=FV(10%/12,5*12,965.02,-100000)

=89802.57

the above is answer

jeff jeffy answered 1 year ago

Next > < Previous

Related Solutions

Develop the payment table for a balloon payment loan $125,000 loan, 10 years, 10% interest rate,...

Develop the payment table for a balloon payment loan $125,000 loan, 10 years, 10% interest rate, balloon payment of $100,000 Year Total Payment Interest Paid Principal Paid Principal Remaining Balloon

Calculate the loan balance after 6 years of payment of the following Balloon Payment Mortgage: 1...

Calculate the loan balance after 6 years of payment of the following Balloon Payment Mortgage: 1 million dollar loan Rate =5% annualized, monthly compounding Loan term = 25 years Amortization = balloon at the end of loan term of $300,000

$100,000 Amortizing Loan 9% stated rate 20-year amortization 5-year balloon Annual Payments a) Calculate annual payment...

$100,000 Amortizing Loan 9% stated rate 20-year amortization 5-year balloon Annual Payments a) Calculate annual payment b) Calculate balloon payment c) Value at 12% yield d) Prepare an amortization table

A fixed-rate constant-payment partially-amortizing mortgage is made for $100,000 at 5% for 30 years. The balloon...

A fixed-rate constant-payment partially-amortizing mortgage is made for $100,000 at 5% for 30 years. The balloon payment will be $50,000 at the end of year 30. Calculate the monthly payment. What will the total of payments be for entire 30 years? Of the total, how much will be interest? What would be the outstanding balance after 5 years?

A 10-year amortized loan of $100,000 with 5% APR requires yearly loan payment. After making four...

A 10-year amortized loan of $100,000 with 5% APR requires yearly loan payment. After making four yearly payments, the fourth year's ending loan balance is $Answer (don't include thousand separator( , ), rounding the number with two decimal places)

A borrower is offered a mortgage loan for $100,000 with an interest rate of 10% and...

A borrower is offered a mortgage loan for $100,000 with an interest rate of 10% and a 30-year amortization period with monthly payments. The origination fee is 1% of the loan and the lender charges two discount points. What is the effective interest rate? 10%, 9%, 10.37%, or 10.24%?

Calculate the future value of $6,000 in a. 5 years at an interest rate of 10%...

Calculate the future value of $6,000 in a. 5 years at an interest rate of 10% per year (round to the nearest dollar) b. 10 years at an interest rate of 10% per year (round to the nearest dollar) c. 5 years at an interest rate of 20% per year (round to the nearest dollar) d. Why is the amount of interest earned in part (a) less than half the amount of interest earned in part (b)? (choose from the...

What is the annual payment on a $10,000 loan, 7% interest for 5 years?

calculate a loan amortization schedule for a $10,000 loan, 5% annual interest, one payment a year...

calculate a loan amortization schedule for a $10,000 loan, 5% annual interest, one payment a year for 10 years, starting on 1/1/2010. All calculations must be shown, i.e., do not use a “package” to complete this question. Loan period starts from 1/1/2010. I mean the first payment is to be made on 1/1/2010.

The maturity of the balloon loan is 5 years, amortization period is 30 years, loan amount...

The maturity of the balloon loan is 5 years, amortization period is 30 years, loan amount is $85,000 with annual interest rate 4.5% and monthly payments. What is the monthly payment for this balloon mortgage? What is the balloon payment at the end of five years for this balloon mortgage?

Subjects