Question

In: Finance

Pantaloon Beer is considering opening a microbrewery near campus. To open the brewery, they must purchase...

Pantaloon Beer is considering opening a microbrewery near campus. To open the brewery, they must purchase $250 in equipment. Shipping of the equipment will cost $40 and installation of the equipment will be $30. Pantaloon will lease a building for $384 per year. The building will need modifications costing $100. Both the modifications and equipment are depreciated using the 5 year MACRS schedule. Pantaloon will operate the brewery for four years, and then expects to sell the brewery to an investor for $500 plus any working capital. The firm will have some one-time expenses in year 1 of $120, primarily licenses and legal fees. To operate the brewery, Pantaloon will need an increase in Inventory of $17, an increase of Accounts Receivables of $19, and will have an increase in Accounts Payable of $15. Working capital will be recovered when we sell the brewery. Annual sales will begin at $600, the increase at $600 per year. Thus year 2 sales are $1200, year 3 are $1800 and year 4 are $2400. Cost of Goods Sold (excluding overhead, depreciation, and lease payments) are 60% of annual sales. To operate the company, executives and administrators must be hired, at an annual fixed cost of $500. Over the past two years, Pantaloon has been testing the concept by using a contract brewer. Last year’s sales were $100 with a cost of goods sold of $120. 40% of the project financing will come from a three-year 6% annual coupon bond. The firm needs new equity investors to fund the expansion and Pantaloon has only been able to find one equity investor. This equity investor requires that the firm have audited financial statements. The outside investor gets to choose the auditor and the auditor would cost the company $30 per year. The firm’s tax rate is 30%. The cost of capital is 13%. What are the Initial Cash Flows in Year 0? What are the Operating Cash Flows in Year 2? What are the Terminal Cash Flows in Year 4? (I want only Terminal Cash Flows, not operating cash flows in year 4)

Solutions

Expert Solution

Initial Cash Flows in Year 0
Cost of Equipment $250
+ Shipping $40
+ Installation $30
+ Building Modification $100
+ Net Working Capital ($17 + $19 - $15) $21
Initial Cash Flows in Year 0 -441
b)
Operating Cash flow in year 2
Sales $1,200
Less: COGS (1200 x 60%) 720
Gross profit $480
Less: Depreciation ($441 - $21) x 32% -134.4
          Overhead -500
          Lease expenses -384
Earning before interest and Tax -$538.4
Less: Interest ($441 x 40% x 6%) -10.584
Earning before Tax -$548.98
Less: Tax 30% 164.6952
Net Income -$384.29
Add: Depreciation 134.4
Operating Cash flow in year 2 -$249.89
c)
Terminal Cash Flow
Terminal Cash Flow = After-tax Proceeds from Disposal ± Change in Working Capital
Terminal cash flow = $371.77 + 21 $392.77
After-tax Proceeds from Disposal = Pre-tax Proceeds from Disposal − Tax on gain on Disposal
After-tax Proceeds from Disposal = $500 - 30% x 427.424 $371.77
Book Value = $420 - (1-20%+32%+19.20%+11.52%)depreciation 72.576
proceeds from tax 500
Gain on sale -427.424

Related Solutions

Bill’s Winery is considering opening a winery near campus. To open the winery, they must purchase...
Bill’s Winery is considering opening a winery near campus. To open the winery, they must purchase $370 in equipment. Shipping of the equipment will cost $50 and installation of the equipment will be $40. In addition to the equipment, Bill’s Winery will build a new building with an all-in price of $1000. Bill bought the land for the winery for $200 five years ago and has no plans for the land if he does not build the winery. The modifications...
Assume that a new theater is opening near campus. The theater owner wants lots of students...
Assume that a new theater is opening near campus. The theater owner wants lots of students to come to see movies, but is nervous about what influences their demand. Through masterful research, the theater owner discovers the following is true about demand for his theater tickets: Own Price Elasticity    =   3.5       Cross Price Elasticity    =   2.2       Income Elasticity    =    4.7 If the owner lowers his price by 20%, by how much will quantity demand...
Three former college classmates decided to open a store near campus to sell wireless equipment to...
Three former college classmates decided to open a store near campus to sell wireless equipment to students. They created a public company, The Wire, and issued stock to interested investors. They plan on creating monthly financial statements. Required: Several transactions occurred in March. Each is described separately in this folder. For each transaction, indicate the accounts for The Wire that are affected, whether they increase or decrease, and the amount of the increase or decrease. YOU MUST FOLLOW THE INSTRUCTIONS...
Three former college classmates decided to open a store near campus to sell wireless equipment to...
Three former college classmates decided to open a store near campus to sell wireless equipment to students. They created a public company, The Wire, and issued stock to interested investors. They plan on creating monthly financial statements. Required: Several transactions occurred in March. Each is described separately in this folder. For each transaction, indicate the accounts for The Wire that are affected, whether they increase or decrease, and the amount of the increase or decrease. Instructions: 1. After each transaction...
Three former college classmates decided to open a store near campus to sell wireless equipment to...
Three former college classmates decided to open a store near campus to sell wireless equipment to students. They created a public company, The Wire, and issued stock to interested investors. They plan on creating monthly financial statements. Several transactions occurred in March. Each is described separately in this folder. For each transaction, indicate the accounts for The Wire that are affected, whether they increase or decrease, and the amount of the increase or decrease. When you record the dollar amounts,...
Three former college classmates decided to open a store near campus to sell wireless equipment to...
Three former college classmates decided to open a store near campus to sell wireless equipment to students. They created a public company, The Wire, and issued stock to interested investors. They plan on creating monthly financial statements. Several transactions occurred in March. Each is described separately in this folder. For each transaction, indicate the accounts for The Wire that are affected, whether they increase or decrease, and the amount of the increase or decrease. When you record the dollar amounts,...
Molly is considering opening a Campus Delivery business. The initial investment for the business is $263,000,...
Molly is considering opening a Campus Delivery business. The initial investment for the business is $263,000, which includes purchasing delivery vehicles and other investments. For tax purposes, the projected salvage value of the delivery vehicles is $25,000. The government requires depreciating the vehicles using the straight-line method over the business’s life of 10 years. Molly is trying to estimate the net cashflows after tax for this business. She has already figured out that the business will generate an annual after-tax...
Molly is considering opening a Campus Delivery business. The initial investment for the business is $263,000,...
Molly is considering opening a Campus Delivery business. The initial investment for the business is $263,000, which includes purchasing delivery vehicles and other investments. For tax purposes, the projected salvage value of the delivery vehicles is $25,000. The government requires depreciating the vehicles using the straight-line method over the business’s life of 10 years. Molly is trying to estimate the net cashflows after tax for this business. She has already figured out that the business will generate an annual after-tax...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT