FAQ: How do I use the Odyssey Financial Model?

FAQ: How do I use the Odyssey Financial Model?

Odyssey compiles your project inputs including load demand, generation capacity, project capex, and revenues for both project sites and project portfolios.

Excel Financial Model

The Financial section of Odyssey includes an Excel financial model. The financial model allows you to model more detailed sensitivities and additional revenue streams, or "key-maker businesses". The financial model automatically pulls in your project-level data including the load/customer category, your generation system, and all project costs. 



1. Input the Financial module inputs 

Follow the instructions above in the Odyssey Financial module inputs section to input the sensitivities and growths/ramps on the financials module first. These inputs will pull into the Financial model, any edits to these values will need to be made in the Odyssey platform. 

2. Download Project Financial Model

Once you've completed the Financial module inputs, select the Download Project Financial Model button at the bottom of the page to save your inputs and download the Excel model. 

Odyssey - Google Chrome 2021-09-06 at 3.53.02 PM
 

3. Add Inputs in the Financial Model

After downloading the Excel model, follow the instructions in the "Instructions - MUST READ" sheet of the Excel workbook. All inputs you entered in the Odyssey platform project modules will be pulled into the Financial model, but will be locked for editing. All edits to project inputs must be made in Odyssey. 

Sample Project 1 - Excel 2021-09-06 at 3.57.16 PM







4. View Financial model outputs

A summary of the financial outputs can be viewed on the Summary page of the Excel financial model. 
Sample Project 1 - Excel 2021-09-06 at 4.01.36 PM


5. Upload your updated Excel financial model to Odyssey

Once the Summary financials look correct, you will upload the Excel financial model to the Financial page of your project in Odyssey. To upload the Excel model, save it on your computer and then select the Upload Project Financial Model button. 

The financial outputs all come from the Summary tab of the model and take into account all inputs you've entered in the Financial model (including your Key-Maker Activities). If you want to make changes, you can Download the financial model, make updates, and re-upload. 

Does your output field not match your Excel upload?
If you had made changes in the Odyssey Financial page since your last Download of the Financial model, your updates from the Financial page will be pulled into your Excel Financial Model to calculate your project financial outputs. To see the latest copy of the Excel Financial Model, press Download Project Financial Model after uploading your latest Financial model.

Portfolio Financial Model


Once you package all projects into a portfolio you will export your Portfolio-level Financial Model which includes the Pro Forma of each project within your portfolio. 

Download the portfolio financial model 

1. Select the projects you would like to include

Select the checkbox next to each project in a lot in your My Projects list.




2. Select Export Financial Model

You can download the portfolio Excel financial model which includes all projects within a lot by selecting Export Project Financial Model(s). The project financial models will take time (it can take a few hours) to download in bulk from the Projects list section, when the portfolio-financial model has completed compiling you will receive an email in your inbox with a link to download the files. 


3. View your file and upload it to the portfolio Data Room

Your portfolio financial model will be emailed to you when completed. Select the link in the email to download a zip file which includes the portfolio financial model and a project-level financial model for each project you selected. 

The portfolio financial model will be labeled "project-group". View the portfolio financials before uploading the portfolio financial model to the Data Room of your portfolio for each lot. 

Note: For security purposes, you must download the file within 24 hours from the link in the email. After 24 hours your files will expire and you will need to export them from Odyssey again.

4. Repeat the steps above for each lot you are submitting a proposal for 


    • Related Articles

    • Create your portfolio financial model

      Once you package all projects into a portfolio you will export your Portfolio-level Financial Model which includes the Pro Forma of each project within your portfolio. You will upload the portfolio financial model in the portfolio Data Room for each ...

    • Create Your Portfolio Financial Model

      Portfolio Financial Model Once you package all projects into a portfolio you will export your Portfolio-level Financial Model which includes the Pro Forma of each project within your portfolio. You will upload the portfolio financial model in the ...

    • Odyssey Tracker

      Odyssey Tracker is an advanced project management tool for coordinating project preparation, construction, and commissioning across all members of your team. If you are interested in adding Tracker to your Odyssey account, contact us to learn more ...

    • FAQ: What are my options for modeling an interconnected mini-grid in Odyssey?

      To model your interconnected mini-grid in Odyssey you have three options depending on your agreement with the DisCo region and desired plan:  Modeling a mini-grid that consumes from and optionally exports electricity to an unreliable grid Modeling an ...

    • NEP AfDB Productive Use Appliances & Equipment (PUE) Application

      The Results Based Financing for Productive Appliances & Equipment aims to increase the productive use of energy in remote communities by increasing access to efficient, electric productive equipment. Submissions outside of the platform will not be ...