Spreadsheet Tools and Calculators
Free calculators for hours worked, percentage change, date difference and other spreadsheet tasks, with the matching Excel and Google Sheets formulas.
Percentage Change Calculator
Find the percent increase or decrease between two numbers, then copy the Excel and Google Sheets formula. Tested on revenue, price and score examples.
ToolsDate Difference Calculator
Count the days, weeks, months and years between two dates, including the DATEDIF formula and a fix for the negative remaining-days bug.
ToolsLoan Payment Calculator
Calculate a loan or mortgage payment, total interest and total paid. Uses the same PMT math as Excel and Google Sheets, with a worked $250,000 example.
ToolsCAGR Calculator
Calculate the compound annual growth rate between a starting and ending value. Matches Excel and Google Sheets RRI, including a 10% five-year check.
ToolsWeighted Average Calculator
Compute a weighted average from a list of values and weights, with the SUMPRODUCT formula that works in Excel and Google Sheets.
ToolsPercentage of Total Calculator
Split a list of amounts into a percentage of the total, with the Excel and Google Sheets formula. Tested on a two-region revenue example.
ToolsMarkup vs Margin Calculator
Convert between markup and margin, or find a selling price from cost. Uses the same profit/cost and profit/price formulas as Excel and Google Sheets.
ToolsCompound Interest Calculator
Project a starting balance with compound interest, optional regular contributions, and the matching FV formula from Excel and Google Sheets.
ToolsTime Card Calculator with Overtime
Split a week of hours into regular and overtime pay, using a daily or weekly threshold, with the Excel and Google Sheets formulas.
ToolsDiscount Calculator (Percentage Off)
Find the sale price, savings, or discount percent from a list price, with the Excel and Google Sheets formulas.
ToolsSimple Interest Calculator
Calculate simple interest and the total amount due using I = PRT, and see how it differs from compound interest.
ToolsPercent Error Calculator
Measure how far a result is from an accepted value, with the ABS formula that works in Excel and Google Sheets.
ToolsHourly to Salary Calculator
Convert an hourly wage to weekly, monthly, and annual salary using hours per week and paid weeks per year, with the spreadsheet formulas.
ToolsRule of 72 Calculator
Estimate how many years an investment takes to double at a given rate, and compare the Rule of 72 to the exact compound formula.
ToolsBreak-Even Calculator
Find the units and revenue needed to cover fixed costs from the selling price and variable cost per unit, with the spreadsheet formulas.
ToolsSales Tax Calculator
Add sales tax to a net price, or back the tax out of a total, with the Excel and Google Sheets formulas.
ToolsROI Calculator
Calculate return on investment from cost and ending value, with the spreadsheet formula and a profit figure.
ToolsStraight-Line Depreciation Calculator
Compute annual straight-line depreciation and book value from cost, salvage, and useful life, including the SLN formula.
ToolsPayback Period Calculator
Find how long it takes to recover a cost from even annual cash flows, or from a list of yearly amounts, with the spreadsheet formulas.
ToolsAPY Calculator (Effective Annual Rate)
Convert a nominal annual rate into APY, or effective annual rate, for monthly, quarterly, or other compounding, including the EFFECT formula.
ToolsDeclining-Balance Depreciation Calculator
Compute double-declining or declining-balance depreciation and book value by year, matching the Excel and Google Sheets DDB function.
ToolsPresent Value Calculator
Find the present value of a lump sum, an annuity, or both, with the Excel and Google Sheets PV formula.
ToolsNPV Calculator
Calculate net present value for uneven cash flows, subtract the initial cost outside NPV, and match the spreadsheet function.
ToolsCommission Calculator
Calculate a flat or two-tier sales commission from a sales amount and a rate, with the spreadsheet formulas.
ToolsHours Worked Calculator
Clock-in to clock-out hours, including overnight shifts and unpaid breaks, plus the matching spreadsheet formula.