Project 1 - Student (1) Read-Only - Excel AutoSave Help View Developer Review Formulas Data Home insert Page Layout ste - pboard Calisto MT - ' ' 29 Wrap Ted Corvi BTW -A- $ - % 9383 Formal Font Alignment Number . IF(Introduction SESA", VLOOKUP(VALUE(Introduction ISESA), Questions ISQ$2:$AL B C D FGH M N On January 1, 2019, Schooner Corp. troed bonds having the following characteristics: A Face value: $100,000.00 Issue price: $90,975.00 Stated ratet 8% per year Market rate: 9% per year Maturity: 19 years The bonds make semiannual interest payments on June 30 and December 31 Assume that the company uses the straight line interest method Part (a) Prepare the journal entry for interest on June 30, 2019. (When computing amounts, use Excel formulas and cell references only. Do not manually input values.) Debit Credit Account Title Part (b) What is the balance of the discount account as of January 1, 2021 (after the fourth interest payment)? (Use Excel formulas and cell references only. Do not manually input values.) Introduction Question Question Question 3 Background on the PV function ly Type here to search MacBoc