Question
Review the rubric to make sure you understand the criteria for earning your grade. Read Chapters 117 from How to Read Nonprofit Financial Statements ,
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}Step 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