Problem 4 : There is no cashflows mentioned, so that I cant check it. Sorry
Problem 5
a | b | a*b | |
Year | Cashflow | PV factor 10% [1/(1+r)]^n | PV |
0 | (7,560.00) | 1.000 | (7,560.00) |
1 | 1,710.00 | 0.909 | 1,554.55 |
2 | 1,710.00 | 0.826 | 1,413.22 |
3 | 1,710.00 | 0.751 | 1,284.75 |
4 | 1,710.00 | 0.683 | 1,167.95 |
5 | 1,710.00 | 0.621 | 1,061.78 |
6 | 1,710.00 | 0.564 | 965.25 |
7 | 1,710.00 | 0.513 | 877.50 |
8 | 1,710.00 | 0.467 | 797.73 |
9 | 1,710.00 | 0.424 | 725.21 |
10 | 1,710.00 | 0.386 | 659.28 |
NPV of the project at 10% | 2,947.21 |
a | b | a*b | |
Year | Cashflow | PV factor 24% [1/(1+r)]^n | PV |
0 | (7,560.00) | 1.000 | (7,560.00) |
1 | 1,710.00 | 0.806 | 1,379.03 |
2 | 1,710.00 | 0.650 | 1,112.12 |
3 | 1,710.00 | 0.524 | 896.87 |
4 | 1,710.00 | 0.423 | 723.28 |
5 | 1,710.00 | 0.341 | 583.29 |
6 | 1,710.00 | 0.275 | 470.40 |
7 | 1,710.00 | 0.222 | 379.35 |
8 | 1,710.00 | 0.179 | 305.93 |
9 | 1,710.00 | 0.144 | 246.72 |
10 | 1,710.00 | 0.116 | 198.97 |
NPV of the project at 24% | (1,264.03) |
NPV of the project at 10% | $ 2,947.21 | |
NPV of the project at 24% | $ (1,264.03) | |
Difference | 4,211.24 | |
IRR of project | 10 + (14*(2947.21/4211.24)) | |
IRR of project | 18.46% |
Cashflows at IRR
a | b | a*b | |
Year | Cashflow | PV factor 18.46% [1/(1+r)]^n | PV |
0 | (7,560.00) | 1.000 | (7,560.00) |
1 | 1,710.00 | 0.844 | 1,443.53 |
2 | 1,710.00 | 0.713 | 1,218.58 |
3 | 1,710.00 | 0.602 | 1,028.68 |
4 | 1,710.00 | 0.508 | 868.38 |
5 | 1,710.00 | 0.429 | 733.06 |
6 | 1,710.00 | 0.362 | 618.82 |
7 | 1,710.00 | 0.305 | 522.39 |
8 | 1,710.00 | 0.258 | 440.98 |
9 | 1,710.00 | 0.218 | 372.26 |
10 | 1,710.00 | 0.184 | 314.25 |
NPV of the project | (0.00) |
is 4b correct? and how do you do 5? Problem 4: Calculating NPV. For the cash...
10. Calculating IRR [LO5] What is the IRR of the following set of cash flower Year WN - O Cash Flow -$15,400 7,300 9,100 5,900 11. Calculating NPV [LO1] For the cash flows in the previous problem, what is the NPV at a discount rate of zero percent? What if the discount rate is 10 percent? If it is 20 percent? If it is 30 percent? 12. NPV versus IRR [LO1, 5] Bruin, Inc., has identified the following two mutually...
(Calculating IRR and NPV) (Related to Checkpoint 11.1 on page 367 and Checkpoint 11.4 on page 376) The cash flows for three independent projects are as follows:a. Calculate the IRR for each of the projects.b. If the discount rate for all three projects is 10 percent, which project or projects would you want to undertake?c. What is the NPV of each of the projects where the appropriate discount rate is 10 percent? 20 percent?
? X Calculating NPV and IRR - Excel FORMULAS DATA REVIEW - Sign In FILE HOME INSERT PAGE LAYOUT VIEW Calibri Paste B IU A Editing Alignment Number Conditional Format as Cell Formatting Table Styles Styles Cells - Clipboard Font A1 д в E F G H I A project that provides annual cash flows of $15,400 for nine years costs $67,000 today. What is the NPV if the required return is 8 percent? What if it's 20 percent? At...
Need Question 9 answered! book contents p to pg go search ebook gc Click here for a description of Table: Questions and Problems 7. 8. Calculating NPV (LO1) For the cash flows in the previous problem, suppose the firm uses the NPV decision rule. At a required return of 11 percent, should the firm accept this project? What if the required return was 25 percent? 9. Calculating NPV and IRR (L01, 5) A project that provides annual cash flows of...
can someone please provide steps for calculating IRR on a TI Nspire CX? I can calculate npv already, but I do not know how to use the irr function on ti nspire. the problem I am stuck on is number 10. thank you out-content-rid-14522766-1/courses/FINC3321-002-201 920/capital%20decisions%281 %29.pdf P9-10 Your company is considering two mutually exclusive projects-C and R-whose costs and cash flows are shown in the following table: Expected Net Cash Flows Year Project CF Project R $(14,000) 8,000 6,000 2,000...
c. If the required return is 7 percent, what is the NPV for Project A? d. If the required return is 7 percent, what is the NPV for Project B? e. At what discount rate would the company be indifferent between these two projects? Bruin, Inc., has identified the following two mutually exclusive projects: Year -o Cash Flow (A) -$41,000 19,400 14,900 12,400 9,400 Cash Flow (B) -$41,000 5,600 12.100 18,600 22,600 mt a. What is the IRR...
discount rate is zero percent? What if the discount rate is 5 percent? If it is 19 percent? 6. Calculating AAR (LO4) Youre trying to determine whether to expand your business by building a new manufacturing plant. The plant has an installation cost of $12 million, which will be depreciated straight-line to zero over its four-year life. If the plant has proiected net income of $1.854,300, $1,907.600, $1,876.000 and $1,329,500 over these four years, what is the project's average accounting...
NPV versus IRR Piercy, LLC, has identified the following two mutually exclusive projects: Year Cash Flow (A) Cash Flow (B) -$77,500 -$77,500 43,000 21,500 29,000 28,000 23,000 34,000 21,000 41,000 a. What is the IRR for each of these projects? If you apply the IRR decision rule, which project should the company accept? Is this decision necessarily correct? b. If the required return is 11 percent, what is the NPV for each of these projects? Which project will you choose...
Problem 9-9 Calculating NPV and l A project that provides annual cash flows of $18,200 for nine years costs $88.000 today. What is the NPV for the project if the required return is 8 percent? (Do not round intermediate calculations. Round your answer to 2 decimal places, e.g. 32.16.) NPV At a required return of 8 percent, should the firm accept this project? Accept O Reject What is the NPV for the project if the required return is 20 percent?...
in314 Exam II X G Bulk Purchases just purchased X + c ps i Cloud 1314 Exam II e zto.mheducation.com/hm.tpx Y Yahoo G Google New Tab Question 19 (of 35) value 8.00 points Problem 8-7 Calculating NPV and IRR [LO 3,4] A project that provides annual cash flows of $3,100 for nine years costs $10,400 today. At a required return of 12 percent, what is the NPV of the project? (Do not round intermediate calcula NPV 5 At a required...