Question
is 4b correct? and how do you do 5?
Problem 4: Calculating NPV. For the cash flows in the previous problem, suppose the firm uses NPV to evaluate projects. 4a. A
0 0
Add a comment Improve this question Transcribed image text
Answer #1

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)
Add a comment
Know the answer?
Add Answer to:
is 4b correct? and how do you do 5? Problem 4: Calculating NPV. For the cash...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • 10. Calculating IRR [LO5] What is the IRR of the following set of cash flower Year...

    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

     (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...

    ? 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...

    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 alrea...

    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?   ...

    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...

    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...

    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...

    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...

    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...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT