Find npv and irr and payback period

Assignment Help Financial Management

Reference no: EM132062583

XYZ Ltd is planning to invest in a project which costs in Year 0 a capital investment of Rs 80 crores. It has made following projections. Its expected sales & EBITDA forecast is as follows:

Year Sales EBITDA %

1 Rs 10 cr 0%

2 Rs 20 cr 10%

3 Rs 50 cr 15%

4 Rs 100cr 20%

5 Rs 120cr 22%

6 Rs 150cr 22%

7 Rs 150cr 22%

Its annual depreciation is Rs 2 cr, Its annual interest costs are Rs 1 cr, tax rate is 34% , Working capital requirements are 15% of sales. Annual capital expenditure requirements after initial capital investment in Year 0 are Year 1 (Rs 5 cr), Year 2 (Rs 3 cr) and there after Rs 2 crores annually.

In year 7 business will have a terminal value of Rs 200 crores i.e. in 7th year at the end of project, the project residual things ie assets and working capital etc can be sold for Rs 200 crores.

For XYZ Ltd cost of capital or hurdle rate assume Debt, Equity 1:1, pre tax cost of debt is 14%, cost of equity is 25%.

Find NPV, IRR and Payback period and give your conclusion if XYZ Ltd should do the project.

Note: Please show all the calculations & formulas in excel sheet.

Reference no: EM132062583

Questions Cloud

New anaesthetic solution : 23.0 mL of anaesthetic is added to distilled water to make a 200 mL solution. What is the % V/V of the new anaesthetic solution?

What is the rationale for this argument : We learned in class that the "option to expand" is an implicit call option. What is the rationale for this argument?

Calculate the dissolved oxygen concentration of solution : An aqueous solution has 0.0086 g of oxygen dissolved in 2.5 L of water. Calculate the dissolved oxygen concentration of this solution in parts per million.

What are the betas listed for these companies : What are the betas listed for these companies? If you made an equal dollar investment in each stocks what would be the beta of your portfolio?

Find npv and irr and payback period : XYZ Ltd is planning to invest in a project which costs in Year 0 a capital investment of Rs 80 crores.

Henderson-hasselbalch equation : (a) Assuming no volume change, calculate the pH of the buffer solution using the Henderson-Hasselbalch equation.

Evaluate the expected change in the value per share : Assuming that the assumptions of the Modigilani and Miller models hold, what is the expected change in the value per share due to the recapitalization?

What was the investment in operating net working capital : The company also needs 1% of sales in cash for operations but carries cash and securities that make 20% of sales.

New temperature inside of the tire in degrees celsius : At the end of a long trip, the tire pressure increased to 1.6 atm. What is the new temperature inside of the tire in degrees Celsius?

User Account

All Pages