Use excel

A complex annuity makes the following payments. However, the cash flow in Period $4$ is missing. The total present value of all cash flows including the missing cash flow in Period $4$ is $$674\mathrm{.}58.$ The appropriate discount rate $/$ period is $10\%.$ Find the missing cash flow.

$\backslash$table$[[0,1,2,3,4,5,6],[,,,,,,],[100,100,100,???,100,100,]]$