add content to your website should include text images , videos and other media that is relevant to your audience and support your goals. - 02/03/2023 00:49 EST
Budget: ₹100 – ₹400 INR
Open a new Excel spreadsheet.
Create the following headers in cells A1 through E1: "Investment amount," "Monthly income," "Term," "Investor % of monthly income," and "IRR."
Input the relevant data into the appropriate cells. For example, in cell A2, input the total investment amount, in cell B2, input the monthly income, in cell C2, input the term in years, in cell D2, input the investor's percentage of monthly income, and in cell E2, leave it blank for now.
In cell E2, enter the following formula to calculate the net cash flows of the investment: =-A212(1-D2/100)+B212D2/100/(1+(IRR(B3:B36512+(-A212*(1-D2/100)+B212D2/100))/A2))^C2.
Press Enter. This will give you the IRR for the project.
Create the following headers in cells A1 through E1: "Investment amount," "Monthly income," "Term," "Investor % of monthly income," and "IRR."
Input the relevant data into the appropriate cells. For example, in cell A2, input the total investment amount, in cell B2, input the monthly income, in cell C2, input the term in years, in cell D2, input the investor's percentage of monthly income, and in cell E2, leave it blank for now.
In cell E2, enter the following formula to calculate the net cash flows of the investment: =-A212(1-D2/100)+B212D2/100/(1+(IRR(B3:B36512+(-A212*(1-D2/100)+B212D2/100))/A2))^C2.
Press Enter. This will give you the IRR for the project.