Spreadsheet Basics

The payments are made at the end of each payment interval, so select END. Move the cursor to PMT to find the payment for the loan, and press ALPHA SOLVE. Since the payments for the loan are paid out, PMT is negative. The payment for the loan is $860.66. Use a spreadsheet to follow the progress of repaying the loan with an amortization table. ................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download