Asume a pece of machinery Cots $420,000 and would yendo salvage value would be 594000 Annuo savings for the could be 80.000 minimum preto return of is required for machinery purchases como de the machinery Dgnore income) Provide the amounts you out in Excel rero 10). On the signs in your Excel input Mpe PMT 5 PV PV Net Present Value Required Provide the amounts you input in Excel and your composed in the comput to) Omit the and signe in your response) Round your answer to one decimal place and use info negative numbers Excel Input Niper PUT 51 PV 50 PV 51 Brittany's address s Are Chase Assume a plece of machinery costs $420,000 and would last for 8 years. At the end of 8 years, the salvage value would be $94.000. Annual cost savings for the machinery would be $82,000. Assume a minimum pretax retum of 14% is required for all machinery purchases. Compute the NPV and IRR for the machinery. (Ignore Income taxes.) Provide the amounts you input in Excel and your calculated net present value. (Ha variable is not used in the calculation, Input a zero (0). Omit the "S" and "%" signs in your response.) Round your answer to the nearest dollar and use a minus sign for negative numbers Excel input Rate Nper PMT PV FV Net Present Value (NPV) Required: Provide the amounts you input in Excel and your calculated internal rate of return. If a vario is not used in the calculation, Input a zero (O). Omit the "S" and "%" signs in your response.) Round your answer to one dhenal place and use a minus sign for negative numbers. Excel input Rate Nper PMT PV $ FV $ Internal Rate of Return (IRR) - W