Reference no: EM131291944
Use the following financial statements for Lake of Egypt Marina, Inc. LAKE OF EGYPT MARINA, INC Balance Sheet as of December 31, 2012 and 2011 (in millions of dollars) 2012 2011 2012 2011 Assets Liabilities and Equity Current assets: Current liabilities: Cash and marketable securities $ 75 $ 65 Accrued wages and taxes $ 40 $ 43 Accounts receivable 115 110 Accounts payable 90 80 Inventory 200 190 Notes payable 80 70 Total $ 390 $ 365 Total $ 210 $ 193 Fixed assets: Long term debt: 300 280 Gross plant and equipment $ 580 $ 471 Stockholders’ equity: Less: Depreciation 110 100 Preferred stock (5 million shares) $ 5 $ 5 Common stock and paid in surplus (65 million shares) 65 65 Net plant and equipment $ 470 $ 371 Retained earnings 330 242 Other long term assets 50 49 Total $ 520 $ 420 Total $ 400 $ 312 Total assets $ 910 $ 785 Total liabilities and equity $ 910 $ 785 LAKE OF EGYPT MARINA, INC. Income Statement for Years Ending December 31, 2012 and 2011 (in millions of dollars) 2012 2011 Net sales (all credit) $ 515 $ 432 Less: Cost of goods sold 230 175 Gross profits $ 285 $ 257 Less: Depreciation 22 20 Other operating expenses 30 25 Earnings before interest and taxes (EBIT) $ 233 $ 212 Less: Interest 33 30 Earnings before taxes (EBT) $ 200 $ 182 Less: Taxes 57 55 Net income $ 143 $ 127 Less: Preferred stock dividends $ 5 $ 5 Net income available to common stockholders $ 138 $ 122 Less: Common stock dividends 65 65 Addition to retained earnings $ 73 $ 57 Per (common) share data: Earnings per share (EPS) $ 2.123 $ 1.877 Dividends per share (DPS) $ 1.000 $ 1.000 Book value per share (BVPS) $ 6.077 $ 4.723 Market value (price) per share (MVPS) $ 14.750 $ 12.550
Calculate the following ratios for Lake of Egypt Marina, Inc., as of year-end 2012. (Use sales when computing the inventory turnover and use common stockholders' 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 times b. Quick ratio times c. Cash ratio times d. Inventory turnover times e. Days’ sales in inventory 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. Basic earnings power % s. ROA % t. ROE % u. Dividend payout % v. Market-to-book ratio times w. PE ratio times.
Value of cash and marketable securities
: Mandesa, Inc., has current liabilities of $8 million, current ratio of 2 times, inventory turnover of 12 times, average collection period of 30 days, and credit sales of $64 million. Calculate the value of cash and marketable securities.
|
Determine the correct inventory amount
: Umatilla Bank and Trust is considering giving Pronghorn Corp a loan. Before doing so, it decides that further discussions with Pronghorn Corp’s accountant may be desirable. Determine the correct inventory amount on December 31.
|
Use the information to complete the balance sheet
: Use the following information to complete the balance sheet below. Sales are $8.8 million, capital intensity ratio is 2.10 times, debt ratio is 55 percent, and fixed asset turnover is 1.2 times.
|
Calculate the inventory turnover
: Suppose at December 31 of a recent year, the following information (in thousands) was available for sunglasses manufacturer Oakley Inc.: ending inventory $167,228; beginning inventory $112,286; cost of goods sold $380,216 and sales revenue $689,374. ..
|
Assets liabilities and equity current assets
: Use the following financial statements for Lake of Egypt Marina, Inc. LAKE OF EGYPT MARINA, INC Balance Sheet as of December 31, 2012 and 2011 (in millions of dollars) 2012 2011 2012 2011 Assets Liabilities and Equity Current assets: Current liabilit..
|
Chart of accounts for exact wording of account titles
: On the first day of the fiscal year, a company issues $35,000, 9%, five-year installment notes that have annual payments of $8,998. The first note payment consists of $3,150 of interest and $5,848 of principal repayment. Journalize the following tran..
|
Calculate the times interest earned ratio
: Sales are $1.5 million, cost of goods sold is $600,000, depreciation expense is $150,000, other operating expenses is $300,000, addition to retained earnings is $146,250, dividends per share is $1, tax rate is 30 percent, and number of shares of comm..
|
Journalize the redemption of the bonds
: On December 31, a $1,850,000 bond issue on which there is an unamortized discount of $74,900 is redeemed for $1,799,500. Journalize the redemption of the bonds.
|
General building supplies to building contractors
: Carter Lumber sells lumber and general building supplies to building contractors in a medium-sized town in Montana. Data regarding the store's operations follow: o Sales are budgeted at $380,000 for November, $390,000 for December, and $400,000 for J..
|