Please answer A-G. calculate present value on excel for subquestion (C).

The Growing Company is expanding and they need some cash to help with their expansion. The company has decided to issue a bond with an eight year maturity. The bond was issued on January 1,2020. The principal for the bond is $37,500,000 and the bond was issued at a discount. The bond pays interest semi annually Required A. You must create the following to complete the problem: Determine the stated interest rate Determine the market interest rate B Calculate the annuity for the bond and the number of periods C Using Excel and showing your work, calculate the Present Value for the bond. D. Prepare the journal entry for January 1,2020 show your work E. Prepare the journal entry for the interest/annuity payment F Prepare the amortization journal entry for the premium G Explain why interest expense dollar amount is different than cash the dollar amount if you combine transaction E and F