Please calculate the yearly NPV and IRR. We want a positive present value in 3 years and our break-even point (positive NPV) should be 10 years. You may adjust Yearly O&M, Periodic Costs, interest rate (5%), or total debt as you see fit to meet these criteria. Revenue and Fees are in thousands of dollars. The fifth to last year is 2044, the revenue is $74,572, and the growth is 4.5%. The fourth to last year is 2045, the revenue is $77,953, and the growth is 4.5%. The third to last year is 2046, the revenue is $81,491, and the growth is 4.5%. The second to last year is 2047, the revenue is $84,354, and the growth is 3.5%. The final year is 2048, the revenue is $86,470, and the growth is 2.5%.
Year Revenue Growth NPV IRR
2020 $1,813 Debit 80%
2021 $2,268 25.1% Equity 20%
2022 $13,301 487.0% i 5%
2023 $16,144 21.4% No. of payments (n) 29
2024 $17,847 10.5% Yearly O&M costs $500,000
2025 $19,679 10.3% Periodic Costs (every 5 years) $1,500,000
2026 $21,164 7.5% Yearly Payments (PMT) $459,167
2027 $23,750 12.2% Yearly PMTS = (Total*Debt*i)/(1+i)^n
2028 $25,924 9.2% Yearly PMTS = (45,500,000*0.8*0.05)/(1+0.05)^29
2029 $28,299 9.2% =(45,500,000*0.8*0.05)/(1+0.05)^(29)
2030 $30,893 9.2% 1,800,000/1.05^29
2031 $33,727 9.2% 437,303.378
2032 $36,824 9.2%
2033 $39,129 6.3%
2034 $41,581 6.3%
2035 $44,189 6.3%
2036 $46,964 6.3%
2037 $49,916 6.3%
2038 $53,138 6.5%
2039 $56,568 6.5%
2040 $60,218 6.5%
2041 $64,105 6.5%
2042 $68,243 6.5%
2043 $71,335 4.5%