Computing Bond Issue Price and Preparing an Amortization Table in Excel On December 31, 2021, Kaplan,...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Computing Bond Issue Price and Preparing an Amortization Table in Excel On December 31, 2021, Kaplan, Inc., issues $550,000 of 9% bonds that pay interest semiannually and mature in 10 years (December 31, 2031). a. Using the Excel PV worksheet function, compute the issue price assuming that the bonds' market rate is 8% per year compounded semiannually. (Refer to Appendix A for illustration.) Round answer to two decimal places. Issue price $ 0 b. Prepare an amortization table in Excel to demonstrate the amortization of the book (carrying) value to the $550,000 maturity value at the end of the 20th semiannual period. (Refer to Appendix A for illustration.) The amortization schedule can be completed using the following Excel template: Amortization Schedule Using the figures from the amortization schedule created in Excel, complete the amortization schedule below for 2022: Enter answers using two decimal places. Beginning Premium Date Period balance 1/1/22 0 Payment Interest amortization Premium balance $ Book value 0 $ 0 6/30/22 1 $ 12/31/22 2 0 $ 0 $ 0 $ 0 0 0 0 0 0 0 0 0 Computing Bond Issue Price and Preparing an Amortization Table in Excel On December 31, 2021, Kaplan, Inc., issues $550,000 of 9% bonds that pay interest semiannually and mature in 10 years (December 31, 2031). a. Using the Excel PV worksheet function, compute the issue price assuming that the bonds' market rate is 8% per year compounded semiannually. (Refer to Appendix A for illustration.) Round answer to two decimal places. Issue price $ 0 b. Prepare an amortization table in Excel to demonstrate the amortization of the book (carrying) value to the $550,000 maturity value at the end of the 20th semiannual period. (Refer to Appendix A for illustration.) The amortization schedule can be completed using the following Excel template: Amortization Schedule Using the figures from the amortization schedule created in Excel, complete the amortization schedule below for 2022: Enter answers using two decimal places. Beginning Premium Date Period balance 1/1/22 0 Payment Interest amortization Premium balance $ Book value 0 $ 0 6/30/22 1 $ 12/31/22 2 0 $ 0 $ 0 $ 0 0 0 0 0 0 0 0 0
Expert Answer:
Posted Date:
Students also viewed these accounting questions
-
National paper Company must purchase a new machine for producing cardboard boxes. The company must choose between two machines. The machines produce boxes of equal quality, so the company will choose...
-
What alternative methods are used to disclose additional information not included in the accounts reported on a companys financial statements? Give examples of the types of information disclosed by...
-
Find the pattern in the number of mites on a lizard with x0 = 10 and following the discrete-time dynamical system xt+1 = 2xt + 30.
-
Describe and illustrate the credit multiplier.
-
Logan Distributing Company of Atlanta sells fans and heaters to retail outlets throughout the Southeast. Joe Logan, the president of the company, is thinking about changing the firms credit policy to...
-
7 1 point In the 1960s, Beatrice and Roger Gardner began Project Washoe, a remarkable attempt to teach American Sign Language to a female chimpanzee named Washoe. By the time she was four years old,...
-
We will proceed by taking advantage of agile approaches,especially scrum. 1) Prepare PBL(Product BackLog list, create user stories, tasks. Give estimation and create ACC(Agile Coach Certification)....
-
Because stress is a complex and highly personalized process, some individuals see a specific situation as a threat, whereas others see the same situation as a challenge or opportunity. TRUE/FALSE.
-
Process theories of motivation assist managers in predicting employees' behavior so that the behavior may be influenced if necessary. TRUE/FALSE.
-
Give three reasons why the ICP accelerometer is the chosen transducer for vibration analysis.
-
Which of the following is not an activity of the HIMSS-SIIM Enterprise Imaging Community? (a) Webinar series (b) Publication of white papers (c) Networking (d) Membership outreach (e) Mentorship...
-
True or False: The rotor vibration of an electric motor cannot be read without proximity probes.
-
Problem 3 Payroll Entries The payroll register for the Puhl Company for the week ended January 15th showed the following: Wages Federal Income Tax withhel Roth IRA deductions United Way deductions...
-
One hundred pounds of water at atmospheric pressure are heated from 60F to 200F. What is the enthalpy change? The internal energy change? Why is the difference between the internal energy change and...
-
Arich uncle allows you to stipulate which of two ways you receive your inheritance: a. \($850,000\) one year after his death or b. \($250,000\) on his death and \($200,000\) each year at the end of...
-
You have the right to receive \($30,000\) at the end of each of the next four years, and money is worth 8%. Using the PV tables, your financial calculator, or Excel, compute the present value of this...
-
Briefly describe the concept of the time value of money.
Study smarter with the SolutionInn App