Calculate IRR and NPV of this project using a 12% discount rate and 15% cap rate. Ms. Brown was able to secure a loan for $1,540,000 and an equity investor agreed to invest the remaining $660,000 in exchange for 20% ownership

Cash Flow

Year 1 $695,000

Year 2 $876,250

Year 3 $1,057,500

Year 4, $1,238,750

Year 5 $1,420,000

Can you Show me the excel formulas needed to solve this? I want to put it in an excel sheet but I must be doing something wrong.