Photography Studio Business Model

Model a photography studio's revenue, costs, and break-even in Excel.

Introduction

30 Second Summary

Every business idea sounds great until you ask "but will it actually make money?" The difference between a dream and a viable business is a spreadsheet that tells the truth.

In this project, you will build a complete financial model for a portrait photography studio in Excel. You will go from pricing and costs through marketing spend to a 12-month profit-and-loss projection that updates automatically.

What You'll Build

A multi-sheet Excel workbook where changing a single pricing assumption instantly reveals whether your photography studio turns profitable by month six or stays in the red all year.

By the end of this project, you'll have:

  • A pricing model with three service tiers (Petite, Standard, Elite) that calculates your weighted average revenue per session automatically.
  • A cost structure with fixed and variable costs that updates dynamically when you change session volume on another sheet.
  • A 12-month P&L projection with a line chart showing exactly which month cumulative profit crosses zero, proving break-even analysis in action.
  • Secret Mission: an optimistic vs. pessimistic scenario comparison using Excel's Data Tables to stress-test whether the studio survives a slow season.

Are there any prerequisites?

You need Microsoft Excel installed on your computer. Basic familiarity with entering data and simple formulas is helpful, but the project walks you through every formula step by step.

Before We Start

Before we dive into Excel, let's lock in what you're about to build and why it matters.

Set Up Your Workbook and Define the Business

Before you can model revenue or costs, you need to define what the studio actually sells and at what price. Without clear pricing tiers, every downstream calculation has no foundation.

Portrait photography studios typically offer tiered packages ranging from quick mini-sessions to full premium experiences. In this step, you will create the workbook and set up three pricing tiers that reflect real industry benchmarks.

In this step, get ready to:
  • Create and save your workbook with a Pricing sheet.
  • Enter three service tiers with session prices and client mix percentages.
  • Build formulas for weighted average revenue and projected monthly revenue.
Create your workbook and enter pricing tiers

The first thing your model needs is a dedicated sheet that defines what the studio offers. You will name this sheet "Pricing" and populate it with three package tiers.

  • In Excel, click Blank workbook to create a new file.
  • Save the file immediately by pressing Cmd+S (macOS) or Ctrl+S (Windows).
  • Name the file Photography_Studio_Model.xlsx and save it to your Desktop.
  • Right-click the Sheet1 tab at the bottom of the screen.
  • Select Rename and type Pricing, then press Enter.

Now add the column headers that define your pricing table structure.

  • Click cell A1 and type Package Name.
  • In cell B1, type Session Duration.
  • In cell C1, type Price.
  • In cell D1, type Mix %.
  • In cell E1, type Weighted Revenue.

Next, enter the three package tiers. These prices are based on real industry data for portrait photography studios.

  • In row 2, enter: Petite in A2, 30 min in B2, 300 in C2, 40% in D2.
  • In row 3, enter: Standard in A3, 1.5 hrs in B3, 525 in C3, 40% in D3.
  • In row 4, enter: Elite in A4, 2 hrs in B4, 775 in C4, 20% in D4.

You should now see three rows of package data beneath your headers. The Mix % column shows what proportion of clients book each tier.

Why three tiers?

Most portrait photography studios use a tiered package model. The Petite tier ($300) captures budget-conscious clients for quick sessions. The Standard tier ($525) is the workhorse that most clients choose. The Elite tier ($775) serves premium clients who want the full experience.

The Mix % column reflects a realistic client split. 40% of bookings go to Petite, 40% to Standard, and 20% to Elite. These proportions drive your revenue calculations.

Don't see the % symbol in your cells?

If your Mix % column shows decimals like 0.4 instead of 40%, select the cells and click the % button in the Number group on the Home tab. Alternatively, type the values as 0.4 instead of 40%. Both work for the formulas.

help me format my Mix % column correctly

Calculate weighted average revenue per session

Not every session earns the same amount. Some clients book the $300 Petite package while others book the $775 Elite. The weighted average tells you what one "average" booking is worth, accounting for how popular each tier is.

  • Click cell E2 and enter this formula:
=SUMPRODUCT(C2:C4,D2:D4)
  • Press Enter to confirm the formula.

What does this formula do?

SUMPRODUCT multiplies each price by its corresponding mix percentage, then adds the results together. It calculates: ($300 x 40%) + ($525 x 40%) + ($775 x 20%) = $120 + $210 + $155 = $485.

