Wise Company was started on January 1, 2013, when it issued 20-year, 10 percent, $200,000 face value bonds at a price of 90. Interest is payable annually at December 31 of each year. Wise immediately purchased land with the proceeds (cash received) from the bond issue. Wise leased the land for $27,000 cash per year. The lease revenue payments are due every December 31.

Required

Set up the following horizontal statements model on a blank spreadsheet. The SCF Activity column is for the classifications operating, financing, or investing.

a. Enter the effects of the 2013 transactions. Assume that both the interest and lease payments occurred on December 31. Notice that the entry for the lease has already been entered as an example. Calculate the ending balances.

b. Enter the effects of the 2014 transactions. Assume that both the interest and lease payments occurred on December 31. Calculate the ending balances.

c. Enter the effects of the 2015 transactions. Assume that both the interest and lease payments occurred on December 31. Calculate the ending balances.

d. On January 1, 2016, Wise Company sold the land for $190,000 cash. Immediately after the sale of the land, Wise repurchased its bond at a price of 93. Assume that no other accounting events occurred during 2016. Enter the effects of the 2016 transactions. Calculate the endingbalances.

SCF Bonds Bond Retained Effect on Pavable Discount Earnings Net Income Date 1-1-13 1-1-13 12-31-13 12-31-13 2013 Ending Activity Cash Land OA 27,000 27,000 Lease Revenue 27.000 Net Income Total Assets Total Claims 2014 Beginning 12-31-14 12-31-14 2014 Ending Net Income Total Assets Total Claims 2015 Beginning 12-31-15 12-31-15 2015 Ending Net Income Total Assets Total Claims 2016 Beginning 1-1-16 1-1-16 2016 Ending Net Income Total Assets Total Claims