Method Two Let’s assume that we didn’t calculate the IRR of 57% as we did above and have no idea what the correct discount rate is. We can use Excel’s What-If calculator in this case.

Trends in Excel predict future values using the TREND function, revealing data insights. TREND function utilizes known data to create a trend line for predictions. You can visualize and calculate ...