Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Based on the below information, using the same financial statements, calculate the ratios on the worksheet below. Show work and result, and comment on the
Based on the below information, using the same financial statements, calculate the ratios on the worksheet below. Show work and result, and comment on the result: what would be a healthy ratio and why; and whether the result you calculated of concern or not. For the last two ratios, be sure to choose two additional ones
Use this link for additional help if it's necessary : https://wrcmn.org/content/205/f8f5339e/2019WRCAudit.pdf
Please fill the worksheet below
STATEMENT OF FINANCIAL POSITION December 31, 2019 [With Comparative Totals for 2018] Cash Contributions receivable Prepaid expenses Merchandise inventory Cash capital campaign ASSETS Cash restricted for purchase of property and equipment Property and equipment, net Total a ssets Accounts payable LIABILITIES AND NET ASSETS Accrued payroll and related expenses Accrued interest Note payable, net Lines of credit Total liabilities Net assets: Without donor restrictions Undesignated Board designated Nest Egg Fund Board designated for capital campaign Total Board designated Total net assets without donor restrictions With donor restrictions Total net assets Total liabilities and net assets 2019 5 4,251 352,200 21,212 5,120 75,541 31,415 1,326,223 5 2,873,572 5 38,314 21,299 1,950I 442,203 95,923 605,139 1,253,409 45,310 42,905 33,223 1,341,532 925,251 2,257,383 5 2,323,522 2018 5 120,931 132,100 11,230 4,112 24,325 1,200,355 5 1,543,155 5 29,037 9,505 250,000 288,542 1,052,819 45,313 45,313 1,093,132 156,4?5 1,254,613 5 1,543,155 Other Accounting Age of Fixed Accumulated Assets depreciation/Depreciation expense Choose two more ratios from your readings that you think would be important to look at: 1. 2.WILDLIFE REHABILITATION CENTER OF MINNESOTA STATEMENT OF ACTIVITIES For the Year Ended December 31, 2019 (With Comparative Totals for 2018) 2019 Without donor With donor restrictions restrictions Total 2018 Revenue and support: Contributions $ 1,621,193 $ 875,751 $ 2,496,944 $ 1,258,573 Special events income net of direct donor benefits of $76,128 in 2019 and $72,028 in 2018 73,485 73,485 104,218 Contract revenue 81,725 81,725 Other revenues 28,299 28,299 28,498 Net assets released from restrictions 106,476 (106,476) Total revenue and support 1,911,178 769,275 2,680,453 1,391,289 Expenses: Program services 1,389,645 1,389,645 1,131,754 Management and general 113,472 113,472 119,288 Fundraising 164,566 164,566 126,860 Total expenses 1,667,683 1,667,683 1,377,902 Change in net assets 243,495 769,275 1,012,770 13,387 Net assets: Beginning of year 1,098,137 156,476 1,254,613 1,241,226 End of year $ 1,341,632 $ 925,751 $ 2,267,383 $ 1,254,613WILDLIFE REHABILITATION CENTER OF MINNESOTA STATEMENT OF FUNCTIONAL EXPENSES For the Year Ended December 31, 2019 {With Comparative Totals for 2018} 2019 Program Management Direct donor services and general Fundraising benets Total 2018 Salaries S 599,810I 5 30,310 $ 30,130I S - S 250,250 5 509,502 Employee benefits 58,014 4,494 2,480 24,988 54,545 Payroll taxes 50,258 2,315 2,303 55,382 44,555 Total salaries and related expenses 818,592 32, 120 34,913 - 890,525 208,218 Professional fees 14,459 8,008 14,383 35,850 55,282 Food 110,925 - 23,951 134,882 120,953 Bank charges and credit card fees 3,145 21,201 24,342 22,209 Telephone and internet 5,438 1,099 244 - 8,281 2,841 Printing and postage 3,915 541 31,405 - 35,953 35,553 Utilities 52,555 5,295 5,995 24,942 2 1,093 Insurance 11,219 1,122 1,121 14,012 10,585 Equipment rental and maintenance 55,232 25,111 5,539 - 92,382 81,532 Interest - 18,510 - - 18,510 1 1,820 Interest - amortization of finance fees 903 903 - Depreciation 52,828 5,318 5,012 25,213 20,012 Travel 3,520 509 413 4,592 3,345 Dues and subscriptions 2,342 - - - 2,342 1,255 Stafftraining 5,819 - 500I - 2,319 11,122 Supplies: Medical 124,952 - 124,952 101,334 Lab 15,288 - 15,288 15,895 General 45,581 2,422 1,195 - 50,253 42,002 Volunteer recognition 2,455 - 15 - 2,420 2,955 Special event: 45,245 Services - 40,300 14,953 55,253 - Entertainment - 10,252 10,252 - Rental - - - 25,942 25,942 - Miscellaneous expenses 28,292 952 824 - 30,523 9,393 5 1,389,545 S 113,422 5 154,555 5 25,128 5 1,243,811 5 1,449,932 Less special events direct donor benefits - [25,128] {25,128} {22,028} 5 1,389,545 S 113,422 5 154,555 5 5 1,552,583 5 1,322,904 WILDLIFE REHABILITATION CENTER OF MINNESOTA STATEMENT OF CASH FLOWS For the Year Ended December 31, 2019 [With Comparative Totals for 2013! Increase {Decrease} in Cash Cash flows from operating activities: Change in net assets Adjustments to reconcile the change in net assets to net cash from operating activities: Depreciation and amortization Changes in operating assets and liabilities: Contributions receivable Prepaid expenses Merchandise inventory Accounts payable Accrued expenses Net cash from operating activities [ash flows from investing activities: Purchase of propertyr and equipment Net cash from investing activities [ash flows from financing activities: Proceeds from {payments on! lines of credit, net Proceeds from note payable Payment ofnance fees Net cash from nancing activities Net increase {decrease} in cash and restricted cash Cash and restricted cash beginning of year [ash and restricted cash - end of year Reconciliation to the statement of financial position Cash Cash - capital campaign Cash restricted for purchase of property and equipment Total cash and restricted cash Supplemental disclosures of cash flow information: Cash paid for interest expense 2019 5 1,012,??0 ?5, 115 [?25, 100] [9,932] [2,053] 9,27\"? 13,?44 3?4,31? {?51,530] {?51,530] [150,000] 455,000 [11,2??] 293,?23 (83,090] 195,30? 5 112,21? 5 4,251 ?5,541 31,415 5 112,21? 5 15,550 2013 5 13,38? ?0,01? {1 13,?93! [5,199] 1,084 ?,395 [2,333] [29,94?) [15,9?4] [15,9?4] 225,000 225,000 1?Q,0?9 15,223 .5 195,30? 5 1?0,S31 24,3?5 5 195,30? 5 11,3?0 WILDLIFE REHABILITATION CENTER OF MINNESOTA NOTES TO FINANCIAL STATEMENTS For the Year Ended December 31, 2019 (With Comparative Totals for 2018) 3. LIQUIDITY AND AVAILABILITY OF RESOURCES Financial assets available for general expenditure within one year of the statement of financial position date are as follows: 2019 2018 Cash 4,261 S 170,931 Cash - capital campaign 76,541 Cash restricted for purchase of property and equipment 31,415 24,376 Contributions receivable 857,200 132,100 Total financial assets available within one year 969,417 327,407 Less: Long-term time restricted contributions (510,000) (50,000) Total financial assets available within one year $ 459,417 $ 277,407WILDLIFE REHABILITATION CENTER OF MINNESOTA NOTES TO FINANCIAL STATEMENTS For the Year Ended December 31, 2019 (With Comparative Totals for 2018) 4. CONTRIBUTIONS RECEIVABLE Contributions receivable as of December 31, 2019 consist of: Capital Operations campaign Total 2020 $ 255,000 $ 92,200 $ 347,200 2021 505,000 505,000 2022 5,000 5,000 $ 765,000 $ 92,200 $ 857,200 5. PROPERTY AND EQUIPMENT Property and equipment consisted of the following: Estimated useful 2019 2018 life - years Land 482,503 $ Land improvements 54,360 5,000 15 Building and building improvements 2,095,789 1,919,321 10 - 39 Equipment 154,096 113,797 3 - 10 Software 4,078 4,078 3 Construction in process 3,000 2,793,826 2,042,196 Accumulated depreciation (917,053) (841,840) $ 1,876,773 $ 1,200,356WILDLIFE REHABILITATION CENTER OF MINNESOTA NOTES TO FINANCIAL STATEM ENTS For the Year Ended December 31, 2019I {With Comparative Totals for 2018} NET ASSETS WITH DONOR RESTRICTIONS Net assets with donor restrictions are restricted for the following purposes or periods: 2019 2013 Subject to expenditure for specified purpose: Purchase and repair of equipment 5 31,415 $ 24,326 Capital campaign 802,135 Subject to the passage of time: For periods after December 31, 2019 92,200 132,100 Total net assets with donor restrictions 3 925,751 S 156,426 WILDLIFE REHABILITATION CENTER OF MINNESOTA STATEMENT OF ACTIVITIES BY CLASS For the Year Ended December 31, 2019 Revenue and support: Contributions Special events income, net 23,435 - 23,435 Contract revenue 31,225 31,225 Other revenues 23,299 - 23,299 Total revenue and support 1,463,635 1,211,313 2,630,453 Expenses: Salaries 325,452 65,123 390,625 Office expenses 194,415 - 194,415 Supplies 302,934 302,934 Equipment 49,123 43,209 92,332 Interest 14,331 3,229 13,610 Depreciation and amortization 24,933 1,133 26,116 Other 32,596 32,596 Total expenses 1,549,339 113,344 1,662,633 Change in net assets {30,204} 1,093,424 1,012,220 Net assets: Beginning of year 1,254,613 - 1,254,613 End of year 5 1,123,909 $ 1,093,424 $ 2,262,333 General Operations 5 1233125 Capital Campaign 5 1,211,313 Total samsma Financial Ratios for Wildlife Rehabilitation Center of Minnesota for the fiscal year 2017 Category Ratio Formula Results/Comments Financial Performance % Return on revenue Change in net assets/Total revenue x 100 Financial strength Liquidity - Days' Cash (Cash plus cash equivalents)/(Total expenses less nonfinancial expenses) x 365 Liquidity - Current Ratio Current assets/Current liabilities Leverage - Debt to Equity Total debt/Total unrestricted net Ratio assets Financial risk Reliance on Revenue Revenue source/Total revenues Source Organizational efficiency Program Spending Ratio Program expenses/Total expenses x 100 Payable Days Accounts Payable/Total expenses x 365Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started