Follow the materials I uploaded. I need finish Chap.2 and Chap.3. Also, the benchmark should be finished.It should be separately. If you have any questions, please let me know as soon as possible. Do not copy the draft of Chap.2 that I uploaded.
Strategy Capstone Instruction
This assignment is my Cap Stone, which the company I choice is “Goldman Sachs” I need finish Chap.2 and Chap.3. In this capstone, it should be no cheating and plagiarized. All of resources need citations. (13-15 pages for chap2; 17-20 pages for chap.3)
The file “Benchmark example” an Excel form for searching some dates in Chap2 and Chap 3. So it should be finished. For this form, I need find 3 companies, which they are competitors of “Goldman Sachs”. And then search the dates I needed. The “Benchmark example” is an example. I need to do a new “Benchmark excel”. I will show 2 pictures about how to work this file.
Those are dates I need in “Benchmark”
1. Liquidity Ratios: These ratios measure the firm’s ability to pay off its short-term debt.
• Current ratio= current assets/current liabilities
• Quick (Acid-Test) ratio=(current assets-inventory)/current liabilities
2. Activity Ratios: These ratios measure the firm’s ability to use its assets to generate sales
• Total Asset Turnover = sales/average total assets
• Inventory Turnover = cost of goods sold/average inventory
3. Debt Ratios: These ratios measure the firm’s ability to raise and pay off long-term debts
• Debt Ratio = total debts/total assets
• Equity Multiplier = total assets/total equity
• TIE (times interest earned) Ratio=EBIT (earnings before interest and taxes)/interest
4. Profitability Ratios: These ratios measure the firm’s ability to generate profits
• Net Profit Margin = net income/sales
• ROE = net income/total equity
• For firms that produce and/or sell a tangible product, it’s also useful to compare gross profit
margin, operating margin, and net profit margin.
5. DuPont Identity: The DuPont Identity analyzes ROE as a product of three other ratios identified above: operating efficiency (Net Profit Margin), asset use efficiency (Total Asset Turnover), and financial leverage (Equity Multiplier). The DuPont Identity is expressed like this:
ROE = Net Profit margin × Total asset turnover × Equity multiplier
For Chap.2, when working on those dates’ explanation should be showed as a “diagram”, then explain specific.
For the Chap.2 Guidelines, the data “CAGR” should be included. All of information and requirement all in the file “BUS SCE Guidelines”.