Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

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 and equipment are depreciated using the 5-year MACRS schedule.Bill's Winery will operate the winery for four years, and then expects to sell the winery to an investor for $1,200 plus any working capital.The firm will have some one-time expenses in year 1 of $170, primarily licenses and legal fees.To operate the winery, Bill's Winery will need an increase in Inventory of $17, an increase of Accounts Receivables of $24, and will have an increase in Accounts Payable of $49.Working capital will be recovered when we sell the winery.

Annual sales are as follows; $400 in year 1, $1,200 in year 2, $2,200 in year 3, and $2,500 in year 4.Cost of Goods Sold (excluding overhead, depreciation, and lease payments) are 40% of annual sales.Production labor is 20% of sales.To manage the company, executives and administrators must be hired, at an annual fixed cost of $260.Property taxes and alcohol licenses are $300 per year.

Bill's has an agreement for a 3-year 6% amortized Small Business Administration Loan to finance part of the project.The firm needs new equity investors to fund the expansion andBill's Winery has only been able to find one equity investor.Both SBA and 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 $20 per year.The firm's tax rate is 20%.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)

Step by Step Solution

3.46 Rating (143 Votes )

There are 3 Steps involved in it

Step: 1

Initial Cash Flows in Year 0 Land purchase 200 Equipment purchase 370 Shipping 50 Installatio... blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Corporate Finance Core Principles and Applications

Authors: Stephen Ross, Randolph Westerfield, Jeffrey Jaffe, Bradford Jordan

5th edition

1259289907, 978-1259289903

More Books

Students also viewed these Finance questions

Question

is a wireless access point a network device

Answered: 1 week ago