. 4 Information given in word problem format: The Peg Corporation (TPC) issued $70,000 bonds on January 1, 2018 and received $72,500 cash for the bonds. The stated interest rate was 7.5%, payable annually. " The bonds have a 5 year life. 7 The market interest rate at time of issuance was 6.638%. B . Use the second tab for all the responses. Round answers to 2 decimal places. 30 " 12 13 14 15 18 12 REQUIRED FOR POINTS: Create a data/reference/master table with all required information. This time you are creating the worksheet from the beginning. Prepare a bond amortization schedule using the straight line method of amortization for all 5 years. Be sure to include all the columns on the amortization schedule for the interest journal entry as well as the individual accounts and carrying value that would be presented on the Balance Sheet. Link or reference the amortization schedule to the data/reference/master table you create. Referencing 'answer' cells back to 'input' cells creates a functioning, effective worksheet. Making these connections allows the worksheet to be used for analyzing potential changes in the results. Prepare a bond amortization schedule using the effective interest method of amortization for all 5 years. Be sure to include all the columns on the amortization schedule for the interest journal entry as well as the individual accounts and carrying value that would be presented on the Balance Sheet. Link or reference the amortization schedule to the data/reference/master table you create. Referencing 'answer' cells back to 'input' cells creates a functioning, effective worksheet. Making these connections allows the worksheet to be used for analyzing potential changes in the results. Using the schedules created and linking/referencing to the schedule cells.... Record the journal entry for the r : 3 17 . A