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
Make sure NO PLAZIARISM
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:
Capital Structure: In the third section of your report, discuss the capital structure of the corporation.
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.
Articulate the corporation’s dividend policy and what impact it has on the investors.
Analyze the relationship between capital structure, cost of capital, and risk, using examples from your chosen organization.
Explain how the relationship between capital structure, cost of capital, and risk can help inform decision making and maximize corporate value.
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:
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.
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.)
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).
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.
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
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
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
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
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