Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Questions 7 and 8 are based on the following investment opportunity: Wonderful Snacks, Inc. is considering adding a new line of cookies and bars to

Questions 7 and 8 are based on the following investment opportunity:

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 440K packages at a price of $2 per unit the first year; but this volume is expected to grow at 12% per year over the life of the project. The price per unit is expected to grow at a rate of 5% per year. Variable costs are 20% of revenue and the fixed costs will be $700K 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 20%.

  1. (15 points) In the FE #7-8 worksheet, 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. Below are calculations you may find useful in setting up your model:

FCF = EBIT x (1 - tax rate) + Depreciation - Capital Expenditures - DNWC + Terminal CF

EBIT = (Price x Units) - Variable Costs - Fixed Costs - Depreciation

Terminal Cash Flow = Salvage Value - Tax Rate x (Salvage Value - Book Value)

  1. (12 points) Wonderful Snacks has requested the following two sensitivity analyses of the proposed projects:
    1. Create a one-way data table to calculate the net present value of the project at discount rates ranging between 5% and 25%. Use increments of 1%.

  1. Create a two-way data table that calculates the net present value of the project at volume growth rates of 6%, 9%, 12% and 15% and price per unit growth rates of 4%, 5%, and 6%.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Financial Markets And Institutions

Authors: Frederic S. Mishkin, Stanley G. Eakins

7th Edition

013213683X, 978-0132136839

More Books

Students also viewed these Finance questions

Question

Briefly describe Hartleys contributions to associationism.

Answered: 1 week ago