Your spreadsheet should include the inputs shown in Figure 10-2. An explanation of the line items...

Transcribed Image Text:

Your spreadsheet should include the inputs shown in Figure 10-2. An explanation of the line items follows the figure. 17 INPUTS 18 Basketball Recruiting Effort (1-Same, 2-More, 3-Max) 19 Added Student Fee (L-Low, M-Medium, O-Outrageous) 20 Do the Women's Football League? (Y/N) 21 Expected bond interest rate (annual) Source: Used with permission from Microsoft Corporation FIGURE 10-2 Inputs section . C • Basketball Recruiting Effort-To win more games, the basketball teams need better recruiting efforts. If these efforts are expected to remain the same, enter 1. If recruiting efforts will increase by a moderate amount, enter 2. If the effort will increase by the maximum amount, enter 3. The entry applies to all years. Number of concerts in year Average concert attendance Average concert ticket . Added Student Fee-To indicate the increase in the student fee, enter L for a low amount, M for a medium amount, or O for an outrageous amount. The entry applies to all years. Do the Women's Football League? (Y/N)-If the university allows the women's league to play in the arena, enter Y. If not, enter N. The entry applies to all years. Expected bond interest rate (annual)-Enter .03 if the annual rate is expected to be 3 percent, .04 if the rate is expected to be 4 percent, and so on. The rate applies to the full 15 years of the bond term. The cell should be formatted for percentage. Number of concerts in year-A firm would be hired to attract concerts and other events to the arena. Enter the number of event days for the year. The entry applies to each year. • Average concert attendance-Enter the number of tickets expected to be sold for an average concert. The entry applies to each year. The maximum number would be 5,000, which is the seating capacity of the arena. • Average concert ticket-Enter the expected average price of a concert ticket. The entry applies to each year. The cell should be formatted for currency. The cells should be formatted appropriately for numbers, currency, or percentages. Your spreadsheet should include the inputs shown in Figure 10-2. An explanation of the line items follows the figure. 17 INPUTS 18 Basketball Recruiting Effort (1-Same, 2-More, 3-Max) 19 Added Student Fee (L-Low, M-Medium, O-Outrageous) 20 Do the Women's Football League? (Y/N) 21 Expected bond interest rate (annual) Source: Used with permission from Microsoft Corporation FIGURE 10-2 Inputs section . C • Basketball Recruiting Effort-To win more games, the basketball teams need better recruiting efforts. If these efforts are expected to remain the same, enter 1. If recruiting efforts will increase by a moderate amount, enter 2. If the effort will increase by the maximum amount, enter 3. The entry applies to all years. Number of concerts in year Average concert attendance Average concert ticket . Added Student Fee-To indicate the increase in the student fee, enter L for a low amount, M for a medium amount, or O for an outrageous amount. The entry applies to all years. Do the Women's Football League? (Y/N)-If the university allows the women's league to play in the arena, enter Y. If not, enter N. The entry applies to all years. Expected bond interest rate (annual)-Enter .03 if the annual rate is expected to be 3 percent, .04 if the rate is expected to be 4 percent, and so on. The rate applies to the full 15 years of the bond term. The cell should be formatted for percentage. Number of concerts in year-A firm would be hired to attract concerts and other events to the arena. Enter the number of event days for the year. The entry applies to each year. • Average concert attendance-Enter the number of tickets expected to be sold for an average concert. The entry applies to each year. The maximum number would be 5,000, which is the seating capacity of the arena. • Average concert ticket-Enter the expected average price of a concert ticket. The entry applies to each year. The cell should be formatted for currency. The cells should be formatted appropriately for numbers, currency, or percentages.

Answer rating: 100% (QA)

Spreadsheet ... View the full answer