Tutorial Home > Software > Office > Microsoft Office 2000 Projects > Mortgage Analysis

Mortgage Analysis
You can easily set up a 2-variable table that you can use to calculate several mortgage options at once. For example, if you choose a mortgage of $170,000.00, you can set up a 2-variable table in Excel that will calculate your monthly payment at $1,131.00 at a 7% interest rate. For this series, you will first create a 2-variable table containing the formulas required to calculate various monthly payments and then you will create a column chart that will compare a variety of payment options.

  Tutorials
  Designate Remaining Series
  Complete the Chart
  Print the Worksheet
  Save and Close the Worksheet
  Set Up a 2-Variable Table
  Enter Interest Rates
  Assign Range Names
  Select the PMT Function
  Use the PMT Function
  Use the Table Function
  Modify Values
  Create a Chart
  Designate Series 1