المصرية لمدينة الانتاج الاعلامى

Mprc.ca

Current price /38.62 egp

Share outstanding  /189.630 million

Market value 7320 billion egp

Total long assets 2396 billion

Total assets 4997 billion

Growth in 5 yrs assets  12 4%

Growth in 10 yrs assets 6.5%

Book value 4283786billion egp /per share /22.59 egp

Growth in book value 5 yrs 12 91%

Growth in book value 10 yrs 5 9%

Total debt 22.217 million

Total debt /equity 22217/4283 .005%

Cash assets 2047.634 billion /per share /10.8 egp

Captial employed 4273 billion

Captial investing 4305 billion

Working captial 1896.7 billion /per share 10 egp /share

/avg revenue 10/7راس مال عامل  كل جنية ايراد يحتاج.25  1

Cost of equity un leverage firm

Beta .2  bond rate

8 5 +8.5×.2+5×.8=14.2 %

Ebitda  710 .812 million

Ev/price  38.62×189.630+debt _cash /ebitda

7×

profit margin 5 yrs 72%

Growth profi margin 5 yrs 21%

Growth in revenue 5yrs 18%

Growth in revenue 10 yrs 11.7%

Avg 3 yrs revenue 1083 billion egp

Ebit  TTM 692.825 billion /per share 3.64 egp /share

Avg ebit 4 yrs included TTm 570 175 /per share 3 egp

Growth in ebit 5 yrs 21%

Growth in  ebit 10 yrs  28%

Ebit margin  avg 3 yrs 57 6% avg ebitc3 yrs 624 million

Reinvestment rate/ capx _deprecation+change in working captial

130 862 avg change in workibg captial

Avg capxc4vyrs 121 million

Depreciation 77 million

121_77_77+130.863 =174 92 million

Reinvestment rate avg ebit 4 yrs /captialvratio avgc4 yrs 39.5 %

Avg change in revenue /captial ratio  179/174 /1.02%

Pe /ebit  (1_reinvest ment rate )×..775 ×1.g)

Pe fundemental 9 ×

Avg 3 yrs ebit included TTM 624×9=6308 billion egp/per share 33.26 egp

Earning power value  570.175×.775+deprication ×.665/cost of captial

+captial investment _debt

8031.25 billion egp /42.35 egp

Avg eps /earning in 3 yrs  853.346 million egp/4.5 per share

Growth in eps 5 yrs 29.5%

Growth in eps in 10 yrs 29%

Captialization ben graham method =2×1.29+8.5×treasury bond /compony bond

10×avg eps 3yrs included TTm853.34 =8556.78 billion egp /per share 45.12 egp

Captial ratio 174.92+3debt =178 million

Reinvestment rate in equity 178 /avg 3 yrs 853.34

21%

Free cash flow firm  avg ebit (1_t)×.605=267 million /per share 1.4 per share

Free cash flow equity avg 3yrs eps 853.34×.775_178 =483.33 million /per share=2.54 egp

Cash flow based TTm 643.460 million /share =3.39

Pe/cash flow 11.4×

Avg cash flow 4 yrs  included TTM=2102 =11egp /per share /pe/total cash flow 4 yrs /3.5×

Pe/avg cash flow 4 yrs /2.77 per share /pe/cash flow /14×

Free cash flow leverage  =avg cashflow 4 yrs _avg 4 yrs capx

1619 billion /4 =404 million /per share 2.13 egp

Fundemental growth =return on equity ×reinvestment equity.79×.195=15.4%

Increasing in price 7037 billion /per share 37 .11 egp

Value firm =7037+cash _debt+2047.634_9.139

9075.91 billion /per share /47.86 egp

Pe /cash flow leverage 404×16.12=6516 billion /per share=34.36 egp

Net profit margin avg 3 yrs 853.34_av3 yrs revenue

.68 %

12629 billion /per share 66.6 egp

Price /net profit ×avgvrevenue /av book value ×book value

12754 billion /67.25 per share

Pe /book value  retention ×return on equity /cost of equity _growth

.79×.195/.062

2.5 pe × 4283=10641 billlion /per share =56.12 egp

Total earning in 10 yrs including TTM 3760.86 BILLION /FOR ONE YEAR 376 MILLION ONE YEAR /PER SHARE /2 EGP /PE /RATIO TO AVG 10 YEARS 19 3 ×<GROWTH IN 10 YRS 29%<1

PEG =19.3 /.29<1

Divdend yield 6 2%

Pe /ratio 1/.062=16×

Avg earning /current price  4.5/38.6=11 65%/pe/ratio 8.6×

AVG FIRM VALUE = 9496.841 billion /50 egp /per share