Archive Pharmacy Listing Magazines John Mitchel Pharmacy, Cobar | Page 26

JOHN MITCHELL PHARMACY, COBAR NSW 190407 DETAILED Weighting 2017 Financial Years Ended 30 June Weighting 1 2017 2018 Weighting 2 Ann 2019 01/07/2018 - 31/12/2018 2018 3 Straight-Line Annualised 2019 Three Year Weighted Average 1 Assessed Fut. Maint. EBITDA Notes Other Expenses 3,200 28,149 8,206 20,357 4,662 14,562 2,045 49,594 876 1,006 48,279 1,189 5,250 121,261 - 12,139 425 - 2,853 1,450 5,606 5,428 5,713 2,137 12,874 357,261 844,738 54,489 YES 54,489 Accounting Fees Advertising and Promotion Bank Charges Bookkeeping Expenses Cleaning and Laundry Computer Expenses Consulting Fees Depreciation and Amortisation Donations Fees, Permits and Licenses Franchise Fees Hire of Plant and Equipment Insurance Interest Paid and Borrowing Costs Legal Fees Postage, Printing and Stationery Security Staff Recruitment Staff Training and Welfare Storage Costs Subscriptions and Memberships Telephone and Internet Travel, Conferences and Entertainment Uniforms Wrapping and Packaging Other Expenses Total Expenses Net Profit Checked to client profit 0.1% 1.2% 0.4% 0.9% 0.2% 0.6% 0.1% 2.2% 0.0% 0.0% 2.1% 0.1% 0.2% 5.3% 0.0% 0.5% 0.0% 0.0% 0.1% 0.1% 0.2% 0.2% 0.2% 0.1% 0.6% 15.5% 36.7% 2.4% 3,200 7,073 7,361 20,384 1,988 13,323 - 43,853 576 2,839 48,015 1,170 6,134 116,304 124 15,297 574 235 3,986 323 4,333 5,124 - 120 14,061 316,396 796,627 22,309 YES 22,309 0.1% 0.3% 0.3% 0.9% 0.1% 0.6% 0.0% 1.9% 0.0% 0.1% 2.1% 0.1% 0.3% 5.0% 0.0% 0.7% 0.0% 0.0% 0.2% 0.0% 0.2% 0.2% 0.0% 0.0% 0.6% 13.6% 34.2% 1.0% 1,691 2,761 2,972 7,327 1,089 5,897 - - 1,096 2,216 23,970 585 (1,908) 56,819 - 1,051 503 235 1,454 - 1,420 2,743 756 214 7,691 120,581 362,072 114,593 YES 114,593 3,354 5,477 5,896 14,534 2,160 11,697 - - 2,175 4,396 47,549 1,160 (3,784) 112,711 - 2,085 997 466 2,884 - 2,817 5,442 1,500 425 15,256 239,196 718,240 227,318 0.1% 0.2% 0.3% 0.6% 0.1% 0.5% 0.0% 0.0% 0.1% 0.2% 2.1% 0.1% -0.2% 4.9% 0.0% 0.1% 0.0% 0.0% 0.1% 0.0% 0.1% 0.2% 0.1% 0.0% 0.7% 10.4% 31.2% 9.9% 3,277 9,787 6,770 17,454 2,520 12,717 341 22,883 1,425 3,312 47,826 1,168 1,027 115,334 41 8,164 761 311 3,246 349 3,787 5,334 1,702 608 14,461 284,607 765,452 130,177 0.1% 0.4% 0.3% 0.8% 0.1% 0.6% 0.0% 1.0% 0.1% 0.1% 2.1% 0.1% 0.0% 5.0% 0.0% 0.4% 0.0% 0.0% 0.1% 0.0% 0.2% 0.2% 0.1% 0.0% 0.6% 12.3% 33.1% 5.6% 14.8% 115,334 22,883 - 138,217 268,394 11.6% 10,000 9,787 5,896 - 2,160 12,717 - - - 4,396 7,140 1,160 7,000 - - 8,164 997 - 2,884 - 3,787 5,442 - 608 15,256 97,395 493,980 0.4% 0.4% 0.3% 0.0% 0.1% 0.6% 0.0% 0.0% 0.0% 0.2% 0.3% 0.1% 0.3% 0.0% 0.0% 0.4% 0.0% 0.0% 0.1% 0.0% 0.2% 0.2% 0.0% 0.0% 0.7% 4.2% 21.4% 401,196 17.4% Adjusted to Norm for a Pharmacy of this Size Three Year Weighted Average Annualised 2019 Included in Accounting Fees Annualised 2019 Three Year Weighted Average Non Operational EBITDA Exclusion Non Operational Annualised 2019 Adjusted to Norm for a Pharmacy of this Size Annualised 2019 Adjusted to Norm for a Pharmacy of this Size EBITDA Exclusion Non Operational Three Year Weighted Average Annualised 2019 Non Operational Annualised 2019 Non Operational Three Year Weighted Average Annualised 2019 Non Operational Three Year Weighted Average Annualised 2019 EBITDA Add Back / (Deduct) 121,261 49,594 - 170,854 225,343 Interest Paid and Borrowing Costs Depreciation and Amortisation Payroll Tax Total EBITDA adjustments EBITDA Other adjustments Wages Adjusted to Norm Accounting and Bookkeeping Adjusted to Norm Franchise Fee Adjusted to Norm Insurance Adjusted to Norm Other Income Consulting Fees Donations Legal Fees Staff Recruitment Storage Costs Travel, Conferences and Entertainment Total Other Adjustments Adjusted EBITDA Difference between Assessed EBITDA 105,234 13,557 41,139 (1,750) (2,169) 2,045 876 - - 1,450 5,713 166,095 391,439 9,758 9.8% 17.0% 116,304 43,853 - 160,156 182,465 87,427 13,584 40,875 (866) - - 576 124 235 323 - 142,277 324,743 76,454 7.8% 13.9% 112,711 - - 112,711 340,030 83,019 7,888 40,409 (10,784) - - 2,175 - 466 - 1,500 124,672 464,702 (63,505) 20.2% 88,191 10,731 40,686 (5,973) (361) 341 1,425 41 311 349 1,702 137,445 405,838 (4,642) 17.6% Notes 1. Weighting 1 2017 2 2018 3 Ann 2019 2. We note that we have valued the pharmacy as an ungeared, unencumbered stand alone business and have not taken any corporate structure issues into account, including taxation liabilities and inter-business transfers/consolidations. Page 13 of 56 (c) Armstrong Business Valuations Pty Ltd