Logo
Home Study Material Contact Search
AI Chat FREE
  1. business
  2. finance
  3. wonderful snacks, inc. is considering adding a new

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

60.1K

Verified Solution

Question

Finance

Wonderful Snacks, Inc. is considering adding a new line of cookies and bars to its current product offer. The projects life is 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 at 10% per year over the life of the project. The price per unit is expected to grow at a rate of 3% per year. Variable costs are 20% of revenue and the fixed costs will be $850K per year. The equipment required to produce the cookies and bars has an upfront cost of$1.4M. It will be depreciated using straight-line depreciation over the life of the project. After seven years, the equipment will be worthless. No additional net working capital is required for this project. The projects discount rate is 15% and the firms marginal tax rate is 35%.

  1. using excel build a model to calculate the projects free cash flows (FCF) and net present value. Create driver cells that allow the user to vary the following inputs: volume growth rate, price per unit growth rate, and discount rate.

Answer & Explanation Solved by verified expert
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

Other questions asked by students