Compute free cash flow

Assignment Help Finance Basics
Reference no: EM131082665

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

  • Construct a spreadsheet model to compute free cash flow that relies on the following assumptions or estimates:
  • 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.)
  • If unit sales were 15% higher than the base case, what unit price would it take for the investment to achieve a zero NPV?

Reference no: EM131082665

Questions Cloud

Determining the price depreciation : What is the depreciation on the 5 year bond, and the % price depreciation on the 10 year bond
Given the way in which many forces have affected drug : Given the way in which many forces have affected drug use in the past, develop your own projection into the future - to the year 2025 - of the nature of our society's drug use problems, based on some of the social, political, economic, law enforce..
Analyze these data and draw appropriate conclusions : Each hand truck is used four times and the data that follow are obtained. Analyze these data and draw appropriate conclusions. Use α = 0.05.
Effective rate of interest on the loan : A corporation borrows $2 million from the bank at a 6 percent prime rate. If the bank requires the company to hold 15 percent of the amount of the loan on deposit as a compensation balance, what is the effective rate of interest on the loan?
Compute free cash flow : Construct a spreadsheet model to compute free cash flow that relies on the following assumptions or estimates: 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...
Develop an interactive e-learning tool in english language : Write a simple description about the program H. Design and display the screenshot of each form and label the different objects - develop an interactive e-learning tool in English language learning for kids
Define how expectations and context can influence perception : Describe how expectations, contexts, emotions, and motivation can influence perception. Provide examples of each.
Is there any indication that a transformation is required : Is there any indication that a transformation is required?
Potential multinational corporation : Describe the risks that a potential multinational corporation may no longer face as it ceases to be a domestic corporation. Discuss total and unique risks for a potential multinational corporation.

Reviews

Write a Review

Finance Basics Questions & Answers

  Calculate the market price of a share

Given the following data: stockholders equity = $1,250; price/earnings ratio =10; shares outstanding =25; market/book ration =1.75.

  Problem regarding the internal rate of return

Answer the following questions and problems from Chapter 7, page 328 of the text, 2, 3, 6, 8, 9. List and describe the three decision rules when using the Internal Rate of Return.

  Determine primary roles of the sec

Determine three primary roles of the SEC and explain how does the Sarbanes Oxley Act augment the SEC's role in managing financial governance? Do you think that businesses are more ethical after the passing of the Sarbanes Oxley Act?

  What would the capital surplus be

Holden Bicycles has 2,000 shares outstanding each with a par value of $0.50. If they are sold to shareholders at $12 each, what would the capital surplus be?

  A particular securitys default risk premium is 3 percent

a particular securitys default risk premium is 3 percent. for all securities the inflation risk premium is 2 percent

  Earned value management

Review the Fleming and Koppelman article from your assigned readings. Evaluate two of the ten EVM requirements and analyze how a project you have worked on in the past could have been more effective by using the measures.

  Weighted average cost of capital for fox

Fox Scientific Solutions has a capital structure that is 60% common equity & 40% debt. There is no preferred equity. The market risk premium is 6% & the risk free rate is 3%. The beta of the common stock is 2.0. The bonds have a yield to maturity ..

  How much money would have to be deposited every quarter if

how much money would have to be deposited every quarter if a company wants to have 75000 at the end of three years .

  In your own words explain how to obtain the ldquoexpected

in your own words explain how to obtain the ldquoexpected value of perfect informationrdquo for any payoff table which

  Explain why sunk costs should not be included in a capital

explain why sunk costs should not be included in a capital budgeting analysis but opportunity cots and externalities

  What is the graph of the payoff function

Calculate Payoff Function in the following Portfolio. What is the graph of the payoff function?

  What is the cost of new equity for this company\

What is the cost of new equity for this company, taking into account flotation costs?

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd