Question

1 Approved Answer

Posted on Jul 13, 2024

Question 19 10 pts What is the IRR of the ice cream expansion opportunity for Jack's Food Products? 17.20% 9.97% 13.18% 16.25% Question 20 10

Question 19 10 pts What is the IRR of the ice cream expansion opportunity for Jack's Food Products? 17.20% 9.97% 13.18% 16.25% Question 20 10 pts Based on the return characteristics of the ice cream expansion opportunity for Jack's Food Products, Jack should NOT invest the money to expand into ice cream production. True False x C D B E ACCS FOOD PRODUCTS Income Statement - Htorical and Proforma international Expansion CAGR Rent Salaries, Wages Ulities Other Total Operating Expenses Operating Profit $ $ $ 5 $ Historie Actual 2016 2017 325.000 225.000 $ 30340835 3.157.1995 177,565 1820545 521595 500,125 1465 4203.225 2.615.9265 21.5305 2018 225,000 5 3,200.1543 181.500 5 $42.999 4.817,73 3.36943 2019 240,000 $ 3450.000 385.000 570.000 5,1280005 2005 Proforma 2020 2021e 240,000 $ 20.000 3.500.000 3.650.000 190.000$ 390,000 $ 50,000 $ 620,000 $ 5,200,000 $ S421.000 3,990,000 $ 420.000 5 20 2022e 240.000 300.000 206,000 640.000 5.614 000 4486.000 5 NRERE ME NEW ME Non-Operating income (xpenses interest Pre Tax Net Income Taxes Net Income 5 5 294.000 5 2.331,0365 76,00 1.554813 2.000 2.500 510 $ 20.1225 1,7114383 240005 3.02545 675.149 2400,25 20,000 3.07.000 666,3305 2AL605 20.000 5 30.000 776.5805 2.92YA103 214.0005 4,025.000 147.1505 3,187 650S 294,000 4.192.000 $82,120 211.680 5 5 COITOA TERMINAL VALUE 2 4 5 Cash Flow From At Calculations Operating Cash Flow IOC Net Captur Spending Ending WC Beginning wc Chanesini Working Con CHA 3 + Discounted Cash Pow 2019 2022) WACKS FOOD PRODUCTS Balance Sheet Historical and Proforma 5 3 3 9 30 Ats Cash Accounts Receivable Inventory TotalCurrent Assets Net Fred Assets Total Assets $ $ 5 S Histork - Actual 2016 2017 54.365 1,179,7245 452,45 216.1415 1,623.0145 1459.774S 2.606,0275 2.8563395 2,9072545 3111954 56019315 5.06.2015 2013 15780155 312.004 1.662,122 $ 1.552.345 3,070219 6.622.60 2015e 0.036795$ 101.318 5 1599.3275 4017435 3.127.5935 7,165.028 Proforma 2020 2021e 2014675 2,134,6405 500,6715 593.1275 1.745.8215 1.799.400 5 4294495 4527,1675 3209765 2287,4035 7504.1735 7,814.5265 2022 2.207,126 604) 1A50,900 4,662,915 3,109,501 7612,456 $ 5 12 13 14 15 16 5 5 Liabilities Accounts Payable Accrued Liabilities TotalCurrent Labs Boods 16.25% Total Les 427.5035 17:25 1.215 2.500.000 5 2.914215 1241775 49000 05 2.500.000 $ 2.903.0775 5 5 300015 17067 170505 2.500.000 27050 412.90 24500 5 3749 2.300.000 2.9375 611155 667815 6779765 DOO 1.177.97015 SOS 8691 555225 2.500.0005 ROSS.223 5 01.500 60546 66,16 2.500.000 16 $ 10 19 20 21 22 23 24 25 26 3 Equity Preferred touty 18.35%) Commons Hatine une Total Buty 1.500.000 100.000 10310 2.6192103 1.500.000 10000 1459.216 2050216 1.500.000 100.000 2.1959105 1.950 1.500.000 1000005 2.6275303 4227530 1.500,000 100.000 249505 44.950 1.500.000 5 100 000 10366005 63,000 $ 0000051 000001 ORCE ON 5 C D G 129 20% 7.25% 1.000.000 1615 $ 1 KOKS FOCO PRODUCTS 2 WACC 3 4 5 Common fout Industry lieta Proxy for the Companya) 7 Current Rak- Free Rate Market Premium 9 Number of Common Equity Shares Outstanding 10 Current Price Per Common Coulty Share Total Value of Common Louity 12 Expected Equity Return for cost of equity capital Preferred Euty 14 Cost of Preferred Equity 15 Totul Value of Preferred Equity 16 17 Current Bond Velvetperbond) 18 Total Bonds Cost of Debt Bonds 10 21 WARGAS 22 Total Values 23 Weght of Community 24 Weight of Puered Couty 25 Weight of Bones HUN 2.500.000 3 55. Stopar a bond both 1.500 bon. Con esto matury, 5. The the We Cost of Capital DOON AN 27 28 29 10 31 JO Com ABIVA Uw wine from the come statement 13 OOD PRODUCIS Ice Cream Opportunity 2 3 4 TERMINAL VALUE 5 6 7 8 9 10 Revenue COGS Gross Margin Increase in Advertising and Marketing Increase in Saarles & Wapes Increase in Utilities Increase in Other Expenses Tax Effect of Depreciation on Capbx Capital Cost of New quloment CITA 2019 $ 500,000 $ $ 125,000 $ $ 375,000 $ $ 145,000) $ (120,000) $ $ 19,000) 5 $ 17,000) $ S 195,000 $ $ 16,500,000) 5 $ 10,111,000) 2020 1.250.000 5 312,500 $ 937.500 5 (50,000) (160,000) (13,000) $ 17.000) 195,000 $ 3 902,500 $ 2021 1.500,000 $ 375,000 $ 1.125,000 $ (55,000) S (170,000) (14,500) 17.000) $ 195.000 5 1,073,500 5 2022 1,750,000 437,500 1.312,500 (60,000) (180,000) (16,000) 17.000) 195,000 11 12 13 1,244,500 5 6,844,750 15 16 17 NPV IRR 19 20 21 D G I JACK'S FOOD PRODUCTS Toggles and Assumptions 1 2. 3 4 5 6 7 3 9 10 11 Increased Revenue from Ice Cream Business Increased COGS from Ice Cream Business Increase in Advertising and Marketing increase in Salaries & Wages Increase in Uttes Increase in Other Expenses Capital Cost of New Equipment Depreciation of New Equipment (assuming 7 Year SL) Assume Tax Rate Terminal Multiple $ $ $ $ $ 5 $ $ 2019 500.000 125,000 $ 45.000 120,000 $ 9.000 $ 7.000 $ 550.000 9255715 21% 5.5 2020 1.250,000 $ 312,500 5 50.0005 160,000 S 13,000 $ 7.000 $ 2021 1.SOODOO 5 375,000 $ 55.000$ 170,000 $ 34.500 5 7.000 5 2022 1,750.000 437.500 60,000 180,000 16,000 7.000 12 928.5715 928,5715 928,571 14 15 16 CES FOOD PRODUCTS stios Historic-Actua 2017 2021 2016 2018 2000 2015e 644 56 2022 625 SH 5652 NA 55.90 Key Ratios vertory Turnover ventory Period cevables Travel Becevables Period Operating Cycle NA NA 37 2. 3314 NA 25.15 Payables Tumove Payu Period Cash Cycle 5037 NA 5201 Question 19 10 pts What is the IRR of the ice cream expansion opportunity for Jack's Food Products? 17.20% 9.97% 13.18% 16.25% Question 20 10 pts Based on the return characteristics of the ice cream expansion opportunity for Jack's Food Products, Jack should NOT invest the money to expand into ice cream production. True False x C D B E ACCS FOOD PRODUCTS Income Statement - Htorical and Proforma international Expansion CAGR Rent Salaries, Wages Ulities Other Total Operating Expenses Operating Profit $ $ $ 5 $ Historie Actual 2016 2017 325.000 225.000 $ 30340835 3.157.1995 177,565 1820545 521595 500,125 1465 4203.225 2.615.9265 21.5305 2018 225,000 5 3,200.1543 181.500 5 $42.999 4.817,73 3.36943 2019 240,000 $ 3450.000 385.000 570.000 5,1280005 2005 Proforma 2020 2021e 240,000 $ 20.000 3.500.000 3.650.000 190.000$ 390,000 $ 50,000 $ 620,000 $ 5,200,000 $ S421.000 3,990,000 $ 420.000 5 20 2022e 240.000 300.000 206,000 640.000 5.614 000 4486.000 5 NRERE ME NEW ME Non-Operating income (xpenses interest Pre Tax Net Income Taxes Net Income 5 5 294.000 5 2.331,0365 76,00 1.554813 2.000 2.500 510 $ 20.1225 1,7114383 240005 3.02545 675.149 2400,25 20,000 3.07.000 666,3305 2AL605 20.000 5 30.000 776.5805 2.92YA103 214.0005 4,025.000 147.1505 3,187 650S 294,000 4.192.000 $82,120 211.680 5 5 COITOA TERMINAL VALUE 2 4 5 Cash Flow From At Calculations Operating Cash Flow IOC Net Captur Spending Ending WC Beginning wc Chanesini Working Con CHA 3 + Discounted Cash Pow 2019 2022) WACKS FOOD PRODUCTS Balance Sheet Historical and Proforma 5 3 3 9 30 Ats Cash Accounts Receivable Inventory TotalCurrent Assets Net Fred Assets Total Assets $ $ 5 S Histork - Actual 2016 2017 54.365 1,179,7245 452,45 216.1415 1,623.0145 1459.774S 2.606,0275 2.8563395 2,9072545 3111954 56019315 5.06.2015 2013 15780155 312.004 1.662,122 $ 1.552.345 3,070219 6.622.60 2015e 0.036795$ 101.318 5 1599.3275 4017435 3.127.5935 7,165.028 Proforma 2020 2021e 2014675 2,134,6405 500,6715 593.1275 1.745.8215 1.799.400 5 4294495 4527,1675 3209765 2287,4035 7504.1735 7,814.5265 2022 2.207,126 604) 1A50,900 4,662,915 3,109,501 7612,456 $ 5 12 13 14 15 16 5 5 Liabilities Accounts Payable Accrued Liabilities TotalCurrent Labs Boods 16.25% Total Les 427.5035 17:25 1.215 2.500.000 5 2.914215 1241775 49000 05 2.500.000 $ 2.903.0775 5 5 300015 17067 170505 2.500.000 27050 412.90 24500 5 3749 2.300.000 2.9375 611155 667815 6779765 DOO 1.177.97015 SOS 8691 555225 2.500.0005 ROSS.223 5 01.500 60546 66,16 2.500.000 16 $ 10 19 20 21 22 23 24 25 26 3 Equity Preferred touty 18.35%) Commons Hatine une Total Buty 1.500.000 100.000 10310 2.6192103 1.500.000 10000 1459.216 2050216 1.500.000 100.000 2.1959105 1.950 1.500.000 1000005 2.6275303 4227530 1.500,000 100.000 249505 44.950 1.500.000 5 100 000 10366005 63,000 $ 0000051 000001 ORCE ON 5 C D G 129 20% 7.25% 1.000.000 1615 $ 1 KOKS FOCO PRODUCTS 2 WACC 3 4 5 Common fout Industry lieta Proxy for the Companya) 7 Current Rak- Free Rate Market Premium 9 Number of Common Equity Shares Outstanding 10 Current Price Per Common Coulty Share Total Value of Common Louity 12 Expected Equity Return for cost of equity capital Preferred Euty 14 Cost of Preferred Equity 15 Totul Value of Preferred Equity 16 17 Current Bond Velvetperbond) 18 Total Bonds Cost of Debt Bonds 10 21 WARGAS 22 Total Values 23 Weght of Community 24 Weight of Puered Couty 25 Weight of Bones HUN 2.500.000 3 55. Stopar a bond both 1.500 bon. Con esto matury, 5. The the We Cost of Capital DOON AN 27 28 29 10 31 JO Com ABIVA Uw wine from the come statement 13 OOD PRODUCIS Ice Cream Opportunity 2 3 4 TERMINAL VALUE 5 6 7 8 9 10 Revenue COGS Gross Margin Increase in Advertising and Marketing Increase in Saarles & Wapes Increase in Utilities Increase in Other Expenses Tax Effect of Depreciation on Capbx Capital Cost of New quloment CITA 2019 $ 500,000 $ $ 125,000 $ $ 375,000 $ $ 145,000) $ (120,000) $ $ 19,000) 5 $ 17,000) $ S 195,000 $ $ 16,500,000) 5 $ 10,111,000) 2020 1.250.000 5 312,500 $ 937.500 5 (50,000) (160,000) (13,000) $ 17.000) 195,000 $ 3 902,500 $ 2021 1.500,000 $ 375,000 $ 1.125,000 $ (55,000) S (170,000) (14,500) 17.000) $ 195.000 5 1,073,500 5 2022 1,750,000 437,500 1.312,500 (60,000) (180,000) (16,000) 17.000) 195,000 11 12 13 1,244,500 5 6,844,750 15 16 17 NPV IRR 19 20 21 D G I JACK'S FOOD PRODUCTS Toggles and Assumptions 1 2. 3 4 5 6 7 3 9 10 11 Increased Revenue from Ice Cream Business Increased COGS from Ice Cream Business Increase in Advertising and Marketing increase in Salaries & Wages Increase in Uttes Increase in Other Expenses Capital Cost of New Equipment Depreciation of New Equipment (assuming 7 Year SL) Assume Tax Rate Terminal Multiple $ $ $ $ $ 5 $ $ 2019 500.000 125,000 $ 45.000 120,000 $ 9.000 $ 7.000 $ 550.000 9255715 21% 5.5 2020 1.250,000 $ 312,500 5 50.0005 160,000 S 13,000 $ 7.000 $ 2021 1.SOODOO 5 375,000 $ 55.000$ 170,000 $ 34.500 5 7.000 5 2022 1,750.000 437.500 60,000 180,000 16,000 7.000 12 928.5715 928,5715 928,571 14 15 16 CES FOOD PRODUCTS stios Historic-Actua 2017 2021 2016 2018 2000 2015e 644 56 2022 625 SH 5652 NA 55.90 Key Ratios vertory Turnover ventory Period cevables Travel Becevables Period Operating Cycle NA NA 37 2. 3314 NA 25.15 Payables Tumove Payu Period Cash Cycle 5037 NA 5201