Homework
Competency
Estimates future financial outcomes using discounted cash flow analysis.
Comprehensive Financial Statement Problem
Complete the second part of the final demonstration of mastery related to Competency 2 content; using the financial statement for selected company, analyze discounted cash flow and net present value; complete a forecasting analysis for five years.
a. For the company you used in Competency 1 (Khols) , calculate the data necessary to analyze the discounted cash flow and the net present value.
b. Complete a five-year financial forecast for the company.
c. Present this data so that corporate leaders, stockholders, and the public can understand it. This should be in both numeric/table and graph (such as bar graphs, histograms, etc.) form.
• For assistance on creating graphs and charts in Excel, please see one of the following tutorials
o Excel - Create a chart from start to finish (Links to an external site.)
o Excel 2016 - Charts (Links to an external site.)
d. How does this data add to the story from Competency 1? What new information did you learn about the company? How does this add to or change the ideas you have about the company's financial status? What suggestions do you have for the company for moving forward.
Format your homework according to the give formatting requirements:
a. The answer must be double spaced, typed, using Times New Roman font (size 12), with one-inch margins on all sides.
b. The response also includes a cover page containing the title of the homework, the course title, the student's name, and the date. The cover page is not included in the required page length.
c. Also include a reference page. The references and Citations should follow APA format. The reference page is not included in the required page length.