I am trying to utilize the IRR function in excel to calculate IRR for my
string of cash flows for 30 years:

Year Cash Flows
2008 -
2009 852
2010 2,163
2011 11,181
2012 9,598
2013 7,774
2014 (203)
2015 329
2016 1,926
2017 (2,475)
2018 (22,903)
2019 (16,136)
2020 3,576
2021 (4,109)
2022 1,329
2023 1,401
2024 2,572
2025 (477)
2026 1,556
2027 1,370
2028 1,045
2029 571
2030 (13,113)
2031 6,178
2032 6,345
2033 6,515
2034 6,764
2035 7,039
2036 7,333
2037 7,672
2038 8,017
2039 8,329
residual 56,607

The formula I am using is:

=(1+IRR("Range of Data),(1+0.0875)^0.25-1))^4-1

I am getting the "#DIV/0!" error. What am I missing here? Any assistance
would be most appreciated.

Thanks!