please help explain how each step is done with their excel formulas for a thumbs up$!$

In each of the following independent cases the compary doses its books on December $31$

Sandford Co$.$ sells bonds on March $1,2025.$ The bonds pay interest on September $1$ and March $1.$ The

due date of the bonds is September $1,2028.$ Pertinent information follows:

Give the entries through December $31,2026.$

Titaria Co$.$ sells bonds on June $1,2025.$ The bonds pay interest on December $1$ and June $1.$ The due

date of the bonds is June $1,2029.$ On October $1,2026,$ Titarla buys back a portion of the bonds.

Additional information follows:

Give the entries through December $1,2027.$

Instructions

For the two cases prepare all of the relevant journal entries from the time of sale until the date indicated.

Use the effective$-$interest method for discount and premium amortization $($oonstruct amortization tables

where applicable$).$ Amortise premium or discount on interest dates and at yearend. $($Assume that no

reversing entries were made.$)$

Sunford Co$\_(2)$

Calculation of issoe price and discount using Excels PV function:

Maturity Valae of Boeds Payable

Proceeds from Sale of Boods using Excels PV Function

Discount oa Boods Payable

Schedule of Boed Discouns Amortization

Effective Interest Method

$10\%$ Boods Sold to Yield $12\%$