I'm working on a finance case study and need support to help me understand better.
Please Complete assignment ... Follow all guideline and and complete detailed analysis
Any question please ask in message box. Thank you
send word doc and excel files
also there a file that shows what the case shouldn't look like and phrases it shouldnt contain
What Your Case Analysis Should NOT Look like or Contain. If it does, you will get a ZERO for the case analysis I. Paragraphs, Margins and Tables 1. Examples of Poor Paragraph Structures: 2. 3. 4. Paper needs to be Fully Justified. Note the jagged right margin here. 5. Figures, Tables, Charts and Graphs should be: 1. Labeled and numbered. 2. Must not contain Excel Gridlines or Excel syntax errors. 3. Columns and Rows should be aligned. Example: This table is properly labeled and numbered. The columns are lined-up with the numbers. Lastly, there are no excel gridlines in the table. No Excel gridlines Table is labeled and numbered. Column labels and numbers are aligned. Metrics to quantify trends II. General Case Study Errors Paper Characteristics that Guarantee an Automatic ZERO. 1. Papers that simply restate the case without any type of analysis. 2. Those papers that do not follow the specific case format. 3. Those papers that have unlabeled tables and graphs. 4. Those papers where tables and graphs take up the ENTIRE page. 5. Those papers that do not make a recommendation. Or, papers in which the recommendation is NOT supported by the quantitative and qualitative analysis. 6. Those papers that DO NOT provide REASONABLE alternative solutions with some explanation. 7. Papers that have similar graphs, tables and language only in reverse order or scrambled with the absurd belief that it will not be noticed. 8. Papers that are DOUBLE Spaced and not SINGLE SPACED. 9. Papers in which the case analysis turned in is simply just the case copied over. 10. Papers where a SINGLE paragraph takes up the entire page. 11. Papers without subheadings to break-up the text and increase readability. Thus, there is a “sea” of text on the page. 12. Papers that include up to date research. As noted below, cases are to be completed as of the time period of the case. III. Language usage that is not acceptable in the context of the case. Expressions that should not be used when writing up a case analysis. 1. Table 5 shows….Point: Tables do not show. 2. As you can see…Point: who can see? 3. Table 7 indicates…Tables do not indicate 4. The numbers have gone up a lot….. 5. The numbers have gone down a lot….. 6. As you can see, the ratio is increasing … 7. 6. As you can see, the ratio is decreasing …. 8. I would… 9. The number shows….point: numbers do not show 10. The number is increasing… 10. The numbers in the table show… 11. In my opinion… 12. I believe…I think…I am… 13. Only a small difference between the numbers… 14. Not a large difference between the numbers… 15. It is a huge… 16. The number is increasing … III. Sample Case Write Ups of Data in Tables. Case Analysis Sample Data Tables Sample Analysis: Sales is increasing at a CAGR of 74.8% while the gross margin is increasing at a CAGR of 2.1%. The implication of the trend is that COGS has not rapidly increased. See Table 1 above. Furthermore, the stability of COGS is also indicated with an average gross margin 49.9% and 2.2% percentage increase for the 4 year period. In contrast, sales have increased by 142.5% for the 4 year period with an average increase of 8.3% per year implying strong demand for the firm’s products. 2. Liquidity Ratio Trends Sample Analysis: The current ratio is declining at a negative 3.31% CAGR with a negative 4.39% change for the 4 year period. The average current ratio value is 17.8 for the 4 year period which implies a high level of current assets. See Table 3 above. The quick ratio is declining at a negative 16.65% CAGR and an average negative percentage change of 8.83% for the 4 year period. The decline in the quick ratio relative to the current ratio suggests the firm is carrying a large amount of inventory on its balance sheet. The implication is that the firm’s liquidity position is not good. The cash ratio has declined at a negative 60.98% CAGR and a negative 21.2% change over the time period.