medicine in Ontario is highly fragmented and is just beginning to consolidate. Only a few pharmacy chains have focused on this unique product offering, and NatureCARE Pharmacies is a clear market leader with 18 pharmacies in the province. Management's projections assume that NatureCARE Pharmacies is expected to make three investments in fixed assets to expand its operation; this was to occur in 2011. This effort was expected to further solidify the firm's position in Ontario and serve as a springboard for further expansion into neighboring provinces (Manitoba and Quebec). Tables 1 and 2 on the following pages present the income statement and a balance sheet for NatureCARE Pharmacies. The statements present the historical financial numbers (2007 to 2010) and the projected financial forecasts (2011 to 2015). Table 3 provides averages betas for different industries. Table 4 includes selected industry averages. Please assume that the market risk premium is equal to 15% and that the 60-day Treasury bill rate is equal to 5.5%. Table 1 - The balance sheet for NatureCARE Pharmacies, 2010 - 2015 (year end results) Listorical 2010 Forecast 2011 2012 2013 2014 2015 S00) Touch A rwahl inventary Total current assets Fixed assets, ross Luss: Accumuland depreciation Fixed Tal Assis LOIN 1. 1 4 wlis 1711:4.13333 1. 540141107231213 19.20121.56512425.8522932232 al 26,451 0.32339,131132.10.0.97290.641 8,360 36608 lis 261836 is cal 1. 3.283 5.120 60sd .310. 6,919 15.08213.246 11.40 9.573 3.534 33,370 15.609526 3,510 29,5508837 Llabilities and Shareholders' Equity Cuis Accounts payable Tumbil 1 12.130 16. 122253. 8 232232.960 2140116.4741759 3231563 16991 1990 5.90 6.99160911 5201 29111 1 9 Total Share 'Eury Il me shares Il Red ings Tutacholders oquity Tu labi shoboken' paty Seasodis dissolo sod is 12.50 20.125 .933 8. 13. 12.1452692333 324 0.3715.10 2.9 .50 Income Statement Table 2 - The income statement for NatureCARE Pharmacies, 2007-2013 (pear end results) The Case Study (NatureCARE Pharmacies) Let's assume that NatureCARE Pharmacies is an independent network of pharmacies in the province of Ontario, Canada. The business was established as an entrepreneurial venture in 2005 (when the first pharmacy was opened) and by 2010 revenue reached $58.0 million. NatureCARE Pharmacies has a unique focus-it specializes in homeopathic medicine (accounting for about 75 percent of the company's revenue), vitamins (10 percent of revenue), and dietary supplements (15 percent); the remaining 10 percent of revenue comes from a wide range of other products. The firm sources products from leading international suppliers such as Heel (Germany), Boiron (France), Genestra Brands (USA), and Swiss Herbal (Switzerland). The pharmaceutical sector for alternative medicine in Ontario is highly fragmented and is just beginning to consolidate. Only a few pharmacy chains have focused on this unique product offering, and NatureCARE Pharmacies is a clear market leader with 18 pharmacies in the province. Management's projections assume that NatureCARE Pharmacies is expected to make three investments in fixed assets to expand its operation, this was to occur in 2011. This effort was expected to further solidify the firm's position in Ontario and serve as a springboard for further expansion into neighboring provinces (Manitoba and Quebec). Tables 1 and 2 on the following pages present the income statement and a balance sheet for NatureCARE Pharmacies. The statements present the historical financial numbers (2007 to 2010) and the projected financial forecasts (2011 to 2015). Table 3 provides averages betas for different industries. Table 4 includes selected industry averages. Please assume that the market risk premium is equal to 15% and that the 60-day Treasury bill rate is equal to 5.5%. Table 1 - The balance sheet for NatureCARE Pharmacies, 2010 - 2015 (year end results) Hisi 2012 Ils ) 2011 2012 2013 2014 2015 I Accounts receivable Ilimentary cursets I . weddin Hid e real 1 9:15,124.13339 5,538 6 .5911,08 2,51 13.919 19.292.652.2025.29,320 32.863 26.45120,523 3.15132.100 IR IRWIN 1 16 1245 120x 10670 4,1415.213,34611,409 9.573 73 13,57045.692,907 7 95 ,175 Liabilities and Shareholders' Equity Current while II A b le Intal current hilities Long tem deb Total liabilities 2 12,150 16,47422.25725,85519 327283 1 47422.252 25. 29.32232 wal 16,991|11.991 1991 6,991 6991 6,991 29,1246429.24122.87131839.853 Shareholder uity mer II Re m ings 10 Sonic 500 10.900 1764717004 Hal Assets | 33,570445.60952,1973,51 tissues Llubilities and share bukura qully Irunt hilities: I N o vale Tal current abilities Lynn du Tun Mabibodies 12. 19442225325.884232232 val 12. 11.1942 .sh. 3221122 16,991 1.991 6.991 6,091 6991 6.991 9121124.46429,249 2,8451431839853 hercher Family Ik h Related carines Total stareholders equity Total liabilities and shareholders' equity o usunto sul 12.40 3 .034 4.250 17.14625, 1971,67090.233 .534 33,37145.612. 3.511.30 Income Statement Table 2 - The income statement for NatureCARE Pharmacies, 2007-2015 (year end results) 0001 Historic 2003 2004 2009 2010 2011 Projected 2012 2013 2014 2015 Rey 13.4892.2023,734 5799484,1u55721134,783152,2069,348 11871.918,726 45.759664 0.714104, 118.91433,275 61X1.314 5.28 12237|18.042 2544 29,917 33,951 16.1171 Kloom and minine 261 3 1.7 4. .0 T 941812 11.84 145 157 478 1062947316037744416 4572 56 167 171 1581 222 2,434 2.813 .1199 I , prin Treningsbelevin s and amortization (CBITDAI 155 619 2.526.612,816 12.16 14.22 15,914 17.05 Depreciate Operating profilERIT) IN UN Farming I T axa 161 Net (less) 180 180 250 837 1832 1833 1.833 1,4 1,837 -25 419 233 5.781 111 124 14.07415217 90 1 941 1426040400 600 600 -15 200 2.15 4842 1941 11 10 14 SIX 9 729 1.745 1. 4 19 4211141143.220 -11 11 .5 1 2 5.60471 890 291 ) Table 3 - Average betas for specific industries for the period between 2000 and 2010 22 2001 2002 2003 2004 2005 2006 2007 2012 2010 Avere standard A 6.99 0,211 laron 11 as I. 9 9 10x 12 x 1.5 1.-2.53 Baking mains 1. 0. 0.0 l 1.34 0004 I S O sol 170 17 0.5 0.5 0.3 0.6 0.81 0.64 090.62 Mexicali Land 1 . .. .. .. . is '000) Til Hiccio 2007 2008 2009 2010 2011 2012 2013 2014 2015 Revue Cost of ads sold Cross profit 1.487.21623.734 7.99484,991119,472 134,73 152,2 169.34 2.4715. 11,72845.757 .0 40.204114, 118,98 133,275 181,04 3,008 12.237 18.0 25.000 29,923 33,35. 36,071 Selling cos! Kiesteral and administrative expers 262 36111,780 1451 IN 47 50 1021121 9860271 7879 2 402110 222 9.43 4 2.420 10,200 4 ,4 2,8 11,346 4,57 3,099 Fornings for res, de damuntinlun (FRITDA dades als 14 15 91412055 D I 1. 14 XL 15 Cipro ERT Intere expense Earnings becoce axes (EBT Taxese Vui vui (en) N 1421 1. 2 2 10 12 90 4 01 -115295 2.1584845249381 11,2 1 o 22 LOA |-11: Moi 1,5- 2014 2.4 6.4 7.5 14LSIS 5.225 8904 9.2 | Table 3 - Average betas for specific industries for the period between 2000 and 2010 2002 2003 2004 2005 2006 2007 2008 2009 2010 Avon devi Apparel Aulumul Baikling materials 0. 80.90 07 . 11.99 0. 1.14 1.300 100 0 1. 01 .23 2 .51 1.2 1.53 Soos 0 54.96 098 109 110 145132 1.0 104 1.14 1.19 1.20 1.59 1.9 1.7 1.7 1.1 1.11 0.od .11 .09 1.0 1.09 10 .30 0.0 0 Ilectric services In emas 1.10 1.0 1.10 1.64 0.4 0.8 1.01 10 1.2 1.2 .10 2750 14.1 21 2631 278 2 79 1411 104 110 Medical services 11. 044 x 11.94 1. Oxx 022 Precis metals 095 14 11 18 Railroad 0.81 ose 0.0 0. 0 103 4041 66 1.7 od 0. 6 s 1.00 osales 19 123 124 1220 LOI 135 134 9 4 Telecamere 11 This 0. as a dos Od samog 02 Table 4 - Selected industry averages in the pharmacy services industry FRUIT Net profit margin 7.2 percent h uity ratio 5 percent TIL 4.5 ROE 10. perveni Quin 1.2 Perform a financial analysis of the NatureCARE Pharmacies in view of the information found in the case. Your analysis should relate to historical data and forecast data. Note that in terms of historical data, only the 2010 balance sheet is available. Historical income statements are available for other years. Use tables 1 4 for your analysis. medicine in Ontario is highly fragmented and is just beginning to consolidate. Only a few pharmacy chains have focused on this unique product offering, and NatureCARE Pharmacies is a clear market leader with 18 pharmacies in the province. Management's projections assume that NatureCARE Pharmacies is expected to make three investments in fixed assets to expand its operation; this was to occur in 2011. This effort was expected to further solidify the firm's position in Ontario and serve as a springboard for further expansion into neighboring provinces (Manitoba and Quebec). Tables 1 and 2 on the following pages present the income statement and a balance sheet for NatureCARE Pharmacies. The statements present the historical financial numbers (2007 to 2010) and the projected financial forecasts (2011 to 2015). Table 3 provides averages betas for different industries. Table 4 includes selected industry averages. Please assume that the market risk premium is equal to 15% and that the 60-day Treasury bill rate is equal to 5.5%. Table 1 - The balance sheet for NatureCARE Pharmacies, 2010 - 2015 (year end results) Listorical 2010 Forecast 2011 2012 2013 2014 2015 S00) Touch A rwahl inventary Total current assets Fixed assets, ross Luss: Accumuland depreciation Fixed Tal Assis LOIN 1. 1 4 wlis 1711:4.13333 1. 540141107231213 19.20121.56512425.8522932232 al 26,451 0.32339,131132.10.0.97290.641 8,360 36608 lis 261836 is cal 1. 3.283 5.120 60sd .310. 6,919 15.08213.246 11.40 9.573 3.534 33,370 15.609526 3,510 29,5508837 Llabilities and Shareholders' Equity Cuis Accounts payable Tumbil 1 12.130 16. 122253. 8 232232.960 2140116.4741759 3231563 16991 1990 5.90 6.99160911 5201 29111 1 9 Total Share 'Eury Il me shares Il Red ings Tutacholders oquity Tu labi shoboken' paty Seasodis dissolo sod is 12.50 20.125 .933 8. 13. 12.1452692333 324 0.3715.10 2.9 .50 Income Statement Table 2 - The income statement for NatureCARE Pharmacies, 2007-2013 (pear end results) The Case Study (NatureCARE Pharmacies) Let's assume that NatureCARE Pharmacies is an independent network of pharmacies in the province of Ontario, Canada. The business was established as an entrepreneurial venture in 2005 (when the first pharmacy was opened) and by 2010 revenue reached $58.0 million. NatureCARE Pharmacies has a unique focus-it specializes in homeopathic medicine (accounting for about 75 percent of the company's revenue), vitamins (10 percent of revenue), and dietary supplements (15 percent); the remaining 10 percent of revenue comes from a wide range of other products. The firm sources products from leading international suppliers such as Heel (Germany), Boiron (France), Genestra Brands (USA), and Swiss Herbal (Switzerland). The pharmaceutical sector for alternative medicine in Ontario is highly fragmented and is just beginning to consolidate. Only a few pharmacy chains have focused on this unique product offering, and NatureCARE Pharmacies is a clear market leader with 18 pharmacies in the province. Management's projections assume that NatureCARE Pharmacies is expected to make three investments in fixed assets to expand its operation, this was to occur in 2011. This effort was expected to further solidify the firm's position in Ontario and serve as a springboard for further expansion into neighboring provinces (Manitoba and Quebec). Tables 1 and 2 on the following pages present the income statement and a balance sheet for NatureCARE Pharmacies. The statements present the historical financial numbers (2007 to 2010) and the projected financial forecasts (2011 to 2015). Table 3 provides averages betas for different industries. Table 4 includes selected industry averages. Please assume that the market risk premium is equal to 15% and that the 60-day Treasury bill rate is equal to 5.5%. Table 1 - The balance sheet for NatureCARE Pharmacies, 2010 - 2015 (year end results) Hisi 2012 Ils ) 2011 2012 2013 2014 2015 I Accounts receivable Ilimentary cursets I . weddin Hid e real 1 9:15,124.13339 5,538 6 .5911,08 2,51 13.919 19.292.652.2025.29,320 32.863 26.45120,523 3.15132.100 IR IRWIN 1 16 1245 120x 10670 4,1415.213,34611,409 9.573 73 13,57045.692,907 7 95 ,175 Liabilities and Shareholders' Equity Current while II A b le Intal current hilities Long tem deb Total liabilities 2 12,150 16,47422.25725,85519 327283 1 47422.252 25. 29.32232 wal 16,991|11.991 1991 6,991 6991 6,991 29,1246429.24122.87131839.853 Shareholder uity mer II Re m ings 10 Sonic 500 10.900 1764717004 Hal Assets | 33,570445.60952,1973,51 tissues Llubilities and share bukura qully Irunt hilities: I N o vale Tal current abilities Lynn du Tun Mabibodies 12. 19442225325.884232232 val 12. 11.1942 .sh. 3221122 16,991 1.991 6.991 6,091 6991 6.991 9121124.46429,249 2,8451431839853 hercher Family Ik h Related carines Total stareholders equity Total liabilities and shareholders' equity o usunto sul 12.40 3 .034 4.250 17.14625, 1971,67090.233 .534 33,37145.612. 3.511.30 Income Statement Table 2 - The income statement for NatureCARE Pharmacies, 2007-2015 (year end results) 0001 Historic 2003 2004 2009 2010 2011 Projected 2012 2013 2014 2015 Rey 13.4892.2023,734 5799484,1u55721134,783152,2069,348 11871.918,726 45.759664 0.714104, 118.91433,275 61X1.314 5.28 12237|18.042 2544 29,917 33,951 16.1171 Kloom and minine 261 3 1.7 4. .0 T 941812 11.84 145 157 478 1062947316037744416 4572 56 167 171 1581 222 2,434 2.813 .1199 I , prin Treningsbelevin s and amortization (CBITDAI 155 619 2.526.612,816 12.16 14.22 15,914 17.05 Depreciate Operating profilERIT) IN UN Farming I T axa 161 Net (less) 180 180 250 837 1832 1833 1.833 1,4 1,837 -25 419 233 5.781 111 124 14.07415217 90 1 941 1426040400 600 600 -15 200 2.15 4842 1941 11 10 14 SIX 9 729 1.745 1. 4 19 4211141143.220 -11 11 .5 1 2 5.60471 890 291 ) Table 3 - Average betas for specific industries for the period between 2000 and 2010 22 2001 2002 2003 2004 2005 2006 2007 2012 2010 Avere standard A 6.99 0,211 laron 11 as I. 9 9 10x 12 x 1.5 1.-2.53 Baking mains 1. 0. 0.0 l 1.34 0004 I S O sol 170 17 0.5 0.5 0.3 0.6 0.81 0.64 090.62 Mexicali Land 1 . .. .. .. . is '000) Til Hiccio 2007 2008 2009 2010 2011 2012 2013 2014 2015 Revue Cost of ads sold Cross profit 1.487.21623.734 7.99484,991119,472 134,73 152,2 169.34 2.4715. 11,72845.757 .0 40.204114, 118,98 133,275 181,04 3,008 12.237 18.0 25.000 29,923 33,35. 36,071 Selling cos! Kiesteral and administrative expers 262 36111,780 1451 IN 47 50 1021121 9860271 7879 2 402110 222 9.43 4 2.420 10,200 4 ,4 2,8 11,346 4,57 3,099 Fornings for res, de damuntinlun (FRITDA dades als 14 15 91412055 D I 1. 14 XL 15 Cipro ERT Intere expense Earnings becoce axes (EBT Taxese Vui vui (en) N 1421 1. 2 2 10 12 90 4 01 -115295 2.1584845249381 11,2 1 o 22 LOA |-11: Moi 1,5- 2014 2.4 6.4 7.5 14LSIS 5.225 8904 9.2 | Table 3 - Average betas for specific industries for the period between 2000 and 2010 2002 2003 2004 2005 2006 2007 2008 2009 2010 Avon devi Apparel Aulumul Baikling materials 0. 80.90 07 . 11.99 0. 1.14 1.300 100 0 1. 01 .23 2 .51 1.2 1.53 Soos 0 54.96 098 109 110 145132 1.0 104 1.14 1.19 1.20 1.59 1.9 1.7 1.7 1.1 1.11 0.od .11 .09 1.0 1.09 10 .30 0.0 0 Ilectric services In emas 1.10 1.0 1.10 1.64 0.4 0.8 1.01 10 1.2 1.2 .10 2750 14.1 21 2631 278 2 79 1411 104 110 Medical services 11. 044 x 11.94 1. Oxx 022 Precis metals 095 14 11 18 Railroad 0.81 ose 0.0 0. 0 103 4041 66 1.7 od 0. 6 s 1.00 osales 19 123 124 1220 LOI 135 134 9 4 Telecamere 11 This 0. as a dos Od samog 02 Table 4 - Selected industry averages in the pharmacy services industry FRUIT Net profit margin 7.2 percent h uity ratio 5 percent TIL 4.5 ROE 10. perveni Quin 1.2 Perform a financial analysis of the NatureCARE Pharmacies in view of the information found in the case. Your analysis should relate to historical data and forecast data. Note that in terms of historical data, only the 2010 balance sheet is available. Historical income statements are available for other years. Use tables 1 4 for your analysis