Show all your work in order to receive full credit. Circle your answers and use pencil to solve it. Excel files must be uploaded through the Blackboard exam assignment. Once you finish your exam take pictures of it and convert them into a pdf document so you can upload it through blackboard as well. 1. Use the cash flow given and a MARR =12% to find the following: ( 30 points) a) Determine the number of possible rate of return values in the net cash flow series using the two sign tests. b) Find the rate or rates of return values with excel using interest between 30 and 130% and plot your results. c) Determine the external rate of return, using the modified rate of return approach with an investment rate 5% and a borrowing rate of 7%. Solve the problem using excel. 2. Using the following information. Determine which should be selected base in its ROR using an Annual Worth analysis. The MARR =8%. Show a hand solution. ( 25 points) 3. The cash flows for two alternatives are shown. Determine which should be selected base in its ROR using a Present Worth analysis. The MARR =5%. Show a hand solution. ( 20 points) 4. A company is considering the projects shown below, all of which can be considered to last indefinitely. The company's MARR is 19% per year. What project should be selected? ( 25 points) Show all your work in order to receive full credit. Circle your answers and use pencil to solve it. Excel files must be uploaded through the Blackboard exam assignment. Once you finish your exam take pictures of it and convert them into a pdf document so you can upload it through blackboard as well. 1. Use the cash flow given and a MARR =12% to find the following: ( 30 points) a) Determine the number of possible rate of return values in the net cash flow series using the two sign tests. b) Find the rate or rates of return values with excel using interest between 30 and 130% and plot your results. c) Determine the external rate of return, using the modified rate of return approach with an investment rate 5% and a borrowing rate of 7%. Solve the problem using excel. 2. Using the following information. Determine which should be selected base in its ROR using an Annual Worth analysis. The MARR =8%. Show a hand solution. ( 25 points) 3. The cash flows for two alternatives are shown. Determine which should be selected base in its ROR using a Present Worth analysis. The MARR =5%. Show a hand solution. ( 20 points) 4. A company is considering the projects shown below, all of which can be considered to last indefinitely. The company's MARR is 19% per year. What project should be selected? ( 25 points)
