Enter formulas in cels that contain question marks $($only use formulas$).$ After entering formulas in all of the cells that contain questian marks, werify that the amounts match the example below.

$($a$)$

Calculate the $1$ssue price of the bonds $$2,786,813\mathrm{.}95$ D$1$scount

$($b$)$ Complete the first four rows of the amortization schedule

$($c$)$ Record issuance of the bonds

$($d$)$ Record the first interest payment

$($c$)$ Record the second interest payment

Save your completed Applying Excel form to your computer and then upload it here by cllcking "Browse". Next click "Save". You will use this worksheet to answer questions in Part $2.$ Basmes:

$($a$)$ Calculane the issue price of the bends

$($b$)$ Complese the fint four nows of the anoetintion schedule

$($c$)$ Fecend issuance ef the bonds

$($d$)$ Fecend the fins inserest pappetent

$($e$)$ Fecend the second inserest payptient