Instructions - REQUISITES REPORT
Please follow these instructions before you start to work in this report.
1- Be sure that you have read and understand the chapters 1 to S.
2- You must read at least the latest 3 years SEC 10K Reports from your company, especially the PART 1 section business description, risk and legal events. (Report 1 would help you in this issue)
3- You must have the latest 5 years SEC 10K Reports from your company, you can access YahooFinance or the company official site.
Requisites for this second report. You most turn in two files, one excel file and one word document. Below are the instructions for each file.
Excel File Instructions
1- Attach you have one excel file that is called FinSAS Clean Example.XLS, download the file and rename the file with the ticker of your company, if your company is Walmart, then the name of the file is WMT.XLS the ticker had sent to you from your professor at the beginning of the semester.
2- Open the new renamed file then READ the instructions TAB. Don't plug in any number if you haven't read the instructions first.
3- The excel file has a TAB called INPUT, you must enter the data of the income statement (IS) and balance sheet (BS), you must use the SEC 10K Report information from the last five years.
- Be careful about how you enter the financial data, sometimes on the excel file, net sales mean's total revenues for your company, or your company is a service company that does not need inventory, at the end all concepts either are equal or similar in terms of concept descriptions.
- Also be careful about positives and negatives numbers, for example on the excel file expenses are subtracted from the income or cost, but your company may use negative number so you need to be aware about double subtraction or summarization.
- At the end, both statements, IS and BS should be exactly the same as is shown in their respective SEC 10K Reports. Each error is penalized.
- Be completely sure that the Balance Sheet is balanced, or that Assets equals Liabilities and Equity for every fiscal year. This is the most important accounting equation so errors at this level are also penalized.
- Also you need to create or insert one TAB named NOTES and you must include the notes to the financial Statement's from the 10k report, yes BS and IS NOTES.
4- There is one additional section that you at this point will leave almost in blank, this section is called OTHER DATA on the INPUT TAB row 104. From this section the only required data is the ROW 118 Cash Flow from Operations, you will find this information on the Cash Flow Statement from your company, specifically cash flow from operations activities. After you entered all the financial data, automatically you must have the calculations for the vertical, horizontal and ratios.
5- Once you have entered the BS and IS, you will have the output tabs, Vertical, Horizontal and Ratios AVG or END analysis. These tabs are going to be the raw material for the word document and Ratio Conclusions.
Your report should include the following sections:
1- Balance Sheet.
Make a report where you can conclude about the link between the Business Strategy Analysis reading on the business section part 1 from the 10K's reports and how the company use the Resources (Assets) and how those resources are financed (Liabilities) to expand the operations during the last 5 years. Are the resources and finances aligned to the firm Strategy? What is the best balance sheet for my company using the current strategy as a context?
2- Income Statement.
Include in your report where you can conclude about company cash cow product, it means your most important service or product from your company. In terms of margins, in terms of sales, in terms of volume, in terms of those product or services that provide or increase substantially the PROFITS or GROSS MARGIN. Explore this question what's the best IS for my company using the current strategy as a context? In other words have the strategic decisions from the past translated into better income statement for my company? Explore these variables or questions, Have my company increased sales, inventories and account receivables at the same velocity? Have my suppliers helped me in these operations increments? Have my company operated better the business? Have my products and services improved the efficiency in terms of my competitors?
Attachment:- Assignment Files.rar