Review the rubric to make sure you understand the criteria for earning your grade.
Read Chapters 117 from How to Read Nonprofit Financial Statements, and Chapters 1, 2, and 7 of Wiley Not-for-Profit GAAP 2020.
Review Strategic Financial Analysis for Higher Education.
Download the Excel file Financial Statement Analysis.
Open the PDF file Indiana Wesleyan University Independent Auditors Report and Consolidated Financial Statements.
Use the information on pages 3 and 4 of the IWU financial statements to enter the required numbers in the blue shaded cells on the Data Entry sheet.
Data Entry Income Sources Tuition \& fees (net of aid) Governmental grants Private gifts and grants Dividends and interest Other income Auxiliary income \begin{tabular}{|r|r|} \hline 131,027,576 & \\ \hline 6,059,602 & \\ \hline 5,204,528 & \\ \hline 5,770,155 & \\ \hline 2,707,812 & \\ \hline 23,993,761 & \\ \hline \end{tabular} Expense Categories Instruction Academic support Student services Auxiliary enterprises Institutional support Development \begin{tabular}{|r|l|} \hline 60,439,383 & \\ \hline 16,417,526 & \\ \hline 54,305,547 & \\ \hline 20,343,503 & \\ \hline 20,083,604 & \\ \hline 1,969,420 & \\ \hline \end{tabular} Primary Reserve Ratio Unrestricted Net Assets Temporarily Restricted Net Assets Property, Plant, and Equipment Long Term Debt Return on Net Assets Ratio Change in Net Assets Total Net Assets (Beginning of Year Assets Cash Accounts receivable, net of allowance of $2,009,100 in 2020 and Liabilities and Net Assets Liabilities Net Assets Without donor restrictions With donor restrictions Total net assets \begin{tabular}{rrr} 61,768,499 & & 61,768,499 \\ 16,626,125 & & 16,626,125 \\ 57,130,497 & & 57,130,497 \\ 25,321,250 & & 25,321,250 \\ 16,631,013 & & 16,631,013 \\ 2,254,218 & & 2,254,218 \\ \hline 179,731,602 & & 179,731,602 \\ \hline \end{tabular} \begin{tabular}{rrr} 1,564,670 & 707,410 & 2,272,080 \\ (35,559) & (4,372) & (39,931) \\ & (6,813) & (6,813) \\ \hline 1,529,111 & 696,225 & 2,225,336 \\ \hline 8,631,358 & 1,728,476 & 10,359,834 \\ \hline 379,160,807 & 82,689,412 & 461,850,219 \\ \hline \end{tabular} \begin{tabular}{llllll} $387,792,165 & $ & 84,417,888 & $472,210,053 \\ \hline \end{tabular} Data Entry Income Sources Tuition \& fees (net of aid) Governmental grants Private gifts and grants Dividends and interest Other income Auxiliary income \begin{tabular}{|r|r|} \hline 131,027,576 & \\ \hline 6,059,602 & \\ \hline 5,204,528 & \\ \hline 5,770,155 & \\ \hline 2,707,812 & \\ \hline 23,993,761 & \\ \hline \end{tabular} Expense Categories Instruction Academic support Student services Auxiliary enterprises Institutional support Development \begin{tabular}{|r|l|} \hline 60,439,383 & \\ \hline 16,417,526 & \\ \hline 54,305,547 & \\ \hline 20,343,503 & \\ \hline 20,083,604 & \\ \hline 1,969,420 & \\ \hline \end{tabular} Primary Reserve Ratio Unrestricted Net Assets Temporarily Restricted Net Assets Property, Plant, and Equipment Long Term Debt Return on Net Assets Ratio Change in Net Assets Total Net Assets (Beginning of Year Assets Cash Accounts receivable, net of allowance of $2,009,100 in 2020 and Liabilities and Net Assets Liabilities Net Assets Without donor restrictions With donor restrictions Total net assets \begin{tabular}{rrr} 61,768,499 & & 61,768,499 \\ 16,626,125 & & 16,626,125 \\ 57,130,497 & & 57,130,497 \\ 25,321,250 & & 25,321,250 \\ 16,631,013 & & 16,631,013 \\ 2,254,218 & & 2,254,218 \\ \hline 179,731,602 & & 179,731,602 \\ \hline \end{tabular} \begin{tabular}{rrr} 1,564,670 & 707,410 & 2,272,080 \\ (35,559) & (4,372) & (39,931) \\ & (6,813) & (6,813) \\ \hline 1,529,111 & 696,225 & 2,225,336 \\ \hline 8,631,358 & 1,728,476 & 10,359,834 \\ \hline 379,160,807 & 82,689,412 & 461,850,219 \\ \hline \end{tabular} \begin{tabular}{llllll} $387,792,165 & $ & 84,417,888 & $472,210,053 \\ \hline \end{tabular}
