Easy Accounting AnimatedFree Accounting Formula Calculator
Excel workbook · 8 tabs · 28 formulas · free for subscribers
Get it free in your inbox
An Excel workbook that does the maths for you. Type your numbers into the yellow cells and watch the answers appear.
- 28 key formulas in one place
- 15 financial ratios with traffic-light meanings
- Depreciation, break-even, NPV, IRR & payback
- A full loan repayment schedule
Inside the workbook
8 tabs that do the maths for you
Accounting equation & debits/credits
Check Assets = Liabilities + Equity and see which side each account sits on.
Depreciation
Straight-line and reducing-balance schedules, year by year.
15 financial ratios
Profitability, liquidity, efficiency and gearing, each with a GREEN / AMBER / RED meaning.
Break-even
Contribution, break-even units and sales, margin of safety and target profit.
NPV, IRR & payback
Investment appraisal with discounted cash flows and a clear accept/reject answer.
Loan schedule
Monthly repayment, interest and balance for up to 30 years.
Works in Microsoft Excel and other spreadsheet apps that open .xlsx files. For learning purposes only, not financial advice.