Using the Commercial Loan Guide

Using the Commercial Loan Guide

Click the Commercial loan button from the guide screen. The Commercial loan dialog window is displayed as shown below with its standard defaults. This guide's assumptions are listed in the box above the input fields.

** SCREEN SHOT HERE **

Commercial loan dialog input fields

Note: Use [Tab] to move from field to field or click within each field.

  • Start date The start date defaults to the current date. Click in the Start date field and enter a date or click the Calendar button and select the desired date. (See Date shortcuts.)
  • Loan amount Type the dollar amount of the loan. For this example 1M (for 1,000,000.00) was entered. (See Amount shortcuts.)
  • Loan term (in years) The drop-down list has 3 options: 20, 25, or 30 years. You can choose an option from the drop-down list or type 20, 25, or 30 in the Loan term field. For this example 20 (for 20 years) was entered.
  • Interest rate This is a percent field where the interest rate of the loan should be entered. For this example 5 was entered (for 5%).
  • Create balloon after The drop-down list has 5 options: No balloon, 3, 5, 7, or 10 years. You can choose an option from the drop-down list or type N, 3, 5, 7, or 10 in the Create balloon after field. For this example [Tab] (for default of 5 years) was entered.
  • Create Builds the cash flow based on all entered data.

The pre-populated Cash Flow Data window should now appear as shown below. The cash flow can be further adjusted to fit your specific commercial loan scenario.

** SCREEN SHOT HERE **

Cash Flow Data fields

  • Label field includes the name of the guide used. (See Edit the Label field.)
  • Compounding Period is set to Exact Days per this guide's assumptions.
  • Nominal Annual Rate is set to the entered Interest rate of 5%.
  • The calculation settings per this guide's assumptions (Normal amortization and a 360 day year) are displayed at the bottom left. You can click on the displayed settings to quickly access the Calculations group on the Configuration ribbon where you can change these settings.

Cash Flow Matrix fields

  • Start date The Date in the Loan Event (line 1).
  • Loan amount The Amount - 1,000,000.00 - in the Loan Event (line 1).
  • Loan term (in years) The Amount - 6,640.36 - in the 1st Payment Event (line 2) is the payment amount if you calculate a 1,000,000 loan at 5% for 240 months (20 years) with this guide's assumptions (Compounding Period in Exact Days, Compute Method set to Normal, and a Year Length of 360 days).
  • Create balloon after The Number in the 2nd Payment Event (line 2) = 60 (5 years).