CHAPTER 14 Financial Statement Analysis 549 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 Change's overall financial position and performance? Why? In your assessment, make reference to each ratio you calculated. 14-11. 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: Excel File Edit View Insert Format Tools Data Window Help 6E-14_11 9. 2. 2. Y. & 100% Home Review Edit Wrap Text General Layout Tables Charts SmartArt Formulas Data Font Alignment FRI Times New Roman - 12 A. A abc Clear B I U . . X fx NET ASSETS WITHOUT DONOR RESTRICTIONS D Problem 14-11 Paste Merge A29 E F TEMPLATE PARTA December 30, 2020 % s December 30, 2019 % S CODE 4 CHANGE Statements of Financial Position . Common Size Ratios 9 2 2 3 ASSETS 4 CASH AND CASH EQUIVALENTS 5 INTEREST AND DIVIDENDS RECEIVABLE 6 CAMPAIGNS' PLEDGES RECEIVABLE 7 PREPAID EXPENSES AND OTHER 18 INVESTMENTS 19 20 TOTAL 21 22 LIABILITIES AND NET ASSETS 23 LIABILITIES: 24 Accounts payable DAV 25 Accounts payable other 26 Annuity payment liability 27 Total liabilities 1,909,606 61,244 373,788 16.244 10.944.924 1.044,193 52,582 358,632 25,367 9,653 039 13.305.806 11,133,813 201,721 910 171,550 1,012 3.679.148 3.851,715 4,059 893 29 NET ASSETS WITHOUT DONOR RESTRICTIONS 30 31 TOTAL 9.245.913 7.282,098 13 305 306 11.133.813 33 35 Normal View Common Size Balance Sheet Ready Common Sure Activity Statement Parts B to G 6E 100 A Home Layout Tables Charts SmartArt Formulas Data Review Edit Font Fill Times New Roman 12 Alignment abc Wrap Text A- A- . Paste Clear B. U Merge 8 C D E F H32 x fx 1 PART A (Continued) 2 3 CODE 4 CHANGE 4 Statements of Activities 5 Common Size Ratios 6 7 8 SUPPORT AND REVENUE: 9 Contributions 10 Contributions of charitable gift annuities 11 Bequests 12 Investment income 14 10 support au revenue December 30, 2020 % S December 30, 2019 % S 4,771,172 241, 245 2,178,924 766580 7,957,921 2,654,400 178,626 32,436,803 384,670 35,654,499 16 EXPENSES: 17 Program services 18 Management and general 19 Fundraising 6,053,675 85,933 179.272 34,754,236 75,499 168.316 21 Total expenses 6318.885 34,998.01 CHANGE IN NET ASSETS BEFORE CHANGE IN UNREALIZED APPRECIATION 23. OF INVESTMENTS 24 CHANGE IN UNREALIZED APPRECIATION 25 OF INVESTMENTS 1.639,036 656,448 27 CHANGE IN NET ASSETS 328279 428759 29 NET ASSETS Beginning of year 1,963.815 1.084,607 2282.09 31 NET ASSETS End of year 6.19729) 9245913 7.282.098 30 [ Normale Common Size Balance Sheet Ready Common Size Activity Statement Parts 3 to 6 Excel File Edit View Insert Format Tools Data Window 9. 01. 2. 2. - Y- A Home Layout Tables Charts SmartArt Formulas Data Revies Edit Font FIN Times New Roman 12 A A- Alignment abc Wrap TE Paste Clear U A- Merg H55 - A B D E G H 3 PART B 2020 2019 5 Current Ratio 5 3 8 CO 11 PARTC 12 13 Days Cash 14 on Hand 15 16 17 18 19 PART D 20 21 Debt Ratio 22 23 24 25 26 32 33 34 35 36 37 PARTE 38 39 Total margin 40 41 42 43 45 46 PART G 47 48 Program Services 49 50 51 S2 53 55 58 67 Common Size Balance Sheet Ready Common Size Activity Statement Normal view Parts & to G CHAPTER 14 Financial Statement Analysis 549 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 Change's overall financial position and performance? Why? In your assessment, make reference to each ratio you calculated. 14-11. 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: Excel File Edit View Insert Format Tools Data Window Help 6E-14_11 9. 2. 2. Y. & 100% Home Review Edit Wrap Text General Layout Tables Charts SmartArt Formulas Data Font Alignment FRI Times New Roman - 12 A. A abc Clear B I U . . X fx NET ASSETS WITHOUT DONOR RESTRICTIONS D Problem 14-11 Paste Merge A29 E F TEMPLATE PARTA December 30, 2020 % s December 30, 2019 % S CODE 4 CHANGE Statements of Financial Position . Common Size Ratios 9 2 2 3 ASSETS 4 CASH AND CASH EQUIVALENTS 5 INTEREST AND DIVIDENDS RECEIVABLE 6 CAMPAIGNS' PLEDGES RECEIVABLE 7 PREPAID EXPENSES AND OTHER 18 INVESTMENTS 19 20 TOTAL 21 22 LIABILITIES AND NET ASSETS 23 LIABILITIES: 24 Accounts payable DAV 25 Accounts payable other 26 Annuity payment liability 27 Total liabilities 1,909,606 61,244 373,788 16.244 10.944.924 1.044,193 52,582 358,632 25,367 9,653 039 13.305.806 11,133,813 201,721 910 171,550 1,012 3.679.148 3.851,715 4,059 893 29 NET ASSETS WITHOUT DONOR RESTRICTIONS 30 31 TOTAL 9.245.913 7.282,098 13 305 306 11.133.813 33 35 Normal View Common Size Balance Sheet Ready Common Sure Activity Statement Parts B to G 6E 100 A Home Layout Tables Charts SmartArt Formulas Data Review Edit Font Fill Times New Roman 12 Alignment abc Wrap Text A- A- . Paste Clear B. U Merge 8 C D E F H32 x fx 1 PART A (Continued) 2 3 CODE 4 CHANGE 4 Statements of Activities 5 Common Size Ratios 6 7 8 SUPPORT AND REVENUE: 9 Contributions 10 Contributions of charitable gift annuities 11 Bequests 12 Investment income 14 10 support au revenue December 30, 2020 % S December 30, 2019 % S 4,771,172 241, 245 2,178,924 766580 7,957,921 2,654,400 178,626 32,436,803 384,670 35,654,499 16 EXPENSES: 17 Program services 18 Management and general 19 Fundraising 6,053,675 85,933 179.272 34,754,236 75,499 168.316 21 Total expenses 6318.885 34,998.01 CHANGE IN NET ASSETS BEFORE CHANGE IN UNREALIZED APPRECIATION 23. OF INVESTMENTS 24 CHANGE IN UNREALIZED APPRECIATION 25 OF INVESTMENTS 1.639,036 656,448 27 CHANGE IN NET ASSETS 328279 428759 29 NET ASSETS Beginning of year 1,963.815 1.084,607 2282.09 31 NET ASSETS End of year 6.19729) 9245913 7.282.098 30 [ Normale Common Size Balance Sheet Ready Common Size Activity Statement Parts 3 to 6 Excel File Edit View Insert Format Tools Data Window 9. 01. 2. 2. - Y- A Home Layout Tables Charts SmartArt Formulas Data Revies Edit Font FIN Times New Roman 12 A A- Alignment abc Wrap TE Paste Clear U A- Merg H55 - A B D E G H 3 PART B 2020 2019 5 Current Ratio 5 3 8 CO 11 PARTC 12 13 Days Cash 14 on Hand 15 16 17 18 19 PART D 20 21 Debt Ratio 22 23 24 25 26 32 33 34 35 36 37 PARTE 38 39 Total margin 40 41 42 43 45 46 PART G 47 48 Program Services 49 50 51 S2 53 55 58 67 Common Size Balance Sheet Ready Common Size Activity Statement Normal view Parts & to G