Rocky mountain

In order to derive the forecast horizon, an approach of product-life cycle is used to evaluate the reasonable forecast horizon. Proper forecast horizon need to extend into the future in which the firm is under a steady-state, slow-growth or no-growth condition. By that time, the firm step into the maturity and decline period of the product-life cycle. Rocky Mountain Advanced Genome Inc.

There's a specialist from your university waiting to help you with that essay.
Tell us what you need to have done now!


order now

(RMAG) manufactures three different kinds of pharmaceutical products: diagnostic test kits related products which are supposed to be available in 12 months, agricultural bio-genetic engineering related products which are expected to generate revenues in 24-36 months, and human therapeutics related products which are still in the early period of research. Only after the third section of RMAG’s business enters into the slow maturity periods, should the whole company enjoy no excessive growth opportunities thus it determines the projections of the forecast horizon.

The following factors might determine the length of the high-speed growth period of RMAG: the size of the company, competition advantage and the barriers for new entry. While there are pharmaceutical companies with similar business in the market, it is assumed that RMAG can only enjoy a steady growth period of 5 years after the breakthrough of the products of third section, and then the company experience another 2 years’ slow-down growth to enter into the maturity period.

Since the case only provides the estimation of RMAG managements and Big Sur’s director, it is assumed that the “breakthrough” do experience in the 8th year based on the average forecast of the potential buyer and seller. Based on above analysis, it is assumed that forecast horizon is 15 years (1996-2010). 2 Free Cash Flow Projections Since most of the data available is the evaluation from the buyer and seller

with RMAG’s optimistic and Big Sur’s sober, a reasonable assumption is to take the average value as the assumed data to perform the free cash flow projections. The following are the detail assumptions: 2. 1 Assumption on Sales revenue The sales revenue are estimated according to the sales growth rate, which are assumed separately for different segments according to its different life-circle period: introductory phase’s low growth, fast growing, reaching maturity’s sustainable growth, and declining.

While the average values from the two firms are assumed to be the sales revenue for the year of 1996 to 2005, the growth rate of the following years are assumed to follow the listed principles: growth rate is assumed to stay stable in the maturity period (4 years) at a growth rate of 10%, then it is slow down till it reaches the declining period. The terminal growth rate assumption is discussed in Question 2. 2. 2 Assumption on the cost of goods sold (COGS),SG&A ,R&D,: COGS, SG&A and R&D of the year 1996-2005 are assumed to be the average rate of the estimations from RMAG and Big Sur according to the certain ratio to sales

?SID:310316707 Name: Min Ouyang? revenue. Since it normally enjoys a high profit margin in this industry, it is assumed that ratio decreases at a rate of 98% annually in the next 4 years in which COGS, SG&A account for slightly below 30% separately of the sales revenue. Since this data directly determine the profitability of the business, a sensitive analysis shows that the stable ratio change from 30% to 35%, the discounted free cash flow will change from -45. 46 to -58. 82 million. 2. 3 Assumptions on Contract revenue and Other incomes : The same principle of 2.

2 is applied to assumptions of contract revenue and other incomes. 2. 4 Tax Rate: To simplify the projections of the free cash flow, an average tax rate of 40% is assumed to stay stable which is the ratio of total taxes paid to total positive incomes before taxes. 2. 5 A/R collection periods days, A/P Collection days and inventory days Although they might be different according to the different stage of the life-circle and products, it is assumed that the A/R collection periods, A/P Collection days and inventory days keep stable to be 30 days, 20 days and 40 days separately to simplify the model.

2. 6 capital expenditure The same principle of 2. 2 is applied to assumptions of capital expenditure from 1996 to 2005, while it witness a decrease of 90% annually in the next 4 years due to the fact that with the maturity of the business, the capital expenditure will decrease significantly comparing to the growth stage. 2. 7 Changing in non-cash item It is assumed that the non-cash items are caused by the changes of accumulated depreciations. The depreciations are assumed to be the 10% of the up-dated noncash items which will be the sum total from the first year to date on a half-year base.

2. 8 Working Capital Based on the assumptions of 2. 5, the accounts receivables, the accounts payables and inventory can be calculated. The working capital is equal to accounts payable less the accounts receivables and inventory. (See attached worksheet for detail) 2. 9 WACC The assumption of WACC is assumed to match the business risks and expected inflation. Since RMAG has been found only 15 months, the commercialization of its products is expected uncertainty of FDA approval and how soon the breakthrough in research will occur. Since both RMAG and Big Sur agree that the WACC should be 0.

