I need help with Case 10 in the Problem-Solving Cases In Microsoft Access & Excel, 15th Edition on pages 167-174.

Can any one help?

a Search Sheet Share ^ Insert Page Layout Formulas Data Review View Developer AutoSum Wrap Text General Calibri Body) , 16 A^ A | | B 1 . ,_, _, A, Merge & Center, $ , % , o *a Conditional Format Cell Sort & Filter Insert Delete Format Copy Clear Formatting as Table Styles A1x f TEACHERS PENSION FUND a CONSTANTS 4 Retiree Years ot Service 0.01 0.04 0.05 8952 527071,418 0.01 0.01 0.01 0.01 0.09 0.06 2,000 5 0.01 0.09 0.06 82820 0.09 0.06 90579 27,343,132 Averae Increese in Teacher Salary 0.05 83648 0.05 84485 1485 27,61555 0.05 92,400 527891,709 85,330 5 87045 S 87915 88,791 S Mortaity Rate Expected Average Final Salary 7 86,183 526001,84 8 525,757525 11 NPUTS 12 Cost of living Adjustment 13 Long Term Rate of Return 14 Psoductivity actor Final Salarye Back Sate Contribution Facto 20 NPV of Unfunded Liability RatoAsses To Labilty P 8,500 133000 24 Average Teacher Salary 5 Number 2 Number o of Acte Teachars Number ot 2 Tocal Teacher Comperaation 29 Emplayec ContrbunoFund State Contibution to Fund 3 Averape Retiree Benefit 32 Experced Benefits Payout FUND BALANCE STATEMENT 35 Beginning Balance Add: Emplayee Contrbution Add:Stabe Connibution 9 Les Benetits Payout 0 Less Administratve Expenses 41 Ending Bolance C4 Expected Benefits Payout S Net Present Valse of Payouts Ratio of Assets to Lisbility NP + 90% Ready 25 25 25 a Search Sheet Share ^ Insert Page Layout Formulas Data Review View Developer AutoSum Wrap Text General Calibri Body) , 16 A^ A | | B 1 . ,_, _, A, Merge & Center, $ , % , o *a Conditional Format Cell Sort & Filter Insert Delete Format Copy Clear Formatting as Table Styles A1x f TEACHERS PENSION FUND a CONSTANTS 4 Retiree Years ot Service 0.01 0.04 0.05 8952 527071,418 0.01 0.01 0.01 0.01 0.09 0.06 2,000 5 0.01 0.09 0.06 82820 0.09 0.06 90579 27,343,132 Averae Increese in Teacher Salary 0.05 83648 0.05 84485 1485 27,61555 0.05 92,400 527891,709 85,330 5 87045 S 87915 88,791 S Mortaity Rate Expected Average Final Salary 7 86,183 526001,84 8 525,757525 11 NPUTS 12 Cost of living Adjustment 13 Long Term Rate of Return 14 Psoductivity actor Final Salarye Back Sate Contribution Facto 20 NPV of Unfunded Liability RatoAsses To Labilty P 8,500 133000 24 Average Teacher Salary 5 Number 2 Number o of Acte Teachars Number ot 2 Tocal Teacher Comperaation 29 Emplayec ContrbunoFund State Contibution to Fund 3 Averape Retiree Benefit 32 Experced Benefits Payout FUND BALANCE STATEMENT 35 Beginning Balance Add: Emplayee Contrbution Add:Stabe Connibution 9 Les Benetits Payout 0 Less Administratve Expenses 41 Ending Bolance C4 Expected Benefits Payout S Net Present Valse of Payouts Ratio of Assets to Lisbility NP + 90% Ready 25 25 25