Syntha Lab RU

Financial mathematics: time value, NPV, IRR, MIRR, annuity, leasing and currency

The calculation base of investment and financing decisions: discounting, NPV, IRR and MIRR, payback (simple and discounted), annuity payments, the lease-versus-buy choice, the effect of the exchange rate on margin and a forward. The decision: whether to invest, how to finance and how to hedge the rate.

Math and analytics Brand and retail Verified: 2026-11-13

Open interactively →

Why this document

The finance director and the owner read this when they decide whether to invest in a store, warehouse or equipment, or to choose between leasing and buying. Money today is worth more than money tomorrow, so projects are compared by NPV and IRR, not by total income. Simple payback hides that late flows are worth less, so it is supplemented with discounted payback. When purchases are in foreign currency, the exchange rate moves margin directly, so the break-even rate is calculated in advance. Without this, a project is chosen by feel, not by the price of money.

At a glance

What is this document and why is it needed?
The calculation base of investment and financing decisions: discounting, NPV, IRR and MIRR, payback (simple and discounted), annuity payments, the lease-versus-buy choice, the effect of the exchange rate on margin and a forward. The decision: whether to invest, how to finance and how to hedge the rate.
Who owns the document and how often is it rebuilt?
Finance director or investment analyst; calculated before each project (store, equipment, new line) and when rates and FX change; the result goes to the investment committee and the budget.
What mistakes are the most common?
Payback without discounting and the project is accepted → real payback exceeds the lease term → the discounted term as a condition. Projects of different scale are compared by IRR → a small high-IRR project is chosen over a large one with a larger NPV → decide by NPV and PI. Interest is deducted in the flow and discounted at WACC → double counting of the cost of capital → interest is not deducted in project NPV.

For whom

Brand
A brand evaluates a line launch, production equipment, a warehouse and own stores; the key risk is the purchase FX rate and a long time from payment to sale. The calculation runs in cash flows with VAT on payment and VAT refund, not in profit.
Retail
A retailer evaluates opening and refitting a store, equipment, a warehouse and online; the main payback horizon is set by the lease, so the project horizon equals the lease term and store revenue follows a ramp-up curve.

What it consists of

Time value of money

  • Money today is worth more than money tomorrow: discounting brings a flow CF_t to today by dividing by (1 + r)^t. The rate r reflects the project cost of capital (WACC) or a required return with a risk premium; it must be of the same basis as the flow (nominal for nominal flows).
  • Brand: the rate is set higher for projects with FX purchase risk; Retailer: for stores the rate is raised for new formats and regions. The rate and premium are fixed in policy and revisited when the key rate changes.

NPV, IRR, MIRR, payback

  • Project: investment RUB 18 million and yearly flows 4,000, 6,000, 7,500, 8,000, 8,000 thousand RUB. At a 20% rate NPV = RUB 913 thousand, profitability index PI = 1.05, IRR = 22%. Rule: NPV > 0 means the project earns more than the cost of capital.
  • IRR assumes reinvestment of flows at the same rate; MIRR sets separate finance (20%) and reinvestment (14%) rates and in the example equals 18.8%, below IRR and below the rate: the project is borderline and the conclusion depends on the reinvestment assumption.
  • Simple payback is 3.1 years, discounted 4.7 years: the 1.7-year gap is the price of time; a decision on term (for example, no longer than the lease) uses the discounted measure.

Annuity and loan

  • Annuity payment PMT = L·i/(1 − (1 + i)^−n): for a loan of RUB 12 million over 36 months at 21% a year the payment is RUB 452 thousand a month, overpayment RUB 4.276 million; in the first payment interest is RUB 210 thousand and principal RUB 242 thousand: early payments are mostly interest.
  • Loan interest is not deducted in project NPV (it is already in the discount rate); financing cost is shown separately, in the company cash flow and in covenants.

