Case Study of Lyons Document Storage Corporation

grounds study of Lyons Document Storage Corporation stay Accounting gateway The Lyons Company is modernly a company providing storage of documents for other merged customers. Lyons had operated conservatively without any long-term debt until it issued bonds in 1999. The bounds issued were $10 one thousand thousand in 20-year bonds, offering a coupon rate of 8% with pursuance paid semiannually, and s one-time(a) to yield the 9% market rate of worry at the time. In the following essay, we take it as pick 1. These bonds were issued on July 2, 1999 and would be due July 2, 2019. But now, the investment bankers told the companys owner, Mr.Lyons, that $10 jillion in new 6% bonds with semiannual liaison right offments could be issued to provide the company with exactly $10 one one thousand meg million in champion at the end of 10 years. The new evoke stipends would be $200,000 slight each year than old bonds, which still had 12 years forrader they would be paid off. We t ake issuing these new bonds as Alternative 2. If it is selected, 11542K/1K=11542 new bonds provide Lyons throw away to issue to refund the old bonds. at that place is as well a third utility(a) Issuing $11. 54 million of 10-year 6% bonds to completely pay-off the existing bonds with no pauperism for additional coin from the company.Now, we are facing the problem that if Lyons should issue one of the new bonds with dispirit chase rate or keep the existing bonds. One ideal more or less Bond First I want to talk about the terms of premium and cut. Usually in that respect entrust be difference between the eccentric value of the bond and the actual occur of funds that the borrower receives when the bond is originally issued. This difference is called premium or discount. If the fare received is larger than the face value, it is called premium. If it is smaller than the face value, it is called discount. With this definition, we come to account exactly how much the comp any eceived from its 8% bonds amount received by the borrower. The value, VN, is given by the following compare. VN=rZ(P/A,i%,N)+C(P/F,i%,N) Where VN bond value or equalizer sheet financial obligation with N remaining periods r bond interest rate Z bond face value i predominate yield at time of issued C redemption value at maturity For the old bonds, r=8% with semiannual payments, i=9%, Z=C=$10 million, N=40(one period is half a year). VN=0. 04*10(P/A, 4. 5%, 40)+10(P/F, 4. 5%, 40)= 9. 08 million. Thus, the company actually received $9. 08 million from the old bond, which is less than the face value $10 million. This is a discount bond.We put up also using this equation to recalculate the amount shown in the dimension sheet at December 31, 2006 VN=0. 04*10(P/A, 4. 5%, 25)+10(P/F, 4. 5%, 25)= 9. 26 million (number of remaining half-year period=25) At December 31, 2007 VN=0. 04*10(P/A, 4. 5%, 23)+10(P/F, 4. 5%, 23)= 9. 29 million The current market value of the bonds outstandin g at the current interest rate of 6% equals to the actual amount of money the borrower will receive at that time. We croup also delectation the above equation to do the calculation. This time r=6% with semiannual payments, i=6%, Z=C=$10 million, remaining number of period=21.VN=0. 03*10(P/A, 3%, 21)+10(P/F, 3%, 21)=$11. 54million Comparison between one-third Alternatives We offer compare these three alternatives based on two aspects change moves and book earnings. First, lets compare the bullion give ear. Here we use the derivative instrument PW method and commemorate alternative 1 as the base. For Alternative 2, there is $1. 54 million cash out advert in Jan. 2009, since $11. 54 million is paid to draw back the old bonds. In the following years, alternative 2 will pay $100K less than alternative 1 semiannually, till July. 2019. But for alternative 3, as the new bonds face value is $11. 4 million, we do not have to pay the $1. 54 million in Jan. 2009. And the differentia l coefficient annual cash flow is $53. 8K, which is $11. 54 million clock 3% interest rate. Be emplacements, we need to pay $1. 54 million more when it comes to maturity. This is because the redemption value equals to the face value, $11. 54million. The differential cash flow is listed in Exhibit 1. With the cash flow of all period, we can calculate the differential accumulative PW. The differential cumulative PW for alternative 2 PW2=-1542K+100K(P/A,3%,21)=-$0. 5K. The differential PW for alternative 3 PW3=53. 8K(P/A,3%,21)-1542K(P/F,3%,21)=$0. K. The negative differential PW for alternative 2 means the company will eventually pay more money compared to alternative 1. The positive differential PW for alternative 3 means it will eventually receive more money. From the cash flow perspective, it seems the company may issue the $11. 54 million of 10-year 6% bonds. another(prenominal) aspect is book earnings. Earnings will be affected by (i) the $2. 2 million loss on refunding in 2009 , (ii) differential interest payments in every period, and (iii) differential amortized discount disbursement in every period. The $2. 2 million is from $11. 4 million spent to retire bonds negatively charged the $9. 3 million listed on the balance sheet at that time. The differential interest payments are the same as those in the cash flow perspective. The amortized discount of alternative 2 and 3 is zero for each period. This is because the interest expense is $10 million*3%=$300K semiannually. The actual payment is also $300K semiannually. There is no difference between these two values. Therefore, the old amortized discount equals to the differential amortized discount. Old Amortized Discount=Interest Expense-Payment. (See Exhibit 2) For alternative 1, loaf-go we use $9079. K, which is calculated in One Concept about Bond, as the liability at the beginning of the first period. The interest expense of every period equals to the liability at the beginning of that period times the interest rate. Liability at the end of the period before payment (column D) equals to column B plus column C. Finally, after deducting $400k from column D, we welcome the liability at the end of the period, which is $9088. 5K. Use this value as the liability at the beginning of period 2 and repeat the calculation above, we can finish the left side part Exhibit 2. This table shows how the liability increases with each period.At the end of the 20 years it is exactly equal to $10 million face value. To compare the differential book earnings for alternative 2 and 3, we just add an extra part to the left side of the original table. There will be a $2. 2 million loss in the first period, and differential interest payments and amortized discount in the following periods. We add up these 3 differential values and get the New Earnings Effects. (See Exhibit 2 and 3) Conclusion From the book earning perspective, we can see that if the company issue any kind of new bond, there will be incr eases in future years earnings and a loss in current years earnings.The loss will make Mr. Lyons unhappy. As a matter of fact, this perspective just gives us an implication of the companys financial status. It is more reasonable to use cash flow to compare these 3 alternatives, since it takes the time value into consideration. From the cash flow perspective, since PW3 0 only PW2 0, which means Alternative 3 in the long run makes us pay less money than Alternative 1 but Alternative 2 finally makes us pay more money than Alternative 1. Thus we should choose Alternative 3.