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

What do you understand by internal control, Question: The District Cash...

Question: The District Cash Offices represents the decentralisation of services provided by the Accountant - General Department, specially in the collection and accounting of r

Analysis, Ask question #Minimum 100 words accepted FIN 610 Milestone One Gu...

Ask question #Minimum 100 words accepted FIN 610 Milestone One Guidelines and Rubric Overview: For this first milestone, which is due in Module Three, you will describe each of the

A-note, A-Note is the highest tranche of an asset backed security or anothe...

A-Note is the highest tranche of an asset backed security or another structured financial product. An A-note is superior to other notes, like B-notes in bankruptcy or other credit

How do mergers affect communities, How do mergers affect communities? A:...

How do mergers affect communities? A: When a locally controlled bank is merged into a bank headquartered elsewhere (an out-of-market merger), some apprehension about the instit

Commercial insurance example, The East Coast Conglomerate Co (ECCC) a small...

The East Coast Conglomerate Co (ECCC) a small manufacturing company is doing a risk management assessment and a total review of their insurance policies. They have asked you,  know

Derive the fund separation theorem, Question 1: (a) What are the compe...

Question 1: (a) What are the competing theories which have been put forward to explain the term structure of interest rates? Which theories do the evidence tend to support?

What is the basic goal of a business?, What is the basic goal of a business...

What is the basic goal of a business? The main financial goal of the business firm is to make the most of the wealth of the firm's owners.  Wealth, in turn refers to value good

Ethical implications behind corporate governance, problem 1 (a) (i) De...

problem 1 (a) (i) Define Corporate Governance. (ii) Show the ethical implications behind Corporate Governance. (b) (i) Why do organizations engage in social accounting?

Antamina mines, i need to find out how quickly i could get some answers to ...

i need to find out how quickly i could get some answers to stock valuation questions on antamina mines case and how cheaply

Ssjdda, As the company''''s sales and earnings increased, so did the demand...

As the company''''s sales and earnings increased, so did the demand for capital. The firm''''s needs included inventory as well as additional space to house the inventory, computer

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