Using the Balance Sheet and the Income Statement (Statement of Revenues and Expenses)  calculate both the OPERATING MARGIN  with formula operating income Loss/ total operating revenues and the RETURN ON TOTAL ASSETS  using formula  ebit/total assists

FINANCIAL ACCOUNTING
10th Edition
ISBN:9781259964947
Author:Libby
Publisher:Libby
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
icon
Related questions
Topic Video
Question

Using the Balance Sheet and the Income Statement (Statement of Revenues and Expenses)  calculate both the OPERATING MARGIN  with formula operating income Loss/ total operating revenues and the RETURN ON TOTAL ASSETS  using formula  ebit/total assists

 

 

 

Balance Sheet
Assets
Current Assets
Cash and cash equivalents
Accounts receivable (not)
Inventories
Prepaid Insurance
Total Current Assets
Property, Plant, and Equipment
Land
Buildings (net)
Equipment (net)
Net Property, Plant, and Equipment
Other Assets
December 31, 2002
$190,000
250,000
25,000
5.000
$470,000
360,000
133,000
$963,000
$345,000
200,000
$545,000
418,000
$963,000
$100,000
0
260,000
Investments
$133.000
Total Other Assets
Total Assets
Liabilities and Fund Balance
Current Liabilities
Current maturities of long-term debt
$52.000
Accounts payable and accrued expenses 293.000
Total Current Liabilities
Long-Term Debt
$252,000
Less Current Maturities of Long-Term Debt (52.000)
Net Long-Term Debt
Total Liabilities
Fund Balances
Unrestricted fund balance
$418.000
Restricted fund balance
Total Fund Balances
Total Liabilities and Fund Balance
Statement of Revenue and Expenses
For the Year Ending
December 31, 20x2
Revenue
Net patient service revenue
$2,000,000
Total operating revenue
Operating Expenses
Medical/surgical services
$600,000
Therapy services
860,000
Other professional services
80,000
Support services
220,000
General services
65,000
Depreciation
40,000
Interest
20,000 $1,885,000
Total operating expenses
Income from Operations
$115.000
Nonoperating Gains (Losses)
Interest Income
$5,000
Net nonoperating gains
5,000
Revenue and Gains in Excess of
Expenses and Losses
$120.000
Increase in Unrestricted Fund Balance
$120,000
$2,000,000
470,000
Current Assets
345,000 Current Liabilities
=1.362
2. Quick Ratio
190,000+250,000
345,000
- 1.275
Step 1
1,885,000
(40,000)
1/1.845.000
1.845.000
365
-5,055
Step 2
1. Current Ratio
Step 3
190,000
5,055
= 37.5 days
Step 1
2.000.000
90%
1,800,000
Step 2
1.800.000
365
= 4,931
Step 3
250,000
4,931
-50.7 days
Cash and Cash Equivalent+
Net Receivables
Current Liabilities
3. Days Cash on Hand (DCOH)
Unrestricted Cash and Cash Equivalents
Cash Operating Expenses divided by
days in period (365)
Percent of Credit Revenues
Information obtained elsewhere
4 Days Receivables
Nat Receivables
Net Credit Revenue divided by #days in period (365)
Transcribed Image Text:Balance Sheet Assets Current Assets Cash and cash equivalents Accounts receivable (not) Inventories Prepaid Insurance Total Current Assets Property, Plant, and Equipment Land Buildings (net) Equipment (net) Net Property, Plant, and Equipment Other Assets December 31, 2002 $190,000 250,000 25,000 5.000 $470,000 360,000 133,000 $963,000 $345,000 200,000 $545,000 418,000 $963,000 $100,000 0 260,000 Investments $133.000 Total Other Assets Total Assets Liabilities and Fund Balance Current Liabilities Current maturities of long-term debt $52.000 Accounts payable and accrued expenses 293.000 Total Current Liabilities Long-Term Debt $252,000 Less Current Maturities of Long-Term Debt (52.000) Net Long-Term Debt Total Liabilities Fund Balances Unrestricted fund balance $418.000 Restricted fund balance Total Fund Balances Total Liabilities and Fund Balance Statement of Revenue and Expenses For the Year Ending December 31, 20x2 Revenue Net patient service revenue $2,000,000 Total operating revenue Operating Expenses Medical/surgical services $600,000 Therapy services 860,000 Other professional services 80,000 Support services 220,000 General services 65,000 Depreciation 40,000 Interest 20,000 $1,885,000 Total operating expenses Income from Operations $115.000 Nonoperating Gains (Losses) Interest Income $5,000 Net nonoperating gains 5,000 Revenue and Gains in Excess of Expenses and Losses $120.000 Increase in Unrestricted Fund Balance $120,000 $2,000,000 470,000 Current Assets 345,000 Current Liabilities =1.362 2. Quick Ratio 190,000+250,000 345,000 - 1.275 Step 1 1,885,000 (40,000) 1/1.845.000 1.845.000 365 -5,055 Step 2 1. Current Ratio Step 3 190,000 5,055 = 37.5 days Step 1 2.000.000 90% 1,800,000 Step 2 1.800.000 365 = 4,931 Step 3 250,000 4,931 -50.7 days Cash and Cash Equivalent+ Net Receivables Current Liabilities 3. Days Cash on Hand (DCOH) Unrestricted Cash and Cash Equivalents Cash Operating Expenses divided by days in period (365) Percent of Credit Revenues Information obtained elsewhere 4 Days Receivables Nat Receivables Net Credit Revenue divided by #days in period (365)
Expert Solution
steps

Step by step

Solved in 2 steps

Blurred answer
Knowledge Booster
Accounting Equation
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
FINANCIAL ACCOUNTING
FINANCIAL ACCOUNTING
Accounting
ISBN:
9781259964947
Author:
Libby
Publisher:
MCG
Accounting
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
Accounting Information Systems
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis…
Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON
Intermediate Accounting
Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education
Financial and Managerial Accounting
Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education