Plss answer in excel with detailed and step by step calculation shown ...
80.2K
Verified Solution
Question
Finance
Plss answer in excel with detailed and step by step calculation shown
Question 1 Bonds (23 marks) Terra Company issued a $300,000,7.50%,10-year bond on June 1,2015 . Additional information on the bond follows: Bond Date: January 1,2015 Maturity Date: December 31,2024 Yield (Market) Rate: 8% Interest Payment Date: Interest is paid annually on December 31 of each year Terra's year end: September 30 Required: Round calculations to the nearest dollar a) Calculate the present value of the bond assuming that it had been issued on January 1, 2015. Show calculations/keystrokes. ( 1 mark) b) Prepare a bond amortization table from January 1, 2015 until December 31, 2018. Show each annual interest payment. ( 3 marks) c) Calculate the total amount of cash received by Terra on June 1, 2015, reflecting the fact the bond was issued on June 1, 2015. Make the journal entry to record the bond issue on June 1, 2015. (4 marks) d) Prepare the adjusting entry required at Terra's year end, Sept 30, 2017. (2 marks) e) Prepare the journal entry on Terra's books to make the December 31, 2017 interest payment to its investors. ( 2 marks) f) On July 1,2018, Terra Company decides to retire 20% of the bonds at 98 plus accrued interest. (i) Make the entry to record interest up to July 1 including interest payable (interest will be paid when the bond is retired in part (ii) below) ( 3 marks) (ii) Make the entry to retire the bonds. ( 5 marks) g) Make the entry on Terra's books on December 31, 2018 to pay out interest to the remaining bondholders. ( 3 marks)
Plss answer in excel with detailed and step by step calculation shown

Get 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.