CITE YOUR SOURCES AND PARAPHRASE OR THE WHOLE GROUP WILL RECEIVE A ZERO FOR PLAGARISM. I have zero tolerance for plagiarism!!!
What is considered plagiarizing?
• Copying and pasting without proper citation.
• Copying and pasting large sections of the paper from other sources, even if it is properly sourced. You are expected to paraphrase.
1. You will be working on the same company as the previous project.
2. For this project you will turn in two items, the paper through turnitin and the excel sheet with the calculations.
You will be doing all your calculations in excel first and then the paper write-up.
EXCEL Submission
1. Obtain year-end financial statement information for your assigned company for the last three years. The statements should include the balance sheet, the income statement, and the statement of cash flows. Download this information from Morningstar.com. Please access Morningstar through Lindenwood database for ease of access and use.
The financial statement information is to be presented in a series of Excel Spreadsheets. (Excel spreadsheet Sheet 1)
2. Obtain year-end financial statement information for your company’s major competitor for the last three years. The statements should include the balance sheet, the income statement, and the statement of cash flows.
The financial statement information is to be presented in a series of Excel Spreadsheets. (Excel spreadsheet Sheet 2)
3. Calculate the financial ratios for each of the past three years in the manner shown in Chapter 3 or as close an approximation as you can, depending on available data. These ratios must be calculated for your company and the major competitor. These ratios are to be calculated by you from the financial statement information you gathered in Step 1. They are not to be cut-and-pasted from external sources. (Present all ratios in Excel spreadsheet Sheet 1 (for your company) and Sheet 2 (competitor)). The cells in the excel spreadsheet should have formulas in them so I can see that you calculated the ratios yourself)
The required ratios are those summarized in the illustration in Page 68 of the textbook (11thed). Calculate the following ratios:
• Current ratio, quick ratio, NWC to assets, and interval measure
• Inventory turnover, receivables turnover, fixed asset turnover, and total asset turnover
• Debt-equity ratio, equity multiplier, long-term debt ratio, and times interest earned ratio
• Profit margin, ROA, and ROE
• Price-earnings, PEG, Price-sales, and market to book
4. Once you have calculated the ratios, create graphs to illustrate the three-year trends in the ratios.
5. Calculate ROE using DuPont analysis for the past 3 years for your company and for your company’s competitor. (Present calculations in Excel spreadsheet Sheet 3)
Last Completed Projects
| topic title | academic level | Writer | delivered |
|---|