0 ITEMS
IRR (Internal Rate of Return) Modeling with Multiple Projects
A 3-tab based template to easily enter up to 19 deals and see their resulting IRR’s.
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.
Similar Products
Other customers were also interested in ...
Real Estate Financial Model Bundle
This is a collection of financial model templates for Real Estate businesses and its related sectors... Read more
Commercial Real Estate Valuation Model Templa...
The commercial real estate valuation model template assists to run a professional DCF Valuation for ... Read more
Real Estate Financial Model Templates Package
This is a collection of financial model templates for real estate businesses and its related sectors... Read more
Commercial Real Estate Acquisition Model for ...
Advanced Real Estate Model for a professional DCF valuation of Office, Retail or Industrial Properti... Read more
Real Estate Financial Model Template Bundle
This Real Estate Financial Model Template Bundle is best for those who are real estate professionals... Read more
Construction / Development Financial Model
Development & Construction Model presents the case where a property with multiple residential un... Read more
Hospitality Financial Model Template Package
This is a collection of financial model templates for businesses in the hospitality industry and its... Read more
Hotel Development REFM Financial Model Excel ...
Get the Best Hotel Development REFM Financial Model. Excel Template for your pitch deck to convince ... Read more
Commercial Real Estate – Lease or Sell ...
Project Finance Model is for the financing of long-term infrastructure projects and includes Funding... Read more
Multi-Family Apartment Complex – Acquis...
General Overview Advanced financial model presenting an acquisition scenario for a Multi-family A... Read more