ACCTG 101 Lecture Notes - Lecture 12: Income Statement, Issued Shares, Effective Interest Rate
Document Summary
Get access
Related Documents
Related Questions
Can you please help solve the formula portions and show theformulas used?
PROBLEM DATA
The University Club recently issued $1,500,000 of 10-year, 9%bonds at an effective interest rate of 10%. Bond interest ispayable annually.
REQUIREMENTS
1. You have been asked to calculate the issuance price of thebonds and prepare amortization schedules for any discount orpremium. The worksheet BONDS has been provided to assist you. Notethat the worksheet contains a scratch pad at the bottom that hasbeen preprogrammed to automatically compute and display therelevant cash flows needed for bond pricing.
2. The bond pricing formula will utilize the NPV (Net PresentValue) function on your spreadsheet program. The NPV function willautomatically compute the net present value of annual future cashflows discounted at a specific interest rate. The interest rateshould be expressed as a cell address.
BONDS | |||||
Bond Pricing andAmortization | |||||
Data Section | |||||
Face value of bond | $1,500,000 | ||||
Years to maturity * | 10 | ||||
Stated interest rate | 9.0% | ||||
Effective interest rate | 10.0% | ||||
* Worksheet is designed for use with bonds having amaturity of | |||||
12 years or less and paying interestannually. | |||||
Answer Section | |||||
Bond issue price | FORMULA1 | ||||
Amortization Schedule -Straight Line Method | |||||
Cash | Interest | (Disc.) | Bond | ||
Year | Paid | Amortization | Expense | Premium | Carrying Value |
0 | FORMULA2 | FORMULA3 | |||
1 | FORMULA4 | FORMULA5 | FORMULA6 | FORMULA7 | FORMULA8 |
2 | FORMULA9 | FORMULA10 | FORMULA11 | FORMULA12 | FORMULA13 |
3 | 0 | 0 | 0 | 0 | 0 |
4 | 0 | 0 | 0 | 0 | 0 |
5 | 0 | 0 | 0 | 0 | 0 |
6 | 0 | 0 | 0 | 0 | 0 |
7 | 0 | 0 | 0 | 0 | 0 |
8 | 0 | 0 | 0 | 0 | 0 |
9 | 0 | 0 | 0 | 0 | 0 |
10 | 0 | 0 | 0 | 0 | 0 |
11 | 0 | 0 | 0 | 0 | 0 |
12 | 0 | 0 | 0 | 0 | 0 |
Amortization Schedule -Effective Interest Method | |||||
Interest | Cash | (Disc.) | Bond | ||
Year | Expense | Paid | Amortization | Premium | Carrying Value |
0 | FORMULA14 | FORMULA15 | |||
1 | FORMULA16 | FORMULA17 | FORMULA18 | FORMULA19 | FORMULA20 |
2 | FORMULA21 | FORMULA22 | FORMULA23 | FORMULA24 | FORMULA25 |
3 | 0 | 0 | 0 | 0 | 0 |
4 | 0 | 0 | 0 | 0 | 0 |
5 | 0 | 0 | 0 | 0 | 0 |
6 | 0 | 0 | 0 | 0 | 0 |
7 | 0 | 0 | 0 | 0 | 0 |
8 | 0 | 0 | 0 | 0 | 0 |
9 | 0 | 0 | 0 | 0 | 0 |
10 | 0 | 0 | 0 | 0 | 0 |
11 | 0 | 0 | 0 | 0 | 0 |
12 | 0 | 0 | 0 | 0 | 0 |
Scratch Pad | |||||
Display of relevant cash flows | |||||
Annual | Bond | ||||
Year | Interest | Maturity | |||
1 | 135000 | 0 | |||
2 | 135000 | 0 | |||
3 | 135000 | 0 | |||
4 | 135000 | 0 | |||
5 | 135000 | 0 | |||
6 | 135000 | 0 | |||
7 | 135000 | 0 | |||
8 | 135000 | 0 | |||
9 | 135000 | 0 | |||
10 | 135000 | 1500000 | |||
11 | 0 | 0 | |||
12 | 0 | 0 | |||
On January 1, Year 1, DPH, Co. issued a $3,500,000, 5 year bond.Interest will be paid on June 30 and December 31 each year. Thebond has a stated rate of 5% and was issued at 98. Ignore theeffects of taxes for this problem.
31. | (6 points) Make the journal entry for the issuance of thebond. |
32. | (16 points) Make the journal entries for the first two interestpayments, assuming that DPH uses the effective interestmethod for amortizing any premiums or discounts on theirdebt. The effect interest rate on the bonds was 5.5% |
33. | (15 points) On July 1, Year 4, DPH decided to retire 10% of thebonds in order to avoid violating a debt covenant on their majorline of credit. On that day, the bonds were selling at 101. Makethe journal entry to record the early retirement, assumingthat DPH, Co. uses the straight-line method for amortizingany premiums or discounts on their debt. |
34. | (22 points) On August 31st, Year 4, the bonds were selling at97. Because of the good price, DPH decided to retire an additional30% of the bond. Make any necessary journal entries to record therepurchase. Assume that the market price includes anyaccrued interest and that DPH is still using the straight-linemethod. |
35. | (16 points) Before recording the bond retirements, DPH reportedthe following information:
Calculate the company's ROA, Debt-to-Equity, and Current Ratiosbefore and after the debt retirement. Assume all other necessaryentries, including any interest on the bonds, have been properlyrecorded. (HINT: Since you don't have beginning values, just usethe ending values for those ratios requiring averages!) |
Use the following to answer questions 36-41:
At the end of last year, Tull Co. submitted paperwork to switchfrom a sole proprietor ship to a corporation. Just prior to yearend, the company received final authorization from the state ofIdaho to incorporate. In the articles of incorporation, Tull, Inc.is authorized to issues 1,000,000 shares of $2 par common stock. OnDecember 31st, Mrs. Tull received 250,000 shares of common stock inexchange for her equity in the sole proprietorship.
36. | (3 points) Make the journal entry to record Tull's first equityoffering on January 15th of the current year. The company issued150,000 shares at par value. |
37. | (5 points) Make the journal entry to record an additional equityoffering on June 1st. The company issued 60,000 shares for $8 pershare. |
38. | (3 points) On August 15th, Tull decided to repurchase 15,000shares of common stock in order to improve stock price. Make theappropriate journal entry to record the repurchase if the marketprice for Tull common stock on that day was $6 per share. |
39. | (6 points) On November 11th, Tull's management decided that thestock price had increased sufficiently for them to reissue 7,500shares of their treasury stock. Make the entry to record thereissue of these shares if the stock price was $17 per share. |