Question




Question 20 1 points Save Answer Lakeside Winery is considering expanding its winemaking operations. The expansion will requi
0 0
Add a comment Improve this question Transcribed image text
Answer #1

Answer:- -$13,287

Explanation:-

NPV = Present Value of Cash Inflows - Initial Investments. 7- NPV = Initial Investment E cf t=1 clerit or NPV= CF (ltr) + Cf

Following is the Excel sheet showing the calculation of NPV of the project:-

5 Book4 - Excel nitin arora Ga х File Home Insert Page Layout Formulas Data Review View Help Tell me what you want to do Shar

Following is the Formula Sheet of above excel sheet for easy understanding of the formulas used:-

Book4 - Excel nitin arora Ga File Share fx Home Insert Page Layout Formulas Data Review View Help Tell me what you want to do

[ Note:- Proceeds from sale of equipment = Market Value x (1 - Tax rate) = $181000 x (1 - 0.35) = $117650 ]

Add a comment
Know the answer?
Add Answer to:
Question 20 1 points Save Answer Lakeside Winery is considering expanding its winemaking operations. The expansion...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • Lakeside Winery is considering expanding its winemaking operations. The expansion will require new equipment costing $697,000...

    Lakeside Winery is considering expanding its winemaking operations. The expansion will require new equipment costing $697,000 that would be depreciated on a straight-line basis to zero over the 5-year life of the project. The equipment will have a market value of $192,000 at the end of the project. The project requires $62,000 initially for net working capital, which will be recovered at the end of the project. The operating cash flow will be $187,600 a year. What is the net...

  • 5) Lakeside Winery is considering expanding its winemaking operations. The expansion will require new equipment costing...

    5) Lakeside Winery is considering expanding its winemaking operations. The expansion will require new equipment costing $675,000 that would be depreciated on a straight-line basis to zero over the 5-year life of the project. The equipment will have a salvage value of $181,000 at the end of the project. The project requires $51,000 initially for net working capital, which will be recovered at the end of the project. The operating cash flow will be $187,600 a year. What is the...

  • Lakeside Winery is considering expanding its winemaking operations. The expansion will require new equipment costing $685,000...

    Lakeside Winery is considering expanding its winemaking operations. The expansion will require new equipment costing $685,000 that would be depreciated on a straight-line basis to zero over the 4-year life of the project. The equipment will have a market value of $186,000 at the end of the project. The project requires $56,000 initially for net working capital, which will be recovered at the end of the project. The operating cash flow will be $210,600 a year. What is the net...

  • 23. Lakeside Winery is considering expanding its winemaking operations. The expansion will require new equipment costing...

    23. Lakeside Winery is considering expanding its winemaking operations. The expansion will require new equipment costing $708,000 that would be depreciated on a straight-line basis to a zero balance over the four-year life of the project. The equipment can be sold for $220,000 after the four years. The project requires $46,000 initially for net working capital, all of which will be recovered at the end of the project. The projected operating cash flow is $211,500 a year. What is the...

  • 5) Lakeside Winery is considering expanding its winemaking operations. The expansion will require new equipment cos...

    5) Lakeside Winery is considering expanding its winemaking operations. The expansion will require new equipment costing $675,000 that would be depreciated on a straight-line basis to zero over the 5-year life of the project. The equipment will have a salvage value of $181,000 at the end of the project. The project requires 551,000 initially for networking capital, which will be recovered at the end of the project. The operating cash flow will be $187.600 a year What is the net...

  • the lunch box is expanding and expects operating cash flows of 32500 a year for three...

    the lunch box is expanding and expects operating cash flows of 32500 a year for three years as a result. this expansion requires 28000 in new fixed assets. these assets will be worthless and fully depreciated at the end of the project. in addition, the project requires an initial investment of 2800 in net working capital at the beginning of the project, which will be recovered at the end of the project. what is the net present value of this...

  • 2. Bruno's Lunch Counter is expanding and expects operating cash flows of $26,000 a year for...

    2. Bruno's Lunch Counter is expanding and expects operating cash flows of $26,000 a year for 4 years as a result. This expansion requires $39,000 in new fixed assets. These assets will be worthless at the end of the project. In addition, the project requires $3,000 of net working capital, 100% of which will be recovered at he end of the project. What is the net present value of this expansion project at a required rate of return of 16...

  • Le Terroir Winery is considering an expansion project to produce fine wines. The trial expansion will...

    Le Terroir Winery is considering an expansion project to produce fine wines. The trial expansion will last for 4 years. It will require a capital investment of $1,000,000, and additional net operating working capital of $150,000. The winery expects to sell 10,000 bottles of wine each year at $98/bottle. The variable cost is $60/bottle, and total fixed costs are $200,000. Each of these are expected to be constant over the 4 year life of the project. a. Assuming a tax...

  • Fly High Co. is expanding and expects operating cash flows of $65,000 a year for four...

    Fly High Co. is expanding and expects operating cash flows of $65,000 a year for four years as a result. This expansion requires 5105,000 in new fixed assets. These assets will be worthless at the end of the project. In addition, the project requires $7,000 of net working capital, which will be recovered at the end of the project. What is the net present value of this expansion project at a required rate of return of 15 percent? A)- 574,600...

  • A firm is considering an expansion project that will last three years. The project requires an...

    A firm is considering an expansion project that will last three years. The project requires an immediate purchase of a new equipment that costs $900,000. The equipment will be fully depreciated using straight-line method over the next three years. The resale price of the equipment at the end of year three is estimated to be $200,000. The project will generate annual sales of $750,000 and incur annual costs (all costs except depreciation expense) of $200,000 for each of the next...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT