Reference no: EM132466143

Part I:

Marquoya College (MC) is a medium-sized private school located in the Midwest. In the past, MC administrators established a budget for the next academic year by adding a specific percentage (e.g., 6 percent, 8 percent) to the tuition revenue and operating expenses. This year MC has asked for your assistance in developing its budget for the next academic year. You are supplied with the following data for the current year.

Enrollment 4,300 students

Tuition $3,300/year Full-time faculty 250 (72% tenured)

Fees $280/year Average faculty salary $36,000/year

Full tuition-only scholarships 400 students

For the next academic year, enrollment is expected to increase by 300 students, with each student taking an average of 32 credit hours. Tuition will increase by $100/year.

Prepare a schedule computing the next academic year's tuition and fee revenue budget. Explicitly show the effect of scholarships.

Part II:

 The additional students will require MC to hire 20 adjunct faculty members. Each adjunct will teach 18 credit hours and will be paid at the rate of $750/credit hour. Full-time faculty members will receive a 5 percent pay increase. Additional merit increases to be awarded to individual faculty members will amount to $280,000.

Prepare a schedule computing the next academic year's budget for faculty salaries. The payroll budget should reflect payroll taxes using a rate of 10 percent.

Part III:

The current budget is $1,200,000 for operation and maintenance of plant and equipment, including $190,000 for salaries and wages. Experience of the past 3 months suggests that the current budget is realistic. However, expected increases for next year are $10,000 in salaries and $50,000 in other expenditures for maintenance of plant and equipment. The IRS has determined that MC has unrelated business income. In the year just past, MC paid $48,000 of federal income taxes and a penalty of $2,000. MC's administrators feel that proper allocation of costs and timely payments to the IRS will result in a total tax liability of $36,000. Estimates for other costs include: Mortgage payments $ 264,000 (reducing principal by $100,000)

Administrative and general 1,440,000 (including salaries of $1,200,000)

Library 1,800,000 (including salaries of $1,000,000)

Health and recreation 750,000 (including salaries of $300,000)

Athletics 320,000 (including salaries of $60,000)

Insurance and retirement benefits 548,000 Capital improvements 1,300,000

Where applicable, use a payroll tax rate of 10 percent. Anticipated revenues, other than tuition for the next academic year, are as follows:

Endowment receipts $ 514,000 (e.g., interest, dividends)

Net income from auxiliary services $ 538,000

Athletics $ 1,580,000

MC's remaining source of revenue is an annual alumni support campaign. Last year, the alums were very generous (MC's basketball team was ranked high throughout the cage campaign) and contributed over $600,000. MC borrowed $200,000 from the Golden Dome Bank for summer operations on June 15. The principal plus interest (at an annual rate of 12%) is to be paid on September 15. On the basis of the tuition and fee revenue budget and faculty salaries budget computed in parts I and II, prepare a schedule computing the amount that must be raised during the annual support campaign to cover the expenditures budgeted. 

PArt IV:

Using anticipated alumni support of $750,000, prepare a cash budget for the first quarter (September, October, November) of the MC fiscal year. (Round all calculations to the nearest hundred dollars.) The following patterns of cash flows are anticipated: MC must maintain a cash balance of $3,000. Financing can be arranged at the Golden Dome Bank at a rate of 8 percent. Borrowing occurs in $1,000 increments. All loans are repaid as soon as possible, but a minimum of 1 month's interest is charged. Estimated cash on September 1 is $3,700.