Joint Venture Real Estate Model

irr

Video Tutorial:

Includes a monthly and annual summary that auto-fills based on inputs and goes out for a period up to 30 years.

Includes a breakdown of investor units based on the aggregate investor cash required.

Includes a DCF analysis based on its own tab assumptions.

Includes a full dynamic amortization schedule for financing options that is completely dynamic and integrated into all aspects of the model.

Includes a full amortization schedule to track depreciation if needed. The depreciation model itself allows for all conventions and various useful life inputs.

Includes a dynamic reserve calculation to let you check if you have allowed enough cash to cover initial costs before revenue starts.

One of the most difficult things for developers/sponsors to do is explaining to investors what the cash flows look like in a given real estate venture. This template was built to give developers a great tool to use in order to explain what is going on to investors/partners and how various changes to a deal will effect return %’s.

Additions*****
The two waterfall models allow you to either enter the monthly cash flows of the project per each month and based on those cash flows, it will show the splits of cash flow to each group. The higher-priced one has allowed for up to 3 groups with different hurdle rates i.e. 1 sponsor and 2 investors, with the 2 investors having different hurdle rates.

The lower-priced waterfall model allows for you to build cash flows from a top down style real estate model or you could just put in the cash flows for each month manually. Based on those cash flows, it has a waterfall split between 1 sponsor and 1 investor.

*Free version does not include the depreciation schedule.

Joint Venture Real Estate Financial Model

 

 

 

Users who purchased Joint Venture Real Estate Model, also purchased:
Apartment Complex Cash Flow and Valuation
apartment building
Add to wish list
Purchase Excluding 7.7% tax
Peer to peer (P2P) lending Investing Model
Banking concept 3D
Add to wish list
Purchase Excluding 7.7% tax
Mobile Home Park / Community Financial Feasibility
mobile1
Add to wish list
Purchase Excluding 7.7% tax
Industry , ,
Summary The purpose of this model is to give investors and sponsors a clear picture of what their projected cash flow returns will be (based on over 30 Inputs) as well as perform sensitivity analysis on various IRR hurdles. This was built for the average user and was done in a general enough way to fit nearly any scenario but still be specific enough to account for all the cash caveats that go into planning out a single real estate venture. This model is built to handle one single project at a time.
Screenshots / Pictures Joint Venture Real Estate Financial Model



Use Cases , , , , , , , , ,

You must log in to submit a review.

Leave a Reply