Need more of an explanation, click definition for additional information.

Entries that are user input are in a brown font.

Determine Maximum Loan Amount

Annual N.0.I.: 
Debt service coverage:
Loan amortization (years):
Balloon term (years):
Interest rate (EX: .0925):
747564.8 _
1.25 _____
25 _______
 5 _______
.0875 ____
 
Using the constant
 
Debt service coverage

Maximum loan amount

Annual payment

Maximum rate for debt
Service break even

Balloon excluding monthly

Balloon including monthly

.0986572363339

1.20

$6,314,495.42

$622,970.67

.1109


$5,874,571.66


$5,926,485.89 



1.25

$6,061,915.60

$598,051.84

.1165


$5,639,588.76


$5,689,426.41



1.30

$5,828,765.00

$575,049.85

.1221


$5,422,681.52


$5,470,602.34

Up ] Loan/Investment Analysis ] Capitalization Rates ] Income/Expense Analysis ] [ Maximum Loan Amount ] Sensitivity Report ] Discounted Cash Flow ] Lease Analysis/Summary ]

 

If you came to this page through a search engine, click here for the  Home Page.

Copyright © 2007 - 1999 Loan Masters, Inc., all rights reserved.