Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

1. The need help with finance with the calculate the grants receivable turnover ratio and the average grant collection for the year 2000 to 1999

1. The need help with finance with the calculate the grants receivable turnover ratio and the average grant collection for the year 2000 to 1999

Grants receivable turnover is equal to the total grant revenue / grants receivable

Average grant collection period is equal to 365 / grants receivable turnover

2. Is there a trend in grants receivable turnover favorable or unfavorable and why?

3. Is values of the average grant collection period warrant concern over the collection procedures of the grants?

4. How much cash was borrow in 2000?

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

2000 1999 $ Assets Current assets Cash Grants receivable Due from MountainMade Deposits 116,179 284,125 22,133 4,336 135,500 1,802 Total current assets 422,437 141,638 Property and equipment Furniture and equipment, net 14,314 _10,187 Total assets $ 436,751 $ 151,825 Liabilities and net assets Current liabilities Accounts payable Payroll liabilities Loan loss reserve Loan origination fees Total current liabilities 1,682 6,753 3,160 2,436 2,004 2,622 2,445 2,032 9,103 14,031 Net assets Unrestricted Temporarily restricted 72,186 350,534 31,664 111,058 142,722 Total net assets 422,720 Total liabilities and net assets $ 436,751 $ 151,825 Temporarily Restricted 2000 Total 1999 Total Unrestricted $ 462,739 $ $ 134,270 2,391 8,332 3,300 597,009 2,391 8,332 3,300 168,575 1,610 5,837 Revenue and support Grants Contributions Program income Contract revenue Special events Interest earned Net assets released from restrictions Total revenue and support 2,887 7,723 3,303 2,887 223,263 (223,263) 239,476 374,443 613,919 187,048 Expenses Program services Management & general Fundraising Total expenses 272,521 45,859 15,541 272,521 45,859 15,541 253,273 42,495 14,156 333,921 333,921 309,924 Change in unrestricted net assets 40,522 239,476 279,998 (122,876) Net assets, beginning of year 31,664 | 111,058 142,722 265,598 Net assets, end of year $ 72,186 $ 350,534 $ 422,720 $ 142,722 Mgmt & General Fund Raising Total 2000 Total 1999 Program $ $ 153,339 12,888 20,398 7,470 9,052 $ 20,636 1,688 2,671 978 1,006 $ 9,150 767 1,214 445 $ 183,125 15,343 24,283 8,893 10,058 529 529 241 169 659 Salaries Payroll taxes Health insurance Retirement plan Auto expense Bank service charges Computer expense Copy and fax Insurance Office Supplies Professional fees Postage Printing Promotion Rent Resource materials/dues Special events Staff training/development Telephone Travel Video production Loan loss reserve Interest rebates Miscellaneous Depreciation 2,003 2,636 2,820 8,570 7,079 4,729 7,626 4,212 7,696 2,395 1,264 2,183 8,368 887 847 3,245 296 2,413 3,295 4,152 10,753 18,692 5,912 8,473 4,212 9,620 2,994 146,222 11,139 16,902 5,555 7,757 341 7,340 3,898 4,146 4,931 24,369 1,528 9,529 1,979 7,805 4,546 14,544 11,244 3,959 4,965 12,000 1,040 257 1,512 2,416 1,924 599 10,828 2,994 2,217 561 187 10,828 3,742 2,463 246 715 715 565 565 2,289 2,861 Total expenses $ 272,521 $ 45,859 $ 15,541 $ 333,921 $ 309,924 2000 1999 Cash flows from operating activities: Increase (decrease) in net assets 279,998 $ (122,876) Adjustments to reconcile change in net assets to net cash provided by operating activities: Depreciation 2,861 2,416 50,833 (Increase) decrease in operating assets: Grants receivable Due from Mountain Made Deposits (148,625) (22,133) 1,802 (1,802) Increase (decrease) in operating liabilities: Accounts payable Payroll liabilities Loan loss reserve Member origination fees Other current liabilities (322) 4,131 715 404 540 2,622 1,570 1,718 485 (64,494) Net cash provided by operating activities 118,831 Cash flows from investing activities: Purchase of equipment (6,988) (5,033) Net increase (decrease) in cash 111,843 (69,527) Cash and cash equivalents, beginning of year 4,336 73,863 Cash and cash equivalents, end of year $ 116,179 $ 4,336 2000 1999 $ Assets Current assets Cash Grants receivable Due from MountainMade Deposits 116,179 284,125 22,133 4,336 135,500 1,802 Total current assets 422,437 141,638 Property and equipment Furniture and equipment, net 14,314 _10,187 Total assets $ 436,751 $ 151,825 Liabilities and net assets Current liabilities Accounts payable Payroll liabilities Loan loss reserve Loan origination fees Total current liabilities 1,682 6,753 3,160 2,436 2,004 2,622 2,445 2,032 9,103 14,031 Net assets Unrestricted Temporarily restricted 72,186 350,534 31,664 111,058 142,722 Total net assets 422,720 Total liabilities and net assets $ 436,751 $ 151,825 Temporarily Restricted 2000 Total 1999 Total Unrestricted $ 462,739 $ $ 134,270 2,391 8,332 3,300 597,009 2,391 8,332 3,300 168,575 1,610 5,837 Revenue and support Grants Contributions Program income Contract revenue Special events Interest earned Net assets released from restrictions Total revenue and support 2,887 7,723 3,303 2,887 223,263 (223,263) 239,476 374,443 613,919 187,048 Expenses Program services Management & general Fundraising Total expenses 272,521 45,859 15,541 272,521 45,859 15,541 253,273 42,495 14,156 333,921 333,921 309,924 Change in unrestricted net assets 40,522 239,476 279,998 (122,876) Net assets, beginning of year 31,664 | 111,058 142,722 265,598 Net assets, end of year $ 72,186 $ 350,534 $ 422,720 $ 142,722 Mgmt & General Fund Raising Total 2000 Total 1999 Program $ $ 153,339 12,888 20,398 7,470 9,052 $ 20,636 1,688 2,671 978 1,006 $ 9,150 767 1,214 445 $ 183,125 15,343 24,283 8,893 10,058 529 529 241 169 659 Salaries Payroll taxes Health insurance Retirement plan Auto expense Bank service charges Computer expense Copy and fax Insurance Office Supplies Professional fees Postage Printing Promotion Rent Resource materials/dues Special events Staff training/development Telephone Travel Video production Loan loss reserve Interest rebates Miscellaneous Depreciation 2,003 2,636 2,820 8,570 7,079 4,729 7,626 4,212 7,696 2,395 1,264 2,183 8,368 887 847 3,245 296 2,413 3,295 4,152 10,753 18,692 5,912 8,473 4,212 9,620 2,994 146,222 11,139 16,902 5,555 7,757 341 7,340 3,898 4,146 4,931 24,369 1,528 9,529 1,979 7,805 4,546 14,544 11,244 3,959 4,965 12,000 1,040 257 1,512 2,416 1,924 599 10,828 2,994 2,217 561 187 10,828 3,742 2,463 246 715 715 565 565 2,289 2,861 Total expenses $ 272,521 $ 45,859 $ 15,541 $ 333,921 $ 309,924 2000 1999 Cash flows from operating activities: Increase (decrease) in net assets 279,998 $ (122,876) Adjustments to reconcile change in net assets to net cash provided by operating activities: Depreciation 2,861 2,416 50,833 (Increase) decrease in operating assets: Grants receivable Due from Mountain Made Deposits (148,625) (22,133) 1,802 (1,802) Increase (decrease) in operating liabilities: Accounts payable Payroll liabilities Loan loss reserve Member origination fees Other current liabilities (322) 4,131 715 404 540 2,622 1,570 1,718 485 (64,494) Net cash provided by operating activities 118,831 Cash flows from investing activities: Purchase of equipment (6,988) (5,033) Net increase (decrease) in cash 111,843 (69,527) Cash and cash equivalents, beginning of year 4,336 73,863 Cash and cash equivalents, end of year $ 116,179 $ 4,336

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

Public Finance A Contemporary Application Of Theory To Policy

Authors: David N Hyman

10th Edition

053875446X, 978-0538754460

More Books

Students also viewed these Finance questions

Question

What is the meaning of cointegration?

Answered: 1 week ago

Question

Does your message present a conclusion?

Answered: 1 week ago