Business Planning & Feasibility Analysis

Chapter 10
Financial Feasibility, Valuation, and Risk Analytics

Bachelors Program in Entrepreneurship
Business Planning & Feasibility Analysis   •   Bachelor

Financial Feasibility, Valuation, and Risk Analytics

Introduction

Financial feasibility analysis converts a business idea into an evidence-based judgment about whether the venture can create value, remain solvent, and withstand uncertainty. A financially attractive idea is not necessarily feasible: it may generate accounting profit but fail because cash arrives too late, require excessive investment, or expose owners and lenders to unacceptable risk.

Entrepreneurs therefore need an integrated system rather than a single forecast. The system should connect operating assumptions, financial statements, cash requirements, investment appraisal, valuation, and risk analysis. This chapter develops that system and applies it to an illustrative venture.

Learning Objectives

By the end of this chapter, students should be able to:

  1. Calculate and interpret break-even sales, contribution margin, cash runway, and financial ratios.
  2. Prepare and evaluate cash-flow forecasts for a new venture.
  3. Apply NPV, IRR, discounted payback, and relevant valuation methods.
  4. Use sensitivity analysis, scenario analysis, stress testing, and decision trees.
  5. Identify limitations, ethical issues, and governance requirements in financial feasibility work.
  6. Formulate financing and contingency decisions from quantitative evidence.

1. Financial Feasibility as an Integrated Decision

Financial feasibility asks four related questions:

  • Profitability: Can the venture earn an acceptable return after operating costs?
  • Liquidity: Can it pay obligations when they fall due?
  • Value creation: Is the present value of expected benefits greater than the investment?
  • Resilience: How does performance change when assumptions are wrong?

A feasibility model normally includes an operating forecast, projected income statement, cash-flow statement, balance sheet, capital budget, funding plan, and risk analysis. These components must be internally consistent. For example, sales growth should affect receivables and inventory, depreciation should affect profit but not cash directly, and debt financing should affect both cash and future interest or principal payments.

The distinction between profit and cash is fundamental. Profit is measured using accrual accounting; cash flow records actual timing of receipts and payments. A growing business can report profit while becoming insolvent if customers pay slowly or inventories expand rapidly.

2. Operating Economics and Break-Even Analysis

Contribution margin

Contribution margin is the amount available from each sale to cover fixed costs and then generate profit.

Contribution margin per unit = Selling price per unit − Variable cost per unit

The contribution margin ratio is:

CM ratio = (Selling price − Variable cost) ÷ Selling price

The calculation assumes that selling price and variable cost are approximately constant over the relevant range and that costs can reasonably be classified as fixed or variable.

Accounting break-even

For a single-product business:

Break-even units = Fixed costs ÷ Contribution margin per unit
Break-even sales = Fixed costs ÷ CM ratio

Fixed costs are costs that do not change with output over the relevant range, such as rent or salaried administration. Variable costs change with units or sales, such as materials, payment fees, and delivery costs.

For multiple products, the calculation requires a stable sales mix. If weighted-average contribution margin per unit is used:

Break-even composite units = Fixed costs ÷ Weighted-average contribution margin per composite unit

Break-even is not a forecast. It is a threshold based on assumptions. It ignores financing costs, taxes, capacity constraints, price changes, uncertainty, and cash timing unless these are explicitly incorporated.

Margin of safety and operating leverage

The margin of safety indicates how far expected sales can fall before accounting break-even is reached:

Margin of safety = Expected sales − Break-even sales
Margin of safety percentage = Margin of safety ÷ Expected sales × 100

Operating leverage describes sensitivity of operating profit to sales changes. A common measure is:

Degree of operating leverage = Contribution margin ÷ Operating profit

This measure is meaningful when operating profit is positive and costs are correctly classified. High operating leverage magnifies both gains and losses.

3. Cash Forecasting and Runway

A cash budget estimates opening cash, receipts, payments, financing flows, and closing cash for each period:

Closing casht = Opening casht + Cash inflowst − Cash outflowst

The next period’s opening cash equals the previous period’s closing cash. A minimum cash reserve should be specified before the model is built. A business is not financially feasible merely because cumulative cash flow is positive at the end of a five-year forecast; it must avoid an unacceptable cash deficit during the intervening periods.

Cash runway estimates how long the venture can continue before cash falls below its required minimum. With a stable monthly net cash burn:

Runway months = (Cash available − Minimum reserve) ÷ Monthly net cash burn

