Excel Project $3$: Worth $10$ Points Total

$5$ Points $-$ Completing this Excel sheet by making an efficient use of Excel. Must use cell references and$/$or formulas in green cells. Hard coding numbers in green cells $($regardless of if they are correct$)$ will result in point deductions $($i$.$e$.$ if you hard code all green cells you will receive $0$ points for this$-$part of the project$).$ This Excel sheet does not need to be correct to receive all $5$ points. The purpose of this part of the project is to use Excel efficiently.

$5$ Points $-$ Inputting correct answers into WileyPlus. The WileyPlus platform will be graded for accuracy only. How you get to the answer is up to you $-$ I recommend using this Excel sheet to help you!

P$13\mathrm{.}5($LO $1,2)$ Comprehensive Bond Problem

In each of the following independent cases the company closes its books on December $31.$

Sandford Co$.$ sells bonds on March $$2025.$ The bonds pay interest on September $1$ and March $1.$ The due date of the bonds is September $1,2028.$ Pertinent information follows:

$\backslash$table$[[$Par value of the bonds,$$500,000$