Leasing versus buying

  • Equipment of RUB 9 million: buying with a loan at 21% and a residual value of RUB 2 million after 3 years against leasing at RUB 300 thousand a month. At a 20% discount rate the present cost of buying is 8,021, of leasing RUB 8.072 million: a RUB 52 thousand difference in favor of buying, so the options are nearly equal and the decision is made not by arithmetic but by taxes, VAT, liquidity and covenant limits.
  • Brand: production equipment is more often bought, warehouse and transport leased; Retailer: store equipment is leased when capital is more needed in stock. Contract terms (buyout, insurance, indexation) are checked separately.

Currency: sensitivity and forward

  • A unit costs 14.5 conventional currency units plus logistics of RUB 180 at a price of RUB 3,000 excluding VAT: at RUB 92 per unit margin is 49.5%, at 110 RUB 40.8%, the break-even rate is RUB 194.5. Each +RUB 10 on the rate lowers margin by about 4.8 pp.
  • The forward rate by interest-rate parity F = S·(1 + r_RUB·T)/(1 + r_fx·T): at rates of 20% and 4% for six months F = RUB 99.2 (a premium of 7.8%). Hedging fixes the rate and the cost but not for free: the premium is the price of certainty.

Brand and retailer: financial decisions

  • Brand: a brand project: a line, factory investment, a warehouse; the flow depends on the season sales curve and on production payment in advance, so discounting is monthly and includes working capital in stock.
  • Retailer: a retailer project: a store, a refit, a format; the flow is tied to the lease term and the ramp-up curve, and the horizon equals the lease, most often 3-5 years.
  • Brand: a brand raises the discount rate for FX purchase risk and leftover risk; the premium is set through an FX scenario rather than a single number.
  • Retailer: a retailer raises the discount rate for a new region and format and for traffic risk; the premium is confirmed with data on the mature stores of the chain.
  • Brand: a brand compares leasing and loans for production equipment, a warehouse and vehicles; residual value and buyout matter, and the effect on borrower covenants is checked in advance.
  • Retailer: a retailer compares leasing and loans for store equipment and IT; premises rent (FSBU 25/2018) enters debt load and covenants, so it is counted as a liability.
  • Brand: FX sensitivity of a brand runs through cost: the currency share, the purchase rate, a forward and the contract currency; the choice between a hedge and a price revision is made by scenarios.
  • Retailer: FX sensitivity of a retailer runs through purchases from suppliers and importers and through currency-linked rents; it shows in category margin and in rent.
  • Brand: a brand shows the investment committee NPV, the robustness range by FX and demand, the financing method and the purchase revision conditions.
  • Retailer: a retailer shows the store NPV, payback before the end of the lease, sensitivity to traffic and the conditions for closing the point if the plan is missed.

Where the data comes from

Data sourceFields
Project budgetCapital expenditure by date (with and without VAT), flows by year or month, project term, residual value, working capital.
Treasury and banksLoan and lease rates, payment schedules, covenant requirements, deposit rate, exchange rates and forward quotes.
Purchasing and contractsContract currency, rate on the payment date, payment deferral, cost structure by currency.

How to build it step by step

  1. Step 1. Define the project horizon: the lease term for a store, service life for equipment, a season or cycle for a line.
  2. Brand: Step 2. Assemble flows by supplier payment dates and customer receipts including VAT and partner deferrals.
  3. Retailer: Step 3. Assemble store flows: refit investment, stock, rent, revenue along the ramp-up curve, lease term.
  4. Step 4. Choose the discount rate and risk premium; record it in the minutes.
  5. Step 5. Compute NPV, IRR, PI, simple and discounted payback; with a non-standard flow (several sign changes) IRR is not used.
  6. Step 6. Compute MIRR with reasonable finance and reinvestment rates and compare with IRR.
  7. Step 7. Build the NPV profile by rate and find the rate at which the decision flips; show the range of robustness.
  8. Step 8. For financing compare loan and lease by present cost and by effect on covenants and taxes.
  9. Step 9. Build sensitivity to the exchange rate and decide whether a forward or a change of contract currency is needed; compute the hedge cost.
  10. Step 10. Assemble the decision: NPV, robustness range, financing method, FX policy, risks and revision conditions.

Formulas

