Calculate project ranking based on cashflow analysis using discount rate and cashflow intervals. Determine if projects are good, bad, or the best option.

Project Ranking based on Cashflows

Purpose

The function calculates the ranking of projects based on their cashflows, taking into account the discount rate and cashflow intervals.

Use Cases

This function can be used by businesses or individuals to compare different projects based on their cashflows and determine which project is the best investment option.

How to Use

1. Enter the cashflows for each project in the input fields.
2. Select the discount rate in percentage per year.
3. Click on the "Calculate" button to see the ranking of projects.

Input Values

1. Cashflows: Enter the cashflows for each project.
2. Description: The cashflows represent the amount of money generated or spent by each project over time.
3. Discount Rate: Select the discount rate in percentage per year.
4. Description: The discount rate is used to calculate the present value of future cashflows.

Output Values

1. Ranking: The ranking of projects based on their net present value (NPV) and internal rate of return (IRR).
2. Description: The output shows the project name, period, NPV, IRR, and overall rank (Bad, OK, Best).

Any other Instructions

• Make sure to enter accurate cashflow values for each project.
• The function will automatically calculate the ranking based on the input data.
• The best project will be marked as "Best" in the output.

Code Analysis

The function calculates the net present value (NPV) and internal rate of return (IRR) for each project based on the discount rate and cashflow intervals. It then ranks the projects as "Bad", "OK", or "Best" based on their NPV and IRR values.

Technical Parameters

• discount_rate, cashflow_interval, cashflows

Return Values

• Ranking

Example Expressions

You can use the following expressions to directly evaluate in a non-interactive manner using eva():

1. Example 1:

prjrank(discount_rate='10 pct/yr', cashflow_interval='yr', cashflows=pd.DataFrame({
    'Project1': [-40000, 5000, 8000, 12000, 30000],
    'Project2': [-25000, 3000, 5000, 25000, ''],
    'Project3': [-10000, 2000, 6000, 7000, ''],
}))

1. Example 2:

prjrank(discount_rate='8 pct/yr', cashflow_interval='yr', cashflows=pd.DataFrame({
    'Project1': [-30000, 6000, 9000, 15000, 25000],
    'Project2': [-20000, 4000, 7000, 18000, ''],
    'Project3': [-15000, 3000, 5000, 10000, ''],
}))

Click on Help icon to open the help page on a separate window.