Assumption Set Specifications
Switching Models
Import using EzEntry
Investment
Investors
Depreciation
Loans
- Unit Sales Development Draw
- Commercial Development Draw
- Adjustable Rate
- Interest Only to Amortizing
- No Payment to Amortizing
- Refinance
- Best Time to Refinance
- Conduit 360-365
- Amortizing Basics
Revenue
Revenue Existing Leases
Revenue Lease Up
Revenue Owner Representation
Revenue Tenant Representation
Expenses
Reimbursements
Market Profiles
Development Spending Dialog
Development Unit Sales
Portfolio
Partnership/LLC
'What if' Sensitivity
'What if' Risk
Reports
Charts
Graphs
Presentation
Measures
Ratios
|
Video Title: Loans Overview
- video duration: 3:14 minutes
- direct link to this video:https://www.planease.com/commercial-real-estate-video-training.aspx?1=Loans
Loan page overview for investment analysis. Construction draw loans are handled through Edit / Development Spending or Edit / Unit Sales — not the Loan page directly. Loan Amount entry methods: any number less than 3 (e.g. 1.2) = Debt Coverage Ratio; numbers 3-100 = Loan to Value percentage; any number over 100 = dollar amount. The Audit Window at bottom left shows results live as you enter assumptions. Loan Interest Rate: planEASe calculates the NOI for the year the loan starts and sizes the loan to match the specified coverage ratio or LTV. Loan Type options: Amortizing, Interest Only, Accruing, Variable, No Payments Compounding, quarterly/semi-annual/annual payments, and Conduit loans. Balloon Payment Due: enter number of payments until balloon — e.g. 60 for a 20-year loan due in 5 years (60 monthly payments). Loan Origination Date: leave zero for acquisition date, or enter any month/year. Payment Override: overrides the calculated payment — useful to accelerate payoff (enter higher amount) or model a specific required payment. Loan Points: enter 1 for one point (1% of original loan amount) added to debt service at origination. Amortized Points for Tax: defaults to code 1 (amortized over loan life) or enter specific years. Add additional loans: Edit / Add Loan Page — unlimited loans allowed for seconds, thirds, etc.
|