AutoSave OFF HES Project 2 Home Insert Draw Page Layout Formulas Data Review View Developer Tell me Share Comments Calibri (Body) ab Insert v vi X LO v 11 General Conditional Formatting Format as Table Cell Styles 48-0- 3 WEX -X Delete v Paste B I U A $ % ) S S Ideas .00 0 Sort & Filter Sensitivity Format v Find & Select J6 fx Current Assets A B c D E G H 1 L M N P R s T V w CAPTAIN JET INC. BALANCE SHEET 15,438 (50) CAPTAIN JET INC. INCOME STATEMENT FOR THE YEAR ENDED DECEMBER 31, 2014 31 Dec 14 31-Dec 13 15,388 Current Assets Cash 4,723 10,665 19,031 5,150 6,850 5.000 68 Retained Earnings, Beginning Net Income/Loss Dividends Payment Retained Earnings, End of th 1,519 5,685 313 1,781 788 (100) 19,254 17,130 163 3 FOR THE YEAR ENDED DECEMBER 31, 2014 4 Sales Revenue 5 Less: Sales Return 6 Net Sales 7 Cost of Goods Sold 8 Gross Profit 9 Utilities Expenses 10 Salary and Wages Expenses 11 Rent Expenses 12 Depreciation Expenses 13 Interest Expenses 14 Supplies Expenses 15 Bad Debt Expenses 16 Total Operating Expenses 17 Earnings before Income Taxes 18 Income Tax Expenses 19 Earnings after income Taxes 20 21 22 23 24 25 26 27 28 29 30 31 32 10,500 7.055 5,052 68 500 23,307 0 0 0 6,375 5.688 0 48,875 125.219) 10,300 354 Accounts Receivable Inventories Prepaid insurance Prepaid Rent Total Current Assets Non Current Assets Long term investments Investments in equity securities Land held for future development Property, plant, and Equipment Buildings Less: Accumulated Depreciation Intangible Assets Capitalized Development Costs Goodwill Other identifiable intangible Assets Total Non Current Assets Total Assets 0 6,375 5,658 0 47,000 31 333 1,000 1,000 9,500 6,000 52,125 69.255 0 9,500 6,000 52,219 75,526 o 0 6,688 188 225 1,500 1,086 825 196 10.668 0 188 1,500 1055 35 7,755 0 13,750 15,000 Current Liabilities Accounts payable Salary and Wages Payable Interest Payable es Unearned Revenue Income Tax payable Property taxes payable Utilities payable Total Current Liabilities Non Current Liabilities Notes payable Provisions Related to Pensions Bonds Payable Total Non Current Liabilities Total Liabilities Stockholders' Equity Common Stock ($10 par, 11,000 and 10,000 shares) Preferred Stock (5% dividend, $100 par values, 1050 and 1000 sh Paid in capital. Common Stock Paldin capital - Preferred Stock Retained Earnings Accumulated Other Comprehensive income Less: Treasury Stock Total Stockholders' Equity Total Liabilities and Stockholders' Equity 37 38 39 40 41 42 0 13,750 21,SOS 44 45 45 47 48 49 SO 51 52 15,000 25,668 o 13,750 13,125 3,438 1,250 19,254 625 (1.594) 49,856 75,526 12,500 12,500 3,438 1,250 19,031 625 (1,594 47.750 69.255 FS's Ratios Projected FS + + Select destination and press ENTER or choose Paste + 75% A B Calculate the following ratios for year 2014 (round all ratios to two places behind the decimal): 1 Working capital 2 Current ratio 3 Acid test ratio 4 Accounts receivable turnover (use net sales as numerator) 5 Collection period of receivables (use 360 days in each year) 6 Accounts payable turnover ratio 7 Inventory turnover ratio 8 Days to sell inventory 9 Debt-to-Equity ratio 10 Times interest earned = 11 RNOA (assume 12% tax rate) 11 12 ROCE