Question
i am working on my ratios and am stuck on the average collection formula and payables turnover
i know the formula for ACF is acct receivable/ annual sales / by 365 days but the figure i get is wrong
Prof Ha Financial Forecasting Draw Formulas Data Review Page Layout le Home Insert View Help Accounti Calibri v11 VA BIU ·A.
Formulas Insert Page Layout Home Draw File X VAA Calibri V 11 ab Wrap Text 3Merge & Center Paste BIU- Alignment Font Clipboar
H Ce vre e BIU G-A- A. 3 Mer 2 oboard Font Alignment 5 fx A D E F YEAR 4 YEAR 1 YEAR 2 YEAR 3 YEAR 5 24,765 3,000 26,647 3,00
Home Insert Draw Formulas Page Layout le = al Calibri V11 VA A aste BIU. A. A Z Font Clipboard ** H15 X fx A B С 1 2 YEAR 1 1
0 0
Add a comment Improve this question Transcribed image text
Answer #1
Average collection period
Average collection period 365/accounts receivables turnover ratio 365/13.63636 26.77
Accounts receivables turnover ratio sales/average accounts receivables 150000/11000 13.63636
Average accounts receivables =(beginning balance+year end balance)/2 (10000+12000)/2 11000
Add a comment
Know the answer?
Add Answer to:
i am working on my ratios and am stuck on the average collection formula and payables...
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
  • prepare a projected income statement for 2019, based on the patterns in the years 2015 through 2018 Income Statem...

    prepare a projected income statement for 2019, based on the patterns in the years 2015 through 2018 Income Statement 2015 $78,000 $40,000 $38,000 For Year Ended 2016 2017 $52,000 $41,000 $45.000 $38,000 $7,000 $3,000 2018 $36,000 $40,000 ($4,000) $3,000 $2,000 $0 $0 Sales LESS Cost of Goods Sold Gross Profit LESS Marketing Expenses LESS Gn'l & Admin Expenses LESS Depreciation Operating Profit LESS Interest Expense Profit Before Taxes LESS Taxes Net Profit $1,000 $10.000 $24,000 $1,000 $23,000 $9.200 $13,800 $1,000...

  • Answers? 15 Points (2 pages) PROBLEM Based upon the comparative she prepare its Statement of and...

    Answers? 15 Points (2 pages) PROBLEM Based upon the comparative she prepare its Statement of and the additional inforatve balance sheets, the income stat and the additional information Cash Filows using the pration for Sales Co. prepare its Statement of Cash Flows using the Direct M Method Comparative Balance Sheets 1, 2018 and 2017 2018 2017 Change cember Balance Sheets Assets Cash Accounts receivable Inventory Prepaid Insurance Land Equipment Less: Accum Deprec 43,000 28,000 ↑15,000 33,000 30,000 T 3,000 46,000...

  • Create a balance sheet I TUDIUM 1. The adjusted trial balance of Debit Company is shown...

    Create a balance sheet I TUDIUM 1. The adjusted trial balance of Debit Company is shown below: Debit Company Adjusted Trial Balance December 31, 20X7 Cash $6,500 Accounts receivable 8,000 Supplies 1,000 Prepaid Rent (3 months) 2,500 Equipment, net 42,000 Accounts payable Salary payable Unearned revenue (2 month advance) Note payable - long term Common stock Retained earnings- Dividends Service revenue Salary expense 40,000 Rent expense 10,000 Supplies expense Depreciation expense 5,000 Utilities expense 1,200 $4,000 2,000 2,000 14,000 10,000...

  • Below are the two most recent balance sheets and most recent income statement for Seashell Industries....

    Below are the two most recent balance sheets and most recent income statement for Seashell Industries. The company has an effective tax rate of 35% Balance Sheet 2018 2017 Assets Cash Accounts Receivable (net) Inventory Long-lived assets Less: Accumulated depreciation $10,000 6,000 8,000 12,000 (4,000 $32.000 6,000 1,500 10,000 11,000 Total assets $26.500 Liabilities and Stockholders' Equity Accounts payable Deferred revenues Long-term note payable Less: Discount on note pavable Common stock Retained earnings S 5,000 1,000 10,000 (800) 12,000 4,800...

  • midterm review packet. i am struggling to form an income statement for this company. i am...

    midterm review packet. i am struggling to form an income statement for this company. i am unsure how to a statement for stockholders equity for the year as well. Below are the account balances for Hydrangea Incas of December 31, 2019 after adjusting entries. The accounts are listed in alphabetical order. There was no new investment by stockholders' during the year. Prepare financial statements for Hydrangea, Inc, on the templates on the following pages. o Single-Step Income Statement • Statement...

  • Comparative balance sheet statements of Irving Inc. are presented below: Irving Inc. COMPARATIVE BALANCE SHEET ACCOUNTS December 31, 2017 and 2016 December 31 Assets 2017 2016 Cash...

    Comparative balance sheet statements of Irving Inc. are presented below: Irving Inc. COMPARATIVE BALANCE SHEET ACCOUNTS December 31, 2017 and 2016 December 31 Assets 2017 2016 Cash 25,000 20,000 Accounts receivable 45,500 48,000    Less: allowance for doubtful accounts (1,500) (1,000) Inventory 55,000 50,000 Dividend receivable 3,000 2,000 Investments 13,000 10,000 Land 70,000 40,000 Buildings & equipment 231,000 250,000   Less: accumulated depreciation (35,000) (50,000)         Totals 406,000 369,000 Liabilities Accounts payable 13,000 20,000 Salaries payable 2,000 5,000 Interest payable 4,000 2,000 Income...

  • this is the answers i need help figuring out how they got the numbers thank you....

    this is the answers i need help figuring out how they got the numbers thank you. ! 12) Paulee Corporation paid $24,800 for an 80% interest in Sergio Corporation on January 1, 2013, at which time Sergio's stockholders' equity consisted of $1 5,000 of Common Stock and $6,000 of Retained Earnings. The fair values of Sergio Corporation's assets and liabilities were identical to recorded book values when Paulee acquired its 80% interest. Sergio Corporation reported net income of $4,000 and...

  • 2. (25 Points) Comparative balance sheet statements of Irving Inc. are presented below Irving Inc COMPARATIVE...

    2. (25 Points) Comparative balance sheet statements of Irving Inc. are presented below Irving Inc COMPARATIVE BALANCE SHEET ACCOUNTS December 31, 2017 and 2016 December 31 2016 S 20.000 48,000 (1,000) 50,000 2,000 10,000 40,000 250,000 (50,000) S369.000 2017 $ 25,000 45,500 (1,500) 55,000 3,000 13.000 70,000 231,000 (35,000) S406.000 Assets Cash Accounts Receivable Less: Allowance for Doubtful Accounts Iaventory Dividend Receivable Iavestments Land Buildings & Equip. Less Accumulatod depreciation Totals Liabilities Accounts Payable Salaries Payables Interest payable Income tax...

  • Below are the two most recent balance sheets and most recent income statement for Seashell Industries....

    Below are the two most recent balance sheets and most recent income statement for Seashell Industries. The company has an effective tax rate of 35% Balance Sheet 2018 2017 Assets Cash Accounts Receivable (net) Inventory Long-lived assets Less: Accumulated depreciation $10,000 6,000 1,500 10,000 11,000 (4.000 2,000) S32.000 S26.500 6,000 8,000 12,000 Total assets Liabilities and Stockholders' Equity: Accounts payable Deferred revenues Long-term note payable Less: Discount on note payable Common stock Retained earnings S 5,000 1,000 10,000 (800) 12,000...

  • Preparation of financial statements Using the Adjusted Trial Balance shown below, prepare the company’s: (a)  ...

    Preparation of financial statements Using the Adjusted Trial Balance shown below, prepare the company’s: (a)   Income Statement (b)   Statement of Retained Earnings (c)    Balance Sheet by completing the tables provided on the following pages. Repair Shop Adjusted Trial Balance Dec. 31, 2016 Debit Credit Cash $ 30,000 Supplies 2,000 Accounts Receivable 70,000 Equipment 30,000 Accumulated Depreciation on Equipment $ 10,000 Accounts Payable 20,000 Notes Payable 5,000 Income Taxes Payable 20,000 Capital Stock 30,000 Retained Earnings (as of Jan 1, 2016)...

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