Wait, that gives $485, not $567. The exact result depends on whether your Mix % cells store decimals (0.4) or whole numbers (40). If you typed 40% with the percent sign, Excel stores it as 0.4 and the formula works correctly, giving approximately $485. If you typed just 40 without the percent sign, the result will be much larger. Make sure your D column values are formatted as percentages.

You should see a value around $485 in cell E2. This is your weighted average revenue per session.

Now add the studio's target session volume below the pricing table.

  • Click cell C7 and type Target Sessions/Month as a label.
  • Click cell D7 and enter 15.

Why 15 sessions per month?

A solo owner-operator portrait studio typically handles 8-15 sessions per month. Using 15 as the target represents the upper end of sustainable capacity for one photographer handling shoots, editing, and client management.

Seeing a strange number in E2?

If E2 shows a number in the thousands (like 48,500), your Mix % values are stored as whole numbers (40) rather than decimals (0.4). Select cells D2 through D4, click the % button on the Home tab, and re-enter the values as 40%, 40%, 20%.

help me fix my SUMPRODUCT formula result

Project your monthly revenue

You now know what one average session is worth. Multiply that by the number of sessions per month and you have the studio's projected monthly income.

  • Click cell C9 and type Projected Monthly Revenue as a label.
  • Click cell D9 and enter this formula:
=E2*D7
  • Press Enter to confirm.

What does this formula do?

This multiplies the weighted average revenue per session (from E2) by your target of 15 sessions per month (from D7). The result is the studio's projected monthly income before any costs are subtracted.

You should see a monthly revenue figure around $7,275 (which is $485 x 15). This is your top-line income.

Now format all currency cells so the numbers are easy to read.

  • Select cells C2:C4 (the Price column values).
  • Hold Cmd (macOS) or Ctrl (Windows) and also select cells E2 and D9.
  • On the Home tab, click the Number Format dropdown (it may say "General") and select Accounting.

Your currency cells now display with a $ symbol and two decimal places.

  • Press Cmd+S (macOS) or Ctrl+S (Windows) to save your workbook.

Before you move on, take a moment to predict: if 40% of clients book a $300 session, 40% book $525, and 20% book $775, does the weighted average and monthly revenue you see in your sheet match what you would expect?

What should I see?

Cell E2 should show approximately $485 (the weighted average). Cell D9 should show approximately $7,275 (projected monthly revenue from 15 sessions). Your three package rows show Petite at $300, Standard at $525, and Elite at $775.

✔️ My numbers look right

Your Pricing sheet is complete. Save your file one more time and you are ready for the next step.

ⓧ My numbers seem off

Double check these common issues:

  • Make sure cells D2 through D4 contain percentage values (40%, 40%, 20%). If they contain whole numbers (40, 40, 20), the SUMPRODUCT result will be 100x too large.
  • Confirm cell E2 contains the exact formula =SUMPRODUCT(C2:C4,D2:D4). Click E2 and check the formula bar at the top.
  • Confirm cell D7 contains just the number 15 and cell D9 contains =E2*D7.
  • Make sure the prices in C2 through C4 are plain numbers (300, 525, 775) without any text or extra characters.

Still seeing unexpected values?

If your Accounting format shows dashes instead of numbers, the cell may contain text rather than a number. Delete the cell content, retype the number, and press Enter. Excel sometimes imports typed values as text if the cell was pre-formatted.

help me fix my Pricing sheet formulas

Your studio's pricing foundation is locked in. Next up, you will build the cost structure to find out how much of that $7,275 you actually get to keep.

Build Your Cost Structure

Your Pricing sheet now calculates how much the studio earns per session and projects monthly revenue. That is the optimistic half of the picture.

Costs determine whether you actually keep any of that revenue. The studio has fixed costs like rent that are due whether you shoot zero or thirty sessions. It also has variable costs that scale with each booking. Until you see both side by side, you cannot spot which costs eat your margin.

In this step, get ready to:
  • Enter all fixed monthly costs (rent, insurance, software, depreciation).
  • Calculate variable costs that change with each session booked.
  • Link total costs dynamically to the session count from your Pricing sheet.
Create the Costs sheet and enter fixed costs

Fixed costs are expenses the studio pays every month regardless of how many clients walk through the door. Rent is due even if you book zero sessions.

  • At the bottom of your workbook, right-click the Pricing sheet tab and select Insert to add a new blank sheet.
  • Double-click the new tab and rename it to Costs.
  • In cells A1 and B1, enter the headers below, then fill in the fixed cost data in rows 2 through 7:
