YieldraPayment per period
Payment per period. The five registers balance to zero. Money in is +, money out is −; r is the rate per payment period.
OpenYieldra
Explore the library
N, I/Y, PV, PMT and FV stay on screen while you type, so a wrong P/Y shows before you press CPT.
Present value
Present value. The five registers balance to zero. Money in is +, money out is −; r is the rate per payment period.
OpenFV
FV. The five registers balance to zero. Money in is +, money out is −; r is the rate per payment period.
OpenNPV · Cash flow
NPV · Cash flow. Each flow is discounted back to period 0 at rate I and added up.
OpenIRR · Cash flow
IRR · Cash flow. IRR is the rate that makes NPV exactly zero; it is found by iteration.
OpenMIRR · Cash flow
MIRR · Cash flow. MIRR discounts outflows at rate I and grows inflows at the reinvestment rate RI, so it gives one answer even when IRR has several.
OpenPayback
Payback. Uses undiscounted cash flows at equal intervals. A fractional recovery period is a linear estimate.
OpenAmortization
Amortization. Each payment first covers the period's interest on the balance; the rest repays principal.
OpenEffective annual rate (%)
Effective annual rate (%). The effective rate is what the nominal rate becomes once compounding is counted.
OpenNominal annual rate (%)
Nominal annual rate (%). The effective rate is what the nominal rate becomes once compounding is counted.
OpenPercent change
Percent change. The new value is the old value grown by the change for the given number of periods.
OpenNew value
New value. The new value is the old value grown by the change for the given number of periods.
OpenProfit margin
Profit margin. Margin is profit as a share of the selling price; markup is profit as a share of cost.
OpenBreakeven
Breakeven. At breakeven, revenue exactly covers fixed and variable costs.
OpenDepreciation
Depreciation. Straight line spreads cost minus salvage evenly; the other methods take more in the early years.
OpenDates
Dates. Counts actual calendar days, excluding the start date. No business-day or 30/360 adjustment.
OpenBond
Bond. Discounts regular coupons and redemption at the yield. Settlement is on a coupon date; accrued interest and irregular periods are excluded.
OpenExtra payments
Extra payments. Every extra amount goes straight to principal, so later periods charge interest on a smaller balance and the loan ends early.
OpenNo matching entries. Try another term.
Page language