Unit 6 Assignment Final Project - Ratio Calculations

profilebrandon282011
AC216FinalProjectRatioAnalsyis4.xlsx

Ratio Calculations

Ratio Analysis (enter the year of the company's most recent financial report)
Company
2017
marsha baker: Enter the year for the company's most recent financial reports
2016 2015
Liquidity Ratios CURRENT RATIO: Current assets 15 20 25
Current liabilities
QUICK RATIO: Cash + ST investments + receivables
Current liabilities
Debt ratios DEBT TO TOTAL ASSETS: Total debt
Total assets
DEBT TO TOTAL EQUITY: Total debt
Total equity
TIMES INTEREST EARNED: Income before tax and interest
Interest charges
Mangement ratios ACCOUNTS RECEIVABLE TURNOVER: Net credit sales
Average net accounts receivable
INVENTORY TURNOVER: Cost of goods sold
Average inventory
Profitabilty ratios NET PROFIT ON SALES: Net income
Net sales
GROSS PROFIT MARGIN Gross profit
Net sales
RETURN ON ASSETS: Net income + interest
Average assets
RETURN ON EQUITY: Net income - preferred dividends
Average common equity
BOOK VALUE: Common equity
Common shares
Market ratios EARNINGS PER SHARE: Income available to common
Average number of shares
PRICE EARNINGS: Market price per share
Earnings per share
DIVIDEND RATE/YIELD: Annual cash dividend per share
Market price per share
DIVIDEND PAYOUT RATIO: Annual cash dividend per share
Earnings per share
2,928.00
4,600.00
4,600.00
-8
4,592.00
4,592.00
3.62%
3.75
3.74
3.74
0.9
Page 26
4-Mar-19
866-541-3770
HOOVERS.COM

Ratio Summary

Ratio Analysis
Company 0 3 year % change Copy this spreadsheet into your paper
2017 2016 2015 as exhibit 1
CURRENT RATIO: 15 20 25 40%
QUICK RATIO: 0 0 0 ERROR:#DIV/0!
DEBT TO TOTAL ASSETS: 0 0 0 ERROR:#DIV/0!
DEBT TO TOTAL EQUITY: 0 0 0 ERROR:#DIV/0!
TIMES INTEREST EARNED: 0 0 0 ERROR:#DIV/0!
ACCOUNTS RECEIVABLE TURNOVER: 0 0 0 ERROR:#DIV/0!
INVENTORY TURNOVER: 0 0 0 ERROR:#DIV/0!
NET PROFIT ON SALES: 0 0 0 ERROR:#DIV/0!
GROSS PROFIT MARGIN 0 0 0 ERROR:#DIV/0!
RETURN ON ASSETS: 0 0 0 ERROR:#DIV/0!
RETURN ON EQUITY: 0 0 0 ERROR:#DIV/0!
BOOK VALUE: 0 0 0 ERROR:#DIV/0!
EARNINGS PER SHARE: 0 0 0 ERROR:#DIV/0!
PRICE EARNINGS: 0 0 0 ERROR:#DIV/0!
DIVIDEND RATE/YIELD: 0 0 0 ERROR:#DIV/0!
DIVIDEND PAYOUT RATIO: 0 0 0 ERROR:#DIV/0!