Solve In Excel and please Show formulas. As well as possible steps to do a Cashflow diagram

Exercise 3.11 : Joan takes a loan of $80,000 over a period of 10 years from a bank at an interest rate of 5% per year. She plans to pay it off in 10 year-end payments of $7,000 each. As these payments will not be able to pay off the loan, she also decides to pay the entire amount that she hopes to inherit from her grandfather at the end of the fifth year. What would the size of the inheritance need to be to pay off the loan