Many academic institutions offer a sabbatical policy. a year free of teaching and other administrative respc earning $70,000 per year who works for a total of 42 amount she will earn while on sabbatical if the annui Interest rate Years between sabbaticals Years of employment Number of sabbaticals 7-year period interest rate Value today Requirements $70,00 6.00% 50.36% S126,964. l. In cell Cll, by using cell references, calculate the nu taken (1 pt.). 2 Before calculating the value today, you need to find t will use to discount each amount earned during sabbi references, calculate the seven-year-period interest r 3 To calculate the value today, calculate the present val years using the function PV. In cell C13, by using th calculate the value today (1 pt.).