A currently owned machine was purchased 12 years ago for $80,000 with an estimated life of 15 years and $5,000 salvage. SL depr has been used. This machine produces parts at the rate of 3.55 hours per 100 parts, and has an efficiency rating of 80%. The machine requires 3 operators paid a wage rate of $14.56 per hour. The machine is run on one shift only, with overtime scheduled as necessary. Demand for these parts averages 51,000 parts per year. Overtime pay is 50% greater than the base rate. Labor costs are increasing at 4.7% per year. The parts sold last year for $2.49 per part. Material last year was $0.15 per part and is increasing at the same rate as labor costs. Future price increases are expected to average 6.1% per year. Maintenance last year was $4500. The machine can be kept running but maintenance will increase by 11% per year. The current market value for this machine is $35,000. The tax rate is 40%. a. How much will be realized for this machine after taxes if it were to be sold today? b. Complete the following table. Assume the machine is sold in 3 years for $1000. yr Rev Labor_Maint BTCF Depr Tax Inc Tax ATCF Nom Real 0 13 14 15 c. Calculate the inflation adjusted rate of return (10) if this machine is kept and then sold at the end of year 15 (three years from now). Inflation is expected to be 3.2, 4.7, and 3.6% for the next 3 years. d. Repeat a-c using SOYD depreciation. e. Repeat a-c using SL depreciation assuming that 25% of the first cost was borrowed at 7.75% per year, repaid using the standard repayment schedule. Redo the table as required. A currently owned machine was purchased 12 years ago for $80,000 with an estimated life of 15 years and $5,000 salvage. SL depr has been used. This machine produces parts at the rate of 3.55 hours per 100 parts, and has an efficiency rating of 80%. The machine requires 3 operators paid a wage rate of $14.56 per hour. The machine is run on one shift only, with overtime scheduled as necessary. Demand for these parts averages 51,000 parts per year. Overtime pay is 50% greater than the base rate. Labor costs are increasing at 4.7% per year. The parts sold last year for $2.49 per part. Material last year was $0.15 per part and is increasing at the same rate as labor costs. Future price increases are expected to average 6.1% per year. Maintenance last year was $4500. The machine can be kept running but maintenance will increase by 11% per year. The current market value for this machine is $35,000. The tax rate is 40%. a. How much will be realized for this machine after taxes if it were to be sold today? b. Complete the following table. Assume the machine is sold in 3 years for $1000. yr Rev Labor_Maint BTCF Depr Tax Inc Tax ATCF Nom Real 0 13 14 15 c. Calculate the inflation adjusted rate of return (10) if this machine is kept and then sold at the end of year 15 (three years from now). Inflation is expected to be 3.2, 4.7, and 3.6% for the next 3 years. d. Repeat a-c using SOYD depreciation. e. Repeat a-c using SL depreciation assuming that 25% of the first cost was borrowed at 7.75% per year, repaid using the standard repayment schedule. Redo the table as required