Description
Every key business formula in one linked Excel workbook: pricing, break-even, a 12-month P&L and cash flow forecast, loans, financial ratios, NPV and IRR, growth KPIs, VAT and corporate tax, payroll and inventory. Change the yellow cells and everything updates.
11 linked calculators + a dashboard
- Pricing & Margins: price from cost and target margin, margin vs markup, VAT-inclusive price, and the extra volume you need to cover a discount
- Break-Even: contribution margin, break-even units and sales, target-profit volume, margin of safety, operating leverage
- Profit & Loss: 12-month forecast with gross profit, overheads, EBITDA, depreciation, interest, corporate tax, net profit, margins and chart
- Cash Flow: 12-month forecast with collections, supplier payments, VAT, loan instalments, tax, low-cash alerts, runway and chart
- Loan & EMI: monthly instalment, total interest and a repayment schedule up to 10 years
- Ratios: working capital, current and quick ratio, DSO, DIO, DPO, cash conversion cycle, ROA, ROE, debt-to-equity, interest cover
- Investment: NPV, IRR, profitability index, ROI, payback and a clear invest / don't invest decision
- Growth & KPIs: CAGR, CAC, customer lifetime value, LTV:CAC, conversion, churn and retention
- VAT & Tax: add or extract VAT, VAT return estimate, corporate tax and effective tax rate
- Payroll & Staff: cost to company, hourly rate, overtime, UAE end-of-service gratuity
- Inventory: economic order quantity (EOQ), safety stock, reorder point and holding cost
Learn as you use it: every calculator has a “How it is calculated” column that explains the formula in plain words. Sheets are linked, so your price and cost flow into break-even and inventory, and the P&L feeds the cash flow, ratios and tax.
Instant download (.xlsx, 13 sheets, 1,200+ formulas). Works in Microsoft Excel 2010+ (Windows & Mac), Excel for the web, Google Sheets, Apple Numbers and LibreOffice. Currency-neutral; tax settings default to UAE rules and can be changed for any country. Comes with realistic example figures and a How to Use sheet.
Payment & Security
Your payment information is processed securely. We do not store credit card details nor have access to your credit card information.