This simple formula is applicable only when cash burn is positive and reasonably stable. If burn varies materially, calculate runway period by period using the cash budget. Net cash burn should include operating payments, capital expenditure, debt service, taxes, and other unavoidable cash commitments. Non-cash expenses such as depreciation are excluded from burn, although the assets that depreciation represents may require future replacement.

Working capital is often the major source of early-stage cash pressure. A simplified cash conversion cycle is:

Cash conversion cycle = Inventory days + Receivable days − Payable days

A longer cycle means that cash is tied up for longer, all else equal. The measure is informative only when the underlying day calculations use compatible revenue, cost, and balance-sheet definitions.

4. Financial Statements and Ratio Analysis

A projected income statement estimates revenue, operating expenses, depreciation, interest, tax, and net income. A projected cash-flow statement separates:

  • operating cash flows;
  • investing cash flows, such as equipment purchases; and
  • financing cash flows, such as equity investment and borrowing.

A balance sheet must satisfy:

Assets = Liabilities + Equity

Failure to balance usually indicates an error in retained earnings, debt, working capital, or cash.

Useful ratios include:

RatioFormulaInterpretation
Current ratioCurrent assets ÷ Current liabilitiesShort-term coverage, subject to asset quality
Debt-to-equityTotal debt ÷ EquityFinancial leverage
Gross marginGross profit ÷ RevenueProduct-level economics
Operating marginOperating profit ÷ RevenueProfitability after operating costs
Return on invested capitalAfter-tax operating profit ÷ Invested capitalReturn generated by operating capital
Interest coverageEBIT ÷ Interest expenseAbility to service interest

Ratios must be compared with the venture’s history, competitors, industry conditions, and debt covenants. A high current ratio can conceal obsolete inventory or uncollectible receivables. A high return on equity may result from excessive leverage rather than superior operations.

5. Investment Appraisal

Net present value

NPV discounts future incremental cash flows to the present and subtracts the initial investment:

NPV = −I0 + ∑[t=1 to n] CFt ÷ (1 + r)t

Here, I0 is the initial cash investment, CFt is the incremental cash flow in period t, r is the discount rate per period, and n is the number of periods. Cash flows and the discount rate must use the same time unit. If cash flows are nominal, the discount rate should also be nominal; if cash flows are real, the rate should be real.

A positive NPV means that expected benefits exceed the required return under the model assumptions. NPV is generally preferred to accounting profit because it recognizes timing and opportunity cost. The discount rate should reflect the risk and financing context of the cash flows, without double-counting risk already modeled in scenarios.

Internal rate of return

IRR is the discount rate that makes NPV equal to zero:

0 = −I0 + ∑[t=1 to n] CFt ÷ (1 + IRR)t

IRR is useful for communication but has limitations. It can produce multiple rates when cash flows change sign more than once, and it can rank mutually exclusive projects incorrectly when projects differ in scale or timing. When NPV and IRR conflict, NPV normally provides the stronger value-maximization criterion, provided the discount rate is appropriate.

Payback and discounted payback

Simple payback is the time required for cumulative undiscounted cash flows to recover the initial investment. Discounted payback uses discounted cash flows. Payback is easy to explain and highlights liquidity, but it ignores cash flows after recovery and does not directly measure value creation.

If the unrecovered balance at the beginning of a year is B and the discounted cash flow during that year is CF, the fractional year is:

Fractional year = B ÷ CF

This interpolation assumes cash flow arrives evenly during the period.

6. Valuation of Entrepreneurial Ventures

Valuation is an estimate, not a fact. It depends on expected cash flows, risk, growth, control rights, liquidity, and market evidence.

Discounted cash-flow valuation

For a stable business, enterprise value may be estimated as:

Enterprise value = ∑[t=1 to n] FCFt ÷ (1 + r)t + TVn ÷ (1 + r)n

FCFt is free cash flow to the firm and TVn is terminal value. Under perpetual growth:

TVn = FCFn+1 ÷ (r − g)

where g is the perpetual growth rate. The formula requires r > g, a stable business, and a defensible long-run growth assumption. Because terminal value can represent a large share of total value, it should be tested carefully.

Free cash flow to the firm can be expressed as:

FCF = EBIT × (1 − Tax rate) + Depreciation − Capital expenditure − Increase in net working capital

Debt interest is excluded from FCFF because the discount rate ordinarily reflects the financing cost of both debt and equity. Mixing cash-flow definitions and discount rates creates valuation error.

Relative valuation

