In: Finance
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) |