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

jeff jeffy answered 1 year ago

Next > < Previous

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)...

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.

You have a 10 year loan for $50,000 and you make annual payments. The interest rate...

You have a 10 year loan for $50,000 and you make annual payments. The interest rate is 6% annual compounded quarterly. a) What are your annual payments? b) If the inflation rate is 3.2% annual compounded monthly, what is the purchasing power of your final payment in year 2 dollars? c) What are the equal annual payments in year 2 constant dollars with the above inflation rate? d) What is the total interest paid in year 2 constant dollars with...

You signed on an amortized loan. Under the loan, you will borrow $1000 at an annual...

You signed on an amortized loan. Under the loan, you will borrow $1000 at an annual rate of 6% for 3 years. Lets generate an amortized loan table showing payment scheduling. To generate the amortized loan table, we need to understand a same amount of payment (composed of interest charge and principal). Using PV of Ordinary Annuity equation, we can calculate an annual payment. C = 374.11. At the 1st year, you are required to pay 374.11. Out of 374.11,...

Subjects