Give right answer in excel format kudos! Thanks! The following amortization and interest schedule...
70.2K
Verified Solution
Question
Accounting
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, 2014Get Answers to Unlimited Questions
Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!
Membership Benefits:
- Unlimited Question Access with detailed Answers
- Zin AI - 3 Million Words
- 10 Dall-E 3 Images
- 20 Plot Generations
- Conversation with Dialogue Memory
- No Ads, Ever!
- Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Other questions asked by students
StudyZin's Question Purchase
1 Answer
$0.99
(Save $1 )
One time Pay
- No Ads
- Answer to 1 Question
- Get free Zin AI - 50 Thousand Words per Month
Best
Unlimited
$4.99*
(Save $5 )
Billed Monthly
- No Ads
- Answers to Unlimited Questions
- Get free Zin AI - 3 Million Words per Month
*First month only
Free
$0
- Get this answer for free!
- Sign up now to unlock the answer instantly
You can see the logs in the Dashboard.