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

  Support or lack of support

01:  The p-value is a probability that measures the support or lack of support for the

  The florine mining company has constructed a town at

the florine mining company has constructed a town at junilla near the site of a rich mineral discovery in a remote part

  Explain why expected return is considered forward-looking

Explain how differences in allocations between the risk-free security and the market portfolio can determine the level of market risk

  How many yen would you receive for every shekel exchanges

U.S. dollar can be exchanged for 3.50 Israeli shekels or for 104.00 Japanese yen. What is the cross-exchange rate between the yen and the shekel, how many yen would you receive for every shekel exchanges?

  Baker bros has a dso of 40 days and its annual sales are

baker bros. has a dso of 40 days and its annual sales are 7300000. what is its accounts receivable balance? assume it

  What is the source of potential agency conflicts between

what is the source of potential agency conflicts between owners and bondholders? who is the agent and who is the

  A project requires a net investment of 450000 it has a

a project requires a net investment of 450000. it has a profitability index of 1.25 based on the firms 12 percent cost

  Analyze the existing business strategies

Analyze the existing business strategies, domestic and global environments, industry, and internal capabilities for both Apple andSamsung. Assess the significant manner in which each company's mission and vision align with the long-terms goals and..

  Calculate the adjusted present value

Suppose that a company is planning to undertake a project costing $2,000,000. This money will be depreciated using straight line depreciation over 5 years.

  To maximise profit you need to sell your output at the

to maximise profit you need to sell your output at the highest price. after what you have learned this week with

  Which of the following is not one of the four items

which of the following is not one of the four items required to be shown in the heading of a financial statement?a. the

  Currency swaps interest rate swaps with alternative debt

currency swaps interest rate swaps with alternative debt issues.ashton bishop is the debt manager for world telephone

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