Real estate management

profileBrucele
SavillsPlc2017Ratiocalculations1.pdf

P&L 2017 2016 BS 2017 2016

(£ 000s) (£ 000s) (£ 000s) (£ 000s)

Revenue 1,600.00 1,445.90 Trade receivables 391.20 333.20

Gross Profit Inventories 6.00 5.30

Operating Profit 103.80 92.70 Cur Assets 708.20 652.80

Interest 4.10 2.40 Cur Liab 741.90 623.20

Earngs 4 SH 81.10 67.70 NC Liab 87.00 117.20

dividends 39.30 35.40 Equity 441.70 407.00

eps 0.59 0.49 # of employees 34,429 32,361

div per share 0.29 0.26 Total EQ _ NCL 528.70 524.20

Share price 9.93 7.01

Cost of Sales 1,600.00 1,445.90

# of shares 136.20 137.20 Trade Payables 111.60 80.90

Ratios

Figures Answer Figures Answer Δ

ROSF 81.10 18.361% 67.70 16.634% ↑ 441.70 407.00

ROCE 103.80 19.633% 92.70 17.684% ↑

441.7+87 407+117.2

Gross P margin - 0.000% - 0.000% =

1,600.00 1,445.90

Operating margin 103.80 6.488% 92.70 6.411% ↑

1,600.00 1,445.90

Average Inventory 6.00 1.369 days 5.30 1.338 days ↑

turnover period 1,600.00 1,445.90

Settlement days 391.20 89.243 days 333.20 84.112 days ↑ for receivables 1,600.00 1,445.90

Settlement days 111.60 25.459 days 80.90 20.422 days ↑

for payments 1,600.00 1,445.90

Sales to CE 1,600.00 3.026 times 1,445.90 2.758 times ↑ 441.7+87 407+117.2

Sales per Empyee 1,600.00 46,472 £s 1,445.90 44,680 £s ↑ 34,429.00 32,361.00

Current Ratio 708.20 0.955 times 652.80 1.047 times ↓ 741.90 623.20

Quick Ratio 708.2-6 0.946 times 652.8-5.3 1.039 times ↓ 741.90 623.20

Gearing Ratio 87.00 16.455% 117.20 22.358% ↓ 441.7+87 407+117.2

Interest Cover 103.80 25.317 times 92.70 38.625 times ↓ 4.10 2.40

Div payout 39.30 48.459% 35.40 52.29% ↓ 81.10 67.70

Dvd cover 2.063613232 2.064 times 1.912429379 1.912 ↑ (times)

div per share 39.30 0.289 £ 35.40 0.258 ↑

136.20 137.20

Div yield 0.320606951 3.229% 0.286686103 4.093% ↓ 9.93 7.01

EPS 0.588 0.488 ↑

P/E 9.93 16.888 times 7.01 14.355 times ↑

0.588 0.488

Investment

Profitability

Efficiency

Savills plc 2017

2017 2016

Liquidity

Gearing