Loan Amount from LTV
Calculates loan amount, property value, or LTV ratio given the other two values.
• Property Value / Purchase Price: $7,000,000
• Loan-to-Value Ratio (LTV): 65.0%
• Loan Amount: $4,550,000
Hold Period in Months
Expresses the hold period in months for the loan payoff calculation.
• Hold Period (Years): 5 yr
• Hold Period (Months): 60
Loan Payoff at Sale
Calculates the remaining loan balance at the end of the hold period.
• Hold Period (Months): 60
• Loan Amount: $4,550,000
• Interest Rate (Note Rate): 7.00%
• Loan Amortization Term (Months): 360
• Loan Payoff at Sale: $4,282,987
Hold Period as Scalar Years
Expresses the hold period as a bare number of years for use as a loop bound and in series index arithmetic.
• Hold Period (Years): 5 yr
• Hold Period (Scalar Years): 5
Projected NOI Series
Projects NOI year-by-year over the hold period at a compound annual growth rate.
• Hold Period (Scalar Years): 5
• Net Operating Income (NOI): $450,000
• NOI Growth Rate (Annual): 3.0%
• Projected NOI Series:
| # | NOI |
|---|
| 1 | $450,000 |
| 2 | $463,500 |
| 3 | $477,405 |
| 4 | $491,727 |
| 5 | $506,479 |
Terminal / Reversion Value
Calculates the projected sale price at end of hold period by applying the exit cap rate to Year N+1 NOI, where the year-after-exit growth is taken from the final-period growth of the projected NOI series itself.
• Exit Cap Rate: 6.50%
• Projected NOI Series: See table above
• Terminal / Reversion Value: $8,025,744
Net Sale Proceeds
Calculates net proceeds from sale after selling costs and loan payoff.
• Terminal / Reversion Value: $8,025,744
• Selling Cost Rate: 2.0%
• Loan Payoff at Sale: $4,282,987
• Net Sale Proceeds: $3,582,241
Annual Debt Service
Calculates annual debt service, or back-solves loan amount or note rate, based on loan terms.
• Loan Amount: $4,550,000
• Interest Rate (Note Rate): 7.00%
• Loan Amortization Term (Months): 360
• Annual Debt Service: $363,255
Annual Cash Flows Series
Builds a year-by-year table of pre-tax cash flows over the hold period.
• Hold Period (Scalar Years): 5
• Projected NOI Series: See table above
• Annual Debt Service: $363,255
• Annual Cash Flows Series:
| # | Cash Flow |
|---|
| 1 | $86,745 |
| 2 | $100,245 |
| 3 | $114,150 |
| 4 | $128,472 |
| 5 | $143,224 |
Terminal Year Cash Flow
Calculates the total cash flow in the final hold year, combining operating cash flow and net sale proceeds.
• Annual Cash Flows Series: See table above
• Net Sale Proceeds: $3,582,241
• Terminal Year Cash Flow: $3,725,465
Closing Costs
Calculates closing costs as a percentage of property value.
• Property Value / Purchase Price: $7,000,000
• Closing Cost Rate: 1.5%
• Closing Costs: $105,000
Equity Required
Calculates equity required as purchase price minus loan proceeds plus closing costs.
• Loan Amount: $4,550,000
• Property Value / Purchase Price: $7,000,000
• Closing Costs: $105,000
• Equity Required: $2,555,000
IRR Cash Flow Vector
Constructs the full IRR cash flow vector: initial equity outflow, annual operating cash flows, and terminal year cash flow.
• Equity Required: $2,555,000
• Annual Cash Flows Series: See table above
• Hold Period (Scalar Years): 5
• Terminal Year Cash Flow: $3,725,465
• IRR Cash Flow Vector:
| # | Cash Flow |
|---|
| 0 | $-2,555,000 |
| 1 | $86,745 |
| 2 | $100,245 |
| 3 | $114,150 |
| 4 | $128,472 |
| 5 | $3,725,465 |
Internal Rate of Return
Calculates the levered IRR from the full hold period cash flow vector.
• IRR Cash Flow Vector: See table above
• Internal Rate of Return (IRR): 10.85%