show work

AMORTIZATION SCHEDULE Create the amortization schedule (which lays out individual loan payments along with the principal/interest split in each payment) for a loan of $15,000 paid monthly over 3 years using a 9% APR. 1 2 3 PMT = After you have calculated the payment, simply create the amortization schedule. Note that you can create the amortization schedule "manually" doing you calculations line-by-line. However, it's much easier to set up the table in Excel by setting up the formulas in the 1st couple of lines, and then copy/paste for the balance of lines required for the table (i.e., total of 3 years times 12 months equals 36 lines for the amortization table for this problem). If you use Excel, just "Copy" the table you create in Excel as an object and "Paste" it here (or use a "snipping tool" to copy/paste it)