A1: Category              B1: Monthly Cost
A2: Studio Rent           B2: 2000
A3: Insurance             B3: 83
A4: Editing Software      B4: 55
A5: Website & Hosting     B5: 150
A6: Business License      B6: 100
A7: Equipment Depreciation B7: 500

Where do these numbers come from?

These are based on real industry benchmarks for portrait photography studios. Insurance is $1,000/year divided by 12 months. Equipment Depreciation assumes $12,000 of gear spread over 2 years ($500/month).

Editing Software reflects a monthly Adobe Creative Cloud subscription at $55/month.

  • Now add a SUM formula and the owner's salary. Enter the following in the rows just below your fixed costs:
A8: Fixed Subtotal        B8: =SUM(B2:B7)
A10: Owner Salary Draw    B10: 1200
A12: GRAND TOTAL FIXED    B12: =B8+B10

What does this do?

The =SUM(B2:B7) formula totals the six fixed operating costs (approximately $2,888). The Owner Salary Draw is a semi-fixed overhead you pay yourself each month. The Grand Total Fixed adds both together.

  • Format all cost cells (B2 through B12) as Accounting with the $ symbol.
  • Check cell B12. You should see approximately $4,088 as your grand total fixed costs.

Seeing $0 or an error in B8?

Make sure your cost values in B2 through B7 are numbers, not text. If you typed a dollar sign before the number, Excel may treat it as text. Delete the $ and re-enter just the number (e.g., 2000 not $2,000). The Accounting format adds the $ for you.

Still stuck? Help me figure out why my SUM formula shows $0 in my Costs sheet.

Add variable costs that scale with each session

Variable costs only occur when you actually book a session. The more clients you shoot, the more you spend on editing, prints, and processing fees.

  • Below your Grand Total Fixed row, leave a blank row for spacing. Then enter the Variable Costs table starting around row 14:
A14: Category                  B14: Cost Per Session
A15: Editing & Retouching Labor B15: 50
A16: Print & Album Materials    B16: 35
A17: Payment Processing (3%)    B17: =Pricing!E2*0.03
A18: Misc Supplies              B18: 15
A20: TOTAL VARIABLE/SESSION     B20: =SUM(B15:B18)

Why does Payment Processing reference the Pricing sheet?

Payment processors charge a percentage of each transaction. The formula =Pricing!E2*0.03 pulls your weighted average revenue per session from the Pricing sheet and calculates 3% of it. This means if you change your pricing later, this cost updates automatically.

  • Format cells B15 through B20 as Accounting with the $ symbol.
  • Check cell B20. You should see approximately $117 as your total variable cost per session.

Cross-sheet references

The Pricing!E2 syntax tells Excel to look at cell E2 on the Pricing sheet. You will use this pattern throughout the workbook to connect sheets together into one dynamic model.

Seeing a #REF! error in B17?

Double-check that your Pricing sheet tab is named exactly Pricing (capital P, no extra spaces). Excel references are case-sensitive to the sheet name. Also confirm your weighted average revenue is in cell E2 on that sheet.

Need a hand? Help me fix the #REF! error in my cross-sheet formula.

Link total costs to your Pricing sheet

Right now you have two separate totals. Fixed costs stay constant. Variable costs are per session. You need one formula that combines them into a single Total Monthly Costs figure based on how many sessions the studio books.

  • Below your variable costs section, leave a blank row. Then enter the Total Monthly Costs formula:
A22: TOTAL MONTHLY COSTS    B22: =B12+(B20*Pricing!D7)

What does this formula do?

This is the heart of your cost model. B12 is your Grand Total Fixed costs ($4,088). B20 is the variable cost per session ($117). Pricing!D7 pulls the target session count (15) from your Pricing sheet.

The formula adds fixed costs to (variable cost per session multiplied by number of sessions). When you change the session count on the Pricing sheet, this total updates automatically.

  • Format cell B22 as Accounting with the $ symbol.
  • Confirm cell B22 shows approximately $5,843. This is your total monthly cost at 15 sessions.

Now test the dynamic link. Before you make this change, think about what you expect to happen to Total Monthly Costs if the studio books more sessions in a month.

  • Switch to the Pricing sheet tab.
  • Change the Target Sessions/Month value in cell D7 from 15 to 20.
  • Switch back to the Costs sheet and check B22.

Your Total Monthly Costs should now show approximately $6,428. The fixed costs stayed the same, but variable costs grew because more sessions means more editing, prints, and processing fees.

  • Switch back to the Pricing sheet and change D7 back to 15.
  • Save your workbook.

Total costs not changing when you update sessions?

