Title: How the Andersons Projected a 12 Tagline: How the Andersons Projected a 12.7% Return on a Risky Biotech Investment to Fund Their Kids' College Using MIRR Problem: The Andersons, earning $450,000 annually, face the daunting task of funding three children's college education. A financial advisor pitched them a seemingly lucrative, yet risky, investment in a pre-IPO biotech startup, promising high returns but with a complex cash flow structure. The initial investment was $50,000, followed by potential capital calls of $20,000 in year 2 and $10,000 in year 3. Projected payouts were $15,000 in year 4, $40,000 in year 5, and a final exit payout of $100,000 in year 7. However, the risk lay in the uncertain timing and potential for capital calls beyond their initial estimates. They needed a clear way to understand the true return, considering their cost of capital (5%) and the potential reinvestment rate of profits (8%). Standard IRR calculations were misleading due to the variable nature of the cash flows and the reinvestment of early profits. Solution: The Andersons used the Golden Door Asset MIRR Calculator to analyze the potential biotech investment. By inputting the initial investment, capital calls, projected payouts, their cost of capital (finance rate), and a conservative estimate of their reinvestment rate, they obtained a Modified Internal Rate of Return (MIRR) of 12.7%. This MIRR provided a more accurate picture of the investment's profitability compared to a standard IRR, considering the varying timing and reinvestment of cash flows. Further analysis with the Tax Equivalent Yield Calculator helped them understand the after-tax impact of the investment's potential returns. They also leveraged the Bond YTM calculator to assess safer, lower-yielding investment options to compare risk adjusted returns. ROI: By accurately assessing the MIRR of 12.7%, the Andersons felt confident in proceeding with a $30,000 initial investment (instead of $50,000). Over the 7 year investment horizon, the projected earnings of $90,000 would save them $12,000 in additional required investments to reach their college funding goals. This represents an efficiency increase of 13.3%. Description: Confidently assess the true profitability of complex investments with varying cash flows and reinvestment opportunities. Our MIRR Calculator empowers you to make informed decisions and secure your financial future. Category: Client Service