2. Calculate the NATCF series, and find the NPV of each investment using the WACC as the discount rate. (50 pts.)

Question 1 WACC Calculations DIA EIA rdebt requity tax rate WACC 0.700 0.300 6% 40% 25% Question 2, 3, and 4 Microbrewery Kitchen Other Cash Effects Inflows Outflows Year Depreciation Loan Pavment Loan Interest Taxable Income NATCF (microbrew) Taxes Other Cash Effects Year Outflows Inflows NATCF (kitchen) Depreciation Loan Pavment Loan Interest Taxable Income Taxes OOO OO AWN Year NATCF | PV Factor PV P V outflows FV Factor FV inflows Year NATCF P V Factor PV P V outflows FV Factor FV inflows COCOU AWNO COWN NPV NPV IRR IRR MIRR MIRR Question 5 Type your answer here Question 6 Type your answer here You currently own and operate a bar in Chicago called the Big Tap. Up until now you have only served beer and hard alcohol to your customers (no food), and all liquor served has been purchased through a distributor. Business has been good, but you have just bought and moved into a new building and are looking to further expand the bar's business. The new building you are now located in has more space than the bar's previous location and the basement of the new building is currently unfinished. You have come up with two different investment possibilities: Investment Alternative 1: Microbrewery Renovate the basement into a microbrewery and begin brewing your own beer for sale at the bar. Investment Alternative 2: Kitchen Renovate the basement into a kitchen and begin to serve a full menu of food at the bar. Information: You have estimated that both projects will require an initial investment of $100,000 for renovations and new equipment purchases. You have found a local bank that will lend 70% of the initial investment, financed over 5 years at 6% per year. You can assume that the entire initial investment will be depreciated using the straight-line method over a 10-year period. You expect both investments to generate additional revenues of $50,000 and additional expenses of $32,000 in the first year. Both the revenues and expenses directly related to the new investments are expected to grow at a rate of 2% each year. Effects on other sales: If you decide to go with the microbrewery and start selling your own beer, you expect sales of other beverages to decline by $3000 in the first year. This loss in sales is expected to grow at a rate of 1% each year. If you decide on the kitchen investment and start serving food, you expect beverage sales to increase by $3000 in the first year. This gain in beverage sales is expected to grow at a rate of 1% each year. Other information you might need: Big Tap - Financial Information D/A Interest rate on debt (rdebt) Required rate of return on equity (reguity) | Marginal Tax Rate 0.70 6% 40% 25% Question 1 WACC Calculations DIA EIA rdebt requity tax rate WACC 0.700 0.300 6% 40% 25% Question 2, 3, and 4 Microbrewery Kitchen Other Cash Effects Inflows Outflows Year Depreciation Loan Pavment Loan Interest Taxable Income NATCF (microbrew) Taxes Other Cash Effects Year Outflows Inflows NATCF (kitchen) Depreciation Loan Pavment Loan Interest Taxable Income Taxes OOO OO AWN Year NATCF | PV Factor PV P V outflows FV Factor FV inflows Year NATCF P V Factor PV P V outflows FV Factor FV inflows COCOU AWNO COWN NPV NPV IRR IRR MIRR MIRR Question 5 Type your answer here Question 6 Type your answer here You currently own and operate a bar in Chicago called the Big Tap. Up until now you have only served beer and hard alcohol to your customers (no food), and all liquor served has been purchased through a distributor. Business has been good, but you have just bought and moved into a new building and are looking to further expand the bar's business. The new building you are now located in has more space than the bar's previous location and the basement of the new building is currently unfinished. You have come up with two different investment possibilities: Investment Alternative 1: Microbrewery Renovate the basement into a microbrewery and begin brewing your own beer for sale at the bar. Investment Alternative 2: Kitchen Renovate the basement into a kitchen and begin to serve a full menu of food at the bar. Information: You have estimated that both projects will require an initial investment of $100,000 for renovations and new equipment purchases. You have found a local bank that will lend 70% of the initial investment, financed over 5 years at 6% per year. You can assume that the entire initial investment will be depreciated using the straight-line method over a 10-year period. You expect both investments to generate additional revenues of $50,000 and additional expenses of $32,000 in the first year. Both the revenues and expenses directly related to the new investments are expected to grow at a rate of 2% each year. Effects on other sales: If you decide to go with the microbrewery and start selling your own beer, you expect sales of other beverages to decline by $3000 in the first year. This loss in sales is expected to grow at a rate of 1% each year. If you decide on the kitchen investment and start serving food, you expect beverage sales to increase by $3000 in the first year. This gain in beverage sales is expected to grow at a rate of 1% each year. Other information you might need: Big Tap - Financial Information D/A Interest rate on debt (rdebt) Required rate of return on equity (reguity) | Marginal Tax Rate 0.70 6% 40% 25%