Braves Bus Tours wants to provide excursions to several national and international sports events that will be taking place throughout the country during the next few years. To make the buses more comfortable and the trips more popular, each of eight new buses will be equipped with a kitchen and a large video screen for movies and sports telecasts.

Each bus costs $200,000 and requires customized equipment that costs an additional $100,000 per bus. All the buses and the equipment have a recovery period (MACRS life) of 5 years. An advertising campaign, which will start immediately, costs $750,000 and will be paid for immediately. Other start-up costs total $30,000.

The sports trips are scheduled for 3-10 days and will generate revenues of $100 per day per seat. For the eight video buses, total revenues are expected to be $3,168,000 for the first year and $3,484800 for the second year (a 10% increase). Operating costs are 30% of total revenues. Personnel expenses, including driver salaries, are $650,000 in year 1 and will increase by 5% in year 2.

The company expects to discontinue the operation of its video bus tours after the second year. Each bus will be sold to a university for $160,000 ($150,000 for the bus itself and $10,000 for the equipment). The finance department has determined that the beta of this project is 1.5, while the market return is expected to be 14%. Treasury bills pay a nice safe 4 percent.

Should the company proceed with this project? Demonstrate your decision by answering the following questions (build a cash flow estimate, and in it show):

1. What are the cash flows for the initial investment period (CF₀)?

2. What is the MACRS depreciation schedule for the first two years for all of the buses and the equipment? The fall into the MACRS 5 year class. See Table 9.7 (page 284 of the text).

3. What are the after-tax cash flows for the 2 years that the bus tours will be in operation if their tax rate is 24%?

4. What are the termination cash flows in year 2?

5. If NPV analysis is used, should the buses be purchased?

** This question has been answered before on Chegg but didn't complete the requirements or have the right numbers. Please do your best to make everything easy to understand so I can learn it. thanks