Solution-Compute free cash flow that relies

Compute free cash flow that relies

Assignment Help Finance Basics

Reference no: EM131081295

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: EM131081295

Questions Cloud

Effective rate of interest on the loan : 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?

Describe and discuss amazon capital composition : How many types of bonds issued by your firm are currently trading? What are their rates of return?

Ee computation electromagnetic : The project is supposed to be a small research project, so it should be done such that you can show me and the class you have put in good effort and have been creative and thoughtful about it. As far as page limit goes, there is really no hard lim..

Mission of maximizing shareholder value : With the mission of maximizing shareholder value in mind, how could the health care financial Manager help to motivate a large group of employees to exceptional performance? Explain in detail.

Compute free cash flow that relies : 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...

Explain why this is the underlying problem : Explain how a clearly defined problem could help with solutions.

Circuit used to create an edge-triggered d flip-flop : To simulate the operation of a circuit used to create an edge-triggered D flip-flop. To test the operation of a 74LS74 D flip-flop and compare the operation with the predicted behavior.

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.

What should a criminal defense lawyer do when the lawyer : According to Rich Deem, "We are instructed not to lie, and lying is strongly condemned"(n.page). Destroying evidence to prove guilt is lying and that is unacceptable and prosecutors and defense attorneys should follow the proper vertical and horiz..

User Account

All Pages

Compute free cash flow that relies

Reference no: EM131081295

Reference no: EM131081295

Questions Cloud

Reviews

Write a Review

Finance Basics Questions & Answers

Financial reporting and analysis

A report on financial accounting

Describe the types of financial ratios

Differences between sole proprietorship and corporation

Prepare a cash budget statement

What are the implied interest rates

State pricing theory and no-arbitrage pricing theory

Small business administration

Effect of financial leverage

Evaluate the basis for the payment to the lender

Importance of opps, ipps, mpfs and dmepos

Time value of money

Assured A++ Grade

Academics

Major Subjects

Majors

Get In Touch

TERMS & POLICIES

HELP & SUPPORT