Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

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

image text in transcribed

image text in transcribed

image text in transcribed

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 Rate 0.1 Type A Year -8650 INGAWN -2200 -2200 -2200 -2200 -2200 Type B - 13900 - 1900 -1900 -1900 -1900 -1900 -1900 -1900 3000 1. The construction of the Microsoft Excel sheets and the answered questions has a total grading value of ten (10) points. 2. The deadline for hand in this exercise is indicated at the end of the week of the fourth module. Steps: 1. Start the Microsoft Excel software program. 2. Use the example data to complete the assignment. Notes: 1. Enter the information exactly as below. When finished, make sure to click Submit. al fou arratio se changes and continue working later, or click Cancel to quit without saving changes. Cancel 1. Enter the information exactly as below. 0.1 - 15900 - 1900 -1900 - 1900 Type A -8650 -2200 -2200 -2200 -2200 -2200 1900 USE YOU NOWN EPMT(C3,5,CS)+2200 EPMT(C3,7,D5)+1900+PMT(C3,7,0,013) (do not forget to write the = sign) To format columns with numbers: right click the mouse in the cell you which to modify, select format cell, and number The equal() sign means that you have an equation and it will compute automatically what is indicated in the cell. a. Write and answer the following questions using the Microsoft Excel spreadsheet. You may copy the questions and write the answer below the table in the Excel sheet. b. Once you have built the Excel tables, with all the changes in different tables, and answered all the questions you have to send the work (Excel sheets and answered questions) to the professor using the Attach File function in Black Board to attach your document and send it to the professor. To use the Attach File enter the Course Content in Black Board. Select the Assignment Module 6, attach the file and submit. Questions (You only have to write in Excel one of the answers, the one you think is the correct answer to the question) When finished, make sure to click Submit. intinnallu click on an Draft to save changes and continue working later, or click Cancel to quit without saving changes Cancel b. Once you have built the Excel tables, with all the changes in different tables, and answered all the questions you have to send the work (Excel sheets and answered questions) to the professor using the Attach File function in Black Board to attach your document and send it to the professor. To use the Attach File enter the Course Content in Black Board. Select the Assignment Module 6, attach the file and submit. Questions (You only have to write in Excel one of the answers, the one you think is the correct answer to the question) 1. When in cell C3 the interest rate is change from 10% to 5% the annual worth of Type A alternative Type A is $4,197.93. a. True b. False 2. When in cell C3 the interest rate is change from 10% to 15% the annual worth of Type A alternative is $4,780.43 a. True b. False 3. When in cell C3 the interest rate is changed to 15% to 5% the present worth of this alternative is $4, 824.10. a. True b. False 4. When in cell D1 the interest rate is changed to 10% to 5% the present worth of Type B alternative is -$3,933.74 a True b. False 5. In this problem when you raise the rate of return (i), the higher the annual worth quantity? a. True b. False

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Elements Of Chemical Reaction Engineering

Authors: H. Fogler

6th Edition

9780135486221

Students also viewed these Accounting questions