Give right answer in excel format kudos! Thanks!

The following amortization and interest schedule reflects the issuance of 10-year bonds by Ayayai Corporation on January 1, 2014, and the subsequent interest payments and charges. The company's year-end is December 31, and financial statements are prepared once yearly. Amortization Schedule Amount Unamortized Carrying Value Year Cash Interest 1/1/2014 $5,735 $ 95,765 2014 $11,165 $11,492 5,408 96,092 2015 11,165 11,531 5,042 96,458 2016 11,165 11,575 4,632 96,868 2017 11,165 11,624 4,173 97,327 2018 11,165 11,679 3,659 97,841 2019 11,165 11,741 3,083 98,417 2020 11,165 11,810 2,438 99,062 2021 11,165 11.887 1,716 99,784 2022 11,165 11,974 907 100,593 2023 11,165 12,072 101,500 (a) Indicate whether the bonds were issued at a premium or a discount. (b) Indicate whether the amortization schedule is based on the straight-line method or the effective-interest method. (c) Determine the stated interest rate and the effective-interest rate. (Round answers to 0 decimal places, e.g. 18 The stated rate % The effective rate % (d) On the basis of the schedule above, prepare the journal entry to record the issuance of the bonds on January 1, 2014. (If no entry is required, select "No Entry" for the account titles and enter for the amounts. Credit account titles are automatically indented when amount is entered. Do not indent manually.) Date Account Titles and Explanation Debit Credit January 1, 2014 (e) On the basis of the schedule above, prepare the journal entry to reflect the bond transactions and accruals for 2014. (Interest is paid January 1.) (If no entry is required, select "No Entry" for the account titles and enter for the amounts. Credit account titles are automatically indented when amount is entered. Do not indent manually.) Date Account Titles and Explanation Debit Credit December 31, 2014