a) Develop tables using a spreadsheet to determine the ATCF (After Tax Cash Flow) for the 8 years of the AV’s considering all 30 AVs. Negative taxable income is treated a $0 taxable income. a. Using straight line depreciation (8 points) b. Using MACRS depreciation with the appropriate property class (8 points) b) If they keep all 30 vehicles for 8 years calculate the Present Worth (PW) and IRR of the investment of all 30 vehicles for each method using an after-tax MARR of 9%. (4 points)

Knight company reports the following costs and expenses in may. factory utilities $17,400 direct labor $70,300 depreciation on factory equipment 13,850 sales salaries 46,700 depreciation on delivery trucks 3,900 property taxes on factory building 3,100 indirect factory labor 53,700 repairs to office equipment 1,500 indirect materials 84,200 factory repairs 2,220 direct materials used 137,700 advertising 15,900 factory manager’s salary 8,700 office supplies used 2,770 from the information: your answer is incorrect. try again. determine the total amount of manufacturing overhead. manufacturing overhead $ 173050 link to text your answer is incorrect. try again. determine the total amount of product costs. product costs $ 208000 link to text your answer is incorrect. try again. determine the total amount of period costs. period costs $ 66870 click if you would like to show work for this question: open show work