The spreadsheet fragment below shows a net present value and internal rate of return calculation for a
Question:
The spreadsheet fragment below shows a net present value and internal rate of return calculation for a project:
Use Data Table to do a sensitivity analysis on the NPV of the project, varying the discount rates from 0%, 3%, 6%, ?, 21% and varying the growth rates from 0%, 3%, ?, 12%.
D E NPV, DISCOUNT AND GROWTH RATES A В F G H 1 2 Growth rate 3 Discount rate 4 Cost 5 Year 1 cash flow 10% 15% 500 100 6 7 Year 8 Cash flow 1 2 3 4 -500.00 100.00 110.00 121.00 133.10 146.41 10 NPV 11 IRR (101.42) <-- =NPV(B3,C8:G8)+B8 6.60%|<-- =IRR(B8:G8) Cell B15 contains the data table 12 function =B10 13 Growth 14 15 16 ($101.42) 0% 3% 6% 9% 12% 0% 0.00 30.91 63.71 98.47 135.28 17 Discount rate 3% -42.03 -14.56 14.55 45.38 78.01 18 6% -78.76 -54.26 -28.30 -0.84 28.21 19 9% -111.03 -89.08 -65.85 -41.28 -15.33 20 12% -139.52 -119.78 -98.91 -76.86 -53.57 21 15% -164.78 -146.97 -128.15 -108.28 -87.32 22 18% -187.28 -171.15 -154.13 -136.16 -117.23 23 21% -207.40 -192.75 -177.30 -161.01 -143.84 24 24% -225.46 -212.11 -198.04 -183.22 -167.62
Step by Step Answer:
Related Video
The internal rate of return, or IRR, is a metric used to measure the profitability of an investment. It is the discount rate that makes the net present value of an investment equal to zero. To calculate the IRR, we need to know the investment\'s cash flows. These are the inflows and outflows of cash that will result from the investment. For example, an investment in a property might have cash outflows for the purchase price, closing costs, and any renovations, and cash inflows from rent and eventual sale of the property. The IRR is the discount rate at which the NPV of the investment is equal to zero. There are many ways to calculate IRR, from simple spreadsheet functions to more complex financial modeling software. It\'s worth noting that IRR can be a bit tricky when it comes to projects that don\'t have a consistent cash flow over time. These types of investments are known as \"irregular cash flow\" and the IRR might be misleading or not suitable to calculate. There are other metrics to evaluate these investments such as Modified Internal Rate of Return (MIRR) which is a variation of IRR and is used to get more accurate results.
Students also viewed these Business questions
-
Straightforward net present value and internal rate of return The City of Bedford is studying a 600-acre site on Route 356 for a new landfill. The startup cost has been calculated as follows:...
-
Using net present value and internal rate of return to evaluate investment opportunities Kerry Woods rich uncle gave him $60,000 cash as a gift for his 40th birthday. Unlike his spoiled cousins who...
-
Why are net present value and internal rate of return considered discounted cash flow methods?
-
Technology World tsad the following revenue and expenses during the month ended July 31, Fees for computer repairs Advertising expense Salaries expense Telephone expenses fees for printer repairs...
-
You are a British exporter who knows in December that you will receive SI5 million in three months (March). The current spot exchange rate is $1.5/, and the March forward exchange rate is also $1.5/....
-
Luzadis Company makes furniture using the latest automated technology. The company uses a job - order costing system and applies manufacturing overhead cost to products on the basis of machine -...
-
The optimum speeds (in kilometers per hour) for 30 hatchbacks Approximate the mean of the frequency distribution. Car Speeds (in kilometers per hour) Frequency 20-24 15 25-29 8. 30-34 4 35-39 3
-
Halsey, Inc., manufactures two types of baby car seats: standard and deluxe. Information for the year 2012 has been given as follows: Manufacturing overhead for the year totals $650,000. Halsey...
-
ABC; product profitability Outerwear Inc. is concerned about the profitability of its regular gloves. Company managers are considering producing only the top-quality, fleece lined, gloves. The...
-
A woman is telling about the time her coworkers waste when the supervisors are out at meetings all day. The worker responds, Why dont you say something? Read the questions that above and decide what...
-
The Excel function PV(rate, number_periods, payment) calculates the present value of a constant payment. For example in the spreadsheet example below, Use Data Table to graph the present value as a...
-
Use Excel to perform the following matrix operations: a. b. c. 2 61 [1 1 4 8 7 +8 0 -23 1 -9 1 7 3
-
A glider of mass 0.150 kg moves on a horizontal frictionless air track. It is permanently attached to one end of a mass less horizontal spring, which has a force constant of 10.0 N/m both for...
-
Continue with the case of Shiva Industries Ltd. as above. Required 1. Determine the rate of depreciation as per WDV. 2. Determine the annual depreciation and accumulated depreciation for all the...
-
Continue with the case of Maruti Suzuki Ltd. Also refer to the illustration of Grasim Industries Ltd. in this chapter. Carry out a comparative analysis of the two companies. Towards this purpose...
-
Continue with the case of Shiva Industries Ltd. as above. In the beginning of the 6th year, a valuer appraises the machine to be worth Rs. 97.50 lakh with an estimated residual value of Rs. 4,87,500....
-
This case is in continuation to the case of Oil and Natural Gas Corporation Ltd. as illustrated in the last chapter. Now refer further to the extracts from annual report 2005-06 of the company...
-
It can be interesting to compare the purchasing power of the dollar over different periods in history. Go to www.bankofcanada.ca/en/rates.htmand scroll down to the link to the inflation calculator to...
-
Tomiko is a 50 percent owner (partner) in the Tanaka partnership. During the year, the partnership reported $1,000 of interest income and $2,000 of dividends. How much of this income must Tomiko...
-
(8%) Problem 6: A student attaches a f= 3.5 kHz oscillator to one end of a metal rail of length L = 25 m. The student turns on the oscillator and uses a piezoelectric gauge at the other end to...
-
Will Facebook be able to have a successful business model without invading privacy? Explain your answer. Could Facebook take any measures to make this possible?
-
Wearables have the potential to change the way organizations and workers conduct business. Discuss the implications of this statement.
-
How would a business process such as ordering a product for a customer in the field be changed if the salesperson were wearing a smartwatch equipped with Salesforce software?
-
Ramirez Company installs a computerized manufacturing machine in its factory at the beginning of the year at a cost of $45,300. The machine's useful life is estimated at 10 years, or 403,000 units of...
-
14. (3 points) Write a program that ask the user for 1. their first name and 2. their last name, Enter first name: Matt Enter last name: Priem Hello Matt Priem! and then outputs a greeting similar to...
-
Given a sorted array 2, 5, 8, 12, 16, 18, 22, 25, 29, 32 and the following interpolation search algorithm. Show the steps of the algorithm when 25 is searched. Also, when 26 is searched. array a,...
Study smarter with the SolutionInn App