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...
-
Joseph Farmer earned $68,000 in 2017 for a company in Kentucky. He is single with 1 withholding allowance and is paid annually. Compute the following employee share of the taxesusing the percentage...
-
Give an example of end-user computing (EUC).
-
At the beginning of the year, Wongs Martial Arts Centre bought three used fitness machines from Hangar Inc. for a total cash price of $ 38,000. Transportation costs on the machines were $ 2,000. The...
-
2. Commercial Banking. You are a corporate account officer with the Commercial & In- dustrial Bank Corporation (CIBC). One of your major manufacturing clients, who are re- tooling one of their...
-
The input is a collection of currencies and their exchange rates. Is there a sequence of exchanges that makes money instantly? For instance, if the currencies are X, Y, and Z and the exchange rate 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...
-
Dr. Roger Jones is a successful dentist but is experiencing recurring financial difficulties. For example, Jones owns his office building, which he leased to the professional corporation that housed...
-
Walton Manufacturing Company makes a product that sells for $ 7 5 . 8 0 per unit. Manufacturing costs for the product amount to $ 2 7 . 0 0 per unit variable, and $ 7 7 , 0 4 0 fixed. During the...
-
Explain the typical influence of high vs low power distance on the following emphasis on formality, delegation of decision making.
-
Which pigment is the most non-polar, and which pigment is the most polar? What pigments are more soluble in the chromatography solvent, xanthophylls or chlorophyll a? What characteristics did you use...
-
Milden Company is a merchandiser that plans to sell 4 1 , 0 0 0 units during the next quarter at a selling price of $ 5 9 per unit. The company also gathered the following cost estimates for the next...
-
Harbert, Incorporated had a beginning balance of $12,000 in its Accounts Receivable account. The ending balance of Accounts Receivable was $10,500. During the period, Harbert collects $72,000 of its...
-
The following Houston, TX house prices($1000s) were extracted from zillow.com in August 2019: Treating these 25 houses as a random sample of all available homes in Houston, calculate a 90% upper...
-
Subtract the polynomials. (-x+x-5) - (x-x + 5)
-
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...
-
D 8 The Gomez family bought a house for $175,000. They paid 20% down and amortized the rest at 11.2% over a 30-year period. Find their monthly payment. $1,354.45 O $1693.07 $2,149.21 $1,125.17 5
-
Consider two investments: a municipal bond that pays a tax-free yield of 3.5% and a taxable bond with a yield of 5%. If an investor is in the 25% tax bracket, what would be the tax equivalent yield...
-
You want to purchase a new Car for OMR ( Choose your amount _ 2 0 . 0 0 0 _ _ _ _ _ _ _ _ ) . You pay a 2 0 % down payment and agree to pay the remaining amount in one year in equated monthly...
Study smarter with the SolutionInn App