Must ANSWER ALL 4 SUBSET QUESTIONS (table attached)

A)

A university begins Year 1 with 80 faculty. They hire 4 faculty each year. During each year 10% (rounded to the nearest integer) of the faculty present at the beginning of the year leave the university. For example, in a year where there are 73 faculty at the beginning of the year, 7 would leave the university at the end of the year. The university wants to know how many faculty they will have at the end of year 10. The resulting spreadsheet can be found below. The formula copied down from E10 to E11:E18 was.............

B)

You would like to show how the number of faculty at the end of year 10 depends on the quit rate and number of annual hires. We would like for example, to have cell L10 give the number of Year 10 faculty if we hire 1 faculty member a year and 10% quit each year. Using the information in the spreadsheets below, what would be the row input cell for a two-way data table?

Note: If the answer is a formula, there is no need to begin that answer with =. Please do not put any unnecessary spaces or () in your response.

C)

You would like to show how the number of faculty at the end of year 10 depends on the quit rate and number of annual hires. We would like for example, to have cell L10 give the number of Year 10 faculty if we hire 1 faculty member a year and 10% quit each year. Using the information in the spreadsheets below, what would be the column input cell for the two-way data table?

Please do not put any unnecessary spaces or () in your response.

D)

You would like to show how the number of faculty at the end of year 10 depends on the quit rate and number of annual hires. We would like for example, to have cell L10 give the number of ending Year 10 faculty if we hire 1 faculty member a year and 10% quit each year. Using the information in the spreadsheets below, what formula would be entered in cell J9?

Please do not put any unnecessary spaces or () in your response.

K L M N D E G H 0.05 0.1 0.15 0.2 Quit rate 0.1 10 Hires per year 11 5 Starting number of facutly 80 12 13 Ending 14 in Starting 8 Year faculty Hires faculty 15 9 80 A 76 10 76 72 11 72 A 69 12 69 4 56 13 66 63 14 53 61 15 61 59 16 59 57 17 57 55 18 10 55 A 53 19K L M N D E G H 0.05 0.1 0.15 0.2 Quit rate 0.1 10 Hires per year 11 5 Starting number of facutly 80 12 13 Ending 14 in Starting 8 Year faculty Hires faculty 15 9 80 A 76 10 76 72 11 72 A 69 12 69 4 56 13 66 63 14 53 61 15 61 59 16 59 57 17 57 55 18 10 55 A 53 19A B9:B18 ROUND(0.1*B9:B18,0) +C9:C18 Note: If the answer is a formula, there is no need to begin that answer with =. Please do not put any unnecessary spaces or () in your response. You would like to show how the number of faculty at the end of year 10 depends on the quit rate and number of annual hires. We would like for example, to have cell L10 give the number of Year 10 faculty if we hire 1 faculty member a year and 10% quit each year. Using the information in the spreadsheets below, what would be the row input cell for a twoway data table? B Answer: E3, E4 Note: If the answer is a formula, there is no need to begin that answer with =. Please do not put any unnecessary spaces or () in your response. You would like to show how the number of faculty at the end of year 10 depends on the quit rate and number of annual hires. We would like for example, to have cell L10 give the number of Year 10 faculty if we hire 1 faculty member a year and 10% quit each year. Using the information in the spreadsheets below, what would be the column input cell for the twoway data table? C Answer: E9:E18 Please do not put any unnecessary spaces or () in your response. You would like to show how the number of faculty at the end of year 10 depends on the quit rate and number of annual hires. We would like for example, to have cell L10 give the number of ending Year 10 faculty if we hire 1 faculty member a year and 10% quit each year. Using the information in the spreadsheets below, what formula would be entered in cell J9? D Answer: B9:B18 ROUND(0.1*B9:B18,0) +1 Please do not put any unnecessary spaces or () in your response. Consider the cash flows seen here. If we discount cash flows at 10% per year, the Net Present Value (rounded to the nearest dollar) of these cash flows as of 4/10/2011 is $595_____. Consider the cash flows seen here. The Internal Rate of return on the cash flows of Problem 26 (rounded to the nearest 1%) is ____34%________. Enter just the number; e.g., 18%