Net Cash Flows and NPVs for different discount rate for projects S and L are given below Net Cash Flows ($) Discount Rate (%) NPVS NPVL Year (t) Project S Project L 0% $800 $1100 0 $(3000) $(3000) 5 554.32 1 1500 400 10 161.33 2 1200 900 15 (90.74) (259.24) 3 800 1300 20 (309.03) (565.97) 4 300 1500 ii) NPVS at 10%: d) What is the IRR for S? (Write down the equation for IRR and then Use an excel worksheet to calculate IRR

Net Cash Flows and NPVs for different discount rate for projects S and L are given below Net Cash Flows ($) Discount Rate (%) NPVS NPVL Year (t) Project S Project L 0% $800 $1100 0 $(3000) $(3000) 5 554.32 1 1500 400 10 161.33 2 1200 900 15 (90.74) (259.24) 3 800 1300 20 (309.03) (565.97) 4 300 1500 ii) NPVS at 10%: d) What is the IRR for S? (Write down the equation for IRR and then Use an excel worksheet to calculate IRR

Principles of Accounting Volume 2

19th Edition

ISBN:9781947172609

Author:OpenStax

Publisher:OpenStax

Chapter11: Capital Budgeting Decisions

Section: Chapter Questions

Problem 16EA: Project B cost $5,000 and will generate after-tax net cash inflows of $500 in year one, $1,200 in...

See similar textbooks

Similar questions

Project B cost $5,000 and will generate after-tax net cash inflows of $500 in year one, $1,200 in year two, $2,000 in year three. $2,500 in year four, and $2,000 in year five. What is the NPV using 8% as the discount rate? For further instructions on net present value in Excel, see Appendix C.
Define each of the following terms: Capital budgeting; payback period; discounted payback period Independent projects; mutually exclusive projects Net present value (NPV) method; internal rate of return (IRR) method; profitability index (PI) Modified internal rate of return (MIRR) method NPV profile; crossover rate Nonnormal cash flow projects; normal cash flow projects; multiple IRRs Reinvestment rate assumption Replacement chain; economic life; capital rationing; equivalent annual annuity (EAA)
. Net Cash Flows and NPVs for different discount rate for projects S and L are given below Net Cash Flows ($) Discount Rate (%) NPVS NPVL Year (t) Project S Project L 0% $800 $1100 0 $(3000) $(3000) 5 554.32 1 1500 400 10 161.33 2 1200 900 15 (90.74) (259.24) 3 800 1300 20 (309.03) (565.97) 4 300 1500 h) If projects are independent (not mutually exclusive), which project(s) would you accept? i) at 5% ii) at 15%
Net Cash Flows and NPVs for different discount rate for projects S and L are given below Net Cash Flows ($) Discount Rate (%) NPVS NPVL Year (t) Project S Project L 0% $800 $1100 0 $(3000) $(3000) 5 554.32 1 1500 400 10 161.33 2 1200 900 15 (90.74) (259.24) 3 800 1300 20 (309.03) (565.97) 4 300 1500 e) What is the IRR for L? (Write down the equation for IRR and then Use an excel worksheet to calculate IRR Equation: Answer: f) What is the cross-over rate? (Write down the equation for IRR and then Use an excel worksheet to calculate IRR Equation: ANSMER:
Net Cash Flows and NPVs for different discount rate for projects S and L are given below Net Cash Flows ($) Discount Rate (%) NPVS NPVL Year (t) Project S Project L 0% $800 $1100 0 $(3000) $(3000) 5 554.32 1 1500 400 10 161.33 2 1200 900 15 (90.74) (259.24) 3 800 1300 20 (309.03) (565.97) 4 300 1500 g) If projects are mutually exclusive, which project would you accept? i) at 5% ii) at 15% h) If projects are independent (not mutually exclusive), which project(s) would you accept? i) at 5% ii) at 15%
Net Cash Flows and NPVs for different discount rate for projects S and L are given below Net Cash Flows ($) Discount Rate (%) NPVS NPVL Year (t) Project S Project L 0% $800 $1100 0 $(3000) $(3000) 5 454.85 554.32 1 1500 400 10 161.33 108.59 2 1200 900 15 (90.74) (259.24) 3 800 1300 20 (309.03) (565.97) 4 300 1500 25 a) Calculate the discounted payback period in years at 10% for the Project S and Project L i) Payback for Project S: ii) Payback for Project L: b) Calculate NPVS for 25% and NPVL for 25%. Fill the table i) NPVS at 25%: ii) NPVL at 25%: c What is the IRR for S? (Write down the equation for IRR and then Use an excel worksheet to calculate IRR Equation: Answer: d) What is the IRR for L? (Write down the equation for IRR and then Use an excel worksheet to calculate IRR Equation: Answer: e) What is the…
Company Z is considering a project that has the following cash flow data. Assuming a WACC of 8.0%, what is the project's discounted payback period? Year 0 1 2 3 Cash Flow -900 425 425 425 Group of answer choices 3.08 2.61 2.42 2.78 2.18
Net Cash Flows and NPVs for different discount rate for projects S and L are given below Net Cash Flows ($) Discount Rate (%) NPVS NPVL Year (t) Project S Project L 0% $800 $1100 0 $(3000) $(3000) 5 554.32 1 1500 400 10 161.33 2 1200 900 15 (90.74) (259.24) 3 800 1300 20 (309.03) (565.97) 4 300 1500 a) Calculate the payback period in years for the Project S and Project L i) Payback for Project S: ii) Payback for Project L: c) Calculate NPVS for 5% and NPVL for 10%. Fill the table i) NPVS at 5%: ii) NPVS at 10%: d) What is the IRR for S? (Write down the equation for IRR and then Use an excel worksheet to calculate IRR Equation: Answer: e) What is the IRR for S? (Write down the equation for IRR and then Use an excel worksheet to calculate IRR Equation: Answer: f) What is the cross-over rate? (Write down the equation for IRR and then Use…
. Net Cash Flows and NPVs for different discount rate for projects S and L are given below Net Cash Flows ($) Discount Rate (%) NPVS NPVL Year (t) Project S Project L 0% $800 $1100 0 $(3000) $(3000) 5 554.32 1 1500 400 10 161.33 2 1200 900 15 (90.74) (259.24) 3 800 1300 20 (309.03) (565.97) 4 300 1500 a) Calculate the payback period in years for the Project S and Project L i) Payback for Project S: ii) Payback for Project L: c) Calculate NPVS for 5% and NPVL for 10%. Fill the table i) NPVS at 5%: ii) NPVS at 10%: d) What is the IRR for S? (Write down the equation for IRR and then Use an excel worksheet to calculate IRR Equation: Answer:
Watts Co. is considering a project that has the following cash flow and WACC data. What is the project's MIRR? WACC: 10.00% Year 0 1 2 3 4 Cash flows -$725 $375 $400 $425 $450 Group of answer choices 25.34% 26.43% 24.25% 27.24% 23.16%
A project has the following cash flows: C * 0 = - 100000; C 1 = 50000 C * 2 = 150000 C 3 = 100000 . If the discount rate changes from 12 percent to 15 percent, what is the CHANGE in the NPV of the project ( approximately)? Multiple Choice 12,750 increase 12,750 decrease 14,240 increase 14,240 decrease
Project Y has following cash flows: C0 = -800, C1 = +6,000, and C2 = -6,000. Calculate the IRRs for the project: For what range of discount rates does the project have positive NPV (Plot a graph with NPV on the vertical axis and discount rate on the horizontal axis).

SEE MORE QUESTIONS

Recommended textbooks for you

Principles of Accounting Volume 2

Accounting

ISBN:

9781947172609

Author:

OpenStax

Publisher:

OpenStax College

Corporate Fin Focused Approach

Finance

ISBN:

9781285660516

Author:

EHRHARDT

Publisher:

Cengage

Financial Management: Theory & Practice

Finance

ISBN:

9781337909730

Author:

Brigham

Publisher:

Cengage

Principles of Accounting Volume 2

Accounting

ISBN:

9781947172609

Author:

OpenStax

Publisher:

OpenStax College

Corporate Fin Focused Approach

Finance

ISBN:

9781285660516

Author:

EHRHARDT

Publisher:

Cengage

Financial Management: Theory & Practice

Finance

ISBN:

9781337909730

Author:

Brigham

Publisher:

Cengage

SEE MORE TEXTBOOKS

GET THE APP

About FAQ Academic Integrity Sitemap Document Sitemap

Contact Bartleby Contact Research (Essays)High School Textbooks Literature Guides Concept Explainers by Subject Essay Help Mobile App

GET THE APP

Privacy

Your CA Privacy Rights

Your NV Privacy Rights

About Ads

Manage My Data

bartleby, a Learneo, Inc. business

	Net Cash Flows ($)		Discount Rate (%)	NPV_S	NPV_L
Year (t)	Project S	Project L		0%	$800	$1100
0	$(3000)	$(3000)		5		554.32
1	1500	400		10	161.33
2	1200	900		15	(90.74)	(259.24)
3	800	1300		20	(309.03)	(565.97)
4	300	1500