I need this to be completed using Excel. The solution must be made by using the classic Straight Line Method without assuming repeatability. Anual worth must be used to determine which is the best alternative. I would apprecieate if you list the formulas used in Excel. Thank you.

7-41. Two alternative machines will produce the same product, but one is capable of higher-quality work, which can be expected to return greater revenue. The following are relevant data: Machine A Machine B $30,000 8 years Capital investment Life Terminal BV (and MV) Annual receipts Annual expenses $20,000 12 years $4,000 $150,000 $138,000 $188,000 $170,000 7-41. Two alternative machines will produce the same product, but one is capable of higher-quality work, which can be expected to return greater revenue. The following are relevant data: Machine A Machine B $30,000 8 years Capital investment Life Terminal BV (and MV) Annual receipts Annual expenses $20,000 12 years $4,000 $150,000 $138,000 $188,000 $170,000