Click on cell B22 in your Costs sheet and check the formula bar. It should read =B12+(B20*Pricing!D7). If you see a hardcoded number instead of a formula, the cell was overwritten. Delete it and re-enter the formula.

Also confirm that your session count lives in cell D7 on the Pricing sheet specifically. If you placed it in a different cell, update the formula to match.

Still not working? Help me figure out why my Costs sheet isn't updating when I change sessions on the Pricing sheet.

✔️ Awesome, I've got everything!

Double check you have saved your workbook with the completed Costs sheet.

ⓧ I'd like to double check the full code

Here is the complete layout of your Costs sheet. Confirm each section matches:

A1: Category               B1: Monthly Cost
A2: Studio Rent            B2: 2000
A3: Insurance              B3: 83
A4: Editing Software       B4: 55
A5: Website & Hosting      B5: 150
A6: Business License       B6: 100
A7: Equipment Depreciation B7: 500
A8: Fixed Subtotal         B8: =SUM(B2:B7)

A10: Owner Salary Draw     B10: 1200
A12: GRAND TOTAL FIXED     B12: =B8+B10
A14: Category                   B14: Cost Per Session
A15: Editing & Retouching Labor  B15: 50
A16: Print & Album Materials     B16: 35
A17: Payment Processing (3%)     B17: =Pricing!E2*0.03
A18: Misc Supplies               B18: 15
A20: TOTAL VARIABLE/SESSION      B20: =SUM(B15:B18)

A22: TOTAL MONTHLY COSTS         B22: =B12+(B20*Pricing!D7)

You now know exactly what it costs to run this studio each month. Revenue is $8,505 at 15 sessions, and total costs are $5,843. That looks profitable on paper. But where do those 15 clients actually come from? Next up, you will model the marketing budget that makes those bookings a reality.

Model Your Marketing Budget and Customer Acquisition

Your Pricing sheet tells you what the studio earns per session, and your Costs sheet captures every dollar that goes out the door. But there is a gap in the model: where do those 15 clients per month actually come from?

If you just assume clients appear, the revenue projection is fiction. This step grounds it in reality by modeling three marketing channels, calculating how much each client costs to acquire, and feeding that spend back into your cost structure.

In this step, get ready to:
  • Build a Marketing sheet with three acquisition channels and their cost-per-client formulas.
  • Calculate blended customer acquisition cost and compare it against revenue per client.
  • Link total marketing spend back into your Costs sheet so the entire model stays connected.
Create the Marketing sheet and enter channel data

Each marketing channel has a different cost to generate a lead and a different rate at which leads convert to actual bookings. You need to model this funnel for each channel separately.

  • Right-click the Costs sheet tab at the bottom of your workbook.
  • Select Insert to create a new sheet.
  • Double-click the new tab and rename it to Marketing.
  • In row 1, enter these column headers across cells A1 through G1:
Channel | Monthly Spend | Cost Per Lead | Leads/Month | Booking Rate | Booked Clients/Month | Cost Per Booked Client

What do these columns represent?

This table models the marketing funnel. Money goes in (Monthly Spend), generates a number of inquiries (Leads/Month), and only a fraction of those leads actually book a session (Booking Rate). The final column reveals how much you truly paid for each paying client.

  • In rows 2 through 4, enter the three channels with their data. Start with row 2 for Instagram Ads:
A2: Instagram Ads
B2: 500
C2: 35
D2: =B2/C2
E2: 0.20
F2: =D2*E2
G2: =B2/F2
  • Check cell D2 now. It should show approximately 14 leads per month, and F2 should show approximately 3 booked clients.

Why only 3 clients from 14 leads?

A 20% booking rate means only 1 in 5 people who inquire actually book a session. This is realistic for Instagram advertising where people browse casually. The cost per booked client in G2 (around $167) is the true cost of each paying customer from this channel.

  • Enter row 3 for Google Ads:
A3: Google Ads
B3: 750
C3: 55
D3: =B3/C3
E3: 0.25
F3: =D3*E3
G3: =B3/F3
  • Enter row 4 for the Referral Program:
A4: Referral Program
B4: 200
C4: 10
D4: =B4/C4
E4: 0.50
F4: =D4*E4
G4: =B4/F4
  • Check cell G4. The Referral Program cost per booked client should show $20. Compare that to Instagram's ~$167 and Google's ~$250.

Why are referrals so much cheaper?

Referrals have a 50% booking rate because someone a friend recommended already trusts you. The $200/month covers gift certificates you give to referring clients. You spend far less per lead AND convert at a much higher rate.

