Tilman Company is required by a bond indenture to make equal annual payments to
ID: 2358664 • Letter: T
Question
Tilman Company is required by a bond indenture to make equal annual payments to a bond sinking fund at the end of each of the next 20 years. The sinking fund will earn 8 percent interest and must accumulate to a total of $500,000 at the end of the 20-year period. Use Table FA-2 (in Exhibit B-4) Calculate the amount of the annual payments. (Round your FV factor to 3 decimal places and final answer to the nearest dollar amount. Omit the "S" sign in your response.) Calculate the total amount of interest that will be earned by the fund over the 20-year period. (Round your FV factor to 3 decimal places. Do not round your intermediate calculations and round your final answer to the nearest dollar amount. Omit the "$" sign in your response.) Make the general journal entry to record redemption of the bond issue at the end of the 20-year period, assuming that the sinking fund is recorded on Tilman's accounting records at $500,000 and bonds payable are recorded at the same amount. (Omit the "$" sign in your response.) What would be the effect of an increase in the rate of return on the required annual payment? Reduces the amount of payment required by Tilman. Increases the amount of payment required by Tilman. No effect.Explanation / Answer
a. We have Amt reqd = FV = 500,000 Period = nper = 20 Rate =8% So Annula pyament reqd = PMT(Rate,nper,PV,FV) = PMT(8%,20,0,500000) = $10,926 b. CUMIPMT excel function Returns the cumulative interest paid on a loan between start_period and end_period. (Analysis ToolPak) It is CUMIPMT(Rate,nper,PV,start_period,end_period,type) Total Int =CUMIPMT(8%,20,500000,1,20,0)= $518,522 c. Bond Acct Dr 500,000 Sinking Fund Cr 500,000 d. Reduces the amt of payment reqd by Tilman