use excel to solve 11.02-PR002 You have been asked to perform a sensitivity analysis on a company's plan to modemize its facilities to determine the impact of possible errors in estimating the net annual savings. The initial investment in the modemnization is $30,000. The expected net annual savings are $13,000. The salvage value is $7,000 after a planning horizon of 7 years. MARR is 12% per year. Determine if the modernization is economically attractive based on the initial estimates and an annual worth (AW) analysis. Determine the AW if the net annual savings change by the following percentages from the initial estimate: -80%, -60%, -40%, -20 %, +20%, +40%. Determine the percentage change in net annual savings that causes a reversal in the decision regarding the attractiveness of the project.

A manager is considering installation of one of the following two machines in his factory 24 Panther $30,000 Cheeler More Info 1 $90,000 $20,000 $30,000 4 6 None None Initial Cost Annual Costs Service life (years) Salvage value Since the machines have different service lives, his economic analysis will assume repeatability and use an analysis period of 12 years. Given a MARR of 10% per year, calculate the following two parameters Click the icon to view the interest and annuity table for discrete compounding when /-10% per month. The EUAC of the Cheeter over the analysis period is (select the closest value) OA. $9,335 OB. $50,665 OC. $43,209 OD. $101,330 OE. $56,417 The PW of the Cheeter over the analysis period is (select the closest value). OA. $441,318 OB. $384,408 OC. $345,216 The of " wie OA BI O . Ос OR H " 0 0 " 15 ожи кли Derm TOW 5 6 B 9 0 T Y U 1 O P

please provide correct answer it would great help

How would I solve part A and B ? Thank you..

Determine the FW of the following engineering project when the MARR is 15% per year. Is the project acceptable? Proposal A Investment cost Expected life Market (salvage) value Annual receipts $11,000 5 years -$1,000 S7,000 $4,000 Annual expenses "A negative market value means that there is a net cost to dispose of an asset Click the icon to view the interest and annuity table for discrete compounding when the MARR is 15% per year The FW of the follawing engineering froject is $ (Round to the nearest dollar.)

Required information A process for producing the mosquito repellant Deet has an initial investment of $205,000 with annual costs of $53,000. Income is expected to be $90,000 per year. What is the payback period at /= 0% per year? At/ 12% per year? (Note: Round your answers to the nearest integer.) The payback period at / 0% is determined to be years. The payback period at i= 12% is determined to be years.

One of the mutually exclusive alternatives below must be selected. Base your recommendation on A(Sauer-Glock) cash flows when the MARR = 15% per year. EOY EOY P/5 10 20 10 20 2P 2P Glock 40 Sauer 45 ..... The IRR on A(Sauer-Glock) is %. (Round to two decimal places.)

A company predicts they will make $1,321 per year over the next 19 years if they spend $2,497 on a machine (an asset with multi-year use). If the MARR is 16.0%, how much is this investment worth per year?

Incorrect Question 8 When calculating the Break Even Analysis, one needs to subtract the FW of the cash inflows from the PW of the cash outflows. True False

Please handwriten solution