Real Estate Financial Modeling Tools

Standard Version: ARGUS Valuation DCF (TM) Leverage and Joint Venture Analysis Companion Pro-Forma Template

$399.00

SKU: SKU-459 Category:

Description

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.

Register now to get FREE e-Books, Excel tools and access to Valuate software REGISTER
left to take 50% off with coupon code: yearend50