Year 0 Year 1 Year 2 Year 3 Year 4 Revenue 120000 440000 440000 330000 Cost...

	Year 0	Year 1	Year 2	Year 3	Year 4
Revenue		120000	440000	440000	330000
Cost of Goods Sold		-60000	-220000	-220000	165000
Gross Profit		60000	220000	220000	165000
Selling, General and Admin		-7000	-7000	-7000	-7000
Depreciation		-80000	-80000	-80000	-80000
EBIT		-27000	133000	133000	78000
Income tax (35%)		9450	-46550	-46550	-27300
Incremental Earnings		-36450	86450	86450	50700

Capital Purchaes	-280,000
Change to NWC		-5,000	-5,000	-5,000	-5,000

A garage is installing a new "bubble-wash" car wash. It will promote the car wash as a fun activity for the family, and it is expected that the novelty of this approach will boost sales in the medium term. If the cost of capital is 88%,by using the data in the table above, calculate the net present value (NPV) of this project.

Solutions

Expert Solution

NPV = sum of present values of FCF

FCF in each year = incremental earnings + depreciation - capital purchases - change to NWC

In year 1, EBIT is negative. Therefore, taxes should be positive, and these are a cash inflow since there is a reduction in tax expense. This will offset the negative EBIT to increase the incremental earnings. Therefore, this adjustment needs to be done in Year 1.

present value of each FCF = FCF / (1 + cost of capital)ⁿ

where n = number of years after which the cash flow occurs

NPV = 124,256

jeff jeffy answered 1 year ago

Next > < Previous

Related Solutions

These are the cash flows. Year 0 1 2 3 4 5 6 Revenue 3.2000 4.0000...

These are the cash flows. Year 0 1 2 3 4 5 6 Revenue 3.2000 4.0000 5.6000 5.6000 4.0000 2.4000 Expenses .7200 .9000 1.2600 1.2600 .9000 .5400 Depreciation .9500 .9500 .9500 .9500 .9500 .9500 Pretax profit 1.5300 2.1500 3.3900 3.3900 2.1500 .9100 Tax .5355 .7525 1.1865 1.1865 .7525 .3185 Net income .9945 1.3975 2.2035 2.2035 1.3975 .5915 OCF 1.9445 2.3475 3.1535 3.1535 2.3475 1.5415 Cash flow investment −5.7000 .4362 Change in NWC −.3200 −.0800 −.1600 0.0000 .1600 .1600 .2400...

A= 1 2 4 0 1 -2 -1 0 1 2 0 3 8 1 4...

A= 1 2 4 0 1 -2 -1 0 1 2 0 3 8 1 4 . Let W denote the row space for A. (a) Find an orthonormal basis for W and for W⊥. (b) Compute projW⊥(1 1 1 1 1 ).

exampleInput.txt 1 2 3 0 2 3 4 0 1 3 5 0 1 2 6...

exampleInput.txt 1 2 3 0 2 3 4 0 1 3 5 0 1 2 6 1 5 6 8 2 4 6 7 3 4 5 9 10 5 8 9 4 7 9 6 7 8 6 How can I detect when 'cin' starts reading from a new line. The amount of numbers in each row is unknown. I need them in type 'int' to use the data.

0. 0. 0. 0.0. 0. 0. 0. 0. 1. 1. 1. 1. 1. 1. 2. 2. 2. 3. 4.

0. 0. 0. 0.0. 0. 0. 0. 0. 1. 1. 1. 1. 1. 1. 2. 2. 2. 3. 4. A.)MEAN – B.)MEDIAN - C.)MODE - D.)STANDARD DEVIATION – E.)5 NUMBER SUMMARY – F.)BOX AND WHISKERS PLOT – G.) OUTLIERS-

0. 0. 0. 0.0. 0. 0. 0. 0. 1. 1. 1. 1. 1. 1. 2. 2. 2. 3. 4.

0. 0. 0. 0.0. 0. 0. 0. 0. 1. 1. 1. 1. 1. 1. 2. 2. 2. 3. 4. A.)5 NUMBER SUMMARY – B.)BOX AND WHISKERS PLOT – C.) OUTLIERS-

Consider the following data: quantity total cost total revenue 0 3 0 1 9 12 2...

Consider the following data: quantity total cost total revenue 0 3 0 1 9 12 2 16 24 3 24 36 4 33 48 5 45 60 6 58 72 7 74 84 a. Calculate the profit for each quantity. How many units should this firm produce to maximize profit? b. Calculate MR for each quantity. Calculate MC for each quantity. Does the profit-maximizing formula support your answer from part a? c. Is this firm perfectly competitive? How do you...

4) Consider total cost and total revenue given in the following table: Quantity 0 1 2...

4) Consider total cost and total revenue given in the following table: Quantity 0 1 2 3 4 5 6 7 7 Total Cost $120 150 160 170 190 230 300 410 610 Total Revenue $0 70 140 210 280 350 420 490 560 A. Create a table that includes the fixed cost at each level of output as well as the variable cost at each level of output. If capital is fixed and the firm uses 10 units of...

Project Year 0 Year 1 Year 2 Year 3 Year 4 A -$ 49 $ 25...

Project Year 0 Year 1 Year 2 Year 3 Year 4 A -$ 49 $ 25 $ 22 $ 22 $ 15 B -$ 101 $ 19 $ 39 $ 51 $ 61 a. What are the IRRs of the two projects? b. If your discount rate is 4.8%, what are the NPVs of the two projects? c. Why do IRR and NPV rank the two projects differently?

TABLE 4 Project Year 0 Year 1 Year 2 Year 3 Year 4 Year 5 Cash...

TABLE 4 Project Year 0 Year 1 Year 2 Year 3 Year 4 Year 5 Cash Flow Cash Flow Cash Flow Cash Flow Cash Flow Cash Flow A -15000 6000 7000 6000 6000 6000 B -15000 7000 7000 7000 7000 7000 C -18000 12000 2000 2000 2000 2000 "Consider the cash flow of the three projects depicted in Table 4. The cost of capital is 7.5%. If an investor decided to take projects with a payback period of 2 years...

Year Qtr t revenue ($M) 2011 1 1 5.889 2 2 6.141 3 3 8.272 4...

Year Qtr t revenue ($M) 2011 1 1 5.889 2 2 6.141 3 3 8.272 4 4 9.302 2012 1 5 6.436 2 6 6.932 3 7 8.987 4 8 10.602 2013 1 9 7.517 2 10 7.731 3 11 9.883 4 12 12.098 2014 1 13 8.487 2 14 8.685 3 15 11.559 4 16 15.221 2015 1 17 11.132 2 18 11.203 3 19 13.83 4 20 16.979 2016 1 21 12.312 2 22 13.452 3 23 17.659...

Subjects