Archive Pharmacy Listing Magazines John Mitchel Pharmacy, Cobar | Page 25
ARMSTRONG BUSINESS VALUATIONS PTY LTD
Financial Analysis - Future Maintainable EBITDA
JOHN MITCHELL PHARMACY, COBAR NSW
190407
DETAILED
Weighting
2017
Financial Years Ended 30 June
Script Numbers
2018
2017
PBS Sales - Other
2,299,333
Weighting
2
Ann 2019
01/07/2018 -
31/12/2018
2018
n/a
Retail Sales
Total Sales
Weighting
1
0.0%
0.0%
100.0%
Increase in Total Sales
Increase in Retail Sales
Increase in PBS Sales
Increase in PBS Script Numbers
PBS Sales $ per Script
42,318
636,524
1,691,523
2,328,046
101.2%
n/a
27.3%
72.7%
100.0%
1,159,392
$39.97
3
Straight-Line Annualised
2019
44,780
631,228
1,668,654
2,299,882
98.8%
99.2%
98.6%
105.8%
$37.26
Three Year Weighted
Average 1
Assessed Fut. Maint.
EBITDA
Notes
Script reports 1 Jul 2018 to 30 Nov 2018
27.4%
72.6%
100.0% 2,309,178 100.0% 2,309,178 100.0% Three Year Weighted Average
8.9%
61.6%
-9.0%
61.6%
38.4% 1,475,447
833,731 63.9%
36.1% 1,475,447
833,731 63.9%
36.1% Three Year Weighted Average
Cost of Goods Sold
Opening Stock
Purchases
Closing Stock
Total Cost of Goods Sold
Gross Profit
Stock Turn
Other Income
Interest Received
PBS and Government Incentives
Commissions and Other Incentives
Insurance Recovery
Other Income
Total Other Income
Gross Profit and Other Income
268,522
1,443,267
(246,711)
1,465,078
834,255
11.7%
62.8%
-10.7%
63.7%
36.3%
5.9
246,711
1,528,658
(205,218)
1,570,151
757,896
10.6%
65.7%
-8.8%
67.4%
32.6%
205,218
715,663
(207,179)
713,703
445,690
205,218
1,417,729
(207,179)
1,415,769
884,113
7.7
See Page 5
6.8
-
56,899
4,370
1,534
2,169
64,972
899,227 0.0%
2.5%
0.2%
0.1%
0.1%
2.8%
39.1% -
55,017
6,024
-
-
61,041
818,937 0.0%
2.4%
0.3%
0.0%
0.0%
2.6%
35.2% -
27,159
3,816
-
-
30,975
476,665 -
53,875
7,571
-
-
61,445
945,558 0.0%
2.3%
0.3%
0.0%
0.0%
2.7%
41.1% -
54,759
6,522
256
361
61,898
895,629 0.0%
2.4%
0.3%
0.0%
0.0%
2.7%
38.8% -
53,875
7,571
-
-
61,445
895,176 0.0%
2.3%
0.3%
0.0%
0.0%
2.7%
38.8% EBITDA Exclusion
Annualised 2019
Annualised 2019
Non Operational
Non Operational
353,461
31,628
25,752
-
-
7,831
418,671 15.4%
1.4%
1.1%
0.0%
0.0%
0.3%
18.2% 241,901
26,170
132,098
-
-
4,610
404,779 10.4%
1.1%
5.7%
0.0%
0.0%
0.2%
17.4% 115,247
9,878
74,771
-
-
-
199,895 228,615
19,594
148,322
-
-
-
396,531 9.9%
0.9%
6.4%
0.0%
0.0%
0.0%
17.2% 253,852
23,792
122,486
-
-
2,842
402,971 11.0%
1.0%
5.3%
0.0%
0.0%
0.1%
17.5% 299,780
-
-
15,000
-
-
314,780 13.0%
0.0%
0.0%
0.6%
0.0%
0.0%
13.6% Fair Wage Assessment. See Page 5
Included Above
Included Above
Remote Living Allowance
Below Payroll Tax Threshold
Included Above
36,404
2,941
3,350
26,111
68,805 1.6%
0.1%
0.1%
1.1%
3.0% 43,381
3,598
2,999
25,474
75,453 1.9%
0.2%
0.1%
1.1%
3.2% 23,840
2,547
2,284
12,924
41,595 47,291
5,053
4,531
25,637
82,512 2.1%
0.2%
0.2%
1.1%
3.6% 44,173
4,216
3,824
25,662
77,875 1.9%
0.2%
0.2%
1.1%
3.4% 47,291
5,053
3,824
25,637
81,805 2.0%
0.2%
0.2%
1.1%
3.5% Annualised 2019
Annualised 2019
Three Year Weighted Average
Annualised 2019
Less Expenses
Wage and Oncost Expenses
Salaries and Wages
Superannuation Contributions
Locum Fees
Remote Living Allowance
Payroll Tax
Workcover
Total Wage and Oncost Expense
Total Rent and Property Expenses
Rent
Rates and Taxes
Repairs and Maintenance
Electricity and Gas
Total Rent and Property Expenses
Page 12 of 56
(c) Armstrong Business Valuations Pty Ltd