WorstCase GAS
WorstCase GAS
WorstCase GAS
10/8/2024
DEPRECIATION Taxes
- Depreciation Methodology Used: Straight line Tax rate assumed in the model: 25%
- Dividend ratio 35% Additional tax assumption in "Other Assumptions" box
Big 4 deposit Interest Rate
- VCB 4.60%
- BIDV 4.70%
AGR 4.70%
VTB 4.70%
Average Interest Rates 4.68%
Income Statement
Cost Adjustments - Gain/ (Loss) Billion 26 26 26 26 26 26
Income Tax
Reduction in EBT for timing differences Billion 0 0 0 0 0 0
ECONOMIC SCENARIOS
Cost Inflation 7.00% 7.00% 7.00% 7.00% 7.00% 7.00%
Base Case 6.50% 5.50% 6% 6% 5.50% 6%
Best Case 5.50% 5.50% 6% 5.50% 5% 5%
Worst Case 7% 7% 7% 7% 7% 7%
SALES SCENARIOS
Sales Annual Forecast 91987 96587 101416 108515 116111 124239
Sales Forecast - VND/ Billion
Base Case 95820 100611 105642 113036 120949 129415
Best Case:+4,0% 99653 104635 109867 117558 125787 134592
Worst Case:-4,0% 91987 96587 101416 108515 116111 124239
Revenue
Gross Revenue 89,953.00 91,987.20 96,586.56 101,415.89 108,515.00 116,111.05 124,238.82
Freight & Warehousing 0 26 26 26 26 26 26
Net Revenue 89,953.00 92,013.20 96,612.56 101,441.89 108,541.00 116,137.05 124,264.82
Fixed Costs
Operating Labour #REF! 1,346.00 1,440.22 1,541.04 1,648.91 1,764.33 1,887.83 2,019.98
Other #REF! 1,524.66 1,631.39 1,745.58 1,867.77 1,998.52 2,138.41 2,288.10
Total Fixed Costs #REF! 2,870.66 3,071.61 3,286.62 3,516.68 3,762.85 4,026.25 4,308.09
Total Costs #REF! 76,749.51 82,121.98 87,870.52 94,021.45 100,602.96 107,645.16 115,180.33
Cost of Sales 65,006.00 79,409.00 76,749.51 82,121.98 87,870.52 94,021.45 100,602.96 107,645.16 115,180.33
S, & G & A 3,611.50 3,514.39 4,018.60 4,299.90 4,600.90 4,922.96 5,267.56 5,636.29 6,030.83
Total Costs 68,617.50 82,923.39 80,768.11 86,421.88 92,471.41 98,944.41 105,870.52 113,281.46 121,211.16
Financial Revenue 1,186.81 1,451.12 2,273.00 2,727.60 3,273.12 3,927.74 4,713.29 5,655.95 6,787.14
Financial fees 403.00 169.00 587.00 818.28 981.94 1,178.32 1,413.99 1,696.79 2,036.14
Net revenue from financial activities 783.81 1,282.12 1,686.00 1,909.32 2,291.18 2,749.42 3,299.30 3,959.17 4,751.00
Cost Adjustements - Gain/ (Loss) - - - 26.00 26.00 26.00 26.00 26.00 26.00
EBIT 10,374.50 17,799.61 10,870.89 7,500.64 6,432.33 5,246.90 5,969.78 6,814.76 7,804.66
Interest 304.00 336.00 339.00 292.02 284.38 439.71 670.31 1,077.09 1,559.19
EBT 11,204.00 9,978.00 14,619.00 7,208.62 6,147.95 4,807.19 5,299.47 5,737.67 6,245.47
Current Income Taxes 2,304.00 2,037.00 2,812.00 1,441.72 1,229.59 961.44 1,059.89 1,147.53 1,249.09
Deferred Income Taxes 48.91 - 31.05 33.85 0 0 0 0 0 0
Total Income Taxes 1,441.72 1,229.59 961.44 1,059.89 1,147.53 1,249.09
Net Income 8,851.80 7,971.80 11,606.00 5,766.90 4,918.36 3,845.75 4,239.58 4,590.14 4,996.38
Margins
Net profit margin 6.27% 5.09% 3.79% 3.91% 3.95% 4.02%
EBIT Margin 8.15% 6.66% 5.17% 5.50% 5.87% 6.28%
Return on Equity 7.22% 4.33% 2.69% 2.39% 2.24% 2.13%
Investing Activities
CAPEX 8000.00 9500.00 7500.00 7500.00 3000.00 3000.00
Other 0.00 0.00 0.00 0.00 0.00 0.00
Investing Cash Flow 8000.00 9500.00 7500.00 7500.00 3000.00 3000.00
Financing Activities
Revolver Issuance/ (Repayment) (1604.8) 0.0 0.0 0.0 0.0 0.0
Team Debt Issuance/ (Repayment) (1000.0) (1000.0) (1000.0) 800.0 800.0 800.0
Common Shares Issuance 0.0 0.0 0.0 0.0 0.0 0.0
Common Dividends 2018.4 1721.4 1346.0 1483.9 1606.5 1748.7
Financing Cash Flow (586.4) 721.4 346.0 2283.9 2406.5 2548.7
Changes in the cash position 0 0 0 25,362.86 19543.67716 16727.65033 20450.22932 16738.71236 17910.99744
Beginning Cash - - - +25,363 +44,907 +61,634 +82,084 +98,823
Ending Cash 0 0 0 25362.85604 44906.5332 61634.18353 82084.41285 98823.12521 116734.1226
ASSETS
Cash and equivalent cash 5,300.33 10,549.34 5,668.90 25,362.86 44,906.53 61,634.18 82,084.41 98,823.13 116,734.12
Cash 1,395.85 1,318.14 1,156.47 7,608.86 13,471.96 18,490.26 24,625.32 29,646.94 35,020.24
Short-term investment 24,799.83 23,726.00 35,084.64 40,346.60 46,398.59 53,358.38 61,362.14 70,566.46 81,151.42
Account receivable 16,920.20 16,191.00 16,865.00 20,106.49 21,169.66 22,228.14 23,784.11 25,379.46 27,230.43
Customers receivable 10,598.40 9,210.00 12,541.00 12,063.90 12,701.79 13,336.88 14,270.47 15,227.68 16,338.26
Inventory 3,241.22 4,102.44 3,944.54 4,523.96 4,763.17 5,001.33 5,351.42 5,710.38 6,126.85
Other 1,133.16 1,082.30 654.35 753.99 793.86 833.56 891.90 951.73 1,021.14
Prepaid expense 70.00 83.67 60.63 100.53 105.85 111.14 118.92 126.90 136.15
Total Current Assets 51,394.73 55,651.08 62,217.43 91,093.90 118,031.82 143,055.59 173,473.99 201,431.15 232,263.96
Long account receivable 187.72 168.69 318.10 318.10 318.10 318.10 318.10 318.10 318.10
Net PP&E 18,098.00 16,369.00 19,532.00 27,532.00 37,032.00 44,532.00 52,032.00 55,032.00 58,032.00
Real estate investment 21.93 36.27 31.73 35.00 35.00 35.00 35.00 35.00 35.00
Work-in-progress 4,871.00 5,978.00 1,780.00 1,860.10 1,943.80 2,021.56 2,102.42 2,186.52 2,263.04
Long-term investment 400.61 405.53 398.01 415.92 434.64 452.02 470.10 488.91 506.02
Other 3,794.00 4,052.00 3,475.00 3,475.00 3,475.00 3,475.00 3,475.00 3,475.00 3,475.00
Total Long Term Assets 27,373.26 27,009.49 25,534.84 33,636.12 43,238.55 50,833.68 58,432.63 61,535.53 64,629.17
Total Assets 78,768.00 82,660.57 87,752.27 124,730.03 161,270.36 193,889.27 231,906.61 262,966.68 296,893.13
Long-term payable 10,014.00 9,001.13 7,483.89 18,095.84 19,052.69 20,005.33 21,405.70 22,841.52 24,507.38
Long-term interest payable 7,510.00 6,037.96 4,270.50 15,381.47 16,194.79 17,004.53 18,194.84 19,415.29 20,831.28
Total Long Term Liabilties 10,014.00 9,001.13 7,483.89 18,095.84 19,052.69 20,005.33 21,405.70 22,841.52 24,507.38
Total Liabilties 26,575.00 21,489.09 22,455.83 44,841.58 47,749.04 50,710.41 54,260.14 57,899.72 62,122.44
Equity 52,192.73 61,173.56 65,298.62 79,888.45 113,521.32 143,178.86 177,646.47 205,066.96 234,770.69
Shareholder's Equity 52,192.73 61,173.56 65,298.62 79,888.45 113,521.32 143,178.86 177,646.47 205,066.96 234,770.69
Total Liabilities and Shareholders' Equity 78,767.73 82,662.65 87,754.45 124,730.03 161,270.36 193,889.27 231,906.61 262,966.68 296,893.13
CAPEX
2025F 8,000.00 800.00 400.00 800.00 800.00 800.00 800.00
2026F 9,500.00 950.00 475.00 950.00 950.00 950.00
2027F 7,500.00 750.00 375.00 750.00 750.00
2028F 7,500.00 750.00 375.00 750.00
2029F 3,000.00 300.00 150.00
2030F 3,000.00 300.00
Days per year (days) 365 365 366 365 365 365 366 365
Account Balances
Accounts Receivable (days) 78.18 58.67 68.43 80.00 80.00 80.00 80.00 80.00 80.00
Inventories (days) 17.24 18.06 17.83 18.00 18.00 18.00 18.00 18.00 18.00
Prepaid rec (days) 0.32 0.30 0.25 0.40 0.40 0.40 0.40 0.40 0.40
Other Assets (days) 5.24 3.92 2.66 3.00 3.00 3.00 3.00 3.00 3.00
Accounts Payable (days) 92.99 57.40 71.20 72.00 72.00 72.00 72.00 72.00 72.00
Other Liabilities (days) 8.25 3.84 2.97 4.00 4.00 4.00 4.00 4.00 4.00
Long term receivable 46.27 32.62 30.37 1.00 1.00 1.00 1.00 1.00 1.00
Account Balances
Accounts Receivable (VND/ Billion) 20,106.49 21,169.66 22,228.14 23,784.11 25,379.46 27,230.43
Inventories (VND/ Billion) 4,523.96 4,763.17 5,001.33 5,351.42 5,710.38 6,126.85
Prepaid expenses (VND/ Billion) 100.53 105.85 111.14 118.92 126.90 136.15
Other Assets (VND/ Billion) 753.99 793.86 833.56 891.90 951.73 1,021.14
Long-term receivable (VND/ Billion) 18,095.84 19,052.69 20,005.33 21,405.70 22,841.52 24,507.38
Accounts Payable (VND/ Billion) 16,155.14 17,333.36 18,546.70 19,844.97 21,176.10 22,720.50
Other Liabilities (VND/ Billion) 897.51 962.96 1,030.37 1,102.50 1,176.45 1,262.25
Net Working Capital (VND/ Billion) 0 8432 8536 8597 9199 9816 10532
Change in Working Capital (VND/ Billion) 8432 104 61 602 617 716
Revolver
Operating Cash Flow 17,949.22 9,322.25 8,881.64 10,666.38 11,332.16 12,362.27
Investing Cash Flow (8000) (9500) (7500) (7500) (3000) (3000)
Mandotory Debt Repayments (1000) (1000) (1000) +800 +800 +800
Common Stock Issuance/ (Buy-back) 0 0 0 0 0 0
Dividends (2018) (1721) (1346) (1484) (1607) (1749)
FCF After Mandatory Debt Repayment 6930.8 (2899.2) (964.4) 2482.5 7525.6 8413.5
and Dividend