MSME 5-Year Financial Plan
Build a realistic 5-year financial plan with conservative, base, and optimistic scenarios. Designed for MSMEs and cooperatives.
Entity & Horizon
What kind of business is this and how far are we projecting?
₱
Revenue
How will your business earn money? Pick the model that matches how you sell.
₱
%
Costs
What does it cost to make and run your business?
%
Operating Expenses (annual)
₱
₱
₱
₱
₱
₱
₱
₱
%
Working Capital
How fast does cash move through your business?
days
days
days
Capital Expenditures
Equipment, machines, leasehold improvements — when will you invest?
₱
₱
₱
₱
₱
Bank Loan / Financing
Loan proceeds appear in Year 0 cash. Interest expense flows through P&L; principal payment flows through Cash Flow.
₱
%
Tax & Patronage Distributions
How much of profits are taxed and how much is distributed to members?
%
%
Scenarios
Three projections from the same assumptions. Conservative trims growth and adds cost pressure; Optimistic does the opposite.
5-Year Revenue
₱16,181,715
Total Base scenario
Avg Gross Margin
55.0%
Average across the plan
Year 5 EBIT
₱1,177,338
Operating profit
Year 5 Cash
₱2,146,579
Break-even Year 1
| P&L Item | Year 1 | Year 2 | Year 3 | Year 4 | Year 5 |
|---|---|---|---|---|---|
| Revenue | ₱2,400,000 | ₱2,760,000 | ₱3,174,000 | ₱3,650,100 | ₱4,197,615 |
| Cost of Goods Sold | ₱1,080,000 | ₱1,242,000 | ₱1,428,300 | ₱1,642,545 | ₱1,888,927 |
| Gross Profit | ₱1,320,000 | ₱1,518,000 | ₱1,745,700 | ₱2,007,555 | ₱2,308,688 |
| Gross Margin % | 55.0% | 55.0% | 55.0% | 55.0% | 55.0% |
| Operating Expenses | |||||
| Rent | ₱120,000 | ₱126,000 | ₱132,300 | ₱138,915 | ₱145,861 |
| Utilities | ₱48,000 | ₱50,400 | ₱52,920 | ₱55,566 | ₱58,344 |
| Salaries & Wages | ₱540,000 | ₱567,000 | ₱595,350 | ₱625,118 | ₱656,373 |
| Marketing | ₱50,000 | ₱52,500 | ₱55,125 | ₱57,881 | ₱60,775 |
| Transportation | ₱36,000 | ₱37,800 | ₱39,690 | ₱41,675 | ₱43,758 |
| Supplies | ₱30,000 | ₱31,500 | ₱33,075 | ₱34,729 | ₱36,465 |
| Insurance | ₱24,000 | ₱25,200 | ₱26,460 | ₱27,783 | ₱29,172 |
| Other | ₱24,000 | ₱25,200 | ₱26,460 | ₱27,783 | ₱29,172 |
| Total Operating Expenses | ₱872,000 | ₱915,600 | ₱961,380 | ₱1,009,449 | ₱1,059,921 |
| EBITDA | ₱448,000 | ₱602,400 | ₱784,320 | ₱998,106 | ₱1,248,767 |
| Depreciation | ₱42,857 | ₱50,000 | ₱64,286 | ₱64,286 | ₱71,429 |
| EBIT (Operating Profit) | ₱405,143 | ₱552,400 | ₱720,034 | ₱933,820 | ₱1,177,338 |
| Interest Expense | ₱40,000 | ₱40,000 | ₱30,000 | ₱20,000 | ₱10,000 |
| Pre-tax Income | ₱365,143 | ₱512,400 | ₱690,034 | ₱913,820 | ₱1,167,338 |
| Tax | ₱73,029 | ₱102,480 | ₱138,007 | ₱182,764 | ₱233,468 |
| Net Income | ₱292,114 | ₱409,920 | ₱552,027 | ₱731,056 | ₱933,871 |
| Net Margin % | 12.2% | 14.9% | 17.4% | 20.0% | 22.2% |
| Patronage Distributions | ₱73,029 | ₱102,480 | ₱138,007 | ₱182,764 | ₱233,468 |
Revenue and Gross Profit (bars). Net Income trajectory (line).