Modified Internal Rate Of Return

Closed

I'm trying to calculate and solve my historical and future projected monthly yield factoring in time for my litigation funding company. I began this project thinking that Internal Rate of Return (IRR) would be the correct formula to use. I can't use the normal IRR function in Excel since it can only handle one negative number in a fixed stream of cash flows. Excels Modified Internal Rate of Return (MIRR) formula allows for multiple negative cash flows, but I'm not clear if this is the correct formula to use for my purposes. I'm told that when using MIRR, for every negative sign change beyond one, that there are additional correct answers (ex: if they're four sign changes there would be four mathematically correct answers for the IRR).

I need you to help me determine the following once I bring you up to date:

Is MIRR adequate for my needs? How should investor capital infusions into my company be accounted for? Do I need to create a special formula for my unique needs? If so, you would need to have the mathematical capacity to create this formula.

Skills: Education & Tutoring

See more: modified internal rate return, clear capital, capital one, can capital, rate change, my rate, excel help formula, change of rate, return, rate, modified, mathematical m, Litigation, internal , internal project, infusions, excel ex, calculate the irr, stream needs, excel modified, education create change, return time excel, company internal, education change, internal rate return formula

Project ID: #844134

3 freelancers are bidding on average $97 for this job

raiseq

Research scholar in finance can help you

$55 USD in 3 days
(1 Review)
1.2
sankalplondon3

Please let me know when we have to start the work for u asap I am Skype add me as sankalpsaxena7

$35 USD in 1 day
(0 Reviews)
0.0
OSATO

I am a mathematician and can do the work.

$200 USD in 10 days
(0 Reviews)
0.0