Overview

This project finance model is an advance version of the model you can find under the following link:

https://www.eloquens.com/tool/XvxKFxl5/finance/project-finance-models/project-finance-model-unlimited-scenarios

It introduces the new spreadsheet purely concentrating on the ratios. Especially useful in evaluation of the outcome of the model, and assess the key risks of the project.

Project finance model which is not fixed to any particular industry. Easy to incorporate various revenue and cost lines. Particularly useful for the feasibility study of the potential projects from the inception. The main outcome of the model is to resolve the optimum price to achieve required hurdle rate, based on the flexible cost and debt terms.
In addition to the functionality described in the base version this model incorporates new features:

• Detailed calculations of the investment ratios – IRR, NPV, Money Multiple and Cash Yield;
• Comparison of the debt ratios typically evaluated by lenders – DSCR, LLCR, PLCR and Weighted Average Life (WAL);
• Other ratios to evaluate the financial statements – profitability, liquidity, leverage and efficiency;
• Updates in the input sheet and timing to support the ratios calculations.

The template follows best practices in financial modelling and VBA. The model will be expanded in the future to incorporate more complex aspects. Stay in touch to see the new features. Please contact me directly if you have any questions or suggestions. After purchase, use private messages if you need help in populating the models.

Reviews Add a review
No reviews yet

More From Samir Asadov

Browse our top rated business templates. See All
Event Table Allocator
138
0
In the modern work environment to benefit the most from the events (Christmas Dinner, team-building sessions, client conferences), organizers are…
Project Finance Model - Advanced Senior Debt
135
0
This project finance model is an advance version of the model you can find under the following link: https://marketplace.corporatefinanceinstitute.com/financial-model-templates/project-finance-model-base/ The…
Project Finance Model - Dynamic Excel Visualization
200
0
This project finance model is an advance version of the model you can find under the following link: https://marketplace.corporatefinanceinstitute.com/financial-model-templates/project-finance-model-base/ It…
Project Finance Model - Scenarios & Ratios & Timeline
293
0
This project finance model is an advanced version of the model you can find under the following link: https://www.eloquens.com/tool/yZ54Hr1A/finance/project-finance-models/project-financing-model-scenarios-ratios It…
Project Finance Model - Advanced Ratios
275
0
This project finance model is an advance version of the model you can find under the following link: https://marketplace.corporatefinanceinstitute.com/financial-model-templates/project-finance-model-base/ It…
Project Finance Model - Power BI
352
0
This project finance model is an advance version of the model you can find under the following link: https://marketplace.corporatefinanceinstitute.com/financial-model-templates/project-finance-model-unlimited-scenarios/ The…
See All