Financial Metrics - Present values

Financial Metrics Example: Investments' return rate & value

This is a business case example of the use of 5 financial metrics components in order to measure the profitability and the value of some investment projects.

The business case:
Imagine you are a firm that wants to invest in 3 different ways.
One way is to begin building an orchid, and for that you plan 3 different projects for which the costs and returns are not regular.
The second and third ways are different financial investments.
The second is in form of several regular monthly investments projects while the third one is in in the same form but you have the aditional information of knowing the cost of the capital and at which rate the returns will be reinvested.

After getting the data of the investment projects, which stocked into different excel file, congregated into three different flows devided by type of investments as previously described we begin begin enriching it with the computation of the financial formulae.

In the end we have an overview of all the projects with the return rate and NPV for each of them and two visualizations to have a ranking of which are the best investment opportunities for the firm in the case.

External resources

• Check out the nodes and other workflows developed by Mydral
• For more info and support, contact Mydral