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
Our 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
Airbnb Financial Model
Air BnB Financial Model Template presents the business case of the purchase of up to 5 properties wi... 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
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 convi... Read more
Shopping Mall Financial Model
Shopping Mall Financial Model presents the case of an investment into a shopping mall and its operat... 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