Question

In: Finance

Consider the following capital investment proposal: It requires an initial investment of $1,170 million. The project...

Consider the following capital investment proposal:
It requires an initial investment of $1,170 million. The project is expected to generate the following net cash flows:
$417 million in year 1
$328 million in year 2
$475 million in year 3
$531 million in year 4.

If the company uses a discount rate of 11%, how much is the profitability index?

Enter your answer in millions. Round to one decimal.

Please show work

Solutions

Expert Solution

Solution:

If the company uses a discount rate of 11%, the profitability index = $ 1.1 million

Please find the attached screenshot of the excel sheet containing the detailed calculation for the solution.


Related Solutions

Consider a project that has a 10% cost of capital that requires an initial investment of...
Consider a project that has a 10% cost of capital that requires an initial investment of $10,000. The year 1 net cash inflow is $2,450; the year 2 net cash inflow is $2,850; the year 3 net cash inflow is $3,350; the year 4 net cash inflow is $3,750; and the year 5 net cash inflow is $5,250. What is the project's discounted payback? NPV? AND IRR?
• The project requires $25 million in initial capital investment, and will have an economic lífe...
• The project requires $25 million in initial capital investment, and will have an economic lífe of 5 years. The investment will be straight-line depreciated down to a book value of zero at the end of 5 years. The investment is expected to be salvaged for $5 million at the end of 5 years. • The projected sales are $20 million per year from year 1 through year 5, variable costs are 50% of annual sales, and fixed costs are...
. Beckett, Inc. is evaluating a capital expenditure proposal that requires an initial investment of $1,200,000...
. Beckett, Inc. is evaluating a capital expenditure proposal that requires an initial investment of $1,200,000 and has predicted pre-tax cash inflows of $200,000 per year for 10 years. The new equipment will have no salvage value, but will replace an old piece of equipment valued on the books at $150,000 that can sell for $120,000. Beckett pays a tax rate of 20%, and has a required rate of return of 12% (PV of single value factor for 10 years...
Your company received an investment proposal which requires an initial investment of $5682678 now. The project...
Your company received an investment proposal which requires an initial investment of $5682678 now. The project will last for 5 years. You also have the following information about this project; Years 1 2 3 4 5 CF 682678 120,000 130,000 140,000 568267 Discount Rate 5% 7% 8% 10% 10% If you receive the above cash flows at the end of each year, calculate the NPV using both spreadsheet method and excel NPV function, and clearly mention if you will invest...
McCormick & Company is considering a project that requires an initial investment of $24 million to...
McCormick & Company is considering a project that requires an initial investment of $24 million to build a new plant and purchase equipment. The investment will be depreciated as a modified accelerated cost recovery system (MACRS) seven-year class asset. The new plant will be built on some of the company's land, which has a current, after-tax market value of $4.3 million. The company will produce bulk units at a cost of $130 each and will sell them for $420 each....
McCormick & Company is considering a project that requires an initial investment of $24 million to...
McCormick & Company is considering a project that requires an initial investment of $24 million to build a new plant and purchase equipment. The investment will be depreciated as a modified accelerated cost recovery system (MACRS) seven-year class asset. The new plant will be built on some of the company's land, which has a current, after-tax market value of $4.3 million. The company will produce bulk units at a cost of $130 each and will sell them for $420 each....
McCormick & Company is considering a project that requires an initial investment of $24 million to...
McCormick & Company is considering a project that requires an initial investment of $24 million to build a new plant and purchase equipment. The investment will be depreciated as a modified accelerated cost recovery system (MACRS) seven-year class asset. The new plant will be built on some of the company's land, which has a current, after-tax market value of $4.3 million. The company will produce bulk units at a cost of $130 each and will sell them for $420 each....
McCormick & Company is considering a project that requires an initial investment of $24 million to...
McCormick & Company is considering a project that requires an initial investment of $24 million to build a new plant and purchase equipment. The investment will be depreciated as a modified accelerated cost recovery system (MACRS) seven-year class asset. The new plant will be built on some of the company's land, which has a current, after-tax market value of $4.3 million. The company will produce bulk units at a cost of $130 each and will sell them for $420 each....
McCormick & Company is considering a project that requires an initial investment of $24 million to...
McCormick & Company is considering a project that requires an initial investment of $24 million to build a new plant and purchase equipment. The investment will be depreciated as a modified accelerated cost recovery system (MACRS) seven-year class asset. The new plant will be built on some of the company's land, which has a current, after-tax market value of $4.3 million. The company will produce bulk units at a cost of $130 each and will sell them for $420 each....
McCormick & Company is considering a project that requires an initial investment of $24 million to...
McCormick & Company is considering a project that requires an initial investment of $24 million to build a new plant and purchase equipment. The investment will be depreciated as a modified accelerated cost recovery system (MACRS) seven-year class asset. The new plant will be built on some of the company's land, which has a current, after-tax market value of $4.3 million. The company will produce bulk units at a cost of $130 each and will sell them for $420 each....
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT