Basic Financial Calculations
nurselen
Week_3_Application_Assignment_Template.xlsxWeek 3 assignment
| Name: Course: | ||
| Current Ratio = total current assets/ total current liabilities | 2.27 | Note: in B cell calculation is included |
| Days of Cash on Hand = cash/(total operating expense/365) | ||
| Age of Accounts Receivable = accounts receivable, less allowance for doubtful accounts/(net patient service revenue/365) | ||
| Age of Physical Plant = accumulated depreciation/depreciation | You will receive a negative number..change to a positive number (Erase information in this cell and put positive number here. | |
| Debt to Equity Ratio = Long Term Debt/Balance at June 30, 20x2-Total net assets | ||
| Debt to Assets Ratio = Long TermDebt/total assets | ||
| Collection Rate = net patient service revenue/gross patient service revenue | ||
| Operating Margin Ratio = gains or loss from operations/net patient service revenue | ||
| ABC General Hospital Statement of Revenue and Expenses - June 30, 20X2 | ||
| Assets | ||
| Current Assets | ||
| Cash | $1,985,000 | |
| Accounts Receivable less allowance for doubtful accounts | 3,720,000 | |
| Inventory | 550,000 | |
| Total Current Assets | $6,255,000 | |
| Fixed Assets | ||
| Plant and Equipment | $10,000,000 | |
| Less Accumulated Depreciation | -3,770,000 | |
| Total Fixed Assets | $6,230,000 | |
| Total Assets | $12,485,000 | |
| Liabilities and Net Assets | ||
| Current Liabilities | ||
| Accounts Payable | $1,900,000 | |
| Accrued Accounts Payable | 850,000 | |
| Total Current Liabilities | $2,750,000 | |
| Long Term Debt | 2,800,000 | |
| Pension Liability | 1,250,000 | |
| Total Liabilities | 6,800,000 | |
| Net Assets | ||
| Balance at June 30, 20X1 | 4,775,000 | |
| Gain or (Loss) from Operations | 910,000 | |
| Balance at June 30, 20X2 - Net Assets | $5,685,000 | |
| Total Liabilities and Net Assets | $12,485,000 | |
| Gross Patient Service Revenue | ||
| Inpatient Revenue | $8,250,000 | |
| Outpatient Revenue | 2,275,000 | |
| Total Gross Patient Service Revenue | $10,525,000 | |
| Less: Discounts | -1,455,250 | |
| Net Patient Revenue | $9,069,750 | |
| Operating Expenses | ||
| Salaries & Benefits | $5,110,000 | |
| Supplies and Services | 2,829,750 | |
| Interest | 100,000 | |
| Depreciation | 120,000 | |
| Total Operating Expense | $8,159,750 | |
| Gain or (Loss) from Operations | $910,000 | |
Name:_x000D_Assignment:_x000D_Date:_x000D_
