I am working on calculating money-weighted rate of return for my portfolio. I have to solve the following equation for r:
$298,082 = ($250,000 * (1 + r)) + ($25,000 * (1 + r)^((365 - 258)/365)))
...which simplifies to:
$298,082 = ($250,000 * (1 + r)) + ($25,000 * (1 + r)^(0.293150685))
Is there an easy way to do this in Excel? I am using Excel 2016.
$298,082 = ($250,000 * (1 + r)) + ($25,000 * (1 + r)^((365 - 258)/365)))
...which simplifies to:
$298,082 = ($250,000 * (1 + r)) + ($25,000 * (1 + r)^(0.293150685))
Is there an easy way to do this in Excel? I am using Excel 2016.