Prepare a spread sheet model

Assignment Help Corporate Finance
Reference no: EM131091

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 subsequent 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 prepare a spread sheet model for the client that determines 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.

Reference no: EM131091

Questions Cloud

Prepare swag''s consolidated balance sheet : Prepare Swag's consolidated balance sheet
A project report on vulnerability assessment & penetration t : The implementation of project involves hosting a web server and to check different vulnerabilities present on it with the help of different tools.
Accounting professional and ethical standards : Code of Ethics for Professional Accountants
Sensitivity analysis : Sketch the results of a sensitivity analysis
Prepare a spread sheet model : Prepare a spread sheet model for the client that determines NPV/IRR with and without tax.
Accounting and partnership problems : Accounting and Partnership problems
A thesis on succession planning : This document is basically a thesis which focuses on Succession Planning system in single family Businesses.
Spreadsheet model of the heat transfer situation : Spreadsheet model of the heat transfer situation
Prepare a research proposal : Prepare a Research Proposal based on a business issue.

Reviews

Write a Review

 

Corporate Finance Questions & Answers

  Impact of the global economic crisis on business environment

This paper reviews the article of ‘the impact of the global economic crisis on the business environment' that is written by Roman & Sargu (2011).

  Explain the short and the long-run effects on real output

Explain the short and the long-run effects on real output, price, and unemployment

  Examine the requirements for measuring assets

Examine the needs for measuring assets at fair value in accounting standards

  Financial analysis report driven by rigorous ratio analysis

Financial analysis report driven by rigorous ratio analysis

  Calculate the value of the merged company

Calculate the value of the merged company, the gains (losses) to each group of shareholders, NPV of the deal under different payment methods. Synergy remains the same regardless of payment method.

  Stock market project

Select five companies for the purpose of tracking the stock market, preparing research on the companies, and preparing company reports.

  Write paper on financial analysis and business analysis

Write paper on financial analysis and business analysis

  Intermediate finance

Presence of the taxes increase or decrease the value of the firm

  Average price-earnings ratio

What is the value per share of the company's stock

  Determine the financial consequences

Show by calculation the net present value for the three alternatives (no education, network design certification, mba). Also, according to NPV suggest which alternative you advise your friend to choose

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