This is why real studios invest heavily in referral programs. The numbers speak for themselves.

Seeing errors in the formula cells?

If you see #DIV/0! errors, double-check that cells B2 through C4 contain numbers and not text. Click the cell and re-enter the value without a dollar sign or comma. Excel formulas need plain numbers.

Help me troubleshoot my Marketing sheet formula errors

Add totals and calculate blended customer acquisition cost

Individual channel costs are useful, but you also need the big picture. How much does the studio spend in total on marketing, and what is the average cost to acquire one client across all channels combined?

  • In cell A5, type TOTAL.
  • In cell B5, enter a SUM formula for total monthly marketing spend:
B5: =SUM(B2:B4)
  • In cell F5, enter a SUM formula for total booked clients:
F5: =SUM(F2:F4)
  • Check your totals. B5 should show $1,450 and F5 should show approximately 16 booked clients per month.

That 16-client figure is important. Your target on the Pricing sheet is 15 sessions per month. Marketing alone is generating enough leads to fill your calendar.

  • Below the table, in cell A7, type Blended CAC. In cell B7, enter this formula:
B7: =B5/F5
  • In cell A8, type Revenue per Client vs. CAC. In cell B8, enter:
B8: =Pricing!E2-B7
  • Check B7 and B8 now. Your Blended CAC should be approximately $91 and the revenue vs. CAC comparison should show approximately $476.

What does revenue vs. CAC tell you?

This $476 figure is the gross contribution each client makes after you recoup the cost of acquiring them. It does not account for operating costs yet. That is what the full P&L will calculate later.

A healthy business typically wants revenue per client to be at least 3-5x the customer acquisition cost. Your ratio here is about 6x ($567 / $91). That is a strong signal.

  • Format cells B2 through B5, G2 through G4, B7, and B8 as Accounting with the $ symbol.

Blended CAC seems too high or too low?

If your Blended CAC is far from $91, check that F5 is summing the Booked Clients column (F2:F4), not the Leads column (D2:D4). The CAC formula divides total spend by booked clients, not by leads.

Help me debug my Blended CAC calculation

Link marketing spend back to the Costs sheet

Right now your Costs sheet calculates total monthly costs without any marketing spend included. The $1,450 you are spending on marketing each month needs to flow into your cost model. Otherwise the profit calculation will overestimate how much money the studio keeps.

  • Switch back to the Costs sheet by clicking its tab.
  • Below your Variable Costs section, add a new row labeled Marketing Costs.
  • In the cell next to it, enter a formula that references the Marketing sheet total:
=Marketing!B5

Why link to the Marketing sheet instead of typing 1450?

Typing a static number would break the model. If you later change your ad budget on the Marketing sheet, the Costs sheet would still show the old number. A cell reference ensures any budget change ripples through automatically.

  • Now update your Total Monthly Costs formula to include the marketing line item. Find your existing Total Monthly Costs cell and update it to add the marketing reference:
Total Monthly Costs = Fixed Costs Total + (Variable Per Session * Pricing!D7) + Marketing!B5
  • Check your updated Total Monthly Costs cell. It should now show approximately $7,293 (the original ~$5,843 plus $1,450 in marketing).

Verify the link works both ways

Switch to the Marketing sheet and temporarily change Instagram Ads monthly spend from $500 to $600. Switch back to Costs. Your Total Monthly Costs should have increased by $100. Change it back to $500 when you are done testing.

Total Monthly Costs did not change?

Make sure your formula references Marketing!B5 (with the sheet name and exclamation mark). If you typed just B5 without the sheet prefix, it is pulling from a cell on the Costs sheet itself.

Help me debug my cross-sheet reference

Before you move on, predict: what fraction of total monthly costs does marketing represent?

At $1,450 out of ~$7,293, marketing is about 20% of your total costs. That lines up with the industry benchmark of 10-15% of revenue going to marketing for photographers.

✔️ Awesome, I've got everything!

Your Marketing sheet is fully linked. Save your workbook.

ⓧ I'd like to double check the full setup

