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

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

A. 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.

B. Articulate the corporation's dividend policy and what impact it has on the investors.

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

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

IV. 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:

A. 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.

B. 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.)

C. Estimate the current value of your corporation by forecasting the cash flows over five years using the provided Excel template, and explain your findings. Calculate EVA, NPV, IRR and MIRR.

Please provide help as how to complete the "Capital Structure" tab and "Valuation" tab of the excel sheet the yellow portions