Extensions for financial calculations and analysis. All commands support math expressions in parameters (e.g. 0.05/12, 30*12).
Version 1.0.5 | 12 commands
Comprehensive financial calculators for loans, investments, and personal finance planning.
Loans & mortgages
::loan (insert) — Calculate loan payment and amortization schedule. Example: ::loan(10000, 60, 4) for $10k, 60 months, 4% interest::mortgage (insert) — Calculate mortgage payment and schedule. Example: ::mortgage(500000, 20, 6.5, 30) for $500k, 20% down, 6.5%, 30 yearsInvestment calculations
::investment (insert) — Calculate investment growth with contributions, taxes, and inflation. Example: ::investment(10000, 5000, 500, 7, 30) for initial, annual, monthly, rate, years::pv (insert) — Present value calculator. Example: ::pv(100000, 10) for future value $100k in 10 years::fv_simple (insert) — Future value (simple calculation). Example: ::fv_simple(10000, 10) for $10k in 10 years::fv (insert) — Future value (Excel FV function style). Example: ::fv(0.05/12, 120, -100, -10000) for rate, nper, pmt, pv::pmt (insert) — Payment per period (Excel PMT function). Example: ::pmt(0.05/12, 360, 500000) for monthly payment on $500k::npv (replaceLine) — Net present value from cash flows. Example: ::npv(10, -1000,500,500,500) for 10% rate with cash flows::irr (replaceLine) — Internal rate of return. Example: ::irr(-1000,300,400,500) calculates IRR from cash flowsFIRE & tax planning
::fire_amount (insert) — Calculate annual income from investments using safe withdrawal rate. Example: ::fire_amount(1000000) for income from $1M at 4%::fire_plan (insert) — Calculate path to financial independence. Example: ::fire_plan(100000, 3000, 5000) for savings, monthly additions, target expenses::tax (insert) — Calculate tax and after-tax income. Example: ::tax(100000, 25) for $100k income at 25% rate