A relation is in ______________________________ if it does not ...

[lb_gilbert]

A relation is in ___________________ ___________ if it does not contain repeating groups.
 Fill in the blank(s) with correct word

Question 2

(Financial statement analysis of a governmental enterprise hospital)
 
  Following is a trial balance (with 000 omitted for simplification) showing the accounts of Beta Hospital at December 31, 2013 .
 
  Using the information from the trial balance, analyze Beta's financial statements by answering the following questions. Show all calculations.
   a. What is the current ratio?
   b. What is the number of days of revenue in net patient accounts receivable?
   c. How much is the excess of revenues over expenses?
   d. What is the earnings margin?
   e. What is the long-term debt-to-equity ratio at year-end?
   f. What is the interest coverage (times interest earned)?
 
   Debits Credits
   Cash 5,000
   Patient accounts receivable 8,000
   Allowance for bad debts 1,000
   Food and medicines inventory 2,000
   Buildings. 40,000
   Accumulated depreciation, buildings 8,000
   Equipment 20,000
   Accumulated depreciation, equipment 10,000
   Land 5,000
   Accounts payable 6,000
   Accrued interest payable 200
   Current portion of bonds payable 1,500
   Long-term bonds payable 34,000
   Net assets, January 1, 2008 17,300
   Patient service revenues (net) 36,000
   Patient care expense 20,000
   Dietary expense 2,000
   General and administrative expense 6,000
   Bad debts expense 1,000
   Depreciation., buildings and equipment 4,000
   Interest expense 1,000 _______
   Totals 114,000 114,000

[rachel]

Answer to Question 1

first normal form (1NF)
1NF
first normal form

Answer to Question 2

a. Current assets (Cash 5,000 + Patient accounts receivable 8,000 - Allowance for bad debts 1,000 + Food and medicines inventory 2,000) = 14,000;
Current liabilities (Accounts payable 6,000 + Accrued interest payable 200 +Current portion of bonds payable 1,500) = 7,700;
Current ratio: Current assets / Current liabilities = 14,000 / 7,700 = 1.82

b. Net patient accounts receivable / Net patient service revenues / day =  7,000 / (36,000 / 365) = 7,000 / (98.63) = 71 days

c. Net patient service revenue = 36,000
Expenses
Patient care expense 20,000
Dietary 2,000
General and administrative 6,000
Bad debts 1,000
Depreciation 4,000
Interest 1,000
34,000
Excess of revenues over expenses  2,000

d. Earnings margin =
Excess of revenues over expenses / Revenues, gains, other support
=  2,000 / 36,000 = 5.55

e. Long-term bonds payable = 34,000;
Year-end total net assets =
Net assets at beginning of year (17,300) + Excess of revenues over expenses for the year (2,000) = 19,300;
Long-term debt to equity ratio =
Long-term debt / Total net assets = 34,000 / 19,300 = 176

f. Times interest earned =
(Excess of revenues over expenses + Interest expense) / Interest expense
= 3,000 / 1,000 = 3 times

[lb_gilbert]

Thanks for the timely response, appreciate it

[sultana.d]

Wow, this really help