IRR (Internal Rate of Return) Modeling with Multiple Projects

Internal Rate of Return

Video Tutorial:

The value of the model is that it takes cash flows on a monthly basis and you can dynamically change the start/end dates of each project and the right IRR will populate accordingly, no matter what month is chosen to start/end.

There is also a consolidated IRR result.

You will see a comparison chart for IRR vs. required rate of return analysis as well as some approve/reject conditional formatting.

The main inputs include entering the name of each project, how much each project costs and the month it starts, the start/end date of cash flows, and a possible exit cash flow.

 

Users who purchased IRR (Internal Rate of Return) Modeling with Multiple Projects, also purchased:
Apartment Complex Cash Flow and Valuation
apartment building
Add to wish list
Purchase Excluding 7.7% tax
Joint Venture Real Estate Model
irr
Add to wish list
Purchase Excluding 7.7% tax
Hotel Valuation Financial Model
Hotel_VaHotel Valuation Financial Modelluation_Financial_Model
Add to wish list
Purchase Excluding 7.7% tax
Industry ,
Summary A 3-tab based template to easily enter up to 19 deals and see their resulting IRR's.
Screenshots / Pictures Project IRR Vs. Required Return
IRR Modeling with Multiple Projects
Internal Rate of Return
Use Cases , , , , , , , , , , , , ,

You must log in and be a buyer of this download to submit a review.

Leave a Reply