Question

In: Finance

You borrow $100,000 and make annual payments for 5 years. The interest rate is 8%. How...

You borrow $100,000 and make annual payments for 5 years. The interest rate is 8%. How much interest do you pay in year 2?

PLEASE EXPLAIN STEP BY STEP HOW YOU SOLVE WITH ONLY YOUR FINANCIAL CALCULATOR

Solutions

Expert Solution

First we will calculate the annual payments. Here, the payments will be same every year, so it is an annuity. We will use the present value of annuity formula to calculate annual payments:

PVA = P * (1 - (1 + r)-n / r)

where, PVA = Present value of annuity = $100000, P is the periodical amount, r is the rate of interest = 8% and n is the time period = 5

Now, putting these values in the above formula, we get,

$100000 = P * (1 - (1 + 8%)-5 / 8%)

$100000 = P * (1 - ( 1+ 0.08)-5 / 0.08)

$100000 = P * (1 - ( 1.08)-5 / 0.08)

$100000 = P * (1 - 0.68058319703) / 0.08)

$100000 = P * (0.31941680296 / 0.08)

$100000 = P * 3.99271003708

P = $100000 / 3.99271003708

P = $25045.65

So, annual payments are $25045.65.

Now,

Interest in year 1 = Amount borrowed / Outstanding * rate of interest

Interest in year 1 = $100000 * 8% = $8000

Principal repayment in year 1 = Annual payment - Interest in year 1

Principal repayment in year 1 = $25045.65 - $8000 = $17045.65

Principal outstanding at the end of year 1 = Amount borrowed - principal repayment

Principal outstanding at the end of year 1 = $100000 - $17045.65 = $82954.35

Interest in year 2 = Principal outstanding at the end of year 1 - rate of interest

Interest in year 2 = $82954.35 * 8% = $6636.35

So, interest in year 2 = $6636.35


Related Solutions

Assume that you borrow $15,000 for five years (annual payments) at a market rate of 5%....
Assume that you borrow $15,000 for five years (annual payments) at a market rate of 5%. Assuming that inflation is 3.5%, what would the equivalent equal annual payment be in constant dollars?
You borrow $60,000; the annual loan payments are $5,840.18 for30 years. What interest rate are...
You borrow $60,000; the annual loan payments are $5,840.18 for 30 years. What interest rate are you being charged? Round your answer to the nearest whole number.
You borrow $180,000; the annual loan payments are $11,709.26 for 30 years. What interest rate are...
You borrow $180,000; the annual loan payments are $11,709.26 for 30 years. What interest rate are you being charged? Round your answer to two decimal places.
You borrow $245,000; the annual loan payments are $23,847.41 for 30 years. What interest rate are...
You borrow $245,000; the annual loan payments are $23,847.41 for 30 years. What interest rate are you being charged? Round your answer to two decimal places.
If you borrow $26,000 with monthly payments of $550 over 5 years, what annual rate are...
If you borrow $26,000 with monthly payments of $550 over 5 years, what annual rate are you paying? A. 8.18% B. 8.41% C. 9.81% D. 8.51%
You plan to borrow $100,000 at a 10% annual interest rate. The terms require you to...
You plan to borrow $100,000 at a 10% annual interest rate. The terms require you to amortize the loan with 10 equal end-of-year payments. How much interest would you be paying in Year 1?
You plan to borrow $100,000 at a 4.5% annual interest rate. The terms require you to...
You plan to borrow $100,000 at a 4.5% annual interest rate. The terms require you to amortize the loan over 15 years what is monthly payment and how much total interest would you be paying during the Year 1?
Assume a coupon of 6%. You borrow $10 million from the bank and you make annual payments over 8 years.
Assume a coupon of 6%. You borrow $10 million from the bank and you make annual payments over 8 years. There is a balloon payment of $1,000,000 at the end of year 8. Determine annual interest and principal payment for each year. Please make sure your answer includes a separate statement as to the exact principal payment in year 8.
Assume a coupon of 6%. You borrow $10 million from the bank and you make annual payments over 8 years.
Assume a coupon of 6%. You borrow $10 million from the bank and you make annual payments over 8 years. There is a balloon payment of $1,000,000 at the end of year 8. Determine annual interest and principal payment for each year. Please make sure your answer includes a separate statement as to the exact principal payment in year 8. How to do this in excel?
You borrow a GPM of $50,000 with annual payments and 3- year term. The interest rate...
You borrow a GPM of $50,000 with annual payments and 3- year term. The interest rate is 10% and the payment factors from years 1 to 3 are as follows: 50%, 50% and 100% Questions: 1.What are the annual payments for years 1 to 3? 2.What is remaining balance at the end of year 1? 3.What are interest payment and principal payment for years 1 to 3?
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT