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.