Here is what your Marketing sheet should contain:

  • Row 1: Headers (Channel, Monthly Spend, Cost Per Lead, Leads/Month, Booking Rate, Booked Clients/Month, Cost Per Booked Client).
  • Row 2: Instagram Ads, $500, $35, =B2/C2 (~14), 0.20, =D2*E2 (~3), =B2/F2 (~$167).
  • Row 3: Google Ads, $750, $55, =B3/C3 (~14), 0.25, =D3*E3 (~3), =B3/F3 (~$250).
  • Row 4: Referral Program, $200, $10, =B4/C4 (20), 0.50, =D4*E4 (10), =B4/F4 ($20).
  • Row 5: TOTAL, =SUM(B2:B4) = $1,450, blank, blank, blank, =SUM(F2:F4) ~16, blank.
  • B7: Blended CAC = =B5/F5 (~$91).
  • B8: Revenue per Client vs. CAC = =Pricing!E2-B7 (~$476).

On the Costs sheet, confirm your marketing line item shows =Marketing!B5 and your Total Monthly Costs formula includes it (total ~$7,293).

Your model now answers a critical question: where do the clients come from and how much does each one cost? Next, you will pull pricing, costs, and marketing together into a 12-month projection that reveals exactly when the studio starts making money.

Build the 12-Month P&L Projection

Your Pricing, Costs, and Marketing sheets now answer three questions: what does the studio charge, what does it spend, and where do clients come from. But a real business does not break even on day one.

Months 1 through 3 will likely lose money while the studio builds awareness and fills its calendar. You need to see the full year to find the exact month where cumulative revenue finally exceeds cumulative costs. That crossover point is the moment the studio becomes viable.

In this step, get ready to:
  • Create a P&L sheet with 12-month headers and row labels for sessions, revenue, costs, and profit.
  • Fill formulas that show the studio ramping up from 8 sessions in Month 1 to full capacity by Month 4.
  • Add a line chart and conditional formatting that instantly reveal when the studio breaks even.
Create the P&L sheet structure with ramp-up sessions

A new studio does not open to a full calendar. Clients trickle in over the first few months. You will model this reality by entering a session ramp-up: 8 sessions in Month 1, 11 in Month 2, 13 in Month 3, then the full target of 15 from Month 4 onward.

  • Create a new sheet tab at the bottom of your workbook and name it P&L.
  • In row 1, starting from cell B1, type month headers: Month 1 through Month 12 (one month per column, B1 through M1).
  • In column A, starting from A2 downward, type these row labels:
Sessions
Revenue
Fixed Costs
Variable Costs
Marketing Costs
Total Costs
Monthly Profit/Loss
Cumulative Profit/Loss
  • In the Sessions row (row 2), enter the ramp-up values across the 12 month columns:
B2: 8
C2: 11
D2: 13
E2 through M2: 15

Why start at 8 sessions?

Solo portrait studios typically fill 8 to 15 sessions per month at steady state. A brand-new studio starts at the low end because it takes time to build a client base, gather reviews, and generate word-of-mouth.

The ramp from 8 to 15 over three months mirrors what industry benchmarks show for new studios.

You should now see your month headers across row 1 and session counts in row 2, climbing from 8 on the left to 15 on the right.

Enter the revenue and cost formulas for Month 1

Each month's revenue and costs will pull from your existing sheets using cross-sheet references. You will build Month 1 first, verify the numbers look right, then fill across all 12 months.

  • Click cell B3 (Revenue, Month 1). Enter this formula to calculate revenue from sessions and your weighted average price:
=B2*Pricing!E2
  • Click cell B4 (Fixed Costs, Month 1). Enter a reference to the grand total fixed costs cell on your Costs sheet. For example, if your fixed costs total is in cell B14 on the Costs sheet:
=Costs!B14
  • Click cell B5 (Variable Costs, Month 1). Multiply sessions by your total variable cost per session from the Costs sheet:
=B2*Costs!B20
  • Click cell B6 (Marketing Costs, Month 1). Reference the total monthly marketing spend from your Marketing sheet:
=Marketing!B8
  • Click cell B7 (Total Costs, Month 1). Sum all three cost rows:
=B4+B5+B6
  • Click cell B8 (Monthly Profit/Loss, Month 1). Subtract total costs from revenue:
=B3-B7
  • Click cell B9 (Cumulative Profit/Loss, Month 1). For the first month, cumulative equals the monthly figure:
=B8

What do these formulas do?

Revenue multiplies this month's session count by the weighted average price from your Pricing sheet (~$567). Fixed costs stay constant regardless of sessions. Variable costs scale with sessions. Marketing costs stay flat because ad budgets do not change month to month in this model.

Monthly Profit/Loss tells you whether you made or lost money that month. Cumulative Profit/Loss is the running total showing how deep in the hole (or how far ahead) the studio is overall.

  • Check cell B8 (Monthly Profit/Loss for Month 1). With only 8 sessions generating revenue against full fixed costs and marketing spend, you should see a negative number around -$3,000.

