Ratios healthy
9
To review
0
Financial Ratio Analysis
Liquidity, profitability, efficiency and leverage ratios calculated from your figures and compared with targets.
12 free business analysis templates, ready to edit in your browser and download for Excel, Word, Google Sheets or your calendar app. This collection brings together 7 documents and 5 spreadsheets from Business Plans & Strategy, Business Finance and KPIs & Performance. Start with Financial Ratio Analysis, Business Case and Gap Analysis: each comes with realistic sample content, working formulas or ready-to-use wording, and a step-by-step guide.
Ratios healthy
9
To review
0
Liquidity, profitability, efficiency and leverage ratios calculated from your figures and compared with targets.
Sponsor: Name Author: Name Date: Date Decision needed by: Date
1. Summary
What you propose, what it costs, what it returns and what you are asking for.
2. The problem or opportunity
What is happening today, the evidence, and what it costs the organisation.
3. Objectives
Options, costs, benefits, risks and a recommendation for a proposed investment or change.
| Organisation / area | Kestrel Software: Customer |
| Scope | Support for the self-serve |
| Target state source | FY2027 customer experience |
1. Objective
Bring support performance up to the levels promised in business-plan contracts and needed to reduce churn from 2.4% to 1.8% a month by Q3 2027.
2. Current state summary
A team of 14 agents handles about 9,800 tickets a month by email and chat. Ticket volume grew 38% in 2026 while headcount grew 8%. There is no knowledge base for customers, routing is manual, and only two agents can res
3. Future state summary
Compare where you are with where you need to be, size each gap, find its cause and plan how to close it.
Prepared by: Name · Date: Date · Scope: What is being analysed
SWOT grid
| Strengths (internal) | Weaknesses (internal) |
| Loyal repeat customers: 62% | Reliance on one supplier |
| Experienced founding team | Limited marketing budget |
| Opportunities (external) | Threats (external) |
| Growing demand in segment X | New low-cost competitor |
| Partnership with local busi | Rising input costs |
TOWS strategies
| Strategy type | Action | Owner |
| S–O: use strengths to seize | Launch referral programme f | Name |
| W–O: fix weaknesses to seize | Apply for grant to build on | Name |
Key takeaways
Assess strengths, weaknesses, opportunities and threats, then turn them into actions.
Our score
3.9
Best competitor score
3.9
Average entry price
$33
Compare competitors on price, features, positioning and weighted scores.
Total profit
$176,775
Overall margin
31%
Loss-making customers
1
Revenue, direct costs and cost to serve by customer, with margin, ranking and who is unprofitable.
Prepared by: Name Date: Date Time horizon: Next 3 years
Political
| Factor | Opportunity or threat | Impact |
| Trade policy change | Threat | High |
Economic
| Factor | Opportunity or threat | Impact |
| Interest rates, inflation, |
Social
| Factor | Opportunity or threat | Impact |
| Demographics, attitudes, wo |
Political, economic, social, technological, legal and environmental factors with impact, likelihood and your response.
NPV
$118,225
IRR (approx.)
15%
Profitability index
1.2
Evaluate an investment the way a CFO does: after-tax cash flows, NPV, approximate IRR, profitability index and simple and discounted payback.
| Company | Brightline Coffee Roasters |
| Industry defined as | Direct-to-consumer specialt |
| Prepared by | Name, role |
Scoring: each driver is rated 1 (weak force, favourable) to 5 (strong force, unfavourable). The force rating is the average of its drivers.
1. Competitive rivalry
| Driver | Evidence | Score |
| Number and size of competit | Around 120 online roasters; | 4 |
| Industry growth | Category growing 9% a year, | 3 |
Implication: Profit depends on retention, not acquisition. Discount-led growth destroys margin.
2. Threat of new entrants
Score the five competitive forces in your industry and turn the result into clear strategic choices.
| Reference | RCA-2026-031 |
| Site / department | Meridian Foods Distribution |
| Date opened | 3 November 2026 |
1. Problem statement
Between 1 September and 31 October 2026, picking accuracy in the chilled section fell from 99.6% to 98.7%. 412 order lines were mis-picked, mostly wrong product variants (e.g. 500 g instead of 1 kg), leading to 63 custo
2. Impact
| Area | Impact |
| Customer | 63 complaints; 2 formal not |
| Financial | $18,400 credits plus $6,100 |
3. Containment
Investigate a problem with 5 Whys and a fishbone diagram, verify the cause and fix it so it stays fixed.
Total costs
$687,000
Total benefits
$1,457,000
PV of costs
$613,577
Multi-year costs and benefits, discounted to present value, with NPV, benefit-cost ratio, ROI and payback.
| Organisation | Ashford Mutual Insurance |
| Process | Home insurance claim: notif |
| Process owner | Name, Head of Property Clai |
1. Process boundaries
2. SIPOC table
| Suppliers | Inputs | Process |
| Policyholders | Claim notification and desc | 1. Register the claim |
| Brokers | Photos, receipts, estimates | 2. Validate cover and polic |
3. Process steps in more detail
Map a process at a glance: suppliers, inputs, process steps, outputs and customers, with requirements and measures.