CAN YOU SHOW WORK BY EXCEL HOW TO GET IRR MONTHLY AND IRR ANNUALIZED? THANK YOU.

Excel File Edit View Insert Format Tools Data Window Help D Sun 11:18 AM Q OOO AutoSave OFF L1_practice Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments X LE Times New Roman v 10 v A A ab Wraa Text Percentage PU v 47.0 We 4 Paste BIU O A $ %> Insert - Merge & Center Delete Y Forma: Incas Conditional Format Call Formatting as Table Styles Sort Filter Fird Select B7 Xfx A B c D F F G G H 1 j L M N o P Q R S 1 2 3 Month 4 5 Tender's Comprehensive Cash Flaws Comprehensive Cushllow for Lender (ROM) 3 4 5 6 0 1 2 7 8 9 10 11 12 (30,000) (154,597) (216,436) (386,494) (274,816) (154,597) (154,597) (154,597) (273,436) (137,678) 2,032,491 7 IRR (monthly) B IRR (annualized) 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 #1 #2 43 24 #5 A6 #7 #8 #9 #10 #11 #12 + + Ready HD + 125% w P Is 23 A