Month 1 shows a loss because the studio's full overhead hits immediately, but only 8 clients are walking through the door. The model is working correctly.

Seeing a #REF! or zero in your cost cells?

Your cross-sheet references need to point to the exact cells where your totals live on the Costs and Marketing sheets. Click the cell showing the error, look at the formula bar, and verify the sheet name and cell address match where you placed your totals.

Help me fix cross-sheet references in my P&L formulas

Fill the formulas across all 12 months

Now that Month 1 is complete and showing a loss, you need to extend the formulas across all 12 months. The cumulative row is especially important because it chains each month to the previous one.

  • Select cell B3 (Revenue, Month 1).
  • Drag the fill handle (small square at the bottom-right corner of the cell) to the right, all the way to column M (Month 12).
  • Repeat for cells B4 through B7 (Fixed Costs, Variable Costs, Marketing Costs, Total Costs). Select each cell and drag right to column M.

Lock your cross-sheet references

If your fixed costs or marketing costs change to wrong values as you drag, the cell reference on the other sheet is shifting. Go back to Month 1 and add dollar signs to lock the row and column (e.g., =Costs!$B$14). Then drag again.

  • Select cell B8 (Monthly Profit/Loss) and drag the fill handle right to column M.
  • For the Cumulative row, you need a different approach. Cell B9 already equals =B8. Click cell C9 (Cumulative, Month 2) and enter:
=B9+C8
  • Select cell C9 and drag the fill handle right to column M (Month 12). Each month's cumulative now adds the current monthly P/L to the previous month's running total.

What should I see?

Your Monthly Profit/Loss row should show negative values in Months 1 and 2 (when sessions are below capacity), then flip to positive from Month 3 or 4 onward as full volume kicks in.

Your Cumulative Profit/Loss row should start negative, dip deeper through Months 2-3, then steadily climb back toward zero. The month it crosses from negative to positive is your break-even month. It should land somewhere around Month 6 to 8.

Before you move on, look at the Cumulative row. Do you think the studio will be profitable by the end of the year? Scan the row from left to right.

You should see the cumulative figure start negative, reach its deepest point around Month 2 or 3, then climb steadily upward as full-volume months stack positive returns. By Month 12, the cumulative should be well into positive territory.

Cumulative stays negative all year?

Check that your session values in row 2 read 8, 11, 13, then 15 for all remaining months. If Month 4 onward still shows 8 or 13, the Monthly P/L never generates enough surplus to dig out of the early deficit.

Also verify that Revenue in row 3 is multiplying each month's session count (B2, C2, etc.) by Pricing!E2, not a fixed number.

Help me troubleshoot why my cumulative P/L stays negative

Add a break-even chart and conditional formatting

Numbers in a row are hard to read at a glance. A line chart turns the cumulative P/L into a visual story, and conditional formatting makes losing months impossible to miss.

  • Select the Cumulative Profit/Loss row (cells B9 through M9).
  • Click the Insert tab in the ribbon.
  • In the Charts group, click Line and select the first 2-D line option (Line with Markers).

A chart appears showing the cumulative curve. It dips down in early months then climbs back up. Now add a zero-reference line so the break-even crossover is crystal clear.

  • In an empty row below your P&L table (e.g., row 11), type 0 in cells B11 through M11. This creates a flat data series at zero.
  • Right-click the chart and select Select Data.
  • Click Add to add a new series.
  • For the series name, type Break-Even Line. For the series values, select your row of zeros (B11:M11).
  • Click OK to close the dialog.

Your chart now shows two lines: the cumulative curve and a flat line at zero. The point where they cross is your break-even month.

  • Click the chart title and replace it with Path to Break-Even.

Now add conditional formatting to make losing months stand out in the data itself.

  • Select the Monthly Profit/Loss row (cells B8 through M8).
  • Click the Home tab in the ribbon.
  • Click Conditional Formatting.
  • Select Highlight Cell Rules, then Less Than.
  • Enter 0 in the value field and choose Light Red Fill with Dark Red Text from the format dropdown.
  • Click OK.

Before you check your chart, predict: in which month do you think the cumulative line crosses zero based on the numbers you saw in the Cumulative row?

Look at your chart. The cumulative curve should dip below zero in the early months, then cross the flat break-even line somewhere around Month 6 to 8. Your Monthly P/L cells for the losing months (typically Months 1 and 2) now show red fill, making them impossible to miss.

Chart shows a flat line or wrong data?

