Question

Topic: Net present 49 hat is the IRR of a project with the following cash flows: Co--$200, Ci-110, C2-$121? A. Zero B.10% C. 18% D. 5%
0 0
Add a comment Improve this question Transcribed image text
Answer #1

C0 = -200

C1= 110

C2= 121

C0 = C1/(1+IRR) + C2/ (1+IRR)^2

We can find the IRR manually but a better way is to find the IRR using Excel.

IRR= 6.7%

Sign in Book1 - Excel 《Product Activation Failed) AutoSave Share Tell me what you want to do File Insert Draw Page Layout Formulas Data Review View Help Home General 田FF Calibri Conditional Fornat as Cell Insert Delete Fornat FormattingTable Styles- 、. Sort & Find & Editing : Filter-Select- . 녀 . 의 _ . 로三들經垣臣 Merge & Center-5 . % , Paste Number Styles Cells Alignment Clipboard C6 Cash flows Year 0 200 100 121 IRR IRR(D2:D4) 10 12 13 14 16 17 Sheet1 Shet2 + 100 Ready 写cP ENG 11:39 AM

Add a comment
Know the answer?
Add Answer to:
Topic: Net present 49 hat is the IRR of a project with the following cash flows:...
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
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