You are a new credit analyst at Community Bank. You’ve been given an opportunity to show what you learned and demonstrate your expertise using Excel. You’ve been given the attached hard copy financial statements found below. Your boss has asked you to:
Spread them in Excel, that means to enter them into a usable and dynamic format. Use formulas to calculate subtotals and totals where appropriate.
1. Provide a trend analysis for 2013, that means year over year changes.
2. Provide a common sized statement for 2013 only, the following ratios:
3. Calculate and report the following ratios for 2013:
4. Net Working Capital
5. Current Ratio
6. Accounts Receivables Turnover
7. Inventory Turnover
8. Gross Profit Margin
9. Operating Profit margin
10. Net Profit Margin
That is all you know. The format and methodology are up to you. You will be evaluated for your next big promotion on demonstration of your use of excel, professional formatting, and calculation of ratios. Your boss insists that all your work is done in Excel and that she is able to follow your methodology.
She only wants one Excel workbook as your work product.