On January $1,$ Meister Company issues $$200,000$ of $6\%$ bonds. Interest of $$6,000$ is payable semi$-$annually on June $30$ and December $31.$ The bonds mature in $5$ years.The market yield for bonds of similar risk and maturity is $4\%.$ Utilizing the time value of money tables in your book, calculate the issue price of the bonds $($round the result to whole dollars$).$

I understand this is generally figured out by using PV or FV$,$ and i cannot figure out how to calculate it$.$ If an explanation could be provided $($bonus if its how to do the formula in Excel$),$ i would very much appreciate that. Thank you!