20, this data is assumed in the model. Meanwhile a sensitive analysis of WACC to the enterprise value shows that it can influence the outcome dramatically with a minor change from 0. 20to 0. 22 produce an outcome from 33. 85 million to negative value. Based on the above assumptions, we then calculate the PV of free cash flow with a formula of net income plus noncash items less the capital expenditure and less changing in working capital. Then we discount the FCF to get the present value of free cash flow. (See attached table for detail) Question 2 Terminal Values and Terminal Growth Rate Issue

?SID:310316707 Name: Min Ouyang? A proper terminal growth rate will be assumed to proceed the calculation of the terminal value (TV). There are several ways to forecast the terminal growth rate such as the self-sustainable growth rate formula and the nominal growth model. Since it is can seldom accurately predicate the ROE and dividend policy at this early stage of the firm, an approach of the combination of real growth rate and inflation model will be used to get a reasonable growth rate. Since an inflation of 3% is generally accepted for the macro economy of USA, the problem comes to the real growth rate.

For the pharmaceutics industry in its maturity, the drive of the growth will be growth of the population (0. 5%) and the increased medical expenditures. With RMAG’s entering into the declining period of the life circle, it is reasonable to assume that the real terminal growth range will be zero growth or equal to the average real GNP growth (2. 5%). Therefore a base growth rate is 3. 5% with a fluctuate range of 3% to 5. 5%. From the sensitive analysis, we can observe the significant influence of the terminal growth rate to the overall value in which growth change from 3% to 5. 5% leads to the 90% EV from 37. 35 to 49. 27.

Perpetual growth model is the one we will examine the TV here while the general analysis of the shortcoming of some alternative ways of doing this: book value, liquidation value, multiples (P/E, P/B) is discussed below. Book value can normally used to evaluate firms with no intangible assets and stable operations. Since book value method is backward looking, it is improper to evaluate a company like RMAG which is in its early development stage. Liquidation Value might be suitable to evaluate the firm with cloudy operating prospects. It might understate a healthy business’s terminal value like RMAG’s. Multiples will be discussed in question 3.

Since TV accounts for a big portion of the Equity of the firms, sensitive analysis of its main drives such as the sales growth rate, WACC is performed. We can clearly see the great impact of this factor in the scenario analysis. The basic assumption to calculate the TV with a perpetual growth model is listed in section 1. The formula for the terminal value of a perpetually growing firm is equal to the discounted FCF2010*(1+g) / (WACC – g). Terminal growth rate of 3. 5%, WACC of 20% with other assumptions listed in question 1 are used to calculate the TV with an outcome of 40. 92 million for the whole company in which TV is 91.

7 million. A logical conclusion of the firm’s is a range of with the down side of 37. 45 million and 57. 17 million for the upper which separately base on the assumptions of growth rate of 3% and 5. 5% while the absolute upper limit is determined by the long run growth rate of the overall society economy. Question 3 Multiples Analysis The possible approaches of multiples and its pros and cons are examined. Price-to-book method can be easily for calculation while it sometimes ignore the depreciation of the goods as well as the inflation factor and it always depend on the accounting practices to get the book value of the company.

Other issue includes how to accurately consider the multiples of firms while firms are all different although the business might be comparable. ?SID:310316707 Name: Min Ouyang? However, it is an effective supplement to evaluate the value of the company. It indicates in the case material that the book value of RMAG will be 3. 5 million and the firms will not pay dividends for quite a long time, so that it is assumed 3. 5 million will be the book value for RMAG. While the multiples of similar firms available are Human Genome Sciences’ 11. 71 and Myraid Genetics’ 4.

55, we take 8 times as the base assumption for the enterprise values since comparable companies are between 4 to 12 times. The ranges of the multiples, we take 4 to 11 times as the great uncertainty of future development of the company. In this case, the 90% of the value will range from 12. 6 million to 34. 65 million as shown in the sensitive analysis. As for another multiple of P/E, it also has some kinds of shortcoming. Firstly it cannot be accurately forecast the earnings for the maturity and declining period; anyway, it is a thing of 15 years later.

Secondly it base on the earnings instead of the free cash flow, so that it might be inaccurate for predict a company like RMAG and it might be more appropriate for a mature company with stable earnings. However, it does provide us some information to predict the value of the firm. Sensitive analysis can give some clue of the range of the evaluation. We examine the net income of 2010 and get the PV of 14. 91 million with a discount rate of 20% and other assumptions listed in question 1. We then examine the relevant company’s 15-20 times for comparable companies. As for the performance of Human Genome Sciences’ 87.

77, it is high due to the fact that the company is at the stage of high growth. We take a multiple of 17 times as the base assumption and down side’s 15 and upper’s 19 to get a base value of 228. 15 million with a range of 201. 31to 254. 99million (see sensitive analysis for detail) for 90% of the value. It indicates the huge opportunities of RMAG, of course, it also contains great risks of whether or not the company can reach that period. Question 4 Triangulation of value. Different methods come to different results of the values of RMAG. Due to the relatively short of direct operating data, all valuation is measured with inaccurate.

