Answered step by step
Verified Expert Solution
Question
1 Approved Answer
i need help with questions 1-3 on a spreadsheet. i did also take a picture of the secone page showing how to do it incase
i need help with questions 1-3 on a spreadsheet.
Net Present Value and Internal Rate of Return P 12 - B Clean-It Up Company has decided to bid on the right to provide auto emissions testing for the State of Arizona. A study has been made and the following cash receipts and payments have been identified over the life of the ten year contract. When the contract ends, the working capital will be released for use elsewhere. Required (using an electronic spreadsheet): 1) Using a required rate of return of 14%, determine the net present value. 2) Using a required rate of return of 10%, determine the net present value. 3) Determine the internal rate of return, calculated to two decimal places (see next page). 1) Position your cursor in the cell where you wish to display the result. 2) Point and click the Insert Function button. 3) Choose the Financial Category and IRR. Function as illustrated below: 4) Point and click the [ OK ] button. 5) If the IRR box is covering any part of the values to be used, move it to another part of the screen. This can be accomplished by holding the left mouse button down while moving to an open area of the screen. 6) Highlight the range of cells to be used in the calculation and click the [ OK ] button. The IRR will display. Please adjust precision as needed using the Increase or Decrease Decimal buttons. For practice, try to replicate the following i did also take a picture of the secone page showing how to do it incase you get lost which in my case i got lost and dont know what to do please help
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started