Question

Home Insert Draw Page Layout Formulas Data Review View LA Paste 128 Arial 11 AA == BI U B OA V fix x Answer each question in
0 0
Add a comment Improve this question Transcribed image text
Answer #1

1.

Working Capital = Current assets - Current liabilities

= 709,000-167,000

= $542,000

2.

Current ratio = Current assets / Current liabilities

= 709,000/167,000

= 4.25

3.

Acid test ratio = ( Cash + Accounts receivable)/Current liabilities

= (188,000+285,000)/167,000

= 2.83

4.

Acid test ratio can never be higher than current ratio. It happens because while calculating acid test ratio some current assets like inventories and prepaid expenses are excluded.

1.

Average receivable = ( Beginning accounts receivable + Ending accounts receivable)/2

= (110,000+112,000)/2

= $111,000

accounts receivable turnover ratio for year 2 = Net sales/Average receivable

= 1,450,000/111,000

= 13.06

2.

Average collection period for year 2 = 365/13.06

= 30 days

Kindly comment if you need further assistance.

Thanks‼!

Add a comment
Know the answer?
Add Answer to:
Home Insert Draw Page Layout Formulas Data Review View LA Paste 128 Arial 11 AA ==...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • Chapter_2_Applying_Excel_Student_Form.xls File Home Insert Draw Page Layout Formulas Data Review Vie Arial 10 AA Paste *...

    Chapter_2_Applying_Excel_Student_Form.xls File Home Insert Draw Page Layout Formulas Data Review Vie Arial 10 AA Paste * Cut Еe Copy Format Painter Clipboard BIU Font Alignment A1 fx Chapter 2: Applying Excel B D ? per unit A B с Chapter 2: Applying Excel 2 3 Data 4 Unit sales 20,000 units 5 Selling price per unit $60 per unit 6 Variable expenses per unit $45 per unit 7 Fixed expenses $240,000 8 9 Enter a formula into each of the...

  • please help. File Home Insert Page Layout Formulas Data | - 10-AN = Paste * Cut...

    please help. File Home Insert Page Layout Formulas Data | - 10-AN = Paste * Cut Ca Copy Format Painter Clipboard D23 Font НА ЛИ UBLIC 1 Homework Assignment 2 Data Sheet Assumptions 2017 2016 650 935 50 25 5 Accounts payables 885 6 Accounts receivables 950 7 Net Sales 7,800 5,500 8 Common stock 350 350 9 Operating costs 5,243 3,756 10 Gross fixed assets 4,500 3,500 11 Interest expense 12 Long-term debt 2,000 1,800 13 Depreciation & amortization...

  • DATA REVIEW VIEW FORMULAS AA Wrap Text FILE HOME INSERT PAGE LAYOUT Cut Calibri 11 Paste...

    DATA REVIEW VIEW FORMULAS AA Wrap Text FILE HOME INSERT PAGE LAYOUT Cut Calibri 11 Paste Format Painter BIU.B. S Clipboard Font Copy E E Merge & Center 88 Conditional Format as Cell Formatting Table Styles Inse Alignment 041 X fx Production Cost Report: Weighted Average Method. Quality Confections Company manufactures chocolate bars in two processing departments, Mixing and Packaging, and uses the weighted average method for its process costing system. The table that follows shows information for the Mixing...

  • EM221 Insert Draw Page Layout Formulas Data Review View Home Paste June 1: Byte of Accounting, In...

    journalize thse transactions EM221 Insert Draw Page Layout Formulas Data Review View Home Paste June 1: Byte of Accounting, Ine. issued 2,590 shares of its common stock to Jeremy after $22,660 in cash nd omputer o apment with a fair market value of$34,320 were received. 01. June I: Byte of Accounting, Inc, issued 2,371 shares of its common stock after acquiring from Courtney $38,500 in cash, computer equipment with a fair market value of $12,760 and office equipment with a...

  • Home Insert Draw Page Layout Formulas Data Review View percentage 29 ES 2 Calibri (Body) 12...

    Home Insert Draw Page Layout Formulas Data Review View percentage 29 ES 2 Calibri (Body) 12 A A * BLUE OA 13 Conditional Formatting Format as Table Cell Styles 2 Insert Delete Format 5 % + Recover Unsaved Workbooks. We were able to save changes to one or more files. Do you want to recover them? X f x -'BS V&H'ID47 E4 Effective management of assets is critical for most companies. Investment in assets is needed to drive revenue growth....

  • Home Insert Page Layout Formulas Data Review View Help Search Calibri -11-AA BIU 18-la-A- General In-...

    Home Insert Page Layout Formulas Data Review View Help Search Calibri -11-AA BIU 18-la-A- General In- Paste 25 Wrap Text E Merge & Center - DD $ - % -8 Conditional Format as Cell Formatting Table Styles Styles Fo Clipboard Font Alignment Number AutoSave OM 314 f 4 B D E F G H 1 Selected balance sheet and income statement data follow for The New York Times Company for fiscal 2016 (in thousands). Use the data to calculate the...

  • AutoSave of Exam3 PartB_SP20_Due_04_24 - Excel File Home insert Draw Page Layout Formulas Data Review View...

    AutoSave of Exam3 PartB_SP20_Due_04_24 - Excel File Home insert Draw Page Layout Formulas Data Review View Help Search ΑΙ Formula Bar с 1 Week Week D E F G H I J On 3a [10 points). Data set to your left (sheet On3a) contains information on weekly sales for a local grocery store over a 12-week period. Use the data set to answer the following questions 1. Construct a time series plot. What type of pattern exists in the data?...

  • AutoSave OFF 5 = Home View Insert Draw Page Layout Formulas Data Review Calibri (Body) 11...

    AutoSave OFF 5 = Home View Insert Draw Page Layout Formulas Data Review Calibri (Body) 11 A A = = = BIU CA E Paste 2 Wrap Text Merge & Cent 23 x ✓ fx $6,300 A B Question 3 (answer requirements a, b and c) C D н (5 points for part a, 6 points for part b, and 5 points for c) Hudson Incoporated currently uses a job-order costing system and applies manufacturing overhead with a predetermined overhead...

  • HW 5(1) (Protecte File Home Insert Page Layout Formulas Data Review View Help Search O PROTECTED...

    HW 5(1) (Protecte File Home Insert Page Layout Formulas Data Review View Help Search O PROTECTED VIEW Be careful-files from the Internet can contain viruses. Unless you need to edit, it i SUBSCRIPTION EXPIRED Most of the features of Excel have been disabled. Reactivate ADDITIONAL INFORMATION If you need to make a quick edit before renewing your subscription, learn more a 177 fx с D 2016 A B Refer to the fiscal 2017 income statement and balance sheet of 1...

  • Need formulas for areas in red Home Insert Draw Page Layout Formulas Date Review View Developer...

    Need formulas for areas in red Home Insert Draw Page Layout Formulas Date Review View Developer Help Power Piv Cut Copy- Parte Clipboard - Font Alignment G28 Cash Flow Identity Exercise Complete the CFI using the given income statements and other information below 2019 2018 11 12 13 Comparative Balance Sheets Assets 2019 2018 Liabilities Current Assets Current Liabilities Cash & Equivalents 2.500 2.550 Accounts payable Short term investments 1,834 2.400 Accruals and Other Accounts receivable 5,672 4.966 Total current...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT