- B C G D E F H 1 Note Please See The Forecast Dcf Sheet For Current Financial Statement Information Of Company A 2 3 B 1 (64.68 KiB) Viewed 20 times
- B C G D E F H 1 Note Please See The Forecast Dcf Sheet For Current Financial Statement Information Of Company A 2 3 B 2 (59.76 KiB) Viewed 20 times
- B C G D E F H 1 Note Please See The Forecast Dcf Sheet For Current Financial Statement Information Of Company A 2 3 B 3 (58.62 KiB) Viewed 20 times
- B C G D E F H 1 Note Please See The Forecast Dcf Sheet For Current Financial Statement Information Of Company A 2 3 B 4 (49.97 KiB) Viewed 20 times
- B C G D E F H 1 Note Please See The Forecast Dcf Sheet For Current Financial Statement Information Of Company A 2 3 B 5 (49.97 KiB) Viewed 20 times
- B C G D E F H 1 Note Please See The Forecast Dcf Sheet For Current Financial Statement Information Of Company A 2 3 B 6 (45.59 KiB) Viewed 20 times
- B C G D E F H 1 Note Please See The Forecast Dcf Sheet For Current Financial Statement Information Of Company A 2 3 B 7 (49.12 KiB) Viewed 20 times
10 Cash and marketable securities 11 Accounts receivable evene 12 Inventory evenue 13 Fixed ass growth mie 14 Shon-derm bomowings mense 15 Accounts payable evene 16 Other accred liabilities/reverse 17 Longdom Deb 18 Common stocks 19 Tax 20 21 Year 22 Revenue 23 Cost of Goods Sold 24 Depreciation 25 Other operating expe 26 Famings before interest and taxes (EBIT) 27 Interest expense 28 Interest income 29 Eamings before us (BT) 30 Taxes 31 Net Eamings 32 Dividends 33 Retained Famnings 34 35 Cash and marketable secunces 36 Accounts receivable 37 laventory 38 Total Cument Ass 39 Fixed assets, al cost 40 Accumulated depreciation 41 Net Fixed Assets 42 Total Assets 43 44 Shon-tcm bomwings (intest-bearing) 45 Accounts payable 46 Other accrund liabilities 47 Total Current Liabilities 48 Long-tem Debt (interest-bearing) 49 Cennes stocks 50 Retained Bamings $1 Total Liabilities and Equity 52 53 54 55 Free Cash Flows Calculation 56 WACC 57 Teminal Crowth Rate 58 59 Year 60 Mid-Year 61 EBIT 62 Taxes 63 NOPAT 64 Depreciation 65 Change in pon-cash current assets 66 Change in non-interest coment liabilities 67 Change in fixed assets ( cost) 68 Free Cash Flow 69 Terminal Value 70 Total 71 Present Valac Factor (based on Mid-Year) 72 Present Value 73 74 Extimaned Valie of Operating Ass 75 Cash and meuble secti 76 All interest-bearing debt 77 Eate Equity Value 78 79 80 81 82 83 WACC Balance sheet plag 4.00% Aconte As constet 21.00% 0 31,904 01231) 0,936) (9,765) 4,972 0,120) 1,042 4,594 (1028) 3,366 (630) 3,236 24.070 15,425 14316 53,811 49,799 (15,761) 34,038 $7,849 2,201 4,252 5,035 11,4 26,661 23,853 25,847 87,849 3.50% Please use the WACC calocated in the "WACC" sheet 0.5 15 2.5 3.5 Multiples + Forecast DCF
с D E F G 1 Note: Please see the "Forecast DCF" sheet for current financial statement information of Company A 2 Market Value of Cash Equity Market Value of Debt Revenue EBITDA Value of Operating Assets 57,870 7,875 13,679 19,732 4,805 Competitor 1 Competitor 2 68,873 6,872 18,904 25,962 5,903 Competitor 3 43,821 5,881 11,067 14,321 3,972 78,536 9,369 21,084 28,437 6,803 Competitor 4 Competitor 5 98,734 10,413 26,583 36,452 8,972 0 Average 1 2 Company A amount (Revenue and EBITDA) Company A Estimated Value of Operating Assets 4 Average Estiamted Value of Operating Assets Cash and marketable securities All interest-bearing debt Esimated Equity Value WACC Ready Forecast DCF Multiples + H Value of Operating Assets/Rev. Value of Operating Assets/EBITDA
1992 C ... Auten Home insert Draw Page Layout Formulas Data Review View Tell me 11 X 1. Call(Body) BTU + Á A AM Pa Merge Center 120 A D D G 1 Note: Please see the "Ferecast DCF" sheet for current financial statement information of Company A Book price per share 145 78.5 Market price per share 21% 1.75% Market risk premium 5.60% 6 Tax rate 7 Risk-free rate 9 Borrowing rate 10 Debt 11 Market cap 12 Beta 13 Cost of equity 14 Weight of debe 15 Weight of equity 16 WACC 17 18 19 Information for the competitor 20 21 Competitor 22 Competitor 2 23 Competitor 24 Competitor 4 25 Competitor 5 26 27 The Company AS DE 28 Equity Beta WADO Ready Part B Corporate Valuation Template General 18.3 Market Value Market Value Equity of Debe of Equity Beta $57,870 $13.679 1.39 568,873 $18.904 1.37 $43,821 $11,067 141 $78,536 $21,084 1.64 598,734 $26,583 1.48 Mes Cenderal For Cest Farming is Tore Styles H Please use the "Interest rate on all interess-bearing debe" from Forecast DCF sheet Please use total interest-bearing debt (Year 0) from "Forecast DCF" sheet Please use the following information (Information for the competitors) to estimate beta DE Asset Bets Average: sert Dete For L M fo Fiter N FINES Select Share A 0 Deta af Comments 140% a
Auten 1992 C Home insert Draw Page Layout Formulas Data Review View Tell me B Times New Roman - 11 *. + Á A X 1. Paste BT G16 NFT DKP sheet for fals inter of Company A Ma Va Market Vake of Equity C FRIDA D 1475 11,474 18712 4,300 C5,474 Compet 8,473 672 5, 43,821 11,367 16,384 25.962 5.500 14321 3,972 2KAST 400 Camp Cres 185 9.30 21,344 8,734 3610 MALL Avg Com (evensend EBITDA) Company Ad Vike of Operating A Avage Et Vilas of Open Cash and marke Ang dib WWOO Ready Part B Corporate Valuation Template General Vake of O FDCF Text- Vakif ATA Cenderal Format Cest Formnings Tote Styles vert Delete Format 。 fort Fiter FINES Select Share Anal af Comments 100%
Auten 1992 C Home insert Draw Page Layout Times New Roman <- 11 B X 1. Paste BIU Ready WADO onir Formulas Data Review A A A.M Persek kali AN L A DOF Muitges Part B Corporate Valuation Template Percentage 782 View Tell me Text Merge Center Cest Cenderal Forma Formnings Tote Styles sert Dete For Σ. ma Share FINES Ana fo Fiter Select af Comments