Analysis of Data in Excel Coursework - 275 Words

Analysis of Data in Excel (Coursework Sample) Content: Show all work/calculations in the most simplest for no excel pleaseWeb-surfing exercise: Find a fast-growth publicly traded firm with financial statements posted on the firmà ¢Ã¢â€š ¬s Web page. Relate that firmà ¢Ã¢â€š ¬s financial statements to those of the examples in this chapter.343344Formulate the process by which you would project that firmà ¢Ã¢â€š ¬s financial statements into the future in order to conduct a valuation.2. Using a free stock quoting and research site on the Web (e.g., or http://money.cnn.com), examine the current price for an Internet company. Relate the financial data you can find on the firm to the current stock price.Chapter 9: Exercises/Problems: # 2 p. 3442.[Venture Present Values] The TecOne Corporation is about to begin producing and selling its prototype product. Annual cash flows for the next five years are forecasted as:A. Assume annual cash flows are expected to remain at the $800,000 level after Year 5 (i.e., Year 6 and thereafte r). If TecOne investors want a 40 percent rate of return on their investment, calculate the ventureà ¢Ã¢â€š ¬s present value.B. Now assume that the Year 6 cash flows are forecasted to be $900,000 in the stepping-stone year and are expected to grow at an 8 percent compound annual rate thereafter. Assuming that the investors still want a 40 percent rate of return on their investment, calculate the ventureà ¢Ã¢â€š ¬s present value.C. Now extend Part B one step further. Assume that the required rate of return on the investment will drop from 40 percent to 20 percent beginning in Year 6 to reflect a drop in operating or business risk. Calculate the ventureà ¢Ã¢â€š ¬s present value.D. Letà ¢Ã¢â€š ¬s assume that TecOne investors have valued the venture as requested in Part C. An outside investor wants to invest $3 million in TecOne now (at the end of Year 0). What percentage of ownership in the venture should the TecOne investors give up to the outside investor for a $3 million new inv estment?Chapter 9: Softec Mini Case: p. 348 A- F onlyMINI CASE: SoftTec Products companyThe SoftTec Products Company is a successful, small, rapidly growing, closely held corporation. The equity owners are considering selling the firm to an outside buyer and want to estimate the value of the firm. Following is last yearà ¢Ã¢â€š ¬s income statement (2010) and projected income statements for the next four years (2011à ¢Ã¢â€š ¬2014). Sales are expected to grow at an annual 7 percent rate beginning in 2015 and continuing thereafter. ACTUAL PROJECTED [$ THOUSANDS] 2010 2011 2012 2013 2014 Net sales $150.0 $200.0 $250.0 $300.0 $350.0 Cost of goods sold Âà ¢75.0ÂÂÂÂ à ¢100.0 à ¢125.0 à ¢150.0 à ¢175.0 Gross profit 75.0 100.0 125.0 150.0 175.0 SGA expenses Âà ¢30.0 Âà ¢40.0 Âà ¢50.0 Âà ¢60.0 Âà ¢70.0 Depreciation à ¢7.5ÂÂÂÂ à ¢10.0 à ¢12.5 à ¢15.0 à ¢17.5 Earnings before interest and taxes ÂÂ37.5 ÂÂ50.0 ÂÂ62.5 ÂÂ75.0 ÂÂ87.5 Interest à ¢3.5ÂÂÂÂ à ¢3.5 à ¢3.5 à ¢3.5 à ¢3.5 Earnings before taxes ÂÂ34.0 ÂÂ46.5 ÂÂ59.0 ÂÂ71.5 ÂÂ84.0 Taxes (40% rate) Âà ¢13.6ÂÂÂÂÂ&nb...