Excel Calculators
Explore finance, math, date and business calculations.
Percentage
Find a percentage of a number.
Percentage Change
Measure increase or decrease from an old value to a new value.
Percent Difference
Compare two values using their average as the denominator.
Average
Calculate the arithmetic mean of values.
Weighted Average
Calculate an average where values have different weights.
Ratio
Express one quantity relative to another.
Markup
Calculate selling price from cost and markup percentage.
Profit Margin
Calculate profit as a percentage of selling price.
Profit
Calculate profit from revenue and cost.
Discount Price
Calculate the price after a discount.
Tax / GST
Calculate tax amount and total including tax.
Reverse Tax
Find the pre-tax amount from a tax-inclusive total.
Break-even Units
Units required to cover fixed costs.
Break-even Sales
Sales revenue required to cover fixed costs.
CAGR
Compound annual growth rate between two values.
Simple Interest
Calculate simple interest.
Simple Interest Total
Calculate principal plus simple interest.
Compound Interest
Calculate compound interest with annual compounding.
Compound Amount
Calculate final amount with annual compounding.
EMI
Calculate monthly loan payment using the standard EMI formula.
Loan Total Interest
Estimate total interest paid over a fixed-rate EMI loan.
Loan Total Payment
Estimate total payments over a fixed-rate EMI loan.
Present Value
Present value of a future lump sum.
Future Value
Future value of a lump sum with annual compounding.
Monthly Savings Future Value
Future value of monthly deposits at a monthly rate.
SIP Future Value
Estimate SIP maturity value using monthly compounding.
ROI
Return on investment as a percentage of investment cost.
Annualized Return
Annualized return from start and end values.
Rule of 72
Approximate years for money to double at a given annual rate.
Straight-line Depreciation
Annual depreciation with no residual value assumption beyond salvage.
Depreciation Rate
Straight-line depreciation rate as a percentage.
Loan-to-Value
Loan amount as a percentage of property value.
Debt-to-Income Ratio
Monthly debt payments as a percentage of gross monthly income.
Savings Rate
Monthly savings as a percentage of income.
Investment Doubling Time
Estimate doubling time using the Rule of 72.
Days Between Dates
Count calendar days from a start date to an end date.
Business Days
Count weekdays between two dates, excluding Saturdays and Sundays.
Weeks Between Dates
Calculate elapsed weeks between two dates.
Months Between Dates
Calculate approximate elapsed months using 30.4375 days per month.
Years Between Dates
Calculate elapsed years from two dates.
Age Calculator
Calculate age in years from date of birth.
Days in Year
Return the number of days in a calendar year.
Quarter Finder
Find the calendar quarter for a date.
Indian FY Quarter
Find the Indian financial-year quarter (Apr–Mar).
Indian Financial Year
Return the Indian financial year for a date.
Days to Month End
Count days remaining in the month after a selected date.
Growth Rate
Calculate simple growth rate between two values.
Target Achievement
Calculate actual performance as a percentage of target.
Target Variance
Calculate actual minus target.
Collection Efficiency
Compare collected amount with overdue amount.
Conversion Rate
Calculate conversions as a percentage of leads or opportunities.
Attrition Rate
Calculate departures as a percentage of average headcount.
Utilization Rate
Calculate used capacity as a percentage of available capacity.
Productivity
Output produced per unit of input.
Cost per Unit
Calculate average cost for each unit produced.
Revenue per Employee
Average revenue generated per employee.
Average Ticket Size
Average transaction value.
Inventory Turnover
Cost of goods sold divided by average inventory.
Working Capital
Current assets minus current liabilities.
Current Ratio
Current assets divided by current liabilities.
Quick Ratio
Liquid current assets divided by current liabilities.
Debt-to-Equity
Total debt divided by shareholder equity.
Operating Margin
Operating profit as a percentage of revenue.
Gross Margin
Gross profit as a percentage of revenue.
Net Margin
Net profit as a percentage of revenue.
Receivable Days
Estimate average collection days from receivables and annual credit sales.
Inventory Days
Estimate days inventory is held from inventory and annual COGS.
Cash Conversion Cycle
Receivable days plus inventory days minus payable days.
Sales Commission
Calculate commission from sales and commission rate.
Hourly Salary
Estimate hourly pay from monthly salary and monthly hours.
Annual Salary
Convert monthly salary to annual salary.
Overtime Pay
Calculate overtime earnings from hourly rate and hours.
Salary + Commission
Calculate total pay from base salary and commission.
Interactive practice runs in your browser.