Question
You are a manager at PercolatedFiber, which is considering expanding its operations in synthetic fiber manufacturing. Your boss comes into youroffice, drops aconsultant's report on
You are a manager at PercolatedFiber, which is considering expanding its operations in synthetic fiber manufacturing. Your boss comes into youroffice, drops aconsultant's report on yourdesk, andcomplains, "We owe these consultants $ 1.3
$1.3 million for thisreport, and I am not sure their analysis makes sense. Before we spend the $ 29
$29 million on new equipment needed for thisproject, look it over and give me youropinion." You open the report and find the following estimates(in millions ofdollars):
(Click on the Icon located on thetop-right corner of the data table below in order to copy its contents into aspreadsheet.)
Project Year
Earnings Forecast($ million)
1
2
. . .
9
10
Sales revenue
29.000
29.000
29.000
29.000
29.000
29.000
29.000
29.000
minus
Cost of goods sold
17.400
17.400
17.400
17.400
17.400
17.400
17.400
17.400
equals
=Gross profit
11.600
11.600
11.600
11.600
11.600
11.600
11.600
11.600
minus
Selling, general, and administrative expenses
2.320
2.320
2.320
2.320
2.320
2.320
2.320
2.320
minus
Depreciation
2.900
2.900
2.900
2.900
2.900
2.900
2.900
2.900
equals
=Net operating income
6.380
6.380
6.380
6.380
6.380
6.380
6.380
6.380
minus
Income tax
2.233
2.233
2.233
2.233
2.233
2.233
2.233
2.233
equals
=Net unlevered income
4.147
4.147
4.147
4.147
4.147
4.147
4.147
4.147
All of the estimates in the report seem correct. You note that the consultants usedstraight-line depreciation for the new equipment that will be purchased today(year 0), which is what the accounting department recommended. The report concludes that because the project will increase earnings by $ 4.147
$4.147 million per year for tenyears, the project is worth $ 41.47
$41.47 million. You think back to your halcyon days in finance class and realize there is more work to bedone!
First, you note that the consultants have not factored in the fact that the project will require $ 11
$11 million in working capital upfront(year 0), which will be fully recovered in year 10.Next, you see they have attributed $ 2.32
$2.32 million ofselling, general and administrative expenses to theproject, but you know that $ 1.16
$1.16 million of this amount is overhead that will be incurred even if the project is not accepted.Finally, you know that accounting earnings are not the right thing to focuson!
a. Given the availableinformation, what are the free cash flows in years 0 through 10 that should be used to evaluate the proposedproject?
b. If the cost of capital for this project is 9 %
9%, what is your estimate of the value of the newproject?
a. Given the availableinformation, what are the free cash flows in years 0 through 10 that should be used to evaluate the proposedproject?
The free cash flow for year 0 is $
nothing
million. (Round to three decimal places and enter a decrease as a negativenumber.)
The free cash flow for years 1 to 9 is $
nothing
million. (Round to three decimal places and enter a decrease as a negativenumber.)
The free cash flow for year 10 is $
nothing
million. (Round to three decimal places and enter a decrease as a negativenumber.)
b. If the cost of capital for this project is 9 %
9%, what is your estimate of the value of the newproject?
The value of the project is $
nothing
million. (Round to three decimalplaces.)
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started