An engineer is evaluating the purchase of a machine at a cost of $25,000 for a construction project. investment in the company. This machine is depreciated by MACRS as a 7-year property. The Net benefits from this investment, before deducting depreciation, are $8,000 per year for 9 years. After 9 years the machine has no residual value, it is discarded and no value is obtained in the disposal of the asset. There is an annual inflation of 8% during those 9 years. The combined federal and state tax rate, for this company it is 28% 

RESOLVE IN EXCEL AND PRESENT THE RESULTS OF EACH PART IN CASH FLOW TABLES BY SEPARATE. DO NOT PRESENT SEVERAL RESULTS IN THE SAME TABLE. A. PREPARE A CONVERSION TABLE OF BEFORE TAX CASH FLOW IN REAL DOLLARS YEAR 0 TO BEFORE TAX CASH FLOW IN CURRENT DOLLARS. B. PREPARE A TABLE THAT INCLUDES ALL CALCULATIONS OF DEPRECIATION, INCOME TAXABLE AND TAX PAYMENTS BASED ON THE "BEFORE TAX CASH FLOW" IN DOLLARS CURRENT UNTIL THE "AFTER TAX CASH FLOW" IS ACHIEVED IN CURRENT DOLLARS. C. PREPARE A CONVERSION TABLE OF AFTER TAX CASH FLOW IN CURRENT DOLLARS A AFTER TAX CASH FLOW IN REAL DOLLARS. D. CALCULATE THE PRESENT VALUE OF THE AFTER TAX CASH FLOW IN REAL DOLLARS, USING THE MARR OF 10%. E. CALCULATE THE IRR OF THE AFTER TAX CASH FLOW IN REAL DOLLARS. F. IF THE COMPANY USES A MINIMUM ATTRACTIVE RATE OF RETURN (MARR) AFTER 10% TAXES, SHOULD THIS INVESTMENT BE CONSIDERED OR DISCARDED? EXPLAIN. G. IF INFLATION AND THE PAYMENT OF TAXES HAD NOT BEEN TAKEN INTO ACCOUNT, HOW MUCH IT WOULD HAVE BEEN THE RESULT OF THE INTERNAL RATE OF RETURN (IRR OF THE BEFORE TAX CASH ORIGINAL FLOW WITHOUT INFLATION AND WITHOUT TAXES). H. THE INTERNAL RATE OF RETURN OF THE BEFORE TAX CASH FLOW WITHOUT TAKING INTO ACCOUNT THE INFLATION, NOR TAXES, IS IT USEFUL FOR ECONOMIC ANALYSIS IN ENGINEERING? EXPLAIN WHY OR WHY NO.