Paul takes a loan of $225,000 from the bank at 7% interest rate per year over a 10-year period. He plans to pay off the loan in 10 yearly payments of $16,000 each, and with the money that he is going to inherit from his grand parents. How much should he inherit to pay off the entire loan if the grand parents give him the money at the end of the 4th year and he hands over the entire amount to the bank on the day he receives it?

Can you please work in excel adjusting NPER and RATE with PV and FV formulas to find the inheritance needed. Please if you do not know how to do this in the way I'm asking do not copy and paste an already posted solution. Thank You