Set up the following spreadsheet to reflect the two


Crist Company operates a lawn mowing service. Crist has chosen to depreciate its equipment for financial statement purposes using the straight line method. However, to save cash in the short run, Crist has elected to use the MACRS method for income tax reporting purposes.

Required: 

a. Set up the following spreadsheet to reflect the two different methods of reporting. Notice that the first two years of revenues and operating expenses are provided.

 b. Enter the effects of the following items for 2013.

(1) At the beginning of 2013, Crist purchased for $10,000 cash a lawn mower it expects to use for five years. Salvage value is estimated to be $2,000. As stated, Crist uses the straight line method of depreciation for financial statement purposes and the MACRS method for income tax purposes. Use formulas to calculate depreciation expense for each method. 

(2) No equipment was sold during 2013; therefore, no gain or loss would be reported this year. 

(3) The income tax rate is 30 percent. For simplicity, assume that the income tax payable was paid in 2013. 

(4) Complete the schedules for income reporting, reporting of equipment, and reporting of cash flows for 2013. Use formulas for all calculations. 

c. Enter the effects of the following items for 2014.

(1) Crist used the mower for the entire 2014 year. Enter 2014 depreciation expense amounts for the income reporting section of your spreadsheet. 

(2) At December 31, Crist sold the lawn mower for $7,000. Calculate the gain or loss on the sale for the income reporting section. Use formulas to make the calculations. 

(3) The income tax rate is 30 percent. For simplicity, assume that the income tax payable was paid in 2014. 

(4) Complete the schedules for income reporting and reporting of cash flows for 2014.

d. Calculate the Total columns for the income reporting and reporting of cash flows sections. 

e. Respond to the following.

(1) In 2013, by adopting the MACRS method of depreciation for tax purposes instead of the straight line method, what is the difference in the amount of cash paid for income taxes? 

(2) In the long term, after equipment has been disposed of, is there any difference in total income under the two methods?

 

2341_264-B-A-I-A (3530).png

n (3) In the long term, after equipment has been disposed of, is there any difference between total income tax expense and total income tax paid? 
(4) Explain why Crist Company would use two different depreciation methods, particularly the straight line method for the financial statements and an accelerated method (MACRS) for reporting to the IRS.

Solution Preview :

Prepared by a verified Expert
Accounting Basics: Set up the following spreadsheet to reflect the two
Reference No:- TGS01234692

Now Priced at $15 (50% Discount)

Recommended (90%)

Rated (4.3/5)