Please show your work and write out your solutions in detail by giving formulas and a short summary at the end. Please do not just post about financial calc or excel without explaining how you got the answer. thank you!

Consider the following mutually exclusive projects:

	T=0	1	2	3
Project X:	-100	20	30	90
Project Y:	-100	80	30	20

1. Find IRRs for both projects.
2. 
   
3. Find the cross-over rate.
4. 
   
5. Construct a graph, where you will show the NPV of each project as a function of its discount rate (i.e NPV on the vertical axis and r on the horizontal axis). Both NPVs should be on the same graph. This graph is the NPV schedule.
6. 
   
7. Please describe as fully as possible which project is the best and under which circumstances.

Answer rating: 100% (QA)

A B C D E F G 1 Year 0 Year 1 Year 2 Year 3 Formula IRR 2 Project X 100 20 30 90 ... View the full answer