طاقة عربية

      Taqa.ca    

طاقة عربية

TAQA.CA

AVG FIRM VALUE 17151.5 BILLION

PER/SHARE 12.7 EGP

متوسط قيمة طاقة عربية /TAQA.CA

17151.5 BILLION EGP/12.7 EGP/PER SHARE

Current price 14.72 egp

Outstanding share 13502 billion

Market value 16606.9 billion

Total asset  24038 billion

Growth asset in 5 years  24%

Cash asset 5551.484 billion egp /per share 4.1 egp

Short term debt  7703 billion egp

Growth in 5 years short term debt 43%

Long term debt 1025.284 billion (longvdebt +captial lease)

Growth in 5 years long term debt 21%

Total debt =8728

Equity 4792 billion /per share  3.49 egp

Growth in 5 years in equity 24%

Growth in 10 years in equity 11%

Levarge total asset /equity 24038/4792

Captial investment 8573+4792 13520 billion

Captial employed  avg equity in last2 years

4466+1025=5491 billion

Beta fundemental / asset pricing model method

.47

Leverage bea =1+ (1_.775)×d/equity=1.18

Unleverage beta.79

Cost of equityleverage=22.53

Cost of equity unleverage=19.21

Cost of captial leverage beta =.7×22.53+.3×.775×.205

.2051%

Ebit /interest rate 1964/1821 more 1 coverage  weakeness   c degree

Coverage ratio /1964/net interest rate 1964/123 16 time

Intrest rate 20.5%

Ebitda 2400

Total debt /ebitda 8728/2400=3.63 good rate is no more 1.2

Net debt 3173/2400 1 32  good rate

Growth in last 5 yrs 25%

Revenue 25593 billion

Avg 3 yrs in revenue 19320 billion

Growth 5 yrs in revenue 26%

Margin  gross profit avg 3 yrs 2557/19320 =13.2%

Pe /gross profit  6.5 x 2557/16606/15.4%

Pe/ev = 8.25x

Reivestment rate  capx_deprication +chnge in working cap

/ebit (1_t)

828.7/avg 3 yrs ebit (1_t)829.7/1225=.767

Return on investment 22%

Fundmental growth 15%

Ebit 1964 billion

Avg ebit4 yrs 1433 billion

Growth 5 yrs in ebit 19.5%

Growth 10 yrs in EBIT 22.9%

Margin profit in recent year .7%

Margin profit avg 3 yrs .8%

Ebit /market value   11.8%

Pe/ebit fundemental =(1_reinvestment rate )×1.229×(1_t)

/cost of caprial _growth

=12.8

Pe/ebit firm value =12.8×1580=20253 billion /per share /15 egp

Eps in recent year 1053 billion /per share .78

1053/market value =6% <10% risk sign

Avg 3yrs in eps  770 million /per share/.57

Growth in last 3 yrs 37%

Growth in 5 years /17%

Growth in 10 yrs16%

Net profit margin in recent yrs 4%

Avg net profit margin 4%

Pe /current market  18.61 /growth 17%grc in 5 yrs

Peg1.1 >1

Captialzatio ben graham /2×1.16+8.5 ×bond /treasury bond

Pe 10.82 × recent year 1053 11400 billion /per share 8.5 egp for recent yeae /avg3 years 8370 billion /per share 6.2 egp

Cash flow 1053+434depreca=1487

Pe/cash flow /11×

Free cash flow in recent year  1717 /per share 1.27

23.08 /per share

Pe/Free cash flow in lastc2 yrs cycle  929 million/16889 billion /12.5 per share egp

Pe/free cash flow avg 4yrs 543 /9871.74 billion /7.3 per share

Increase in price =avgv2yrs free cash flow 929 ×118/.025

19016 billion/per

Firm value 19016debtv8725+cashv5555/15846 billion/per share 11.72 egp

Pe/free cash flow avg 4 yrs 23.25×543/ 12627 billion/per share 9.34

Pe/free cash flow avg 2 yrs 929 growth 17.52

Pe 17.52 ×929=16300 billion 12.05 egp per share

Net profit margin .725

Price /net profit ×revenue/book value ×bookvalue

.725 ×25593/4792×4792 =18554 billion /per share13.72 egp

Apv 14054.7_2430.3=11624.4 billion +13119_3170=21573/per share 16 egp

Earning power value  avg 4 yrs ebit +debraction ×(1_t)/cost of captial + working captial +fixed asset +intangible asset _long term debt

19954 billion  +  captial _invested  _debt 16784 billion/12.41 per share

Avg firm value =17151.5 billion /12.7 egp per share