Calculate the following using the appropriate functions in Excel: 1. Find the NPV and IRR of...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Calculate the following using the appropriate functions in Excel: 1. Find the NPV and IRR of a project with the following cash flows and a 12% cost of capital. Also calculate the MIRR assuming a reinvestment rate of 8% (recall that the modified IRR assumes reinvestment is at the cost of capital or another rate rather than the IRR). Use an IF statement to add an accept reject decision for each. Cash flow $ (40,000) t 0 1 10,000 2 10,000 3 11,000 4 17,000 5 12,000 2. Calculate the Profitability Index of the project in (1) using IF and ABS. The profitability index weights the PV of future cash flows by the initial investment in order to rank projects by return to each dollar invested. Would the project be accepted? 3. For the project in (1), construct a table to calculate the NPV for cost of capital between 0% and 40%. Graph the results of table to show the NPV profile. Label your axes and customize the graph as necessary. 4. What is the Payback Period for the cash flows in (1)? Calculate with at least one method. Consider using IF, AND, ABS, MAX, SUM, ROUND, COUNTIF, and/or VLOOKUP in your formulas. NPV= NCF: = (1 + k) NCF: NPV = =0 PB = Years before cost recovery + Remaining cost to recover Cash flow during the year (1+IRR) TV PV Cost= (1+ MIRR)" NPV+Initial invesment PI = Initial investment Calculate the following using the appropriate functions in Excel: 1. Find the NPV and IRR of a project with the following cash flows and a 12% cost of capital. Also calculate the MIRR assuming a reinvestment rate of 8% (recall that the modified IRR assumes reinvestment is at the cost of capital or another rate rather than the IRR). Use an IF statement to add an accept reject decision for each. Cash flow $ (40,000) t 0 1 10,000 2 10,000 3 11,000 4 17,000 5 12,000 2. Calculate the Profitability Index of the project in (1) using IF and ABS. The profitability index weights the PV of future cash flows by the initial investment in order to rank projects by return to each dollar invested. Would the project be accepted? 3. For the project in (1), construct a table to calculate the NPV for cost of capital between 0% and 40%. Graph the results of table to show the NPV profile. Label your axes and customize the graph as necessary. 4. What is the Payback Period for the cash flows in (1)? Calculate with at least one method. Consider using IF, AND, ABS, MAX, SUM, ROUND, COUNTIF, and/or VLOOKUP in your formulas. NPV= NCF: = (1 + k) NCF: NPV = =0 PB = Years before cost recovery + Remaining cost to recover Cash flow during the year (1+IRR) TV PV Cost= (1+ MIRR)" NPV+Initial invesment PI = Initial investment
Expert Answer:
Posted Date:
Students also viewed these accounting questions
-
The divorced spouse can continue on a group health plan for how many months? O 12 months O 24 months O 18 months O 36 months
-
A seismic probe bores itself into the seabed, going as deep as it can before running out of fuel. This takes about five minutes. It rotates its spiral drill head at rate R(t) that follows a...
-
The rate of return on ABC, Inc., stock over the last five years was 6.32 percent, 9.7 percent, -0.94 percent, 8.22 percent, and 15.68 percent. What was the geometric average return (in percent) on...
-
When average total cost is at its minimum: A. Average variable cost is declining with increases in output B. Average variable cost plus average fixed cost is declining with increases in output C....
-
From the text Web site, link to the site of the Federal Reserve Bank of St. Louis; also, see the Guide to St. Louis Fed Data." Get annual data on the inflation rate, the interest rate on 3-month...
-
a) What authentication mechanisms are common on IP telephones? b) What does SIP Identity ensure? c) How can eavesdropping be thwarted? d) What sound quality problem may encryption create? e) Why do...
-
Suppose you want to buy a house five years from today. You currently have $25,000 saved toward this purchase, but don't think you'll be able to save any more money, other than the interest that the...
-
Dobler Company just took its physical inventory on December 31. The count of inventory items on hand at the companys business locations resulted in a total inventory cost of $300,000. In reviewing...
-
Verizon Communications Inc. provides telecommunications services using operating costing. In January 2034, the company incurs the following costs: Network Maintenance: $20 million (fixed) Customer...
-
Task 1: Academic Integrity reflection (5 marks) In order to access this assignment, you were asked to read about an Academic Integrity issue and answer related multiple-choice questions. Before con...
-
A rubber ball of mass m traveling horizontally with a speed v hits a wall and bounces back with the same speed. The magnitude of the change in momentum is (a) 0, (b) mv, (c) mv/2, (d) 2mv.
-
The center of mass and center of gravity coincide (a) if the acceleration due to gravity is constant, (b) if momentum is conserved, (c) if momentum is not conserved, (d) only for irregularly shaped...
-
A net force on an object can cause (a) an acceleration, (b) a change in momentum, (c) a change in velocity, (d) all of the preceding.
-
When there are numerous property and equipment transactions during the year, an auditor who plans to set the control risk at a low level usually performs a. Substantive analytical procedures for...
-
The following circumstances may involve violations of the Rules of Conduct: 1. A CPA bases his fee on the outcome of a bankruptcy proceeding. 2. A CPA discloses confidential information in a peer...
-
What are the 9 red flags of bribery and kickbacks that we went over in the notes?
-
The population of Detroit, Michigan, decreased from 1,027,974 in 1990 to 688,701 in 2013 (Source: U.S. Census Bureau). Find the average rate of change in the population of Detroit, Michigan, over the...
-
The production budget for cars for May (in units) is a. 6,500 b. 11,000 c. 4,500 d. 10,100 Munch Enterprises makes a small toy car that is voice activated. Projected sales for the next four months...
-
The production budget for cars for May (in units) is a. 6,500 b. 11,000 c. 4,500 d. 10,100
-
The total cost of goods sold for June is a. $103,500 b. $128,800 c. 57,500 d. \($232,300\) Munch Enterprises makes a small toy car that is voice activated. Projected sales for the next four months...
Study smarter with the SolutionInn App