your task is to complete the yellow-shaded columns to complete the close process. All other cells...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
your task is to complete the yellow-shaded columns to complete the close process. All other cells are locked within the spreadsheet. This practice problem continues the understanding of the placement of specific account types on the appropriate financial statements. For each of the financial statements, the column headers are labeled for debits (DR) and credits (CR). The excess of revenue over expenses is closed out to Net Assets (NA), which appears on both the Statement of Net Assets and Balance Sheet. Fort Collins General Hospital Financial Worksheet For the Fiscal Year Ended December 31, 20X3 Acet No. 101 Cash 102 Temporary Investments 105 104 105 100 107 108 109 名条班民日菜菜或游戏开 150 160 101 170 171 201 204 205 206 Account Name Accrued Interest Receivable 301 302 401 402 405 Accounts Receivable (A/R) Allowance for Uncollectible Accounts (AUCAs) Inventory (Supply 202 Notes Payable (N/P) 404 405 406 407 Prepaid Insurance Expense Prepaid Rent Expense Prepaid Interest Expense Land 205 Accrued interest Payable Buildings(s) Accumulated Depreciation-Building(s) Equipment Accumulated Accounts Payable (A/P) Depreciation Equipment 220 Bonds Payable Accrued Salaries and Wages (5/W) Payable Deferred Rental Revenue (Income) Deferred Tuition Revenue (Income) Hospital Net Assets (NA) Revenue and Expense Summary Routine Services Revenue Ancillary Services Revenue Premium Revenue Other Operating Revenue Rental Revenue Tuition Revenue Interest Revenue 400 Non-Operating Revenue 501 Contractual Adjustments 502 Charity Care Adjustments 601 Salary and Wages (5/W) Expense 602 Inventory (Supply) Expense 603 Utilities Expense 604 605 606 Insurance Expense Repairs Expense Rent Expense Depreciation Expense 607 608 Interest Expense 609 Bad Debt Expense 610 Other (Miscellaneous) Expenses ADI Trial Balance 12/31/20X5 Profit/Loss end-of-year NA update: does it belence OR 616,100 353.000 44,700 1.013,100 167,100 13.500 4.900 400 450.000 407 400 148.200 144.200 181,900 684,400 280,200 148.200 110,500 54,800 17,800 156.500 67,400 75,400 CR 13.500 121.500 40.400 21.400 14.800 5.000 4.700 10.000 5,400 299.100 1,482,000 2.254,400 687,100 134,700 125.900 37,700 19,700 33.400 13,700 24.300 Totals: 3,325,800 5.325.800 Statement of Operations 2005 OR CA Statement of NA 20x5 DR CA Selence Sheet 12/31/2015 DR CR your task is to complete the yellow-shaded columns to complete the close process. All other cells are locked within the spreadsheet. This practice problem continues the understanding of the placement of specific account types on the appropriate financial statements. For each of the financial statements, the column headers are labeled for debits (DR) and credits (CR). The excess of revenue over expenses is closed out to Net Assets (NA), which appears on both the Statement of Net Assets and Balance Sheet. Fort Collins General Hospital Financial Worksheet For the Fiscal Year Ended December 31, 20X3 Acet No. 101 Cash 102 Temporary Investments 105 104 105 100 107 108 109 名条班民日菜菜或游戏开 150 160 101 170 171 201 204 205 206 Account Name Accrued Interest Receivable 301 302 401 402 405 Accounts Receivable (A/R) Allowance for Uncollectible Accounts (AUCAs) Inventory (Supply 202 Notes Payable (N/P) 404 405 406 407 Prepaid Insurance Expense Prepaid Rent Expense Prepaid Interest Expense Land 205 Accrued interest Payable Buildings(s) Accumulated Depreciation-Building(s) Equipment Accumulated Accounts Payable (A/P) Depreciation Equipment 220 Bonds Payable Accrued Salaries and Wages (5/W) Payable Deferred Rental Revenue (Income) Deferred Tuition Revenue (Income) Hospital Net Assets (NA) Revenue and Expense Summary Routine Services Revenue Ancillary Services Revenue Premium Revenue Other Operating Revenue Rental Revenue Tuition Revenue Interest Revenue 400 Non-Operating Revenue 501 Contractual Adjustments 502 Charity Care Adjustments 601 Salary and Wages (5/W) Expense 602 Inventory (Supply) Expense 603 Utilities Expense 604 605 606 Insurance Expense Repairs Expense Rent Expense Depreciation Expense 607 608 Interest Expense 609 Bad Debt Expense 610 Other (Miscellaneous) Expenses ADI Trial Balance 12/31/20X5 Profit/Loss end-of-year NA update: does it belence OR 616,100 353.000 44,700 1.013,100 167,100 13.500 4.900 400 450.000 407 400 148.200 144.200 181,900 684,400 280,200 148.200 110,500 54,800 17,800 156.500 67,400 75,400 CR 13.500 121.500 40.400 21.400 14.800 5.000 4.700 10.000 5,400 299.100 1,482,000 2.254,400 687,100 134,700 125.900 37,700 19,700 33.400 13,700 24.300 Totals: 3,325,800 5.325.800 Statement of Operations 2005 OR CA Statement of NA 20x5 DR CA Selence Sheet 12/31/2015 DR CR
Expert Answer:
Answer rating: 100% (QA)
Financial Worksheet For the Fiscal year ended December 31 20x5 Cash Temporary Investment Accrued Int... View the full answer
Related Book For
Fundamental Accounting Principles
ISBN: 978-0078110870
20th Edition
Authors: John J. Wild, Ken W. Shaw, Barbara Chiappetta
Posted Date:
Students also viewed these organizational behavior questions
-
The Edwards Lake Community Hospital balance sheet as of December 31, 2019, follows. Required a. Record in general journal form the effect of the following transactions during the fiscal year ended...
-
The following transactions were completed by Irvine Company during the current fiscal year ended December 31 Feb. 8 Received 45% of the $18,700 balance owed by DeCoy Co., a bankrupt business, and...
-
CM Corporation (CMC) was founded in 2011 by Eric Conner and Phil Martin. The company designs install, and services security systems for high-tech companies. The founders, who describe themselves as...
-
An employee earns $24 per hour and 1.5 times that rate for all hours in excess of 40 hours per week. Assume that the employee worked 43 hours during the week. Assume that the FICA tax rate is 7.5%...
-
During its first year of operations, Sunshine Travel earned revenue of $530,000 on account. Industry experience suggests that Sunshine Travels uncollectible accounts will amount to 3% of revenues. On...
-
What are the five components of the COSO IC-IF Model?
-
Identify the performance metrics used in project supply chain management.
-
Hundreds of thousands of drivers dropped their automobile insurance in 2008 as the unemployment rate rose (Wall Street Journal, December 17, 2008). Sample data representative of the national...
-
You are a financial analyst working at EcoHomes and you are evaluating the following mutually exclusive projects: Time Period Project A Cash Flows Project B Cash Flows Cost -100,000 -200,000 Year 1...
-
Consolidation related simulation example: Millennium Capital Management, Inc., (MCM) acquired a 90% interest in NextGen, Inc. MCM's Financial Manager, Matthew Steven, has prepared a draft memo to the...
-
How many grams of the dry-cleaning solvent 1,2-dichloroethane (also called ethylene chloride), C2H4Cl2, can be prepared by reaction of 15.4 g of ethylene, C2H4, with 3.74 g of Cl2? CH + Cl CH4Cl...
-
If you were trying to examine this issue, how would you proceed? Any suggestions for me to take next steps? same. Is that what happened? You normally wouldnt borrow money from the company, would you?
-
Police in Albemarle County, Virginia, were on the lookout for a stolen orange and black motorcycle that had eluded them in two previous traffic incidents. Officer David Rhodes drove past the home of...
-
Its Intoxicating Inc., is a Pennsylvania corporation that manufactures and distributes cosmetic products to various retailers. Maritim is a German company that owns and operates hotels throughout...
-
Define the following: a. Asset b. Liability c. Net asset
-
Its not like what youve done has really hurt anyone. At most, the missing money might cost earnings-pershare, maybe a penny. Is that what caused you to write those checks in the name of your company?
-
The CFO and the COO are disagreeing about implementing a plan use departmental codes on the office copy machine. The conflict type is Question 10 options: interpersonal conflict intrapersonal...
-
Select the correct answer for each of the following questions. 1. On December 31, 20X3, Saxe Corporation was merged into Poe Corporation. In the business combination, Poe issued 200,000 shares of its...
-
Why is working capital given special attention in the process of analyzing balance sheets?
-
Refer to this chapters opening feature about Facebook. Assume that Mark Zuckerberg desires to expand his online services to meet peoples demands. He decides to meet with his banker to discuss a loan...
-
Refer to the chapter opener regarding John Hewitt and his company, Liberty Tax Service. All successful businesses track their costs, and it is especially important for start-up businesses to monitor...
-
For installation and operation of a pipeline for an incompressible fluid, the total cost (in dollars per year) can be represented as follows: \[C=C_{1} D^{1.5} L+C_{2} m \Delta p / ho\] where...
-
Heavy fuel oil, initially semisolid at $15^{\circ} \mathrm{C}$ is to be heated and pumped through a $15 \mathrm{~cm}$ diameter (inside) pipe at the rate of $20000 \mathrm{~kg} / \mathrm{h}$. The pipe...
-
We are interested to produce $P$ in the reaction $A ightarrow P$ using a continuous reactor at $v=240$ liters/ hr with $C_{A_{0}}=3$ moles/liter. However, it is noticed that there is a second...
Study smarter with the SolutionInn App