Navigation
Óíèâåðñàëüíàÿ ÑòðàòÌîäåëü
Àíàëèç äèñêîíòèðîâàííûõ äåíåæíûõ ïîòîêîâ                
            Êîíåö ôèíàíñîâîãî ãîäà
(â òûñ. RUB, åñëè íå óêàçàíî èíîå)         ìàð-15 ìàð-16 ìàð-17 ìàð-18 ìàð-19
EBITDA òûñ. RUB   9 074.5  256 762.0  478 467.3  678 709.1  860 828.3 
Íàëîã íà ïðèáûëü äî âûïëàòû ïðîöåíòîâ òûñ. RUB   (314.9) (45 852.4) (86 193.5) (122 241.8) (154 665.7)
×èñòîå èçì.â ðàá.êàï. è ïðî÷èõ òûñ. RUB   (13 798.5) (7 286.2) (6 743.0) (6 306.3) (5 962.3)
Êàïèòàëîâëîæåíèÿ òûñ. RUB   (200 000.0) (200 000.0) (200 000.0) (200 000.0) (200 000.0)
Ðåç-òû ÷ðåçâû÷-õ îáñòîÿòåëüñòâ òûñ. RUB                            -                            -                            -                            -                            -  
Äåíåæíûé ïîòîê áåç ó÷åòà ôèíàíñèðîâàíèÿ òûñ. RUB   (205 038.9) 3 623.4  185 530.8  350 161.0  500 200.4 
                   
  Äàòà Îöåíêè 01 àïð 14  
×èñòûé äîëã 31 ìàð 14 òûñ. RUB                            -   Äàòà Áàëàíñîâîé îò÷åòíîñòè 31 ìàð 14  
   
Èíâåñòèð-íûé êàïèòàë[1] òûñ. RUB                            -   Äàòà Èíâåñòèöèé[2] 31 ìàð 14  
                   
(â òûñ. RUB, åñëè íå óêàçàíî èíîå) Ìóëüòèïëèêàòîð EBITDA Òåðì. Ñòîèìîñòè     Ìóëüòèïëèêàòîð EBITDA Òåðì. Ñòîèìîñòè
  6.5x  7.0x  7.5x  6.5x  7.0x  7.5x 
  TV 5 595 384.1  6 025 798.3  6 456 212.4  5 595 384.1  6 025 798.3  6 456 212.4 
   
  WACC Ñòîèìîñòü Êîìïàíèè íà 01 àïð 14 WACC Ñòîèìîñòü Àêöèé íà 01 àïð 14
  12.0% 3 659 922.7  3 904 151.2  4 148 379.8  12.0% 3 659 922.7  3 904 151.2  4 148 379.8 
  12.5% 3 579 251.0  3 818 100.3  4 056 949.6  12.5% 3 579 251.0  3 818 100.3  4 056 949.6 
  13.0% 3 500 656.9  3 734 268.5  3 967 880.0  13.0% 3 500 656.9  3 734 268.5  3 967 880.0 
   
  WACC Âìåíåííàÿ íîðìà ðîñòà çà ïðîãíîçíûì ïåðèîäîì Èíâ. êàïèòàë IRR íà Èíâåñòèð-íûé êàïèòàë
  12.0% 2.8% 3.4% 3.9% 0  151.4% 154.9% 158.4%
  12.5% 3.3% 3.9% 4.4% 0  151.4% 154.9% 158.4%
  13.0% 3.7% 4.3% 4.9% 0  151.4% 154.9% 158.4%
                   
Ðàñ÷åò íàëîãà íà ïðèáûëü áåç ó÷åòà âûïëàòû ïðîöåíòîâ
            Êîíåö ôèíàíñîâîãî ãîäà
