The formula entered in cell g9 and copied down to g10g18


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. In cell G9 the first cell address referred to was cell E9. The formula entered in cell G9 and copied down to G10:G18 was E9+F9 followed by

Request for Solution File

Ask an Expert for Answer!!
Finance Basics: The formula entered in cell g9 and copied down to g10g18
Reference No:- TGS0947412

Expected delivery within 24 Hours