User Account

All Pages

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

  How much total interest is paid over the life of the loan

Prepare an amortization schedule for a five-year loan of $50,000. The interest rate is 8 percent per year, and the loan calls for equal annual payments. How much interest is paid in the third year? How much total interest is paid over the life of ..

  How many years will it take to exhaust his funds

Your father has $540,000 invested at 7.3%, and he now wants to retire. He wants to withdraw $50,000 at the beginning of each year, beginning immediately. How many years will it take to exhaust his funds, i.e., run the account down to zero?

  Representation-variance analysis

Variance analysis is very important for healthcare managers because it can be used to observe how well a healthcare organization is performing and also how close actual costs and revenues are to expected costs and revenues. However there are some ..

  Explaining and comparing mutually exclusive projects

Explaining and Comparing mutually exclusive projects and Negative amount should be indicated by a minus sign

  What does it mean for a process to be capable

A process is operating in such a manner that the mean of the process is exactly on the lower specification limit. What must be true about the two measures of capability for this process?

  Problem regarding the firm required rate of return

Zacher Co.'s stock has a beta of 0.72, the risk-free rate is 4.25%, and the market risk premium is 5.50%. What is the firm's required rate of return?

  What would be your monthly mortgage payment

You are considering purchasing an existing single family house for $200,000 with a 20 percent downpayment and a thirty-year fixed-rate mortgage at 5.5 percent.

  Conduct a dynamic firm profitability analysis over time

Conduct a dynamic firm profitability analysis over time (fiscal years 2008-2012) as shown in Exhibit 5.1. Can you find signs of performance differentials between these two firms that may have indicated problems at BlackBerry? When did BlackBerry's..

  A company is producing an electromagnetic field parts for

a company is producing an electromagnetic field parts for this it requires material alpha whose original standard

  For the past five years the price of microprocessors inc

for the past five years the price of microprocessors inc. stock has been increasing at a rate of 9 percent a year.

  The payment structure of a corporate bond

The payment structure of a corporate bond is best thought

  Calculate the total amount of money needed today to meet

1. calculate the total amount of money needed today to meet julies medical needs. assume that she lives seven years and

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!

Submit Assignment

Academics

Major Subjects

Majors

Get In Touch

whatsapp: +1-415-670-9521

Phone: +1-415-670-9521

Email: [email protected]

TERMS & POLICIES

HELP & SUPPORT

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