Question:
Using Table 14. 1 and Table 14. 2 from the text, calculate the current ratio, days cash on hand, days in accounts receivable, total asset turnover, interest coverage, long-term debt to net assets, total margin, and return on assets for 2023. Show your work.
The following question was written by Blair Williams:
Table 14.1
Table 14.2
Transcribed Image Text:
Assets Current Assets Cash Marketable securities Accounts receivable, net Inventory Prepaid expenses Total current assets Long-Term Assets Buildings and equipment Less accumulated depreciation Net buildings and equipment Land Goodwill Total long-term assets Total assets 2023 2022 Liabilities and Net Assets Liabilities Current Liabilities Wages payable Accounts payable Unearned revenue 4.5% $ 30,000 3.7% $ 23,000 4.8% 32,000 4.2% 26,000 68,000 7.9% 52,000 11.0% 16.1% 106,000 14.2% 88,000 Total current liabilities 14.000 12,000 2.1% 1.9% 35.5% $234.000 34.9% $217,000 46.7% $308,000 41.2% $256.000 13.3% 88,000 11.0% 68,000 33.3% $ 220,000 30.3% $188,000 16.4% 14.8% 108,000 17.4% 98,000 17.4% 108,000 64.5% $426,000 65.1% $404,000 Long-Term Liabilities Mortgage payable Bond payable Other 109,000 Total long-term liabilities Total liabilities Net Assets Without donor restrictions With donor restrictions Total net assets 100.0% $660.000 100.0% $621,000 Total liabilities and net assets 2023 2022 2.1% $ 14,000 1.9% $ 12,000 10.0% 66,000 9.3% 58,000 5.8% 38,000 5.2% 32,000 17.9% $ 118,000 16.4% $102,000 14.9% $98,000 17.4% $ 108,000 208,000 31.5% 208,000 33.5% 13.0% 86,000 12.6% 78,000 59.4% $392,000 63.4% $394.000 77.3% $510,000 79.9% $496,000 10.9% $ 72,000 7.6% $ 47,000 11.8% 78,000 12.6% 78,000 22.7% $ 150,000 20.1% $ 125,000 100.0% $660,000 100.0% $621,000