Balance Sheet Preparation using Excel cell links

Using the items listed in the Account List tab, complete the Income Statement tab, using links [= or +].

For subtotals and totals, use formulas as appropriate.

Follow proper formatting as shown in the instructional videos provided in the Module Videos an Powerpoints examples.

DO NOT TYPE IN NUMBERS. USE ONLY LINKS OR FORMULAS.

The first two accounts have been provided as examples.

BALANCE SHEET ACCOUNTS IN ALPHABETICAL ORDER ASSETS Accounts Payable Accounts Receivable Accrued Compensation and Related Liabilities Additional Paid In Capital Advances from Third Party Payors BOARD DESIGNATED ASSETS (Restricted use): Bonds Payable Buildings Capitalized Lease Obligations Cash Cash (Restricted use) Common Stock ($1 par) Construction In Progress Construction Loans-Interim Financing CURRENT ASSETS: CURRENT LIABILITIES Current Maturities of Long Term Debt Current Portion Of Funds Held In Trust DEFERRED CREDITS: Deferred Income Taxes Deferred Third Party Revenue Due From Restricted Funds Due to Restricted Funds Equipment EQUITY (INVESTOR OWNED) Fixed Equipment - Building Service Fixed Equipment - Other Goodwill Income Taxes Payable INTANGIBLE ASSETS: Inventory INVESTMENTS AND OTHER ASSETS: Investments In Property, Plant & Equipment Land Land Improvements Leasehold Improvements Less - Accumulated Depreciation Less Accumulated Depreciation Less Current Maturities of Long Term Debt Less Treasury Stock Less-Estimated Uncollectable & Allowances PRPPRAHEE oe eo 2,876,766 52,067,351 7,796,489 11,253,540 172,707 24,934,458 26,832,251 8,131,300 22,009,774 100,000 1,756,385 40,619,731 16,326,222 2,523,297 5,429,711 4,793,059 1,361,180 (51,902,635) (9,757,996) LIABILITIES AND FUND BALANCES-UNRESTRICTED LONG TERM DEBT Marketable Securities (Restricted use) Marketable Securities Mortgage Payable NET PROPERTY, PLANT & EQUIPMENT (FIXED ASSETS) Noncurrent Liabilities Notes and Loans Payable Notes and Loans Payable to Parent Notes Payable Other Accrued Expenses Other Assets Other Assets (Restricted use) Other Current Liabilities Other Deferred Credits Other Intangible Assets Other Investments Payables to Third Party Payors Pledges And Other Receivables Preferred Stock Preopening And Other Organization Costs Prepaid Expenses PROPERTY, PLANT AND EQUIPMENT (FIXED ASSETS): Receivables From Third Party Payors Retained Earnings (Capital Account for Partnership or Sole Proprietorship) TOTAL TOTAL (FIXED ASSETS) TOTAL ASSETS TOTAL BOARD DESIGNATED ASSETS (Restricted use): TOTAL CURRENT ASSETS TOTAL CURRENT LIABILITIES TOTAL DEFERRED CREDITS TOTAL EQUITY TOTAL INTANGIBLE ASSETS TOTAL INVESTMENTS & OTHER ASSETS TOTAL LIABILITIES (DEBT) TOTAL LIABILITIES AND EQUITY TOTAL LONG TERM DEBT Treasury Stock Unamortized Loan Costs Bold font indicates section heading , subtotal, or total Oe PSRHPFPHPRHAFHFHEHEBHHOH 3,544,313 53,186 11,249 951,166 (256,770) 730,917 1,139,966 4,388,214 75,034,121 STANDUP MEMORIAL HOSPITAL BALANCE SHEET As of December 31, 2024 ASSETS CURRENT ASSETS: Cash Accounts Receivable Less-Estimated Uncollectable & Allowances Inventory Marketable Securities Other Assets Pledges And Other Receivables Prepaid Expenses Receivables From Third Party Payors Due From Restricted Funds Current Portion Of Funds Held In Trust TOTAL CURRENT ASSETS PROPERTY, PLANT AND EQUIPMENT (FIXED ASSETS): Land Land Improvements Leasehold Improvements Buildings Fixed Equipment - Building Service Fixed Equipment - Other Equipment Construction In Progress TOTAL (FIXED ASSETS) Less Accumulated Depreciation NET PROPERTY, PLANT & EQUIPMENT (FIXED ASSETS) BOARD DESIGNATED ASSETS (Restricted use): Cash (Restricted use) Marketable Securities (Restricted use) Other Assets (Restricted use) TOTAL BOARD DESIGNATED ASSETS (Restricted use): INVESTMENTS AND OTHER ASSETS: Investments In Property, Plant & Equipment Less - Accumulated Depreciation Other Investments Other Assets TOTAL INVESTMENTS & OTHER ASSETS $ 8,131,300 $ 52,067,351 $ (9,757,996) $ 50,440,655 formula formula formula formula formula INTANGIBLE ASSETS: Goodwill Other Intangible Assets Preopening And Other Organization Costs Unamortized Loan Costs TOTAL INTANGIBLE ASSETS TOTAL ASSETS LIABILITIES AND FUND BALANCES-UNRESTRICTED CURRENT LIABILITIES Accounts Payable Accrued Compensation and Related Liabilities Current Maturities of Long Term Debt Due to Restricted Funds Income Taxes Payable Notes and Loans Payable Notes and Loans Payable to Parent Other Accrued Expenses Other Current Liabilities Advances from Third Party Payors Payables to Third Party Payors TOTAL CURRENT LIABILITIES DEFERRED CREDITS: Deferred Income Taxes Deferred Third Party Revenue Other Deferred Credits TOTAL DEFERRED CREDITS LONG TERM DEBT Bonds Payable Capitalized Lease Obligations Construction Loans-Interim Financing Mortgage Payable Notes Payable Noncurrent Liabilities Less Current Maturities of Long Term Debt TOTAL LONG TERM DEBT EQUITY (INVESTOR OWNED)or NET ASSETS (Non-Profit) Common Stock ($1 par) Preferred Stock $ formula 50,440,655 formula formula formula formula Additional Paid In Capital Retained Earnings (Capital Account for Partnership or Sole Proprietorship) Less Treasury Stock TOTAL EQUITY TOTAL LIABILITIES AND EQUITY In Balance FALSE formula formula