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...

  • 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...

  • 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...

  • Cirice Corp. is considering opening a branch in another state. The operating cash flow will be...

    Cirice Corp. is considering opening a branch in another state. The operating cash flow will be $158,900 a year. The project will require new equipment costing $571,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 $163,000 at the end of the project. The project requires an initial investment of $37,500 in net working capital, which will be recovered at the end of the...

  • Global Water Treatment, Inc. is analyzing a proposed investment that would initially require $750,000 of new...

    Global Water Treatment, Inc. is analyzing a proposed investment that would initially require $750,000 of new equipment. This equipment would be depreciated on a straight-line basis to a zero balance over the four-year life of the project. The estimated salvage value is $150,000. The project requires $50,000 initially for net working capital, all of which will be recouped at the end of the project. The projected operating cash flow is $ 265,000 a year. What is the internal rate of...

  • 1. Caspian Sea Drinks is considering the production of a diet drink. The expansion of the...

    1. Caspian Sea Drinks is considering the production of a diet drink. The expansion of the plant and the purchase of the equipment necessary to produce the diet drink will cost $22.00 million. The plant and equipment will be depreciated over 10 years to a book value of $2.00 million, and sold for that amount in year 10. Net working capital will increase by $1.23 million at the beginning of the project and will be recovered at the end. The...

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
ADVERTISEMENT