Financial Management Homework Assignment #11 Do Something The Board of Directors of Do Something has asked you to analyze the organization's financial statements and provide a brief but thorough memo describing its current financial health.1 Using the financial statements and the Excel template: 1. Calculate the following sets of ratios for 2014: . Profitability o Turnover . Liquidity Leverage Program services BalanceSheet Activity Statement Cash Flow Statement Profitability & Tu Statement of Financial Position December 31, 2014 (with summarized comparative totals at December 31, 2013) Assets 2014 2013 $10,315,136 $10,989,368 548.741 306.254 95,060 24.256 114,760 404.919 $15.505,183 $12.483.358 Cash and cash equivalents Investments Other receivables Prepaid expenses Security deposits Fixed assets, net 550,123 3.771,828 114,550 75,671 18,221 559,654 Total assets Liabilities Accounts payable and accrued expenses Grants payable Deferred rent Other liabilities 290,206 $263,325 113,500 38.529 19.5 2.731.942 2.379,035 3,147.296 1,528,500 40,994 Total liabilities Net assets 10,501,187 ,278,411 2.624,961 3.057.651 13.126,148 9,336.062 Total net assets Total liabilities and net assets $15.505,183 $12.4833 BalanceSheet Activity Statement Cash Flow Statement Profitability &Tu Profitability and Turnover Ratios: link to the financial statement worksheets whenever pessible, entering additional information from the notes to the financial statements as needed. The first one has been done for you as an example (click to see formulas) Profitability Ratios 28.87% Return on Assets Unrestricted Revenue& Support Receivables Turnover Why didn't we ask you to calculate inventory turnover ratios7 BalanceSheet Activity Statement Cash Flow Statement Profitability & Tu Cash flows from operating activities 22.262) (10 691) 5.248 4,776 (24.207) 19.4909 1 415 7.442 422 048 202,22209,077 222-184)12.922 674 232) 138.349 Net change in cash Do Something uses an alternative accounting treatmend for bad debta and reakzed gaina which a why BalanceSheet Activity Statement Cash Flow Statement Profitability & Tu De Something, Inc For the Year Ended December 31,2014 Unrestricted Res Operating support and revenue 730,000 $3,792,000 ,343,624 4549,900 6,493,524$,585,67 $3,062,000 Corporations Special events (net of direct expense of $126,125 Donated servic ard materials Consulting fees Licensing fees Investment income 128,692 959,034 11,224,088 990,499 128,692 59,034 0 11,224,088 990,499 970,336 7,794,254 407,500 475,000 5,675 37,884 0,000 37,884 0,000 from restrictions .712,5905.712.590) 24.503,411(432.690)24.070.721 16.227.691 Total revenues, gains and other support Operating expenses: Program services Supporting services 0 19,381,46213,327,091 Management and general Fundraising 738,849 160,324 20.280,635 263.591 o20.280,635 14.146.54 738,849 60,324 Total operating expenses Change in net assets Net assets, beginning of year Net assets, end of year 4,222,776 (432,690) 3,790,086 2,081,143 .254.919 $10.501.187 $2.62491 $13.126.148 .336.962 6.278,411305.9.336.062