We further investigate the assumptions contained in various approaches to triangulate the appropriate value estimation. The perpetual growth model is superior since it enjoys the features such as forward looking, cash flow-focused, time value of funds while other the pros and cons of other approaches is discussed in above section. It is reasonable to give the most weight to perpetual growth/DCF valuation, and the least weight to P/E approaching with 85%, 10% and 5% of the weight is separately allocated to perpetual growth model, P/B multiples and P/E multiples. Of

course, if we raise the weight of P/E multiples the price will get higher due to the fact that we emphasis more on future benefits over current risks to increase the weight of P/E. Given this method of weight allocation, the attached worksheets clearly show the enterprise value (90% EV) is 48. 71 million with a range from 35. 12 million to 60. 62million based on the assumptions listed above. Beyond the purchasing decision, this outcome gives some guidelines of the negations of the acquisition activities. We could start with the price of 35. 12 million while quitting the negations if the price goes up as high as 60. 62 million.

?SID:310316707 Name: Min Ouyang? Income Statement Forecast Income Statement 1996 1997 1998 1999 2000 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010 0. 5 8. 0 0. 5 8. 5 19. 2 3. 0 33. 2 32. 6 9. 9 63. 0 55. 5 31. 7 107. 1 83. 2 60. 2 149. 9 112. 4 84. 3 164. 9 151. 7 109. 5 181. 4 166. 9 120. 5 199. 5 183. 5 132. 6 219. 5 201. 9 145. 8 237. 0 222. 1 160. 4 251. 3 239. 9 173. 2 260. 0 254. 2 183. 6 269. 2 263. 1 190. 0 278. 6 272. 4 196. 7 0. 0 9. 0 13. 5 0. 0 30. 7 24. 6 0. 0 75. 7 37. 8 4. 0 154. 2 67. 8 28. 4 278. 9 117. 1 85. 2 431. 7 172. 7 127. 8 553. 9 221. 6 166. 1 634. 9 222. 2 199. 4 715. 0 250. 2 219. 3 786. 5 275. 3 241.

2 860. 7 275. 4 265. 4 929. 7 291. 6 286. 6 984. 5 302. 6 303. 8 1026. 1 309. 0 314. 4 1062. 0 313. 5 -4. 5 21. 5 6. 1 22. 5 37. 8 15 86. 3 12 161. 8 4 259. 0 3. 5 332. 4 3. 5 412. 7 3. 5 464. 7 3. 5 511. 2 3. 5 585. 3 3 638. 1 3 681. 9 3 717. 1 3 748. 6 3 R&D 21. 5 SG&A 18. 0 39. 5 1 24. 5 22. 5 25 27 34. 5 43. 5 51. 5 52. 5 50 49 48. 0 47. 1 46. 1 45. 2 30. 7 55. 2 1 45. 4 67. 9 0. 5 77. 1 102. 1 -2 139. 4 166. 4 -6 172. 7 207. 2 -13. 5 221. 6 265. 1 -20. 5 254. 0 305. 5 -22. 5 250. 2 302. 7 -18. 5 275. 3 325. 3 -10 275. 4 324. 4 -10 291. 6 339. 6 -10 302. 6 349. 6 -10 309. 0 355. 2 -10 313. 5 358. 7 -10 -21. 5 -25. 6 -14. 6 -5. 8

-6. 7 41. 8 50. 3 88. 2 147. 0 179. 4 253. 9 291. 6 325. 3 354. 9 382. 9 0 0 0 0 0 16. 7 20. 1 35. 3 58. 8 71. 8 101. 5 116. 6 130. 1 142. 0 153. 2 -21. 5 -25. 6 -14. 6 -5. 8 -6. 7 25. 1 30. 2 52. 9 88. 2 107. 7 152. 3 174. 9 195. 2 212. 9 229. 7 Sales Cancer diagnostics Other diagnostics Agriculture Human therapeutics Total sales Cost of sales Gross Profits Contract Revenues Operating expenses Total Expenses Other Income Income before Taxes Taxes Net Income Free Cash Flow Caculation Net Income Noncash Items Changing in Working Capital Captital Expenditures Free Cash Flow -21. 5 -25. 6 -14. 6 -5. 8 0. 4 0. 7 1. 5 3. 1 -2. 0 -3. 3 -7.

