NPV Formula in Excel: How to Calculate NPV and IRR (Free Calculator)
Learn how to calculate NPV and IRR in Excel with a step-by-step build and a worked example. The free NPV & IRR calculator is included.
admin
Mortgage Calculator in Excel: Monthly Payment with Taxes, Insurance and PMI (Free)
Build a mortgage calculator in Excel with the PMT function, then add property tax, insurance, HOA and PMI. Download the free template with a yearly amortization table and equity chart.
Invoice Template for Google Sheets and Excel (Free, Auto-Calculating)
A free invoice template for Google Sheets and Excel that calculates line amounts, discount, tax, total, due date and balance due. Includes a step-by-step build and a worked example.
DCF Model in Excel: Step-by-Step Discounted Cash Flow (Free Template)
Learn how to build a DCF model in Excel, from free cash flow forecast to terminal value and value per share. The free template has every formula and a sensitivity grid.
Compound Interest Calculator in Excel with Monthly Contributions (Free)
Build a compound interest calculator in Excel with monthly contributions using the FV function. Download the free template and follow the step-by-step guide.
Profit Margin Formula in Excel: Gross Margin, Markup and Pricing (Free Calculator)
Learn the profit margin formula in Excel, how it differs from markup, and how to price for a target margin. A free Excel calculator is included.
Profit and Loss Template in Excel: Build a 12-Month P&L (Free Download)
A free 12-month profit and loss template for Excel, with a step-by-step guide to the formulas for gross profit, operating profit, tax and net profit. Includes a worked example and Google Sheets notes.
Loan Amortization Schedule in Excel (Free Template + Formulas)
Learn how to build a loan amortization schedule in Excel with PMT, EDATE and simple fill-down formulas. The free template includes an extra payment calculator and a balance chart.
Debt Snowball Spreadsheet: Free Excel Planner (Snowball vs Avalanche)
A free Excel debt snowball spreadsheet that also switches to the avalanche method. Learn how each formula works and compare payoff dates on your own debts.
Cash Flow Forecast Template in Excel: 12-Month Plan (Free Download)
A free 12-month cash flow forecast template for Excel with formulas, a minimum buffer check and a closing balance chart. Follow the steps to build it or download it ready to use.