Business case financial analysis: compare costs and benefits

Business case financial analysis compares the cash consequences of a proposed change with a realistic baseline. It shows which costs are additional, which benefits can be supported and when the money moves. The result should help the budget owner choose among options and identify the assumptions that could reverse the choice.

Define the decision before collecting costs

Write down the business problem, the current operating arrangement and the alternatives that meet the same requirement. Give every option a common start date, evaluation period and service standard. Continuing as you are remains an option, with its expected costs and constraints made explicit.

A whole-company business-plan financial section is a different deliverable. For narrower commercial applications, use the account-growth review business case or the customer supplier-switch business case. Their specific benefits should not be pasted into an unrelated investment request.

Assign one owner to the cash schedule and name the people responsible for confirming costs and benefits. A finance reviewer can check arithmetic; the operations owner must explain why the proposed spending changes operating performance.

Turn the available files into an evidence register

Start with payroll and overtime exports, supplier invoices, expense-ledger rows, purchase quotations and the proposed implementation schedule. Each assumption should have a source, period, owner and status. Distinguish a quoted amount from an estimate and an approved staffing change from an aspiration.

Separate initial spending from recurring spending. The SBA's startup-cost guidance uses this distinction to show how much capital is needed and when. The same separation helps a business-change case: equipment and installation belong on their payment dates, while maintenance follows its contract schedule.

Use incremental amounts throughout:

Incremental cash flow = Cash benefits relative to baseline - Additional cash costs relative to baseline

A cost that is identical under every option does not change the ranking. Money already spent is not a future cash outflow. Record both for transparency, but keep them out of the incremental comparison.

A worked comparison of two operating changes

An illustrative US distributor is reviewing two packing-station changes. Both meet the same throughput and safety requirements. The baseline is the approved operating plan, including its expected overtime and outside packing costs.

The table shows additional initial spending and annual amounts relative to that baseline. Benefits are payments removed from the operating budget, supported by the staffing and supplier schedules. They do not include a dollar value for redeployed employee hours.

Annual net cash benefit is 100,000 - 35,000 = $65,000 for A and 70,000 - 25,000 = $45,000 for B. Use =B3-B4 for A if the table begins at A1, with inputs on rows 2 through 4.

For this limited illustration, benefits last three years, there is no residual value and no working-capital change. Cash flows are before tax and financing. A real case needs an explicit treatment of those items and a discount rate consistent with that treatment.

If period labels occupy A2:A5 and cash flows B2:C5, cumulative cash in D2 is =B2. In D3 enter =D2+B3 and fill down. The final cumulative values must equal the cash-flow column sums.

Compare the timing with net present value

The undiscounted totals favor A, but timing also matters. Net present value discounts future cash flows and subtracts initial spending. Here the assumed annual rate is 10%; it is an example input, not a recommended company hurdle rate.

Values are rounded to the nearest dollar after calculation. Using the cash-flow table above, the exact spreadsheet formula for A is:

=NPV(10%,B3:B5)+B2

For B, substitute column C. Microsoft's NPV documentation specifies equally spaced, end-of-period cash flows and adding an immediate initial cash flow separately. Covirage is not affiliated with Microsoft.

The higher NPV favors A under these assumptions. It does not remove the need to assess whether the extra initial cash is available or whether the operational risks are acceptable. Use the same tax basis, price basis and time horizon for both options.

Test the assumption most likely to fail

Change one input first. Suppose A's annual avoided cash costs are only $80,000; its initial spending and annual additional operating costs stay unchanged.

The lower-benefit NPV is =NPV(10%,45000,45000,45000)-120000. The case has become negative while option B's assumptions remain unchanged. That makes evidence for avoided overtime and outside services a decision requirement. Record what would confirm those savings before making the purchase commitment.

Where business cases go wrong

• Counting revenue as benefit. Include the incremental cash contribution after the costs of serving additional demand.
• Counting time twice. Do not claim both eliminated payroll spending and a full capacity benefit from the same employee hours.
• Omitting implementation costs. Training, temporary cover, disruption and contract exit payments need owners and payment dates.
• Using inconsistent timing. Discounting an initial payment as though it occurred at year-end overstates its present-value result.
• Hiding uncertainty in one total. Show the assumptions whose plausible changes reverse the ranking, rather than presenting one NPV as a guaranteed outcome.

Check your business-case workbook in Covirage

Upload the option costs, baseline spending and dated cash assumptions for Covirage to map the columns and its tools to compute and check the figures. The external AI model explains the comparison with every figure traced to its rows. Create a free Covirage account, then set up your business and bring a sample of your own data.

See the supporting approach for Excel analysis.