Answered step by step
Verified Expert Solution
Question
1 Approved Answer
i need this ASAP!! fill out the yellow squares Enter your enterprise value here: Mike's Distillery, Inc. Financial Statements Lovas in was Forecast Forecast 7
i need this ASAP!! fill out the yellow squares
Enter your enterprise value here: Mike's Distillery, Inc. Financial Statements Lovas in was Forecast Forecast 7 1791 Year: Revenue EBITDA Operating Income (EBIT) Pre-Tax Income (EBT) Net Income Historical n 1,350 650 513 500 395 Forecast 1 1,500 720 570 554 438 Forecast 2 1,545 737 587 568 449 Forecast 3 1,591 755 605 582 460 1,639 773 623 597 472 Forecast 5 1,688 792 642 613 484 Forecast 6 1,739 811 661 629 497 831 681 645 510 378 776 Balance Sheet Cash Net Working Capital Net Fixed Assets Total Assets 225 240 75 100 2,500 2.675 1,176 290 2.675 4,141 1,553 350 2.750 4,653 1.927 400 2,850 5.177 2,304 460 2.950 5,714 2,550 3,153 2,689 525 3,050 6,264 2,625 3,641 Line of Credit Total Debt 200 200 240 240 280 280 320 320 360 360 400 400 440 440 480 480 Total Equity 2,475 2.913 3,361 3,821 4,293 4,777 5,274 5,784 Total Liabilities & Equity 2,675 3,153 3,641 4,141 4,653 5,177 5,714 6.264 Interest Expense Total Interest Expense Cost of Debt (Rd) 0 0 0 Cash Flow 0 1 2 3 4 5 6 7 Enter your enterprise value here: Mike's Distillery, Inc. Comparable Companies Analysis Dollars in Millions Company Revenue EBITDA Net Inc FCF EBITDA % NI % FCF % Mkt Cap Net Debt Tax Rate D/E Asset Beta EV Armchair Liquors Beaubien Booze Cass Spirits 800 625 425 575 385 150 300 245 95 125 9 5 72 72% 62% 35% 38% 39% 22% 16% 15% 17% $1.997 $2.676 $1,150 $1,210 $143 $490 Levered Beta 1.99 1.32 1.43 21% 21% 21% 0.61 0.05 0.43 3207 2819 1640 EVI EV/ Revenue EBITDA 4.0x 5.6x 4.5x 7.3x 3.9x 10.9x Mike's Distillery | $1,350 $650 $395 $260 48% 29% 19% $125 21% 0 4 .1x 7.9x Metric Multiple EV DA Mike's Distillery Revenue EBITDA FCF bL Re Rd Tax Rate Average: 21% E/ WACC 7 831 80 150 Les Funds Purchase Price Transaction Fees 15.200 PURCHASE TRANSACTION Sources e Funds Senior Debe $1.950 SubDebe 1300 Equity Check Total Assumptions Purchase Multiple E Muinple Senior Debt Meltiple Sub DobeMaple Transaction Fees Tax Rate 30 20k Cash Flow Schedu EBITDA Depreciation EBIT Senior Interest Sub Interest EBT Tanes Net Income Depreciation -Caper Increase in NWC (122) (124) 83883" 1821 Total 15.252 573 681 0 1241 657 (1381 519 150 21% 38 88382883 (122) 457 6.25% SALE TRANSACTION Sources Funds Sale Price 150 Senior Debt APR Senior Debt Amort Sub Debt APR 150 Urolunds Serior Debt Sub Debt Transwotion Fees Sponsor Return Total FCF Year OPF EBITDA 650 Slee 1231 . . -Senior Principal Adjusted FCF -Senior Paydown Pemaining FCF Sub Paudown FinalFCF -Cash to Equity (176) 0 Sleeloooo 607 0 607 0 0 607 689 (439) (607) (253) 0 415 00415 IRRUNUM OOO OSS 0 NO DEBT SCHEDULES Swi Date Beginning Balance Required Payment EaPayments Ending Balance 0195001544 01.104 1231 (245) (260) (176) (195) (215) 1154401 1041 628 1 14 (277 (114) (237) 011410 30 30 00 30 30 1300 1300 1300 1300 1300 Subaruha Dude Begiving Balance Pwdown Ending Bence 061 1807 30 10000 361 333 H Enter your Enterprise Value here: Mike's Distillery, Inc. VC Method Analysis Dolars in lines Exit Value Calculation VC Discount Rate Calculation Metric Multiple Investor Discount Rate Risk of Failure 12% 1096 - Revenue EBITDA FCF VC Discount Rate: 2 AVERAGE EXIT VALUE - VC Method Calculation 5 Exit Value M 5 Time to Exit 7 Discount Rate 3 Amount of Investment of Current Shares 0% 175 1,000 1 Post Money Value 2 Pre-Money Value 3 Ownership % 4 Shares to be sold 5 Share Price Enter your enterprise value here: Mike's Distillery, Inc. Financial Statements Lovas in was Forecast Forecast 7 1791 Year: Revenue EBITDA Operating Income (EBIT) Pre-Tax Income (EBT) Net Income Historical n 1,350 650 513 500 395 Forecast 1 1,500 720 570 554 438 Forecast 2 1,545 737 587 568 449 Forecast 3 1,591 755 605 582 460 1,639 773 623 597 472 Forecast 5 1,688 792 642 613 484 Forecast 6 1,739 811 661 629 497 831 681 645 510 378 776 Balance Sheet Cash Net Working Capital Net Fixed Assets Total Assets 225 240 75 100 2,500 2.675 1,176 290 2.675 4,141 1,553 350 2.750 4,653 1.927 400 2,850 5.177 2,304 460 2.950 5,714 2,550 3,153 2,689 525 3,050 6,264 2,625 3,641 Line of Credit Total Debt 200 200 240 240 280 280 320 320 360 360 400 400 440 440 480 480 Total Equity 2,475 2.913 3,361 3,821 4,293 4,777 5,274 5,784 Total Liabilities & Equity 2,675 3,153 3,641 4,141 4,653 5,177 5,714 6.264 Interest Expense Total Interest Expense Cost of Debt (Rd) 0 0 0 Cash Flow 0 1 2 3 4 5 6 7 Enter your enterprise value here: Mike's Distillery, Inc. Comparable Companies Analysis Dollars in Millions Company Revenue EBITDA Net Inc FCF EBITDA % NI % FCF % Mkt Cap Net Debt Tax Rate D/E Asset Beta EV Armchair Liquors Beaubien Booze Cass Spirits 800 625 425 575 385 150 300 245 95 125 9 5 72 72% 62% 35% 38% 39% 22% 16% 15% 17% $1.997 $2.676 $1,150 $1,210 $143 $490 Levered Beta 1.99 1.32 1.43 21% 21% 21% 0.61 0.05 0.43 3207 2819 1640 EVI EV/ Revenue EBITDA 4.0x 5.6x 4.5x 7.3x 3.9x 10.9x Mike's Distillery | $1,350 $650 $395 $260 48% 29% 19% $125 21% 0 4 .1x 7.9x Metric Multiple EV DA Mike's Distillery Revenue EBITDA FCF bL Re Rd Tax Rate Average: 21% E/ WACC 7 831 80 150 Les Funds Purchase Price Transaction Fees 15.200 PURCHASE TRANSACTION Sources e Funds Senior Debe $1.950 SubDebe 1300 Equity Check Total Assumptions Purchase Multiple E Muinple Senior Debt Meltiple Sub DobeMaple Transaction Fees Tax Rate 30 20k Cash Flow Schedu EBITDA Depreciation EBIT Senior Interest Sub Interest EBT Tanes Net Income Depreciation -Caper Increase in NWC (122) (124) 83883" 1821 Total 15.252 573 681 0 1241 657 (1381 519 150 21% 38 88382883 (122) 457 6.25% SALE TRANSACTION Sources Funds Sale Price 150 Senior Debt APR Senior Debt Amort Sub Debt APR 150 Urolunds Serior Debt Sub Debt Transwotion Fees Sponsor Return Total FCF Year OPF EBITDA 650 Slee 1231 . . -Senior Principal Adjusted FCF -Senior Paydown Pemaining FCF Sub Paudown FinalFCF -Cash to Equity (176) 0 Sleeloooo 607 0 607 0 0 607 689 (439) (607) (253) 0 415 00415 IRRUNUM OOO OSS 0 NO DEBT SCHEDULES Swi Date Beginning Balance Required Payment EaPayments Ending Balance 0195001544 01.104 1231 (245) (260) (176) (195) (215) 1154401 1041 628 1 14 (277 (114) (237) 011410 30 30 00 30 30 1300 1300 1300 1300 1300 Subaruha Dude Begiving Balance Pwdown Ending Bence 061 1807 30 10000 361 333 H Enter your Enterprise Value here: Mike's Distillery, Inc. VC Method Analysis Dolars in lines Exit Value Calculation VC Discount Rate Calculation Metric Multiple Investor Discount Rate Risk of Failure 12% 1096 - Revenue EBITDA FCF VC Discount Rate: 2 AVERAGE EXIT VALUE - VC Method Calculation 5 Exit Value M 5 Time to Exit 7 Discount Rate 3 Amount of Investment of Current Shares 0% 175 1,000 1 Post Money Value 2 Pre-Money Value 3 Ownership % 4 Shares to be sold 5 Share PriceStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started