• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 22. Using Excel's Analysis Tools > Creating Amortization Tables to Calc...

Creating Amortization Tables to Calculate Mortgage Payments

Excel's Table feature helps you to create structured tables for calculating mortgage and lease payments, depreciation, and so on. Suppose that you want to purchase a house; you need to see the mortgage rate based on variable percentages and mortgage amounts. Here, you would use the PMT function to create a table to provide the mortgage rate, as shown in Figure 22.24. The schedule in cells F5:F19 is calculated based on a total loan amount of $100,000 on a 30-year mortgage, with percentage rates starting at 5 percent and increasing in .5 percent increments.

Following is the syntax for the PMT function used to create the table:


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint