In: Accounting
Carlisle State College had the following account balances for the year ended and as of June 30, 2018. Debits are not distinguished from credits, so assume all accounts have a “normal” balance.
| Additions to permanent endowments | 400,000 | 
| Auxiliary enterprise revenue | 4,200,000 | 
| Capital grants and gifts | 300,000 | 
| Depreciation expense | 1,400,000 | 
| Employee Benefits | 1,975,000 | 
| Federal grants and contracts revenue | 2,000,000 | 
| Gifts | 700,000 | 
| Interest on capital-related debt | 450,000 | 
| Investment income | 220,000 | 
| Net position, beginning of year | 11,450,000 | 
| Nonexempt wages | 1,500,000 | 
| Other operating expenses | 900,000 | 
| Salaries-exempt staff | 2,300,000 | 
| Salaries-faculty | 6,500,000 | 
| Scholarship tuition and fee contra revenue | 300,000 | 
| Scholarships and fellowships expense | 315,000 | 
| State and local grants and contracts revenue | 900,000 | 
| State appropriation for operations | 4,970,000 | 
| State appropriations for capital additions | 250,000 | 
| Student tuition and fee revenue | 8,450,000 | 
Required
Prepare, in good form, a Statement of Revenues, Expenses, and Changes in Net Position for Carlisle State College for the year ended June 30, 2017.
PLEASE DO IN EXCELL AND START WITH OPERATING REVENUES.