COURSE LEARNING OBJECTIVE: Students will use electronic worksheets or other productivity Tool to solve problems and develop models EXCEL LEARNING OBJECTIVES: Use the built-in formulas to determine the present Value (PV) of a bond - Use the built-in formulas to determine the effective issuance rate of a bond with issue costs (RATE) Set up an automated bond amortization schedule - Name cells using the Name Box Use Scenario Manager to create a scenario describing the effects of a change in the market interest rate (an Independent variable) on the proceeds from issuing the bond (a dependent variable) and the corresponding total interest expense (a dependent variable) over the term of the bond. DR Correcting entries for bonds transactions AAA Inc recently hired a new accountant with extensive experience in tax accounting. Because of the pressures of the new job, the accountant was unable to review the topic of accounting for bonds payable During the first year, he made the following entries for the issuance of new bonds and the two interest payments CR 01/01/19 Cash 607,434 Accounts Payable 607,434 fed 3600.000, of 1253-year bonds Invest is payable semiannually on June 30 and January 1. The effective rate was 11.5%) 06/30/19 Interest Expense 38,000 Cash 36,000 First semiannual interest paymen 12/31/19 Interest Expense 36,000 Interest Payable 36,000 (Second semiannual interest INSTRUCTIONS: Based on the explanation of each entry. a. Set up an Excel sheet similar to the example below. b. Determine the proceeds from the issuance of bonds using Excel's built-in formula for PRESENT VALUE = PV. c. Set up an amortization schedule (entirely using formulas) in Excel under the effective interest method. d. Prepare the entries (in Excel) that should have been made on 1/1/19 and 6/30/19 assuming the company uses the effective interest method to amortize the premium and discount on its bonds 2. Assuming the company closes its books on December 31", prepare the journal entries for 12/31/19 and 1/1/20 What is the effect of these errors on Net Income, Earnings per Share, Total abilities and Retained Earnings if they are not discovered (detected) before the publication of the annual report? g. Assuming the error was discovered at the end of 2019 but before closing the books, prepare the necessary journal entry(ies) to correct the error. h. Assuming the error was discovered at the beginning of January of 2020, prepare the necessary journal entry(les) to correct the error