Estimation of the weighted average cost of capital WACC . With Explanations how did you estimated.
Fantastic news! We've Found the answer you've been seeking!
Question:
Estimation of the weighted average cost of capital " WACC" . With Explanations how did you estimated.
Item | 06/20 | 06/21 | 06/22 | 06/23 |
Operating Revenue | 13,260,236,048.00 | 13,654,296,355.00 | 15,231,673,682.00 | 19,870,286,576.00 |
Other Revenue | 73,291,563.00 | 59,457,302.00 | 118,449,702.00 | 205,128,205.00 |
Total Revenue Excluding Interest | 13,333,527,611.00 | 13,713,753,657.00 | 15,350,123,385.00 | 20,075,414,781.00 |
Operating Expenses | -8,763,660,206.00 | -8,766,161,213.00 | -10,112,062,708.00 | -14,193,061,840.00 |
EBITDA | 4,569,867,404.00 | 4,947,592,444.00 | 5,238,060,676.00 | 5,882,352,941.00 |
Depreciation | -506,046,918.00 | -531,258,313.00 | -646,973,435.00 | -739,064,856.00 |
Amortisation | -105,638,933.00 | -127,560,521.00 | -140,513,862.00 | -514,328,808.00 |
Depreciation and Amortisation | -611,685,851.00 | -658,818,834.00 | -787,487,298.00 | -1,253,393,665.00 |
EBIT | 3,958,181,553.00 | 4,288,773,610.00 | 4,450,573,377.00 | 4,628,959,276.00 |
Interest Revenue | 10,199,621.00 | 5,187,549.00 | 25,257,657.00 | 57,315,233.00 |
Interest Expense | -219,728,981.00 | -227,188,081.00 | -258,382,929.00 | -669,683,257.00 |
Net Interest Expense | -209,529,360.00 | -222,000,532.00 | -233,125,272.00 | -612,368,024.00 |
PreTax Profit | 3,748,652,192.00 | 4,066,773,077.00 | 4,217,448,105.00 | 4,016,591,251.00 |
Tax Expense | -685,123,123.00 | -782,255,919.00 | -761,939,323.00 | -631,975,867.00 |
Net Profit after Tax Before Abnormals | 3,063,529,068.00 | 3,284,517,158.00 | 3,455,508,782.00 | 3,384,615,384.00 |
Abnormals | 0.00 | -125,432,295.00 | -182,609,957.00 | 0.00 |
Abnormals Tax | 0.00 | 0.00 | 0.00 | 0.00 |
Net Abnormals | 0.00 | -125,432,295.00 | -182,609,957.00 | 0.00 |
Reported NPAT After Abnormals | 3,063,529,068.00 | 3,159,084,862.00 | 3,272,898,824.00 | 3,384,615,384.00 |
Outside Equity Interests | 0.00 | 0.00 | 0.00 | -75,414,781.00 |
Shares Outstanding at Period End | 454,048,707.00 | 455,125,994.00 | 481,706,266.00 | 482,369,261.00 |
Weighted Average Number of Shares | 453,808,099.00 | 454,865,604.00 | 468,754,857.00 | 482,173,148.00 |
EPS Adjusted (cents/share) | 672.45 | 720.52 | 735.64 | 683.26 |
EPS After Abnormals (cents/share) | 672.45 | 693.00 | 696.76 | 683.26 |
Item | 06/20 | 06/21 | 06/22 | 06/23 |
CA - Cash | 1,740,346,787.00 | 2,405,959,031.00 | 15,149,368,558.00 | 2,334,841,628.00 |
CA - Receivables | 2,270,435,669.00 | 2,079,941,473.00 | 2,152,997,532.00 | 2,873,303,167.00 |
CA - Prepaid Expenses | 212,297,828.00 | 196,195,796.00 | 252,576,571.00 | 452,488,687.00 |
CA - Inventories | 5,113,652,921.00 | 5,028,731,045.00 | 6,289,737,262.00 | 8,244,343,891.00 |
CA - Investments | 0.00 | 0.00 | 0.00 | 0.00 |
CA - NCA Held Sale | 0.00 | 0.00 | 0.00 | 0.00 |
CA - Other | 55,952,207.00 | 118,515,562.00 | 49,499,201.00 | 60,331,825.00 |
Total Current Assets | 9,392,685,414.00 | 9,829,342,910.00 | 23,894,179,126.00 | 13,965,309,200.00 |
NCA - Receivables | 20,836,368.00 | 8,778,930.00 | 18,580,345.00 | 144,796,380.00 |
NCA - Inventories | 0.00 | 0.00 | 0.00 | 0.00 |
NCA - Investments | 20,690,660.00 | 28,598,031.00 | 584,845,405.00 | 260,935,143.00 |
NCA - PP&E | 9,187,527,320.00 | 10,023,942,537.00 | 12,060,676,440.00 | 14,105,580,693.00 |
NCA - Intangibles(ExGW) | 1,436,689,494.00 | 1,970,736,898.00 | 2,105,966,032.00 | 12,619,909,502.00 |
NCA - Goodwill | 1,681,771,819.00 | 1,580,340,516.00 | 1,723,472,202.00 | 12,185,520,361.00 |
NCA - Future Tax Benefit | 791,199,184.00 | 704,309,656.00 | 751,197,561.00 | 1,360,482,654.00 |
NCA - Other | 1,894,215.00 | 5,187,549.00 | 7,838,583.00 | 9,049,773.00 |
Total NCA | 13,140,609,063.00 | 14,321,894,120.00 | 17,252,576,571.00 | 40,686,274,509.00 |
Total Assets | 22,533,294,477.00 | 24,151,237,031.00 | 41,146,755,697.00 | 54,651,583,710.00 |
CL - Account Payable | 2,222,643,158.00 | 2,713,088,587.00 | 3,340,397,735.00 | 4,444,947,209.00 |
CL - Short-Term Debt | 294,769,051.00 | 630,220,803.00 | 6,523,443,170.00 | 1,591,251,885.00 |
CL - Provisions | 598,280,635.00 | 718,808,193.00 | 454,347,510.00 | 914,027,149.00 |
CL - NCL Held Sale | 0.00 | 0.00 | 0.00 | 0.00 |
CL - Other | 4,662,683.00 | 66,108,007.00 | 0.00 | 0.00 |
Total Curr. Liabilities | 3,120,355,529.00 | 4,128,225,591.00 | 10,318,188,416.00 | 6,950,226,244.00 |
NCL - Account Payable | 326,096,459.00 | 596,036,179.00 | 0.00 | 0.00 |
NCL - Long-Term Debt | 8,437,272,329.00 | 7,093,774,940.00 | 7,495,717,811.00 | 16,850,678,733.00 |
NCL - Provisions | 1,079,994,171.00 | 1,135,408,353.00 | 1,394,687,182.00 | 3,220,211,161.00 |
NCL - Other | 58,574,967.00 | 49,481,245.00 | 777,616,490.00 | 743,589,743.00 |
Total NCL | 9,901,937,928.00 | 8,874,700,718.00 | 9,668,021,483.00 | 20,814,479,638.00 |
Total Liabilities | 13,022,293,457.00 | 13,002,926,310.00 | 19,986,209,899.00 | 27,764,705,882.00 |
Share Capital | -6,645,781,728.00 | -5,991,753,125.00 | 702,278,995.00 | 779,788,838.00 |
Reserves | 490,018,942.00 | 842,245,277.00 | 856,873,276.00 | 977,375,565.00 |
Retained Earnings | 15,666,763,805.00 | 16,297,818,568.00 | 19,601,393,525.00 | 22,052,790,346.00 |
Other Equity | 0.00 | 0.00 | 0.00 | 0.00 |
Convertible Equity | 0.00 | 0.00 | 0.00 | 0.00 |
SE Held Sale | 0.00 | 0.00 | 0.00 | 0.00 |
Outside Equity | -- | -- | -- | 3,076,923,076.00 |
Total Equity | 9,511,001,019.00 | 11,148,310,720.00 | 21,160,545,797.00 | 26,886,877,828.00 |
Item | 06/20 | 06/21 | 06/22 | 06/23 |
Receipts from Customers | 0.00 | 0.00 | 0.00 | 0.00 |
Payments to Suppliers and Employees | 0.00 | 0.00 | 0.00 | 0.00 |
Dividends Received | 0.00 | 0.00 | 0.00 | 0.00 |
Interest Received | 0.00 | 0.00 | 0.00 | 0.00 |
Interest Paid | -207,489,436.00 | -214,019,686.00 | -250,108,869.00 | -564,102,564.00 |
Tax Paid | -517,266,501.00 | -657,754,722.00 | -663,521,556.00 | -849,170,437.00 |
Other Operating Cashflows | 4,350,429,841.00 | 5,689,412,077.00 | 4,729,423,718.00 | 5,336,349,924.00 |
Net Operating Cashflows | 3,625,673,903.00 | 4,817,637,669.00 | 3,815,793,293.00 | 3,923,076,923.00 |
Payment for Purchase of PPE | -1,992,714,556.00 | -2,217,478,052.00 | -1,811,148,207.00 | -2,552,036,199.00 |
Proceeds From Sale of PPE | 0.00 | 0.00 | 0.00 | 167,420,814.00 |
Investments Purchased | 0.00 | 0.00 | -562,781,245.00 | 0.00 |
Proceeds From Sale of Investments | 27,247,559.00 | -8,113,860.00 | 0.00 | 410,256,410.00 |
Payments for Purchase of Subsidiaries | -25,936,179.00 | 0.00 | 0.00 | -15,888,386,123.00 |
Proceeds from Sale of Subsidiaries | 0.00 | 0.00 | 0.00 | 0.00 |
Loans Granted | 0.00 | 0.00 | 0.00 | 0.00 |
Loans Repaid | 0.00 | 0.00 | 0.00 | 0.00 |
Other Investing Cashflows | 0.00 | 0.00 | -1,016,112.00 | 0.00 |
Net Investing Cashflows | -1,991,403,176.00 | -2,225,591,912.00 | -2,374,945,565.00 | -17,862,745,098.00 |
Proceeds from Issues | 61,197,726.00 | 75,019,952.00 | 7,241,109,014.00 | 51,282,051.00 |
Proceeds from Borrowings | 2,408,130,555.00 | 51,476,456.00 | 5,940,920,307.00 | 3,829,562,594.00 |
Repayment of Borrowings | -2,038,758,560.00 | -626,363,394.00 | -459,282,914.00 | -1,203,619,909.00 |
Dividends Paid | -1,286,755,063.00 | -1,274,275,073.00 | -1,507,766,003.00 | -1,868,778,280.00 |
Other Financing Cashflows | -80,285,589.00 | -90,449,587.00 | -72,724,633.00 | -120,663,650.00 |
Net Financing Cashflows | -936,470,931.00 | -1,864,591,646.00 | 11,142,255,770.00 | 687,782,805.00 |
Net Increase in Cash | 697,799,796.00 | 727,454,110.00 | 12,583,103,498.00 | -13,251,885,369.00 |
Cash at Beginning of Period | 958,472,971.00 | 1,531,391,327.00 | 2,511,394,977.00 | 15,586,726,998.00 |
Exchange Rate Adj | 21,273,495.00 | 42,431,497.00 | -93,192,045.00 | -58,823,529.00 |
Other Cash Adjustments | 0.00 | 0.00 | 0.00 | 0.00 |
Cash at End of Period | 1,677,546,262.00 | 2,301,276,935.00 | 15,001,306,430.00 | 2,276,018,099.00 |
Item | 06/20 | 06/21 | 06/22 | 06/23 |
Shares Outstand. (EOP) | 454,048,707.00 | 455,125,994.00 | 481,706,266.00 | 482,369,261.00 |
Weighted Avg. Shares | 453,808,099.00 | 454,865,604.00 | 468,754,857.00 | 482,173,148.00 |
EPS Bef. Abs | 675.07 | 694.51 | 698.21 | 686.31 |
EPS Aft. Abs. | 672.45 | 693.00 | 696.76 | 683.26 |
Dilution Factor | -- | -- | -- | -- |
Cumulative | 1.00 | 1.00 | 1.00 | 1.00 |
Reportd EPS Bef. Abs.Adj | 672.45 | 720.52 | 735.64 | 683.26 |
DPS - Adj Ex. Special | 294.08 | 293.87 | 318.12 | 356.72 |
DPS - Adj. | 294.08 | 293.87 | 318.12 | 356.72 |
Interim Div - Ordinary | 147.13 | 134.91 | 142.29 | 162.15 |
Interim Franking - Ord (%) | 0.00 | 0.00 | 0.00 | 0.00 |
Gross Interim Div - Ord | 147.13 | 134.91 | 142.29 | 162.15 |
Final Dividend - Ordinary | 146.96 | 158.97 | 175.83 | 194.57 |
Final Franking - Ordinary (%) | 0.00 | 10.00 | 10.00 | 10.00 |
Gross Final Div - Ord | 146.96 | 165.78 | 183.37 | 202.91 |
Special Dividend - Ord | 0.00 | 0.00 | 0.00 | 0.00 |
Special Franking - Ord (%) | -- | -- | -- | -- |
Gross Special Div - Ord | 0.00 | 0.00 | 0.00 | 0.00 |
Total Div - Ex. Special | 294.08 | 293.87 | 318.12 | 356.72 |
Total Div - Inc. Special | 294.08 | 293.87 | 318.12 | 356.72 |
Total Franking - Ex. Spec | 0.00 | 5.41 | 5.53 | 5.45 |
Total Franking - Inc. Spec (%) | 0.00 | 5.41 | 5.53 | 5.45 |
Total Gross Div- Ex.Spec | 294.08 | 300.69 | 325.66 | 365.05 |
Total Gross Div- Inc.Spec | 294.08 | 300.69 | 325.66 | 365.05 |
Tax Rate (%) | 18.28 | 19.24 | 18.07 | 15.73 |
Corporate Tax Rate (%) | 30.00 | 30.00 | 30.00 | 30.00 |
Payout Ratio Ex. Special (%) | 43.73 | 40.79 | 43.24 | 52.21 |
Payout Ratio (%) | 43.73 | 40.79 | 43.24 | 52.21 |
Dividend Yield (%) | 1.02 | 1.03 | 1.18 | 1.29 |
Dividend Yield Ex. Spec (%) | 1.02 | 1.03 | 1.18 | 1.29 |
Dividend Cover (%) | 228.66 | 245.18 | 231.25 | 191.54 |
Gross Div. Yield (%) | 1.02 | 1.05 | 1.21 | 1.32 |
Gross Div. Yield Ex. Spec (%) | 1.02 | 1.05 | 1.21 | 1.32 |
Item | 06/20 | 06/21 | 06/22 | 06/23 |
Operating Rev. 1 Year (%) | 9.28 | 2.97 | 11.55 | 30.45 |
Operating Rev. 3 Year (%) | 15.52 | 9.97 | 7.87 | 14.43 |
Operating Rev. 5 Year (%) | 13.28 | 11.40 | 12.11 | 14.12 |
Operating Exp. 1 Year (%) | 8.60 | 0.03 | 15.35 | 40.36 |
Operating Exp. 3 Year (%) | 10.53 | 7.56 | 7.81 | 17.43 |
Operating Exp. 5 Year (%) | 12.74 | 7.04 | 9.27 | 15.04 |
EBITDA 1 Year (%) | 11.30 | 8.27 | 5.87 | 12.30 |
EBITDA 3 Year (%) | 22.12 | 10.52 | 8.46 | 8.78 |
EBITDA 5 Year (%) | 12.85 | 17.25 | 15.86 | 9.92 |
EBIT 1 Year (%) | 10.86 | 8.35 | 3.77 | 4.01 |
EBIT 3 Year (%) | 19.84 | 9.53 | 7.62 | 5.36 |
EBIT 5 Year (%) | 11.86 | 17.25 | 14.12 | 7.24 |
EBT After Abs. 1 Year (%) | 12.29 | 5.14 | 2.37 | -0.45 |
EBT After Abs. 3 Year (%) | 19.50 | 8.49 | 6.52 | 2.33 |
EBT After Abs. 5 Year (%) | 10.93 | 13.47 | 12.93 | 5.41 |
EAT 1 Year (%) | 11.97 | 3.12 | 3.60 | 1.11 |
EAT 3 Year (%) | 20.78 | 10.53 | 6.16 | 2.60 |
EAT 5 Year (%) | 11.28 | 13.56 | 13.49 | 7.18 |
EPS Adj 1 Year (%) | 11.59 | 7.15 | 2.10 | -7.12 |
EPS Adj 3 Year (%) | 20.84 | 11.14 | 6.88 | 0.53 |
EPS Adj 5 Year (%) | 12.42 | 18.37 | 14.06 | 5.41 |
Total Div. Ex Spec 1 Year (%) | 10.65 | -0.07 | 8.25 | 12.13 |
Total Div. Ex Spec 3 Year (%) | 18.36 | 8.78 | 6.18 | 6.65 |
Total Div. Ex Spec 5 Year (%) | 12.85 | 11.55 | 12.39 | 9.33 |
DPS Adj Ex Spec 1 Year (%) | 10.65 | -0.07 | 8.25 | 12.13 |
DPS Adj Ex Spec 3 Year (%) | 18.36 | 8.78 | 6.18 | 6.65 |
DPS Adj Ex Spec 5 Year (%) | 12.85 | 11.55 | 12.39 | 9.33 |
Total Assets 1 Year (%) | 28.33 | 7.18 | 70.37 | 32.82 |
Total Assets 3 Year (%) | 23.85 | 18.33 | 32.82 | 34.36 |
Total Assets 5 Year (%) | 22.01 | 18.85 | 28.25 | 30.25 |
Net PP&E 1 Year (%) | 43.68 | 9.10 | 20.32 | 16.96 |
Net PP&E 3 Year (%) | 33.92 | 27.78 | 23.55 | 15.36 |
Net PP&E 5 Year (%) | 30.82 | 25.51 | 25.82 | 24.03 |
Total Equity 1 Year (%) | 27.02 | 17.21 | 89.81 | 27.06 |
Total Equity 3 Year (%) | 32.24 | 26.40 | 41.38 | 41.40 |
Total Equity 5 Year (%) | 21.60 | 26.39 | 38.76 | 37.25 |
Retained Profits 1 Year (%) | 14.30 | 4.03 | 20.27 | 12.51 |
Retained Profits 3 Year (%) | 17.63 | 12.37 | 12.66 | 12.07 |
Retained Profits 5 Year (%) | 14.93 | 12.92 | 15.29 | 13.93 |
Net Debt 1 Year (%) | 22.43 | -23.94 | -- | -- |
Net Debt 3 Year (%) | 19.76 | 3.24 | -- | 32.07 |
Net Debt 5 Year (%) | 25.51 | 8.83 | -- | 27.22 |
Invested Capital 1 Year (%) | 27.44 | 0.39 | 19.28 | 72.37 |
Invested Capital 3 Year (%) | 26.66 | 18.84 | 15.13 | 27.32 |
Invested Capital 5 Year (%) | 24.73 | 19.77 | 19.46 | 28.11 |
NOPLAT 1 Year (%) | 8.92 | 7.59 | 5.37 | 15.12 |
NOPLAT 3 Year (%) | 20.32 | 11.78 | 7.28 | 9.28 |
NOPLAT 5 Year (%) | 12.50 | 18.30 | 14.58 | 11.12 |
Free Cashflow 1 Year (%) | 670.96 | 133.49 | -54.49 | -41.88 |
Free Cashflow 3 Year (%) | 37.65 | 36.85 | 101.58 | -14.84 |
Free Cashflow 5 Year (%) | 6.33 | 28.36 | 22.61 | -7.48 |
Related Book For
Intermediate Financial Management
ISBN: 9780357516669
14th Edition
Authors: Eugene F Brigham, Phillip R Daves
Posted Date: