Calculate the four profitability ratios presented in the chapter for LFC for 2017 and 2018,...

60.1K

Verified Solution

Question

Accounting

Calculate the four profitability ratios presented in the chapter for LFC for 2017 and 2018, as well as the percent change in each from 2017 to 2018. By which measure did LFC's profitability deteriorate the most, and by how much?

The profitability ratios are operating margin, total margin, Return on assets and Return on equity.

imageimageimageimageimage 14-11 Code 4 Change Statements of Financial Position as of March 31, 2017 and 2016 Assets \begin{tabular}{rr} \hline 2017 & \multicolumn{1}{c}{2016} \\ 1,909,606 & $1,044,193 \\ 61,244 & 52,582 \\ 373,788 & 358,632 \end{tabular} allowance for uncollectible pledges of $449,162 in 2017 and $464,486 in 2016 Prepaid expenses and other Investments long ferm Total Assets Liabilities and Net Assets Liabilities Accounts payable Annuity payment liability Total liabilities Unrestricted Net Assets Total Liabilities and Net Assets \begin{tabular}{rr} $202,631 & $172,567 \\ 3,857,262 & 3,679,148 \\ \hline$4,059,893 & $3,851,715 \\ 9,245,913 & 7,282,098 \\ \hline$13,305,806 & $11,133,813 \\ \hline \end{tabular} Lafayette Film Center Statements of Cash Flows for the Years Ended December 31, 2018 and 2017 2018 2017 Operating Activities Change in net assets Adjustments to reconcile change in net assets to net cash provided by/(used in) operating activities Depreciation Contributions restricted for building renovations (Increase)/decrease in operating assets Grants receivable Other receivables Conditional promises to give Prepaid expenses Inventory Deposits Increase/(decrease) in operating liabilities Accounts payable Accrued expenses Deferred revenue Net cash provided by/(used in) operating activities $(680,212)$4,129,254 624,356107,9001,843,396 (424,838)292,666 1,452(33,344) 224,016(16,818) (11,552) 9,108 (59,510) 6,400 (1,510) (5,026)(423,404) (2,732)111,776 31,186 $(227,842)$5,950,406 Investing Activities Payments for property and equipment Net cash/(used in) investing activities $(682,412)$(682,412)$(7,159,362)$(7,159,362) Financing Activities Payments on capital leases Net increase in line of credit Net cash provided by financing activities \begin{tabular}{lr} $(49,336) & $(10,084) \\ 860,510 & 100,000 \\ \hline 811,174 & $89,916 \end{tabular} Net increase/(decrease) in cash and cash equivalents Cash and cash equivalents-beginning of year Cash and cash equivalents-end of year \begin{tabular}{rr} $(99,080) & $(1,119,040) \\ 174,662 & 1,293,702 \\ \hline 75,582 & $174,662 \\ \hline \end{tabular} The accompanying notes are an integral part of these statements. Total Liabilities al. The accompanying notes are an integral part u.... 148 Lafayette Film Center Statements of Activities for the Years Ended December 31, 2018 and 2017 14-11 Code 4 Change Statements of Financial Position as of March 31, 2017 and 2016 Assets \begin{tabular}{rr} \hline 2017 & \multicolumn{1}{c}{2016} \\ 1,909,606 & $1,044,193 \\ 61,244 & 52,582 \\ 373,788 & 358,632 \end{tabular} allowance for uncollectible pledges of $449,162 in 2017 and $464,486 in 2016 Prepaid expenses and other Investments long ferm Total Assets Liabilities and Net Assets Liabilities Accounts payable Annuity payment liability Total liabilities Unrestricted Net Assets Total Liabilities and Net Assets \begin{tabular}{rr} $202,631 & $172,567 \\ 3,857,262 & 3,679,148 \\ \hline$4,059,893 & $3,851,715 \\ 9,245,913 & 7,282,098 \\ \hline$13,305,806 & $11,133,813 \\ \hline \end{tabular} Lafayette Film Center Statements of Cash Flows for the Years Ended December 31, 2018 and 2017 2018 2017 Operating Activities Change in net assets Adjustments to reconcile change in net assets to net cash provided by/(used in) operating activities Depreciation Contributions restricted for building renovations (Increase)/decrease in operating assets Grants receivable Other receivables Conditional promises to give Prepaid expenses Inventory Deposits Increase/(decrease) in operating liabilities Accounts payable Accrued expenses Deferred revenue Net cash provided by/(used in) operating activities $(680,212)$4,129,254 624,356107,9001,843,396 (424,838)292,666 1,452(33,344) 224,016(16,818) (11,552) 9,108 (59,510) 6,400 (1,510) (5,026)(423,404) (2,732)111,776 31,186 $(227,842)$5,950,406 Investing Activities Payments for property and equipment Net cash/(used in) investing activities $(682,412)$(682,412)$(7,159,362)$(7,159,362) Financing Activities Payments on capital leases Net increase in line of credit Net cash provided by financing activities \begin{tabular}{lr} $(49,336) & $(10,084) \\ 860,510 & 100,000 \\ \hline 811,174 & $89,916 \end{tabular} Net increase/(decrease) in cash and cash equivalents Cash and cash equivalents-beginning of year Cash and cash equivalents-end of year \begin{tabular}{rr} $(99,080) & $(1,119,040) \\ 174,662 & 1,293,702 \\ \hline 75,582 & $174,662 \\ \hline \end{tabular} The accompanying notes are an integral part of these statements. Total Liabilities al. The accompanying notes are an integral part u.... 148 Lafayette Film Center Statements of Activities for the Years Ended December 31, 2018 and 2017

Answer & Explanation Solved by verified expert
Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students