Term Loans

 

What will my monthly payments be for a 5-year equipment lease of $250,000? How will this affect my overall financial picture?

 

Within the Projections module, click on Forecast, then click Term Loans button under Special Calculators:

 

 

On the next screen, enter all amounts except for Payment.  Then press on the yellow CALC button to calculate the payment:

 

 

Press “OK” to have values placed in the correct places in the model. Click on the New Term Loans tab to see the various payments associated with the loan.  Below are the principle repayments:

 

 

Let’s look at a graph of the interest being paid. Click on the row with the interest, then click on the Trends icon:

 

 

 

The calculations can be worked in reverse as well.  You can put in the payment you want to make and the interest rate you think you’ll get, then calculate the loan amount you can get.