Estate & Finance in Excel

Provide spreadsheet data, hide repetitive rows to reduce the number of pages to ONE (e.g., landscape mode; 5-point deduction otherwise). You must annotate each formula (in one row) to receive full or partial credit.  Answer all questions in the order given (though all the data can be on one page at the beginning; 1-point deduction otherwise).