Finance Class

profilemalen28
TeamFProject_RatioWorksheet.xlsx
Home>Business & Finance homework help>Finance Class

Sheet1

Team:
Compiler Who will be the Compiler/Project Lead ? 2015 2014 2013
1 Student A Liquidity Current Ratio 0.97 0.51 0.51
2 Student A Liquidity Quick Ratio 0.28 0.12 0.13
3 Student B Activity Ratios Accounts Receivable Turnover 71.65 71.33 69.25
4 Student B Activity Ratios Inventory Turnover 8.09 7.98 8.04
5 Student B Activity Ratios Accounts Payable Turnover 6.23 6.26 5.96
6 Student C Profitability Returns Return on Equity % 0.20 0.21 0.23
7 Student C Profitability Returns Return on Assets% 0.08 0.08 0.09
8 Student C Profitability Returns Net Profit Margin % 0.03 0.03 0.04
9 Student C Profitability Returns Operating Profit Margin 0.03 0.03 0.04
10 Student D Financing Debt to Equity %
11 Student D Financing Debt to Assets %
12 Student D Financing Times Interest Earned
13 Student E Market Value Earnings per Share $ 1.16 1.15 1.23
14 Student E Market Value Price to Earnings ratio 8.62 7.83 6.5
Price per share $ 10.00 $ 9.00 $ 8.00
2015 2014 2013
14,000,000 shares outstanding each year

Use of three years of data (2013, 2014, and 2015). Enter ratio outcomes here and expand your comments in the final document - see the "Project Outline" document.

Assign Ratios to respective students, i.e. Student A, Student B, etc.: also need a compiler. This Excel spreadsheet needs to be completed and embedded in the final write up.

WalMart Analysis: This worksheet will support the findings presented in the final document: Compiler-Leader: Please embed in the final write up

Sheet2

Sheet3