(â òûñ. RUB, åñëè íå óêàçàíî èíîå)         ìàð-15 ìàð-16 ìàð-17 ìàð-18 ìàð-19
Ðàñ÷åò íàëîãîîáëàãàåìîé ïðèáûëè                  
EBIT òûñ. RUB   1 574.5  229 262.0  430 967.3  611 209.1  773 328.3 
Ðó÷íàÿ êîððåêòèðîâêà íàëîãà íà ïðèáûëü 1 òûñ. RUB                            -                            -                            -                            -                            -  
Ðó÷íàÿ êîððåêòèðîâêà íàëîãà íà ïðèáûëü 2 òûñ. RUB                            -                            -                            -                            -                            -  
Ñóììàðíàÿ íàëîãîîáëàãàåìàÿ ïðèáûëü òûñ. RUB   1 574.5  229 262.0  430 967.3  611 209.1  773 328.3 
Ñòàâêà íàëîãà íà ïðèáûëü òûñ. RUB   20.0% 20.0% 20.0% 20.0% 20.0%
Íàëîã íà ïðèáûëü - Ôàêòè÷åñêèå ïëàòåæè òûñ. RUB   (314.9) (45 852.4) (86 193.5) (122 241.8) (154 665.7)
Íîðìàòèâíûå íà÷èñëåíèÿ íàëîãà çà ïåðèîä òûñ. RUB   (314.9) (45 852.4) (86 193.5) (122 241.8) (154 665.7)
Ðàñ÷åò èñïîëüçîâàíèå óáûòêîâ ïðîøëûõ ïåðèîä òûñ. RUB  
Íàêîïëåííûé íàëîãîâûé ùèò - ÍÏ òûñ. RUB                            -                            -                            -                            -                            -  
Íàëîãîâûé ùèò Ñîçäàííûé òûñ. RUB                            -                            -                            -                            -                            -  
Íàëîãîâûé ùèò Èñïîëüçîâàííûé òûñ. RUB                            -                            -                            -                            -                            -  
Íàêîïëåííûé íàëîãîâûé ùèò - ÊÏ òûñ. RUB                                  -                            -                            -                            -                            -  
Äèñêîíòèðóþùèé ôàêòîð Äëÿ TV
WACC 12.0%         94.5% 84.4% 75.3% 67.3% 60.1% 56.7%
WACC 12.5% 94.3% 83.8% 74.5% 66.2% 58.9% 55.5%
WACC 13.0% 94.1% 83.2% 73.7% 65.2% 57.7% 54.3%
Êîýôôèöèåíò ïðèâåäåíèÿ ê ñðåäíåãîäîâîìó äèñêîíòèðîâàíèþ       0.5  1.5  2.5  3.5  4.5  5.0 
Ðàñ÷åò IRR
          Êîíåö ôèíàíñîâîãî ãîäà
(â òûñ. RUB, åñëè íå óêàçàíî èíîå)       ìàð-14 ìàð-15 ìàð-16 ìàð-17 ìàð-18 ìàð-19
Äåíåæíûé ïîòîê áåç ó÷åòà ôèíàíñèðîâàíèÿ (äëÿ IRR)     (205 038.9) 3 623.4  185 530.8  350 161.0  500 200.4 
         
Ìóëüòèïëèêàòîðû Òåðìèíàëüíîé ñòîèìîñòè IRR Èíâåñòèð-íûé êàïèòàë Äåíåæíûé ïîòîê âêëþ÷àÿ Òåðìèíàëüíóþ ñòîèìîñòü
6.5x        151.4%                          -   (205 038.9) 3 623.4  185 530.8  350 161.0  6 095 584.5 
7.0x  154.9%                          -   (205 038.9) 3 623.4  185 530.8  350 161.0  6 525 998.6 
7.5x        158.4%                          -   (205 038.9) 3 623.4  185 530.8  350 161.0  6 956 412.8 
6.5x        151.4%                          -   (205 038.9) 3 623.4  185 530.8  350 161.0  6 095 584.5 
7.0x  154.9%                          -   (205 038.9) 3 623.4  185 530.8  350 161.0  6 525 998.6 
7.5x        158.4%                          -   (205 038.9) 3 623.4  185 530.8  350 161.0  6 956 412.8 
6.5x        151.4%                          -   (205 038.9) 3 623.4  185 530.8  350 161.0  6 095 584.5 
7.0x  154.9%                          -   (205 038.9) 3 623.4  185 530.8  350 161.0  6 525 998.6 
7.5x        158.4%                          -   (205 038.9) 3 623.4  185 530.8  350 161.0  6 956 412.8 
>> Êîíåö Òàáëèöû                    

[1]
ÔèíÐîáîò:
Ïðåäïîëîæåíèÿ ïî óìîë÷àíèþ, ïîäðîáíåå ñì. â ðóêîâîäñòâå
[2]
FinRobot:
Ïðåäïîëîæåíèÿ ïî óìîë÷àíèþ, ïîäðîáíåå ñì. â ðóêîâîäñòâå
[3]
ÔèíÐîáîò:
Äëÿ êîððåêòíîãî èñïîëüçîâàíèÿ ôóíêöèè ×ÈÑÒÂÍÄÎÕ íåîáõîäèìî óáåäèòüñÿ, ÷òî óñòàíîâëåí «Ïàêåò Àíàëèçà» â íàäñòðîéêàõ Microsoft Excel.