Question

In: Finance

The firm is planning to invest up to £65 million next year. The information about the...

The firm is planning to invest up to £65 million next year. The information about the available investment projects is given in the table below.

Project

The initial investment, millions of £

Internal rate of return

Net present value,

millions of £

Profitability index

A

50

15%

12

B

35

19%

15

C

30

28%

42

D

25

26%

1

E

15

20%

10

F

10

37%

11

G

10

25%

13

H

1

18%

0.1

Assuming the projects are not divisible, use the profitability index(PI) as a criterion to determine the value-maximizing combination of projects. Show the calculations of the profitability indexes in the final column of the table.

Solutions

Expert Solution

Solution.>

I have solved this question in Excel. The formula used are written along with the values. If you still have any doubt, kindly ask in the comment section.

The decision rule for the profitability index is that any project with a ratio greater than one is an acceptable project. Higher the PI, better will be the project.

The reason being, PI is basically a variation of NPV rule.

Profitability index = 1 + (NPV/Initial Cost), hence if the returns are greater than cost, the PI will always be greater than 1 and will be accepted as per capital budgeting techniques.

Since the budget is 65 million, 4 Projects C,E,F and G are selected since they have the highest PI and the cost of these projects fulfilling the budget requirements.

Note: Give it a thumbs up if it helps! Thanks in advance!


Related Solutions

The firm is planning to invest up to £65 million next year. The information about the...
The firm is planning to invest up to £65 million next year. The information about the available investment projects is given in the table below. Project Initial investment, millions of £ Internal rate of return Net present value, millions of £ Profitability index A 50 15% 12 B 35 19% 15 C 30 28% 42 D 25 26% 1 E 15 20% 10 F 10 37% 11 G 10 25% 13 H 1 18% 0.1 Assuming the projects are not...
Managers of a firm are planning to invest $180,000.00 in a new four-year long project to...
Managers of a firm are planning to invest $180,000.00 in a new four-year long project to implement automation in the packaging department. Considering associated risk of the project, the managers are requiring 11% return from this investment. This project is expected to generate future cash flow of $65,000.00 in each year. Find Net present Value Internal Rate of Return Present Value Index Payback period Discounted Payback Period please show the steps Clear without using financial calculator. Thanks
Aldi is forecasting next year’s turnover at USD 70 million. The firm is planning to maintain a 47%
Aldi is forecasting next year’s turnover at USD 70 million. The firm is planning to maintain a 47% dividend pay-out ratio and is expecting a profit margin of 15%. Calculate the projected rise in retained earnings and explain the company’s three main options for raising new growth funding. 
A firm is expected to have free cash flow of $881 million next year. The firm...
A firm is expected to have free cash flow of $881 million next year. The firm has $1 billion of outstanding debt and no preferred stock. The WACC is 7% and FCF is expected to grow at 1% indefinitely. If the firm has 91 million shares outstanding, what is the expected value of the firm's stock price? If a portfolio holds three stocks in equal amounts, and the betas of the three stocks are 0.8, 1.4, and 1.4, what is...
A firm is expected to have free cash flow of $782 million next year. The firm...
A firm is expected to have free cash flow of $782 million next year. The firm has $1 billion of outstanding debt and no preferred stock. The WACC is 10% and FCF is expected to grow at 1% indefinitely. If the firm has 104 million shares outstanding, what is the expected value of the firm's stock price?
You are planning to invest 3 million euros for one year, and you have two alternatives:...
You are planning to invest 3 million euros for one year, and you have two alternatives: a US asset with interest rate 1.9%, and a French asset with interest rate 0.9%. Note also that today’s euro nominal exchange rate per $ equals 0.920. a) If you expect annual depreciation of the euro by 4%, what will be your choice? b) Which expected nominal exchange rate will make you indifferent between the two alternatives? B. The economic report for a Eurozone...
Use the following information for the next six questions: A firm has 2 million shares of...
Use the following information for the next six questions: A firm has 2 million shares of common stock outstanding, currently selling at $60 per share. It is expected to have EPS and dividends per share at the end of the current year in the amounts of $4 and $2.45, and a Return on Equity of 10%. It also has $100 Million par value of debt on its books, which is currently selling at a 5% discount to par. The debt...
A Venture Capital firm(VC Inc.) is planning to invest in an e-commerce start-up(EC ltd) VC Inc,...
A Venture Capital firm(VC Inc.) is planning to invest in an e-commerce start-up(EC ltd) VC Inc, wants a large stake in this start-up firm(EC Ltd) and has plans to go for a 21% stake in the company. EC Ltd. owners are willing to give up a 21% stake. Finance Manager Sui at VC Inc. has made cash flow projections for EC Ltd. Sui has suggested the following: Cash Flows of EC Ltd. will grow at a constant rate of 8%...
You are a manager in a start-up firm based in Bengaluru. The firm is planning to...
You are a manager in a start-up firm based in Bengaluru. The firm is planning to go public and you have been tasked at arriving at an approximate valuation for the firm. The firm is in the business of providing medical grade pure water. The asset beta of the firms’ in the industry with similar size is 1.3 and 1.4. The risk free rate is 5% and the market risk premium is 7%. At present, the firm doesn’t have any...
You are a manager in a start-up firm based in Bengaluru. The firm is planning to...
You are a manager in a start-up firm based in Bengaluru. The firm is planning to go public and you have been tasked at arriving at an approximate valuation for the firm. The firm is in the business of providing medical grade pure water. The asset beta of the firms’ in the industry with similar size is 1.3 and 1.4. The risk free rate is 5% and the market risk premium is 7%. At present, the firm doesn’t have any...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT