Consultancy Firm, Corporate Finance

Assignment Help:
You work for a major consultancy firms in corporate finance. Your firm has been approached by one of its major clients to assist them in solving a problem that they have. You have been assigned the task to solve the client’s problem.

The client needs help with analyzing an investment opportunity given the following information: The initial cost is $2,000,000 and it will provide an EBIT of $400,000 at the end of each year for the next 10 years. The investment is depreciated linearly over the 10 years. The corporate tax rate is 30% and the firm has a D/E = 1/3. Finally, rD = 8% and rE = 15% for this project.

Your task is to create a spread sheet model for the client that calculates NPV/IRR with and without tax. Further, the client is uncertain about the project’s cost of capital therefore they also want you to show in a graph the NPV (with and without tax) for different discount rates. Use the interval 0% to 100% with 5% subintervals. Set the y-axis as NPV and use the x-axis for the discount rates.

N.B. Since the client wants to be able to use this spreadsheet in the future for other projects as well you need to use cell references in the formulas.

Related Discussions:- Consultancy Firm

Do mergers result in layoffs?, Do mergers result in layoffs? A: Overall...

Do mergers result in layoffs? A: Overall employment in the banking industry actually has increased slightly over the last ten years. Some mergers do result in layoffs. However,

Difference between transaction and translation risk, Question: You have...

Question: You have been appointed as the treasurer of Dockers International, an automobile firm with many subsidiaries abroad. The management of Dockers International is relati

Expert triangulation - forecasting methods, Method is the ?rst of two metho...

Method is the ?rst of two methods proposed by Mantrala and Rao (2001) and has been reviewed in Section 2.We use a simpli?ed version, with ?xed prices and for a single period. Furth

Use of forecasting method, Cooper Toys sells a portable baby stroller calle...

Cooper Toys sells a portable baby stroller called the Tot n' Trot. The past two years of demand for Tot n'Trots are shown in the table below. Use an appropriate method to forecast

Estimate net cash flow, Allied Managed Care Company is evaluating two diffe...

Allied Managed Care Company is evaluating two different computer systems for handling provider claims. There are no incremental revenues attached to the projects, so the decisio

Explain in relation to the agency problem, "The agency theory concept was i...

"The agency theory concept was initially developed by Means and Berle (1932), who argued that due to a continuous dilution of equity ownership of large corporations, ownership and

Describe the capital asset pricing model, Question 1: (a) Explain clear...

Question 1: (a) Explain clearly two semi-strong form tests of the Efficient Market Hypothesis (EMH), one supporting and one rejecting the EMH. (b) Summarise the evidence in

American petroleum institute, This institute is a leading oil and gas indus...

This institute is a leading oil and gas industry trade association. The American Petroleum Institute is concerned with public policy and industry lobbying efforts, health and safet

Determine pay back period and net present value, Determine pay back period ...

Determine pay back period and net present value? A company is considering two projects with the subsequent cash flow streams:   Year           Project A

What is the value of equity of alpha, Two firms, Alpha and Beta, are in the...

Two firms, Alpha and Beta, are in the same business and size and identical in all respects except the way in which they have financed their assets. If the economy does well in th

Write Your Message!

Captcha
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd