Financial Modelling Handbook

The case tells us that: "Payment terms agreed with the O&M contractor specify that the O&M fee will be paid monthly within 30 days of month-end." Therefore, we will have one month of O&M costs unpaid at the end of each quarter.

Here's the step by step build-up of the operating costs block. I find it particularly satisfying that in preparing this calculation block, we use our Core Modelling Skills in order from 1 to 5. Step 1: Add a heading I'm creating some space and adding a

The operating costs in our case study are straightforward. We have one O&M contract with a fixed annual fee of $1.5m per annum. In reality, operating costs for any business, even a solar plant, will be more involved than this. However, the modelling of operating costs will

What happens if different customers or different products have different payment lags?

What happens if the invoice payment lag is longer than the model timeline?

Download the Accounts Receivable solution file: To obtain the worked example file to accompany this chapter buy the financial modelling handbook. Although you can't tell from the solution case, I started with the balance corkscrew. I then added the other two calculation blocks. I prefer to forecast the

Note: This lesson begins from the completed model from the Revenue section: To obtain the worked example file to accompany this chapter buy the financial modelling handbook. This section gives you some useful notes and pointers to help you start modelling Accounts Receivable. If you are feeling brave, take a

Working capital has an enormous impact on the cash flow of any business. You must look carefully at the operating reality of the company you are modelling to understand the working capital dynamics. What is Accounts Receivable? Accounts receivable is a balance. It is the value of invoices that have

The main sections of the revenue calculation should be somewhat familiar since we saw them earlier in the book when we were practising our essential skills. Download revenue section solution model: To obtain the worked example file to accompany this chapter buy the financial modelling handbook. I have set up

Note: This lesson begins from the completed file from the previous lesson: To obtain the worked example file to accompany this chapter buy the financial modelling handbook. Modelling objectives: * Model revenue per the specifications of the case; * Flow revenue into our income statement; * Decide what to do about invoice payment