question no 43520

THIS MUST BE DONE USING THE FDRMULAS SUGGESTED EELDW, AND DNA SPREADSHEE'I', WITH ND EITHER ADVANCED FDRMULAS PLEASE. Allied Electrons mustpurchase a new automatic soldering machine to meet increased demand for its electronic goods. t all the machines considered, management has narrowed the choices to the following three mutually exclusive machines. Allied uses a planning horizon of four years [all three can last this long] and a MARK of 10 96. The initial cost is in week 0 and the payments are in years 14. Determine the present worth, future worth, and annual worth for a] 331mg the salvage value is in year 4, and h] when the salvage value is in year 5. Machinel Machine 2 Machine 3 InitiEIICDSt $300,000 $550,0UU $536,000 Annualperatingost $50,000 $90,000 $105,000 I Salvage 1uralue $40,000 $32,500 $23,?50 Hint A cash ow table for part a machine 1 could he stated as follows where costs are negative or where costs are positive. Here they are shown as negative. End of Year Costs 0 1 2 3 1- {$300,000.00} {550,000.00} {550,000.00} {$50,000.00} {$10,000.00} The clearest approach is probably nding the NPV of this. Assuming the monetary values are in cells A3 through E3 =ISHL109632E3J + A3 = 303LIFE-F3 \f\f