Revenue
Program Fee Revenue -$ 1,560,000$ 2,712,000$ 3,648,000$ 3,960,000$ 4,104,000$ 4,248,000$ 4,392,000$ 4,536,000$ 4,728,000$
Financial Aid Contra Revenue -$ -$ -$ (364,800)$ (594,000)$ (718,200)$ (849,600)$ (878,400)$ (907,200)$ (945,600)$
Total Revenue -$ 1,560,000$ 2,712,000$ 3,283,200$ 3,366,000$ 3,385,800$ 3,398,400$ 3,513,600$ 3,628,800$ 3,782,400$
Expenses
Internal Expenses
Teaching Expenses
Faculty Online Course Development 120,000$ 160,000$ 80,000$ 80,000$ 80,000$ 80,000$ 80,000$ 80,000$ 80,000$ 80,000$
Ladder Faculty Online Teaching - - - - - - - - - -
Lecturer Online Teaching - - - - - - - - - -
Ladder Faculty Classroom Teaching - 60,000 60,000 60,000 120,000 120,000 120,000 120,000 120,000 120,000
Lecturer Classroom Teaching - 36,000 36,000 36,000 72,000 72,000 72,000 72,000 72,000 72,000
GSIs - Online Teaching - - - - - - - - - -
GSIs - Classroom Teaching - 108,000 216,000 252,000 288,000 288,000 288,000 288,000 288,000 288,000
Total Teaching Expenses 120,000 364,000 392,000 428,000 560,000 560,000 560,000 560,000 560,000 560,000
Other Academic Expenses
Classroom Space - 39,000 67,800 91,200 99,000 102,600 106,200 109,800 113,400 118,200
Other - External Facilities Costs - - - - - - - - - -
Total Other Academic Expenses - 39,000 67,800 91,200 99,000 102,600 106,200 109,800 113,400 118,200
Administration and Services Staff
Total Admin Staff Headcount - 3.00 4.50 6.00 6.00 7.50 7.50 7.50 7.50 7.50
Admissions - 118,400 177,600 236,800 236,800 296,000 296,000 296,000 296,000 296,000
Student Support - 59,200 118,400 118,400 118,400 177,600 177,600 177,600 177,600 177,600
Career Services - 59,200 59,200 118,400 118,400 118,400 118,400 118,400 118,400 118,400
Other Staff, Variable (e.g., admin support) - 74,000 111,000 148,000 148,000 185,000 185,000 185,000 185,000 185,000
Other Staff, Fixed (e.g., Director) 148,000 148,000 148,000 148,000 148,000 148,000 148,000 148,000 148,000 148,000
Misc. Staff Expenses - 30,000 45,000 60,000 60,000 75,000 75,000 75,000 75,000 75,000
Physical Space for Admin Staff - 4,500 6,750 9,000 9,000 11,250 11,250 11,250 11,250 11,250
Other Costs - - - - - - - - - -
Total Administration and Services Staff 148,000 493,300 665,950 838,600 838,600 1,011,250 1,011,250 1,011,250 1,011,250 1,011,250
Marketing and Recruitment
Marketing Staff 236,800 236,800 236,800 236,800 236,800 236,800 236,800 236,800 236,800 236,800
Advertising 83,333 208,333 291,667 339,583 352,083 364,583 377,083 389,583 404,167 412,500
Total Marketing and Recruitment 320,133 445,133 528,467 576,383 588,883 601,383 613,883 626,383 640,967 649,300
Total Internal Expenses 588,133 1,341,433 1,654,217 1,934,183 2,086,483 2,275,233 2,291,333 2,307,433 2,325,617 2,338,750
Payments to BRCOE or Outside Vendor for Services (if costs listed, provide detailed cost breakdown as separate spreadsheet)
Payment to Vendor 1, e.g., online course development -$ -$ -$ -$ -$ -$ -$ -$ -$ -$
Payment to Vendor 2, e.g., marketing and recruitment -$ -$ -$ -$ -$ -$ -$ -$ -$ -$
Payment to Vendor 3, e.g., technology support -$ -$ -$ -$ -$ -$ -$ -$ -$ -$
Total Payments to Contract Provider(s) - - - - - - - - - -
Program Indirect Expenditures
Campus Assessment -$ 234,000$ 406,800$ 492,480$ 504,900$ 507,870$ 509,760$ 527,040$ 544,320$ 567,360$
Total Program Indirect Expenses -$ 234,000$ 406,800$ 492,480$ 504,900$ 507,870$ 509,760$ 527,040$ 544,320$ 567,360$
Total Expenses 588,133$ 1,575,433$ 2,061,017$ 2,426,663$ 2,591,383$ 2,783,103$ 2,801,093$ 2,834,473$ 2,869,937$ 2,906,110$
Program Net Revenue (588,133)$ (15,433)$ 650,983$ 856,537$ 774,617$ 602,697$ 597,307$ 679,127$ 758,863$ 876,290$
Cumulative Program Net Revenue (588,133)$ (603,567)$ 47,417$ 903,953$ 1,678,570$ 2,281,267$ 2,878,573$ 3,557,700$ 4,316,563$ 5,192,853$
Cumulative Campus Assessment -$ 234,000$ 640,800$ 1,133,280$ 1,638,180$ 2,146,050$ 2,655,810$ 3,182,850$ 3,727,170$ 4,294,530$
Cumulative Total University Net Revenue (588,133)$ (369,567)$ 688,217$ 2,037,233$ 3,316,750$ 4,427,317$ 5,534,383$ 6,740,550$ 8,043,733$ 9,487,383$
Program Breakeven Year 3
Maximum Investment (603,567)
Program Net Present Value (NPV) (years 1-10) 1,742,997$
Program Terminal Value (NPV of years 11+) 894,174$
Total NPV 2,637,171$