Julian R. Sterling
Free finance calculators
Each one runs in the browser, needs no sign-up, and opens on a worked case from one of the books, with the formula and the Excel version alongside.
- Yield maintenance calculatorFree yield maintenance calculator: enter the balance, note rate, treasury yield and months left. $40M at 6.25% against 4.00% for 72 months: $4,793,808.
- Defeasance calculatorFree defeasance calculator: the cost of the treasury portfolio that replaces a CMBS loan. $50M at 5.25%, 72 months left, treasuries at 3.90%: $3,444,752.
- Net effective rent calculatorFree net effective rent calculator: headline rent less rent-free, fit-out and fees, straight line or discounted. €300/m², 5 years, 9 months free: €163.80.
- EOQ calculatorFree EOQ calculator: EOQ = √(2DS/H), with orders a year, ordering and holding cost. 95,680 units, 385 an order, 3.83 to hold: 4,384.5 units.
- Reorder point calculatorFree reorder point calculator: ROP = demand over lead time + safety stock, with variable demand and lead time. 1,840 a week, 6 weeks, 98%: 18,587.
- Per diem interest calculatorFree per diem interest calculator: balance × rate ÷ 365 (or 360) × days. $122,692.38 at 7.25% is $24.37 a day; 17 days add $414.30 to the payoff.
- Eichleay formula calculatorFree Eichleay formula calculator for unabsorbed home office overhead, with Hudson and Emden. 24M contract, 90 days of delay: 2,782.61 a day, 250,435.
- Seller financing calculatorFree seller financing calculator: monthly payment, balloon, and what the note is worth if you sell it. $198,000 at 8%, 5-year balloon: $1,452.85 a month.
- Fix and flip calculatorFree fix and flip calculator: hard money interest and points, holding and selling costs, profit, return on cash, 70% rule. Example profit: $8,700.
- BRRRR calculatorFree BRRRR calculator: buy, rehab, rent, refinance. Cash left in the deal, payment, cash flow, cash-on-cash and DSCR. Default deal: 57,600 left in.
- Cash-on-cash return calculatorFree cash on cash return calculator: NOI less reserves and debt service over the equity invested, with the loan constant. $20M buy, 65% loan: 3.44%.
- 1031 exchange calculatorFree 1031 exchange calculator: the federal tax a sale would trigger (recapture, capital gains, NIIT) and what deferring it is worth. Example: $1,004,202.
- NOI calculatorFree NOI calculator: rent less vacancy and credit loss, plus recoveries, less operating expenses, and the value at a cap rate. Example: $3,446,680.
- R&D tax credit calculatorFree R&D tax credit calculator, ASC method: 14% of QREs above half the 3-year average, 6% rule and the 280C election. $2.4M of QREs: $210,000.
- Interest rate cap calculatorFree interest rate cap calculator: caplet by caplet with Black model, from a zero curve, strike and volatility. $50M, 4.50% strike, 4 years: $790,064.
- Safety stock calculatorFree safety stock calculator: z × √(L·σd² + d²·σL²), with demand and lead time both variable. 1,840 a week, 6-week lead time, 98%: 7,547 units.
- XIRR calculatorFree online XIRR calculator: paste dated cash flows and get the annual IRR, as Excel XIRR computes it. Fund example: 11.33% on irregular dates.
- Time-weighted return calculatorFree time-weighted return calculator: chain-link the return of each sub-period between cash flows. 4.0%, -2.0%, 5.0% and 3.0% give a TWR of 10.23%.
- Yield on cost calculatorFree yield on cost calculator: stabilised NOI over total project cost, the development spread and the value created. $80M project, $5.6M NOI: 7.00%.
- Sortino ratio calculatorFree Sortino ratio calculator: excess return over a minimum acceptable return divided by downside deviation, annualised. Example data: 1.34.
- TERP calculatorFree TERP calculator: theoretical ex-rights price, value of a right, discount to TERP and the EPS bonus factor. 2-for-5 at 30.00 on 42.60: TERP 39.00.
- SDE valuation calculatorFree SDE calculator: value a small business on a multiple of seller’s discretionary earnings, then what the owner keeps after the loan. 450k at 2.8x: 1.26M.
- Depreciation recapture calculatorFree depreciation recapture calculator for rental and commercial property: unrecaptured section 1250 gain at up to 25%, capital gains and NIIT on the sale.
- Bonus depreciation calculatorFree bonus depreciation calculator: 100% for property acquired after 19 January 2025, first-year deduction and tax saved, MACRS on any remaining basis.
Free Excel templates → · Worked articles →