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