I really need help in how to plug in the formulas in excel for this project. I am not very good at excel as I don't use it and will be getting intro course next semester. Can I please get help or show me what formulas and how that needs to be plugged in. I would truly appreciate it!!!

Project #5 - Bond Amortization The Peg Corporation (TPC) issued $6,000 bonds on January 1, 2018 and received $6,101 cash for the bonds. The stated interest rate was 7.5%, payable annually. The bonds have a 4 year life. The market interest rate at time of issuance was 7%. REQUIRED: 1 Prepare a bond amortization schedule using the straight line method of amortization for all 4 years 2 Prepare a bond amortization schedule using the effective interest method of amortization for all 4 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. ** Include a data or information section on the worksheet. ** Link the amortization schedule to the data/information section. ** Answers can be rounded to whole dollars OR two decimal places