Spreadsheet Assignment Using the information from the case bekow develop a Spreadsheet to find income tax expense and net THE CASE Quark Donut Company was incorporatod (as a C corporation) and startod business in 2007, make and sell donuts. Quark remted space in a local mall with a 8 year operating lease. Quark's only capital expenditure was the purchase in January of 2007 of equipment at a cost of $280,000. This equipment has an economic life of 8 years and 0 expectod salvage valuc. Quark uses straight line depreciation for computation of GAAP net income because this best reflects the true economic depecciation of the equipment. For income tax purposes Quark is permitted to use MACRS (the modified accelerated cost recovery system), and the equipment is considered to be in the 7 year class. Therefore the allowved MA0RStates are 14.29% the first year. 24Ay% the second year, 17.49% the third year, 12.499, the fourth year 8.93% the fifth year. 8.92% in the sixth 893%the seventh year and 446% tthc 8th year. Depreciation is the only non-cash cxpense, and is the only source of a difference betwon taxable income and financial accounting income before tax. Assume an income tax rate of 35% is enacted for the years 2007-2009. During the year 2010 a new income tax rate of 30% was enacted for 2010 to 2014. Projected revenues and opcrating expenses (excluding taxes and depreciation)ae as follows: Year Revenues Expenses $130,000 I80,000 $185,000 190,000 $100,000 110,000 $113,000 16,000 Year Revenues Expenses $195,000 $200,000 $200,000 200,000 $127,000 S132,000 $135,000 $138,000 . Use a spreadsheet to find: (note your spreadsheet is the answer to part a. income taxes paid that yancurment income tax payabc) b. deferred tax liability c. the change in deferred tax liability (equal to deferred income tax conse) d. totl income tax expense, II. Using the numbers from your sprcadsheet hand wrise the coroct joumal cnary o income taxes for the year 2010. 111. Find the effective tax rate for 2010 and explain why the enotns tax rate for 2010 is not 30% IV. Assuming the straight line method yields the true economie deprociation what is the advantages of being able to use MACRS for income tax determinations? Why are tax effects important in dociding whether this is a good investment? 2 012 23204