# Essay A University Begins Year 1 With 80 Faculty

671 Words Jul 12th, 2015 3 Pages
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 _
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
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%

Suppose in Problem 40 we want to highlight the year number for each year during which sales were at least 5% higher than the previous year. We would begin by selecting the cell range D6:D12 and choose Conditional Formatting from the Ribbon. Then you would select new rules followed by the Use a Formula option. Finally you would enter the following formula.

(E5/E4)>1.05 (\$E\$6/E5)>1.05 (E6/E5)>1.05 (E6/E5)>.05