In the file named NPV.xlsx in Chapter 8, The net present value functions NPV and XNPV, we
Question:
In the file named NPV.xlsx in Chapter 8, “The net present value functions NPV and XNPV,” we found that for high interest rates, Project 1 has a larger NPV, and for low interest rates, Project 2 has a larger NPV. For what interest rate would the two projects have the same NPV?
Transcribed Image Text:
1 123 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 A r NPV Time 277.7778 Inv 1 CF -27.7778 Inv 2 CF PV Inv 1 PV Inv 2 B PV beginning of Year Inv 1 Inv 2 PV End of Year Inv 1 Inv 2 PV Middle of year Inv 1 Inv 2 C 0.2 0 D 1 -10000 24000 -6000 8000 -10000 20000 -9722.22 -6000 6666.667 -694.444 $277.78 $277.78 ($27.78) ($27.78) $231.48 ($23.15) $253.58 ($25.36) E 2 Total of F -14000 -1000 0 1000
Fantastic news! We've Found the answer you've been seeking!
Step by Step Answer:
Answer rating: 71% (7 reviews)
To determine the interest rate at which the two projects have the same NPV we need to find the r...View the full answer
Answered By
Churchil Mino
I have been a tutor for 2 years and have experience working with students of all ages and abilities. I am comfortable working with students one-on-one or in small groups, and am able to adapt my teaching style to meet the needs of each individual. I am patient and supportive, and my goal is to help my students succeed.
I have a strong background in math and science, and have tutored students in these subjects at all levels, from elementary school to college. I have also helped students prepare for standardized tests such as the SAT and ACT. In addition to academic tutoring, I have also worked as a swim coach and a camp counselor, and have experience working with children with special needs.
0.00
0 Reviews
10+ Question Solved
Related Book For
Microsoft Excel Data Analysis And Business Modeling
ISBN: 9780137613663
7th Edition
Authors: Wayne Winston
Question Posted:
Students also viewed these Business questions
-
Managing Scope Changes Case Study Scope changes on a project can occur regardless of how well the project is planned or executed. Scope changes can be the result of something that was omitted during...
-
Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...
-
Read the case study "Southwest Airlines," found in Part 2 of your textbook. Review the "Guide to Case Analysis" found on pp. CA1 - CA11 of your textbook. (This guide follows the last case in the...
-
Mr. Ajay's trial balance is as follows. Trial Balance for the year ended 31st March, 2017 Amt Debit Balances To Opening Stock To Purchases To Wages To Investment To Carriage outwards To Printing and...
-
MULTIPLE-CHOICE QUESTIONS 1. Which of the following procedures would an auditor typically perform first when assessing the reasonableness of management's estimate of its pension liability? a. Inspect...
-
Reread the Management Focus on Walmart's International Division and answer the following questions: a. Why did the centralization of decisions at the headquarters of Walmart's international division...
-
Assuming the same data as given in problem 9, was the well in each case profitable? Discuss your answer. Problem 9:- Property cost (acquisition cost). Drilling cost (one well). Estimated completion...
-
Tuscany Statuary manufactures bust statues of famous historical figures. All statues are the same size. Each unit requires the same amount of resources. The following information is from the static...
-
3. A 200 kg roller coaster starts from rest at the top of the first hill at a height of 20 m above the ground. The second hill is 15 m above the ground. a. A physics student in line for the ride...
-
You are employed by McDowell and Partners, Chartered Accountants (M&P). A new client, Community Finance Corporation (CFC), approached M&P for assistance. Enviro Ltd. (Enviro) has asked CFC for a loan...
-
The file named Lookupdata.xlsx contains product codes and prices. Set up the worksheet so that when a product code is entered, your worksheet will return the product price. Of course, when new...
-
The file named Singers.xlsx contains a list of songs sung by different singers, as well as the length (in estimated minutes) of each song. Set up your worksheet to compute the total number of songs...
-
At each point evaluate the function or indicate that the function is undefined there. g(x, y) = y x - y (1,3), (3,-3), (2,2)
-
Outline the decision process for making location decisions.
-
Describe scheduling needs in high-volume systems.
-
Discuss key considerations related to global location decisions.
-
Discuss the options available for location decisions.
-
Compare product and service scheduling hierarchies.
-
Fine Leather Ltd. had the following inventory at December 31, 2014: Required: 1. Determine the value of ending inventory that should be reported on the statement of financial position by applying the...
-
You are the newly appointed tax practitioner to complete Emilys tax return and have downloaded the prefill report for Emilys tax return (hint, you can read what a prefill report is here (Links to an...
-
Should all companies use Facebook and Twitter for customer service and marketing? Why or why not? What kinds of companies are best suited to use these platforms?
-
Analyze Instacart using the value chain and competitive forces models. What competitive forces does the company have to deal with? What is its value proposition?
-
Explain how Instacarts business model works. How does the company generate revenue?
-
Elgin Fruit Juice is being investigated as the source of SA's apple juice recalls Elgin Fruit Juice (PTY) LTD is being investigated as the source of the recent apple juice recalls. The company, based...
-
should be able to evaluate the key macroeconomic indicators data of a country and determine the best fiscal and monetary policies for managing growth, inflation and unemployment, while formulating...
-
The chief legal officer (CLO) of Amazon, Inc. is impressed with your knowledge of global economics and has asked you to gather data on institutions governing trade and the types of trade...
Study smarter with the SolutionInn App