9 -13. 2 -7. 5 -7 -16 -32 -6. 7 5. 7 -20. 4 -52 25. 1 8. 4 -27. 1 -53 30. 2 11. 5 -20. 3 -63 52. 9 14. 4 -13. 3 -58 88. 2 16. 7 -15. 5 -45 107. 7 18. 7 -12. 5 -40. 5 152. 3 20. 5 -14. 3 -36. 5 174. 9 22. 2 -12. 4 -32. 8 195. 2 23. 6 -10. 0 -29. 5 212. 9 25. 0 -7. 7 -26. 6 229. 7 26. 2 -6. 7 -23. 9 -30. 6 -73. 4 -46. 6 -41. 6 -4. 0 44. 4 73. 4 122. 1 151. 9 179. 3 203. 7 225. 3 -35. 1 -37. 0 -47. 8 ?SID:310316707 Name: Min Ouyang? Balance Sheet Forecast (Partial) assets account receivable inventory accumulated depreceication liablity and EQUILITY Accounts payable 0. 7 1. 0 2. 4 2. 5 3. 4 3. 1 6. 2 8. 3 4. 6 12. 7 16. 9 7. 8 22. 9 30. 6

13. 5 35. 5 47. 3 21. 9 45. 5 60. 7 33. 4 52. 2 69. 6 47. 8 58. 8 78. 4 64. 5 64. 6 86. 2 83. 2 70. 7 94. 3 103. 7 76. 4 101. 9 125. 9 80. 9 107. 9 149. 5 84. 3 112. 5 174. 5 87. 3 116. 4 200. 6 2. 2 3. 0 3. 7 5. 6 9. 1 11. 4 14. 5 16. 7 16. 6 17. 8 17. 8 18. 6 19. 2 19. 5 19. 7 8 -4. 0 -0. 9 9 44. 4 8. 6 NPV caculation year counter Free cash Flow Discount Free Cash Flow Terminal Value NPV of Equity 1 -30. 6 -25. 5 2 -35. 1 -24. 4 3 -37. 0 -21. 4 91. 7 40. 92 4 -47. 8 -23. 1 5 -73. 4 -29. 5 6 -46. 6 -15. 6 7 -41. 6 -11. 6 10 11 12 13 73. 4 122. 1 151. 9 179. 3 11. 9 16. 4 17. 0 16. 8 PV of Total free cash flow NPV of Net Income of 2010

14 15 203. 7 225. 3 15. 9 14. 6 -50. 8 14. 91 Basic Assumptions Cancer diagnostics sales growth Other diagnostics sales growth Agriculture sales growth Human therapeutics sales growth Cost of Sales /Sales contract revenue SG&A/Sales R&D Other incomes effective tax rate A/R collection periods days A/P Collection days inventory days capital expenditure Starting Non Cash Changing in Non cash Working Capital Terminal Growth Rate WACC 0 3 0 0 1. 5 21. 5 2 21. 5 1 0. 4 30 20 40 7. 5 2. 0 0. 4 0. 4 0. 035 0. 2 16 2. 9 0. 9 1. 4 0. 7 0. 7 5 2. 3 2. 2 0 0 0 0. 8 0. 5 0. 44 22. 5 15 12 1 0. 6 0. 5 24. 5 22. 5 25 1 0. 5 -2 0. 4 0. 4 0. 4 30 30 30

20 20 20 40 40 40 7 16 32 2. 4 3. 1 4. 6 0. 7 1. 5 3. 1 -2. 9 -10. 8 -24. 0 0. 7 0. 5 0. 9 6. 1 0. 42 4 0. 5 27 -6 0. 4 30 20 40 52 7. 8 5. 7 -44. 4 0. 4 0. 35 0. 4 2 0. 4 3. 5 0. 4 34. 5 -13. 5 0. 4 30 20 40 53 13. 5 8. 4 -71. 4 0. 1 0. 1 0. 35 0. 1 0. 3 0. 1 0. 5 0. 3 0. 4 0. 35 3. 5 3. 5 0. 4 0. 4 43. 5 51. 5 -20. 5 -22. 5 0. 4 0. 4 30 30 20 20 40 40 63 58 21. 9 33. 4 11. 5 14. 4 -91. 7 -105. 0 0. 1 0. 1 0. 1 0. 2 0. 35 3. 5 0. 35 52. 5 -18. 5 0. 4 30 20 40 45 47. 8 16. 7 -120. 5 0. 1 0. 1 0. 1 0. 1 0. 35 3. 5 0. 35 50 -10 0. 4 30 20 40 40. 5 64. 5 18. 7 -133. 0 0. 08 0. 06 0. 035 0. 1 0. 08 0. 06 0. 1 0. 08 0. 06 0. 1 0. 1 0. 08