MeasureFormulasNote
DiscountingPV = CF_t / (1 + r)^tThe rate r has the same basis as the flow.
NPV and profitability indexNPV = Σ_(t=0..T) CF_t/(1 + r)^t; PI = (NPV + I₀)/I₀I₀ is the initial investment; PI > 1 when NPV > 0.
IRRIRR: the solution of Σ CF_t/(1 + IRR)^t = 0Found by iteration; with several sign changes in the flow there are several roots.
MIRRMIRR = ( FV(positive flows, r_reinv) / PV(negative flows, r_fin) )^(1/T) − 1Removes the IRR assumption of reinvestment at IRR.
Annuity paymentPMT = L·i / (1 − (1 + i)^(−n)), i = annual rate / 12Month interest = balance × i; principal = PMT − interest.
Present cost of leasingPV_lease = Σ_(k=1..n) L_k/(1 + r_m)^k; PV_buy = PV(loan payments) − residual/(1 + r_m)^nWithout taxes; the tax shield and VAT are added as a separate column.
Forward by interest parityF = S·(1 + r_RUB·T) / (1 + r_fx·T)A bank quote includes a margin; the formula gives a guide.

Formulas in notation

NPV
NPV = Σ_{t=0..T} CF_t / (1 + r)^t
Sum of discounted flows including the investment at t = 0.
Discounted payback
DPP = (t−1) + |S_{t−1}| / [ CF_t / (1+r)^t ], S_t = Σ_{k≤t} CF_k/(1+r)^k
t is the first period where the cumulative sum becomes ≥ 0.
Annuity
PMT = L·i / [ 1 − (1 + i)^{−n} ]
A constant payment over n periods at periodic rate i.
Margin at the exchange rate
m(S) = [ P − u·S − L ] / P
u currency units of cost, S the rate, L logistics, P price excluding VAT.

Worked example

A project: an investment of RUB 18 million and five years of flows, indicators at a 20% rate

YearFlow, RUB thousandDiscounted flowCumulative discounted
0−18,000−18,000−18,000
14,0003,333−14,667
26,0004,167−10,500
37,5004,340−6,160
48,0003,858−2,302
58,0003,215913

NPV RUB 913 thousand, IRR 22%, MIRR 18.8%, PI 1.05; simple payback 3.1 years, discounted 4.7 years. Leasing costs RUB 52 thousand more than buying in present cost, a 6-month forward gives RUB 99.2 at a spot of 92. Everything is illustrative and computed in code.

Figures

NPV profile by discount rate
Line chart: NPV, RUB thousand: 15,500 → −6,870; Zero: 0 → 0−10,000−5,00005,00010,00015,00020,000051015202530354045rate 20%NPV, RUB thousand, 0: 15,500NPV, RUB thousand, 5: 10,580NPV, RUB thousand, 10: 6,661NPV, RUB thousand, 15: 3,498NPV, RUB thousand, 20: 913NPV, RUB thousand, 25: −1,222NPV, RUB thousand, 30: −3,003NPV, RUB thousand, 35: −4,504NPV, RUB thousand, 40: −5,778NPV, RUB thousand, 45: −6,870Zero, 0: 0Zero, 5: 0Zero, 10: 0Zero, 15: 0Zero, 20: 0Zero, 25: 0Zero, 30: 0Zero, 35: 0Zero, 40: 0Zero, 45: 0RUB thousand
  • NPV, RUB thousand
  • Zero
Data as a table
MeasureNPV, RUB thousandZero
015,5000
510,5800
106,6610
153,4980
209130
25−1,2220
30−3,0030
35−4,5040
40−5,7780
45−6,8700

NPV profile by discount rate. The curve crosses zero at IRR; before it the project is worthwhile, after it not. Axis: discount rate, %.

Cumulative discounted flow
Bar chart: 0 −18,000, 1 −14,667, 2 −10,500, 3 −6,160, 4 −2,302, 5 913−20,000−15,000−10,000−5,00005,00000Cumulative flow, RUB thousand: −18,000−18,00011Cumulative flow, RUB thousand: −14,667−14,66722Cumulative flow, RUB thousand: −10,500−10,50033Cumulative flow, RUB thousand: −6,160−6,16044Cumulative flow, RUB thousand: −2,302−2,30255Cumulative flow, RUB thousand: 913913RUB thousand
Data as a table
MeasureCumulative flow, RUB thousand
0−18,000
1−14,667
2−10,500
3−6,160
4−2,302
5913

