Driver-Based Forecasting�and Financial Modeling
FIN143 · Week 4
Operating assumptions, cash needs, and forecast updates
Devon Coombs, CPA, MBA
Santa Clara University · Fall 2026
The purpose of a forecast
A forecast estimates future results from explicit operating assumptions.
Its value comes from showing what must happen, how much cash the�plan requires, and which decisions change when assumptions fail.
Compare actual results with the forecast. Explain the differences and�update the assumptions.
Forecast accuracy matters, alongside usefulness for decisions. A target�expresses an ambition. A forecast shows the results supported by its�assumptions.
FIN143 · Week 4
02
The forecasting process
FIN143 · Week 4
03
Compound growth and CAGR
A constant percentage growth rate produces changing dollar gains as�the base changes.
CAGR summarizes the constant annual rate that connects a beginning�value to an ending value. Actual annual growth can vary.
Mathematical definition. CAGR describes the endpoints, not the path between them.
FIN143 · Week 4
04
Linear and compound growth
Linear growth: Add the same dollar amount each period.
Compound growth: Apply the growth rate to the updated balance each�period.
Ending value = Beginning value × (1 + g)^n
CAGR = (Ending value ÷ Beginning value)^(1/n) − 1
Here, n is the number of elapsed years. This standard percentage�interpretation assumes positive beginning and ending values. CAGR�alone does not show volatility or explain the operating drivers.
Mathematical identities. The salary example assumes ten annual compounding intervals.
FIN143 · Week 4
05
Question: Compound growth
An employee earning $40,000 wants to reach $200,000 in 10 years.�What annual rate must they sustain?
A About 40%, since income must multiply five times
B About 16%, the simple average of the raises
C About 50%, front-loaded in the early years
D About 17.5%, the compound annual growth rate
E About 10%, one-tenth of the total increase
FIN143 · Week 4 · KNOWLEDGE CHECK
06
W4-S006
143
Easy (2/8)
Answer: Compound growth
D About 17.5%, the compound annual growth rate
WHY�($200,000 / $40,000) to the 1/10 power, minus 1, is about 17.5%.
KEY TAKEAWAY�CAGR is the constant rate that links a start and an end value over n�years.
Correct answer: D.
Case: Salary rises from $40,000 to $200,000 over ten years. Dividing�the total percentage increase by ten ignores compounding.
FIN143 · Week 4 · KNOWLEDGE CHECK
07
W4-S006
143
Easy (2/8)
Trailing twelve months
TTM, also called LTM, covers the most recent twelve months of results.
It combines a full annual cycle with more recent data than the last fiscal�year alone. It can still obscure a recent acceleration or deterioration.
Use the same metric definition and comparable periods throughout the�calculation.
FIN143 · Week 4
08
Building TTM
TTM = Last fiscal year + Current YTD − Comparable prior-year YTD
Revenue input | Amount |
Last fiscal year | $4.8M |
Add current year-to-date revenue | $1.5M |
Subtract the comparable prior-year period | ($1.1M) |
TTM revenue | $5.2M |
The subtraction removes the older overlapping months before the�newer months enter the total.
Illustrative source-deck figures. CFI: trailing twelve months
FIN143 · Week 4
09
Question: TTM revenue
Last fiscal-year revenue was $4.2 million. Current year-to-date revenue�is $1.6 million, and revenue for the comparable prior-year year-to-date�period was $1.1 million. What is trailing-twelve-month revenue?
A. $4.7 million.
B. $5.3 million.
C. $5.8 million.
D. $6.9 million.
E. $7.0 million.
FIN143 · Week 4 · KNOWLEDGE CHECK
10
W4-S010
143
Easy (2/8)
Answer: TTM revenue
Last fiscal-year revenue was $4.2 million. Current year-to-date revenue is $1.6�million, and revenue for the comparable prior-year year-to-date period was�$1.1 million. What is trailing-twelve-month revenue?
A. $4.7 million.
B. $5.3 million.
C. $5.8 million.
D. $6.9 million.
E. $7.0 million.
Correct answer: A.
$4.2M + $1.6M − $1.1M = $4.7M. Remove the old overlapping period and add�the new one.
FIN143 · Week 4 · KNOWLEDGE CHECK
11
W4-S010
143
Easy (2/8)
TTM, run rate, and NTM
Measure | What it represents | Main limitation |
TTM / LTM | Actual results for the most�recent twelve months | Can obscure an inflection�within the year |
Annualized�run rate | A recent month × 12, or�recent quarter × 4 | Assumes the selected�period repeats |
NTM | A forecast for the next�twelve months | Depends on assumptions�and execution |
Check the dates, metric definitions, seasonality, and unusual items�before comparing them. A run rate is an extrapolation, not twelve�months of realized results.
FIN143 · Week 4
12
Question: TTM and recurring run rate
KNOWLEDGE CHECK
At September 30, a startup is preparing an investor update�using these revenue figures:
Reporting period | Revenue |
Full prior calendar year | $5.70 million |
January–September of the prior year | $3.90 million |
January–September of the current year | $5.10 million |
September's recognized revenue is $780,000. That amount�includes $180,000 from a one-time implementation project�and $600,000 of recurring subscription revenue. Management�forecasts $9.40 million of revenue for the next 12 months.
For this comparison, include one-time items in historical�trailing-twelve-month (TTM) total revenue. Base the recurring�annualized run rate only on September's recurring revenue.
What are TTM total revenue through September 30 and the�recurring annualized run rate at that date?
A. TTM total revenue: $6.72�million; recurring annualized�run rate: $7.20 million.
B. TTM total revenue: $6.90�million; recurring annualized�run rate: $7.20 million.
C. TTM total revenue: $6.90�million; recurring annualized�run rate: $9.36 million.
D. TTM total revenue: $6.90�million; recurring annualized�run rate: $9.40 million.
E. TTM total revenue: $10.80�million; recurring annualized�run rate: $7.20 million.
Devon Coombs CPA, MBA | Santa Clara University | FIN143
13
W4-S013
143
Hard (6/8)
Answer: TTM and recurring run rate
KNOWLEDGE CHECK
B. TTM total revenue: $6.90 million; recurring annualized run rate: $7.20�million.
Work the calculation
TTM total revenue = $5.70m +�$5.10m − $3.90m = $6.90m.�Recurring annualized run rate�= ($0.780m − $0.180m) × 12�= $7.20m.
Historical total revenue�includes the earned one-time�project, while the specified�recurring run rate excludes it.�Neither calculation uses the�NTM forecast.
Why the other choices are wrong
A. Subtracts the implementation project from�historical TTM even though the question�requests unnormalized total revenue.
C. Annualizes all $780,000 of September�revenue, including the one-time $180,000�project.
D. Substitutes management's NTM forecast for�the requested recurring annualized run rate.
E. Adds the full prior year to current YTD without�subtracting the overlapping prior-year YTD�period.
Devon Coombs CPA, MBA | Santa Clara University | FIN143
14
W4-S013
143
Hard (6/8)
Operating drivers
Start with the operating activity that produces a result.
Examples include billable hours, active customers, units delivered,�qualified opportunities, and productive sales capacity.
Each driver needs a unit, a time period, an assumption, and supporting�evidence.
FIN143 · Week 4
15
Revenue from volume and price
Revenue = Volume delivered × Realized price per unit
For multiple products, sum the separate volume-and-price calculations.�Reflect discounts, returns, contract terms, and recognition timing.
Sales bookings, recognized revenue, and cash collections can occur in�different months.
FIN143 · Week 4
16
A consultant’s three-year forecast
Driver | Year 1 | Year 2 | Year 3 |
Billable hours per working month | 80 | 90 | 100 |
Hourly rate | $75 | $85 | $100 |
Months worked | 11 | 11 | 11 |
Annual gross revenue | $66,000 | $84,150 | $110,000 |
Annual revenue = Billable hours per working month × Hourly rate × Months�worked.
Year 2: 90 × $85 × 11 = $84,150.
The forecast requires both more billable hours and a higher realized rate. Check�capacity and customer demand for each assumption.
Illustrative source-deck figures. All three calculations verified.
FIN143 · Week 4
17
Question: Operating drivers
Which approach provides the strongest operating foundation for a�driver-based revenue forecast?
A. Revenue grows 250% because management believes that growth rate is�necessary to support the next financing valuation.
B. Bookings are built from productive sales capacity, qualified�opportunities, conversion rates, deal size, and timing assumptions.
C. Revenue equals 2% of TAM because capturing a small share of a large�market is a conservative assumption.
D. Revenue is set equal to the amount required for the company to reach�breakeven by the end of the forecast period.
E. Revenue grows at the industry growth rate because individual company�execution is too uncertain to model directly.
FIN143 · Week 4 · KNOWLEDGE CHECK
18
W4-S018
143
Easy (1/8)
Answer: Operating drivers
Which approach provides the strongest operating foundation for a�driver-based revenue forecast?
A. Revenue grows 250% because management believes that growth rate is�necessary to support the next financing valuation.
B. Bookings are built from productive sales capacity, qualified�opportunities, conversion rates, deal size, and timing assumptions.
C. Revenue equals 2% of TAM because capturing a small share of a large�market is a conservative assumption.
D. Revenue is set equal to the amount required for the company to reach�breakeven by the end of the forecast period.
E. Revenue grows at the industry growth rate because individual company�execution is too uncertain to model directly.
Correct answer: B.
FIN143 · Week 4 · KNOWLEDGE CHECK
19
W4-S018
143
Easy (1/8)
Answer: Operating drivers — explanation
Which approach provides the strongest operating foundation for a�driver-based revenue forecast?
B. Bookings are built from productive sales capacity, qualified�opportunities, conversion rates, deal size, and timing assumptions.
B supplies testable operating assumptions. Then reconcile bookings to�delivery, recognized revenue, and collections. The other choices start�with an outcome or broad growth proxy.
Correct answer: B.
FIN143 · Week 4 · KNOWLEDGE CHECK
20
W4-S018
143
Easy (1/8)
Question: Customer additions and churn
Scenario: A subscription business is preparing next year’s revenue forecast.�Management expects to begin the year with 8,000 customers, add 500�customers per month, lose 2% of customers each month, and earn an average of�$40 per customer per month. Which approach best reflects driver-based�forecasting?
A. Increase last year’s revenue by management’s expected overall growth rate.
B. Use the average revenue growth rate from the prior three years.
C. Forecast revenue from customer additions, churn, and revenue per�customer.
D. Use the most recent month’s revenue and annualize it for twelve months.
E. Forecast revenue equal to the midpoint of management’s historical�guidance range.
FIN143 · Week 4 · KNOWLEDGE CHECK
21
W4-S021
143
Easy (1/8)
Answer: Customer additions and churn
Scenario: A subscription business is preparing next year’s revenue forecast.�Management expects to begin the year with 8,000 customers, add 500�customers per month, lose 2% of customers each month, and earn an average of�$40 per customer per month. Which approach best reflects driver-based�forecasting?
A. Increase last year’s revenue by management’s expected overall growth rate.
B. Use the average revenue growth rate from the prior three years.
C. Forecast revenue from customer additions, churn, and revenue per�customer. ✓ Correct
D. Use the most recent month’s revenue and annualize it for twelve months.
E. Forecast revenue equal to the midpoint of management’s historical�guidance range.
Correct answer: C.
FIN143 · Week 4 · KNOWLEDGE CHECK
22
W4-S021
143
Easy (1/8)
Answer: Customer additions and churn — explanation
Scenario: A subscription business is preparing next year’s revenue�forecast. Management expects to begin the year with 8,000 customers,�add 500 customers per month, lose 2% of customers each month, and�earn an average of $40 per customer per month. Which approach best�reflects driver-based forecasting?
C. Forecast revenue from customer additions, churn, and revenue per�customer. ✓ Correct
Track each month’s opening customers, additions, and losses. Apply�revenue per customer using a stated billing and service-timing�convention. A single growth percentage hides those drivers.
Correct answer: C.
FIN143 · Week 4 · KNOWLEDGE CHECK
23
W4-S021
143
Easy (1/8)
Model structure and checks
Organize the workbook into assumptions, operating schedules, financial�statements, and decision outputs.
Connect profit, balance-sheet balances, and cash movements. Check�that assets equal liabilities plus equity and that beginning cash plus net�cash flows equals ending cash.
Flag missing inputs, impossible customer counts, capacity constraints,�and cash below the required floor.
FIN143 · Week 4
24
Modeling guidelines: platform, cash, and timing
Course modeling guidelines, 1–4. ICAEW: Financial Modelling Code · AFP: cash forecasting
FIN143 · Week 4
25
Modeling guidelines: drivers and evidence
Course modeling guidelines, 5–8. ICAEW: Financial Modelling Code
FIN143 · Week 4
26
Modeling guidelines: expenses, cases, and usability
A reader should be able to identify an assumption, change it, and�understand the resulting financial effect.
Course modeling guidelines, 9–11. ICAEW: Financial Modelling Code
FIN143 · Week 4
27
Question: Profit and cash
Among the eleven guidelines, why does the module insist on always�building a cash flow model?
A Because the income statement is not allowed in a model
B Because cash flow replaces the need for revenue forecasts
C Because a profitable company can still run out of cash
D Because investors never read the income statement
E Because cash flow is easier to forecast than expenses
FIN143 · Week 4 · KNOWLEDGE CHECK
28
W4-S028
143
Easy (0/8)
Answer: Profit and cash
C Because a profitable company can still run out of cash
WHY�Profit on paper does not guarantee cash; the cash flow model shows�whether the business survives.
KEY TAKEAWAY�The income statement shows profitability. The cash forecast shows�whether the company can meet payments as they come due.
Correct answer: C.
A customer can pay after revenue is earned while payroll is due earlier. C�identifies that cash-timing problem.
FIN143 · Week 4 · KNOWLEDGE CHECK
29
W4-S028
143
Easy (0/8)
Question: Model structure
A founder builds a five-year model using annual revenue growth�assumptions, hard-coded formulas, and a single base case. The model�shows accounting profit, but does not separately forecast cash balances�or operating drivers. Which change would most improve the model?
A Add more expense line items so the model appears more detailed.
B Extend the forecast to ten years to show a longer strategic horizon.
C Build monthly cash flow from operating drivers and centralized�assumptions.
D Increase the revenue growth rate to better reflect management’s�ambition.
E Replace the base case with an upside case to show investor potential.
FIN143 · Week 4 · KNOWLEDGE CHECK
30
W4-S030
143
Medium (4/8)
Answer: Model structure
A founder builds a five-year model using annual revenue growth�assumptions, hard-coded formulas, and a single base case. The model�shows accounting profit, but does not separately forecast cash balances�or operating drivers. Which change would most improve the model?
A Add more expense line items so the model appears more detailed.
B Extend the forecast to ten years to show a longer strategic horizon.
C Build monthly cash flow from operating drivers and centralized�assumptions.
D Increase the revenue growth rate to better reflect management’s�ambition.
E Replace the base case with an upside case to show investor potential.
Correct answer: C.
FIN143 · Week 4 · KNOWLEDGE CHECK
31
W4-S030
143
Medium (4/8)
Answer: Model structure — explanation
A founder builds a five-year model using annual revenue growth�assumptions, hard-coded formulas, and a single base case. The model�shows accounting profit, but does not separately forecast cash�balances or operating drivers. Which change would most improve the�model?
C Build monthly cash flow from operating drivers and centralized�assumptions.
C connects operating assumptions to cash and exposes the financing�need. Extra line items, a longer horizon, or more optimistic growth�cannot repair the missing logic.
Correct answer: C.
FIN143 · Week 4 · KNOWLEDGE CHECK
32
W4-S030
143
Medium (4/8)
Revenue schedules
Two examples show how operating assumptions produce a forecast:
After forecasting sales activity, model when service is delivered,�revenue is recognized, and cash is collected.
FIN143 · Week 4
33
Hiring, sales, and collection timing
Separate the recruiting lag, employee ramp, opportunity-to-close sales cycle,�and customer collection lag. Do not automatically add lags that overlap.
Required qualified opportunities = Target bookings ÷ (Average booked�contract value × Win rate).
Use opportunities expected to close in the target period. Match the�deal-value definition to the bookings target.
Forecast salary, benefits, employer taxes, recruiting, and equipment�separately where material.
The source’s 30–60-day hiring and engineering assumptions, 60–90-day sales�assumptions, and 1.25–1.4× salary multiplier are illustrative placeholders.�Replace them with role-specific evidence.
The numerical ranges are not verified general benchmarks. Recruiting, ramp, sales cycle, and collection lags describe different events.
FIN143 · Week 4
34
Sales capacity, bookings, and revenue
For a direct-sales business, begin with hire dates and the path to�productive capacity.
Bookings capacity = Productive rep equivalents × Contracts per�productive rep × Average contract value
Check that qualified opportunities and expected conversion can�support that capacity. Avoid counting the same productivity effect�twice.
Contract start dates and delivery terms determine the revenue�schedule. Billing terms and collection lags determine the cash schedule.
Source model adapted from Dave Lishego: The Founder’s Guide to Financial Modeling, © 2019. Bookings-to-revenue and cash reconciliation added for clarity.
FIN143 · Week 4
35
The sales headcount schedule
Schedule | Modeling treatment |
Employed reps | Hire dates, departures, and partial-month employment |
Productive rep�equivalents | Employed reps weighted by the stated ramp�assumption |
Contracts booked | Productive capacity, supported by pipeline and�conversion |
The simple classroom model assumes no sales during ramp, then full productivity.�A more detailed model can use gradual ramp and attrition.
Employment costs begin before full productivity. Sales capacity does not�establish the month revenue will be recognized.
Source model adapted from Dave Lishego: The Founder’s Guide to Financial Modeling, © 2019. Ramp convention is an illustrative assumption.
FIN143 · Week 4
36
Question: Sales ramp
A rep is hired in January with a 90-day time to productivity. When does�the model credit that rep with sales?
A Immediately in January, on the start date
B Never, until the rep is formally promoted
C In February, after one full month on the job
D Around April, once the ramp period has passed
E Only at the very end of the fiscal year
FIN143 · Week 4 · KNOWLEDGE CHECK
37
W4-S037
143
Easy (1/8)
Answer: Sales ramp
D Around April, once the ramp period has passed
WHY�With a 90-day ramp, a January hire is credited with sales around April.
KEY TAKEAWAY�Employment costs begin when the rep starts. Bookings capacity builds as�the rep ramps, while delivery and collection timing determine revenue and�cash.
Correct answer: D.
Case: A January hire has a 90-day ramp. The classroom model uses April as�the first full productive month and assumes no sales during ramp.�Recognition and collection may occur later.
FIN143 · Week 4 · KNOWLEDGE CHECK
38
W4-S037
143
Easy (1/8)
Question: Sales ramp and revenue
KNOWLEDGE CHECK
A SaaS company is forecasting first-quarter bookings and�revenue. Its sales team has two groups:
Every contract has a $24,000 annual value. Contracts close�at month-end, and customers pay the full amount�immediately. Service begins on the first day of the following�month, with revenue earned evenly over the next 12 months.
Assume no existing contracts, discounts, or cancellations.
What are total first-quarter bookings and recognized�revenue?
A. Bookings of $480,000�and recognized revenue of�$36,000.
B. Bookings of $480,000�and recognized revenue of�$76,000.
C. Bookings of $480,000�and recognized revenue of�$480,000.
D. Bookings of $528,000�and recognized revenue of�$36,000.
E. Bookings of $624,000�and recognized revenue of�$44,000.
Devon Coombs CPA, MBA | Santa Clara University | FIN143
39
W4-S039
143
Hard (7/8)
Answer: Sales ramp and revenue
KNOWLEDGE CHECK
A. Bookings of $480,000 and recognized revenue of $36,000.
Work the calculation
Experienced reps close 3 × 2 × 3 =�18 contracts. New reps add 2 × (2 ×�50%) = 2 in March, for 20 contracts�and $480,000 bookings. Each�contract earns $2,000 monthly.
January's six contracts earn two�months in Q1: $24,000. February's�six earn one month: $12,000.�March's eight begin service in April.�Q1 revenue = $36,000.
Why the other choices are wrong
B. Starts revenue in the closing month,�yielding $12,000 in January, $24,000 in�February, and $40,000 in March.
C. Equates upfront cash collections with�revenue earned during the first quarter.
D. Gives the new representatives full�March productivity rather than 50%. Those�extra March bookings would still begin�service in April.
E. Treats both new representatives as fully�productive in both February and March,�producing 6, 10, and 10 monthly contracts.
Devon Coombs CPA, MBA | Santa Clara University | FIN143
40
W4-S039
143
Hard (7/8)
The subscription MRR schedule
MRR is the monthly recurring value of active subscriptions. Ending MRR is�a point-in-time operating metric, not automatically the month’s recognized�revenue or collections.
Simple example: Ending MRR = Beginning MRR + New MRR − Churn MRR.
Full bridge: Also add expansion and reactivation, and subtract contraction.
Apply the churn rate to the measure it describes: customer churn to�customers, revenue churn to recurring revenue. They coincide only under�simplifying assumptions such as equal customer value.
For constant monthly churn c, annual loss from the starting cohort�= 1 − (1 − c)^12. At 2% monthly churn, the loss is 21.5%. At 5%, it is 46.0%.
FIN143 · Week 4
41
A three-month MRR build
Assumptions: $4,500 new MRR each month, 2% monthly revenue churn on�beginning MRR, and no expansion, contraction, or reactivation.
Monthly recurring revenue | January | February | March |
Beginning MRR | $0 | $4,500 | $8,910 |
New MRR | $4,500 | $4,500 | $4,500 |
Churn MRR | $0 | ($90) | ($178) |
Ending MRR | $4,500 | $8,910 | $13,232 |
March: $8,910 + $4,500 − $178.20 = $13,231.80, displayed as $13,232.
Carry full precision in the model. Forecast recognized revenue and collections�separately from ending MRR.
Source-deck example, adapted from Dave Lishego: The Founder’s Guide to Financial Modeling, © 2019. Amounts displayed to the nearest dollar.
FIN143 · Week 4
42
Question: Annual churn
A subscription business has 2% monthly churn. Roughly how much of its�base does it lose in a year?
A About 2%
B About 22%
C About 6%
D About 50%
E About 24%
FIN143 · Week 4 · KNOWLEDGE CHECK
43
W4-S043
143
Easy (2/8)
Answer: Annual churn
B About 22%
WHY�Retaining 98% each month, (0.98) to the 12th power, loses about 22%�over the year.
KEY TAKEAWAY�Monthly churn compounds. 2% monthly is roughly 22% a year, not 24%.
Correct answer: B.
Case: Monthly churn is 2% of the remaining starting cohort. Annual loss�= 1 − 0.98^12 = 21.53%. The 24% answer adds rates instead of�compounding retention.
FIN143 · Week 4 · KNOWLEDGE CHECK
44
W4-S043
143
Easy (2/8)
Expense schedules
Cost of revenue: Forecast hosting, support delivery, payment�processing, and other delivery costs from usage and unit costs. A�revenue percentage can be useful when supported by evidence.
Headcount and operating expenses: Use hiring dates and fully loaded�costs by function. Classify engineering, sales, marketing, and G&A�according to the company’s accounting policies.
Other spending: Separate fixed commitments from usage-based and�discretionary costs. A flat cost assumption needs support, just as a�changing margin does.
Use enough detail to expose the costs that change the decision.
Further reading: expense schedules in Dave Lishego: The Founder’s Guide to Financial Modeling, © 2019.
FIN143 · Week 4
45
Forecast assumptions that need investigation
These are reasons to investigate the model. A simple assumption can be�appropriate when evidence supports it.
FIN143 · Week 4
46
Market size and the operating forecast
TAM estimates the total addressable opportunity. SAM narrows it to the�market the business can serve. SOM estimates a realistically obtainable�portion under stated constraints.
Market size helps assess whether the opportunity fits the strategy and�financing model.
An operating forecast explains how the company wins and serves�customers. A market-share percentage alone does not establish hiring,�conversion, timing, or cash needs.
Compare the forecast with market size as a reasonableness check. Use�consistent geography, customer scope, pricing, period, and revenue�definitions.
Market-sizing definitions are planning conventions. No market-size estimate is asserted in this slide.
FIN143 · Week 4
47
The monthly cash schedule
Ending cash = Beginning cash + Customer collections + Other cash�inflows − Cash payments
Show operating payments, capital expenditures, debt service, and�financing separately.
Collection terms affect receivables. Supplier terms affect payables.�Customer prepayments create future delivery obligations. These timing�differences connect the operating forecast to the balance sheet and�cash schedule.
Track both the lowest projected cash balance and the date the�company needs funding. Use weekly detail when monthly totals could�hide a shortfall.
FIN143 · Week 4
48
Build collections from the receivables schedule
For a month with no write-offs, customer advances, or sales taxes:
Ending receivables = beginning receivables + credit sales − collections.
Illustration: receivables begin at $40,000. All $100,000 of sales are on credit and�customers pay $70,000. Ending receivables are $70,000.
With $50,000 of cash operating costs and no other accruals, profit before�depreciation and tax is $50,000, but operating cash flow is $20,000. The $30,000�receivables increase explains the gap.
Build comparable schedules for payables, inventory, deferred revenue, equipment,�and debt. Reconcile ending cash and assets = liabilities + equity.
Devon Coombs CPA, MBA | Santa Clara University | FIN143
49
Question: Forecast revenue, receivables, and cash
A monthly forecast starts with $80,000 cash and $30,000 receivables. Credit�sales are $120,000, collections are $95,000, and cash operating expenses are�$70,000. Equipment costs $40,000 cash; monthly depreciation is $4,000. There�are no other accruals, taxes, or financing flows.
Which forecast is internally consistent?
A. Profit $46,000; ending receivables $55,000; ending cash $65,000.
B. Profit $46,000; ending receivables $55,000; ending cash $61,000.
C. Profit $46,000; ending receivables $25,000; ending cash $65,000.
D. Profit $6,000; ending receivables $55,000; ending cash $65,000.
E. Profit $46,000; ending receivables $55,000; ending cash $90,000.
Devon Coombs CPA, MBA | Santa Clara University | FIN143
50
W4-S050
143
Hard (6/8)
Answer: Forecast revenue, receivables, and cash
A. Profit $46,000; ending receivables $55,000; ending cash $65,000.
Profit = $120,000 − $70,000 − $4,000 = $46,000. Receivables = $30,000 +�$120,000 − $95,000 = $55,000.
Operating cash = $46,000 + $4,000 − $25,000 = $25,000. Ending cash =�$80,000 + $25,000 − $40,000 = $65,000.
B deducts depreciation from cash again; C omits opening receivables; D expenses�CapEx in addition to depreciation; E treats credit sales as collections.
Devon Coombs CPA, MBA | Santa Clara University | FIN143
51
W4-S050
143
Hard (6/8)
Four questions for the cash plan
A milestone can support a financing case. It does not guarantee that�funding will be available.
FIN143 · Week 4
52
Drivers of enterprise value
The forecast connects operating assumptions to future cash flows and�the capital required to produce them.
Test churn, pricing, gross margin, acquisition efficiency, and growth�together with their cash costs.
A change from 2% to 3% monthly churn is a one-percentage-point�increase, or a 50% relative increase. Its cumulative effect can be�substantial.
Prioritize the assumptions that change financing needs or valuation�most. Their importance depends on the business and the range tested.
Illustrative sensitivity logic. Detailed valuation mechanics follow in Week 5.
FIN143 · Week 4
53
Burn rate and runway
Operating gross burn: Monthly operating cash payments.
Operating net burn: Operating cash payments − Operating cash receipts.�Spending $150K and collecting $50K produces $100K of net burn.
Runway to zero: Usable cash ÷ Positive monthly net burn, assuming a�constant burn rate and no other cash movements.
New financing is separate from operating burn. Include capital�expenditure, debt payments, restricted cash, and the minimum cash floor�in the full cash forecast.
An 18–24-month financing horizon is a planning heuristic. Choose timing�from milestone risk, funding lead time, and downside cash needs.
Burn conventions vary. This slide defines the convention used here. AFP: cash forecasting · Bessemer: State of the Cloud 2023
FIN143 · Week 4
54
Question: Runway
A startup holds $900,000 in cash and burns $150,000 net per month.�What is its runway?
A 3 months
B 9 months
C 12 months
D 15 months
E 6 months
FIN143 · Week 4 · KNOWLEDGE CHECK
55
W4-S055
143
Easy (2/8)
Answer: Runway
E 6 months
WHY�$900,000 divided by $150,000 per month equals 6 months.
KEY TAKEAWAY�Runway equals current cash divided by monthly net burn.
Correct answer: E.
Case: $900,000 usable cash and constant $150,000 monthly net burn.�Six months is time to zero, assuming no other cash movements. A�required cash floor would shorten the operating window.
FIN143 · Week 4 · KNOWLEDGE CHECK
56
W4-S055
143
Easy (2/8)
Cash floor and financing need
Set a cash floor from obligations, collection uncertainty, and the time�needed to respond or raise capital. There is no universal three- or�four-month reserve rule.
When cash declines through the milestone:
Financing need = max(0, Cumulative net cash use + Required ending cash�− Usable starting cash)
More generally, fund the largest projected cash shortfall relative to the�floor, at any point in the forecast.
Account for committed financing once, and include required fees or other�cash uses. An adequate milestone balance can still hide an earlier cash�shortage.
Classroom formula assumes the cash low point occurs at the milestone. General formula follows from the cash roll-forward. AFP: cash forecasting
FIN143 · Week 4
57
Question: A delayed collection
A startup begins March with $160,000 of cash and requires a $50,000�minimum cash balance. A $140,000 customer collection expected in March�moves to April, while March payroll and vendor payments of $210,000 remain�unchanged. Management also wants to spend $25,000 on a discretionary�growth experiment in March. What minimum additional financing or cost�deferral is required to maintain the cash floor and complete the experiment?
A. $75,000.
B. $100,000.
C. $125,000.
D. $140,000.
E. $235,000.
FIN143 · Week 4 · KNOWLEDGE CHECK
58
W4-S058
143
Medium (4/8)
Answer: A delayed collection
A startup begins March with $160,000 of cash and requires a $50,000�minimum cash balance. A $140,000 customer collection expected in March�moves to April, while March payroll and vendor payments of $210,000 remain�unchanged. Management also wants to spend $25,000 on a discretionary�growth experiment in March. What minimum additional financing or cost�deferral is required to maintain the cash floor and complete the experiment?
A. $75,000.
B. $100,000.
C. $125,000.
D. $140,000.
E. $235,000.
Correct answer: C.
FIN143 · Week 4 · KNOWLEDGE CHECK
59
W4-S058
143
Medium (4/8)
Answer: A delayed collection — explanation
A startup begins March with $160,000 of cash and requires a $50,000�minimum cash balance. A $140,000 customer collection expected in�March moves to April, while March payroll and vendor payments of�$210,000 remain unchanged. Management also wants to spend�$25,000 on a discretionary growth experiment in March. What minimum�additional financing or cost deferral is required to maintain the cash�floor and complete the experiment?
C. $125,000.
March ending cash before action: $160K − $210K − $25K = −$75K.�Reaching the $50K floor requires $125K. Assume no other March�receipts and timely funding or payment deferral.
Correct answer: C.
FIN143 · Week 4 · KNOWLEDGE CHECK
60
W4-S058
143
Medium (4/8)
Question: The lowest cash point
KNOWLEDGE CHECK
A startup begins May with $220,000 of usable cash. Management wants�to maintain at least $60,000 at the end of every month.
A $150,000 customer payment expected in May has been delayed until�July. The updated forecast separates that payment from other receipts:
Cash item | May | June | July |
Other operating receipts | $40,000 | $90,000 | $210,000 |
Delayed customer collection | $0 | $0 | $150,000 |
Required cash payments | $230,000 | $170,000 | $160,000 |
Management also plans to complete a $30,000 experiment in May. Its cost�is additional to the required payments in the table. Monthly depreciation of�$12,000 is a noncash expense and is not included in these cash payments.
Any new financing arrives before May's payments and is available�throughout the forecast. Assume no financing fees, repayments, or other�cash flows.
What is the smallest financing amount that allows the company to�complete the experiment and maintain the $60,000 minimum at every�month-end?
A. $60,000.
B. $80,000.
C. $110,000.
D. $140,000.
E. $200,000.
Devon Coombs CPA, MBA | Santa Clara University | FIN143
61
W4-S061
143
Hard (7/8)
Answer: The lowest cash point
KNOWLEDGE CHECK
D. $140,000.
Work the calculation
Without financing: May ending cash =�$220,000 + $40,000 − $230,000 −�$30,000 = $0. June ending cash = $0 +�$90,000 − $170,000 = −$80,000.
July ending cash = −$80,000 + $210,000�+ $150,000 − $160,000 = $120,000. The�maximum floor shortfall is in June:�$60,000 − (−$80,000) = $140,000.
With that raise, month-end balances are�$140,000, $60,000, and $260,000.�Positive July cash does not eliminate the�earlier financing need.
Why the other choices are wrong
A. Covers May's floor but ignores�the additional $80,000 cash use in�June.
B. Brings the lowest projected�balance to zero, rather than to the�required $60,000 floor.
C. Funds the cash floor while�omitting the required $30,000�experiment from the scenario.
E. Adds a second $60,000 reserve�to the $140,000 already sufficient�to preserve the stated floor.
Devon Coombs CPA, MBA | Santa Clara University | FIN143
62
W4-S061
143
Hard (7/8)
Sizing the raise
Funding calculation | Amount |
Cumulative net cash use through the milestone | $1.80M |
Add required cash remaining | $0.45M |
Subtract usable cash on hand | ($0.80M) |
Additional financing required | $1.45M |
$1.80M + $0.45M − $0.80M = $1.45M.
Check: $0.80M + $1.45M − $1.80M = $0.45M remaining.
Assume no other financing and no earlier cash low point. Financing fees�or other excluded payments would increase the requirement.
Illustrative source-deck figures. Arithmetic verified.
FIN143 · Week 4
63
Question: The gross funding request
KNOWLEDGE CHECK
A startup is deciding how much capital to raise before its�next milestone. Its forecast shows:
The milestone is the lowest cash point in the forecast.�There are no other financing sources, and the forecast�excludes fundraising transaction costs.
At the financing closing, the company must pay a $40,000�legal bill and a placement fee equal to 4% of the gross�amount raised. Both costs are paid from the proceeds.
What is the minimum gross amount the company needs�to raise, rounded to the nearest $1,000?
A. $1,320,000.
B. $1,360,000.
C. $1,375,000.
D. $1,414,000.
E. $1,417,000.
Devon Coombs CPA, MBA | Santa Clara University | FIN143
64
W4-S064
143
Hard (6/8)
Answer: The gross funding request
KNOWLEDGE CHECK
E. $1,417,000.
Work the calculation
Required net proceeds = $1,480,000 +�$270,000 − $430,000 = $1,320,000. If�R is the gross raise, usable proceeds�equal 0.96R − $40,000. Set 0.96R −�$40,000 = $1,320,000.
Thus R = $1,360,000 ÷ 0.96 =�$1,416,666.67, rounding to $1,417,000.�The stated low point means no larger�interim shortfall must also be funded.
Why the other choices are wrong
A. Covers only net operating funding�need and ignores both transaction�costs.
B. Adds the $40,000 legal bill but omits�the 4% placement fee.
C. Calculates $1,320,000 ÷ 96% but�omits the fixed legal bill.
D. Multiplies $1,360,000 by 1.04�instead of dividing by 0.96. The fee is�4% of gross proceeds, not a 4% markup�on the required net amount.
Devon Coombs CPA, MBA | Santa Clara University | FIN143
65
W4-S064
143
Hard (6/8)
Customer economics
Customer economics connect the cost of acquisition with the revenue�and contribution customers generate over time.
Compare customers with similar pricing, acquisition channels, and�retention behavior. Track cohorts as they mature.
Positive customer contribution helps fund fixed costs. It does not by�itself establish company profitability or sufficient cash.
FIN143 · Week 4
66
Margins and revenue per customer
Gross margin % = (Revenue − Cost of revenue) ÷ Revenue.
Contribution per customer = Revenue per customer − Variable costs per�customer, for the same period. State which costs are included.
Monthly ARPU / ARPA = Monthly revenue or MRR ÷ The corresponding user or�account count. Specify the measure, period, and denominator convention.
Negative incremental contribution means additional activity increases the loss�under those cost assumptions. Positive contribution must still cover fixed costs.
Compare margins only after checking gross-versus-net revenue presentation and�cost classification.
ARPU refers to users; ARPA refers to accounts. Define the paying-customer unit�consistently.
FIN143 · Week 4
67
Acquisition cost, lifetime value, and payback
CAC = Acquisition sales and marketing costs ÷ New customers acquired.�Match the spending to the acquisition period or cohort.
Revenue-basis LTV ≈ Monthly revenue per customer ÷ Monthly customer�churn.
Gross-profit LTV ≈ Monthly revenue per customer × Gross margin % ÷�Monthly customer churn.
CAC payback in months ≈ CAC ÷ Monthly gross profit per customer.
The LTV shortcuts assume constant positive churn, stable customer�revenue and margin, no expansion, and no discounting. Use cohort�evidence when those assumptions fail. Payback should reflect customer�survival and the contribution available to recover CAC.
FIN143 · Week 4
68
LTV/CAC and SaaS/cloud benchmarks
Use a gross-profit or contribution basis for LTV/CAC when evaluating�acquisition economics. Revenue-basis LTV does not subtract delivery�costs.
A 3:1 ratio means $3 of estimated lifetime gross profit or contribution per�$1 of CAC, under the stated method. It does not imply $3 of net profit.
Illustrative SaaS/cloud screening heuristics: LTV/CAC around 3:1, CAC�payback below 18 months, gross margin above 70%, and NRR above 100%.�These are not universal pass/fail tests.
Compare similar customer segments, contract sizes, stages, and�accounting definitions. Check forecast cash needs even when the ratios�look attractive.
The four thresholds are illustrative course heuristics retained from the source deck. Bessemer (2021) provides historical cloud-company comparisons, not this�exact set of thresholds. ChartMogul: SaaS metric definitions · Bessemer: Scaling to $100 Million
FIN143 · Week 4
69
Churn and net revenue retention
Logo churn: Customers lost ÷ Customers at the start of the period.
Gross revenue churn: Recurring revenue lost to cancellations and�downgrades ÷ Starting recurring revenue.
NRR = (Starting MRR + Expansion − Cancellation losses − Downgrades) ÷�Starting MRR.
Use only the starting customer cohort. Assume no reactivation here, or�disclose how reactivations are treated. Exclude new-customer revenue and�avoid subtracting downgrades twice.
NRR above 100% means recurring revenue from that starting cohort�increased. It does not establish company-wide profitability or cash�generation.
FIN143 · Week 4
70
Question: Growth versus retention
KNOWLEDGE CHECK
A SaaS company begins the quarter with $120,000 of monthly recurring�revenue (MRR). During the quarter, it records the following changes:
Customer activity | Effect on MRR |
Expansions by customers present�at the start of the quarter | Increase of $18,000 |
Cancellations by customers�present at the start of the quarter | Decrease of $22,000 |
Downgrades by customers�present at the start of the quarter | Decrease of $8,000 |
New customers acquired during�the quarter | Increase of $52,000 |
The cancellation and downgrade amounts do not overlap. Assume no�reactivations, foreign-exchange effects, or other changes.
Management argues that the increase in total MRR shows the existing�customer base is becoming more valuable.
What are total MRR growth and net revenue retention (NRR), and�what do they indicate about the customers present at the start of the�quarter? Round both percentages to one decimal place.
A. Total MRR growth:�−10.0%; NRR: 90.0%; the�starting cohort�contracts.
B. Total MRR growth:�33.3%; NRR: 75.0%; the�starting cohort�contracts.
C. Total MRR growth:�33.3%; NRR: 90.0%; the�starting cohort�contracts.
D. Total MRR growth:�33.3%; NRR: 133.3%; the�starting cohort expands.
E. Total MRR growth:�43.3%; NRR: 90.0%; the�starting cohort�contracts.
Devon Coombs CPA, MBA | Santa Clara University | FIN143
71
W4-S071
143
Hard (6/8)
Answer: Growth versus retention
KNOWLEDGE CHECK
C. Total MRR growth: 33.3%; NRR: 90.0%; the starting cohort contracts.
Work the calculation
Starting-cohort ending MRR =�$120,000 + $18,000 −�$22,000 − $8,000 = $108,000.�NRR = $108,000 ÷ $120,000 =�90%. Total ending MRR =�$108,000 + $52,000 =�$160,000.
Total growth = $160,000 ÷�$120,000 − 1 = 33.3333%. New�acquisitions mask contraction�in the starting cohort. The�results do not prove durable�product-market fit.
Why the other choices are wrong
A. Applies the starting cohort's 10% decline to the�entire company, excluding new customers. NRR�and the cohort direction are correct.
B. Omits the $18,000 expansion from NRR. The�75% figure is gross retention under these�assumptions.
D. Includes $52,000 from new customers in NRR,�which must be limited to the starting cohort.
E. Uses new-customer MRR divided by starting�MRR as total growth, without netting the $12,000�decline in the starting cohort. NRR and the cohort�direction are correct.
Devon Coombs CPA, MBA | Santa Clara University | FIN143
72
W4-S071
143
Hard (6/8)
Question: Revenue-basis LTV
A SaaS product earns $200 ARPU per month at 2% monthly churn.�What is the revenue-basis LTV?
A $400
B $2,400
C $10,000
D $100
E $4,000
FIN143 · Week 4 · KNOWLEDGE CHECK
73
W4-S073
143
Easy (2/8)
Answer: Revenue-basis LTV
C $10,000
WHY�LTV equals ARPU divided by monthly churn: $200 / 0.02 = $10,000.
KEY TAKEAWAY�On a revenue basis, LTV = ARPU / monthly churn rate.
Correct answer: C.
Assume constant monthly ARPU and churn. The $10,000 is�undiscounted lifetime revenue; delivery costs and CAC have not been�deducted.
FIN143 · Week 4 · KNOWLEDGE CHECK
74
W4-S073
143
Easy (2/8)
Metric priorities by stage
Before revenue | Early revenue | Scaling |
Burn and runway | CAC and payback | NRR and cohort retention |
Financing need | Contribution margin | LTV/CAC |
Time to first revenue | Churn | Gross margin trend |
Evidence at milestones | ARPU / ARPA | Revenue per employee |
Cash obligations | Cash conversion | Operating leverage |
These are priorities, not exclusive categories. Every stage needs cash discipline,�and retention matters as soon as customers begin renewing.
LTV estimates become more useful as cohorts mature and retention evidence�improves.
Course teaching priorities, not a universal stage taxonomy.
FIN143 · Week 4
75
Stress-testing the operating plan
Sensitivity: Vary selected inputs while holding other independent�assumptions fixed. One-variable analysis isolates an input. Two-variable�tables test combinations.
Scenario: Use a coherent set of assumptions describing a possible future.
For each case, inspect cash needs, the date cash reaches the floor, and the�milestone the business can fund.
FIN143 · Week 4
76
Sensitivity: churn and ending MRR
Start with $0 MRR and add $4,500 of new MRR each month for 36 months. Apply�churn to beginning MRR; assume no expansion, contraction, or reactivation.
Ending MRR = Beginning MRR × (1 − Monthly churn) + $4,500.
Monthly churn | Ending MRR after 36 months |
2% | $116,277 |
3% | $99,896 |
4% | $86,623 |
Increasing churn from 2% to 4% is a two-percentage-point increase. It doubles the�rate and reduces ending MRR by $29,654 (25.5%), with all other assumptions fixed.
These amounts are month-end MRR, not cumulative revenue.
Illustrative extension of the existing MRR model. Carry full precision through all 36 months; display dollars rounded to the nearest dollar. ChartMogul: MRR�movements
FIN143 · Week 4
77
Reverse stress tests identify the breaking point
A downside scenario asks what happens under a set of assumptions. A reverse�stress test asks how far an assumption can deteriorate before a constraint fails.
Suppose the monthly model's lowest cash balance is $300,000 and the required�floor is $120,000. Headroom is $180,000.
If an additional dollar of delayed collections reduces cash at that low point by one�dollar, the plan can absorb at most $180,000 more delay at that date.
State which assumptions stay fixed. Re-test every date: a delay may move the�lowest cash point. Decide in advance what action a threshold will trigger.
Devon Coombs CPA, MBA | Santa Clara University | FIN143
78
Question: Stress-testing collection delays
Before new financing, the forecast cash low point is $260,000 at June 30. The�required cash floor is $100,000. A customer payment of $200,000 expected that�day could slip to July 31. All other cash flows remain unchanged; without this delay,�no other date is lower.
What is the June 30 effect, and the minimum additional cash needed to preserve�the floor?
A. Cash is $60,000; the company needs $100,000 of additional cash.
B. Cash is $160,000; the company needs $0 of additional cash.
C. Cash is $60,000; the company needs $160,000 of additional cash.
D. Cash is $260,000; the company needs $0 of additional cash.
E. Cash is $60,000; the company needs $40,000 of additional cash.
Devon Coombs CPA, MBA | Santa Clara University | FIN143
79
W4-S079
143
Medium (4/8)
Answer: Stress-testing collection delays
E. Cash is $60,000; the company needs $40,000 of additional cash.
Delayed collection reduces June 30 cash to $260,000 − $200,000 = $60,000.�Preserving the $100,000 floor requires $40,000.
The $160,000 starting headroom absorbs part of the delay. A gives the entire floor;�B treats headroom as cash and ignores the delay; C confuses headroom with the�remaining gap; D ignores timing.
The July receipt does not repair a June payment failure. Check July and all�intervening dates before selecting a financing or spending response.
Devon Coombs CPA, MBA | Santa Clara University | FIN143
80
W4-S079
143
Medium (4/8)
Question: Sensitivity and scenarios
How does the one-variable sensitivity method used here differ from�business scenario analysis?
A One-variable sensitivity isolates an input; a scenario tests a�coherent set of assumptions
B Sensitivity is optional while scenario is legally required
C Sensitivity uses actuals; scenario uses only forecasts
D Sensitivity is for revenue; scenario is for expenses
E Sensitivity applies to startups; scenario to public firms
FIN143 · Week 4 · KNOWLEDGE CHECK
81
W4-S081
143
Easy (0/8)
Answer: Sensitivity and scenarios
A One-variable sensitivity isolates an input; a scenario tests a�coherent set of assumptions
WHY�This sensitivity method changes one input while holding other�independent assumptions fixed. A scenario combines assumptions�describing a possible future.
KEY TAKEAWAY�Sensitivity tests selected inputs. Scenarios evaluate internally�consistent operating conditions and responses. Sensitivity tables can�also vary two inputs.
Correct answer: A.
FIN143 · Week 4 · KNOWLEDGE CHECK
82
W4-S081
143
Easy (0/8)
Rolling forecasts and variance analysis
A rolling forecast adds a new future period as actual results replace the�completed period, maintaining a stated horizon such as twelve months.
Preserve the prior forecast so changes remain measurable. Update�material assumptions at a cadence suited to the business.
Timing variance: An event occurs in a different period. A March�collection arriving in April can create a March cash shortfall.
Operating variance: Volume, price, mix, cost, or retention differs from�plan. Determine whether the change is temporary or persistent.
Assign a cause and response. A delayed launch is not automatically a�permanent loss.
FIN143 · Week 4
83
Question: Timing variance
A customer payment expected in March arrived in April. How should�variance analysis classify this?
A A permanent variance requiring immediate strategic change
B A timing variance, right in direction but off in period
C An error that should be ignored as ordinary noise
D A signal that the customer has churned permanently
E A reason to abandon the current forecast entirely
FIN143 · Week 4 · KNOWLEDGE CHECK
84
W4-S084
143
Easy (1/8)
Answer: Timing variance
B A timing variance, right in direction but off in period
WHY�The collection occurred in April instead of March. Update the cash�schedule and assess whether the delay creates a March cash shortfall�requiring financing or spending changes.
KEY TAKEAWAY�Timing variance shifts an event between periods. A persistent operating�variance changes the expected volume, price, cost, or retention. Both�can change decisions.
Correct answer: B.
FIN143 · Week 4 · KNOWLEDGE CHECK
85
W4-S084
143
Easy (1/8)
The MARCS forecasting cycle
Measurable: Reconcile historical data and define the metrics.
Aspirational: State the strategic outcome and milestone the company�wants to reach.
Realistic: Build the operating forecast from evidence and test plausible�alternatives.
Controllable: Identify actions management can take and constraints it�must work around.
Sequenced: Schedule hiring, delivery, collection, and funding. Compare�actuals, explain variances, and update the plan.
Course framework: MARCS.
FIN143 · Week 4
86
Forecasting and valuation
The operating forecast establishes the cash-flow assumptions used in�valuation.
The quality of those assumptions, the financing required, and the�uncertainty around the results matter alongside the calculated value.
Next: Week 5, discounted cash flow and terminal value.
Devon Coombs, CPA, MBA
Santa Clara University
FIN143 · Week 4
87
Optional practice and reference
The main sequence teaches the concepts and includes foundation questions�followed by applied challenges.
The following slides retain additional questions, worked answers, and deeper�reference for independent practice or extra class time.
Each question stays with its answer. Use the topic titles to select practice; the�appendix does not introduce a prerequisite needed for the main lesson.
Devon Coombs CPA, MBA | Santa Clara University | FIN143
88
Formula reference: growth and revenue
CAGR = (Ending value ÷ Beginning value)^(1/n) − 1, for n elapsed years and�positive endpoint values.
TTM = Last fiscal year + Current YTD − Comparable prior-year YTD.
Revenue = Volume delivered × Realized price, subject to the applicable�recognition timing.
Ending MRR = Beginning MRR + New + Expansion + Reactivation −�Contraction − Churn.
Required opportunities = Bookings target ÷ (Average booked contract value�× Win rate), using comparable definitions and the target closing period.
Fully loaded employment cost = Salary + Employer taxes + Benefits + Other�employment costs. Use actual estimates where available.
The MRR terms are recurring revenue movements. The salary multiplier in the original was a heuristic, not an identity. CFI: trailing twelve months · ChartMogul: MRR�movements
FIN143 · Week 4
89
Formula reference: cash planning (1 of 2)
Operating net burn = Operating cash payments − Operating cash�receipts.
Runway to zero = Usable cash ÷ Positive monthly net burn, assuming�constant burn and no other cash movements.
Time to the cash floor = max(0, (Usable cash − Required cash floor) ÷�Positive monthly net burn), under the same assumptions.
At the floor, time remaining is zero. Below it, the immediate cash�shortfall equals the required floor minus usable cash.
FIN143 · Week 4
90
Formula reference: cash planning (2 of 2)
Simple financing need = max(0, Cumulative net cash use + Required�ending cash − Usable starting cash).
Use the largest forecast shortfall if the cash low point occurs before the�milestone. Model financing, investment, debt payments, and cash timing�explicitly.
Cash identities and stated classroom assumptions. If burn changes or�becomes nonpositive, use the cash schedule rather than the shortcut.
FIN143 · Week 4
91
Formula reference: customer economics (1 of 2)
Gross margin % = (Revenue − Cost of revenue) ÷ Revenue.
Contribution per customer = Revenue per customer − Variable costs�per customer.
ARPU / ARPA = Period revenue or MRR ÷ Matching user or account�count.
CAC = Acquisition sales and marketing costs ÷ New customers�acquired.
FIN143 · Week 4
92
Formula reference: customer economics (2 of 2)
Revenue LTV ≈ Monthly revenue per customer ÷ Monthly customer�churn.
Gross-profit LTV ≈ Monthly revenue per customer × Gross margin % ÷�Monthly customer churn.
CAC payback ≈ CAC ÷ Monthly gross profit per customer.
NRR = (Starting cohort MRR + Expansion − Cancellations −�Downgrades) ÷ Starting cohort MRR, assuming no reactivation.
Match periods and populations. LTV assumes constant positive churn�and stable customer revenue, with no discounting. Screening heuristics�are not guarantees.
FIN143 · Week 4
93
Question: Annualized run rate
A SaaS company generated $1.5 million of revenue in its most recent month after�launching a major new product. Management refers to a $18 million annual�revenue run rate. Which statement best describes this figure?
A It represents the company’s actual revenue earned over the last twelve�months.
B It assumes the latest monthly revenue continues for the next twelve months.
C It is more reliable than TTM revenue because it uses the most recent�operating data.
D It adjusts recent revenue for seasonality before estimating annual�performance.
E It represents the revenue management expects to recognize under signed�contracts.
FIN143 · Week 4 · KNOWLEDGE CHECK
95
W4-S095
143
Easy (1/8)
Answer: Annualized run rate
A SaaS company generated $1.5 million of revenue in its most recent month after�launching a major new product. Management refers to a $18 million annual revenue�run rate. Which statement best describes this figure?
A It represents the company’s actual revenue earned over the last twelve months.
B It assumes the latest monthly revenue continues for the next twelve�months. ✓
C It is more reliable than TTM revenue because it uses the most recent operating�data.
D It adjusts recent revenue for seasonality before estimating annual performance.
E It represents the revenue management expects to recognize under signed�contracts.
Correct answer: B.
FIN143 · Week 4 · KNOWLEDGE CHECK
96
W4-S095
143
Easy (1/8)
Answer: Annualized run rate — explanation
A SaaS company generated $1.5 million of revenue in its most recent�month after launching a major new product. Management refers to a�$18 million annual revenue run rate. Which statement best describes this�figure?
B It assumes the latest monthly revenue continues for the next twelve�months. ✓
$1.5M × 12 = $18M. This extrapolates the latest month. It does not�establish historical annual revenue, signed-contract revenue, or a�seasonal adjustment.
Correct answer: B.
FIN143 · Week 4 · KNOWLEDGE CHECK
97
W4-S095
143
Easy (1/8)
Question: TTM, run rate, and NTM
A startup reports TTM revenue of $3 million, a current annualized run-rate of $6 million�based on its strongest recent month, and management NTM revenue of $9 million. What�should an investor conclude from the spread before relying on the $9 million forecast?
A. Use NTM as the primary basis because it incorporates management’s latest�information, provided the assumptions are internally consistent.
B. Use TTM as the primary basis because it is historical, treating run-rate and NTM�only as secondary sensitivity cases.
C. Average the three measures to reduce dependence on any single period and�smooth the effect of recent volatility.
D. Use run-rate as the primary basis because it reflects current momentum, then�reconcile management’s NTM forecast to that annualized level.
E. Treat the gap as an unproven inflection and test whether the recent spike and�forward assumptions are repeatable.
FIN143 · Week 4 · KNOWLEDGE CHECK
98
W4-S098
143
Medium (4/8)
Answer: TTM, run rate, and NTM
A startup reports TTM revenue of $3 million, a current annualized run-rate of $6 million�based on its strongest recent month, and management NTM revenue of $9 million. What�should an investor conclude from the spread before relying on the $9 million forecast?
A. Use NTM as the primary basis because it incorporates management’s latest�information, provided the assumptions are internally consistent.
B. Use TTM as the primary basis because it is historical, treating run-rate and NTM�only as secondary sensitivity cases.
C. Average the three measures to reduce dependence on any single period and�smooth the effect of recent volatility.
D. Use run-rate as the primary basis because it reflects current momentum, then�reconcile management’s NTM forecast to that annualized level.
E. Treat the gap as an unproven inflection and test whether the recent spike and�forward assumptions are repeatable.
Correct answer: E.
FIN143 · Week 4 · KNOWLEDGE CHECK
99
W4-S098
143
Medium (4/8)
Answer: TTM, run rate, and NTM — explanation
A startup reports TTM revenue of $3 million, a current annualized�run-rate of $6 million based on its strongest recent month, and�management NTM revenue of $9 million. What should an investor�conclude from the spread before relying on the $9 million forecast?
E. Treat the gap as an unproven inflection and test whether the recent�spike and forward assumptions are repeatable.
Test whether the strongest month repeats and whether pipeline,�capacity, and retention support $9M. Internal consistency or averaging�cannot validate demand.
Correct answer: E.
FIN143 · Week 4 · KNOWLEDGE CHECK
100
W4-S098
143
Medium (4/8)
Question: Productive sales capacity
Four fully productive sales representatives each close three contracts�per quarter at $20,000 per contract. Two additional representatives�start on January 1 but require a 90-day ramp before they can close�business. What bookings should the model attribute to the team during�the first quarter?
A. $120,000.
B. $240,000.
C. $280,000.
D. $320,000.
E. $360,000.
FIN143 · Week 4 · KNOWLEDGE CHECK
101
W4-S101
143
Medium (3/8)
Answer: Productive sales capacity
Four fully productive sales representatives each close three contracts�per quarter at $20,000 per contract. Two additional representatives�start on January 1 but require a 90-day ramp before they can close�business. What bookings should the model attribute to the team during�the first quarter?
A. $120,000.
B. $240,000.
C. $280,000.
D. $320,000.
E. $360,000.
Correct answer: B.
FIN143 · Week 4 · KNOWLEDGE CHECK
102
W4-S101
143
Medium (3/8)
Answer: Productive sales capacity — explanation
Four fully productive sales representatives each close three contracts�per quarter at $20,000 per contract. Two additional representatives�start on January 1 but require a 90-day ramp before they can close�business. What bookings should the model attribute to the team during�the first quarter?
B. $240,000.
4 productive reps × 3 contracts × $20,000 = $240,000. Assume the�two new hires contribute no Q1 contracts. $360,000 would incorrectly�credit all six reps at full productivity.
Correct answer: B.
FIN143 · Week 4 · KNOWLEDGE CHECK
103
W4-S101
143
Medium (3/8)
Question: The cash buffer
A startup projects $1.25 million of cumulative net burn before its next major milestone. It�starts with $550,000 of cash and wants at least $300,000 remaining at the milestone.�Management proposes raising $700,000 because current cash plus the raise equals�projected burn. Which assessment is correct?
A. The $700,000 raise is sufficient because current cash plus new capital covers�projected burn, and the cash buffer can be rebuilt after the milestone.
B. The company should raise $850,000 because the $300,000 buffer should be�added to current cash before comparing available funds with projected burn.
C. The company should raise $950,000 because only part of current cash should be�considered available when planning for operating uncertainty.
D. The company should raise $1.0 million because burn plus the desired ending buffer,�less current cash, leaves a $1.0 million funding requirement.
E. The company should raise $1.55 million because projected burn and the desired�ending buffer should both be financed entirely with new capital.
FIN143 · Week 4 · KNOWLEDGE CHECK
104
W4-S104
143
Medium (3/8)
Answer: The cash buffer
A startup projects $1.25 million of cumulative net burn before its next major milestone. It�starts with $550,000 of cash and wants at least $300,000 remaining at the milestone.�Management proposes raising $700,000 because current cash plus the raise equals�projected burn. Which assessment is correct?
A. The $700,000 raise is sufficient because current cash plus new capital covers�projected burn, and the cash buffer can be rebuilt after the milestone.
B. The company should raise $850,000 because the $300,000 buffer should be�added to current cash before comparing available funds with projected burn.
C. The company should raise $950,000 because only part of current cash should be�considered available when planning for operating uncertainty.
D. The company should raise $1.0 million because burn plus the desired ending�buffer, less current cash, leaves a $1.0 million funding requirement.
E. The company should raise $1.55 million because projected burn and the desired�ending buffer should both be financed entirely with new capital.
Correct answer: D.
FIN143 · Week 4 · KNOWLEDGE CHECK
105
W4-S104
143
Medium (3/8)
Answer: The cash buffer — explanation
A startup projects $1.25 million of cumulative net burn before its next�major milestone. It starts with $550,000 of cash and wants at least�$300,000 remaining at the milestone. Management proposes raising�$700,000 because current cash plus the raise equals projected burn.�Which assessment is correct?
D. The company should raise $1.0 million because burn plus the�desired ending buffer, less current cash, leaves a $1.0 million funding�requirement.
$1.25M + $0.30M − $0.55M = $1.00M. Raising $0.70M leaves zero cash.�The $1.55M choice ignores the $0.55M already available.
Correct answer: D.
FIN143 · Week 4 · KNOWLEDGE CHECK
106
W4-S104
143
Medium (3/8)
Question: Growth and cohort retention
A subscription startup reports 40% year-over-year revenue growth, but each new�customer cohort loses roughly half of its recurring revenue within 12 months.�Management argues that aggregate growth proves durable product-market fit. What�should an analyst examine next?
A. The total market size, because a sufficiently large TAM can offset weak retention�for an extended period.
B. The latest month’s revenue, because run-rate growth is more important than�historical cohort behavior.
C. The number of website visitors, because stronger top-of-funnel activity is the�clearest test of customer value.
D. The company’s gross margin, because positive gross margin is sufficient to�demonstrate that retention is economically sustainable.
E. Cohort retention and the acquisition cost required to replace lost recurring�revenue, because new sales may be masking customer decay.
FIN143 · Week 4 · KNOWLEDGE CHECK
107
W4-S107
143
Medium (4/8)
Answer: Growth and cohort retention
A subscription startup reports 40% year-over-year revenue growth, but each new�customer cohort loses roughly half of its recurring revenue within 12 months.�Management argues that aggregate growth proves durable product-market fit. What�should an analyst examine next?
A. The total market size, because a sufficiently large TAM can offset weak retention�for an extended period.
B. The latest month’s revenue, because run-rate growth is more important than�historical cohort behavior.
C. The number of website visitors, because stronger top-of-funnel activity is the�clearest test of customer value.
D. The company’s gross margin, because positive gross margin is sufficient to�demonstrate that retention is economically sustainable.
E. Cohort retention and the acquisition cost required to replace lost recurring�revenue, because new sales may be masking customer decay.
Correct answer: E.
FIN143 · Week 4 · KNOWLEDGE CHECK
108
W4-S107
143
Medium (4/8)
Answer: Growth and cohort retention — explanation
A subscription startup reports 40% year-over-year revenue growth, but�each new customer cohort loses roughly half of its recurring revenue�within 12 months. Management argues that aggregate growth proves�durable product-market fit. What should an analyst examine next?
E. Cohort retention and the acquisition cost required to replace lost�recurring revenue, because new sales may be masking customer�decay.
E tests whether acquisition spending masks weak recurring-revenue�retention. TAM, website traffic, aggregate growth, and positive gross�margin cannot independently establish durable customer economics.
Correct answer: E.
FIN143 · Week 4 · KNOWLEDGE CHECK
109
W4-S107
143
Medium (4/8)
A consultant’s three-year forecast: reference example
Driver | Year 1 | Year 2 | Year 3 |
Billable hours per working month | 80 | 90 | 100 |
Hourly rate | $75 | $85 | $100 |
Months worked | 11 | 11 | 11 |
Annual gross revenue | $66,000 | $84,150 | $110,000 |
Annual revenue = Billable hours per working month × Hourly rate × Months�worked.
Year 2: 90 × $85 × 11 = $84,150.
The forecast requires both more billable hours and a higher realized rate. Check�capacity and customer demand for each assumption.
Illustrative source-deck figures. All three calculations verified.
FIN143 · Week 4 · Appendix
110
Question: TTM EBITDA
A company’s fiscal year ended December 31, 2025. Through June 30,�2026, it reports year-to-date EBITDA of $7.0 million. EBITDA for the first�six months of 2025 was $5.5 million, and full-year 2025 EBITDA was�$12.0 million. What is TTM EBITDA as of June 30, 2026?
A $7.0 million
B $12.0 million
C $13.5 million
D $14.0 million
E $19.0 million
FIN143 · Week 4 · Appendix · KNOWLEDGE CHECK
111
W4-S111
143
Medium (3/8)
Answer: TTM EBITDA
A company’s fiscal year ended December 31, 2025. Through June 30,�2026, it reports year-to-date EBITDA of $7.0 million. EBITDA for the first�six months of 2025 was $5.5 million, and full-year 2025 EBITDA was�$12.0 million. What is TTM EBITDA as of June 30, 2026?
A $7.0 million
B $12.0 million
C $13.5 million ✓
D $14.0 million
E $19.0 million
Correct answer: C.
FIN143 · Week 4 · Appendix · KNOWLEDGE CHECK
112
W4-S111
143
Medium (3/8)
Answer: TTM EBITDA — explanation
A company’s fiscal year ended December 31, 2025. Through June 30,�2026, it reports year-to-date EBITDA of $7.0 million. EBITDA for the first�six months of 2025 was $5.5 million, and full-year 2025 EBITDA was�$12.0 million. What is TTM EBITDA as of June 30, 2026?
C $13.5 million ✓
$12.0M − $5.5M + $7.0M = $13.5M. The result covers July 2025 through�June 2026 using a consistent EBITDA definition.
Correct answer: C.
FIN143 · Week 4 · Appendix · KNOWLEDGE CHECK
113
W4-S111
143
Medium (3/8)
Question: Customers lost to churn
A subscription business starts the year with 1,000 customers and has�2% monthly churn. Assuming no new customers are added,�approximately how many of the original customers will be lost after 12�months?
A About 20
B About 215
C About 60
D About 500
E About 240
FIN143 · Week 4 · Appendix · KNOWLEDGE CHECK
114
W4-S114
143
Easy (2/8)
Answer: Customers lost to churn
A subscription business starts the year with 1,000 customers and has 2%�monthly churn. Assuming no new customers are added, approximately how�many of the original customers will be lost after 12 months?
A About 20
B About 215
C About 60
D About 500
E About 240
Correct answer: B.
1,000 × (1 − 0.98^12) = 215.28, or about 215 customers lost. About 785�remain. The 240 answer assumes a fixed loss of 20 every month.
FIN143 · Week 4 · Appendix · KNOWLEDGE CHECK
115
W4-S114
143
Easy (2/8)
Question: Financing need
Cumulative net burn to the milestone is $1.8M, minimum cash is�$0.45M, and cash on hand is $0.8M. What is the financing need?
A $1.45 million
B $2.60 million
C $1.00 million
D $1.15 million
E $0.55 million
FIN143 · Week 4 · Appendix · KNOWLEDGE CHECK
116
W4-S116
143
Easy (2/8)
Answer: Financing need
A $1.45 million
WHY�Cumulative net burn plus minimum cash minus cash on hand: 1.8 + 0.45�- 0.8 = $1.45M.
KEY TAKEAWAY�Financing need = cumulative net burn to the milestone + minimum cash�- cash on hand.
Correct answer: A.
Case: $1.8M net cash use, $0.45M required ending cash, and $0.8M�available now. The $1.45M raise leaves exactly $0.45M. Assume no�earlier low point or other financing.
FIN143 · Week 4 · Appendix · KNOWLEDGE CHECK
117
W4-S116
143
Easy (2/8)