can you please show me how to calculate the discounted cash flow? Please dont just give...
can you please show me how to calculate the discounted cash flow? Please dont just give me the answer.
| g. At a cost of capital of 12%, what is the discounted payback period for these two projects? | |||||||||
| WACC = | 12% | ||||||||
| Project A | |||||||||
| Time period | 0 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | |
| Cash flow | -$375 | -$300 | -$200 | -$100 | $600 | $600 | $926 | -$200 | |
| Disc. cash flow | |||||||||
| Disc. cum. cash flow | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
| Intermediate calculation for payback | |||||||||
| Payback using intermediate calculations | #DIV/0! | ||||||||
Homework Answers
Add Answer to:
can you please show me how to calculate the discounted cash
flow? Please dont just give...
Calculate payback periods. Please show calculations so I can duplicate it in excel. 7 Your division is considering two projects. Its wACC is 10%, and the projects, after-tax cash flows (in millio...
Calculate payback periods. Please show calculations so I can
duplicate it in excel.
7 Your division is considering two projects. Its wACC is 10%, and the projects, after-tax cash flows (in millions 8 of dollars) would be as follows: Expected Cash Flows Project A Project B 10 Time (S30) S5 s10 S15 S20 (S30) S20 S10 S8 S6 12 13 14 15 16 17 18 a. Calculate the projects' NPVs, IRRs, MIRRs, regular paybacks, and discounted payback Use Excel's NPV...
SHOW FORMULAS f. What is the regular payback period for these two projects? Project A Time period...
SHOW FORMULAS f. What is the regular payback period for these two projects? Project A Time period 0 1 2 3 4 5 6 7 Cash flow (375) (300) (200) (100) 600 $600 $926 ($200) Cumulative cash flow Intermediate calculation for payback — Payback using intermediate calculations Project B Time period 0 1 2 3 4 5 6 7 Cash flow Cumulative cash flow Intermediate calculation for payback Payback using intermediate calculations Payback using PERCENTRANK Ok because cash flows follow normal...
Calculate the discounted payback for a project with the following projected cash flows: Year Cash Flow ...
Calculate the discounted payback for a project with the following projected cash flows: Year Cash Flow 0 -2,500 1 600 2 1300 3 827 4 600 Assume the risk-adjusted WACC is 8.4%. Enter your answer as a number with 2 decimal places of precision (i.e. 1.23) Do not round intermediate calculations (PVs)
Part 2 - The second model isfor a project forGardialFisheries. GardialFisheries is considering two mutually exclusive...
Part 2 - The second model isfor a project forGardialFisheries. GardialFisheries is considering two mutually exclusive investments. The projects’ expected net cash flows are as follows: Expected Net Cash Flows for the 7 year Project are: Project A −$375, −300, −200, −100, 600, 600, 926 and, −200 Project B −$575, 190, 190, 190, 190, 190, 190 and, 0 If each project’s cost of capital is 12%, which project should be selected? If the cost of capital is 18%, what project...
Case Study 3--Capital Budgeting (Comprehensive Spreadsheet Problem 11-23, page 408) Your division is considering two projects....
Case Study 3--Capital Budgeting (Comprehensive Spreadsheet Problem 11-23, page 408) Your division is considering two projects. Its WACC is 10%, and the projects' after-tax cash flows (in millions of dollars) would be as follows: Expected Cash Flows Time Project A Project B 0 ($30) ($30) 1 $5 $20 2 $10 $10 3 $15 $8 4 $20 $6 a. Calculate the projects' NPVs, IRRs, MIRRs, regular paybacks, and discounted paybacks. WACC = 10% Use Excel's NPV function as explained in NPVA...
I have the answer but can you please explain how they got the amounts for Discounted...
I have the answer but can you please explain how they got the
amounts for Discounted CF and Cumulative Discounted CF? Thanks.
7. ACME Inc. is considering a project that has the following cash flow and WACC data. What is the project's discounted payback? WACC 11.00% Year 4 Cash flows -$1.125 $490 $520 $520 520 What is the problem with discounted payback? Why do people still use discounted payback? 11 .00% WACC: Year0 2 4 Cash flows -$1,125 S490 S520...
Compute the discounted payback statistic for Project D if the appropriate cost of capital is 12...
Compute the discounted payback statistic for Project D if the appropriate cost of capital is 12 percent and the maximum allowable discounted payback is four years. (Do not round intermediate calculations and round your final answer to 2 decimal places. If the project does not pay back, then enter a "O" (zero).) Project D Time: Cash flow: 0 -$11,600 1 $3,410 $4,300 34 $1,640 $0 $1,120 Discounted payback period 0 years Should the project be accepted or rejected? accepted rejected...
Quantitative Problem: Bellinger Industries is considering two projects for inclusion in its capital budget, and you...
Quantitative Problem: Bellinger Industries is considering two projects for inclusion in its capital budget, and you have been asked to do the analysis. Both projects' after-tax cash flows are shown on the time line below. Depreciation, salvage values, net operating working capital requirements, and tax effects are all included in these cash flows. Both projects have 4-year lives, and they have risk characteristics similar to the firm's average project. Bellinger's WACC is 7%. 0 1 2 3 4 Project A...
newconnect. mheducation.com hapter 5. Discounted Cash Flow - Part 2 Chapter 5 - DCF & Interest...
newconnect. mheducation.com hapter 5. Discounted Cash Flow - Part 2 Chapter 5 - DCF & Interest Rates - Part 3 Chapter 8 Chapter 8 - NPV & Investment Criteria 6 Stenson, Inc., imposes a payback cutoff of three years for its international Investment projects. Assume the company has the following two projects available. 14.28 Year Cash Flow A Cash Flow B 0 -$62,000 -$ 107,000 1 25,500 27,500 2 33,200 32,500 27,500 26,500 13,500 233,000 What is the payback period...
Consider the following two mutually exclusive projects: Cash Flow Year 0 Cash Flow (B) - $...
Consider the following two mutually exclusive projects: Cash Flow Year 0 Cash Flow (B) - $ 50,000 24,000 22,000 19,500 14, 600 - $ 350,000 45,000 65,000 65,000 440,000 AM + Whichever project you choose, if any, you require a 15% return on your investment. a-1. What is the payback period for each project? (Round the final answers to 2 decimal places.) Payback Period Project A Project B years years a-2. If you apply the payback criterion, which investment will...
Calculate payback periods. Please show calculations so I can
duplicate it in excel.
7 Your division is considering two projects. Its wACC is 10%, and the projects, after-tax cash flows (in millions 8 of dollars) would be as follows: Expected Cash Flows Project A Project B 10 Time (S30) S5 s10 S15 S20 (S30) S20 S10 S8 S6 12 13 14 15 16 17 18 a. Calculate the projects' NPVs, IRRs, MIRRs, regular paybacks, and discounted payback Use Excel's NPV...
I have the answer but can you please explain how they got the
amounts for Discounted CF and Cumulative Discounted CF? Thanks.
7. ACME Inc. is considering a project that has the following cash flow and WACC data. What is the project's discounted payback? WACC 11.00% Year 4 Cash flows -$1.125 $490 $520 $520 520 What is the problem with discounted payback? Why do people still use discounted payback? 11 .00% WACC: Year0 2 4 Cash flows -$1,125 S490 S520...
Compute the discounted payback statistic for Project D if the appropriate cost of capital is 12 percent and the maximum allowable discounted payback is four years. (Do not round intermediate calculations and round your final answer to 2 decimal places. If the project does not pay back, then enter a "O" (zero).) Project D Time: Cash flow: 0 -$11,600 1 $3,410 $4,300 34 $1,640 $0 $1,120 Discounted payback period 0 years Should the project be accepted or rejected? accepted rejected...
newconnect. mheducation.com hapter 5. Discounted Cash Flow - Part 2 Chapter 5 - DCF & Interest Rates - Part 3 Chapter 8 Chapter 8 - NPV & Investment Criteria 6 Stenson, Inc., imposes a payback cutoff of three years for its international Investment projects. Assume the company has the following two projects available. 14.28 Year Cash Flow A Cash Flow B 0 -$62,000 -$ 107,000 1 25,500 27,500 2 33,200 32,500 27,500 26,500 13,500 233,000 What is the payback period...
Consider the following two mutually exclusive projects: Cash Flow Year 0 Cash Flow (B) - $ 50,000 24,000 22,000 19,500 14, 600 - $ 350,000 45,000 65,000 65,000 440,000 AM + Whichever project you choose, if any, you require a 15% return on your investment. a-1. What is the payback period for each project? (Round the final answers to 2 decimal places.) Payback Period Project A Project B years years a-2. If you apply the payback criterion, which investment will...
Most questions answered within 3 hours.
-
Where is the error in this code sequence?
String s1 = "Hello";
String s2 = "ello";...
asked 11 months ago -
Financial data for Joel de Paris, Inc., for last year
follow:
Joel de Paris, Inc.
Balance...
asked 11 months ago -
Consider this reaction:
Al2(SO4)3 (aq)+ BaCl3
(aq) Al2Cl6 (aq)- +
3BaSO4(s) . What is the...
asked 11 months ago -
Suppose that Savneet is considering increasing her
recent random sample from 20 car rentals to 40...
asked 11 months ago -
Trucks arrive at an unloading terminal at an average rate of 120
per hour.
Trucks arrive...
asked 11 months ago -
Why are methanol and ethanol completely soluble in water while
octanol is not very little soluble....
asked 11 months ago -
A facilities manager at a university reads in a research report
that the mean amount of...
asked 11 months ago -
When the CuSO4 is rehydrated by adding water to the anhydrous
compound, is this an endothermic...
asked 11 months ago -
A ray of sunlight is passing from diamond into crown glass; the
angle of incidence is...
asked 11 months ago -
A block of mass 0.249 kg is placed on top of a light, vertical
spring of...
asked 11 months ago -
how do the kidneys compensate in the presences of acidosis
a) trigger hyperventilate
b) reserve acid...
asked 11 months ago -
Question 501 pts
The rental rate of capital to the firm increases. Which of the
following...
asked 11 months ago