Lafayette Film Center (LFC) is a not-for-profit theater that presents independent films. In addition to revenue from theater admissions, LFC relies on concession and caf
Lafayette Film Center (LFC) is a not-for-profit theater that presents independent films. In addition to revenue from theater admissions, LFC relies on concession and caf sales, grants and other external support, theater rental sales, and proceeds from special events and other programs that not only promote an appreciation for independent films but also generate grants and contributions. LFCs new executive director has asked you, as the director of finance, to provide an analysis of the organizations financial position. Refer to Exhibits 14-7 through 14-10; these exhibits present LFCs statements of financial position, statements of activities, analysis of expenses by nature and function, and statements of cash flows for the years ended December 31, 2021, and 2020. 1. Does LFC have an endowment? How do you know? 2. How much of LFCs net assets with donor restrictions were reclassified as unrestricted in 2021? Where can this be found in the statements of financial position and statements of activities? 3. Calculate the four profitability ratios presented in the chapter for LFC for 2021 and 2020 as well as the percent change in each from 2020 to 2021. By which measure did LFCs profitability deteriorate the most, and by how much? 4. LFCs total expenses grew by over 100 percent from 2020 to 2021, while its total revenue and other support declined by over 50 percent. Look at the theaters statements of activities to answer a and b: a. Excluding interest/investment income and the one-time sale of tax credits, which three revenue or support categories declined by over 50 percent from 2020 to 2021? b. Which expense category grew by over 100 percent? Calculate LFCs program services ratio for 2021 and 2020 as well as the percent change in each from 2020 to 2021. Is LFCs program services ratio for 2021 higher than the commonly accepted benchmark?
![image text in transcribed](https://s3.amazonaws.com/si.experts.images/answers/2024/07/669e4b046465d_923669e4b03d091e.jpg)
![image text in transcribed](https://s3.amazonaws.com/si.experts.images/answers/2024/07/669e4b0538fde_924669e4b049d9e3.jpg)
![image text in transcribed](https://s3.amazonaws.com/si.experts.images/answers/2024/07/669e4b06275cb_925669e4b058436c.jpg)
![image text in transcribed](https://s3.amazonaws.com/si.experts.images/answers/2024/07/669e4b0705ddf_926669e4b0669814.jpg)
EXHIBIT 14-7 2021 2020 Lafayette Film Center Statements of Financial Position as of December 31, 2021 and 2020 Assets Current Assets Cash and cash equivalents $ 75,582 Grants receivable 562,696 Inventory 50,400 Other receivables 36,172 Prepaid expenses 11,552 Total Current Assets $ 736,402 $ 174,662 137,858 59,508 37,624 $ 409,652 Long-Term Assets Conditional promises to give Deposits Property and equipment, net Total Long-Term Assets $ 264,514 1,510 9,336,672 $ 9,602,696 $ 488,530 7,910 9,278,616 $ 9,775,056 Total Assets $10,339,098 $10,184,708 $ 113,240 111,776 Liabilities and Net Assets Current Liabilities Accounts payable Accrued expenses Deferred revenue Line of credit Current portion of capital lease obligations Total Current Liabilities $ 106,214 109,044 31,186 960,510 51,100 $ 1,260,054 100,000 48,394 373,410 $ Long-Term Liabilities: Capital lease obligations less current portion 36,596 88,638 Total Liabilities $ 1,296,650 $ 462,048 Net assets: Without Donor Restrictions With Donor Restrictions Total Net Assets $ 8,777,934 264,514 $ 9,042,448 $ 9,184,130 538,530 $ 9,722,660 Total Liabilities and Net Assets $10,339,098 $10,184,708 The accompanying notes are an integral part of these statements. EXHIBIT 14-8 2021 Lafayette Film Center Statements of Activities for the Years Ended December 31, 2021 and 2020 Without Donor Restrictions 2020 Revenue and Support Theater admissions $ 414,818 $ 78,640 Concession and caf sales 1,522,426 196,288 Memberships 139,684 61,350 Theater rental sales 68,180 58,414 Special events 47,710 140,616 Other programs 62,006 45,726 Interest and investment income 56,656 Sale of tax credits 1,384,002 Grants 1,061,762 3,016,550 Contributions 360,104 1,129,112 Total Revenue and Support $3,676,690 $6,167,354 Net assets released from restrictions 274,016 1,826,578 Total Revenue and Other Support $3,950,706 $7,993,932 Expenses Program services General administration Fundraising Total Expenses $3,640,634 455,436 260,832 $4,356,902 $1,378,472 407,244 302,384 $2,088,100 Change in Net Assets Net assets--beginning of year Net assets-end of year $ (406,196) 9,184,130 $8,777,934 $5,905,832 3,278,298 $9,184,130 The accompanying notes are an integral part of these statements. 6. Given your answers to questions 4 and 5, would you recommend that LFC reallocate some of its spending from program services to fundraising in 2022? Why or why not? 7. What was LFC's depreciation expense in 2020 and 2021? Which financial statement(s) provide this information? 8. Now that receivables constitute a much larger proportion of LFC's assets than in the past, the executive director has asked you to calculate the receivables turnover ratio and average collection period for 2021. a. Which revenue items will you exclude from the ratio? Why? b. What is LFC's receivables turnover ratio and average collection period for 2021? Are they favorable or unfavorable? Why? c. Would you recommend recalculating the receivables turnover ratio using the average of beginning-of-year and end-of-year receivables in the denominator? Why or why not? EXHIBIT 14-8 2021 Lafayette Film Center Statements of Activities for the Years Ended December 31, 2021 and 2020 Without Donor Restrictions 2020 Revenue and Support Theater admissions $ 414,818 $ 78,640 Concession and caf sales 1,522,426 196,288 Memberships 139,684 61,350 Theater rental sales 68,180 58,414 Special events 47,710 140,616 Other programs 62,006 45,726 Interest and investment income 56,656 Sale of tax credits 1,384,002 Grants 1,061,762 3,016,550 Contributions 360,104 1,129,112 Total Revenue and Support $3,676,690 $6,167,354 Net assets released from restrictions 274,016 1,826,578 Total Revenue and Other Support $3,950,706 $7,993,932 Expenses Program services General administration Fundraising Total Expenses $3,640,634 455,436 260,832 $4,356,902 $1,378,472 407,244 302,384 $2,088,100 Change in Net Assets Net assets--beginning of year Net assets-end of year $ (406,196) 9,184,130 $8,777,934 $5,905,832 3,278,298 $9,184,130 The accompanying notes are an integral part of these statements. 6. Given your answers to questions 4 and 5, would you recommend that LFC reallocate some of its spending from program services to fundraising in 2022? Why or why not? 7. What was LFC's depreciation expense in 2020 and 2021? Which financial statement(s) provide this information? 8. Now that receivables constitute a much larger proportion of LFC's assets than in the past, the executive director has asked you to calculate the receivables turnover ratio and average collection period for 2021. a. Which revenue items will you exclude from the ratio? Why? b. What is LFC's receivables turnover ratio and average collection period for 2021? Are they favorable or unfavorable? Why? c. Would you recommend recalculating the receivables turnover ratio using the average of beginning-of-year and end-of-year receivables in the denominator? Why or why not? EXHIBIT 14-10 2020 $ 4,129,254 107,900 1,843,396 Lafayette Film Center Statements of Cash Flows for the Years Ended December 31, 2021 and 2020 2021 Operating Activities Change in net assets $(680,212) Adjustments to reconcile change in net assets to net cash provided by (used in) operating activities: Depreciation 624,356 Contributions restricted for building renovations (Increase) decrease in operating assets Grants receivable (424,838) Other receivables 1,452 Conditional promises to give 224,016 Prepaid expenses (11,552) Inventory 9,108 Deposits 6,400 Increase (decrease) in operating liabilities Accounts payable (5,026) Accrued expenses (2,732) Deferred revenue 31,186 Net cash provided by (used in) operating activities $(227,842) 292,666 (33,344) (16,818) (59,510) (1,510) (423,404) 111,776 $ 5,950,406 Investing Activities Payments for property and equipment Net cash/(used in) investing activities $(682,412) $(682,412) $17,159,362) $(7,159,362) $ Financing Activities Payments on capital leases Net increase in line of credit Net cash provided by financing activities $ (49,336) 860,510 $ 811,174 (10,084) 100,000 89,916 $ Net increase/(decrease) in cash and cash equivalents Cash and cash equivalents-beginning of year Cash and cash equivalents-end of year $ (99,080) 174,662 $ 75,582 $(1,119,040) 1,293,702 $ 174,662 The accompanying notes are an integral part of these statements. EXHIBIT 14-7 2021 2020 Lafayette Film Center Statements of Financial Position as of December 31, 2021 and 2020 Assets Current Assets Cash and cash equivalents $ 75,582 Grants receivable 562,696 Inventory 50,400 Other receivables 36,172 Prepaid expenses 11,552 Total Current Assets $ 736,402 $ 174,662 137,858 59,508 37,624 $ 409,652 Long-Term Assets Conditional promises to give Deposits Property and equipment, net Total Long-Term Assets $ 264,514 1,510 9,336,672 $ 9,602,696 $ 488,530 7,910 9,278,616 $ 9,775,056 Total Assets $10,339,098 $10,184,708 $ 113,240 111,776 Liabilities and Net Assets Current Liabilities Accounts payable Accrued expenses Deferred revenue Line of credit Current portion of capital lease obligations Total Current Liabilities $ 106,214 109,044 31,186 960,510 51,100 $ 1,260,054 100,000 48,394 373,410 $ Long-Term Liabilities: Capital lease obligations less current portion 36,596 88,638 Total Liabilities $ 1,296,650 $ 462,048 Net assets: Without Donor Restrictions With Donor Restrictions Total Net Assets $ 8,777,934 264,514 $ 9,042,448 $ 9,184,130 538,530 $ 9,722,660 Total Liabilities and Net Assets $10,339,098 $10,184,708 The accompanying notes are an integral part of these statements. EXHIBIT 14-8 2021 Lafayette Film Center Statements of Activities for the Years Ended December 31, 2021 and 2020 Without Donor Restrictions 2020 Revenue and Support Theater admissions $ 414,818 $ 78,640 Concession and caf sales 1,522,426 196,288 Memberships 139,684 61,350 Theater rental sales 68,180 58,414 Special events 47,710 140,616 Other programs 62,006 45,726 Interest and investment income 56,656 Sale of tax credits 1,384,002 Grants 1,061,762 3,016,550 Contributions 360,104 1,129,112 Total Revenue and Support $3,676,690 $6,167,354 Net assets released from restrictions 274,016 1,826,578 Total Revenue and Other Support $3,950,706 $7,993,932 Expenses Program services General administration Fundraising Total Expenses $3,640,634 455,436 260,832 $4,356,902 $1,378,472 407,244 302,384 $2,088,100 Change in Net Assets Net assets--beginning of year Net assets-end of year $ (406,196) 9,184,130 $8,777,934 $5,905,832 3,278,298 $9,184,130 The accompanying notes are an integral part of these statements. 6. Given your answers to questions 4 and 5, would you recommend that LFC reallocate some of its spending from program services to fundraising in 2022? Why or why not? 7. What was LFC's depreciation expense in 2020 and 2021? Which financial statement(s) provide this information? 8. Now that receivables constitute a much larger proportion of LFC's assets than in the past, the executive director has asked you to calculate the receivables turnover ratio and average collection period for 2021. a. Which revenue items will you exclude from the ratio? Why? b. What is LFC's receivables turnover ratio and average collection period for 2021? Are they favorable or unfavorable? Why? c. Would you recommend recalculating the receivables turnover ratio using the average of beginning-of-year and end-of-year receivables in the denominator? Why or why not? EXHIBIT 14-8 2021 Lafayette Film Center Statements of Activities for the Years Ended December 31, 2021 and 2020 Without Donor Restrictions 2020 Revenue and Support Theater admissions $ 414,818 $ 78,640 Concession and caf sales 1,522,426 196,288 Memberships 139,684 61,350 Theater rental sales 68,180 58,414 Special events 47,710 140,616 Other programs 62,006 45,726 Interest and investment income 56,656 Sale of tax credits 1,384,002 Grants 1,061,762 3,016,550 Contributions 360,104 1,129,112 Total Revenue and Support $3,676,690 $6,167,354 Net assets released from restrictions 274,016 1,826,578 Total Revenue and Other Support $3,950,706 $7,993,932 Expenses Program services General administration Fundraising Total Expenses $3,640,634 455,436 260,832 $4,356,902 $1,378,472 407,244 302,384 $2,088,100 Change in Net Assets Net assets--beginning of year Net assets-end of year $ (406,196) 9,184,130 $8,777,934 $5,905,832 3,278,298 $9,184,130 The accompanying notes are an integral part of these statements. 6. Given your answers to questions 4 and 5, would you recommend that LFC reallocate some of its spending from program services to fundraising in 2022? Why or why not? 7. What was LFC's depreciation expense in 2020 and 2021? Which financial statement(s) provide this information? 8. Now that receivables constitute a much larger proportion of LFC's assets than in the past, the executive director has asked you to calculate the receivables turnover ratio and average collection period for 2021. a. Which revenue items will you exclude from the ratio? Why? b. What is LFC's receivables turnover ratio and average collection period for 2021? Are they favorable or unfavorable? Why? c. Would you recommend recalculating the receivables turnover ratio using the average of beginning-of-year and end-of-year receivables in the denominator? Why or why not? EXHIBIT 14-10 2020 $ 4,129,254 107,900 1,843,396 Lafayette Film Center Statements of Cash Flows for the Years Ended December 31, 2021 and 2020 2021 Operating Activities Change in net assets $(680,212) Adjustments to reconcile change in net assets to net cash provided by (used in) operating activities: Depreciation 624,356 Contributions restricted for building renovations (Increase) decrease in operating assets Grants receivable (424,838) Other receivables 1,452 Conditional promises to give 224,016 Prepaid expenses (11,552) Inventory 9,108 Deposits 6,400 Increase (decrease) in operating liabilities Accounts payable (5,026) Accrued expenses (2,732) Deferred revenue 31,186 Net cash provided by (used in) operating activities $(227,842) 292,666 (33,344) (16,818) (59,510) (1,510) (423,404) 111,776 $ 5,950,406 Investing Activities Payments for property and equipment Net cash/(used in) investing activities $(682,412) $(682,412) $17,159,362) $(7,159,362) $ Financing Activities Payments on capital leases Net increase in line of credit Net cash provided by financing activities $ (49,336) 860,510 $ 811,174 (10,084) 100,000 89,916 $ Net increase/(decrease) in cash and cash equivalents Cash and cash equivalents-beginning of year Cash and cash equivalents-end of year $ (99,080) 174,662 $ 75,582 $(1,119,040) 1,293,702 $ 174,662 The accompanying notes are an integral part of these statements