Making 6 pages business valuation report based on the rubric and the instructions given in the attached files. Excel file and report format are provided for your reference. Use professional english for the format.
Project Report Introduction (20%) This section identifies the current situation, financial objectives and the scope and scale of the analysis Qualitative Assessment (20%) This section provides an analysis of the company’s current strategic options and discuss the qualitive impacts on the company and shareholder interests. Valuation (30%) This section demonstrates the valuation results and address assumptions and methods being conducted. What Type of Valuation? Why this type? And Result. Using the excel template as the reference. Recommendation (30%) This section provides recommendations for the board ‘s decision. FNCE Project – M&A, IPO, and Business Valuation Company Background Telecom Inc. is a family-owned business founded in 1985, and it has been providing TV broadcasting in east Canada. In 2008, it planned to go public and list on the Toronto exchange. However, the financial market collapsed, and the company had to withdraw from the IPO process. Instead, Telecom proceeded with a private placement with a syndicate of local private equity groups and issued 5 million shares at $20 per share. After issuing, Telecom has 10 million shares outstanding. Five years ago, the company also borrowed a $20 million long-term loan outstanding at a 6.5% annual interest rate to expand its satellite TV business. Telecom's marginal tax rate is 34%. Industry Outlook In 2019, the tv broadcasting industry generated $2.8 billion in revenue, with a compounded annual growth rate of 1%. The industry is profitable but highly saturated. Currently, there are five major players dominating the market. • Bell Blue Media, 35% market shares • CBC News, 20% market shares • Corus Live Inc., 15% market shares • Rog Entertainment 10% market shares • Rouge Stone Inc. 6% market shares • Others, 14% market shares According to the industry report, this industry in Canada will continue to be challenged by a shifting media environment over the next decade. The main threat to this industry is primarily online streaming platforms in the USA, and this competition is expected to intensify and plummet industry growth and revenue. Consumers continue to lower their reliance on TV broadcasts for their media source as they increase their dependence on digital forms, including tablets and mobile phones. This trend lures advertisers to increase their commercial budget for new media outlets. In response, the Canadian Radio-television and Telecommunications Commission (CRTC) has lessened content rules and increased funding and pilot programs to provide new avenues for Canadian broadcasting companies, but this may ultimately not be enough to offset further revenue declines. The board of Telecom, mainly controlled by the private equity groups, called a board meeting to urge the management to develop a forward-thinking strategy and reevaluate the IPO opportunity. The board concluded that they must restructure their business models, add digital platform infrastructure, and generate online advertising revenue. The private equity groups have held their investment for more than ten years. Now it is time for them to exist and capitalize on their return via IPO in the stock market. The board wants to know the intrinsic value of their holdings. Board's Agenda One of the directors suggested that the company invests in online streaming platforms and set up a few content-creating studios in-house. She believes this strategy will create synergy between new streaming and current broadcasting. Telecom is able to utilize current employees' talent and maintain content quality and brand identity. She also holds a seat on another company, LimeStreaming Inc. as an independent director. LimeStream has been growing rapidly in the online stream space. She knows that the founders of LimeStreaming are looking for buyers. She suggested the board consider an acquisition as an option to expand Telecom's online business advertising service. The board requests a second opinion on the acquisition deal and the IPO. They want to know whether the acquisition will benefit their shareholders and how much would be the fair value of LimeStreaming Inc. Also, all the board members agree to proceed with the IPO and determine the fair share price before moving forward. Valuation Methods In valuing a business, there is no single or specific mathematical formula. The particular approach and the factors to consider will vary in each case. Where there is evidence of open market transactions having occurred involving the shares, or operating assets, of a business interest, those transactions may often form the basis for establishing the value of the company. Because LimeStreaming and Telecom are private companies, which lack open market transactions, the generally accepted approaches for valuing a private business interest are: Method 1: The Capitalized Earnings Approach (LimeStream) Method 2 The Capitalized EBITDA Approach (LimeStream) Method 3: The Market Approach (Telecom) The Capitalized Earnings/EDITDA Approaches are a general way of determining a business value by using one or more methods wherein a value is determined by capitalizing or discounting anticipated future benefits. This approach emphases on the continuation of the operations as if the business is a "going concern". The Market Approach to valuation is a general way of determining a business value or equity interest by using one or more methods that compare the subject entity to similar businesses, business ownership interests, and securities that have been sold in the public market at a fair price. Required In the report, you need to address the board's concern regarding the LimeStream acquisition and the company IPO, including the pros and cons of each strategy. Moreover, you are requested to perform quantitative analysis and provide the business value of LimeStream and the fair share price of Telecom Inc. My Highlight My Highlight My Highlight My Highlight My Highlight LimeStreams LimeStreams Account12/31/1912/31/2012/31/21TTM Total Revenue$15,073,000.00$13,916,000.00$14,655,000.00$14,786,000.00 Cost of Revenue$8,861,000.00$8,059,000.00$8,768,000.00$8,751,000.00 Gross Profit$6,212,000.00$5,857,000.00$5,887,000.00$6,035,000.00 Operating Expenses Total Operating Expenses$2,488,000.00$2,618,000.00$2,585,000.00$2,593,000.00 Operating Income or Loss$3,724,000.00$3,239,000.00$3,302,000.00$3,442,000.00 Interest Expense$799,000.00$844,000.00$816,000.00$860,000.00 Total Other Income/Expenses Net-$149,000.00-$196,000.00-$330,000.00-$371,000.00 Income Before Tax$2,755,000.00$2,172,000.00$2,127,000.00$2,183,000.00 Income Tax Expense$712,000.00$580,000.00$569,000.00$594,000.00 Income from Continuing Operations$2,043,000.00$1,592,000.00$1,558,000.00$1,589,000.00 Net Income$2,043,000.00$1,592,000.00$1,558,000.00$1,589,000.00 EBITDA$6,119,000.00$5,711,000.00$5,596,000.00- Cash and Cash Equivalents$ 250,000.00 Long Term Loan$ 1,000,000.00 Perferred Shares$ - 0 Minority Interests$ - 0 Telecom 2021TTM Revenue$ 154,000,000.00$ 153,500,000.00 Operating Income $ 37,000,000.00$ 36,800,000.00 Net Income $ 17,000,000.00$ 15,800,000.00 EBITDA $ 103,000,000.00$ 102,500,000.00 Diluted EPS$ 83,000,000.00$ 82,500,000.00 Normalized Diluted EPS$ 85,000,000.00$ 84,300,000.00 $ - 0$ - 0 In Billion$ - 0$ - 0 Cash and Cash Equivalents$ 4,000,000.00$ 4,200,000.00 Long Term Loan$ 10,000,000.00$ 10,000,000.00 Perferred Shares$ - 0$ - 0 Minority Interests$ - 0$ - 0 Comps US$ MMListed MarketEnterpriseTTMTTMTTMTTMEV/EV/EV/EV/ NameTickerExchangeSharesPriceCapitalizationValueRevenuesEBITDANet IncomeCash FlowRevenueEBITDANet IncomeCash FlowCashDebt, Prefs, MI Bell Blue MediaBBMETSX55.835.01,951.41,951.43,245.5350.0306.0186.00.65.66.410.575.075.0 CBC NewsCBCNTSX44.722.51,006.41,895.911,453.51,235.0860.0460.00.10.81.22.2345.51,235.0 Corus LiveCORSTSX45.63.8170.8156.81,453.8115.065.029.00.11.52.65.9162.0148.0 Rog Entertainment ROGETSX88.228.82,536.92,428.91,243.7125.068.080.02.020.337.331.7120.012.0 Rouge StoneROUGTSX75.432.72,462.02,873.5564.595.055.075.04.425.944.832.88.5420.0 Multiple Capitalized Earnings Method Cost of EquityLowHigh Long-term government bond yields2.31%2.31% Adjusted large cap equity risk premia4.20%4.20% Small cap equity risk premia3.50%3.50% Company specific risk11.00%12.00% Required equity return 21.01%22.01% Long-Term Growth in Earnings1%1% Capitalization Rate5.00 (x)4.76 (x) Capitalized EBIDTA Method Support for Discount to Comparable Company Multiplies Size10.0%15.0% Liquidity15.0%20.0% 25.0%35.0% Discount Range EBITDA MultipleMultiplier 5.5025%4.13 5.5030%3.85