Chapter 3 HW.xlsx - Adam's salary Arin's salary Interest...

This preview shows page 1 - 6 out of 11 pages.

Adam's salary $45,100.00 Utilities $3,190.00 Arin's salary $30,200.00 Groceries $2,240.00 Interest received $540.00 Medical $1,450.00 Dividends received $190.00 Property taxes $1,655.00 Auto insurance $610.00 Income tax, Social Security $12,800.00 Home insurance $760.00 Clothes and accesories $1,960.00 Auto loan payment $3,250.00 Gas and auto repair $2,090.00 Mortgage payment $14,300.00 Entertainment $2,010.00 Income: Expenses: Adam's salary $45,100.00 Mortgage payment $14,300.00 Arin's salary $30,200.00 Income tax, Social Security $12,800.00 Interest received $540.00 Auto loan payment $3,250.00 Dividends received $190.00 Utilities $3,190.00 Total Income $76,030.00 Groceries $2,240.00 Gas and auto repair $2,090.00 Entertainment $2,010.00 Clothes and accesories $1,960.00 Property taxes $1,655.00 Medical $1,450.00 Home insurance $760.00 Auto insurance $610.00 Total Expense: $46,315.00 Cash Surplus (or deficit) $29,715.00
Ratio Island Electric Utility Burger Heaven Fink Software Roland Motors Current ratio 1.13 1.31 6.84 4.48 Quick ratio 0.89 0.83 5.22 3.66 Debt ratio 0.64 0.42 0.02 0.31 Net profit margin 6.23% 14.33% 28.46% 8.44%
Month of Amounts receivable origin Annual Sales: July $3,925.00 Credit Terms(days): August $1,980.00 Average Sales per Day: September $33,980.00 Average AR: October $15,125.00 November $51,995.00 December $192,950.00 Year-end accounts receivable $299,955.00 a) The avgerage collection period = 45.61815625 = Accounts Receivable/Average Sales per Day
$2,400,000 30 $6,575.34 (Annual Sales/365) $49,992.50
Items ($000) Procter & Gamble

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture