Problem $5-14$ Creative Learning Centers $($pages $193-194).$ In part A compute ROI and EVA for each school and for all of the schools. You will need an Excel spreadsheet.

Creative Learning Centers $($CLC$),$ a for$-$profit firm, operates over $100$ preschools primarily located in the northeast for children ages $46.$ CLC$$s innovative curriculum utilizes the latest technology and offers young minds creative expression, language and social skills, physical movement, music, and number skills$$all provided by professional trained teachers. CLC leases buildings for their schools and invests substantial resources in leasehold improvements for classrooms, technology, and playground equipment. CLC$$s cost of capital is $12$ percent. Typical tuition is about $$6,300$ per year for a five$-$day$-$a$-$week, four$-$hour$-$per$-$day program. Maria Schnelling manages $15$ CLC schools in the state of Virginia. She has decision$-$making responsibility for staffing and operating her schools, as well as the responsibility for recommending adding new schools and closing existing schools. The following table provides current operating data on all of her $15$ preschools, and breaks out her top$-$ and bottom$-$performing schools:

Preschool Group

After$-$Tax Operating Income

Total Investment

All $15$ Virginia preschools

$$1,811,250$

$$11,625,000$

Best $3$ Virginia performers

NaN

NaN

VA$4$

$$184,230$

$$801,000$

VA$12$

$$156,030$

$$743,000$

VA$9$

$$151,000$

$$755,000$

Worst $3$ Virginia performers

NaN

NaN

VA$2$

$$34,000$

$$680,000$

VA$8$

$$14,200$

$$710,000$

VA$5$

$-$$$23,700$

$$790,000$

After$-$tax operating income$$ represents all revenues less all expenses $($including depreciation and taxes but excluding any interest on debt to finance the investment$)$ of running a school for the last $12$ months.

Ms$.$ Schnelling has identified three possible locations for new CLC preschools in Virginia $($denoted as NVA$1,$ NVA$2,$ and NVA$3).$ The following table provides current projected data on the three new preschools:

Preschool Group

After$-$Tax Operating Income

Total Investment

NVA$1$

$$132,000$

$$880,000$

NVA$2$

$$110,500$

$$850,000$

NVA$3$

$$79,200$

$$720,000$

Required:

a$.$If Maria Schnelling is evaluated and rewarded based on after$-$tax operating income, which of her $15$ existing schools will she recommend closing, and which of her three new schools will she recommend opening? $($Justify your answers.$)$

b$.$If Maria Schnelling is evaluated and rewarded based on return on investment, which of her existing $15$ schools will she recommend closing, and which of her three new schools will she recommend opening? $($Show computations.$)$

c$.$You have been hired as a consultant to the board of directors to advise the board as to how CLC should measure and reward the performance of CLC managers, such as Ms$.$ Schnelling in Virginia. How should CLC measure and reward its state managers? Provide a compelling rationale to support your recommendation. $($Support your recommendation with relevant computations.$)$

In part A compute ROI and EVA for each school and for all of the schools. You will need an Excel spreadsheet.