Question

Some proffesional from here request more information but below is all I have, There is something missing? if not please help me here

Objective: This activity has the purpose of helping students compute an equivalent annual worth quantity using the software Microsoft Excel. Also to perform a sensitivity analysis. (Objective 7) Student Instructions: Read example to be used to compute an equivalent annual worth cash flow. Example Equivalent Annual Worth with different lives: A mechanical engineer is considering two types of pressure sensors for a low pressure steam line. The costs are shown below. Which should be selected based on an annual worth comparison at an interest rate of 10% per year? Type $8,650.00 $13,900.00 First cost, $ Maintenance cost $/year Salvage value Life, years $2,200.00 $1,900.00 $0.00 $3,000.00 7 1. Have available the Microsoft Excel software program. 2. Construct a table in the Microsoft Excel work sheet as shown below. The instructions are shown in the second table, A B C D 57 0.1 Rate Type A -8650 Type B - 13900 When finished, make sure to click Submit. Antionally click Save an Draft to save changes and continue working later, or click Cancel to quit without saving changes. Cancel

Answer 1

As per my knowledge
first question
!) when the cell change from 10% to 5%
1)TRUE
2) when the cell change from 10% to 15%
2)False
3) when the cell change from 15% to 5%
3) TRUE
4) when the D cell change from 10% to 15%
4)TRUE
5) Rate of Return
5)TRUE