Subscriber only lesson.
Sign up to this course to view this lesson.
OPEX Part 2
When to use
When constructing a basic financial model.
- Operating Expenditure (OPEX) will be calculated using of the final method of inputs, combination.
- A Growth rates flag will need to be inserted into Row 148 which produces a 1 or a 0
- The Amounts and Growth rates are linked from the Assumptions tab
- The formula for OPEX is =(1-J148)*J150+(J148*I153*(1+J151))
Lesson notes are only available for subscribers.