Formula: Subtract; Cell Referencing BE17.4 - Using Excel to Prepare Entries for Debt Investments PROBLEM Hendricks Corporation purchased trading investment bonds at pat Student Work Area Required: Provide input into cells shaded in yellow in this template. Use cell references Problem arca, with mathematical formulas to calculate any amounts not given. the Purchase price of bonds 50,000 The following data was provided by Hendricks at December 31. Prepare Hendricks journal entries for: (a) The purchase of the investment (b) The interest received (c) The fair value adjustment Annual interest received Fair value of the bonds 2.000 47,400 Debit Credit A zero balance exists in the Fair Value Adjustment account before the above activity. (a) (b) (c)