Finance and Financial Management Commons^™

How To Create Cash Flows That Give A Priori Irrs?, Charlie Charoenwong, Xinxin Li, Chee K. Ng

Southwestern Business Administration Journal

We illustrate algebraically the way to numerically derive the cash flows of an investment project yielding a set of desired IRRs. This is significant given the dearth of practice questions with the appropriate cash flow numbers, and their corresponding sign, in widely adopted Finance textbooks that will allow students to find multiple IRRs as learning exercises. The note serves to fill that void by allowing the readers to change the IRR inputs in an Excel spreadsheet and have the corresponding cash flows output ready for an assignment. Instructors can use the Excel codes to create different cash flows that yield …