All Industries, Financial Model, General Excel Financial Models

Budget, Budgeting, Dividends, Financial Planning, Financing, Forecast

This template will be useful if you have a startup company, an affiliate, or a company division with volatile cash flows. In some periods, there might be shortfalls that need to be funded externally, while in other periods, there might be excess cash that can be distributed.

The logic of this template is as follows:

You need to decide on the funding period (it can be 3 months, 6 months, or any other time period). This is how often you would like to fund the company or distribute excess cash.
The template takes the cash balance at the beginning of a funding period, forecasts monthly cash inflows and outflows during that period, and determines if there will be any deficit of cash in any month.
In case a shortfall is anticipated, it calculates how much funding is required at the beginning of the period (taking into account the minimum cash balance that you also provide).
If by the end of the funding period, there is expected to be some extra cash, this cash is distributed as of the end of this period.
But if in the next period, there will be a shortage, this distribution is reduced by the amount you need to set aside to cover this shortage in the next period. if it is not enough, a funding amount is calculated for that next period.

A few additional considerations on funding matters:

Reduction of share capital can be complex from a legal standpoint and cannot be made very often.
In some countries, you cannot pay more dividends than the amount of net assets you have.
There could be other limitations imposed by your local requirements. Contact me if you need help creating a more complex funding model addressing your particular situation.

You must log in to submit a review.