Use Excel

a.Se buys a team for experimentation and research for $100,000. The equipment will depreciate using MACRS. ? In which category of the "MACRS GDS property class" is this asset classified? b.? How much is the depreciation deduction of the first year? C. CALCULATEs the taxable income for the first year, if the company generated in income $ 400,000 for the concept of the equipment. The company has ordinary expenses of $10,000 and depreciation expenses as calculated in part b. d. how much is the combined federal and state tax for a state where the state tax is 8%. e. CALCULATES how much the company has to pay in combined federal and state taxes at the end of the first year. The state incremental tax is 8%. f.CALCULATES how much is the surplus income of the first year, after paying taxes (after tax income). Fill the whites: a.Property class: b. The depreciation deduction is: $ c. Taxable income = $ .d. Combined Federal and State Tax % (to two decimal places). and. Taxes payable = $ = .f. Income after tax = $ =