Question

In: Finance

You borrow a ten-year loan of $1,500,000. The annual interest rate is 13% that to be...

You borrow a ten-year loan of $1,500,000. The annual interest rate is 13% that to be repaid every 2 weeks. Assume 52 weeks a year. List the numerical answers and EXCEL formulas of payment, interest, principal paid and end balance of 115th periodic payment in the table provided.

Payment Interest Principal

End Balance (Period 115)

(Numerical Answer) (Numerical Answer) (Numerical Answer) (Numerical Answer)
(EXCEL Formula) (EXCEL Formula) (EXCEL Formula) (EXCEL Formula)

Solutions

Expert Solution

End Balance of 115th Payment =  $1,050,858.96


Related Solutions

Assume you are to borrow money, the loan amount, at an annual interest rate to be...
Assume you are to borrow money, the loan amount, at an annual interest rate to be paid in equal installments each period. Installment Loan Schedule Loan Amount $25,000 Annual Interest Rate 9.90% Periods per year 12 Years to payback 5 See Table B.3 in book. Factor 47.17454194 FACTOR = [1 - (1 / ((1 + R)^n)]/ R Equal Payments $529.95 let R = period interest rate let n = number of periods to payback loan Number of periods: 60 Reduction...
You are buying a car and will borrow $31,837 with a 5-year loan. The interest rate...
You are buying a car and will borrow $31,837 with a 5-year loan. The interest rate is 4.46%, what is your monthly payment?
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.
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?
You borrow a GPM of $400,000 with annual payments and 15-year term. The interest rate is...
You borrow a GPM of $400,000 with annual payments and 15-year term. The interest rate is 4.5% and the payment factors from year 1 to year 15 are: 50%, 50%, 50%, 50%, 50%, 75%, 75%, 75%, 75%, 75%, 100%, …, 100%. What are the annual payments for years 1 to 15? What is remaining balance at the end of each year? What are the interest payment and principal payment for years 1 to 15? Answer the questions (1) to (3)...
construct a 10 year amortizing loan table with 8% interest rate. You borrow $30,000 initially and...
construct a 10 year amortizing loan table with 8% interest rate. You borrow $30,000 initially and repay it in your ten equal annual year end payments. show only the first 3 steps.
construct a 10 year amortizing loan table with 8% interest rate. You borrow $30,000 initially and...
construct a 10 year amortizing loan table with 8% interest rate. You borrow $30,000 initially and repay it in your ten equal annual year-end payments. Show only the first three years.
You borrow $7083 to buy a car. This is a 38-month loan with an annual rate...
You borrow $7083 to buy a car. This is a 38-month loan with an annual rate of 4.04%. What is your required monthly payment? Round to the nearest $0.01 (e.g., if your answer is $385.4789, record it as 385.48). Do this on excel and explain how to do it please.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT