We are learning multiples in my finance class. Please solve this by giving the formulas to each highlighted components, and the items on financial statements I will have to reference to solve this on my own. I am not really looking for a numerical answer, moreso the formulas that go into each component. Thanks
A B D E F G H J K L M N o 32 Intrinsic Value of Equity Estimated Stock Price 784,065 46.95 33 $ 34 35 M-2 Multiples Model 36 Market Data Valuation 37 Price/shr V/EBITDA P/E V/Sales 3.8 38 9.6 15.2 39 $ $ S 1.7 9.0 Financial Data EV (SM) Sales (SM) EBITDA (SM) Earnings (SM) 275,190.00 $ 72,824.00 $ 28,682.00 $ 16,158.00 253,610.00 $ 149,166.00 $ 28,238.00 $ 16,416.00 65,480.00 $ 23,814.00 S 6,072.00 $ 2,988.00 49,840.00 $ 9,560.00 $ 3,480.00 $ 2,892.00 4,020.00 $ 2,144.00 $ 518.00 $ 348.00 13.2 Mcap (SM) 246,220.00 S 217,090.00 $ 51,100.00 $ 50,740.00 $ 4,170.00 $ 57.26 $ 157.94 $ 35.51 $ 95.18 $ 45.46 $ 40 Blue Bay Glass Green Grove Panels Shiny Trinkets Inc Blinding Lights Co. Earthy Tinting Average 2.7 10.8 17.1 41 S 5.2 17.5 14.3 7.8 42 $ 1.9 12.0 43 3.1 10.3 15.0 44 45 Alcove $ 18.15 46 47 48 V/Sales Estimated Value: Estimated Value Intrinsic Value of Equity Estimated Stock Price 49 50 51 52 53 V/EBITDA Estimated Value: Estimated Value Intrinsic Value of Equity Estimated Stock Price 54 55 56 57 58 P/E Estimated Value: Estimated Value Estimated Stock Price 59 60 61 A B D E F G H J K L M N o 32 Intrinsic Value of Equity Estimated Stock Price 784,065 46.95 33 $ 34 35 M-2 Multiples Model 36 Market Data Valuation 37 Price/shr V/EBITDA P/E V/Sales 3.8 38 9.6 15.2 39 $ $ S 1.7 9.0 Financial Data EV (SM) Sales (SM) EBITDA (SM) Earnings (SM) 275,190.00 $ 72,824.00 $ 28,682.00 $ 16,158.00 253,610.00 $ 149,166.00 $ 28,238.00 $ 16,416.00 65,480.00 $ 23,814.00 S 6,072.00 $ 2,988.00 49,840.00 $ 9,560.00 $ 3,480.00 $ 2,892.00 4,020.00 $ 2,144.00 $ 518.00 $ 348.00 13.2 Mcap (SM) 246,220.00 S 217,090.00 $ 51,100.00 $ 50,740.00 $ 4,170.00 $ 57.26 $ 157.94 $ 35.51 $ 95.18 $ 45.46 $ 40 Blue Bay Glass Green Grove Panels Shiny Trinkets Inc Blinding Lights Co. Earthy Tinting Average 2.7 10.8 17.1 41 S 5.2 17.5 14.3 7.8 42 $ 1.9 12.0 43 3.1 10.3 15.0 44 45 Alcove $ 18.15 46 47 48 V/Sales Estimated Value: Estimated Value Intrinsic Value of Equity Estimated Stock Price 49 50 51 52 53 V/EBITDA Estimated Value: Estimated Value Intrinsic Value of Equity Estimated Stock Price 54 55 56 57 58 P/E Estimated Value: Estimated Value Estimated Stock Price 59 60 61
