Turn the numbers
into a point of view.

Build the model. Understand the drivers. Explain what matters. Practical education for the work a good analyst is expected to do.

The Keystone Standard
Teach the method. Not the trick.

The Keystone LabSynthetic teaching case

Field Note 001 / Driver Analysis

Look past the headline.

Keystone
Revenue$1.30m+8.0% vs. base
Operating Profit$140.6k-21.9% vs. base
Operating Margin10.9%Base: 15.0%
What moved operating profit?USD, thousands
Operating profit bridgeBase: $180,000. Volume: $38,400. Price: $0. Unit cost: -$77,760. Scenario: $140,640. Sequential bridge, with price and cost effects calculated at scenario volume.2501250180.0Base+38.4Volume0.0Price−77.8Unit cost140.6Scenario
Revenue is growing. Profit is not.

Operating profit falls 21.9% versus the base case. Trace volume, price, and unit cost separately before recommending a response.

Change the Assumptions

Try your own scenario. Each slider recalculates the bridge above.

The Calculation

Units × (Price − Unit Cost) − Fixed Costs

10,800 × ($120.00 − $79.20) − $300,000 = $140,640

Base: 10,000 units · $120 price · $72 variable unit cost · $300,000 fixed costs. Synthetic learning example, not company results or financial advice. Fixed costs stay constant; volume, price, and unit cost are independent inputs.

Select a scenario. Follow the numbers. Form a point of view.
A learning division of Keystone Reporting GroupExplore the lab Learn the thinking behind the numbers

Four disciplines.
One connected workflow.

Good analysis does not stop at a spreadsheet. Follow the work from a controlled model to a clear management recommendation.

Select a discipline to explore its output

A model you can defend.

Separate inputs from calculations. Make assumptions visible. Reconcile the output before building the story.

Inside the Complete GuideFinancial Modeling in Excel8 planned modules · 32 planned lessons
Explore the Curriculum
01_operating_model.xlsxSYNTHETIC
ƒx= Units * (Price - Unit_Cost) - Fixed_Costs
Synthetic operating model inputs and reconciled results
Driver / OutputBase CaseCost Pressure
Units sold10,00010,800
Price per unit$120.00$120.00
Variable cost / unit$72.00$79.20
Fixed costs$300,000$300,000
Revenue$1,200,000$1,296,000
Operating profit$180,000$140,640
Inputs → Calculations → Reconciliation
Illustrative workbook structure. Demonstration only; not a released course file.
KRG Institute laurel crestKRG INSTITUTE
APPLIED FINANCE SERIES

THE COMPLETE

Financial
Analyst
Guide.

MODEL · ANALYZE
AUTOMATE · EXPLAIN
01–04

Learn the whole system.
Not just the software.

An integrated learning path through financial modeling, data analysis, automation, visualization, and corporate reporting, plus one optional specialization.

4Core Courses
35Planned Modules
140Planned Lessons
  • Financial Modeling in Excel
  • Data Analysis, Automation & Visualization
  • AI for Financial Automation
  • The Corporate Reporting Guide
Flagship Pre-Order$399

$696 individually
Save $297 with the package

In production. Pre-order reserves access upon release, not immediate access to a completed course. No release date is currently promised. Review Pre-Order Terms.

Anfernee McLemore, Principal of Keystone Reporting Group
Anfernee McLemorePrincipal, Keystone Reporting Group

Teach only what you can
stand behind under review.

The spreadsheet is the start.
The explanation is the work.

KRG Institute brings Keystone Reporting Group's reporting philosophy into education: know where the number came from, understand what changed, and make the next decision clearer.

Anfernee's background spans pricing, program finance, manufacturing finance, FP&A, healthcare transaction analysis, financial modeling, and reporting automation.

The Keystone LensTeach the method. Not the trick.
Clarity over cleverness.

What actually changed the result?

More volume adds $38,400 of profit. Higher unit costs remove $77,760. The revenue headline alone misses the problem.

$180,000 + $38,400 − $77,760 = $140,640

Applied to the lab's synthetic Cost Pressure case.

About the Institute

Build work you can
stand behind.

Start with the connected analyst path, or explore focused programs for FP&A and project finance.

Find Your Program