1. Calculating Liquidity Ratios
Current Ratio = (Net Working Capital + Current Liabilities)/Current Liabilities
Current Ratio = (1920+4380)/4380
Current Ratio = 1.438
Quick Ratio = (Current Assets-Inventory)/Current Liabilities
Quick Ratio = (1920+4380-3750)/4380
Quick Ratio = 0.582
2. Calculating Profitability Ratios
Net Profit = Sales * Profit Margin
Net Profit = 17.5 * 0.06
Net Profit = $1.05 million
ROA = Net Profit/Total Assets
ROA = 1.05/13.1
ROA = 8.01%
ROE = Net Profit.(Assets - Debt)
ROE = 1.05/(13.1-5.7)
ROE = 14.12%
3. Calculating Average Collection Period
Receivables Turnover = Credit Sales/Account Receivables
Receivables Turnover = 5173820/438720
Receivables Turnover = 11.79
Days Sales Receivables = 365/Receivables Turnover
Days Sales Receivables = 365/11.79
Days Sales Receivables = 30.95 days
4. Calculating Inventory Turnover
Inventory Turnover = COGS/Invnetory
Inventory Turnover = 4682715/417381
Inventory Turnover = 11.22
Day's Sales Inventory = 365/Inventory turnover
Day's Sales Inventory = 32.53 days
× | products . Data Briefs-k × | O etext ps://berkeley.courseload.com/#/content-43581/address/133 xPage 85, Fundamentals of C...
all anwsers must be entered as a formula. X BS.BE FILE HOME INSERT Calculating liquidity ratios - Excel FORMULAS DATA REVIEW ? x PAGE LAYOUT VIEW - Sign In Calibri - 11 SAA B IU. E. A ME Paste Alignment Number LD Conditional Format as Cell Formatting Table Styles Styles Cells Clipboard Font EF G SDJ, Inc., has net working capital of $2,710, current liabilities of $3,950, and inventory of $3,420. What is the current ratio? What is the quick...
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'...
Shelton, Inc., has sales of $20 million, total assets of $17.6 milion, and total debt of $6.7 million. Assume the profit margin is 8 percent. What is the company's net income? (Do not round intermediate calculations. Enter your answer in dollars not in millions, e.g., 1,234,567.) Net income $ 1,600,000 What is the companys ROA? (Do not round intermediate calculations. Enter your answer as a percent rounded to 2 decimal places, e.g., 32.16.) ROA 9.09 % What is the company's...
H Aguilera Corp. has a current accounts receivable balance of $438,720. Credit sales for the year just ended were $5,173,820. What is the receivables turnover? The days' sales in receivables? Accounts receivable Credit sales Days per year $ $ 438,720 5,173,820 366 Complete the following analysis. Do not hard code values in your calculations. Receivables turnover Days' sales in receivables
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...
Questions: 1. Compute the following ratios for PAYPAL HOLDINGS INC: CURRENT RATIO QUICK RATIO CASH RATIO TOTAL DEBT RATIO DEBT EQUITY RATIO TIMES INTEREST EARNED RATIO CASH COVERAGE RATIO INVENTORY TURNOVER DAYS SALES IN INVENTORY RECEIVABLES TURNOVER DAYS SALES IN RECEIVABLES TOTAL ASSET TURNOVER CAPITAL INTENSITY PROFIT MARGIN RETURN ON ASSETS RETURN ON EQUITY PRICE EARNINGS RATIO MARKET TO BOOK RATIO 2. Decompose the ROE using the extended Du-Pont Analysis.
Aguilera Corp. has a current accounts receivable balance of $338,500. Credit sales for the year just ended were $4,847,320. What is the company's receivables turnover? (Do not round intermediate calculations. Round your answer to 2 decimal places, e.g., 32.16.) Receivables : turnover times What is the company's days' sales in receivables? (Use 365 days a year. Do not round intermediate calculations. Round your answer to 2 decimal places, e.g., 32.16.) Days' sales in receivables 7 days How long did it...
A B C D E F G H M N O Exercises Twin Oak Corp has the following comparative balance sheet data. $ Cash Receivables (net) Inventory LT Investments Plant and equipment (net) Twin Oak Corp Balance Sheet December 31 2014 $ 25.000 50,000 90,000 75.000 400.000 $6.10.000 70,000 80,000 345.000 145.000 $6.40.000 2013 20.000 45.000 95.000 70,000 370,000 $600.000 75,000 85.000 315.000 125,000 $600.000 2012 $ 18.000 48.000 64,000 45.000 358,000 $533.000 $ 70,000 50.000 300.000 113,000 $933.000 $...
1 Requirements Calculate the following ratios for 2018 and 2017. When calculating days, round your answer to the nearest whole number a. Current ratio b. Quick (acid-test) ratio c. Inventory turnover and days' inventory outstanding (DIO) d. Accounts receivable turnover e. Days' sales in average receivables or days' sales outstanding (DSO) f. Accounts payable turnover and days' payable outstanding (DPO). Use 1. cost of goods sold in the formula for accounts payable turnover. g. Cash conversion cycle (in days) (When...
Liquidity and Asset Management Ratios Oasis Products, Inc. has current liabilities = $9.8 million, current ratio = 2.00 times, inventory turnover ratio = 12.5 times, average collection period = 25 days, and sales = $111 million. What is the value of their cash and marketable securities? (Consider a 365 days a year.)