15 part question. Need net proceeds, cost of each bond in terms of yield, market price

Selling bonds. Astro Investment Bank has the following bond deals under way: Determine the net proceeds of each bond and the cost of the bonds for each company in terms of yield. The bond yield in the table is the market yield before the bank charges its commission. Assume all bonds are semiannual and issued at a par value of $1,000. For Gravity Belts, the market price of the bond is $ (Round to the nearest cent) Click on the following lcon in order to paste this table's content into a spreadsheet \begin{tabular}{|l|c|c|c|c|} \hline Compeny & Bond Yeld & Commisaion & Coupon Raio & Maturily \\ \hline Gravity belts & 8.3% & 1.6% of sale price & 8.3% & 10 years \\ \hline Invisible rays & 8.8% & 3.3% of sale price & 11.8% & 10 years \\ \hline Solar glasses & 7.3% & 2.5% of sale price & 4.5% & 20 years \\ \hline Spaceships & 11.6% & 4.4% of sale price & 0.0% & 20 years \\ \hline Lunar vacations & 9.9% & 3.5% of sale price & 9.9% & 50 years \\ \hline \end{tabular}