v:* {behavior:url(#default#VML);}
o:* {behavior:url(#default#VML);}
w:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
Normal
0
false
false
false
false
EN-US
X-NONE
X-NONE
/* Style Definitions */
table.MsoNormalTable
{mso-style-name:”Table Normal”;
mso-tstyle-rowband-size:0;
mso-tstyle-colband-size:0;
mso-style-noshow:yes;
mso-style-priority:99;
mso-style-parent:””;
mso-padding-alt:0cm 5.4pt 0cm 5.4pt;
mso-para-margin:0cm;
mso-para-margin-bottom:.0001pt;
mso-pagination:none;
font-size:11.0pt;
font-family:”Calibri”,sans-serif;
mso-ascii-font-family:Calibri;
mso-ascii-theme-font:minor-latin;
mso-hansi-font-family:Calibri;
mso-hansi-theme-font:minor-latin;
mso-bidi-font-family:”Times New Roman”;
mso-bidi-theme-font:minor-bidi;}
Overview: The final project for this course is the creation of a financial analysis and planning report, including a presentation to the executive management team. For Milestone Two, submit a draft of your financial projections (Component 1: Section III).
Project the next three year’s financial statements and free cash flows. Using the projected cash flows, use the cost of capital as a discounting rate to obtain the present value of the firm. Analyze the projections compared to the current market value of the firm.
Prompt: Milestone Two should contain the following sections:
III. Projections: Based on the company’s financial statements, your analysis, and any additional evidence, project the company’s performance for the next three years. Are there any areas of concern? Is the company in good financial shape for moving forward? Discuss a best-case, worst-case, and most likely scenario, including a sustainable growth rate for sales based on existing financial statements and any macroeconomic and financial market conditions that might impact the firm’s strategic objectives. You must thoroughly address the assumptions behind your predictions, supported by spreadsheet calculations. At a minimum, your analysis must cover:
A. Weight of equity
B. Weight of debt
C. Cost of debt
D. Cost of equity
E. Tax rate
F. Value of the company’s stock compared to your forecasted value and free cash flow
Guidelines for Submission: Your draft must contain all of the elements listed above. It should be at least 5 pages in length (excluding the title page, references, supporting calculations, and appendices) and should follow APA guidelines. You must include calculations and appropriate graphs, tables, references, and other appendices as needed to support your written analysis. Cite your sources within the text of your paper and on the reference page.
Critical Elements |
Proficient (100%) |
Not Proficient (0%) |
Value |
Weight of Equity |
Calculations are complete and analysis is comprehensive |
Does not include both calculations and analysis |
12 |
Weight of Debt |
Calculations are complete and analysis is comprehensive |
Does not include both calculations and analysis |
12 |
Cost of Debt |
Calculations are complete and analysis is comprehensive |
Does not include both calculations and analysis |
12 |
Cost of Equity |
Calculations are complete and analysis is comprehensive |
Does not include both calculations and analysis |
12 |
Tax Rate |
Calculations are complete and analysis is comprehensive |
Does not include both calculations and analysis |
12 |
Stock Value |
Calculations are complete and analysis is comprehensive |
Does not include both calculations and analysis |
12 |
Best-Case, Worst-Case, Most Likely Scenario |
Discusses best-case, worst-case, and most likely scenario and considers sustainable growth rate and macroeconomic and financial market conditions |
Does not discuss best-case, worst-case, and most likely scenario |
18 |
Articulation of Response |
Submission is free of errors related to citations, grammar, spelling, syntax, and organization and is presented in a professional and easy-to-read format |
Submission has critical errors related to citations, grammar, spelling, syntax, or organization that prevent understanding of ideas |
10 |
Total |
100% |