Build cash flow based model

Assignment Help Financial Management

Reference no: EM131507289

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%.

Reference no: EM131507289

Questions Cloud

The basic consumer problem : All there is are movies (m) and food (f). The price of movies is $10 while the price of food is $5. I have $145 to spend on these two goods.

Which course of action should be recommended : Extended Learning Exercise A firm must decide between constructing a new facility or renting a comparable office space.

Compare any country with a universal health system : Compare any country with a universal health system to the U.S. health system in terms of cost and access.

Measure resistance using a dc wheatstone bridge : To what factors do you attribute measurement errors? What would be the effect if the excitation voltage for the bridge was a voltage other then 9 Volt

Build cash flow based model : Build a Cash Flow based model. Comment whether the project should be undertaken or not using NPV, IRR and Payback tools.

Does the drug free workplace act apply here : Does the Drug Free Workplace Act apply here? Can the employee file a lawsuit under the Civil Rights Act, Title VII (1964)? Why or why not?

How does motors and mores employee compensation compare : . How does Motors and More's employee compensation compare relative to other organizations in the area?

Quantity of wheat demanded and supplied : The data in the following table represents Canadian wheat market where, Qd and Qs are the quantity of wheat demanded and supplied in bushels per week.

What is the smallest value of n : Extended Learning Exercise The additional investment in a new computer system is a certain $300,000. It is likely to save an average of $100,000.

User Account

All Pages