MAX practice

MAX returns the largest value in its arguments. Below are the 5 financial modeling exercises on Modeldrill that use it, each checked instantly in your browser.

Syntax

MAX(value1, [value2], ...)

What people get wrong

MAX(0, x) is the standard way to floor a value at zero, for example tax only when there is a profit.

financial modeling exercises that use MAX

• Tax only when there is a profitLevel 2Pro
• Tax losses carried forwardLevel 2Pro
• From EBITDA to net incomeLevel 2Pro
• Revolver draw and repayment ruleLevel 3Pro
• Cash and revolver, fully linkedLevel 3Pro

Often used together with: MIN