how do I make a 10 year proforma and find npv, IRR and levered and unlevered cash flows

How do i find the npv and IRR and leverage and unleveraged cash flows. and a 10 year proforma

- Total acquisiton price: 91,000,000 - 288 Units, $316,000 per door, average rent per door is 1,698/ unit - Last sold in 2014 for 65,000,000 - Vacancy is 5% per year|(14 vacant units) - Annual market increase is 1.7% per year - Operating expenses: 3% of EGI - Expecting holding period is 10 years - Expecting to sell year 11. NOI Cap 5.75\% - Selling expenses in year 103% - First Mortgage 70% LTV - Annual Mortgage Interest is 6% - Amortization period is 30 years with monthly payments - Required 8% rate of return - DSCR 1.25 (we would pay all the debts back) Units Lease Compo Salo Tenant Analytics : Loan Financlals Changos Demographics Publo Rocord Contacts lmages Map My Data News Sale Unit Mix > Sold Price Doto Sule Type Building 590,926,1775 (\$5316,818Una1) Sn 2022 inveimert Type 4 Star Mis.-ino Agartmente location Uitan UnhaAvgUntsizeSiories280oenSF6 Teest s7atrana (2021) Wis soore Somentar Wokacie (53) Thanch foorede Some Tanal (op) Fannohefie: 1.3ounh Paikng Tope Seaces Surtace 400 Sale Unit Mix larket Financials thowing financials for this Market (Allanta - GA, Mult-Family). Other lncome Elfectlve Gross Income $12,878.04 $14,295,06 $13,749.39 OPERATWG EXPENSES: Real Estate Taxes Property insurance Utition Aepairs and Maimterance Jaricorial Management Fees Payroll 4 Benefits Adrottaing \& Marketng Proluteional Foes Genera A Admirlatraive Otrer Expenses Goound Rerd Total Operating Expenpes 36.267.03 16.363.2t Openting Eacense Fimto (H) 4e zie Net Operating income 14.9pe.is \$7,23.45 Dther Expenses Total Operating Expenses $5,537.73 $6,267.83 $6,363 Operating Expense Ratio (w) 43.00 43.85 Net Operating Income 56,996.15 $8,027,23 $7,399,45 CAPITAL ITEMS: Capitar Expenditures Extrordinary Capital Expondnures 51,10579 $79.09 51,147.23 560312 Not Cash Flow 96,497,36 (5T. 233.43 55.002 .16 NOI DSCR 207 23 2.07 ree beca occupancy Rade (7) - Total acquisition price: 91,000,000 - 288 Units, $316,000 per door, average rent per door is 1,698/ unit - Last sold in 2014 for 65,000,000 - Vacancy is 5% per year/(14 vacant units) - Annual market increase is 1.7% per year - Operating expenses: 3% of EGI - Expecting holding period is 10 years - Expecting to sell year 11. NOI Cap 5.75% - Selling expenses in year 103% - First Mortgage 70\% LTV - Annual Mortgage Interest is 6% - Amortization period is 30 years with monthly payments - Required 8% rate of return - DSCR 1.25 (we would pay all the debts back) - Total acquisiton price: 91,000,000 - 288 Units, $316,000 per door, average rent per door is 1,698/ unit - Last sold in 2014 for 65,000,000 - Vacancy is 5% per year|(14 vacant units) - Annual market increase is 1.7% per year - Operating expenses: 3% of EGI - Expecting holding period is 10 years - Expecting to sell year 11. NOI Cap 5.75\% - Selling expenses in year 103% - First Mortgage 70% LTV - Annual Mortgage Interest is 6% - Amortization period is 30 years with monthly payments - Required 8% rate of return - DSCR 1.25 (we would pay all the debts back) Units Lease Compo Salo Tenant Analytics : Loan Financlals Changos Demographics Publo Rocord Contacts lmages Map My Data News Sale Unit Mix > Sold Price Doto Sule Type Building 590,926,1775 (\$5316,818Una1) Sn 2022 inveimert Type 4 Star Mis.-ino Agartmente location Uitan UnhaAvgUntsizeSiories280oenSF6 Teest s7atrana (2021) Wis soore Somentar Wokacie (53) Thanch foorede Some Tanal (op) Fannohefie: 1.3ounh Paikng Tope Seaces Surtace 400 Sale Unit Mix larket Financials thowing financials for this Market (Allanta - GA, Mult-Family). Other lncome Elfectlve Gross Income $12,878.04 $14,295,06 $13,749.39 OPERATWG EXPENSES: Real Estate Taxes Property insurance Utition Aepairs and Maimterance Jaricorial Management Fees Payroll 4 Benefits Adrottaing \& Marketng Proluteional Foes Genera A Admirlatraive Otrer Expenses Goound Rerd Total Operating Expenpes 36.267.03 16.363.2t Openting Eacense Fimto (H) 4e zie Net Operating income 14.9pe.is \$7,23.45 Dther Expenses Total Operating Expenses $5,537.73 $6,267.83 $6,363 Operating Expense Ratio (w) 43.00 43.85 Net Operating Income 56,996.15 $8,027,23 $7,399,45 CAPITAL ITEMS: Capitar Expenditures Extrordinary Capital Expondnures 51,10579 $79.09 51,147.23 560312 Not Cash Flow 96,497,36 (5T. 233.43 55.002 .16 NOI DSCR 207 23 2.07 ree beca occupancy Rade (7) - Total acquisition price: 91,000,000 - 288 Units, $316,000 per door, average rent per door is 1,698/ unit - Last sold in 2014 for 65,000,000 - Vacancy is 5% per year/(14 vacant units) - Annual market increase is 1.7% per year - Operating expenses: 3% of EGI - Expecting holding period is 10 years - Expecting to sell year 11. NOI Cap 5.75% - Selling expenses in year 103% - First Mortgage 70\% LTV - Annual Mortgage Interest is 6% - Amortization period is 30 years with monthly payments - Required 8% rate of return - DSCR 1.25 (we would pay all the debts back)