An Excel-based analysis tool that allows you to lever the annual cash flows in an ARGUS Valuation DCF™ output and also perform a joint venture equity partnership analysis. The model is annual in nature, and it is a 100% unlocked file with fully transparent formulas that are further customizable to suit the particulars of your transactions. Applies to commercial office, industrial and retail transactions that are analyzed in ARGUS.
Model Functional Highlights
The model supports the following:
- Manual linking to an ARGUS Valuation DCFTM Excel 11-year output report tab
- One layer of debt financing
- Up to two joint venture equity partnership players with an IRR-based Preferred Return and a residual cash flow split.
Model Tabs
1 Assumptions Input
2 Annual Cash Flow Input
3 Joint Venture Partnership Structure Input
4 IRR Waterfall Exhibit
5 Joint Venture Returns Summary Exhibit – 3 players
6 Senior Loan Monthly Amortization Schedule
7 Permanent Loan Monthly Amortization Schedule
8 Sensitivity Tables Exhibit
Model Maximum Timeline
11 years
Reports
Print-ready, brandable reports are included in the model. See the Sample Reports link above.
License Type And Multiple-User Pricing
Licenses are sold on a per-user basis
Support Included With Purchase
12 months of 1 Business Day turnaround e-mail support from date of purchase.