Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Please use the photos to calculate the following 1.current ratio, 2. Quick ratio, 3. Days of cash on hand 4. Receivable turnover 5.average collection period

image text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribed

Please use the photos to calculate the following

1.current ratio, 2. Quick ratio, 3. Days of cash on hand 4. Receivable turnover 5.average collection period 6.fixed asset turnover 7.total asset turnover 8. Total debt 9. Debt to equity 10. Times interest earned 11. Cash flow coverage 12.operating margins 13. Total margin 14. Return on total assets 15. Return on net assets.

the following should be calculated for both years 2018 and 2017.

1. current ratio, 2. quick ratio 3.days of cash on hand 4. receivables turnover 5. Average collection period 6. fixed asset turnover 7. total asset turnover 8. total debt 9. Debt to equity 10. Times earned interest 11. Cash flow coverage 12. operating margin 13. total margin 14. return on total assets 15. return on net assets.

please calculate for the year 2028 and 2017

2017 and 2018

the ratios should be calculated for year 2017 and 2018

ASSOCIATED BLACK CHARITIES, INC Statements of Financial Position As of Nanamhar 219018 and 2017 ASSOCIATED BI.ACK CHARITIES, INC. Statements of Activities and Changes in Net Assets For the Years Ended December 31, 2018 and 2017 ASSOCIATED BLACK CHARITIES, INC. Statement of Functional Expenses For the Year Ended December 31, 2018 with Comparative Totals for 2017 ASSOCIATED BLACK CHARITIES, INC. Statement of Functional Expenses For the Year Ended December 31, 2017 Total The accompanying notes are an 6 ASSOCIATED BLACK CHARITIES, INC. statements of Cash Flows For the Years Ended December 31, 2018 and 2017 The following tables set forth by level, the fair value hierarchy of the Organization's investments at fair value as of December 31,2018 and 2017 : For the years ended December 31, 2018 and 2017, investment income consisted of the following: 4. PROPERTY AND EQUIPMENT Property and equipment as of December 31, 2018 and 2017, consisted of the following: Depreciation expense for the years ended December 31, 2018 and 2017, was $10,365 and $8,791, respectively. TIES, INC. Notes to the Financial Statements December 31,2018 and 2017 5. NET ASSETS WITH DONCR RESTRICTICNS With donor restrictions net assets as of December 31,2018 and 2017 , were available for the following purposes: 6. LIQUIDITY AND AVAILABILITY The Organization receives contributions from donors which may or may not be restricted for specific purposes. Financial assets of the Organization are primarily comprised of cash and grants receivable from donors. The Organization structures its financial assets to be available as general expenditure liabilities and other obligations come due. To achieve this, the Organization forecasts its future cash flows and monitors its liquidity on a monthly basis. Management and the Board have been monitoring the Organization's cash balances to ensure that there is at least 3 months of working capital available throughout the vear. 6. LIQUIDITY AND AVAILABILITY (oontinued) The following table summarizes the Organization's financial assefs available, that is without within one year of the balance shotions limeir use, for grant obligations and abwams anenditure 7. CONCENTRATION OF RISK The Organization's primary revenue source is a Federal grant. For the years ended December 31, 2018 and 2017, the Organization earned $14,560,550 and $14,531,177, respectively, from the Grantor, which was 68% and 86%, respectively, of total revenue and support. A reduction in funding level could have a significant impact on the Organization. The Organization's grant from the government provides pass-through funding to providers for services under the HIV Emergency Relief Grant Program - Ryan White. Most grants and cost-reimbursable contracts specify the types of expenditures for which the grant or contract funds may be used. The Organization also earned $4,794,261 from the City of Baltimore for the year ended December 31, 2018, to administer the Baltimore Children and Youth Fund, of which $4,625,807 was distributed to third parties and $169,000 was retained by the Organization as management fee revenue. Certain expenses of these funds are subject to audit by the Grantor, and to the extent an audit determines any expenses were disallowed, the amount is subject to refund to the Grantor. Management does not believe any refund, if required as of December 31, 2018 and 2017, vould be material to the financial statements as a whole. The Thrift Plan is qualified under section 403(b) of the Internal Revenue Code. Employees are eligible to participate after completing one year of service and they must be at least 21 years of age. Total contributions for the years ended December 31,2018 and 2017, were approximately $14,480 and $14,896, respectively. 9. OPERATING LEASES On May 11, 2018, the Organization entered into a 6-year and 6-month operating lease for office space for its corporate offices in Baltimore which expires December 31, 2024. The base rent is $9,210 per month, with a 3% escalation clause each year. Future minimum payments under the leases, as of December 31, 2018, were as follows: Rent expense for the years ended December 31, 2018 and 2017 were $80,015 and $84,346, respectively. ASSOCIATED BLACK CHARITIES, INC Statements of Financial Position As of Nanamhar 219018 and 2017 ASSOCIATED BI.ACK CHARITIES, INC. Statements of Activities and Changes in Net Assets For the Years Ended December 31, 2018 and 2017 ASSOCIATED BLACK CHARITIES, INC. Statement of Functional Expenses For the Year Ended December 31, 2018 with Comparative Totals for 2017 ASSOCIATED BLACK CHARITIES, INC. Statement of Functional Expenses For the Year Ended December 31, 2017 Total The accompanying notes are an 6 ASSOCIATED BLACK CHARITIES, INC. statements of Cash Flows For the Years Ended December 31, 2018 and 2017 The following tables set forth by level, the fair value hierarchy of the Organization's investments at fair value as of December 31,2018 and 2017 : For the years ended December 31, 2018 and 2017, investment income consisted of the following: 4. PROPERTY AND EQUIPMENT Property and equipment as of December 31, 2018 and 2017, consisted of the following: Depreciation expense for the years ended December 31, 2018 and 2017, was $10,365 and $8,791, respectively. TIES, INC. Notes to the Financial Statements December 31,2018 and 2017 5. NET ASSETS WITH DONCR RESTRICTICNS With donor restrictions net assets as of December 31,2018 and 2017 , were available for the following purposes: 6. LIQUIDITY AND AVAILABILITY The Organization receives contributions from donors which may or may not be restricted for specific purposes. Financial assets of the Organization are primarily comprised of cash and grants receivable from donors. The Organization structures its financial assets to be available as general expenditure liabilities and other obligations come due. To achieve this, the Organization forecasts its future cash flows and monitors its liquidity on a monthly basis. Management and the Board have been monitoring the Organization's cash balances to ensure that there is at least 3 months of working capital available throughout the vear. 6. LIQUIDITY AND AVAILABILITY (oontinued) The following table summarizes the Organization's financial assefs available, that is without within one year of the balance shotions limeir use, for grant obligations and abwams anenditure 7. CONCENTRATION OF RISK The Organization's primary revenue source is a Federal grant. For the years ended December 31, 2018 and 2017, the Organization earned $14,560,550 and $14,531,177, respectively, from the Grantor, which was 68% and 86%, respectively, of total revenue and support. A reduction in funding level could have a significant impact on the Organization. The Organization's grant from the government provides pass-through funding to providers for services under the HIV Emergency Relief Grant Program - Ryan White. Most grants and cost-reimbursable contracts specify the types of expenditures for which the grant or contract funds may be used. The Organization also earned $4,794,261 from the City of Baltimore for the year ended December 31, 2018, to administer the Baltimore Children and Youth Fund, of which $4,625,807 was distributed to third parties and $169,000 was retained by the Organization as management fee revenue. Certain expenses of these funds are subject to audit by the Grantor, and to the extent an audit determines any expenses were disallowed, the amount is subject to refund to the Grantor. Management does not believe any refund, if required as of December 31, 2018 and 2017, vould be material to the financial statements as a whole. The Thrift Plan is qualified under section 403(b) of the Internal Revenue Code. Employees are eligible to participate after completing one year of service and they must be at least 21 years of age. Total contributions for the years ended December 31,2018 and 2017, were approximately $14,480 and $14,896, respectively. 9. OPERATING LEASES On May 11, 2018, the Organization entered into a 6-year and 6-month operating lease for office space for its corporate offices in Baltimore which expires December 31, 2024. The base rent is $9,210 per month, with a 3% escalation clause each year. Future minimum payments under the leases, as of December 31, 2018, were as follows: Rent expense for the years ended December 31, 2018 and 2017 were $80,015 and $84,346, respectively

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Financial Accounting An Introduction

Authors: Alex Watson, Jacqui Kew

5th Edition

0190425520, 978-0190425524

More Books

Students also viewed these Accounting questions

Question

In what ways are you similar to your closest friends?

Answered: 1 week ago