Financial Models are especially designed excel spreadsheets which have order and consistency throughout the workbook, unlike random set of calculations. So, excel doesn't provide utilites specifically for working on financial modellers. As a finance manager, your team of financial analysts needs this tool every now and then to navigate the formulas, perform review of the calculations, Compare files, delete unwanted named ranges & styles, etc. Without these, it is like going blind for a fight. These utilites have been combined in a single model ribbon using the experience, pitfalls from various other decade old tools. And, have been designed to keep up with the analyst's speed . . .
Know More Download Now
This is a fully prepared Solar Park financial model created using 'AMPERE'. Energy Generation has been calculated with Annual energy input in kWh and the capacity degrades over time. Then Transmission Losses the Net Energy Generation is calculated. Revenue includes Sale of Energy and Sales of Carbon Credit Certificates. Costs include Operations & Maintenance, Insurance and others. This model has easy-to-understand calculations with best modelling practices followed through out the model. It is a bid model built for Solar Park energy generator with scenarios and sensitivity, calculations for returns NPV, IRR and coverage ratios DSCR and LLCR . . .
Know More Purchase Now
This is a already prepared Wind Park financial model created using 'AMPERE'. Energy Production is based on uncertainity probability to calculate Energy Production for different scenarios (P50, P70, P90) based on Normal Curve Distribution. Net Energy Production is calculated after Transmission losses. Revenue is divided into PPA Revenue, Electricity Certificates Sale, Grid Benefits. Costs include Operations & Maintainance (Fixed and Variable), Grid Costs, Land Lease, Insurance, Real Estate Tax and Others.This model has been developed for getting bid price and dummy assumptions have been put into place . . .
Know More Purchase Now
This is Shipping Port Model created using 'AMPERE'. The model has 1 year Actuals and assumes the port to be operational, and a new terminal needs to be built. Four types of cargo are considered here 'Container', 'Liquid Bulk', 'Dry Bulk' and 'Break Bulk'. Further different tariffs have set of Transshipment and Domestic cargo. Costs include Direct Costs for processing each type of cargo, G&A, Salaries, Fuel Expenses, Electricity, Maintenance, Insurance and Rent. This model has been developed considering the port authority is looking to construct and open a new terminal along with an existing terminal. IRR and NPV has been calculated along with Coverage Ratios like DSCR and LLCR, considering the new terminal funding requirements . . .
Know More Purchase Now
This Toll Road Model has been created using 'AMPERE'. This model has easy-to-understand calculations with best modelling practices followed through out the model. This bid model has been developed for a toll project for 25 years having toll rates classified as "Through Traffic", "Daily Pass", "Monthly Pass", "Local Pass". The arrangement being BOT (Build-Operate-Transfer). IRR and NPV has been calculated along with Coverage Ratios like DSCR and LLCR. The model has pre-built "Dashboard" that has neatly arranged metrics driven by sheet "Dash Prep". And a "Track" sheet which can be used to save and compare key outputs across different version of the model . . .
Know More Purchase Now
Dashboarding is an art which requires gathering all the required outputs along with keeping the design simple. It also requires an understanding of the business requirement in order to display appropriate information. Even the placement of items is crucial, as unlike online dashboards provided by visualization tools like Power BI, Spotfire, Excel Dashboard needs to be built in such a way that it fits perfectly within the narrow screen. Too much screen coverage horizontally can make it hard to navigate on smaller screens. We have gathered some excellent and pretty dashboard design for you to use it in your models. We also build custom dashboards for your models. Follow the link to download.
Know More