Market multiples, such as enterprise value-to-revenue or enterprise value-to-EBITDA, compare the venture with similar firms. Comparables should resemble the venture in growth, margins, risk, capital intensity, geography, and business model. Early-stage firms often have negative earnings, making revenue or gross-profit multiples more useful but also more approximate.

Venture method

Investors may estimate a required exit value, discount it at a high target return, and infer a post-money or pre-money valuation. This method is highly sensitive to exit assumptions and should not be presented as objective certainty.

7. Sensitivity, Scenario, and Stress Analysis

Sensitivity analysis

Sensitivity analysis changes one assumption at a time while holding others constant. It identifies influential variables such as price, volume, customer acquisition cost, churn, gross margin, or working-capital days. A useful output is the value at which NPV becomes zero, called a switching value.

For example, if a project’s NPV is positive at a price of $50 but negative at $42, management should identify the precise price threshold and ask whether customers, competitors, and capacity make it realistic.

Scenario analysis

Scenario analysis changes several linked assumptions together. Typical scenarios include base, upside, downside, and severe downside. Each scenario should have a coherent narrative rather than arbitrary percentages. For example, a recession may reduce volume, delay receivables, increase bad debts, and restrict financing simultaneously.

An expected-value estimate can be calculated when probabilities are defensible:

Expected NPV = ∑[i=1 to m] pi × NPVi

Here, pi is the probability of scenario i, with probabilities summing to 1. Expected value does not eliminate risk; two projects can have the same expected NPV but very different downside exposure.

Stress testing

Stress testing examines extreme but plausible conditions, such as a 30% volume decline, a major supplier failure, a doubling of interest rates, or a six-month funding delay. It asks whether the venture remains solvent and what management would do if it does not. Reverse stress testing begins with a failure condition, such as cash falling below zero, and determines which assumptions would cause it.

8. Decision Trees and Contingency Options

A decision tree represents sequential decisions and uncertain events. At a chance node, probabilities are assigned; at a decision node, management selects the best available action after observing information.

Expected monetary value = ∑ pi × Payoffi

Decision trees are particularly useful when a venture can stage investment: conduct a pilot, expand if traction is achieved, abandon if evidence is poor, or secure a follow-on funding option. The value of flexibility may make a staged strategy superior to immediate full-scale investment even when the latter has a higher undiscounted upside.

A decision tree should distinguish decisions made before uncertainty resolves from decisions made afterward. It should also include the cost of obtaining information, probabilities that reflect evidence, and terminal cash flows rather than vague strategic benefits.

9. Illustrative Case: GreenCup Mobile Coffee

This is a fictional illustrative case.

Background and problem

GreenCup Mobile Coffee plans to purchase a mobile unit and sell beverages at business parks. The founders must decide whether to invest $120,000, how much cash to retain, and whether to begin with a pilot.

Assumptions are:

  • selling price: $5.00 per cup;
  • variable cost: $2.00 per cup;
  • annual fixed cash operating costs: $90,000;
  • annual depreciation: $12,000;
  • expected volume: 50,000 cups in year 1;
  • initial equipment investment: $120,000;
  • working-capital investment at launch: $10,000;
  • project life: three years;
  • annual after-tax operating cash flows: $45,000, $60,000, and $70,000;
  • terminal recovery of working capital: $10,000 in year 3;
  • required return: 12%.

Break-even analysis

Contribution per cup is $5 − $2 = $3. Break-even volume is:

$90,000 ÷ $3 = 30,000 cups

Expected volume of 50,000 cups therefore gives a margin of safety of 20,000 cups, or 40% of expected volume. Operating profit before depreciation is:

50,000 × $3 − $90,000 = $60,000

After depreciation, accounting operating profit is $48,000. The distinction matters: depreciation reduces accounting profit but is not a current cash payment.

NPV

The initial cash outflow is $130,000, consisting of equipment and working capital. Cash flows are $45,000, $60,000, and $80,000, with the final amount including working-capital recovery.

NPV = −130,000 + 45,000÷1.12 + 60,000÷1.122 + 80,000÷1.123

Present values are approximately $40,179, $47,831, and $56,970. Therefore:

NPV ≈ −130,000 + 144,980 = $14,980

The positive NPV suggests value creation under the base assumptions. It does not justify ignoring downside risk.

Cash runway

Suppose GreenCup begins with $80,000 of unrestricted cash, requires a $20,000 minimum reserve, and expects a monthly net cash burn of $10,000 during the launch period:

Runway = ($80,000 − $20,000) ÷ $10,000 = 6 months

Management should not use the entire six months without milestones. A prudent plan might require a financing or cost-reduction decision by month four.

