Scribd Logo
Upload

Welcome to Scribd!

  • 21 views

    Valuation Goto

    Uploaded by

    insta insta
    The document presents financial projections for a company from 2022-2030 including EBIT growth rates, EBIT, taxes, free cash flows, weighted average cost of capital, and discounted cash flow valuation to estimate an intrinsic value per share of $144 compared to the current share price of $91, indicating the stock is overvalued. Key figures include estimated free cash flows ranging from $19.4 million to $95.1 million and an intrinsic value per share of $144 compared to the current $91 share price.

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd

    Valuation Goto

    Uploaded by

    insta insta
    21 views13 pages
    The document presents financial projections for a company from 2022-2030 including EBIT growth rates, EBIT, taxes, free cash flows, weighted average cost of capital, and discounted cash flow valuation to estimate an intrinsic value per share of $144 compared to the current share price of $91, indicating the stock is overvalued. Key figures include estimated free cash flows ranging from $19.4 million to $95.1 million and an intrinsic value per share of $144 compared to the current $91 share price.

    Original Title

    VALUATION GOTO

    Copyright

    © © All Rights Reserved

    Available Formats

    XLSX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    The document presents financial projections for a company from 2022-2030 including EBIT growth rates, EBIT, taxes, free cash flows, weighted average cost of capital, and discounted cash flow valuation to estimate an intrinsic value per share of $144 compared to the current share price of $91, indicating the stock is overvalued. Key figures include estimated free cash flows ranging from $19.4 million to $95.1 million and an intrinsic value per share of $144 compared to the current $91 share price.

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd
    Download as xlsx, pdf, or txt
    21 views13 pages

    Valuation Goto

    Uploaded by

    insta insta
    The document presents financial projections for a company from 2022-2030 including EBIT growth rates, EBIT, taxes, free cash flows, weighted average cost of capital, and discounted cash flow valuation to estimate an intrinsic value per share of $144 compared to the current share price of $91, indicating the stock is overvalued. Key figures include estimated free cash flows ranging from $19.4 million to $95.1 million and an intrinsic value per share of $144 compared to the current $91 share price.

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd
    Download as xlsx, pdf, or txt
    of 13

    2022 2023 2024

    BASE YEAR 1 2
    EBIT GROWTH RATE 35.49% 32.23% 28.98%
    EBIT - 30,329,628 - 40,106,372 - 51,727,990
    TAX RATE 22% 22% 22%
    EBIT AFTER TAX = NOPAT = EBIT (1 - T) - 23,657,110 - 31,282,970 - 40,347,832
    LESS NET CAPITAL SPENDING 2,460,751 3,253,973 4,196,877
    LESS CHANGE IN NET WORKING CAPITAL 1,751,982 2,316,733 2,988,052
    FREE CASH FLOW TO THE FIRM - 19,444,377 - 25,712,264 - 33,162,904
    WEIGHTED AVERAGE COST OF CAPITAL 29.3028% 29.3028%
    PRESENT VALUE OF FCFF - 19,885,310 - 19,835,203
    SUM OF PV - 178,305,965
    LESS DEBT - 2,441,756
    ADD CASH AND CASH EQUIVALENTS 29,009,177
    VALUE OF EQUITY - 151,738,544
    NUMBER OF SHARES OUTSTANDING 1,050,178
    ESTIMATED INTRINSIC VALUE PER SHARE - 144
    SHARE PRICE 91
    PRICE AS A PERCENTAGE OF INTRINSIC VALUE -63%
    THE STOCK IS OVERVALUED

    CAPITAL EXPENDITURES 452,136


    LESS DEPRECIATION AND AMORTIZATION EXPENSES 2,912,887
    EQUALS NET CAPITAL SPENDING - 2,460,751

    CHANGE IN NET WORKING CAPITAL - 1,751,982


    2025 2026 2027 2028
    3 4 5 6
    25.72% 22.46% 19.20% 15.95%
    - 65,031,918 - 79,638,760 - 94,931,839 - 110,068,801
    22% 22% 22% 22%
    - 50,724,896 - 62,118,233 - 74,046,834 - 85,853,665
    5,276,272 6,461,377 7,702,159 8,930,275
    3,756,550 4,600,309 5,483,710 6,358,092
    - 41,692,075 - 51,056,546 - 60,860,966 - 70,565,298
    29.3028% 29.3028% 29.3028% 29.3028%
    - 19,285,444 - 18,264,997 - 16,838,332 - 15,098,835
    2029 2030 2031 2032
    7 8 9 10
    12.69% 9.43% 6.17% 2.91%
    - 124,033,350 - 135,728,620 - 144,104,648 - 148,302,680
    22% 22% 22% 22%
    - 96,746,013 - 105,868,324 - 112,401,626 - 115,676,090
    10,063,269 11,012,148 11,691,725 12,032,326
    7,164,750 7,840,324 8,324,162 8,566,660
    - 79,517,995 - 87,015,853 - 92,385,739 - 95,077,104
    29.3028% 29.3028% 29.3028% 29.3028%
    - 13,158,601 - 11,136,141 - 9,143,939 - 7,277,738
    TERMINAL YEAR
    2.91%

    CURRENT YEAR PRIOR YEAR


    CURRENT ASSETS 34,180,478 36,063,697
    CURRENT LIABILITIES 12,162,456 12,293,693
    WORKING CAPITAL 22,018,022 23,770,004
    - 370,777,810 CHANGE IN WORKING CAPITAL - 1,751,982
    29.3028%
    - 28,381,424
    CASH, CURRENT YEAR 29,009,177
    EBIT, PRIOR YEAR - 22,384,656
    EBIT, CURRENT YEAR - 30,329,628

    CAGR COMPUTED MANUALLY 35.49%


    GROWTH RATE 35.49%
    GROWTH RATE 35.49%
    CAGR COMPUTED ON EXCEL #NAME?

    CAGR = COMPOUND AVERAGE GROWTH RATE


    OWTH RATE
    TOTAL 2,912,887 TOTAL
    DEPRECIATION EXPENSE 2,912,887 CAPEX
    CAPEX
    452,136 TOTAL DEB 2,441,756
    104,398 DEBT 413,259
    347,738 DEBT 21,622
    DEBT 180,605
    DEBT 1,102,048
    DEBT 724,222
    SHARES 1,184,363,929,502
    LESS TREASURY SHARES 134,185,580,200
    SHARES ISSUED AND OUTSTANDING 1,050,178,349,302

    MILLIONS 1,000,000
    SHARES 1,050,178
    SHARE PRICE 91.00
    INA GDP INA GDP
    GROWTH RATE (US$ BN) YEAR
    892.97 2011
    2.79% 917.87 2012
    -0.58% 912.52 2013
    -2.38% 890.81 2014
    -3.36% 860.85 2015
    8.25% 931.88 2016
    7.52% 1002 2017
    0.20% 1004 2018
    11.55% 1120 2019
    -10.18% 1006 2020
    18.29% 1190 2021

    3.21% AGR
    2.91% CAGR

    You might also like