financial analysis and planning report

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%