Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Partial credit is possible if you show your inputs. Will's Winery is considering opening a winery near campus. To open the winery, they must purchase

Partial credit is possible if you show your inputs.

Will's Winery is considering opening a winery near campus. To open the winery, they must purchase $290 in equipment. Shipping of the equipment will cost $90 and installation of the equipment will be $50. Will's Winery will lease a building for $355 per year. The building will need modifications costing $120, but these will be paid by the landlord. The modifications and equipment are depreciated using the 5-year MACRS schedule.Will's Winery will operate the winery for four years, and then expects to sell the winery to an investor for $560 plus any working capital.The firm will have some one-time expenses in year 1 of $150, primarily licenses and legal fees. To operate the winery, Will's Winery will need an increase in Inventory of $37, an increase of Accounts Receivables of $24, and will have an increase in Accounts Payable of $35. Working capital will be recovered when we sell the winery.

Annual sales will begin at $600, the increase at $800 per year. Thus year 2 sales are $1400, year 3 are $2200 and year 4 are $3000. Cost of Goods Sold (excluding overhead, depreciation, and lease payments) are 50% of annual sales. To operate the company, executives and administrators must be hired, at an annual fixed cost of $460.

Will's has an agreement for a 3-year 6% amortized Small Business Administration Loan to the first $250 of the project. The firm needs new equity investors to fund the expansion and Will'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 $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)

Show your work/inputs for partial credit.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

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_2

Step: 3

blur-text-image_3

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

Managerial Accounting

Authors: Karen Braun, Linda S Bamber

2nd Edition

136091164, 978-0136091165

More Books

Students also viewed these Accounting questions

Question

What does the going concern assumption mean for a business?

Answered: 1 week ago

Question

3. Give short, clear directions before, not during, transitions.

Answered: 1 week ago