a. | Using the data below as of 12/31/17 and the format found in Exhibit 4.1, create a Balance Sheet for XYZ Hospital for 12/31/17 | |
Accounts payable | 401,760 | |
Accrued expenses | 485,520 | |
Cash | 968,160 | |
Inventory | 295,600 | |
Long-term debt | 6,825,760 | |
Long-term investments | 3,844,720 | |
Net patient accounts receivable | 2,280,720 | |
Net property and equipment | 4,196,000 | |
Notes payable | 346,720 | |
Other long-term liabilities | 420,000 | |
Short-term investments |
800,000 |
Based upon your Balance Sheet, answer the following in the space provided: | |
b. | How much does the hospital own? |
c. | What % of the hospital's assets are current? |
d. | How much does the hospital owe to others? |
e. | What are current assets minus current liabilities? |
f. | What is the hospital's net assets (equity)? |
g. | If the hospital earned $250,000 in 2017, what was the net assets (equity) balance on 12/31/16? |
h. | If the net assets (equity) balance was $375,000 on 12/31/16, what was the hospital's net income in 2017? |
a). Preparing balance Sheet for XYZ Hospital for 12/31/17
Particular | Amount |
ASSETS | |
Cash | 968160 |
Inventory | 295600 |
Net patients Accounts Receivables | 2280720 |
Short Term Investments | 800000 |
Total Current Assets | 4344480 |
Long Term Investments | 3844720 |
Net Property & Equipment | 4196000 |
Total Assets | 12,385,200 |
LIABILITIES & EQUITIES | |
Accounts Payable | 401760 |
Accrued Expenses | 485520 |
Notes Payable | 346720 |
Total Current Liabilities | 1234000 |
Long Term Liabilities | 6825760 |
Other Long term liabilities | 420000 |
Total Equity (balancing figure) | 3905440 |
Total Liabilities & Equities | 12,385,200 |
b). Total Amount the Hospital Own = Total Assets
= 3905,440
So, Hospital own amount is $ 3905,400
c). % of the hospital's assets that are current = (Total Current Assets / Total Assets)*100
= (4344,480/12385,200)*100
= 35.08%
So, % of hospital's assets that are current is 35.08.
d). Total Amount Hospital owe's to others = Total Current liabilities + Long Term Liabilities + Other Long term liabilities
= 1234,000 + 6825,760 + 420,000
= $ 8479,760
So, Hospital owe amount is $ 8479,760.
e). Current Assets less Current Liabilitiies = 4344,480 - 1234,000
=$ 3110,480
f). Hospital's net assets (equity) = Total Assets - Total Liabilities
= 12385,200 - (1234,000 + 6825,760 + 420,000)
= $ 3905,440
g). If the hospital earned $250,000 in 2017, the net assets (equity) balance on 12/31/16 is :
= 3905,440 - 250000
= $ 3655,440
h). If the net assets (equity) balance was $375,000 on 12/31/16, the hospital's net income in 2017 is :
= 3905,440 - 375,000
= $ 3530,440
Note- If you need any clarification regarding this solution, then you can ask in comments
If you like my answer then please Up-vote as it will be motivating.
a. Using the data below as of 12/31/17 and the format found in Exhibit 4.1, create...
a. Using the data below as of 12/31/17 and the format found in Exhibit 4.1, create a Balance Sheet for XYZ Hospital for 12/31/17 Based upon your Balance Sheet, answer the following in the space provided: Accounts payable 401,760 Accrued expenses 485,520 Cash 968,160 Inventory 295,600 Long-term debt 6,825,760 Long-term investments 3,844,720 Net patient accounts receivable 2,280,720 b. How much does the hospital own? Net property and equipment 4,196,000 c. What % of the hospital's assets are current? Notes payable...
Problem 1: Below are financial statements of FIN300.01 Inc: Balance Sheet: 12/31/17 Assets Cash and Marketable Securitics Accounts Reccivable Inventorics Total Current Asscts Net plant and equipment TOTAL ASSETS 2017 10 375 61.5 1,000 2016 80 31. 41.5 810 Liabilities and Equity Accounts Payable Notes Payable Accruals Total Current Liabilities Long Term Bonds TOTAL DEBT Preferred Stock Common Stock Retained carnings TOTAL COMMON EQUITY TOTAL LIABILITIES AND EQUITY 2017 140 110 310 2016 40 G0 130 230 1,064 40 130...
Prepare a vertical analysis for the balance sheet data given below. (Round to two decimal places.) Flowers, Inc Balance Sheet December 31, 2017 $10,000 15,600 38,000 63,600 15,000 195,000 $273600 Assets Current Assets Cash and Cash Equivalents Accounts Receivable, Net Merchandise Inventory Total Current Assets Long-term Investments Property, Plant, and Equipment, Net Total Assets Liabilities Current Liabilities Accounts Payable Notes Payable Total Current Liabdities Long-term Liabilities Total Liabilities Stockholders' Equity Common Stock Retained Eamings Total Stockholders' Equity Total Liabilities and...
The data listed below are taken from a balance sheet of Trident Corporation at December 31, 2021. Required: 1. Determine the missing amounts. 2. Prepare Trident's classified balance sheet. Complete this question by entering your answers in the tabs below. Determine the missing amounts. (Enter the answers in thousands of dollars.) $ in One 241,286 356,700 507,944 86,259 1,624,927 113,800 Cash and cash equivalents Short-term investments Accounts receivable Inventory Prepaid expenses (current) Total current assets Long-term receivables Equipment (net) Total...
Presented below is the balance sheet for HHD, Inc., at December 31, 2021. Current assets Investments Property, plant, and equipment Intangible assets Total assets Current liabilities Long-term liabilities Shareholders' equity Total liabilities and shareholders' equity $ 660,000 545,000 2,420,000 230,000 $3,855,000 $ 460,000 695,000 2,700,000 $3,855,000 The captions shown in the summarized statement above include the following: a. Current assets: cash, $165,000; accounts receivable (net). $215,000; inventory $240,000; and prepaid insurance, $40,000, b. Investments: Investment in equity securities, short term,...
Presented below is the balance sheet for HHD, Inc., at December 31, 2021. Current assets Investments Property, plant, and equipment Intangible assets Total assets Current liabilities Long-term liabilities Shareholders' equity Total liabilities and shareholders' equity $ 640,000 530,000 2,280,000 220,000 $3,670,000 $ 440.000 830,000 2,400,000 $3,670,000 The captions shown in the summarized statement above include the following: a. Current assets: cash, $160,000; accounts receivable (net). $210,000; inventory, $235,000; and prepaid insurance, $35,000 b. Investments: investment in equity securities, short term,...
The data listed below are taken from a balance sheet of Trident Corporation at December 31, 2021. Required: 1. Determine the missing amounts. 2. Prepare Trident's classified balance sheet. Complete this question by entering your answers in the tabs below. Required 1 Required 2 Determine the missing amounts. (Enter the answers in thousands of dollars.) ($ in 000s) $ 252,286 367,700 518,944 97,259 1,734,927 124,800 Cash and cash equivalents Short-term investments Accounts receivable Inventory Prepaid expenses (current) Total current assets...
Exercise 5-12 Presented below is the trial balance of Nash Corporation at December 31, 2020. Debit Credit Cash $ 199,800 $ 8,102,570 Sales Debt Investments (trading) (at cost, $145,000) Cost of Goods Sold Debt Investments (long-term) Equity Investments (long-term) Notes Payable (short-term) Accounts Payable Selling Expenses Investment Revenue 155,570 4,800,000 301,800 279,800 92,570 457,570 2,002,570 64,380 Land 262,570 1,042,800 Buildings Dividends Payable Accrued Liabilities 138,800 98,570 Accounts Receivable 437,570 152,000 27,570 Accumulated Depreciation-Buildings Allowance for Doubtful Accounts Administrative Expenses Interest...
I. Accounts from the unadjusted Test Company's trial balance of 12/31/17 are below: Accounts Payable $ 160,000 Accounts Receivable 130,000 Accumulated Depreciation Equipment 200,000 Advertising Expense 20,000 Cash 150,000 Common Stock 220,000 Equipment 870,000 Prepaid Insurance 30,000 9. Interest Expense 10,000 10. Inventory 300,000 11. Notes Payable (due 6/1/18) 200,000 12. Notes Payable (due 6/1/22) 300,000 13. Prepaid Rent 240,000 14. Retained Earnings 418,000 15. Salaries and Wages Expense 328,000 16. Sales Revenue 500,000 17. Unearned Sales Revenue 80,000 (All...
Presented below is the balance sheet for HHD, Inc., at December 31, 2021. Current assets Investments Property, plant, and equipment Intangible assets Total assets Current liabilities Long-term liabilities Shareholders' equity Total liabilities and shareholders' equity $ 604,000 503,000 2,028,000 202,000 $3,337,000 $ 404,000 1,073,000 1,860,000 $3,337,000 The captions shown in the summarized statement above include the following: a. Current assets: cash, $151,000; accounts receivable (net), $201,000; inventory, $226,000; and prepaid insurance, $26,000. b. Investments: investment in equity securities, short term,...