fix it

profileassi221
book1.xlsx

Sheet1

2018 2017 2016 2015 2014
sales 10698.2 10622 10555.4 10311.5 10309.7
less: cost sales 6650.7 6534.2 6427 6326 6323.5
gross profit 4047.3 4087.8 4128.4 3985.5 3985.5
expenses 3890.7 3834.6 3543.9 3284.2 3291
operating profit 156.5 253.2 584.1 701.3 694.5
loan interest 89.7 76.8 95.3 100.9 114.1
profit before tax 66.8 176.4 488.8 600 580.4
taxation 83 97.1 83.7 117.9 108.3
profitafter tax -16.2 79.3 405.1 482.1 472.1
divideds 303.4 377.5 301.7 280.7 273.6
retained profit 277.5 298.2 103 201.4 198.5
non current assests 6232 6569 7015 6741 6534.5
current asssets 1317.9 1723.3 1461 1455 1368.5
stock 781 758 799.9 797.8 845
debt 329.9 497.3 415 452.2 341.5
cash 207 468 247 205 182
total assest 7549.9 8292 8476 8196 7903
profit and loss account 1405 1553.8 1617 1642.4 1692.8
called up shared capital 406.2 406.2 405 412 408
non current liabilties 2770 2774.1 2928 2885 2847
current liabilities 1826 2368 2104 2111.6 2349
total 14646 17209 15676 14124 14224
liiquidity 2018 2017 2016 2015 2014
current ratio= current assets /current liabilities 0.7217415115 0.7277449324 0.694391635 0.6890509566 0.5825883355
acid test =(curent assets-stock)/ current liabilities 0.2940306681 0.4076435811 0.3142110266 0.3112331881 0.2228607918
profitability
gross margin=gross profit/sales *100 37.8315978389 38.4842779138 255.6777444046 38.651020705 38.6577688973
net operating margin=profit before tax/sales*100 0.6244041054 1.6607041988 4.6308050855 5.8187460602 5.6296497473
return on capital employed=profit after tax/capital empl*100 1.1670160727 2.9776674938 7.6722649506 9.8635541674 10.4520079236
return on share holders funds =frofit after tax/share funds*100 0.6253510579 1.6483978582 4.4596505634 5.5588496887 5.3831456714
efficiency=sales/capital employed 1.0015165699 0.9925896854 0.9630400073 0.9553346428 0.9562132483
stock turnover=cost of good sold/average stocks 8.5156209987 8.6203166227 8.0347543443 7.9293055904 7.4834319527
stock days=avg stock/cost of good sold*365 42.8624054611 42.3418322059 45.4276489809 46.0317736326 48.7744129042
debtorts turnover=debtors/sales*365 11.255491578 17.0885426473 14.3504746386 16.006691558 12.0903130062
creditors turnover=creditors/purchases*365 62.299265297 81.3707399736 72.7551774447 74.745090433 83.1629436356
financial structure gearing=loans and borrowing/cap employed*100 60.464507116 58.5982552122 59.1515151515 58.407903794 57.5407251708
intrest cover=profit before tax/intrest 0.7447045708 2.296875 5.129066107 5.946481665 5.0867659947
divided yield=divided/value of share*100 2549.5798319328 3172.268907563 2535.2941176471 2419.8275862069 855
earnings per share=profit tax/no of ordinally shares -0.0398818316 0.1952240276 1.0002469136 1.1701456311 1.1571078431
price earning ratio=share price/eps