Use the following financial statements for Lake of Egypt Marina, Inc. |
LAKE OF
EGYPT MARINA, INC Balance Sheet as of December 31, 2015 and 2014 (in millions of dollars) |
||||||||||||
2015 | 2014 | 2015 | 2014 | |||||||||
Assets | Liabilities and Equity | |||||||||||
Current assets: | Current liabilities: | |||||||||||
Cash and marketable securities | $ | 44 | $ | 42 | Accrued wages and taxes | $ | 28 | $ | 30 | |||
Accounts receivable | 36 | 36 | Accounts payable | 32 | 36 | |||||||
Inventory | 153 | 63 | Notes payable | 36 | 42 | |||||||
Total | $ | 233 | $ | 141 | Total | $ | 96 | $ | 108 | |||
Fixed assets: | Long term debt: | 51 | 90 | |||||||||
Gross plant and equipment | $ | 212 | $ | 186 | Stockholders’ equity: | |||||||
Less: Depreciation | 65 | 45 | Preferred stock (3 million shares) | $ | 3 | $ | 3 | |||||
Common stock and paid-in surplus (21 million shares) |
21 | 21 | ||||||||||
Net plant and equipment | $ | 147 | $ | 141 | Retained earnings | 229 | 78 | |||||
Other long-term assets | 20 | 18 | ||||||||||
Total | $ | 167 | $ | 159 | Total | $ | 253 | $ | 102 | |||
Total assets | $ | 400 | $ | 300 | Total liabilities and equity | $ | 400 | $ | 300 | |||
LAKE OF EGYPT MARINA, INC. Income Statement for Years Ending December 31, 2015 and 2014 (in millions of dollars) |
|||||
2015 | 2014 | ||||
Net sales (all credit) | $ | 500 | $ | 300 | |
Less: Cost of goods sold | 180 | 105 | |||
Gross profits | $ | 320 | $ | 195 | |
Less: Other operating expenses | 30 | 15 | |||
Earnings before
interest, taxes, depreciation, and amortization (EBITDA) |
290 | 180 | |||
Less: Depreciation | 20 | 12 | |||
Earnings before interest and taxes (EBIT) | $ | 270 | $ | 168 | |
Less: Interest | 20 | 18 | |||
Earnings before taxes (EBT) | $ | 250 | $ | 150 | |
Less: Taxes | 75 | 45 | |||
Net income | $ | 175 | $ | 105 | |
Less: Preferred stock dividends | $ | 3 | $ | 3 | |
Net income available to common stockholders | $ | 172 | $ | 102 | |
Less: Common stock dividends | 21 | 21 | |||
Addition to retained earnings | $ | 151 | $ | 81 | |
Per (common) share data: | |||||
Earnings per share (EPS) | $ | 8.190 | $ | 4.857 | |
Dividends per share (DPS) | $ | 1.000 | $ | 1.000 | |
Book value per share (BVPS) | $ | 11.905 | $ | 4.714 | |
Market value (price) per share (MVPS) | $ | 15.250 | $ | 13.050 | |
Calculate the following ratios for Lake of Egypt Marina, Inc. as of year-end 2015. (Use sales when computing the inventory turnover and use total equity when computing the equity multiplier. Round your answers to 2 decimal places. Use 365 days a year.) |
LAKE OF EGYPT MARINA, INC. | |||
a. | Current ratio | 2.43 times | |
b. | Quick ratio | 0.83 times | |
c. | Cash ratio | 0.46 times | |
d. | Inventory turnover | 3.27 times | |
e. | Days’ sales in inventory | 111.69 days | |
f. | Average collection period | days | |
g. | Average payment period | days | |
h. | Fixed asset turnover | times | |
i. | Sales to working capital | times | |
j. | Total asset turnover | times | |
k. | Capital intensity | times | |
l. | Debt ratio | % | |
m. | Debt-to-equity | times | |
n. | Equity multiplier | times | |
o. | Times interest earned | times | |
p. | Cash coverage | times | |
q. | Profit margin | % | |
r. | Gross profit margin | % | |
s. | Operating profit margin | % | |
t. | Basic earnings power | % | |
u. | ROA | % | |
v. | ROE | % | |
w. | Dividend payout | % | |
x. | Market-to-book ratio | times | |
y. | PE ratio | times | |
A)CURRENT RATIO=current asset÷current liability
Current asset=44+36+153
=$233
Current liability=28+32+36
=$96
So currennt ratio=233÷96
=2.43 times
B)quick ratio=quick asset ÷current liability
Quick asset = current asset -inventory-prepaid expense
Quick asset=233-153(there is no prepaid expenses)
=80
Current liability=28+32+36
=96
So quick ratio=80÷96
=.83 times
C)cash ratio= cash equivalant+cash÷current liability
=44÷96
=.46times
D)inventory turn over ratio= sale÷average inventory(as per the question)
Sale= 500
Average inventory=opening stock +closibg stock ÷2
Average stock=153(because here we didnt give the opening stock,let asume closing stock as the average stock)
Then inventory turnover ratio=500÷153
=3.27 times
E)day sales in inventory=365÷inventory turn over ratio
Invetory turnover ratio=3.27(answer 3)
So day sales in inventory=365÷3.27
=11.67 times
Get Answers For Free
Most questions answered within 1 hours.