The expected annual free cash flow for the GPS tracker investment from is computed as follows: Construct
Question:
Construct a spreadsheet model to compute free cash flow that relies on the following assumptions or estimates:
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?
Transcribed Image Text:
Revenues Variable cost Fixed expenses Gross profit Depreciation Net operating income Income tax expense NOPAT Plus depreciation Less CAPEX Less working capital investment Free cash flow $1.250,000 750,000 250,000 250,000 00,000 S 150,000 51,000 $ 99.000 00,000 $ 199,000 Values Base Case Estimates Initial cost of equipment Project and equipment life Salvage value of equipment Working capital requirement Depreciation method Depreciation expese Discount rate Tax rate Unit sales Price per unit Varia ble cost per unit Fixed costs $1,000,000.o 10 years so So Straight-line 100,000.00 10 00% 34.00% 10,000 $12500 $75.00 250,000.00
Fantastic news! We've Found the answer you've been seeking!
Step by Step Answer:
Answer rating: 52% (23 reviews)
tr msoheightsourceauto col msowidthsourceauto br msodataplacementsamecell style43 msonumberformat 000 000 00220022 msostylenameComma msostyleid3 style45 msonumberformat00220022 00000220022 ...View the full answer
Answered By
Somshukla Chakraborty
I have a teaching experience of more than 4 years by now in diverse subjects like History,Geography,Political Science,Sociology,Business Enterprise,Economics,Environmental Management etc.I teach students from classes 9-12 and undergraduate students.I boards I handle are IB,IGCSE, state boards,ICSE, CBSE.I am passionate about teaching.Full satisfaction of the students is my main goal.
I have completed my graduation and master's in history from Jadavpur University Kolkata,India in 2012 and I have completed my B.Ed from the same University in 2013. I have taught in a reputed school of Kolkata (subjects-History,Geography,Civics,Political Science) from 2014-2016.I worked as a guest lecturer of history in a college of Kolkata for 2 years teaching students of 1st ,2nd and 3rd year. I taught Ancient and Modern Indian history there.I have taught in another school in Mohali,Punjab teaching students from classes 9-12.Presently I am working as an online tutor with concept tutors,Bangalore,India(Carve Niche Pvt.Ltd.) for the last 1year and also have been appointed as an online history tutor by Course Hero(California,U.S) and Vidyalai.com(Chennai,India).
4.00+
2+ Reviews
10+ Question Solved
Related Book For
Valuation The Art and Science of Corporate Investment Decisions
ISBN: 978-0133479522
3rd edition
Authors: Sheridan Titman, John D. Martin
Question Posted:
Students also viewed these Accounting questions
-
Nextron Distribution is performing an analysis of the cash flows it hopes to earn from a major expansion of the firms operations into a new product line. The estimates needed for computing the annual...
-
Landcruisers plus (LP) has operated an online retail store selling off-road truck parts. As the name implies, the firm specializes in parts for the venerable Toyota FJ40 that is known throughout the...
-
At present, Solartech Skateboards is considering expanding its product line to include gas-powered skateboards; however, it is questionable how well they will be received by skateboarders. Although...
-
If we define the median of a sequence as a number so that exactly as many elements come before it in the sequence as come after it, fix the program in 4.6.3 so that it always prints out a median....
-
Langlois Services Inc. is using the contract-based approach to account for a lease of a truck. The lease includes a residual value guarantee at the end of the term of the lease of $16,000. Langlois...
-
JLB Corporation is attempting to determine whether to lease or purchase research equipment. The firm is in the 40% tax bracket, and its after tax cost of debt is currently 8%. The terms of the lease...
-
Derive formula (12.6) by converting a cash flow of a bond to that of the fixed portion of the swap. Formula 12.6 X V=MSo IB(M,C) - 100d (0,M)]}N, (12.6)
-
Welcome Inns is a chain of motels serving business travelers in Arizona and southern Nevada. The chain has grown from one motel in 2007 to five motels. In 2010, the owner of the company decided to...
-
(13%) Problem 4: A student standing on a cliff throws a stone from a vertical height of d = 8.0 m above the level ground with velocity vo = 18 m/s at an angle 0 = 32 below the horizontal, as shown....
-
Chilwell Ltd prepares financial statements to 31 October each year. The company's trial balance at 31 October 2017 is as follows: The following information is also available: 1. Land is...
-
As low-fare airline, Southwest Airlines constantly focuses on ways to improve the efficiency of its operations and maintain a cost structure below that of its competition. In spring 2002, Scott...
-
The Clayton Manufacturing Company is considering an investment in a new automated inventory system for its warehouse that will provide cash savings to the firm over the next five years. The firms CFO...
-
Let L: V W be a linear transformation, and let S = {v1, v2,..., vn} be a set of vectors in V. Prove that if T = {L(v1), L(v2),..., L(vn)} is linearly independent, then so is S. What can we say about...
-
9. 10. 11. 12. 13. 14. 15. Thermal expansion in an aircraft hydraulic system can cause unless a provision is made to relieve the excess Gases are highly Gases Pressure is the greatest at the Liquid...
-
Q39 Members of the baryon decouplets typically decays after 1523 sec into a lighter baryon ( from baryon octet) and a meson ( from pseudoscalar meson octet). Analyze all possible decay modes for 52....
-
A bridge truss extends x = 205 m across a river (shown in the figure below) where 0 = 43. The structure is free to slide horizontally to permit thermal expansion. The structural components are...
-
A 25.0 kg mass moving at a velocity of + 3.0 m/s is stopped by a constant force of 15.0 N. How many seconds must the force act on the mass to stop it? (5 points)
-
he kinetic energy of a 67 kg person running at 19 km/h is 24187.0 J 1273.0 J 636.5 J 12093.5 J
-
Simplify using the power rules. Assume that all variables represent nonzero real numbers. (2x-5) 5
-
Fill in each blank so that the resulting statement is true. A solution to a system of linear equations in two variables is an ordered pair that__________ .
-
At the market close on January 29, 2008, Bank of America Corporation had a closing stock price of $41.84. In addition, Bank of America had a dividend per share of $2.40. Determine Bank of Americas...
-
The market price for Microsoft Corporation closed at $29.86 and $35.60 on December 29, 2006, and December 31, 2007, respectively. The dividends per share were $0.37 for 2006 and $0.41 for 2007. (a)...
-
eBay Inc. developed a Web-based marketplace at www.ebay.com, in which individuals can buy and sell a variety of items. eBay also acquired PayPal, an online payments system that allows businesses and...
-
Q1: what is the net operating income under the variable and absorption cost system. A: ACER company Product sales: 1,000 units at $10 each Variable manufacturing costs: $5.50 per unit Fixed...
-
Solve for 2 and graph the solution on the number line below. 245x+9 or 5x +9 69
-
Places and people differ. The Japanese tend to be very polite, the Australians characteristically blunt. Red means danger or stop to the British, but in Turkey it signifies death, and in China, good...
Study smarter with the SolutionInn App