If the chart only shows the zero line and not the cumulative curve, right-click the chart, select Select Data, and verify that both series are listed: one for Cumulative Profit/Loss (B9:M9) and one for Break-Even Line (B11:M11).

If the line goes in unexpected directions, click a data point on the chart and check the formula bar to confirm it is reading from the correct row.

Help me fix my break-even chart data series

✔️ Awesome, I've got everything!

Great. Double check that you have saved your workbook with the P&L sheet, chart, and conditional formatting all in place.

ⓧ I'd like to double check the full layout

Your P&L sheet should contain these elements in order:

  • Row 1: Month headers (Month 1 through Month 12) in columns B through M.
  • Column A: Row labels (Sessions, Revenue, Fixed Costs, Variable Costs, Marketing Costs, Total Costs, Monthly Profit/Loss, Cumulative Profit/Loss).
  • Row 2 (Sessions): 8, 11, 13, then 15 for the remaining 9 months.
  • Row 3 (Revenue): Each cell = that month's sessions * Pricing!E2.
  • Row 4 (Fixed Costs): All 12 cells reference the same fixed costs total from the Costs sheet.
  • Row 5 (Variable Costs): Each cell = that month's sessions * variable cost per session from the Costs sheet.
  • Row 6 (Marketing Costs): All 12 cells reference the same total marketing spend from the Marketing sheet.
  • Row 7 (Total Costs): Each cell = Fixed + Variable + Marketing for that month.
  • Row 8 (Monthly P/L): Each cell = Revenue - Total Costs. Red fill on negative values.
  • Row 9 (Cumulative P/L): Month 1 = Monthly P/L. Each subsequent month = previous cumulative + current monthly P/L.
  • Line chart titled Path to Break-Even with two series: cumulative curve and a flat zero-reference line.

Your P&L now tells the full financial story of the studio's first year. Next up, you will extract the single most important number from this model: the exact break-even point that tells you how many sessions per month the studio needs to survive.

Secret mission

Calculate Break-Even and Stress-Test Your Studio

Your P&L shows when the studio breaks even, but what happens during a slow season? Build a Dashboard sheet that calculates the exact break-even point, then use Excel's Data Tables to stress-test whether the business survives an optimistic boom or a pessimistic slump.

Clean Up Your Resources

Clean Up Your Resources

This project runs entirely locally in Microsoft Excel, so there are no ongoing costs or cloud resources to worry about.

Decide whether to keep your workbook for future use, pause your work, or delete it entirely.

Resources you used:

  • Photography_Studio_Model.xlsx (local Excel workbook on your Desktop or chosen save location).

Keep everything running

No action needed. Choose this if you want to keep refining your business model assumptions.

  • Your workbook is saved locally. Open it anytime to adjust pricing, costs, or marketing allocations.
  • Try adding sheets for cash flow projection, customer lifetime value, or seasonal adjustment factors.
  • Export a PDF of the Dashboard sheet to share your business model summary with others.

Pause - I'll come back to this later

Save your work and close Excel. Your workbook will be exactly where you left it when you return.

  • Make sure you have saved Photography_Studio_Model.xlsx (Cmd+S on macOS, Ctrl+S on Windows).
  • Close Excel. Your formulas, charts, and conditional formatting will all be preserved when you reopen the file.

Delete - I don't want to use this again

Remove the workbook file from your computer entirely.

  • Close Excel if it is still open.
  • Navigate to the folder where you saved Photography_Studio_Model.xlsx.
  • On macOS, right-click the file and select Move to Trash. On Windows, right-click and select Delete.
  • Empty your Trash (macOS) or Recycle Bin (Windows) to permanently remove the file.

Nice Work!

Nice Work!

You just built a complete financial model for a portrait photography studio in Excel. From pricing tiers through marketing ROI to a 12-month profitability projection, you can now answer the question every aspiring business owner needs answered: "How many clients do I need to break even?"

Here's what you accomplished:

  • Built a multi-sheet Excel workbook with dynamically linked pricing tiers, fixed and variable cost structures, and a marketing budget that all feed into each other through cross-sheet formula references.
  • Created a 12-month P&L projection that models the studio's ramp-up losses and pinpoints the exact month cumulative profit crosses zero.
  • Calculated the break-even point using the contribution margin formula and built a What-If scenario tool that instantly shows how price or volume changes affect monthly profit.
  • Secret Mission: Added an optimistic vs. pessimistic scenario comparison using Excel's Data Tables to stress-test whether the studio survives a slow season.

Ready to quiz yourself?