|
Featured Tutorial
Featured Macro
Excel Finance Class 75: IRR and Mutually Exclusive Projects - Plot Chart To See Cross Over Rate
Download Excel workbook http://people.highline.edu/mgirvin/ExcelIsFun.htm
Learn about : IRR and Mutually Exclusive Projects. Build a table and plot an X-Y Scatter chart to see that at different Required Rates of Return we get different Net Present Value amounts with Mutually Exclusive Projects. Build a table of Difference Cash Flows to then calculate the cross over rate.
Learn about : IRR and Mutually Exclusive Projects. Build a table and plot an X-Y Scatter chart to see that at different Required Rates of Return we get different Net Present Value amounts with Mutually Exclusive Projects. Build a table of Difference Cash Flows to then calculate the cross over rate.