correcurg ennies Tor Donus uansacuoris 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. DR CR 01/01/19 Cash 607,434 Accounts Payable 607,434 (issued $600,000, of 12%, 3-year bonds. Interest is payable semiannually on June 30 and January 1. The effective rate was 11.5%) 06/30/19 Interest Expense 36,000 Cash 36,000 (First semiannual interest payment) 36,000 36,000 12/31/19 Interest Expense Interest Payable (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 rocu o 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 Function Arguments PV Rate Niper Type Return thereof an investment themes of future is worth now Rate the interese period. Forutsetorustry DAR 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. e. Assuming the company closes its books on December 31" prepare the journal entries for 12/31/19 and 1/1/20 1. What is the effect of these errors on Net Income, Earnings per Share, Total Liabilities 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(ies) to correct the error Focus ernet can contain viruses. Unless you need to edit, it's 1. Use Excel's 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 Before starting to use the Scenario Manager, use the Name Box (found above column A) to name the following variables (do not use accents nor spaces): 1. Select the cell where you entered the market rate the number) and type in the Name Box TasaMercado 2. Select the cell where you computed the total interest expense (at the end of the amortization schedule) and type in the Name Box: Gasto Totalinteres. 3. Seled the cell where you computed the present value (cash proceeds) of the bond and type in the Name Box: ValorPresente This is the Name Box AL Scenario Manager Scenarios are part of a suite of commands called what-if analysis tools provided by Microsoft Excel. What-if analysis is the process of changing the values in cells to see how those changes affect the outcome of formulas on the worksheet. Excel saves a set of values in a scenario and can automatically substitute these values in your worksheet. You can create and save different groups of values as scenarios and then switch between these scenarios to view the different results Scenario manager is available from the Data tab, in the Forecast group in the what-if-Analysis command. Create the following 4 scenarios using the ADD button Scenario name = 1 We are typing the NAME of the Changing cell = TasaMercado variable: Excel will automatically Scenario value= 16 (in the screen that appears after you click ok) identify the cell address Scenario name = 2 Changing cell = TasaMercado Scenario value= 14 (in the screen that appears after you click ok) Focus Search Tabla Excel Bonos - Protected ViewSaved to this PC- aalai enge Created by and 2/1/2018 Bed angels OE Layout References Mailings Review View Help net can contain viruses. Unless you need to edit, it's safer to stay in Protected View Enable Editing Scenario name = 2 Changing cell = TasaMercado Changing Scenano value= 14 (in the screen that appears after you click ok) Scenario name = 3 Changing cell = TasaMercado Scenano value= 11 (in the screen that appears after you click ok) Scenario name = 4 Changing cell = TasaMercado Scenario value= 09 (in the screen that appears after you click ok) Then select Summary and make sure scenario summary is selected in the next box In the result cells. Type the names of both independent variables separated by a comma: Gasto Totallnteres, ValorPresente Scenario Summary Report type We are typing the NAME of the Scenario summary variables, Excel will automatically Scenario BivotTable report identify the cell address Result cells: GastototalInteres, ValorPresente ? OK Cancel Finally press OK and Excel will create a table with the results for each scenario Briefly, summarize your findings. i Assume that on January 1, 2019. AAA had bond issue costs of $5,000. Use Excel's built-in formula for RATE to determine the effective interest rate of the net liability on the issuance date What effect has the debt issue costs on the effective interest rate when compared against the original effective interest rate? Focus correcurg ennies Tor Donus uansacuoris 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. DR CR 01/01/19 Cash 607,434 Accounts Payable 607,434 (issued $600,000, of 12%, 3-year bonds. Interest is payable semiannually on June 30 and January 1. The effective rate was 11.5%) 06/30/19 Interest Expense 36,000 Cash 36,000 (First semiannual interest payment) 36,000 36,000 12/31/19 Interest Expense Interest Payable (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 rocu o 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 Function Arguments PV Rate Niper Type Return thereof an investment themes of future is worth now Rate the interese period. Forutsetorustry DAR 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. e. Assuming the company closes its books on December 31" prepare the journal entries for 12/31/19 and 1/1/20 1. What is the effect of these errors on Net Income, Earnings per Share, Total Liabilities 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(ies) to correct the error Focus ernet can contain viruses. Unless you need to edit, it's 1. Use Excel's 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 Before starting to use the Scenario Manager, use the Name Box (found above column A) to name the following variables (do not use accents nor spaces): 1. Select the cell where you entered the market rate the number) and type in the Name Box TasaMercado 2. Select the cell where you computed the total interest expense (at the end of the amortization schedule) and type in the Name Box: Gasto Totalinteres. 3. Seled the cell where you computed the present value (cash proceeds) of the bond and type in the Name Box: ValorPresente This is the Name Box AL Scenario Manager Scenarios are part of a suite of commands called what-if analysis tools provided by Microsoft Excel. What-if analysis is the process of changing the values in cells to see how those changes affect the outcome of formulas on the worksheet. Excel saves a set of values in a scenario and can automatically substitute these values in your worksheet. You can create and save different groups of values as scenarios and then switch between these scenarios to view the different results Scenario manager is available from the Data tab, in the Forecast group in the what-if-Analysis command. Create the following 4 scenarios using the ADD button Scenario name = 1 We are typing the NAME of the Changing cell = TasaMercado variable: Excel will automatically Scenario value= 16 (in the screen that appears after you click ok) identify the cell address Scenario name = 2 Changing cell = TasaMercado Scenario value= 14 (in the screen that appears after you click ok) Focus Search Tabla Excel Bonos - Protected ViewSaved to this PC- aalai enge Created by and 2/1/2018 Bed angels OE Layout References Mailings Review View Help net can contain viruses. Unless you need to edit, it's safer to stay in Protected View Enable Editing Scenario name = 2 Changing cell = TasaMercado Changing Scenano value= 14 (in the screen that appears after you click ok) Scenario name = 3 Changing cell = TasaMercado Scenano value= 11 (in the screen that appears after you click ok) Scenario name = 4 Changing cell = TasaMercado Scenario value= 09 (in the screen that appears after you click ok) Then select Summary and make sure scenario summary is selected in the next box In the result cells. Type the names of both independent variables separated by a comma: Gasto Totallnteres, ValorPresente Scenario Summary Report type We are typing the NAME of the Scenario summary variables, Excel will automatically Scenario BivotTable report identify the cell address Result cells: GastototalInteres, ValorPresente ? OK Cancel Finally press OK and Excel will create a table with the results for each scenario Briefly, summarize your findings. i Assume that on January 1, 2019. AAA had bond issue costs of $5,000. Use Excel's built-in formula for RATE to determine the effective interest rate of the net liability on the issuance date What effect has the debt issue costs on the effective interest rate when compared against the original effective interest rate? Focus