One powerful Excel financial model and a practical masterclass built for Indian businesses — from manufacturing and trading to agencies and SaaS. Change an assumption and watch revenue, profit, cash flow and valuation move with it.
One payment of ₹4,999. No subscription. GST invoice provided.
Generic templates assume one kind of company. A factory, a distributor, a consultancy and a SaaS product earn money in completely different ways, so a model built for software quietly gives the other four the wrong answer.
A single dropdown changes how revenue is built. The sheet then asks for the numbers that actually drive your business:
Every figure traces back to the Assumptions sheet. Move your growth rate, your price, your debtor days or your salary bill, and the P&L, the balance sheet, the cash flow and the valuation all move together — which is how you find out whether a decision is affordable before you make it.
The model also refuses to let you fool yourself: three automatic checks test the balance sheet, the cash balance and the debt schedule in all 60 months, and a red flag tells you which input to fix.
The numbers below are the shipped workbook’s own defaults, recalculated for each business type. They are illustrative — your own figures will be different.
The same model, five different revenue drivers.
Each unit carries a price and a raw-material plus direct-labour cost.
Nothing is hidden and nothing is locked. Every sheet exists to answer a question you will actually ask.
How to use the model in ten minutes, and what not to touch.
Every driver in one place: growth, pricing, cost, GST, tax and DSO/DPO.
Units, customers or billable hours — the switch picks your driver.
Role-wise count and salary, with PF, ESI and the annual hike.
Rent, marketing, tools, legal and travel — fixed and variable.
Asset purchases and WDV depreciation at the IT Act rate.
Receivables, inventory and payables, so you see the cash you lock up.
Term loan, EMI, interest and principal, month by month.
60 months of profit and loss, with the year-wise summary.
60 months of assets, liabilities and equity, tied to the cash flow.
Indirect method — operating, investing and financing.
Three tests. Every month must read OK, or you fix the input.
CAC, LTV, LTV:CAC, payback and lifetime contribution.
Worst, base and best, with a multiplier for each driver.
DCF and revenue multiple, side by side.
ARR, burn, runway, gross margin and Rule of 40 on one page.
How much to raise and where each rupee goes.
Who owns what and who gets what, for two partners or four.
Output GST, input credit, net payable, and the TDS timing.
The monthly and annual revenue you must cross.
A 14-point checklist to close the books every month.
Every sheet, assumption and figure in this walkthrough is read out of the shipped model itself — the same file a buyer receives. Assumptions, the revenue build, the 60-month P&L, the automatic checks, the Investor Dashboard, break-even and the monthly close.
The figures shown are the shipped model’s default assumptions, so they are illustrative of how the model behaves, not a forecast for your business.
The manual explains the reason behind every line in the model, in plain language — not just what to type, but why it matters.
One payment, lifetime access, no subscription and no upsell ladder.
The 21-sheet workbook. Every formula is open and unlocked, so you can see how each figure is calculated and change anything.
13 parts and over 60 chapters, written in plain language for Indian business owners rather than finance specialists.
A guided tour of the workbook, rendered from the shipped model's own sheets, so you are not left staring at 21 tabs on day one.
Monthly close checklist, pre-fundraise checklist, board pack index, investor update email and a data-room index.
If a formula confuses you, write in and get a written answer. No support ticket queue.
When a GST slab, tax rate or PF limit changes, the file is updated and buyers get the new version at no cost.
This is a planning and learning tool. It is not accounting software and it is not tax filing software. It will not compute your statutory liability or file a return for you, and it does not replace your accountant.
Not every business models the same way. Here is what each one can decide with the model.
Factory and workshop owners
Plan capacity, raw-material cost and a term loan. See the month your EMI and your working capital both bite.
Wholesalers, stockists, retail chains
Model inventory days and debtor days. Find out how much cash your growth is quietly locking up in stock.
Consultants, IT firms, professionals
Price a billable hour that actually covers overheads, and see the utilisation you need before profit appears.
Retainer businesses and studios
Per-client profit, retainer mix and the cost of delivery — before you sign the next contract.
Founders and product teams
MRR, churn, cohorts and ARR, with burn and runway on the same page as the P&L.
Anyone raising money or splitting profit
A fundraise summary, a partner split and the investor metrics an investor will ask for.
You type into one sheet. The other twenty do the work.
Fill the designated input cells. This is the only sheet you type into.
One dropdown switches the revenue driver to units, hours or customers.
Revenue driver, headcount, operating expenses and capital expenditure.
Every month must say OK. A red flag points at the input to correct.
The Investor Dashboard and the three statements tell your one-page story.
The planned price becomes ₹7,999 after the first 50 buyers. That is a planned future price set by us — not a discount verified by anyone else.
Seven-day refund policy, subject to the published terms. Read the refund policy before you buy. Checkout is being finalised — until the payment link is live, the button above opens a pre-filled email to hello@tankmetrics.in and you will get the payment link as soon as it is ready.
Two free PDFs, no email needed. Read the writing before you spend anything.
Enter your licence key below and your files unlock. Every copy is stamped with the buyer’s details, which is what makes a refund able to cut off access.
Enter the licence key from your order email. It looks like
TM-XXXX-XXXX-XXXX-XXXX.
Lost your key? Email hello@tankmetrics.in with your order number and I will resend it.
This digital product is a financial planning and educational aid, not tax, legal, investment or accounting advice. Confirm applicable tax rates and compliance requirements with a qualified professional. Features and statutory assumptions must be verified before use. Tax rates, GST slabs and PF/ESI limits shown in the model reflect Indian rules as understood at the time of writing and may change.
21 sheets, 156 pages and a walkthrough — one payment of ₹4,999, yours for life.
Planned price rises to ₹7,999 after the first 50 buyers.Tank Metrics — simple money tools and practical finance education for Indian businesses. The Indian Business Financial Model is a planning and learning aid, not tax or accounting advice.