0. 32 0. 31 0. 31 3 3 3 0. 32 0. 31 0. 31 49. 00 48. 02 47. 06 -10 -10 -10 0. 4 0. 4 0. 4 30 30 30 20 20 20 40 40 40 36. 5 32. 8 29. 5 83. 2 103. 7 125. 9 20. 5 22. 2 23. 6 -147. 3 -159. 7 -169. 7 0. 035 0. 035 0. 035 0. 06 0. 30 3 0. 30 46. 12 -10 0. 4 30 20 40 26. 6 149. 5 25. 0 -177. 3 0. 035 0. 035 0. 035 0. 035 0. 30 3 0. 30 45. 20 -10 0. 4 30 20 40 23. 9 174. 5 26. 2 -184. 0 ?SID:310316707 Name: Min Ouyang? Sensitive Analysis of Growth Rate Growth Rate Enterprise Value 90% EV 0. 035 40. 92 36. 83 0. 020 31. 10 27. 99 0. 030 37. 45 33. 71 P / B t e r mi n a l v a l u e s e n s i t i v e a n a l ys i s Terminate Value 91. 73 82.

07 88. 32 0. 035 0. 040 0. 050 40. 92 44. 60 52. 71 36. 83 40. 14 47. 43 91. 73 95. 35 103. 34 0. 055 57. 17 51. 46 107. 75 Sensitive Analysis of WACC WACC 0. 20 Enterprise Value 40. 92 96. 92 90% EV 36. 83 87. 22 Terminate Value 91. 73 134. 31 0. 22 40. 92 20. 34 3. 43 36. 83 18. 31 3. 09 91. 73 76. 36 63. 84 0. 24 -21. 98 -19. 78 45. 15 0. 18 0. 20 0. 21 Enterprise Value 15. 00 16. 00 17. 00 19. 00 223. 67 201. 31 238. 58 253. 50 283. 32 298. 23 214. 73 228. 15 254. 99 268. 41 20. 00 S ens itive Analys is of C O GS COGS Terminate Value PV Total FCF 0. 32 91. 7 -50. 8 0. 3 96. 51 -45. 46 0. 31 94. 12 -48. 13 0. 32 0. 33 0. 34 0. 35

91. 73 89. 33 86. 94 84. 55 -50. 80 -53. 48 -56. 15 -58. 82 S e n s i t i v e An a l ys i s Growth Rate PV Total FCF 0. 035 -50. 80 0. 020 -50. 98 0. 030 -50. 86 0. 035 -50. 80 0. 040 -50. 75 0. 050 -50. 63 0. 055 -50. 57 P/E terminal value sensitive Analysis multiple m u l t i p l e E n t e r p r i s e V a l9u0e% E V 4. 00 14 12. 6 6. 00 21 18. 9 8. 00 28 25. 2 10. 00 35 31. 5 11. 00 38. 5 34. 65 90% EV of G rowth Rate EV 40. 92 31. 10 37. 45 40. 92 44. 60 52. 71 57. 17 P/B terminal value sensitive analysis multiple Enterprise Value 4. 00 14 6. 00Valuation Approach 21 8. 00 28 P/E multiples 10. 00 35 11. 00 P/B multiples 38. 5 90% EV

Base triangulations of the enterprise value projections 12. 6 18. 9 90% of Enterprise value Relevant Weight Weighted Average value (90%) 25. 2 228. 15 0. 05 11. 41 31. 5 25. 20 0. 10 2. 52 34. 65 DCF of FCF andTerminal Value 40. 92 0. 85 34. 78 Sensitive Analysis of COGS Total EV(90%) COGS Terminate Value PV Total FCF 0. 32 91. 7 -50. 8 0. 3 96. 51 -45. 46 Downside triangulations of the enterprise value projections 0. 31 94. 12 -48. 13 0. 32Valuation Approach 91. 73 0. 33 89. 33 P/E multiples 0. 34 86. 94 P/B multiples 0. 35 84. 55 -50. 80 90% of Enterprise value -53. 48 201. 31 -56. 15 12. 60 -58. 82 DCF of FCF andTerminal Value 27. 99

48. 71 Relevant Weight Weighted Average value (90%) 0. 05 0. 10 0. 85 10. 07 1. 26 23. 79 Sensitive Analysis of Growth Rate Total EV(90%) 35. 12 Growth Rate PV Total FCF EV 0. 035 -50. 80 40. 92 0. 020 -50. 98 31. 10 0. 030 -50. 86 37. 45 Upside triangulations of the enterprise value projections 0. 035 -50. 80 40. 92 Valuation Approach 90% of Enterprise value Relevant Weight Weighted Average value (90%) 0. 040 -50. 75 44. 60 268. 41 0. 05 13. 42 0. 050 P/E multiples -50. 63 52. 71 0. 055 P/B multiples -50. 57 57. 17 34. 65 0. 10 3. 47 DCF of FCF andTerminal Value Total EV(90%) 51. 46 0. 85 43. 74 60. 62 ?SID:310316707 Name: Min Ouyang?

