2017 | 2016 | ||
Cash and marketable securities (55*0.2) | 11.00 | 20.00 | Total assets = Total liabilities+Equity = 115 |
Accounts receivable = 55*1-11 = | 44.00 | 34.00 | which is given. |
Inventory | 22.00 | 26.00 | Next find current assets = Current liabilities*Current ratio = 55*1.4 = 77 |
Current assets (55*1.4) | 77.00 | 80.00 | Further, cash = Current liabilities*0.2 = 55*0.2 = 11 |
Fixed assets (115-77) | 38.00 | 25.00 | Quick assets = Current liabilities*1 = 55 |
Total assets | 115.00 | 105.00 | Accounts receivable = 55-cash = 55-11 = 44 |
Inventory = 77-11-44 = 22 | |||
Notes payable | 25.00 | 20.00 | Sales and COGS calculations are given. |
Accounts payable | 30.00 | 35.00 | Equity = beginning balance+Net income = 30+5.63 |
Current liabilities | 55.00 | 55.00 | Long term debt = 115-53.63-55 |
Long term debt | 6.38 | 20.00 | |
Equity = (30.00+23.63) | 53.63 | 30.00 | |
Total liabilities+Equity | 115.00 | 105.00 | |
Sales | 195.00 | ||
COGS | 120.00 | ||
Other costs | 10.00 | ||
Depreciation | 20.00 | ||
EBIT | 45.00 | ||
Interest (45/8) | 5.63 | ||
Earnings before tax | 39.38 | ||
Tax | 15.75 | ||
Net income | 23.63 | ||
WORKING NOTES FOR INCOME STATEMENT FIGURES: | |||
Sales = Average receivables*365/73 = 39*365/73 = | 195 | ||
COGS = Average inventory*5 = 24*5 = | 120 |
how to get the numbers [2] Financial ratios (58 points) Find the missing values on the...
[2] Financial ratios (58 points) Find the missing values on the balance sheet and the income statement of Pensacola Railroads (in S millions). Start with the balance sheet, and then continue with the income statement. You can use the following ratios: NOTE: USE AVERAGE RECEIVABLES AND INVENTORY Debt Ratio loterest Coverage Ratio CurreatRatio Quick Ratio Cash Ratio 0.4 1.4 0.2 Average Collection Period (average receivables) Tax rate 73 das 40% Marks: 28 for balance sheet, 30 for income statement. Balance...
2. Calculating Financial Ratios [LO2] Find the following financial ratios for Smolira Golf Corp. for 2018 (year-end figures reflect average values where appropriate): Assets Current assets Cash Accounts receivable Inventory Total SMOLIRA GOLF CORP. 2018 Balance Sheets Liabilities and Owners' Equity 2018 2018 Current liabilities $ 37,837 Accounts payable $ 42,582 27,766 Notes payable 16,200 42.632 Other 24 634 108,235 Total 83,416 145,000 Long-term debt Owners' equity Common stock and paid-in surplus Retained earnings Total Equity Total liabilities and owners'...
Below are numbers from a balance sheet and income statement. Construct the financial ratios requested below. Sales 499891 Operating Costs 359935 Depreciation 10000 Interest Expense 5000 Tax Expense 29408 Cash 1000 Receivables 30000 Inventories 59989 Fixed Assets, Net 50000 Payables 11000 Accrued Expenses 10000 Long-Term Loan 50000 Common Equity 69989 Prepare an income statement and a balance sheet for is company using the information provided. Calculate: 1. Current ratio 2. Quick ratio 3. NWC-to-total-Assets (Working capital to assets) 4. Ratio...
Use the attached Income Statement and Balance Sheet to compute the required financial ratios for Seward Inc. and compare to the industry averages. After that, write a brief summary as to what each ratio is measuring and how Seward compares to the industry. For example, you may find that Seward's Inventory Turnover is not as high as the industry average, so they are either not managing their inventories or may be experiencing a decrease in sales. Seward Industries a. Compute...
26. Calculating Financial Ratios (LO2] Find the following financial ratios for Smolira Golf Corp. (use year-end figures rather than average values where appropriate): Assets 2017 2018 Short-term solvency ratios: SMOLIRA GOLF CORP. 2017 and 2018 Balance Sheets Liabilities and Owners' Equity 2018 2017 Current liabilities S 37857 Accounts payable S 36.722 27.766 Notes puble 19.00 42632 Other 19 SHO.255 Toal Long term debe S115.000 $ 34 35 42582 a. Current ratio. Accounts receivable 16.200 b. Quick ratio. 17.801 _36,310 $88.9...
5. Calculate the 2015 financial ratios for Phocbe Corporation rounded to the nearest tenth and put a checkmark in tbe row in which Phorbe's ratios are better than the industry average: Ratio Gross Profit Margin Net Profit Margin Current Ratio Inventory Turnover Receivables Turnover Phoebe Corporation (2015) Industry Averages Phocbe is Better 55.0% 27.5% 3.3 % % 15.5 8.5 Select Financial Ratios What It Measures Eficiency of operations and product pricing Lisiency afher all expenses are considered Short-run debt-paying ability...
ne saved CILJUDI Check my work Problem 4-7 Financial Ratios (LO3) Here are simplified financial statements for Phone Corporation in a recent year: points eBook INCOME STATEMENT (Figures in $ millions) Net sales Cost of goods sold Other expenses Depreciation Earnings before interest and taxes (EBIT) Interest expense Income before tax Taxes (at 35%) Net income Dividends $ 13,700 4,360 4,047 2,698 $ 2,595 715 $ 1,880 658 $ 1,222 $ 916 Print References BALANCE SHEET (Figures in $ millions)...
e following ratios are computed from the financial statements of the Wattawa Company. Compute the missing amounts on the firm's financial statements. Quick Ratio 1.0 Current Ratio 1.5 Accounts Receivable Turnover 5 Debt Ratio 30% Times Interest Earned 3 Inventory Turnover 4 Note: 1) For ratios that call for an average balance, use the year-end value only. 2) All sales were on credit. Wattawa Company Income Statement For the year ended December 31, 2018 Sales ? Less: Cost of Goods...
Anyone know these values and can explain how to get them? Problem 2-6A Condensed balance sheet and income statement data for Sheffield Corp. are presented as follows Sheffield Corp Balance Sheets December 31 Assets Cash Receivables (net) Other current assets Long-term investments Property, plant, and equipment (net) Total assets Liabilities and Stockholder Current liabilities Long-term liabilities Common stock Retained earnings Total liabilities and stockholders' equity 2017 2016 83,300 103,300 62,000 523,300 $803,040 $31,140 23,140 75,300 86,300 60,000 483,300 728,040 s'...
PLEASE FIND THE FINANCIAL RATIOS IN BELOW Financial Ratios The financial statements for Jackson Enterprises (income statement, statement of owner’s equity, and balance sheet) are shown. Jackson Enterprises Income Statement For Year Ended December 31, 20-- Revenue from sales: Sales $170,000 Less: Sales returns and allowances 10,000 Net sales $160,000 Cost of goods sold: Merchandise inventory, January 1, 20-- $6,600 Estimated returns inventory, January 1, 20-- 1,400 $8,000 Purchases $92,870 Less: Purchases returns and allowances $1,896 Purchases discounts 1,888...