Computing Bond Issue Price and Preparing an Amortization Table in Excel
On December 31, 2015, Kaplan, Inc., issues $300,000 of 9% bonds that pay interest semiannually and mature in 10 years (December 31, 2025).
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 $Answer
b. Prepare an amortization table in Excel to demonstrate the amortization of the book (carrying) value to the $300,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 2016
Enter answers using two decimal places.
Answers: 1
Business, 22.06.2019 17:30
Alinguist had a gross income of 53,350 last year. if 17.9% of his income got witheld for federal income tax, how much of the linguist's pay got witheld for federal income tax last year?
Answers: 2
Business, 23.06.2019 00:40
An upper-middle-class manager tends to have hostile relationship with the working-class employees in the firm because of his tendency to perceive himself as superior to them based on his class background. in this example, the manager exhibits: question 14 options: 1) class consciousness. 2) cultural awareness. 3) social mobility. 4) group orientation.
Answers: 3
Business, 23.06.2019 01:00
Sarah is an accountant with desires to open her own business. she is looking for office space at a reasonable rate along with internet service. of the conditions that need to be put in place for the entrepreneurial ecosystem, she needs
Answers: 1
Business, 23.06.2019 10:00
Francesca opened a checking account at first bank one month ago. during the month she wrote 25 checks. first bank will charge her $.25 per check. this fee per check is called a a. service charge b. monthly charge c. transfer charge d. debit charge
Answers: 2
Computing Bond Issue Price and Preparing an Amortization Table in Excel
On December 31, 2015, Kapl...
Mathematics, 07.05.2021 20:30
Physics, 07.05.2021 20:30
Mathematics, 07.05.2021 20:30
English, 07.05.2021 20:30
English, 07.05.2021 20:30
Physics, 07.05.2021 20:30
Mathematics, 07.05.2021 20:30
Mathematics, 07.05.2021 20:30
Mathematics, 07.05.2021 20:30
Business, 07.05.2021 20:30
Mathematics, 07.05.2021 20:30
Business, 07.05.2021 20:30
Mathematics, 07.05.2021 20:30