Accounting and finance calculators and Excel templates
113 calculators and 14 Excel templates for accounting, business and personal finance. Each calculator shows its formula and a worked example.
No results. Try a shorter search term.
- No registration
- Inputs stay in your browser
- Formulas documented
- Three-Statement Financial Model (coming soon)36-month integrated model: revenue, headcount, expense and financing schedules feeding a tied income statement, balance sheet and cash flow.
- Depreciation Schedule TemplateFixed asset register with monthly depreciation, disposals, roll-forwards by class, journal entries and general ledger reconciliation.
- Loan Amortization Schedule TemplatePayment-by-payment amortization with extra principal, journal entries for payment, accrued interest and the current portion, and a lender reconciliation.
- Bank Reconciliation TemplateTwo-sided bank reconciliation with outstanding items, book adjustments and the adjusting journal entry.
- Month-End Close Checklist TemplateClose checklist with owners, business-day due dates and status, a recurring entry register and an account reconciliation tracker.
- Accounts Receivable Aging TemplateInvoice-level aging with customer totals, allowance calculation, journal entry and control account reconciliation.
- Prepaid Expense and Accrual Schedule TemplatePrepaid amortization and accrued expense schedules with both journal entries and ledger reconciliations.
- 13-Week Cash Flow Forecast TemplateWeekly receipts and disbursements for one quarter, with closing cash, minimum balance alerts and forecast-to-actual tracking.
- Annual Operating Budget TemplateBudget by account and month using six methods, with a summary income statement, totals by department, and an export for the Budget to Actual template.
- Budget to Actual Variance TemplateBudget and actuals held by month, so the variance report for any month and the year to date comes from changing one date. Reads the Annual Operating Budget template.
- Personal Budget PlannerMonthly household budget with a spending log, dashboard, yearly overview, and savings goal and debt trackers.
- ASC 842 Lease Schedule TemplateLessee lease liability and right-of-use asset for up to 20 operating and finance leases, with journal entries, maturity analysis and disclosures.
- ASC 606 Revenue Recognition TemplateContract-level revenue schedule for software and SaaS: price allocation, deferred revenue, contract assets and remaining performance obligations.
- Stock-Based Compensation Template (ASC 718)Grant-level expense schedule for options and RSUs with vesting, forfeitures, journal entry by function, roll-forward and a Black-Scholes calculator.
Reference tables
Rates, limits and factor tables- MACRS depreciation tables
- MACRS recovery periods
- Section 179 and bonus depreciation limits
- IRS mileage rates by year
- Social Security wage base by year
- Federal income tax brackets
- 401(k) and IRA contribution limits
- Present value and future value tables
- Loan payment table
- Day count conventions
- Debits and credits: normal balances
- Financial ratio formulas
- Minutes to decimal hours chart
Accounting & Finance Calculators
34 calculators- ROI Calculator
- NPV and IRR Calculator
- Current Ratio and Working Capital Calculator
- Inventory Turnover Calculator
- Days Sales Outstanding (DSO) Calculator
- CAGR Calculator
- Present Value Calculator
- Depreciation Schedule Calculator
- Depreciation Method Comparison Calculator
- Straight-Line Depreciation Calculator
- Double Declining Balance Depreciation Calculator
- Sum-of-the-Years-Digits Depreciation Calculator
- MACRS Depreciation Calculator
- Cost of Goods Sold (COGS) Calculator
- Weighted Average Cost Calculator
- Days Payable Outstanding (DPO) Calculator
- Cash Conversion Cycle Calculator
- Debt-to-Equity Ratio Calculator
- Return on Equity and DuPont Calculator
- EBITDA Calculator
- Interest Coverage Ratio Calculator
- Units of Production Depreciation Calculator
- Accrued Interest Calculator
- Prepaid Expense Amortization Calculator
- Future Value Calculator
- Payback Period Calculator
- WACC Calculator
- CAPM Calculator
- Free Cash Flow Calculator
- Allowance for Doubtful Accounts Calculator
- Earnings per Share (EPS) Calculator
- Early Payment Discount Calculator
- Lease Liability Calculator
- Overhead Rate Calculator
Business & Pricing Calculators
21 calculators- Profit Margin Calculator
- Net Profit Margin Calculator
- Markup Calculator
- Margin vs Markup Converter
- Break-Even Point Calculator
- Sales Tax Calculator
- Discount Calculator
- Percentage Calculator
- Commission Calculator
- Invoice Late Fee Calculator
- Contribution Margin Calculator
- Margin of Safety Calculator
- Burn Rate and Runway Calculator
- Customer Lifetime Value and CAC Calculator
- Selling Price Calculator
- ROAS Calculator
- Payment Processing Fee Calculator
- Invoice Factoring Calculator
- Food Cost Percentage Calculator
- Mileage Reimbursement Calculator
- Employee Cost Calculator
Pay & Payroll Calculators
10 calculatorsLoan & Mortgage Calculators
14 calculators- Loan Payment Calculator
- Mortgage Payment Calculator
- Amortization Schedule Calculator
- Debt Payoff Calculator
- Debt-to-Income Ratio Calculator
- Extra Mortgage Payment Calculator
- Home Affordability Calculator
- Down Payment Calculator
- Loan-to-Value (LTV) Calculator
- Home Equity Calculator
- Refinance Break-Even Calculator
- Loan Comparison Calculator
- APR Calculator
- Interest-Only Loan Calculator
Savings & Interest Calculators
12 calculatorsPersonal Finance Calculators
10 calculatorsCar Cost Calculators
5 calculatorsProperty Investing Calculators
7 calculatorsQuick answers
Common figures, already worked outHourly wage to yearly salary
- $7.25 an hour
- $13.50 an hour
- $18.50 an hour
- $23.50 an hour
- $28.50 an hour
- $36 an hour
- $46 an hour
- $80 an hour
Yearly salary to hourly wage
- $20,000 a year
- $34,000 a year
- $48,000 a year
- $62,000 a year
- $76,000 a year
- $90,000 a year
- $120,000 a year
- $190,000 a year
Loan payment tables by amount
Mortgage payment tables by loan amount
- $100,000 mortgage
- $250,000 mortgage
- $400,000 mortgage
- $550,000 mortgage
- $700,000 mortgage
- $850,000 mortgage
- $1,000,000 mortgage
Car loan payment tables by amount
- $10,000 car loan
- $20,000 car loan
- $30,000 car loan
- $40,000 car loan
- $50,000 car loan
- $60,000 car loan
- $70,000 car loan
- $80,000 car loan