Summary Sources and Uses Chart in a Project Finance Model

Description
One of the most important statement in a project finance model is the sources and uses of funds during construction. It is composed of two sections:

Uses of funds statement shows the total cost of a project with an explicit and meaningful breakdown of costs. It identifies the total financing required for a project.

Sources of funds statement lists the financing facilities that have been identified as available to meet the cost.

The summary sources and uses of funds table appears in most project documents and should also be included in the summary sheet or dashboard within the financial model.

It is also useful to include a chart to visualize the main items in the total project and the financing plan.

Getting a nice looking chart with descending or ascending order require some work.

In this Excel spreadsheet and manual I show you the steps to create a good looking bar chart for your Dashboard.

What you get:

1. An excel file
2. A pdf manual describing the steps with snapshots
3. Short video

The Excel temple can be used for educational purpose and users can also incorporate the template within their own models by making the links to the Sources and Uses line items in their own project financial models.