Create an Amortization Table for a 15-year loan for $100,000. The interest rate is 5%, compounded each month. The monthly payment is $790.79. Calculate how much interest the loan would require. Make it formula-based so that we can quickly change the parameters and re-calculate (change the interest rate, the principle, the payment, etc.).
Here are more detailed instructions attached