Problem 1: In the Excel file provided, you find pro-forma income statements and the current and pro- forma balance sheets for the company Beer in a Box, which delivers brewery home kits for beer home production. Beer in a Box is a relatively young company in a very mature industry. Use the information below and the flow to equity valuation method (discounting the pseudo dividend at the cost of equity) estimate the value of the venture. Assume a cost of equity of 20% for the first three years of forecasting and a cost of equity of 6% for cash flows shareholders receive starting in year 2022, which will be constant without growth in the future. Proforma Income Statements USD in thousands (for the year ending) Sales Cost of goods sold Gross profit Operating expenses (excluding depreciation) Depreciation expense Operating income (EBIT) Interest expense Earnings before taxes Taxes Net income 2019 2018 2022 $56,000.00 $62,720.00 $70,246.40 $70,246.40 22,400.00 $25,088.00 $28,098.56 $28,098.56 $33,600.00 37,632.00 $42,147.84 42,14784 $16,800.00 $18,816.00 $21,073.92 $21,073.92 $ 4,000.00 4,240.00 4,508.80 4,809.86 $12,800.00 $14,576.00 $16,565.12 $16,264.06 1,000.00 1,400.00 1,568.00 1,756.16 $11,800.00 $13,176.00 $14,997.12 $14,507.90 3,540.00 3,952.80 4,499.14 $ 4,352.37 $8,260.00 9223.20 $10,497.98 $10,155.53 2020 2021 Balance Sheet USD in thousands (at the end of the year) Current assets Property, plant, and equipment Total assets 2022 7,500.00 8,400.00 $ 9,408.00 $10,536.96 $10,536.96 $20,000.00 $22,400.00 $25,088.00 $28,098.56 $28,098.56 $27,500.00 $30,800.00 $34,496.00 $38,635.52 $38,635.52 2018 2019 2020 2021 2,500.00 2,800.00 3,136.00 3,512.32 3,512.32 $10,000.00 $14,000.00 $15,680.00 $17,561.60 $17,561.60 15,000.00 $14,000.00 $15,680.00 $17,561.60 $17,561.60 $27,500.00 $30,800.00 $34,496.00 $38,635.52 $38,635.52 Accruals and payables Long term debt Equity Total liabilities and equity Problem 1: In the Excel file provided, you find pro-forma income statements and the current and pro- forma balance sheets for the company Beer in a Box, which delivers brewery home kits for beer home production. Beer in a Box is a relatively young company in a very mature industry. Use the information below and the flow to equity valuation method (discounting the pseudo dividend at the cost of equity) estimate the value of the venture. Assume a cost of equity of 20% for the first three years of forecasting and a cost of equity of 6% for cash flows shareholders receive starting in year 2022, which will be constant without growth in the future. Proforma Income Statements USD in thousands (for the year ending) Sales Cost of goods sold Gross profit Operating expenses (excluding depreciation) Depreciation expense Operating income (EBIT) Interest expense Earnings before taxes Taxes Net income 2019 2018 2022 $56,000.00 $62,720.00 $70,246.40 $70,246.40 22,400.00 $25,088.00 $28,098.56 $28,098.56 $33,600.00 37,632.00 $42,147.84 42,14784 $16,800.00 $18,816.00 $21,073.92 $21,073.92 $ 4,000.00 4,240.00 4,508.80 4,809.86 $12,800.00 $14,576.00 $16,565.12 $16,264.06 1,000.00 1,400.00 1,568.00 1,756.16 $11,800.00 $13,176.00 $14,997.12 $14,507.90 3,540.00 3,952.80 4,499.14 $ 4,352.37 $8,260.00 9223.20 $10,497.98 $10,155.53 2020 2021 Balance Sheet USD in thousands (at the end of the year) Current assets Property, plant, and equipment Total assets 2022 7,500.00 8,400.00 $ 9,408.00 $10,536.96 $10,536.96 $20,000.00 $22,400.00 $25,088.00 $28,098.56 $28,098.56 $27,500.00 $30,800.00 $34,496.00 $38,635.52 $38,635.52 2018 2019 2020 2021 2,500.00 2,800.00 3,136.00 3,512.32 3,512.32 $10,000.00 $14,000.00 $15,680.00 $17,561.60 $17,561.60 15,000.00 $14,000.00 $15,680.00 $17,561.60 $17,561.60 $27,500.00 $30,800.00 $34,496.00 $38,635.52 $38,635.52 Accruals and payables Long term debt Equity Total liabilities and equity