| CALCULATING RATIOS |
| Lake of Eqypt Marina Inc. |
| Balance sheet as at December 31,2015 and 2014 |
| (in million of dollars |
| | 2015 | % | 2014 | % |
| Current Assets |
| Cash and marketable securities | 75 | 8% | 65 | 8% |
| Accounts Receivable | 115 | 13% | 110 | 14% |
| Inventories | 200 | 22% | 190 | 24% |
| Total Current Assets | 390 | 43% | 365 | 46% |
| Fixed Assets |
| Gross Plant and Equipment | 580 | 64% | 471 | 60% |
| Less: Depreciation | 110 | 12% | 100 | 13% |
| Net Plant and equipment | 470 | 52% | 371 | 47% |
| Other Long term Assets | 50 | 5% | 49 | 6% |
| Total Fixed Assets | 520 | 57% | 420 | 54% |
| Total Assets | 910 | 100% | 785 | 100% |
| Current Liabilities |
| Accrued Wages and Taxes | 40 | 4% | 43 | 5% |
| Account Payable | 90 | 10% | 80 | 10% |
| Notes Payable | 80 | 9% | 70 | 9% |
| Total | 210 | 23% | 193 | 25% |
| Long term debt | 300 | 33% | 280 | 36% |
| Stockholders equity |
| Preferred Stock (5 million shares) | 5 | 1% | 5 | 1% |
| Common stock and paid in surplus (65 million in shares) | 65 | 7% | 65 | 8% |
| Retained earnings | 330 | 36% | 242 | 31% |
| Total | 400 | 44% | 312 | 40% |
| Total Liabilities & Equity | 910 | 100% | 785 | 100% |
| Lake of Egypt Marina, Inc. |
| Income Statement for Years Ending December 31, 2015 and 2014 |
| (In million of Dollars) |
| | 2015 | % | 2014 | % |
| Income Statement |
| Net Sales (all credit) | 515 | 100% | 432 | 100% |
| Less: Cost of Goods Sold | 230 | 45% | 175 | 41% |
| Gross Profit | 285 | 55% | 257 | 59% |
| Less: other operating expenses | 30 | 6% | 25 | 6% |
| Earnings before interest, taxes, depreciation and amortization (EBITDA) | 255 | 50% | 232 | 54% |
| Less: Depreciation | 22 | 4% | 20 | 5% |
| Earnings before interest, taxes (EBIT) | 233 | 45% | 212 | 49% |
| Less: Interest | 33 | 6% | 30 | 7% |
| Earnings before taxes (EBT) | 200 | 39% | 182 | 42% |
| Less: Taxes | 57 | 11% | 55 | 13% |
| Net Income | 143 | 28% | 127 | 29% |
| Less: Preferred stock dividends | 5 | 1% | 5 | 1% |
| Net Income available to common stockholders | 138 | 27% | 122 | 28% |
| Less: Common stock dividends | 65 | 13% | 65 | 15% |
| Addition to retained earnings | 73 | 14% | 57 | 13% |
| Per Share Data: |
| Earnings per Share (EPS) | $2.12 | | $1.88 |
| Dividends per Share (DPS) | $1.00 | | $1.00 |
| Book value per Share | $6.08 | | $4.72 |
| Market value per share (MVPS) | $14.75 | | $12.55 |
piedra25
wrong_result_to_fix.xlsx
