Project Finance Model - Dynamic Excel Visualization
Originally published: 30/12/2020 07:10
Last version published: 18/05/2021 07:49
Publication number: ELQ-77538-3
View all versions & Certificate
certified

Project Finance Model - Dynamic Excel Visualization

Dynamic Dashboard to present project finance outcomes

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

https://www.eloquens.com/tool/7jq0HrME/finance/project-finance-models/project-finance-model-base

It has a dynamic advanced visualization based in Excel. Alternatively if you are interested in the Power BI solution, please follow the link below:

https://www.eloquens.com/tool/bbwpsd4l/engineering/power-bi-models/project-finance-model-power-bi

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:

• Dynamic timeline for the visuals, with ability to input start and end date, for more focused analysis;
• Using dynamic ranges to adjust the timeline and avoid presentation of the placeholders;
• Presenting the unusual graphs for the Excel visualisation – gauge, waterfall, timeline.
• Separate section to summarize all data which is presented on the Dashboard.

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.

This Best Practice includes
1 Excel based model

Acquire business license for $39.50

Add to cart

Add to bookmarks

Discuss

Further information

Feasibility study of the potential project

Reviews

  • Be the first to review this Downloadable Best Practice

    Write a review

People using this Best Practice also downloaded


keyboard_arrow_leftkeyboard_arrow_right

More Best Practices from Samir Asadov CFA


keyboard_arrow_leftkeyboard_arrow_right

Any questions on Project Finance Model - Dynamic Excel Visualization?

The user community and author are here to help. Go ahead!


0.0 / 5 (0 votes)

please wait...