a) Given:
Average collection Period, DSO = 91.25 days ; Sales = $ 200,000
Now,
DSO = AR / (Sales/ 365)
Putting values
Account Receivable, AR = 91.25 *( 200,000/365)
Hence, AR = $ 50,000
b) Given,
Cash = 10,000 ; Inventory = 150,000 ; Current Ratio = 4.20
Now,
Current Liability = Current Assets/ Current Ratio
Or,
Current Liability = ( Cash + Inventory + AR )/ Current Ratio
Putting values,
Current Liability = (10,000 + 150,000 + 50,000)/ 4.20
Hence,
Current Liability = $ 50,000
c) Given,
Fixed Asset = $ 90,000 ; Equity = $ 200,000 ;
Note that ,
(Long term debt is already provided in the table but that should be common equity)
Total Asset = Cash + Inventory + AR +FA
Total Asset = 10,000 + 150,000 + 50,000 + 90000 = $ 300,000
As we know,
Total Asset = Total liability = Current Liability + Long term debt + Equity
Putting Values
300,000 = 50,000 + LTD + 200,000
Hence,
Long term debt, LTD = $ 50,000
d) Given, Net income = $15,000
Now,
Return on Equity = Net Income/ Equity
Putting values,
ROE = 15,000/ 200,000
Hence,
Return on Equity, ROE = 0.075 or 7.5 %
Question 2:14 points) The following table summarizes some of key financial data for Copeland Corporation (unit:...
The quick ratio a.relates cash, marketable securities, and net receivables to current liabilities. b.is calculated by taking one item from the income statement and one item from the balance sheet. c.is the same as the current ratio except it is rounded to the nearest whole percent. d.is used to quickly determine a company's leverage and long-term debt-paying ability.
Review the more common financial ratios in table 2-1. Which
ratios do you think are the most important with evaluating the
short-term cash needs of a facility? (I have attached the image of
table 2-1)
rs Concept Two: Analyzing and Boosting Creditwortbiness TABLE 2-1. Key Creditworthiness Ratios Financial Ratio Indicator Total operating revenue- Ope Tt Operating margin rating expenses Total operating revenue ome from operations + Nonoperating revenue Excess margin Total operating + Nonoperating revenue Operating EBIDA margin Operating income...
2) The table summarizes the financial conditions for Intel Corporation (INTC), a manufacturer of various computer- processing chips for fiscal year 2013. Compute the various financial ratios and interpret the firm's financial health during fiscal year 2013. The closing stock price was $25.50 on December 31, 2013 and the average number of outstanding shares was 4.98 billion. (a) Debt ratio (b) Times-interest-earned ratio (c) Current ratio (d) Quick (acid-test) ratio (e) Inventory-turnover ratio (f) Days-sales-outstanding (g) Total-assets-turnover ratio (h) Profit...
[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...
how to get the numbers
[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,...
Financial Data for Energy Power Co. as of December 31, 2018: Inventory $200,000 Long-term debt 300,000 Interest expense 15,000 Accumulated depreciation 440,000 Cash 260,000 Net sales (all credit) 1,500,000 Common stock 800,000 Accounts receivable 225,000 Operating expense (incl. depr. Exp. And taxes) 525,000 Notes payable-current 180,000 Cost of goods sold 940,000 Plant and equipment 1,300,000 Accounts payable 160,000 Marketable securities 90,000 Accrued wages 65,000 Retained earnings 130,000 From the information presented in Tables Above, calculate the following ratios for the...
See the following financial information (Income Statement and
balance Sheet) for Thornton Company for the years ending December
31, 1998 and 1999.
What is the Net Plant & Equipment in 1998
and 1999?
Calculate the Cash balance in 1998 and
1999?
What is firm’s Net Income in 1998 and
1999?
What is the Quick ratio in 1998 and 1999?
What is the ROE in 1998 and 1999?
What is the EPS (Earnings Per Share) in 1998
and 1999?
1998 1999...
EXERCISE - CHAPTER 19. RATIOS: From the following Information, compute the ratios indicated and place the proper number in the blanks provided. ASSETS: Cash $10,000 Marketable Securities $15,000 Accounts Receivable, Net $20,000 Inventory $30,000 Prepaid Assets $ 5,000 Property, Plant & Equipment $100,000 Total Assets: $180,000 LIABILITIES & STOCKHOLDERS' EQUITY: Current Liabilities $20,000 Long-Term Liabilities $80,000 Stockholders' Equity $80,000 Total Liabilities & Stockholder's Equity: $180,000 Sales $200,000 Cost of Goods Sold $150.000 Gross Margin $ 50,000 Operating Expense $ 30,000...
Calculate the current ratio, quick ratio, long-term debt/total
assets, times interest earned, and fixed cost coverage using the
picture below.
X2 X3 X4 $2,500,000 3.200,000 3,500,000 4,000,000 1.900.000 2400.0002.700.000 3200.000 800,000 400,00D 25,000 200,000 10.000 20.000 30.000 60.000 15,000 107,500 COST OF GOODS SOLD GROSS PROFIT SELLING & ADMINISTRATIVE EXPENSE DEPRECIATION LEASES MISCELLANEOUS EXPENSE 600,000 400,000 800,000 800,000 400,000 160,000 190,000 138,700 25,000 175,000 170,000 89,000 EARNINGS BEFORE INTEREST & TAXES INTEREST EARNINGS BEFORE TAXES TAXES (35%) NET INCOME DIVIDENDS...
Unit 10 - Financial Statement Analysis Following is a comparative balance sheet for Summer Days Corporation: Summer Days Corporation Comparative Balance Sheet December 31, 2019 and 2018 2019 2018 Current assets: Cash $ 150,000 $ 90,000 Short-term investments 90,000 80,000 Accounts receivable, net 350,000 220,000 Inventory 400,000 430,000 Prepaid expenses 30,000 30,000 Total current assets $1,020,000 $ 850,000 Property, plant, and equipment, net 750,000 500,000 Other assets 280,000 300,000 Total assets $2,050,000 $1,650,000 Current liabilities: Short-term notes payable $650,000 $670,000...