IRR Calculator

Acquisition Assumptions

Hotel Keys

Purchase Price /key ($)

Purchase Price Total ($)

Developer Fee /key ($)

Other Acquisition Costs (%)

Construction Costs

Hotel Type

Hard Costs /key ($)

Soft Costs /key ($)

FF&E /key ($)

Pre-Opening Costs /key ($)

Contingency (%)

Capital Stack

Investor Equity Debt

Interest Rate (%)

Amortization (years)

GP/LP Equity Contributions

GP Equity LP Equity

Pro-Forma (at stabilization)

Stabilization Year

ADR ($)

Occupancy (%)

Departmental Expenses (%)

Undistributed Operating Expenses (%)

Hotel Management Fee (%)

Asset Management Fee ($)

Insurance Expense ($)

Reserve for Replacement ($)

Property Tax ($)

Annual Growth (%)

Refinance Terms

Refinance Interest Rate (%)

Refinance Amortization (years)

Refinance Year

Debt Yield (%)

Exit Terms

Exit Year

Cap Rate (%)

Disposition Fee (%)

Other Selling Costs (%)

Waterfall Hurdles

Preferred Return Annual (%)

LP IRR Hurdle Level 1 (%)

Promote Level 1 (%)

LP IRR Hurdle Level 2 (%)

Promote Level 2 (%)

LP IRR Hurdle Level 3 (%)

Promote Level 3 (%)

Loading. Please wait...

Results:

Total Deal Amount:

Acquisition Cost:

Construction Cost:

Total Deal IRR:

Total Deal ERM:

LP Summary

LP IRR:

LP Total Contributions:

LP Total Distributions:

LP ERM:

LP Profit:

GP Summary

GP IRR:

GP Total Contributions:

GP Total Distributions:

GP ERM:

GP Profit:

Cashflows

Year	Project Cashflow	LP Cashflow	GP Cashflow

Feedback?

Let us know how we can improve this calculator. Send us an email.