Note: Please answer to the point for the questions a-d, by backing that up with excel calculations:

You have been approached by your CFO to evaluate a Long Term Proposal of starting a new service line/ product; Following numbers are expected to play out over the next 5 years

Initial Investment: Rs 20 Cr

Revenues: Rs 120 Cr in Year 1; annual growth of 20% each year

EBITDA Margin: 0% in Year 1; annual improvement of 500 basis points each year (i.e. 5%, 10%, 15% and so on)

Working Capital Requirements: 10% of Revenue

You also have the following information from the CFOs team

Opportunity cost of capital for your company is 12%

Taxes are paid at 34% on Profit Before Tax

Depreciation is charged at 10% p.a. on the initial investment on a Straight Line basis

Historically, projects undertaken by your company have paid back in 3 years

Based on the above information, you are required to

a) Build a Cash Flow based model b) Comment whether the project should be undertaken or not using NPV, IRR and Payback tools c) What would your recommendation be for (b) above if the opportunity cost of capital was 15%

d)What would your recommendation be for (b) above if you got to know that another project being evaluated has the following results: NPV= Rs 10 Cr; IRR= 13%