Please confirm and advise when I can get the answer as due tomorrow evening. See attached for
Question:
Please confirm and advise when I can get the answer as due tomorrow evening. See attached for the question. I will copy and paste since your upload function doesn't seem to be working.
Scenario
The Superintendent of Private Career Colleges has asked the Quality and Partnerships Unit to assess the current financial situation of a small subgroup of private career colleges. There are concerns that this subgroup, consisting of three specialized Tractor-Trailer/ Driver Licensing private career colleges, is not currently healthy and may be putting students at risk should any of the colleges suddenly close.
Requirement
Using the information provided below, provides analysis of the financial health of each of the three schools, as well as the overall financial health of the subgroup.
- Demonstrate appropriate use of financial indicators and ratios, clearly showing why each is important and what it shows;
- Describe the methods and process you used to undertake your analysis;
- Provide your conclusion on the health of the sector and each institution; and,
- Provide your recommendation to the Superintendent of Private Career Colleges.
College A - Organization Details
PCC ID | ||
Fiscal Year-end | ||
Balance Sheet | ||
2020 | 2019 | |
Assets | ||
Cash and Cash Equivalents | 32,124 | 75,683 |
Accounts Receivable | 150,769 | 108,577 |
Inventory | - | - |
Prepaid Expense | 4,564 | 4,464 |
Due to Related Parties | - | - |
Total Current Assets | 187,457 | 188,724 |
Long-Term Assets | ||
Due from Related Parties | - | - |
Due from Shareholders | - | - |
Property, Plant and Equipment | 539,018 | 554,531 |
Goodwill | 4,594 | 4,594 |
Franchisee Fees | - | - |
Future Income Taxes | 14,853 | 15,911 |
Other Long-Term Assets | 134,660 | 126,852 |
Total Long-Term Assets | 693,125 | 701,888 |
Total Assets | 880,582 | 890,612 |
Liabilities | ||
Bank Indebtedness | - | - |
Accounts Payable and Accrued Liabilities | 55,253 | 68,469 |
Deferred Revenue | 113,518 | 52,370 |
Due to Related Parties | - | - |
Income Taxes Payable | 9,567 | 8,275 |
Current Portion of Loan Payable | 21,678 | 62,839 |
Government Remittances Payable | - | - |
Advances from Shareholders | - | - |
Other Current Liabilities | 7,735 | 8,115 |
Total Current Liabilities | 207,751 | 200,068 |
Long-Term Liabilities | ||
Loan Payable | 79,046 | 79,046 |
Due to Associated Companies | - | - |
Future Income Taxes | - | - |
Due to Related Parties | 53,787 | 84,366 |
Due to Shareholders | 19,482 | - |
Capital Lease | - | - |
Total Long-Term Liabilities | 152,315 | 163,412 |
Total Liabilities | 360,066 | 363,480 |
Shareholders' Equity (Deficiency) | ||
Share Capital | 100 | 100 |
Retained Earnings (Deficit) | 520,416 | 527,032 |
Total Shareholders' Equity | 520,516 | 527,132 |
Total Shareholders' Equity & Liabilities | 880,582 | 890,612 |
A |
31-Dec-20 |
Income Statement | ||
2020 | 2019 | |
Revenue | ||
Vocational Revenue | 667,571 | 1,066,097 |
Non-vocational Revenue | 72,720 | 37,129 |
Other Revenue | 86,408 | 85,293 |
Total Revenue | 826,699 | 1,188,519 |
Expenses | ||
Salaries and Benefits | - | - |
Advertising and Promotion | 18,503 | 44,845 |
Insurance | 59,631 | 55,567 |
Rent and Occupancy Costs | 49,692 | 51,504 |
Equipment Rentals | - | - |
Repairs and Maintenance | 8,924 | 12,956 |
Auto and Travel | 76,646 | 121,608 |
Meals and Entertainment | - | - |
Telephone, Internet & Utilities | 15,336 | 11,820 |
Bank Charges and Interest | 6,084 | 6,216 |
Management Fees and Benefits | - | - |
Contract Instructors | 440,502 | 546,017 |
Commission | - | - |
Bad Debts | 39,772 | 1,560 |
Supplies | 2,707 | 1,274 |
Office and General Expenses | 10,069 | 8,273 |
Amortization | 25,483 | 21,299 |
Training | 13,053 | 18,861 |
Professional Fees | 16,380 | 15,564 |
Other Expenses | 46,867 | 44,430 |
Total Expenses | 829,649 | 961,794 |
Net Operating Income (Loss) | - 2,950 | 226,725 |
Other Gain (Loss) | - | - |
Net Income (Loss) Before Taxes | - 2,950 | 226,725 |
Current Income Tax | 2,608 | 8,275 |
Future Income Taxes | 1,058 | 23,953 |
Income Taxes (Recovered) | 3,666 | 32,228 |
Net Income (Loss) | - 6,616 | 194,497 |
Statement of Retained Earnings |
2020 2019 Retained Earnings (Deficit), Beginning of Year 527,032 332,535 Net Income (Loss): 6,616 194,497 Other Retained Earnings: - - Retained Earnings (Deficit), End of Year: 520,416 527,032 |
College B - Organization Details
PCC ID |
Fiscal Year-end |
Balance Sheet | ||
2020 | 2019 | |
Assets | ||
Cash and Cash Equivalents | 8,703 | 9,221 |
Accounts Receivable | 10,500 | 6,900 |
Inventory | - | - |
Prepaid Expense | - | - |
Due to Related Parties | - | 5,366 |
Total Current Assets | 19,203 | 21,487 |
Long-Term Assets | ||
Due from Related Parties | - | - |
Due from Shareholders | - | - |
Property, Plant and Equipment | - | - |
Goodwill | - | - |
Franchisee Fees | - | - |
Future Income Taxes | - | - |
Other Long-Term Assets | - | - |
Total Long-Term Assets | - | - |
Total Assets | 19,203 | 21,487 |
Liabilities | ||
Bank Indebtedness | - | - |
Accounts Payable and Accrued Liabilities | 5,000 | 4,999 |
Deferred Revenue | 6,750 | 2,500 |
Due to Related Parties | - | - |
Income Taxes Payable | - | - |
Current Portion of Loan Payable | - | - |
Government Remittances Payable | 5,097 | 5,255 |
Advances from Shareholders | - | - |
Other Current Liabilities | - | - |
Total Current Liabilities | 16,847 | 12,754 |
Long-Term Liabilities | ||
Loan Payable | - | - |
Due to Associated Companies | 29,999 | 29,999 |
Future Income Taxes | - | - |
Due to Related Parties | 15,795 | 10,145 |
Due to Shareholders | - | - |
Capital Lease | - | - |
Total Long-Term Liabilities | 45,794 | 40,144 |
Total Liabilities | 62,641 | 52,898 |
Shareholders' Equity (Deficiency) | ||
Share Capital | 101 | 101 |
Retained Earnings (Deficit) | - 43,539 | - 31,512 |
Total Shareholders' Equity | - 43,438 | - 31,411 |
Total Shareholders' Equity and Liabilities | 19,203 | 21,487 |
B | |||
31-Dec-20 | |||
Income Statement | |||
2020 | 2019 | ||
Revenue | |||
Vocational Revenue | 121,096 | 151,574 | |
Non-vocational Revenue | - | - | |
Other Revenue | - | - | |
Total Revenue | 121,096 | 151,574 | |
Expenses | |||
Salaries and Benefits | 49,576 | 55,827 | |
Advertising and Promotion | - | - | |
Insurance | - | - | |
Rent and Occupancy Costs | 75,000 | 109,425 | |
Equipment Rentals | - | - | |
Repairs and Maintenance | - | - | |
Auto and Travel | - | - | |
Meals and Entertainment | - | - | |
Telephone, Internet & Utilities | - | - | |
Bank Charges and Interest | 574 | 108 | |
Management Fees and Benefits | - | - | |
Contract Instructors | - | - | |
Commission | - | - | |
Bad Debts | 1,000 | - | |
Supplies | - | - | |
Office and General Expenses | 1,973 | 500 | |
Amortization | - | - | |
Training | - | - | |
Professional Fees | 5,000 | 7,500 | |
Other Expenses | - | - | |
Total Expenses | 133,123 | 173,360 | |
Net Operating Income (Loss) | - 12,027 | - 21,786 | |
Other Gain (Loss) | - | 26 | |
Net Income (Loss) Before Taxes | - 12,027 | - 21,760 | |
Current Income Tax | - | - | |
Future Income Taxes | - | - 5,366 | |
Income Taxes (Recovered) | - | - 5,366 | |
Net Income (Loss) | - 12,027 | - 16,394 | |
Statement of Retained Earnings |
2020 2019 Retained Earnings (Deficit), Beginning of Year 31,512 15,118 Net Income (Loss): 12,027 16,394 Other Retained Earnings: - - Retained Earnings (Deficit), End of Year: 43,539 31,512 |
College C - Organization Details
PCC ID | ||
Fiscal Year-end | ||
Balance Sheet | ||
2020 | 2019 | |
Assets | ||
Cash and Cash Equivalents | 14,100 | 2,709 |
Accounts Receivable | 848 | - |
Inventory | - | - |
Prepaid Expense | 4,583 | 5,353 |
Harmonized sales tax recoverable | - | 2,237 |
Total Current Assets | 19,531 | 10,299 |
Long-Term Assets | ||
Due from Related Parties | - | - |
Due from Shareholders | - | - |
Property, Plant and Equipment | 65,392 | 44,081 |
Goodwill | - | - |
Franchisee Fees | - | - |
Future Income Taxes | - | - |
Other Long-Term Assets | 19,000 | 19,000 |
Total Long-Term Assets | 84,392 | 63,081 |
Total Assets | 103,923 | 73,380 |
Liabilities | ||
Bank Indebtedness | - | - |
Accounts Payable and Accrued Liabilities | 14,101 | 12,395 |
Deferred Revenue | 22,729 | 9,377 |
Due to Related Parties | - | - |
Income Taxes Payable | - | - |
Current Portion of Loan Payable | 20,096 | 13,167 |
Government Remittances Payable | - | - |
Advances from Shareholders | 21,195 | 16,000 |
Other Current Liabilities | 7,908 | 598 |
Total Current Liabilities | 86,029 | 51,537 |
Long-Term Liabilities | ||
Loan Payable | 44,321 | 33,684 |
Due to Associated Companies | - | - |
Future Income Taxes | - | - |
Due to Related Parties | - | - |
Due to Shareholders | - | - |
Capital Lease | - | - |
Total Long-Term Liabilities | 44,321 | 33,684 |
Total Liabilities | 130,350 | 85,221 |
Shareholders' Equity (Deficiency) | ||
Share Capital | 100 | 100 |
Retained Earnings (Deficit) | - 26,527 | - 11,941 |
Total Shareholders' Equity | - 26,427 | - 11,841 |
Total Shareholders' Equity and Liabilities | 103,923 | 73,380 |
C | ||
31-Dec-20 | ||
Income Statement | ||
2020 | 2019 | |
Revenue | ||
Vocational Revenue | 235,768 | 129,871 |
Non-vocational Revenue | 92,846 | 69,904 |
Other Revenue | 2,988 | - |
Total Revenue | 331,602 | 199,775 |
Expenses | ||
Salaries and Benefits | 138,527 | 67,311 |
Advertising and Promotion | 14,208 | 11,949 |
Insurance | 14,279 | 10,157 |
Rent and Occupancy Costs | 25,502 | 8,299 |
Equipment Rentals | - | 1,092 |
Repairs and Maintenance | 39,435 | 10,237 |
Auto and Travel | 27,121 | 19,581 |
Meals and Entertainment | 1,181 | 1,746 |
Telephone, Internet & Utilities | 7,143 | 3,829 |
Bank Charges and Interest | 13,271 | 7,579 |
Management Fees and Benefits | 5,044 | 5,866 |
Contract Instructors | 180 | - |
Commission | - | - |
Bad Debts | - | 839 |
Supplies | 1,320 | 5,753 |
Office and General Expenses | 12,624 | 3,360 |
Amortization | 18,888 | 21,285 |
Training | 12,130 | 5,948 |
Professional Fees | 14,626 | 13,613 |
Other Expenses | - | - |
Total Expenses | 345,479 | 198,444 |
Net Operating Income (Loss) | - 13,877 | 1,331 |
Other Gain (Loss) | - 709 | 874 |
Net Income (Loss) Before Taxes | - 14,586 | 2,205 |
Current Income Tax | - | - |
Future Income Taxes | - | - |
Income Taxes (Recovered) | - | - |
Net Income (Loss) | - 14,586 | 2,205 |
Statement of Retained Earnings |
2020 2019 Retained Earnings (Deficit), Beginning of Year 11,941 14,146 Net Income (Loss): 14,586 2,205 Dividends paid - - Retained Earnings (Deficit), End of Year: 26,527 11,941 |