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.