Income Statement Forecast Income Statement 1996 1997 1998 1999 2000 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010 0. 5 8 0. 5 0 =B4*(1+C43) =B5*(1+C44) =B6*(1+C45) =B7*(1+C46) =C4*(1+D43) =C5*(1+D44) =C6*(1+D45) 0 =D4*(1+E43) =D5*(1+E44) =D6*(1+E45) 4 =E4*(1+F43) =E5*(1+F44) =E6*(1+F45) =E7*(1+F46) =F4*(1+G43) =F5*(1+G44) =F6*(1+G45) =F7*(1+G46) =G4*(1+H43) =G5*(1+H44) =G6*(1+H45) =G7*(1+H46) =H4*(1+I43) =H5*(1+I44) =H6*(1+I45) =H7*(1+I46) =I4*(1+J43) =I5*(1+J44) =I6*(1+J45) =I7*(1+J46) =J4*(1+K43) =J5*(1+K44) =J6*(1+K45) =J7*(1+K46) =K4*(1+L43) =K5*(1+L44) =K6*(1+L45) =K7*(1+L46) =L4*(1+M43) =L5*(1+M44) =L6*(1+M45) =L7*(1+M46)

=M4*(1+N43) =M5*(1+N44) =M6*(1+N45) =M7*(1+N46) =N4*(1+O43) =N5*(1+O44) =N6*(1+O45) =N7*(1+O46) =O4*(1+P43) =O5*(1+P44) =O6*(1+P45) =O7*(1+P46) Total sales Cost of sales Gross Profits =B4+B5+B6+B7 =B8*B47 =B8-B9 =C4+C5+C6+C7 =C8*C47 =C8-C9 =D4+D5+D6+D7 =D8*D47 =D8-D9 =E4+E5+E6+E7 =E8*E47 =E8-E9 =F4+F5+F6+F7 =F8*F47 =F8-F9 =G4+G5+G6+G7 =G8*G47 =G8-G9 =H4+H5+H6+H7 =H8*H47 =H8-H9 =I4+I5+I6+I7 =I8*I47 =I8-I9 =J4+J5+J6+J7 =J8*J47 =J8-J9 =K4+K5+K6+K7 =K8*K47 =K8-K9 =L4+L5+L6+L7 =L8*L47 =L8-L9 =M4+M5+M6+M7 =M8*M47 =M8-M9 =N4+N5+N6+N7 =N8*N47 =N8-N9 =O4+O5+O6+O7 =O8*O47 =O8-O9 =P4+P5+P6+P7 =P8*P47 =P8-P9 Contract Revenues =B48 =C48 =D48 =E48 =F48

=G48 =H48 =I48 =J48 =K48 =L48 =M48 =N48 =O48 =P48 =C50 =C8*C49 =D50 =D8*D49 =E50 =E8*E49 =F50 =F8*F49 Sales Cancer diagnostics Other diagnostics Agriculture Human therapeutics Operating expenses R&D =B50 SG&A =B8*B49 =G50 =G8*G49 =H50 =H8*H49 =I50 =I8*I49 =J50 =J8*J49 =K50 =K8*K49 =L50 =L8*L49 =M50 =M8*M49 =N50 =N8*N49 =O50 =O8*O49 =P50 =P8*P49 Total Expenses Other Income Income before Taxes =B14+B15 =C14+C15 =D14+D15 =E14+E15 =F14+F15 =B51 =C51 =D51 =E51 =F51 =B10+B11-B16+B17 =C10+C11-C16+C17=D10+D11-D16+D17 E10+E11-E16+E17 =F10+F11-F16+F17 = =G14+G15 =G51 =G10+G11-G16+G17 =H14+H15 =H51 =H10+H11-H16+H17 =I14+I15 =I51 =I10+I11-I16+I17

=J14+J15 =J51 =J10+J11-J16+J17 =K14+K15 =K51 =K10+K11-K16+K17 =L14+L15 =L51 =L10+L11-L16+L17 =M14+M15 =M51 =M10+M11-M16+M17 =N14+N15 =N51 =N10+N11-N16+N17 =O14+O15 =O51 =O10+O11-O16+O17 =P14+P15 =P51 =P10+P11-P16+P17 Taxes 0 0 0 0 0 =G18*0. 4 =H18*0. 4 =I18*0. 4 =J18*0. 4 =K18*0. 4 =L18*0. 4 =M18*0. 4 =N18*0. 4 =O18*0. 4 =P18*0. 4 Net Income =B18-B19 =C18-C19 =D18-D19 =E18-E19 =F18-F19 =G18-G19 =H18-H19 =I18-I19 =J18-J19 =K18-K19 =L18-L19 =M18-M19 =N18-N19 =O18-O19 =P18-P19 Free Cash Flow Caculation Net Income =B20 =G20 =H20 =I20 =J20 =K20 =L20 =M20 =N20 =O20 =P20 Noncash Items Changing in Working Capital Captital Expenditures Free Cash Flow

