Home Insert Draw Page Layout >> Y Tell me what you want X Conditional Formatting Tay Format as Table v Paste Font Alignment Number Cell Styles C6 4 x w for A B C D E F G H Using PMT to Amortize a loan and Scenarios Loan $10,000 4 Rate 5 Years 6 Monthly Payment Ice Use PMT function to calculate the monthly payment 8 Complete the amortization schedule below for the first 12 months of the loan. Month Payment Interest Principal Balance SANNA