Money & borrowing
Asset depreciation and book value
Estimate depreciation and remaining book value using straight-line or reducing-balance assumptions.
Home / Categories / Money & borrowing
Money & borrowing
Choose a tool. The method, example and assumptions are included.
Money & borrowing
Average purchase price from investment lots
Average purchase price from investment lots: For each lot, units bought = invested amount / unit price.
Money & borrowing
Balloon loan payment and schedule
Balloon loan payment and schedule: Regular payment = [principal − balloon/(1+r)^n] × r/[1−(1+r)^−n]; at zero rate use (principal−balloon)/n.
Money & borrowing
Bond yield to maturity solver
Bond yield to maturity solver: Solve the discounted coupon-plus-face-value equation by bisection over a nominal annual yield from −90% to 1,000%.
Money & borrowing
Car lease payment from money factor
Estimate a lease’s monthly depreciation, finance charge and payment using the quoted money factor.
Money & borrowing
Compare three investment return scenarios
Compare three investment return scenarios: For each entered nominal annual return, apply rate/12 monthly before adding the end-of-month contribution.
Money & borrowing
Compare two loan offers
Compare two loan offers: Amortize both offers with rounded monthly interest and a final balance adjustment; compare all payments plus upfront fees.
Money & borrowing
Compound annual growth rate (CAGR)
Find the annualized growth rate between a positive starting value and a non-negative ending value.
Money & borrowing
Compound interest
Compound interest: Balance = P × (1 + r/n)^(n×years), without contributions
Money & borrowing
Credit card balance transfer comparison
Credit card balance transfer comparison: Compare monthly rounded-interest payoff under the original rate with a transferred balance including the percentage fee, promo months and a later rate.
Money & borrowing
Credit card payoff time
Estimate the time and interest needed to clear a credit card with fixed monthly repayments and no new spending.
Money & borrowing
Credit utilization ratio
Calculate the share of available revolving credit currently used by your entered balances.
Money & borrowing
Debt snowball vs avalanche comparison
Debt snowball vs avalanche comparison: Add monthly rounded interest, pay fixed minimums, then allocate all remaining budget to the smallest remaining balance (snowball) or highest rate (avalanche).
Money & borrowing
Debt-to-income ratio
Calculate the percentage of your gross monthly income used by required monthly debt payments.
Money & borrowing
Discount calculator
Discount calculator: Final price = price × (1 − discount/100)
Money & borrowing
Discounted payback period
Discounted payback period: enter your own figures, see the result and calculation method, and check the model’s assumptions.
Money & borrowing
Dividend income and yield planner
Dividend income and yield planner: Annual gross dividend = shares × dividend per payment × payments per year.
Money & borrowing
Effective annual rate
Effective annual rate: Effective rate (%) = [(1 + nominal/n)^n − 1] × 100
Money & borrowing
Emergency fund target and shortfall
Plan an emergency savings target from essential spending and months of cover, then see your remaining shortfall.
Money & borrowing
Equivalent annual cost (EAC)
Equivalent annual cost (EAC): enter your own figures, see the result and calculation method, and check the model’s assumptions.
Money & borrowing
Equivalent salary from cost-of-living indices
Compare a salary against two cost-of-living indices that you supply on the same scale and in the same currency.
Money & borrowing
Extra loan payment savings
Compare payoff time and interest with and without an additional monthly loan payment.
Money & borrowing
Fixed-coupon bond price
Value a fixed-coupon bond by discounting its remaining coupons and maturity payment at an entered yield.
Money & borrowing
How long will savings last?
Estimate how many month-end withdrawals savings can support under a fixed return and withdrawal amount.
Money & borrowing
Inflation and purchasing power
Compare a future price with the purchasing power of a fixed amount under an assumed annual inflation rate.
Money & borrowing
Interest-only loan payment plan
Interest-only loan payment plan: Monthly payment = principal × annual rate / 1200.
Money & borrowing
Internal rate of return (IRR)
Internal rate of return (IRR): enter your own figures, see the result and calculation method, and check the model’s assumptions.
Money & borrowing
Investment annual fee impact
Compare projected investment balances with and without a recurring annual asset-based fee under fixed growth assumptions.
Money & borrowing
Investment return on investment (ROI)
Calculate total investment profit and return percentage, including income and fees you enter.
Money & borrowing
Loan amortization schedule
See a monthly loan amortization schedule and download principal, interest and balance as a CSV file.
Money & borrowing
Loan payment / EMI
Loan payment / EMI: Monthly payment = P×r/[1−(1+r)^−n], r=annual/12; at zero interest P/n
Money & borrowing
Loan recast payment after a lump sum
Loan recast payment after a lump sum: Subtract the lump sum from principal and recalculate the fixed payment over the entered remaining term at the same rate.
Money & borrowing
Loan-to-value and combined LTV
Loan-to-value and combined LTV: LTV = first loan/property value ×100.
Money & borrowing
Modified Dietz investment return
Modified Dietz investment return: Return = (ending − starting − net external flows)/(starting + Σ flow × remaining-days/period-days).
Money & borrowing
Modified internal rate of return (MIRR)
Modified internal rate of return (MIRR): enter your own figures, see the result and calculation method, and check the model’s assumptions.
Money & borrowing
Monthly cash-flow budget worksheet
Monthly cash-flow budget worksheet: In entered row order, ending cash = previous cash + income − expenses.
Money & borrowing
Mortgage affordability from a payment budget
Mortgage affordability from a payment budget: Available principal-and-interest payment = income × debt ratio − other debt − housing overhead.
Money & borrowing
Mortgage payment with taxes and insurance
Estimate monthly housing cost including mortgage principal and interest, property tax, insurance and service fees.
Money & borrowing
Multiple discounts
Multiple discounts: Final price = price × (1−d₁/100) × (1−d₂/100); percentages do not add
Money & borrowing
Net present value (NPV)
Discount future net cash flows and subtract the initial outlay to estimate a project’s net present value.
Money & borrowing
Net worth worksheet with asset and debt totals
Net worth worksheet with asset and debt totals: Total entered assets and debts separately; net worth = assets − debts.
Money & borrowing
One-time loan overpayment schedule
One-time loan overpayment schedule: Calculate the normal fixed payment, then apply one extra principal payment after the regular payment in the chosen month.
Money & borrowing
Portfolio rebalancing trade worksheet
Portfolio rebalancing trade worksheet: Target value = (sum of current values + new cash) × target weight.
Money & borrowing
Present value of an annuity
Present value of an annuity: enter your own figures, see the result and calculation method, and check the model’s assumptions.
Money & borrowing
Profitability index
Profitability index: enter your own figures, see the result and calculation method, and check the model’s assumptions.
Money & borrowing
Real return after inflation
Adjust a nominal return for inflation over the same period to estimate the change in purchasing power.
Money & borrowing
Refinance fee break-even
Refinance fee break-even: New payment uses the fixed-rate annuity formula.
Money & borrowing
Rent affordability from a budget ratio
Estimate a monthly rent budget after other housing bills, using the income share you choose.
Money & borrowing
Rent versus buy net-worth scenario
Rent versus buy net-worth scenario: The renter invests the down payment plus purchase closing costs.
Money & borrowing
Rental cash-on-cash return
Rental cash-on-cash return: Annual cash flow = collected rent − operating costs − financing payments.
Money & borrowing
Rental property capitalization rate
Rental property capitalization rate: enter your own figures, see the result and calculation method, and check the model’s assumptions.
Money & borrowing
Retirement income gap and target pot
Retirement income gap and target pot: Annual funding gap = max(0, spending − other income).
Money & borrowing
Savings goal contribution
Savings goal contribution: Monthly saving = max(0, target − current) ÷ months; zero growth model
Money & borrowing
Savings with monthly contributions
Project a savings balance from an initial deposit and recurring monthly contributions, with interest and timing shown.
Money & borrowing
Simple interest
Simple interest: Interest only = principal × annual rate × years
Money & borrowing
Split shared bills in proportion to income
Split shared bills in proportion to income: Each share = shared bill × individual income / sum of incomes.
Money & borrowing
Subscription annual cost comparison
Compare a monthly subscription with an annual plan for your expected usage period, including the break-even month.
Money & borrowing
Time-weighted investment return
Time-weighted investment return: Compute each subperiod return as end/start −1 and geometrically link the factors.
Money & borrowing
Tip and split the bill
Calculate a tip and split the final bill equally, with a cent allocation that adds up to the total.
Money & borrowing
Year-by-year variable-return drawdown
Year-by-year variable-return drawdown: For each entered year apply its return to the current balance, then take the entered year-end withdrawal.
Money & borrowing
Sinking fund periodic deposit
Sinking fund periodic deposit: End-of-period deposit = target × r / [(1+r)^n−1].
Money & borrowing
Rule of 72 comparison
Rule of 72 comparison: Approximate doubling years = 72 / annual percentage growth rate.
Money & borrowing
Level perpetuity present value
Level perpetuity present value: Present value of end-of-period level payments continuing forever = payment / discount rate.
Money & borrowing
Growing perpetuity present value
Growing perpetuity present value: Present value = next-period cash flow / (discount rate − growth rate).
Money & borrowing
Annuity due present value
Annuity due present value: Annuity-due present value = payment × [1−(1+r)^−n]/r × (1+r).
Money & borrowing
Periods to reach a savings goal
Periods to reach a savings goal: Solve target = start(1+r)^n + deposit[(1+r)^n−1]/r and round up to the next whole deposit period.
Money & borrowing
Education cost inflation target
Education cost inflation target: Inflate each annual education payment separately from today, then sum the nominal payments across the study years.
Money & borrowing
Retirement income gap
Retirement income gap: Monthly income gap = max(0, desired spending − pension income − other income).
Money & borrowing
Observed annual portfolio withdrawal rate
Observed annual portfolio withdrawal rate: Observed withdrawal rate = annual withdrawal / beginning portfolio value × 100.
Money & borrowing
Fund switch fee break-even
Fund switch fee break-even: Approximate break-even years = switching cost / annual fee savings on an unchanged balance.
Money & borrowing
Holding-period return after costs
Holding-period return after costs: Holding-period return = (sale proceeds + income − costs − initial investment) / initial investment × 100.
Money & borrowing
Treasury bill bank discount yield
Treasury bill bank discount yield: Bank discount yield = (face − price)/face × 360/days × 100.
Money & borrowing
Bond Macaulay duration
Bond Macaulay duration: Discount each payment at yield/frequency.
Money & borrowing
Bond modified duration price sensitivity
Bond modified duration price sensitivity: Modified duration = Macaulay duration / (1 + nominal yield/frequency), approximating fractional price sensitivity to yield.
Money & borrowing
Gordon dividend growth valuation
Gordon dividend growth valuation: Model value = last dividend × (1+growth) / (required return − growth), with required return greater than growth.
Money & borrowing
Preferred share current yield
Preferred share current yield: Current yield = annual preferred dividend / current price × 100.
Money & borrowing
Stock split share and cost adjustment
Stock split share and cost adjustment: Shares after split = old shares × new/old ratio.
Money & borrowing
Theoretical ex-rights price
Theoretical ex-rights price: TERP = (existing share count × old price + new share count × subscription price) / total share count.
Money & borrowing
Weighted average cost of capital
Weighted average cost of capital: WACC = equity weight × cost of equity + debt weight × cost of debt × (1−tax rate).
Money & borrowing
Debt service coverage ratio
Debt service coverage ratio: Debt service coverage ratio = annual net operating income / annual debt service for the same period.
Money & borrowing
Cash-out refinance net proceeds
Cash-out refinance net proceeds: Net cash proceeds = new loan − existing payoff − closing costs.
Money & borrowing
Remaining loan term from payment
Remaining loan term from payment: Remaining months = −ln(1−monthly rate × balance/payment)/ln(1+monthly rate), rounded up; zero rate uses balance/payment.
Money & borrowing
Car loan principal from monthly budget
Car loan principal from monthly budget: Affordable principal = monthly payment × [1−(1+r)^−n]/r.
Money & borrowing
Currency cross-rate calculator
Currency cross-rate calculator: Units of C per A = (B per A) × (C per B).
Money & borrowing
Canadian mortgage semiannual compounding
Canadian mortgage semiannual compounding: Convert semiannual nominal rate j to monthly rate (1+j/2)^(1/6)−1, then apply the standard monthly amortising-payment formula.