Business, 02.05.2021 14:00 maiyat

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

Show answers

Other questions on the subject: Business

Business, 21.06.2019 23:30, reddmeans6

Starting at age 30, you deposit $2000 a year into an ira account for retirement. treat the yearly deposits into the account as a continuous income stream. if money in the account earns 7%, compounded continuously, how much will be in the account 35 years later, when you retire at age 65? how much of the final amount is interest?

Answers: 2

continue

Business, 22.06.2019 17:10, mikailah0988

At the end of the current year, accounts receivable has a balance of $550,000; allowance for doubtful accounts has a credit balance of $5,500; and sales for the year total $2,500,000. an analysis of receivables estimates uncollectible receivables as $25,000. determine the net realizable value of accounts receivable after adjustment. (hint: determine the amount of the adjusting entry for bad debt expense and the adjusted balance of allowance of doubtful accounts.)

Answers: 3

continue

Business, 22.06.2019 22:10, jeanieb

Consider the labor market for computer programmers. during the late 1990s, the value of the marginal product of all computer programmers increased dramatically. holding all else equal, what effect did this process have on the labor market for computer programmers? the equilibrium wagea. increased, and the equilibrium quantity of labor decreased. b. decreased, and the equilibrium quantity of labor increased. c. increased, and the equilibrium quantity of labor increased. d. decreased, and the equilibrium quantity of labor decreased.

Answers: 3

continue

Business, 23.06.2019 00:00, Brandon4188

Which example would the government consider as intellectual property? a. product design that contains a hologram of the logo of the company b. a copy of a famous artist’s painting in a new medium c. a plant species discovered in the united states for the first time d. a method of production that is common to an entire industry e. a discount structure offered to the customer at a store

Answers: 3

continue

You know the right answer?

Computing Bond Issue Price and Preparing an Amortization Table in Excel On December 31, 2015, Kapl...