do in excel

think of your dream house and its for 5 lakh

You will be completing an amortization table that shows the date, payment amount, interest applied, and the balance of the loan All amounts on the table should be cell references or formulas For this assignment, you will be calculating interest in even monthly periods Your interest rate is 4.99% for 30 years 1. Your loan must be paid off in till at the end of the toon You may need to fit your formula to make the loon ero out the formulamust be local . Before submitting hide throws between the first 12 months and the last 12 months Have fun! BH