Worksheets
- TVM (time value of money): enter four of the five variables (N, I/Y, PV, PMT, FV) and compute the fifth. Loan payment, future value of a deposit, the interest rate on a lease.
- Cash flow: CF0 and subsequent cash flows (with frequency). NPV, IRR, MIRR, NFV, simple and discounted payback period. More: investment calculator.
- Amortisation: principal, interest and balance of an annuity loan for any range of periods (P1–P2). The full schedule is below.
- Bond: from the settlement and redemption dates and the coupon, it calculates the price from the yield or the yield from the price, accrued interest (AI) and modified duration.
- Interest conversion: between nominal and effective annual rates. Date: actual days and 30/360 between two dates. Break-even: any one of FC, VC, P, PFT, Q. % change: percent change and compound annual growth rate (CAGR).
Formulas
TVM: PV × (1 + i)^N + PMT × (1 + i × t) × ((1 + i)^N − 1) ÷ i + FV = 0
i = (1 + I/Y ÷ C/Y)^(C/Y ÷ P/Y) − 1, t = 1 (BGN) or 0 (END)
NPV = Σ CFt ÷ (1 + I)^t, IRR: NPV = 0
EFF = (1 + NOM ÷ C/Y)^C/Y − 1
Example: a 50,000 ₼ loan, 18% a year, 36 months (P/Y = C/Y = 12): PMT = −1,807.62 ₼. This is the same result as the loan calculator.
Bond results are calculated with the standard formula used in financial calculators (taking into account the fraction of the coupon period). For Azerbaijani government and corporate bonds, check the market convention in the issuer's prospectus.
Frequently asked questions
How is it different from the BA II Plus?
The calculation rules and the sign convention are the same: cash outflows are negative, cash inflows are positive. The difference is the interface: instead of key sequences, each worksheet has its own form, and all values are visible at once.
Why does IRR show "cannot be computed"?
For IRR, the cash flows must include at least one negative and one positive amount. Cash flows that change sign several times can have several IRRs: in such cases MIRR is more reliable.
When I compute I/Y, the result is not what I expected
Check the signs of PV and PMT: one must be positive and the other negative. Also check that P/Y and C/Y match the payment frequency (12 for monthly).