Financial Reports Assignment
You will just have to fill in the numbers. The 1st download is an example The assignment is the 2nd download
BS
Account Name | Amount | Account Name | Amount | |||||
Current Assets | Current Liabilities | |||||||
prepaid expenditures | ||||||||
cash and cashequialents | ||||||||
Inventories | ||||||||
accounts Receivable | ||||||||
allowancew from accounts receivable | ||||||||
Total Current Assets | Total Current Liabilities | |||||||
Long-term Assets | Long Term Liabilties | |||||||
Total Long-term Assets | Total Long Term Liabilities | |||||||
Total Liabilities | ||||||||
Net Assets (Equity) | ||||||||
Total Assets | Total Net Assets plus Liability | |||||||
&12Ferris Hospital (000s omitted) Balance Sheet For the year ended 12/31/16
IS
Revenue | ||
Net operating revenue | ||
Expenses | ||
Total operating expenses | ||
Net Income from Operations | ||
Other income (loss) | ||
Interest Income | ||
Net income(loss) | ||
&12Ferris Hospital (000s omitted) Income Statement For the year ended 12/31/16
Cash Flows
December 31, 2014 | December 31, 2013 | Instructions: | |||||
Operating Net Income | 12,645 | Bring over from Income Statement | |||||
Reconcilliation of Net Income to Cash Flow: | |||||||
Add Back: Depreciation and Amortization | 7,698 | Bring over from Income Statement – Depreciation Expense | |||||
(Increase)/Decrease in Accounts Receivable | 10,000 | There was a decrease in Accounts Receivable of 4,000 | |||||
(Increase)/Decrease in Inventory | (1,000) | There was an increase in Inventory of 500 | |||||
(Increase)/Decrease in Prepaid Expense | 1,500 | There was an increase in Prepaid Expense of 1,000 | |||||
Increase/(Decrease) in Accounts Payable | 2,000 | There was a decrease in Accounts Payable of 1,500 | |||||
Adjustments to Net Income | 20,198 | Sum all adjustments | |||||
Net Cash Flow from Operations | 32,843 | Subtract adjustments from Operating Net Income | |||||
Captial and Related Financing | |||||||
Purchase of Capital Equipment | – | You purchased new computers for 10,000 | |||||
Proceeds of Capital Financing | – | There were no proceeds from Capital Financing | |||||
Interest on Lont-term Debt | (5,000) | There was 4,000 paid on Interest on Long-term Debt | |||||
Principal on Long-term Debt | (10,000) | There was 11,000 paid on the Principle on Long-term Debt | |||||
Net Cash from Capital and Related Financing | (15,000) | Sum all Captial and Related Financing | |||||
Investments | |||||||
Investment Income | 2,000 | You received 1,960 from investment income | |||||
(Purchase)/Sale of Investments | – | You purchased a Certificate of Deposit for 1,500 | |||||
Net Cash from Investments | 2,000 | Sum all Investment Income | |||||
Net increase in Cash & Cash Equivalents | 19,843 | Add Net Cash Flow from Operations, Net Cash from Capital and Related Financing and Net Cash from Investments | |||||
Cash & Case Equivalents, Beginning of Year | 5,000 | Put the Cash and Cash Equvalents from 2013 in this cell | |||||
Cash & Cash Equivalents, End of Year | 24,843 | Sum Net increase in Cash and Cash Equvalents from 2013 and 2014 | |||||
Ferris Hospital (000s omitted) Statement of Cash Flows For the year ended 12/31/16
Changes in Fund Balance
December 31, 2014 | December 31, 2013 | ||||||||
Balance First of Year | 70,249 | Put the number from the previous year's balance here. | |||||||
Revenue in Excess of Expenses | 12,645 | Bring the Net Income from the Income Statement here | |||||||
Interest Income | 2,000 | Bring the Interest Income from the Income Statement | |||||||
Balance End of Year | 84,894 | Sum it all up here | |||||||
Ferris Hospital (000s omitted) Changes in Fund Balance For the year ended 12/31/16
Accounts
Accounts payable | 763 | ||
Accounts Receivable Gross | 28,406 | ||
Allowances from Accounts Receivable | (4,208) | ||
Cash and Cash Equivalents | 21,709 | ||
Current portion of long term debt | 3,058 | ||
Depreciation expense | 7,326 | ||
Employee Benefits expense | 13,290 | ||
Inpatient Services Revenue | 90,085 | ||
Insurances expense | 1,512 | ||
Interest Income | 1,780 | ||
Inventories | 2,499 | ||
Less Accumulated depreciation | (43,417) | ||
Long Term Debt, less current portion | 14,798 | ||
Notes payable | 1,153 | ||
Other Operating Expenses | 10,533 | ||
Out Patient Services Revenue | 105,258 | ||
Physician Fees expense | 2,815 | ||
Plant Property& Equipment (PP&E) | 126,327 | ||
Prepaid Expenditures | 3,811 | ||
Repairs & Maintenance expense | 3,205 | ||
Revenue Deductions | (48,755) | ||
Salaries &withholdings payable | 4,164 | ||
Salary & Wage expense | 71,764 | ||
Supplies expense | 23,800 | ||
Utilities expense | 2,256 |
,
BS
Account Name | Amount | Account Name | Amount | |||||
Current Assets | Current Liabilities | |||||||
Prepaid Expenditures | 3,811 | Accounts payable | 713 | |||||
Cash and Cash Equivalents | 21,409 | Salaries &withholdings payable | 4,164 | |||||
Inventories | 2,499 | Notes payable | 1,153 | |||||
Accounts Receivable Gross | 26,406 | Current portion of long term debt | 2,058 | |||||
Allowances from Accounts Receivable | (4,508) | |||||||
Net A/R | 21,898 | |||||||
Total Current Assets | 49,617 | Total Current Liabilities | 8,088 | |||||
Long-term Assets | Long Term Liabilties | |||||||
Plant Property& Equipment (PP&E) | 116,327 | Long Term Debt, less current portion | 14,798 | |||||
Less Accumulated depreciation | (43,417) | |||||||
Total Long-term Assets | 72,910 | Total Long Term Liabilities | 14,798 | |||||
Total Liabilities | 22,886 | |||||||
Net Assets (Equity) | 99,641 | |||||||
Total Assets | 122,527 | Total Net Assets plus Liability | 122,527 | |||||
&12EFG Hospital (000s omitted) Balance Sheet For the year ended 12/31/14
IS
Revenue | ||||
Inpatient Services Revenue | 92,085 | |||
Out Patient Services Revenue | 103,258 | |||
Total Gross Revenue | 195,343 | |||
Revenue Deductions | (48,755) | |||
Net operating revenue | 146,588 | |||
Expenses | ||||
Salary & Wa
Collepals.com Plagiarism Free Papers Are you looking for custom essay writing service or even dissertation writing services? Just request for our write my paper service, and we'll match you with the best essay writer in your subject! With an exceptional team of professional academic experts in a wide range of subjects, we can guarantee you an unrivaled quality of custom-written papers. Get ZERO PLAGIARISM, HUMAN WRITTEN ESSAYS Why Hire Collepals.com writers to do your paper? Quality- We are experienced and have access to ample research materials. We write plagiarism Free Content Confidential- We never share or sell your personal information to third parties. Support-Chat with us today! We are always waiting to answer all your questions. ![]() All Rights Reserved Terms and Conditions |