Scenario analysis

ScenarioVolumeVariable costYear-1 operating cash flowDecision implication
Upside60,000$1.90HighConsider expansion
Base50,000$2.00$45,000Proceed with controls
Downside35,000$2.20Low or negativePreserve cash; pilot only
Severe downside25,000$2.40NegativePause or exit

The downside case approaches break-even volume while also suffering margin compression. A one-variable analysis might miss this interaction. Stress testing should include lower demand, higher input prices, and slower customer payments together.

Decision-tree recommendation

GreenCup can either invest fully now or conduct a three-month pilot costing $15,000. Suppose the pilot has a 60% probability of demonstrating strong demand and a 40% probability of weak demand. If strong, the full project has an estimated NPV of $30,000; if weak, management abandons the project and loses the pilot cost. The expected value of the staged strategy is:

0.60 × ($30,000 − $15,000) + 0.40 × (−$15,000) = $3,000

This simplified calculation excludes the value of learning and timing effects, but it shows how a pilot can reduce downside. The full investment’s base NPV is $14,980, so the staged strategy is not automatically superior on these assumptions. Management should refine the probabilities and include the value of avoiding a poor full investment. The appropriate recommendation may be to pilot if the information substantially changes the expansion decision and cash preservation is strategically important.

Learning points

The case demonstrates that break-even, NPV, runway, and scenario analysis answer different questions. Break-even identifies operating thresholds; runway addresses survival; NPV assesses value; scenario analysis exposes assumption combinations; and decision trees evaluate staged choices.

10. Limitations, Ethics, and Governance

Financial models create an appearance of precision. Their outputs are conditional on assumptions about demand, pricing, costs, tax, investment timing, financing, and terminal value. Common errors include optimistic sales ramps, omission of working capital, double-counting risk, inconsistent nominal and real values, treating sunk costs as relevant, and using terminal growth greater than the discount rate.

Ethically, entrepreneurs should not manipulate forecasts to obtain funding. Material assumptions, downside cases, conflicts of interest, and model limitations should be disclosed. Revenue should not be recognized prematurely, customer deposits should not be treated as unrestricted profit, and personal or investor data used in analytics must be handled lawfully and securely.

Good governance includes version control, documented assumptions, independent review, formula checks, access controls, and an audit trail. Spreadsheet models should separate inputs, calculations, outputs, and scenario controls. AI tools can assist with sensitivity generation, anomaly detection, and documentation, but managers must verify source data, formulas, confidentiality, bias, and explainability. AI-generated forecasts are not evidence unless their assumptions and validation are transparent.

11. Best-Practice Workflow

A disciplined feasibility process follows these steps:

  1. Define the decision, time horizon, currency, tax basis, and perspective.
  2. Build operating assumptions from market and operational evidence.
  3. Separate fixed, variable, sunk, incremental, cash, and non-cash items.
  4. Construct integrated income, cash-flow, and balance-sheet forecasts.
  5. Calculate break-even, runway, ratios, NPV, IRR, and payback.
  6. Validate units, timing, accounting identities, and reconciliation checks.
  7. Conduct sensitivity, coherent scenario, and severe-but-plausible stress tests.
  8. Model staged investment and contingency actions with a decision tree.
  9. Assess funding needs, covenants, governance, and ethical disclosure.
  10. Convert results into explicit go, revise, pilot, defer, or abandon criteria.

Chapter Summary

Financial feasibility is an integrated assessment of profitability, liquidity, value creation, and resilience. Contribution margin and break-even analysis identify operating thresholds, while cash budgets and runway reveal survival requirements. Ratio analysis provides comparative evidence but must be interpreted in context. NPV is the central investment-appraisal measure because it incorporates timing and required return; IRR and payback are useful supplementary measures with important limitations. Valuation may use discounted cash flow, market multiples, or venture methods, but all are assumption-dependent. Sensitivity analysis isolates influential variables, scenario analysis combines coherent changes, stress testing examines extreme conditions, and decision trees evaluate staged investment and flexibility. Ethical disclosure, model governance, validation, and transparent assumptions are essential to responsible entrepreneurial decision-making.

Key Terms

Contribution margin: Sales revenue less variable costs.

Break-even point: Activity level at which profit is zero.

Margin of safety: Difference between expected activity and break-even activity.

Operating leverage: Sensitivity of operating profit to changes in sales.

Cash runway: Period before available cash reaches a minimum reserve.

Working capital: Short-term operating investment in receivables, inventory, and payables.

