0201 MAX() in Financial Modeling

2 minutes
Share the link to this page
You need to purchase the class to view this lesson.
One-time Purchase
List Price:  $139.99
You save:  $40
List Price:  د.إ514.21
You save:  د.إ146.92
List Price:  A$190.56
You save:  A$54.45
List Price:  ৳11,884.34
You save:  ৳3,395.77
List Price:  CA$174.66
You save:  CA$49.90
CHF 90.53
List Price:  CHF 126.75
You save:  CHF 36.21
List Price:  kr877.41
You save:  kr250.70
List Price:  €117.96
You save:  €33.70
List Price:  £100.67
You save:  £28.76
List Price:  HK$1,088.02
You save:  HK$310.88
List Price:  ₹10,412.35
You save:  ₹2,975.17
List Price:  RM591.03
You save:  RM168.88
List Price:  ₦57,601.68
You save:  ₦16,458.80
List Price:  kr1,234.29
You save:  kr352.68
List Price:  NZ$200.72
You save:  NZ$57.35
List Price:  ₱6,999.02
You save:  ₱1,999.86
List Price:  ₨22,760.84
You save:  ₨6,503.56
List Price:  S$189.59
You save:  S$54.17
List Price:  ฿4,603.85
You save:  ฿1,315.48
List Price:  ₺1,183.47
You save:  ₺338.16
List Price:  B$729.18
You save:  B$208.35
List Price:  R2,044.87
You save:  R584.29
List Price:  Лв230.80
You save:  Лв65.94
List Price:  ₩161,258.68
You save:  ₩46,077.20
List Price:  ₪451.72
You save:  ₪129.07
Already have an account? Log In


Hi there. In this case study, I will talk about the applications of Max formula specifically in the area of financial modeling. Now, going by the terminology of the formula a max means amongst the group of numbers, the maximum number will be chosen. Now, how do you use this in financial model and costing? Well, in this very, very theoretical case that lies before us, I have a cell which says income, the tax percentage, well, now, if I have to calculate the income tax, what would I typically say five lakh multiplied with 20%. That's one lakh.

Now, what if, in one of the years the income happens to be negative, the income tax tells me it's a negative one lakh which is not allowed, I would have wanted a numbered zero out there. So what I'm going to do is first if you press Control Zed, let me delete the yellow cell. Let me write a formula which says equal to Max Max Of what? Zero and the positive number which is in the form of identity. tax. So I choose five lakh multiplied with 20%.

Now notice, there will be a battle between these two numbers one is a zero and one is a calculation to one lakh versus zero, whichever is maximum will be picked up, in this case one lakh. But tomorrow, or maybe the next year in case the income happens to be negative, the battle is between zero and negative one lakh who will win it, of course zero. And that's the reason you're getting to see the stache, which is just another form or display value of zero. So this is one of the applications of Max formula. Let me take you through another case study. For example, you would have found this in one of the mobile phone bills or electricity bill, or any of the utilities bill, that if you don't pay it on time, a minimum value of 100 a minimum penalty of 100 will be divide.

But if you have not paid this for quite some time, then 2% of the dues shall be applicable, whichever is higher. That means either 2% of the dues, or hundred, whichever is higher. So now let me show you how this works. Logic can be incorporated in this particular problem using a formula. So I'm writing equal to Max, writing hundred, comma, and then posting a formula that says 5000 multiplied with 2%. I close the bracket and I press enter.

As I copy paste this formula down, notice the first case hundred next case 140. third case 100 minimum. Even if the minimum news was 100 rupees doesn't matter, you have to pay an additional alibi of hundred. But in case in case the amount of juice was 14,000, it's a big value. So it has to be 2% of 14,000, which in this case is 280. So this was more on the applications of Max formula, especially in decision making in Excel.

Sign Up


Share with friends, get 20% off
Invite your friends to LearnDesk learning marketplace. For each purchase they make, you get 20% off (upto $10) on your next purchase.