0. 38 =C33-B33 =D33-C33 =E33-D33 =F33-E33 -2 =C59-B59 =D59-C59 =E59-D59 =F59-E59 =-B56 =-C56 =-D56 =-E56 =-F56 =B23+B24+B25+B26 =C23+C24+C25+C26 =D23+D24+D25+D26 =E23+E24+E25+E26 =F23+F24+F25+F26 =G33-F33 =G59-F59 =-G56 =G23+G24+G25+G26 =H33-G33 =H59-G59 =-H56 =H23+H24+H25+H26 =I33-H33 =I59-H59 =-I56 =I23+I24+I25+I26 =J33-I33 =J59-I59 =-J56 =J23+J24+J25+J26 =K33-J33 =K59-J59 =-K56 =K23+K24+K25+K26 =L33-K33 =L59-K59 =-L56 =L23+L24+L25+L26 =M33-L33 =M59-L59 =-M56 =M23+M24+M25+M26 =N33-M33 =N59-M59 =-N56 =N23+N24+N25+N26 =O33-N33 =O59-N59 =-O56 =O23+O24+O25+O26 =P33-O33 =P59-O59 =-P56 =P23+P24+P25+P26 =B53/365*B8 =B55/365*B8 =B58+B57

=C53/365*C8 =C55/365*C8 =C58+C57 =D53/365*D8 =D55/365*D8 =D58+D57 =E53/365*E8 =E55/365*E8 =E58+E57 =F53/365*F8 =F55/365*F8 =F58+F57 =G53/365*G8 =G55/365*G8 =G58+G57 =H53/365*H8 =H55/365*H8 =H58+H57 =B54/365*B16 =C54/365*C16 =D54/365*D16 =E54/365*E16 =F54/365*F16 =G54/365*G16 =H54/365*H16 5 =F27 =F38/(1+B61)^F37 6 =G27 =G38/(1+B61)^G37 7 =H27 =H38/(1+B61)^H37 0. 4 0. 35 0. 4 2 0. 4 3. 5 0. 4 34. 5 -13. 5 0. 4 30 20 40 53 =F57+F58 =0. 05*(SUM(B56:G56)) 0. 1 0. 35 0. 3 0. 5 0. 4 3. 5 0. 4 43. 5 -20. 5 0. 4 30 20 40 63 =G57+G58 =0. 05*(SUM(B56:H56)) =C20 =D20 =E20 =F20 Balance Sheet Forecast (Partial) assets account receivable inventory

accumulated depreceication liablity and EQUILITY Accounts payable =I53/365*I8 =I55/365*I8 =I58+I57 =J53/365*J8 =J55/365*J8 =J58+J57 =K53/365*K8 =K55/365*K8 =K58+K57 =L53/365*L8 =L55/365*L8 =L58+L57 =M53/365*M8 =M55/365*M8 =M58+M57 =N53/365*N8 =N55/365*N8 =N58+N57 =O53/365*O8 =O55/365*O8 =O58+O57 =P53/365*P8 =P55/365*P8 =P58+P57 =I54/365*I16 =J54/365*J16 =K54/365*K16 =L54/365*L16 =M54/365*M16 =N54/365*N16 =O54/365*O16 =P54/365*P16 9 =J27 =J38/(1+B61)^J37 10 =K27 =K38/(1+B61)^K37 13 =N27 =N38/(1+B61)^N37 =SUM(B39:P39) 14 =O27 =O38/(1+B61)^O37 15 =P27 =P38/(1+B61)^P37 NPV caculation year counter Free cash Flow Discount Free Cash Flow

Terminal Value NPV of Equity 1 2 3 4 =B27 =C27 =D27 =E27 =B38/(1+B61)^B37 =C38/(1+B61)^C37 =D38/(1+B61)^D37 =E38/(1+B61)^E37 =P38*(1+B60)/(B61-B60)/((1+B61)^P37) =SUM(B39:P39)+P38*(1+B60)/(B61-B60)/((1+B61)^P37) 8 =I27 =I38/(1+B61)^I37 11 12 =L27 =M27 =L38/(1+B61)^L37 =M38/(1+B61)^M37 PV of Total free cash flow NPV of Net Income of 2010 =P20/(1+B61)^P37 Basic Assumptions Cancer diagnostics sales growth 0 Other diagnostics sales growth 3 Agriculture sales growth 0 Human therapeutics sales growth 0 Cost of Sales /Sales 1. 5 contract revenue 21. 5 SG&A/Sales 2 R&D 21. 5 Other incomes 1 effective tax rate 0. 4 A/R collection periods days

