HOW MUCHTO SPEND

1. A machine is needed to produce parts at the rate of 60 per hour. The operator to run the machine will be paid $11.47 per hour. The parts cost $.47 each and will be sold for $.93 each after this operation. This operation is expected to be needed for 7 years. SOYD depr will be used and 10% salvage is assumed. Assume that revenues, labor, and material costs flow uniformly and continuously throughout the year, and that the machine will run for 8 hours per day, 250 days per year.

If the tax rate is 47% and MARR is 20%, how much can be spent on this machine? Solve this using the AEC equation and then construct a spreadsheet and use solver to solve this problem.

Assume SL depreciation is used. Repeat part a.

Assume 5 yr MACRS is used. Repeat part a.

Assume the first cost is expensed and the salvage is income in year 7. Repeat part a.

Find how much can be spent with SL depr by varying the debt ratio from 0 to 1.0.

I need help with a detailed step by step solution please.