Reference no: EM13910134
The expected annual free cash flow for the GPS tracker investment from problem 3-1 is computed as follows:
Revenues 1,250,000
Variable cost 750,000
Fixed expenses 250,000
Gross profit 250,000
Depreciation 100,000
Net operating income 150,000
Income tax expense 51,000
NOPAT 99,000
Plus: depreciation 100,000
Less: CAPEX
Less: working capital investment
Free cash flow 199,000
a. Construct a spreadsheet model to compute free cash flow that relies on the following assumptions or estimates:
Base Case Estimates Values
Initial cost of equipment 1, 000,000
Project and equipment life 10 years
Salvage value of equipment 0
Working capital requirement 0
Depreciation method Straight-line
Depreciation expense 100,000
Discount rate 10.00%
Tax rate 34.00%
Unit sales 10,000
Price per unit 125.00
Variable cost per unit 75.00
Fixed costs 250,000
b. What level of annual unit sales does it take for the investment to achieve a zero NPV? Use your spreadsheet model to answer this question. (Hint: Use the Goal Seek function in Excel.)
c. If unit sales were 15% higher than the base case, what unit price would it take for the investment to achieve a zero NPV?
|
What is npv of the project with the lower cost of innovation
: You are able to lower cost of innovation to $200,000 but it will take more time to do the work. This means higher profits and cash flows will be delayed by one year. The investment of $200,000 will occur today. Which option is better ($200,000 wit..
|
|
Find the molecular formula
: a) Find the molecular formula of this compound if the Formula mass is 62.12 g/mole. b) Determine how many H atoms would be in a 3.50g sample of this compound.
|
|
Difference between an equation and an expression
: What is the difference between an equation and an expression? Can we multiply every term of an equation by anything we want? How about an expression?How do you find the common denominator of two or more fractions
|
|
Pollutant turned the painting black
: Lead pigments were used in water colour painting which turned black after prolonged to an air pollutant the original color was restored by using H2O2 which pollutant turned the painting black?
|
|
Construct a spreadsheet model to compute free cash flow
: What level of annual unit sales does it take for the investment to achieve a zero NPV? Use your spreadsheet model to answer this question
|
|
What factors could lead an institutional investor to prefer
: What factors could lead an institutional investor to prefer acquiring an equity stake in a public company through a private sale rather than purchasing such stock in the public market?
|
|
Draw an indifference map for each consumer
: Describe the set of bundles that Mr. Creosote can afford. Draw a few indifference curves and the budget line. How many muffins of each type will he buy?
|
|
Determining the volume of the rock
: A student finds a rock on the way to school. In the laboratory he determines that the volume of the rock is 29.7 cm3, and the mass in 139.943 g. What is the density of the rock?
|
|
Environment at the coffee bean
: 1.How would you gauge Peter's achievements orientation?What are some of the needs not being met for Peter Gibbons at Initech?What changes might improve Peter's motivation? 3.What about the environment at The Coffee Bean? Pygmalion or Golem?
|