Wonderful Snacks, Inc. is considering adding a new line of cookies and bars to its current...

50.1K

Verified Solution

Question

Finance

Wonderful Snacks, Inc. is considering adding a new line ofcookies and bars to its current product offer. The project’s lifeis 7 years. The firm estimates selling 500K packages at a price of$2 per unit the first year; but this volume is expected to grow at10% per year over the life of the project. The price per unit isexpected to grow at a rate of 3% per year. Variable costs are 20%of revenue and the fixed costs will be $850K per year. Theequipment required to produce the cookies and bars has an upfrontcost of$1.4M. It will be depreciated using straight-linedepreciation over the life of the project. After seven years, theequipment will be worthless. No additional net working capital isrequired for this project. The project’s discount rate is 15% andthe firm’s marginal tax rate is 35%.
using excel build a model to calculate the project’s free cashflows (FCF) and net present value. Create driver cells that allowthe user to vary the following inputs: volume growth rate, priceper unit growth rate, and discount rate.

Answer & Explanation Solved by verified expert

3.7 Ratings (479 Votes)

The value of Free Cash Flow and NPV is arrived as below Free Cash Flows Year 0 1 2 3 4 5 6 7 Sales in Units A 500000 550000 605000 665500 732050 805255 885781 Sales Price Per Unit B 200 206 212 219 225 232 239 Sales Revenue CAB 100000000 113300000 128368900 145441964 164785745 186702249 See Answer

Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:

Unlimited Question Access with detailed Answers
Zin AI - 3 Million Words
10 Dall-E 3 Images
20 Plot Generations
Conversation with Dialogue Memory
No Ads, Ever!
Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!

Become a Member

Transcribed Image Text

Wonderful Snacks, Inc. is considering adding a new line ofcookies and bars to its current product offer. The project’s lifeis 7 years. The firm estimates selling 500K packages at a price of$2 per unit the first year; but this volume is expected to grow at10% per year over the life of the project. The price per unit isexpected to grow at a rate of 3% per year. Variable costs are 20%of revenue and the fixed costs will be $850K per year. Theequipment required to produce the cookies and bars has an upfrontcost of$1.4M. It will be depreciated using straight-linedepreciation over the life of the project. After seven years, theequipment will be worthless. No additional net working capital isrequired for this project. The project’s discount rate is 15% andthe firm’s marginal tax rate is 35%.using excel build a model to calculate the project’s free cashflows (FCF) and net present value. Create driver cells that allowthe user to vary the following inputs: volume growth rate, priceper unit growth rate, and discount rate.