30 A/P Collection days 20 inventory days 40 capital expenditure 7. 5 Starting Non Cash 2 Changing in Non cash =0. 05*B56 16 2. 9 0. 9 0. 7 1. 4 0. 7 0. 7 0. 5 5 2. 3 2. 2 0. 9 0 0 0 6. 1 0. 8 0. 5 0. 44 0. 42 22. 5 15 12 4 1 0. 6 0. 5 0. 5 24. 5 22. 5 25 27 1 0. 5 -2 -6 0. 4 0. 4 0. 4 0. 4 30 30 30 30 20 20 20 20 40 40 40 40 7 16 32 52 =B57+B58 =C57+C58 =D57+D58 =E57+E58 =0. 05*(SUM(B56:C56)) =0. 05*(SUM(B56:D56)) =0. 05*(SUM(B56:E56)) 0. 05*(SUM(B56:F56)) = 0. 1 0. 1 0. 1 0. 3 0. 35 3. 5 0. 4 51. 5 -22. 5 0. 4 30 20 40 58 =H57+H58 =0. 05*(SUM(B56:I56)) 0. 1 0. 1 0. 1 0. 1 0. 1 0. 1 0. 2 0. 1 0. 35 0. 35 3. 5 3. 5 0. 35 0. 35 52. 5 50

-18. 5 -10 0. 4 0. 4 30 30 20 20 40 40 45 =J56*0. 9 =I57+I58 =J57+J58 =0. 05*(SUM(B56:J56)) =0. 05*(SUM(B56:K56)) 0. 08 0. 1 0. 1 0. 1 0. 32 3 0. 32 =K50*0. 98 -10 0. 4 30 20 40 =K56*0. 9 =K57+K58 =0. 05*(SUM(B56:L56)) 0. 06 0. 08 0. 08 0. 1 =0. 98*L47 3 =L49*0. 98 =L50*0. 98 -10 0. 4 30 20 40 =L56*0. 9 =L57+L58 =0. 05*(SUM(B56:M56)) 0. 035 =M43 =M43 0. 08 =0. 98*M47 3 =M49*0. 98 =M50*0. 98 -10 0. 4 30 20 40 =M56*0. 9 =M57+M58 =0. 05*(SUM(B56:N56)) =N43 =B60 =B60 0. 06 =0. 98*N47 3 =N49*0. 98 =N50*0. 98 -10 0. 4 30 20 40 =N56*0. 9 =N57+N58 =0. 05*(SUM(B56:O56)) =O43 =N43 =B60 =B60 =0. 98*O47 3 =O49*0. 98 =O50*0. 98 -10 0. 4 30 20 40

=O56*0. 9 =O57+O58 =0. 05*(SUM(B56:P56)) ?SID:310316707 Name: Min Ouyang? Growth Rate Sensitive Analysis of Growth Rate Enterprise Value 90% EV Terminate Value =B60 0. 02 0. 03 0. 035 =B41 =TABLE(,B60) =TABLE(,B60) =TABLE(,B60) =S4*0. 9 =TABLE(,B60) =TABLE(,B60) =TABLE(,B60) =B40 =TABLE(,B60) =TABLE(,B60) =TABLE(,B60) 0. 04 0. 05 0. 055 =TABLE(,B60) =TABLE(,B60) =TABLE(,B60) =TABLE(,B60) =TABLE(,B60) =TABLE(,B60) =TABLE(,B60) =TABLE(,B60) =TABLE(,B60) Sensitive Analysis of WACC WACC Enterprise Value 90% EV Terminate Value =B61 0. 18 =B41 =TABLE(,B61) =S14*0. 9 =TABLE(,B61) =B40 =TABLE(,B61) 0. 2 0. 21 0. 22 =TABLE(,B61) =TABLE(,B61)

=TABLE(,B61) =TABLE(,B61) =TABLE(,B61) =TABLE(,B61) =TABLE(,B61) =TABLE(,B61) =TABLE(,B61) 0. 24 =TABLE(,B61) =TABLE(,B61) =TABLE(,B61) P/E terminal value sensitive Analysis multiple Enterprise Value 90% EV 15 =R23*O41 =S23*0. 9 16 17 19 20 =R24*O41 =R25*O41 =R26*O41 =R27*O41 =S24*0. 9 =S25*0. 9 =S26*0. 9 =S27*0. 9 P/B terminal value sensitive analysis multiple 4 6 8 10 11 Enterprise Value 90% EV =R31*3. 5 =R32*3. 5 =R33*3. 5 =R34*3. 5 =R35*3. 5 =S31*0. 9 =S32*0. 9 =S33*0. 9 =S34*0. 9 =S35*0. 9 =L47 0. 3 0. 31 Sensitive Analysis of COGS Terminate Value =B40 =TABLE(,L47) =TABLE(,L47) PV Total FCF =N40 =TABLE(,L47) =TABLE(,L47)