MasterClass ExecutiveThe University of Chicago Booth School of Business

Data & financial analysis with AI

Your story.
In your own voice.

An executive presentation of the business challenge, AI-assisted analytical approach, verified findings, and recommendation, with a guided walkthrough of the dashboard and supporting financial model.

Project presentation

Read aloud once, then adjust the wording to your voice. Blue cue boxes describe what to show on screen; do not read them aloud.

0:00–0:30 · The business decision

Open Decision.

“For this project, I analyzed Button and Bear, a fictional online teddy-bear business choosing its next-quarter offer.

The founder had 3 options: keep the promotion, reset prices and shipping charges, or introduce a bundle. My goal was to improve operating profit while protecting inventory and a $15,000 cash reserve.

My first hypothesis was that the bundle would be the best choice.”

0:30–1:00 · Checking the data

Open Brief & verification. Show the checks.

“I used AI to review the financial workbooks, orders, and planning inputs. Independent AI agents challenged the calculations and recommendation.

We combined each order’s product lines before calculating shipping, so it wasn’t counted twice. All 10,800 orders reconciled to the monthly records. The original files stayed unchanged.”

1:00–1:40 · What Q3 revealed

Open Q3 performance. Show the budget comparison and profit bridge.

“The first finding was that more orders did not mean more profit. Q3 orders beat budget by 20%, but operating profit was only about $5,500 against a $31,400 plan.

Extra volume added about $9,900 to profit. But discounts removed roughly $21,000, and higher shipping cost per order removed another $9,000. Smaller effects complete the reconciliation.

Those figures explain the financial gap. They don’t prove the promotion caused every change in customer behavior.”

1:40–2:50 · Why I chose Option B

Stay on Q4 scenarios. Select Base and show the offer comparison.

“Next, I compared all 3 offers under base, upside, and downside assumptions.

In the base case, quarterly operating profit was about $9,000 for the current promotion, $49,000 for Option B, the price and shipping reset, and $51,000 for Option C, the bundle.

These are estimates. For example, the reset assumes 10% fewer orders.”

Switch to Decision. Show the bundle substitution comparison. Pause briefly before continuing.

“Based on profit alone, the bundle looked best. But its lead was only about $2,200 before rounding.

We then asked: what if customers who already planned to buy both bears switched to the cheaper bundle? In that test, the bundle’s profit fell below the reset.

The case’s competitor examples also showed Nightlight’s delivered gift set at $48, versus $49 for our bundle. Those fictional snapshots provided context, not proof of demand.

That is why I changed my recommendation to pilot Option B before scaling.”

2:50–3:25 · Inventory and cash

Open Inventory & cash. Show Base, then Upside.

“I also checked whether the business could fund the offers.

Base-case inventory purchases were $36,400 for the reset, versus $48,000 for the bundle.

In the bundle’s upside case, the supplier deposit pushed cash below the reserve, and key products ran out before replenishment arrived. The cash timing assumptions need confirmation before launch.”

3:25–4:00 · Recommendation and deliverable

Return to Decision. Show the pilot steps and supporting workbook.

“My recommendation is to pilot the price and shipping reset, then test the bundle against it before scaling.

I would track contribution per visitor to see whether better margins offset fewer purchases, while monitoring inventory and cash.

The deliverable is this dashboard and supporting workbook, with editable formulas, source references, and reconciliation checks.

AI helped test the evidence. My judgment was to change my initial hypothesis when the numbers showed that the bundle’s advantage was fragile.”

Record your own voice over the finished dashboard. The workbook and competitor evidence are available from Downloads. No AI-generated voiceover is required.