Cumulative discounted flow. The bar turns positive in year 5: discounted payback is 4.7 years.

Present cost: buying on a loan and leasing
Bar chart: Loan payments 9,124, Residual value −1,103, Buy total 8,021, Lease total 8,072−2,00002,0004,0006,0008,00010,000Loan paymentsLoan paymentsThousand RUB: 9,1249,124Residual valueResidual valueThousand RUB: −1,103−1,103Buy totalBuy totalThousand RUB: 8,0218,021Lease totalLease totalThousand RUB: 8,0728,072RUB thousand
Data as a table
MeasureThousand RUB
Loan payments9,124
Residual value−1,103
Buy total8,021
Lease total8,072

Present cost: buying on a loan and leasing. The difference is within 1% of the price: taxes, VAT and liquidity decide.

Margin and purchase exchange rate
Line chart: Margin, %: 55.3 → 3535404550556080869298104110116122Margin, %, 80: 55.3Margin, %, 86: 52.4Margin, %, 92: 49.5Margin, %, 98: 46.6Margin, %, 104: 43.7Margin, %, 110: 40.8Margin, %, 116: 37.9Margin, %, 122: 35%
Data as a table
MeasureMargin, %
8055.3
8652.4
9249.5
9846.6
10443.7
11040.8
11637.9
12235

Margin and purchase exchange rate. Each +RUB 6 on the rate lowers margin by almost 3 pp; the break-even rate is about RUB 194. Axis: rate, RUB per currency unit.

Specifics by category

Apparel
Working capital and seasonal stock make up most of the investment; the flow profile follows seasons, so compute monthly rather than yearly and include markdown of leftovers.
Footwear
A high unit price and a long production cycle increase capital need and FX purchase risk; payback is longer and sensitivity to FX higher than for apparel.
Accessories
Small investment per unit and high turnover at the peak: projects pay back faster but the currency share of cost is often high (imported materials and fittings).
Kids
Turnover and size risk: part of the stock is lost, so the rate with a risk premium is higher; the school season concentrates flow in a few months.
Men
A steady flow and repeat purchases allow a lower risk premium and a long horizon; basic line projects withstand a rate rise better.
Women
Short cycles and fashion risk: a shorter horizon, a higher rate, flows grow fast and fall as fast; the calculation includes a weak-demand scenario.

Common mistakes

  • Payback without discounting and the project is accepted → real payback exceeds the lease term → the discounted term as a condition.
  • Projects of different scale are compared by IRR → a small high-IRR project is chosen over a large one with a larger NPV → decide by NPV and PI.
  • Interest is deducted in the flow and discounted at WACC → double counting of the cost of capital → interest is not deducted in project NPV.
  • Leasing and buying are compared without VAT, taxes and residual value → a wrong conclusion → a common base and separate tax columns.
  • FX sensitivity is not shown → a rate jump destroys season margin → an FX scenario and a hedging policy.

Russian specifics

  • Leasing contracts are governed by the law on financial lease; tax and accounting treatment of leased assets (FSBU 25/2018 for leases) affects the balance sheet and covenants, so the lease calculation is agreed with accounting. Rule: Law 164-FZ of 29.10.1998: Federal Law of 29.10.1998 No. 164-FZ on financial lease (leasing) (rule check not completed).
  • Currency settlements under import contracts fall under currency regulation and control; exchange differences are recognized in reporting, and payment terms and currency are fixed in the contract. Rule: Law 173-FZ of 10.12.2003: Federal Law of 10.12.2003 No. 173-FZ on currency regulation and control (rule check not completed).
  • Input VAT on capital investment is deducted when conditions are met (Art. 171 of the Tax Code): in the project flow the investment is shown with VAT at payment and the VAT refund as a separate line. Rule: Tax Code Art. 171: Tax Code, Art. 171 (VAT deductions) (rule check not completed).

Open interactively →