Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Exhibits 14-11 and 14-12 present the statements of financial position and statements of activities for Code 4 Change, a fictional organization that provides training in

Exhibits 14-11 and 14-12 present the statements of financial position and statements of activities for Code 4 Change, a fictional organization that provides training in computer programming to the unemployed. For both 2021 and 2020, calculate the following:

a. Common size ratios for the statements of financial position and statements of activities

b. The current ratio

c. Days of cash on hand

d. The debt to equity ratio

e. The total margin

f. The program services ratio

How do you assess Code 4 Changes overall financial position and performance? Why? In your assessment, make reference to each ratio you calculated.

image text in transcribed

image text in transcribed

Can you please verify Part A and then complete part B through G in the template shown below

image text in transcribed

image text in transcribed

image text in transcribed

image text in transcribed

Exhibit 14-11 Exhibit 14-11 Code 4 Change Statements of Financial Position as of March 31, 2021 and 2020 Assets 2021 2020 Cash and cash equivalents $ 1,909,606 $ 1,044,193 Interest and dividends receivable 61,244 52,582 Pledges receivablenet of assessment fees and allowance for uncollectible pledges of $449,162 in 2021 and $464,486 in 2020 373,788 358,632 Prepaid expenses and other 16,244 25,367 Investments 10,944,924 9,653,039 Total $13,305,806 $11,133,813 Liabilities and Net Assets Liabilities: Accounts payable $ 202,631 $ 172,567 Annuity payment liability 3,857,262 3,679,148 Total liabilities $ 4,059,893 $3,851,715 Net Assets without Donor Restrictions 9,245,913 7,282,098 Total $13,305,806 $11,133,813 Exhibit 14-12 Code 4 Change Statements of Activities for the Years Ended March 31, 2021 and 2020 2021 2020 Support and Revenue Contribution-net of assessment fees and uncollectible pledges of $428,587 in 2021 and $433,252 in 2020 $4,771,172 $2,654,400 Contributions of charitable gift annuities 241,245 178,626 Bequests 2,178,924 32,436,803 Investment income-net 766,580 384,670 Total support and revenue $7,957,921 $35,654,499 Expenses: Program services $6,053,675 $34,754,236 Management and general 85,933 75,499 Fundraising 179,277 168,316 Total expenses $6,318,885 $34,998,051 Change in Net Assets Before Change in Unrealized Appreciation of Investments $1,639,036 S 656,448 Change in Unrealized Appreciation of Investments 324,779 428,159 $1,963,815 $1,084,607 Change in Net Assets Net AssetsBeginning of year 7,282,098 6,197,491 Net Assets-End of year $9,245,913 $ 7,282,098 Problem 14-11 TEMPLATE PARTA CODE 4 CHANGE Statements of Financial Position Common Size Ratios December 30, 2020 % S December 30, 2019 % S ASSETS CASH AND CASH EQUIVALENTS INTEREST AND DIVIDENDS RECEIVABLE CAMPAIGNS' PLEDGES RECEIVABLE PREPAID EXPENSES AND OTHER INVESTMENTS 14.35% 0.46% 2.81% 0.12% 82.26% 1,909,606 61,244 373,788 16,244 10.944.924 9.38% 0.47% 3.22% 0.23% 86.70% 1,044,193 52,582 358,632 25,367 9.653.039 TOTAL 100.00% 13,305,806 100.00% 11,133,813 LIABILITIES AND NET ASSETS LIABILITIES: Accounts payable-DAV Accounts payable other Annuity payment liability Total liabilities 1.52% 0.01% 28.99% 30.51% 201,721 910 3.857.262 4,059,893 1.54% 0.01% 33.04% 34.59% 171,550 1,017 3.679,148 3,851,715 NET ASSETS WITHOUT DONOR RESTRICTIONS 69.49% 9,245,913 65.41% 7,282,098 TOTAL 100.00% 13,305,806 100.00% 11,133,813 PART A (Continued) CODE 4 CHANGE Statements of Activities Common Size Ratios December 30, 2020 % S December 30, 2019 % s SUPPORT AND REVENUE: Contributions Contributions of charitable gift annuities Bequests Investment income net Total support and revenue 59.96% 4,771,172 3.03% 241,245 27.38% 2,178,924 9.63% 766.580 7.44% 0.50% 90.98% 1.08% 2,654,400 178,626 32,436,803 384.670 100.00% 7,957,921 100.00% 35,654,499 EXPENSES: Program services Management and general Fundraising Total expenses 95.80% 1.36% 2.84% 6,053,675 85,933 179.277 99.30% 0.22% 0.48% 34,754,236 75,499 168,316 100.00% 6.318.885 100.00% 34.998,051 CHANGE IN NET ASSETS BEFORE CHANGE IN UNREALIZED APPRECIATION OF INVESTMENTS CHANGE IN UNREALIZED APPRECIATION OF INVESTMENTS 20.60% 1,639,036 1.84% 656,448 4.08% 324.779 1.20% 428.159 CHANGE IN NET ASSETS 24.68% 1,963,815 3.04% 1,084,607 91.51% 7.282.098 17.38% 6.197.491 NET ASSETS -- Beginning of year NET ASSETS-End of year 116.19% 9,245,913 20.42% 7,282,098 2020 2019 PART B Current Ratio PARTC Days Cash on Hand PART D Debt Ratio 0.00% PARTE Debt to Equity PARTF Total margin PARTG Program Services Exhibit 14-11 Exhibit 14-11 Code 4 Change Statements of Financial Position as of March 31, 2021 and 2020 Assets 2021 2020 Cash and cash equivalents $ 1,909,606 $ 1,044,193 Interest and dividends receivable 61,244 52,582 Pledges receivablenet of assessment fees and allowance for uncollectible pledges of $449,162 in 2021 and $464,486 in 2020 373,788 358,632 Prepaid expenses and other 16,244 25,367 Investments 10,944,924 9,653,039 Total $13,305,806 $11,133,813 Liabilities and Net Assets Liabilities: Accounts payable $ 202,631 $ 172,567 Annuity payment liability 3,857,262 3,679,148 Total liabilities $ 4,059,893 $3,851,715 Net Assets without Donor Restrictions 9,245,913 7,282,098 Total $13,305,806 $11,133,813 Exhibit 14-12 Code 4 Change Statements of Activities for the Years Ended March 31, 2021 and 2020 2021 2020 Support and Revenue Contribution-net of assessment fees and uncollectible pledges of $428,587 in 2021 and $433,252 in 2020 $4,771,172 $2,654,400 Contributions of charitable gift annuities 241,245 178,626 Bequests 2,178,924 32,436,803 Investment income-net 766,580 384,670 Total support and revenue $7,957,921 $35,654,499 Expenses: Program services $6,053,675 $34,754,236 Management and general 85,933 75,499 Fundraising 179,277 168,316 Total expenses $6,318,885 $34,998,051 Change in Net Assets Before Change in Unrealized Appreciation of Investments $1,639,036 S 656,448 Change in Unrealized Appreciation of Investments 324,779 428,159 $1,963,815 $1,084,607 Change in Net Assets Net AssetsBeginning of year 7,282,098 6,197,491 Net Assets-End of year $9,245,913 $ 7,282,098 Problem 14-11 TEMPLATE PARTA CODE 4 CHANGE Statements of Financial Position Common Size Ratios December 30, 2020 % S December 30, 2019 % S ASSETS CASH AND CASH EQUIVALENTS INTEREST AND DIVIDENDS RECEIVABLE CAMPAIGNS' PLEDGES RECEIVABLE PREPAID EXPENSES AND OTHER INVESTMENTS 14.35% 0.46% 2.81% 0.12% 82.26% 1,909,606 61,244 373,788 16,244 10.944.924 9.38% 0.47% 3.22% 0.23% 86.70% 1,044,193 52,582 358,632 25,367 9.653.039 TOTAL 100.00% 13,305,806 100.00% 11,133,813 LIABILITIES AND NET ASSETS LIABILITIES: Accounts payable-DAV Accounts payable other Annuity payment liability Total liabilities 1.52% 0.01% 28.99% 30.51% 201,721 910 3.857.262 4,059,893 1.54% 0.01% 33.04% 34.59% 171,550 1,017 3.679,148 3,851,715 NET ASSETS WITHOUT DONOR RESTRICTIONS 69.49% 9,245,913 65.41% 7,282,098 TOTAL 100.00% 13,305,806 100.00% 11,133,813 PART A (Continued) CODE 4 CHANGE Statements of Activities Common Size Ratios December 30, 2020 % S December 30, 2019 % s SUPPORT AND REVENUE: Contributions Contributions of charitable gift annuities Bequests Investment income net Total support and revenue 59.96% 4,771,172 3.03% 241,245 27.38% 2,178,924 9.63% 766.580 7.44% 0.50% 90.98% 1.08% 2,654,400 178,626 32,436,803 384.670 100.00% 7,957,921 100.00% 35,654,499 EXPENSES: Program services Management and general Fundraising Total expenses 95.80% 1.36% 2.84% 6,053,675 85,933 179.277 99.30% 0.22% 0.48% 34,754,236 75,499 168,316 100.00% 6.318.885 100.00% 34.998,051 CHANGE IN NET ASSETS BEFORE CHANGE IN UNREALIZED APPRECIATION OF INVESTMENTS CHANGE IN UNREALIZED APPRECIATION OF INVESTMENTS 20.60% 1,639,036 1.84% 656,448 4.08% 324.779 1.20% 428.159 CHANGE IN NET ASSETS 24.68% 1,963,815 3.04% 1,084,607 91.51% 7.282.098 17.38% 6.197.491 NET ASSETS -- Beginning of year NET ASSETS-End of year 116.19% 9,245,913 20.42% 7,282,098 2020 2019 PART B Current Ratio PARTC Days Cash on Hand PART D Debt Ratio 0.00% PARTE Debt to Equity PARTF Total margin PARTG Program Services

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

Earnings Quality

Authors: Andrew P.C.

1st Edition

1521507724, 978-1521507728

More Books

Students also viewed these Finance questions