Build real modeling expertise.

Learn the formulas, build the model yourself, or read a finished one and work out what it is really telling you.

Formulas

Before the modeling. Learn the formulas themselves, one level at a time.

See the tests

Modeling

The history and assumptions are given. You build the model.

See the tests

Analysis

The model is built. You work out what it is really saying.

See the tests

What they look like

Modeling

BFGH

2PIP'S LEMONADE STAND

4Reveal answer check (Y / N):Nlocked in the free sample

8Revenue Build20252026E2027E

9Days open616466

10Cups sold per day45.047.049.0

11Cups sold2,7453,0083,234

12Price per cup$2.00

13Price change14.3%5.0%5.0%

14Revenue$5,490––

15Revenue growth28.8%

17Cost Build20252026E2027E

18Three cost behaviors: variable per cup, variable per day, and fixed

19Lemons per cup0.450.450.42

20Price per lemon$0.52

21Lemon price inflation15.6%4.0%3.0%

22Lemon cost per cup$0.234

InstructionsTestScore

Analysis

BDEF

2VANTRIDGE HEALTH PLANS

8Medical loss ratio, by book202320242025

9Commercial84.1%83.6%83.2%

10Medicare Advantage86.9%86.4%86.1%

11Medicaid89.4%89.0%88.7%

12Blended86.0%86.2%86.4%

14Q14

15Every one of the three risk books improves its loss ratio in every year of the forecast, and the blended ratio still gets worse. What is doing that?

16AMedical cost per member is rising faster than the premium charged

17BThe two government books earn a worse ratio and are taking share from commercialB

18CPrior-year reserve releases were larger in the historical years

19DMembership is falling in every book at the same time

20Q15

21Earnings per share grows 11% while net income grows 4%. Where did the other seven points come from?

InstructionsFinancialsQuestionsScoring