Could you please give clear and very detailed answers with cell references, please.
A B D E F G H 1 J M Project #4 - Bond Amortization Information given in word problem format: The Peg Corporation (TPC) issued $70,000 bonds on January 1, 2018 and received $72,500 cash fo The stated interest rate was 7.5%, payable annually. The bonds have a 5 year life. The market interest rate at time of issuance was 6.638%. 1 2 3 Use the second tab for all the responses. 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. 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. Using the schedules created and linking/referencing to the schedule cells.... Record the journal entry for the sale or issuance of the bond. Record the journal entry for ONLY the year one interest payment for both methods. Record the journal entry for the bond retirement at the end of year 5, after the year 5 interest payment is complete and recorded. Record the journal entry if the bond is retired on the first day of year 5 for both methods. A cash payment of $70,550 was needed to buy back the bonds. *** 4 5 6 7 Chapter & Course Outcomes: (demonstrated in this project) A Complete amortization calculations using both the straight line and effective interest methodologies. Analyze and record journal entries for bond liability transactions including sale, interest payment and amortization of discount B or premium. Determine the impact on the financial statements. C Use Microsoft Excel proficiently to record and summarize information used in business analysis and decision making. For journal entry requirements DATE DESCRIPTION ACCOUNT Year Debit Credit A B D E F G H 1 J M Project #4 - Bond Amortization Information given in word problem format: The Peg Corporation (TPC) issued $70,000 bonds on January 1, 2018 and received $72,500 cash fo The stated interest rate was 7.5%, payable annually. The bonds have a 5 year life. The market interest rate at time of issuance was 6.638%. 1 2 3 Use the second tab for all the responses. 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. 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. Using the schedules created and linking/referencing to the schedule cells.... Record the journal entry for the sale or issuance of the bond. Record the journal entry for ONLY the year one interest payment for both methods. Record the journal entry for the bond retirement at the end of year 5, after the year 5 interest payment is complete and recorded. Record the journal entry if the bond is retired on the first day of year 5 for both methods. A cash payment of $70,550 was needed to buy back the bonds. *** 4 5 6 7 Chapter & Course Outcomes: (demonstrated in this project) A Complete amortization calculations using both the straight line and effective interest methodologies. Analyze and record journal entries for bond liability transactions including sale, interest payment and amortization of discount B or premium. Determine the impact on the financial statements. C Use Microsoft Excel proficiently to record and summarize information used in business analysis and decision making. For journal entry requirements DATE DESCRIPTION ACCOUNT Year Debit Credit
