Corporate finance (3 page report excluding calculation explanation)

I need a report as per the instruction

Also you need to fill in the missing information in the excel sheet


Make sure to explain the calculations in short ( calculations is not counted in page count)


Complete instruction goes below




FIN 330 

Overview: Corporate financial managers must have a business-wide perspective to successfully navigate the corporate environment. The skills you develop in this course will support you in your future business career as well as set the conceptual foundation for the future courses in your program. Your final project for FIN 330 will allow you to showcase your mastery of the varied skills a finance professional must obtain by requiring you to analyze a real-world corporation from a quantitative perspective while also investigating the challenges and decisions a manager must face.

In this milestone, you will continue to work on elements of Final Project I, the corporation valuation report.

Prompt: This milestone requires you to write a draft of the Capital Structure and Valuation sections (Sections III and IV) of Final Project I, the corporate valuation report. In this assignment, you will use the same corporation you focused on in Milestone One to expand upon the capital structure of the organization and the valuation of the corporation through forecasting.

Specifically, the following critical elements must be addressed in this milestone:

  1. Capital Structure: In the third section of your report, discuss the capital structure of the corporation.

    1. Outline the most recent year’s debt, equity, and total capital using the provided Excel template to show the overall capital structure of the

      corporation. Please note: to complete this, you will use the same template you used in support of Milestone One, but this time you will be

      completing the “Capital Structure” tab.

    2. Articulate the corporation’s dividend policy and what impact it has on the investors.

    3. Analyze the relationship between capital structure, cost of capital, and risk, using examples from your chosen organization.

    4. Explain how the relationship between capital structure, cost of capital, and risk can help inform decision making and maximize corporate value.

  2. Valuation: The final section of your report will focus on calculating current value, outlining assumptions, and estimating the future value of the corporation through forecasting the cash flows. Specifically, respond to the following:

    1. Calculate the current market value of equity for your corporation, using the three-year history and provided Excel template, and explain what it means for the corporation. You will submit this template along with your report, and may embed pieces of the Excel template into your report to help support your work in this section. Please note: this is the same template you used in support of Milestone One, but this time you will be completing the “Valuation” tab.

    2. Outline any assumptions you have made in calculating the current value and estimating the future value of the corporation, explaining why you made them and why they are important. (Hint: Assumptions can include growth rates, margins, trends, etc.)

    3. Estimate the current value of your corporation by forecasting the cash flows over 10 years using the provided Excel template, and explain your findings. Calculate EVA, NPV, IRR and MIRR using discount rates of 5% (low risk), 10% (medium risk), and 18% (high risk). 

Calculate the price of your order

550 words
We'll send you the first draft for approval by September 11, 2018 at 10:52 AM
Total price:
The price is based on these factors:
Academic level
Number of pages
Basic features
  • Free title page and bibliography
  • Unlimited revisions
  • Plagiarism-free guarantee
  • Money-back guarantee
  • 24/7 support
On-demand options
  • Writer’s samples
  • Part-by-part delivery
  • Overnight delivery
  • Copies of used sources
  • Expert Proofreading
Paper format
  • 275 words per page
  • 12 pt Arial/Times New Roman
  • Double line spacing
  • Any citation style (APA, MLA, Chicago/Turabian, Harvard)

Our guarantees

Delivering a high-quality product at a reasonable price is not enough anymore.
That’s why we have developed 5 beneficial guarantees that will make your experience with our service enjoyable, easy, and safe.

Money-back guarantee

You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.

Read more

Zero-plagiarism guarantee

Each paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.

Read more

Free-revision policy

Thanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.

Read more

Privacy policy

Your email is safe, as we store it according to international data protection rules. Your bank details are secure, as we use only reliable payment systems.

Read more

Fair-cooperation guarantee

By sending us your money, you buy the service we provide. Check out our terms and conditions if you prefer business talks to be laid out in official language.

Read more

Order your essay today and save 15% with the discount code GRADUATE