Cash conversion cycle: Time between paying suppliers and collecting customers.

Net present value: Present value of incremental cash flows less initial investment.

Internal rate of return: Discount rate that makes NPV equal to zero.

Payback period: Time required to recover an investment.

Free cash flow: Cash available after operating needs and capital investment.

Terminal value: Value attributed to cash flows beyond the explicit forecast period.

Enterprise value: Value of operating assets before allocation between debt and equity.

Sensitivity analysis: One-at-a-time examination of assumption changes.

Scenario analysis: Evaluation of linked assumptions under coherent conditions.

Stress testing: Examination of severe but plausible conditions.

Decision tree: Sequential representation of decisions and uncertain events.

Expected monetary value: Probability-weighted average of possible payoffs.

Switching value: Assumption level at which a decision measure changes sign.

Model governance: Controls ensuring model integrity, transparency, and accountability.

Review Questions

Short Answer Questions

  1. Distinguish accounting profit from cash flow.
  2. State the assumptions behind a basic break-even calculation.
  3. Why is NPV generally preferred to payback for investment appraisal?
  4. What is the difference between sensitivity analysis and scenario analysis?
  5. Identify two governance controls for financial models.

Long Answer Questions

  1. Explain how contribution margin, break-even, margin of safety, and operating leverage are related.
  2. Describe the construction of an integrated financial feasibility model for a new venture.
  3. Compare NPV, IRR, simple payback, and discounted payback, including their limitations.
  4. Explain how working capital can cause a profitable venture to become cash constrained.
  5. Discuss the ethical responsibilities of an entrepreneur presenting forecasts to investors.

Analytical / Application Questions

  1. A venture sells a product for $80 with a variable cost of $50 and fixed costs of $150,000. Calculate contribution margin per unit, break-even units, and break-even sales.
  2. A project requires $200,000 initially and produces cash flows of $80,000, $90,000, and $100,000 over three years. Evaluate its NPV at 10% and explain what additional evidence you would seek before investing.
  3. Construct a downside scenario for a subscription venture in which customer acquisition cost rises, churn increases, and collections slow. Identify the resulting cash risks and propose two contingency actions.

Multiple Choice Questions with Answers

Question 1

A product sells for $40 and has a variable cost of $25. Fixed costs are $60,000. What is the break-even volume?

A. 2,000 units

B. 4,000 units

C. 6,000 units

D. 8,000 units

Correct Answer: B. 4,000 units

Question 2

Which measure most directly incorporates the time value of money and opportunity cost?

A. Simple payback

B. Accounting break-even

C. Net present value

D. Gross margin

Correct Answer: C. Net present value

Question 3

If current assets are $120,000 and current liabilities are $80,000, the current ratio is:

A. 0.67

B. 1.00

C. 1.50

D. 2.00

Correct Answer: C. 1.50

Question 4

Which item is normally added back when calculating operating cash flow from accounting profit?

A. Cash rent

B. Depreciation

C. Inventory purchases

D. Interest paid

Correct Answer: B. Depreciation

Question 5

A positive NPV means that, under the stated assumptions, the project:

A. Has no financial risk

B. Exceeds the required return in present-value terms

C. Has the highest possible IRR

D. Will recover its investment immediately

Correct Answer: B. Exceeds the required return in present-value terms

Question 6

Sensitivity analysis generally changes:

A. All assumptions simultaneously

B. One major assumption while holding others constant

C. Only historical accounting data

D. The legal ownership structure

Correct Answer: B. One major assumption while holding others constant

Question 7

In a decision tree, probabilities are associated primarily with:

A. Decision nodes

B. Chance nodes

C. Input cells

D. Balance-sheet accounts

Correct Answer: B. Chance nodes

Question 8

If cash available above the minimum reserve is $45,000 and monthly net burn is $9,000, runway is:

A. 3 months

B. 4 months

C. 5 months

D. 6 months

Correct Answer: C. 5 months

Question 9

Which condition is required for the perpetual-growth terminal-value formula to be mathematically meaningful?

A. Growth exceeds the discount rate

B. Growth equals the discount rate

C. The discount rate exceeds growth

D. Both rates must be zero

Correct Answer: C. The discount rate exceeds growth

Question 10

A high operating leverage means that a change in sales will generally produce:

A. A proportionally larger change in operating profit

B. No change in operating profit

C. A smaller change in fixed costs only

D. A guaranteed increase in cash

Correct Answer: A. A proportionally larger change in operating profit

Business Planning & Feasibility Analysis
Chapter 10 of 15