2Problem: On January 1, 2016, the Auto-Stop Corporation issued bonds in the amount of $10,000 that will be paid in three years. Interest of $400 is payable semiannually 3 each January 1 and July 1 with the first interest payment at the end of the period, on July of the current year. Draw a time lit e of the bonds cash outflo s if the mate rate of interest is 10%, what is the amount of the bond issue proceeds cash received when Auto-Stop Corporation issued the bonds? PV Single Sum? $10,000 7 PV Ordinary Annuity-7 $400 $400 S400 $400 $400 400 t=0 1 11|VY=5%, N = 6 3 Use PV formula in Excel (fx) to compute the PV of the cash outflows related to bond issuance Fill in the formula in 15 (1) PV of Single Sum 16 (2) PV of Ordinary Annuity ? 17 Total PV Your answers should be 7,462.15 2,030.28 9,492.43 19 This should be equal to the amount of the bond issue proceeds(cash received) 20 Sheetl