hmwk help! needs to be on excel

The Janjua Company had the following account balances at 1/1/24 : On that date, the Accumulated OCI account was at its appropriate balance. There were no sales or purchases of Common Stock or Investments during 2024. Prior to any adjusting journal entries related to the Investments, 2024 Net Income was $4,700. No other transactions affecting Retained Earnings occurred. Fair Value of the Investments at 12/31/24 was $22,000. Required for Part I: (a) Prepare the 12/31/24 journal entry to adjust the investment to fair value. (b) Prepare the complete 12/31/24 Equity section of the balance sheet. The following information relates to the HTM debt securities investments of Kiran Company during 2024: a) February 1: The company purchased 10\% bonds of Tempe Co. having a par value of $100,000 at 97 plus accrued interest. Interest is payable June 1 and December 1. Maturity date is 6/1/27. b) June 1: Semiannual interest is received and amortization is updated. c) July 1: 9\% bonds of Flagstaff, Inc. were purchased. These bonds with a par value of $50,000 were purchased at 103 plus accrued interest. Interest dates are May 1 and November 1. Maturity date is 11/1/27. d) November 1: Semiannual interest is received and amortization is updated on Flagstaff bonds. e) December 1: Semiannual interest is received and amortization is updated on Tempe bonds. f) December 31: Interest is accrued and amortization is updated on both investments. Required for Part II: a) Prepare journal entries for all dates. Present journal entries for the Tempe bonds (a, b, e, f), then journal entries for the Flagstaff bonds (c,d,f). No explanations or supporting computations are required. Use straight-line amortization. Do NOT use separate accounts for discounts and premiums; instead, net them into the Investments account. When computing amortization, round the monthly amortization amounts to the nearest cent. However, journal entry amounts can be rounded to the nearest dollar