I am having trouble with requirement 4-5. Please see the question and the all requirements listed. Please assist with an excel of 4-5.

Kind regards

The board of education for the Central Catskill School District is considering the acquisition of several minibuses for use in transporting students to school. Five of the school district's bus routes are underpopulated, with the result that the full-size buses on those routes are not fully utilized. After a careful study, the board has decided that it is not feasible to consolidate these routes into fewer routes served by full-size buses. The area in which the students live is too large for that approach, since some students' bus ride to school would exceed the state maximum of 45 minutes. The plan under consideration by the board is to replace five full-size buses with eight minibuses, each of which would cover a much shorter route than a full-size bus. The bus drivers in this rural school district are part-time employees whose compensation costs the school district $18,000 per year for each driver. In addition to the drivers' compensation, the annual costs of operating and maintaining a full-size bus amount to $50,000. In contrast, the board projects that a minibus will cost only $20,000 annually to operate and maintain. A minibus driver earns the same wages as a full-size bus driver. The school district controller has estimated that it will cost the district $15,250, initially, to redesign its bus routes, inform the public, install caution signs in certain hazardous locations, and retrain its drivers.

A minibus costs $27,000, whereas a full-size bus costs $90,000. The school district uses straightline depreciation for all of its long-lived assets. The board has two options regarding the five full-size buses. First, the buses could be sold now for $15,000 each. Second, the buses could be kept in reserve to use for field trips and out-of-town athletic events and to use as backup vehicles when buses break down. Currently, the board charters buses from a private company for these purposes. The annual cost of chartering buses amounts to $30,000. The school district controller has estimated that this cost could be cut to $5,000 per year if the five buses were kept in reserve. The five full-size buses have five years of useful life remaining, either as regularly scheduled buses or as reserve buses. The useful life of a new minibus is projected to be five years also.

Central Catskill School District uses a hurdle rate of 12 percent on all capital projects.

Required:

1. Think about the decision problem faced by the board of education. What are the board's two main alternatives?

2. One of these main alternatives has two options embedded within it. What are those two options?

3. Before proceeding, check the hint given at the end of the chapter, which explains and diagrams the school board's alternatives. Suppose the board of education chooses to buy the minibuses. Create a net-present-value analysis of the two options for the five full-size buses. Should these buses be sold now or kept in reserve?

4. From your answer to requirement (3), you know the best option for the board to choose regarding the full-size buses if the minibuses are purchased. Now you can ignore the other option. Create a net-present-value analysis of the school board's two main alternatives: (a) continue to use the full-size buses on regular routes or (b) purchase the minibuses. Should the minibuses be purchased?

5. Compute the internal rate of return on the proposed minibus acquisition.

Office King Corporation manufactures three different models of paper shredders including the waste container that serves as the base. While the shredder heads are different for the three models, the waste container is the same. The number of waste containers that Office King will need during the next five years is estimated as follows:

20x1 ............................................................................... 50,000

20x2 ............................................................................... 50,000

20x3 ............................................................................... 52,000

20x4 ............................................................................... 55,000

20x5 ............................................................................... 55,000