Path of Lease Resistance
When capital expenditure is lumpy and / or large it is common to need to consider and model a major maintenance reserve account (MMRA/c). This tutorial describes the function of MMRA and how to code and link it to the Financial Statements.
During the operational phase of a project, capital investment is required to ensure that the project is able to continue operating as planned. Examples include, the resurfacing of runway, a planned lane widening on a toll road or the major overhaul of a generation set. Just like saving up for a rainy day the MMRA/c is designed to accumulate funds to ensure the funds are there when they are needed, if not a little before.
A MMRA/c is typically required by lenders where the maintenance cycle of the project is such that there are large maintenance costs relative to the cashflow which incurred during the operational life of the project. Lenders would be concerned in these circumstances to ensure that cash was effectively put aside equal to the estimated maintenance costs in the year in which such costs are to be incurred.
From the lenders’ perspective, this is important because if that essential maintenance is not done when scheduled it may mean the ability of the project to repay the outstanding loan on time is impaired.
The Major Maintenance Reserve Account usually funded up to certain target balance. The target balance for the MMRA might be set at 6, 12, 18, or 24 months of future major maintenance capex. It may even be a fixed amount.
Similar to DSRA, the funding method for the establishment of the MMRA is usually stated in the Term Sheet which could be one of the following:
In terms of positioning in the cashflow waterfall, the cash available to fund MMRA is usually ranked after operational cashflow but takes precedence over debt service payment.
The following points relate to the example used in the accompanied workbook:
Screenshot: Tutorial assumptions
Modelling the mechanics of a MMRA is similar to modelling a DSRA. Essentially, modelling the MMRA involves cash inflows and cash outflows as described below:
The screenshot below illustrates the elements and calculations of the MMRA. Note that the MMRA target balance is calculated as the sum of future expected maintenance capex. SUM (OFFSET) is used to calculate the dynamic target balance. Refer to our Tutorial titled Offset Function to learn more about this combination.
Generally, interest is earned on the opening balance of the Major Maintenance Reserve Account and is recognised in the same way interest on cash balance is in the cashflow waterfall.
Screenshot: Suggested layout of the calculation of MMRA
In the next screenshot the Cash Inflows to / Outflows from MMRA is linked into to the cashflow waterfall, and the closing balance of the MMRA forms part of the Current Assets in the Balance Sheet.
Note that in the first year the product price is expected to be higher and hence the revenue. Thus, the MMRA is built-up to the target balance in the first year of operations.
Then the prices start to dip in the second year and at the same time there is a large major maintenance capex in year-2. But because the balance in the MMRA could be used to fund such maintenance capex, the net major maintenance capex is constant (AUD 1.25 M).
By maintaining a MMRA, lenders could ensure the funds are set aside from ongoing operations in order to be able to service such capex at given intervals – this reduces the stress of lumpy cashflows on the project and therefore on debt service.
Screenshot: Linking MMRA calculation to Financial Statements
As with the DSRA, care is to be taken modelling the MMRA to avoid circular references. This is particularly true if the initial balance is debt-funded. There is usually no real reason for a logical circular reference to occur due to the MMRA.
An issue frequently raised by lenders is the operation mechanism of MMRA in the event of a debt service payment shortfall. If there is cash available in the MRA and the project has no other funds with which to make a payment due to the lenders, can the lenders access the MMRA in this event? In this case, it is also required to restore the balance of the MMRA if it is drawn to pay debt service.
See All Resources Get the latest Project Finance Tutorials and Blog Posts...
You will go into the draw to WIN a FREE training course.
Instantly unsubscribe at any time. We value your privacy.
We provide leading project finance professionals with in-house training and four public courses in Asia, Europe, US and the Middle East.
Our experience with Navigator was extremely impressive. They exceeded our expectations, I am simply amazed at the model's functionality and the range of information on their website. I am grateful for their dedicated team taking care of our assignment in an efficient and professional manner. We look forward to a robust long-term relationship.Dorado Ocean Resources