After graduating Tennessee Tech with a major in finance, you have developed a brilliant new widget. You sell your widgets for $6. You need to buy a machine to produce your widgets. You are considering two machines: (3.25 points) Machine A: Cost $2,000,000 Annual fixed cost per machine: $250,000; Variable cost per unit $1.40 Annual production capacity: 300,000 widgets (i.e., you cannot produce more than 300,000 widgets) Market life = 5 years; terminal value =0 Machine B: Cost $6,000,000 Annual fixed cost per machine: $25,000; Variable cost per unit $0.40 Annual production capacity: 600,000 widgets Market life = 5 years; terminal value = $200,000 Additional Details: You have already had an inspector evaluate Machine A for $2,000 and Machine B for $6,000. Both machines can be depreciated using straight-line depreciation over a 5-year period. Book value should =0 at the end of 5 years. The tax rate is 30% ANSWER MUST BE IN EXCEL