Please help me do this if you know, thank you very much and please step by step that makes me better understand.
(a). The EBITx multiples of the legacy auto part manufacturers would be very different from those of the new auto parts manufacturers' entrants. Also, age-wise, they are not suitable comparables so it would provide an erroneous valuation to use them as comparables.
(b). Average EV/Sales multiple = (0.3+0.1+0.5+1)/4 = 0475
VRT EV = 0.475*Sales = 0.475*10,937 = 5,195.08
Equity value = EV - debt + cash = 5,195.08 - 3,710 + 415 = 1,900.08 (Answer)
(c).
Formula | Magnus | Autodei | Average | |
EV/Sales | 0.50 | 1.00 | 0.75 | |
VRT Sales | 10,937.00 | 10,937.00 | 10,937.00 | |
(EV/Sales multiple*Sales) | VRT EV | 5,468.50 | 10,937.00 | 8,202.75 |
Less: gross debt | -3,710.00 | -3,710.00 | -3,710.00 | |
Add: cash | 415.00 | 415.00 | 415.00 | |
VRT Equity | 2,173.50 | 7,642.00 | 4,907.75 |
VRT Equity value (using Magnus EV/Sales) = 2,173.50
VRT Equity value (using Autodei EV/Sales) = 7,642.00
VRT Equity value (using the average EV/Sales) = 4,907.75
Formula | Magnus | Autodei | Average | |
EV/EBIT | 8.00 | 13.00 | 10.5 | |
VRT EBIT | 557.00 | 557.00 | 557.00 | |
(EV/EBIT multiple*EBIT) | VRT EV | 4,456.00 | 7,241.00 | 5,848.50 |
Less: gross debt | -3,710.00 | -3,710.00 | -3,710.00 | |
Add: cash | 415.00 | 415.00 | 415.00 | |
VRT Equity | 1,161.00 | 3,946.00 | 2,553.50 |
VRT Equity value (using Magnus EV/EBIT) = 1,161.00
VRT Equity value (using Autodei EV/EBIT) = 3,946.00
VRT Equity value (using the average EV/EBIT) = 2,553.50
(d). The equity value calculated in part (b) is lower than the equity value calculated in part (c) mainly because of the effect of the legacy auto parts manufacturer's multiples. From the information provided, it appears that the legacy companies are running in losses (negative operating margins) while VRT is not. Including their multiples in calculating the equity value of VRT will skew the valuation.
(e). Compared to the equity value calculated in part (c), the IPO price of $823 million is quite low. This indicates that investors are not very confident about the future prospects of VRT and expect it to not perform favorably compared to its competitors, namely Autodei and Magnus.
Please help me do this if you know, thank you very much and please step by step that makes me bet...
Please help with 9.01 - 10.10 Thank you very much!!! Let me know if you need any more information. I See The Light Projected Income Statement For the Period Ending December 31, 20x1 $ 1,125,000.00 750,000.00 375,000.00 $ Sales 25,000 lamps @ $45.00 Cost of Goods Sold @ $30.00 Gross Profit Selling Expenses: Fixed Variable (Commission per unit) @ $3.00 Administrative Expenses: Fixed Variable @ $2.00 Total Selling and Administrative Expenses: Net Profit $ 23,000.00 75,000.00 $ 98,000.00 $ 42,000.00...
please see the problem and set it in the excel. please provide the formula in every cell in the excel so i understand how it is done. thank you very much. the last pic is what i did so far. so please refer to the problem and complete it with all formulas provided for me( for every cell) thank you! 2. Medina werks, a manufacturing company headquartered in Canada, has a competitive advantage that will probably deteriorate over time. analyst...
Please help me in both questions, thank you very much :) QUESTION 3 Ben is a musician who has just finished his degree in music technology. He is currently deciding whether or not to accept a job in Brisbane as a music teacher at a local school, or focus on being a touring musician. He ill earn a wage of $35,000/year as a teacher in Brisbane, and $25,000/year as a touring musician based in Melbourne. Rent is $10,000lyear in Brisbane,...
Please answer all questions and make answers very clear. Thank you so much and I will make sure to give a good rating!!! Use the information contained in these financial statements and notes to complete this case. All answers should be for the most current year (September 24, 2016) unless asked otherwise. Many companies show amounts in the thousands or millions please state amounts as shown on the financial statements. Do not add zeros. You do not need to include...
Slim Perkins, a business journalist, is a recent hire at his firm. Since he joined the firm, he has been following Facebook Inc.’s (FB) initial public offering (IPO) and the stock’s performance. His task is to estimate Facebook’s fair market value, also referred to as “intrinsic” value, and compare this value with the current stock price, and recommend a buy, sell, or hold rating to investors. Slim pulls the company’s consolidated financial statements to collect relevant data on the company’s...
please Help me!! Remaining Time: 3 hours, 11 minutes, 53 seconds. Question Completion Status: QUESTION 1 The following information is for Bright Eyes Auto Supplies: Bright Eyes Auto Supplies Balance Sheet December 31, 2015 $ 40,000 80,000 100,000 140,000 180,000 250.000 Accounts Payable Salaries and Wages Payable Mortgage Payable Total Liabilities Cash Prepaid Insurance Accounts Receivable Inventory Land Held for Investment Land Buildings $200,000 Less Accumulated Depreciation (60.000 Trademark Total Assets $ 130,000 50,000 150.000 330,000 Common Sock Retained Earnings...
Please use own words. Thank you. CASE QUESTIONS AND DISCUSSION > Analyze and discuss the questions listed below in specific detail. A minimum of 4 pages is required; ensure that you answer all questions completely Case Questions Who are the main players (name and position)? What business (es) and industry or industries is the company in? What are the issues and problems facing the company? (Sort them by importance and urgency.) What are the characteristics of the environment in which...
Please read case article, "Attention Kmart Shoppers? Into and out of Bankruptcy" and help me come up with a solution for the case as well as action steps to implement the solution! Thank you!! ATTENTION KMART SHOPPERS? Former Kmart CEO, Charles C. Conaway, failed in his 19-month effort to revive the iconic firm, resulting in the largest retailing bankruptcy filing in history on January 22, 2002 (Davies, et al., 2002). On March 11, 2002, bankrupt Kmart named James B. Adamson...