Lesson 4 - Finantial and Investment Operations
Lesson 4 - Finantial and Investment Operations
Lesson 4 - Finantial and Investment Operations
PROGRAM
BACHELOR’S
DEGREE IN
MARKETING
PROFESSOR: Daniel González
ACADEMIC COURSE: 2021- 2022 (BCN)
1
BUSINESS MATHEMATICS
04
FINANTIAL AND INVESTMENT OPERATIONS
However, we used to work with annual rates. In this section, helping ourselves with concepts we
already saw in Lessons 2 and 3 we are going to find out how to obtain equivalent rates for different
periodicities (e.g., find the equivalent monthly rate given an annual rate or vice versa).
To find equivalent interest rates first we should define the capitalisation system: simple or
compound. From now on, to understand the formulas that will come next, we will use the notation
P1 for the interest rate of the period whose duration is bigger, P2 for the interest rate of the period
whose duration is smaller and n for the number of periods P2 included in P1.
For example, if we want to convert a monthly interest rate to its annual equivalent, we will have
that P1 is the annual interest rate (bigger duration), P2 is the monthly interest rate (smaller
duration) and n=12, since we have 12 months in 1 year.
Therefore, with the simple capitalisation law, we find equivalent interest rates with different
periodicities with the following formulae:
𝑃1 = 𝑃2 ∗ 𝑛
𝑃1
𝑃2 =
𝑛
𝑃1 = (1 + 𝑃2)𝑛 − 1
2
BUSINESS MATHEMATICS
𝑛
𝑃2 = √1 + 𝑃1 − 1
These equivalences will be fundamental to solve financial problems provided that in many occasions
we will need to convert the interest rate before doing some other operations.
A fundamental thing to do the correct calculations with financial operations is that the three last
variables are expressed in the same time units. This is, if the interest rate provided is annual, the
duration should be expressed in years and the periodicity (periodic payments) will be done every
year. If the initial situation does not provide us this circumstance, the rule is to use the periodicity
to determine the units of the other variables (the periodicity cannot be changed because is part of
the agreement in a financial operation but the other two can be converted). In the previous section
we have defined how to find equivalent interest rates and expressing the duration in a different time
unit is a trivial calculation.
Bank 1:
• The origination fee to get the loan equals to 0,5% of the borrowed quantity. This
quantity should be paid when the loan starts.
• To return the loan, an annual fee of 2.200€ should be paid during 5 years.
3
BUSINESS MATHEMATICS
Bank 2:
• The origination fee to get the loan equals to 1,5% of the borrowed quantity. This
quantity should be paid when the loan starts.
• To return the loan, a monthly fee should be paid during 4 years. The fee of the first
month equals to 200€ and it will be increasing 0,5% every month.
As you can see it is not trivial to compare those two options since their conditions are quite different.
Quite often, individuals asking for credit are not familiar with financial laws and, therefore, they
could be easily tricked by experts on this area. To prevent this situation, many countries force
financial entities to provide the Annual Percentage Rate (APR) of all the financial products they
offer. This rate allows the client to compare different financial products in the same fair conditions.
So, for the operation with Bank 1 the cash-flows for the client would be the following:
Today: +9.950€ (10.000€ he gets minus the 0,5% commission paid at the beginning)
Year 1: -2.200€
Year 2: -2.200€
Year 3: -2.200€
Year 4: -2.200€
Year 5: -2.200€
You may relate this formula with the NPV (Net Present Value) concept we will see in next section.
Actually, the APR is the annual rate you need to apply to make both the quantity received and the
quantity returned equivalent.
In general, isolating APR in this equation is not possible and we need to use numerical methods to
approximate it. However, there are some software able to calculate this value.
In the second example, calculations are slightly more complicated because the payments are done
monthly instead of yearly. Nevertheless, we can apply the same method to get the Monthly
Percentage Rate of this financial operation and then transform it to APR using what we learned in
Section 1.
Now, cash-flows will be the following (remember each month we pay a fee 0,5% higher than last
month):
4
BUSINESS MATHEMATICS
Today: 9.850€ (10.000€ he gets minus the 1,5% commission paid at the beginning)
Month 1: 200€
Month 2: 201€
Month 3: 202,01€
Month 4: 203,02€
…
Month 48: 252,83€
Just by solving the same kind of equation we did before we get a monthly rate equal to 0,003748.
Applying the formula in section 1:
So, the APR for this credit is 4,59% which is larger than the APR calculated with Bank 1
conditions.
Just as a comment this doesn’t necessarily mean that we should always go for the option with the
lowest APR (although it is recommended). Imagine, for example, that you want the money for an
investment that will not produce positive cash-flows until the 3rd year. Then, if one bank offers you
the possibility to postpone payments until the 3rd year while other doesn’t you may have no choice
even if the APR of this second option is lower.
As it has been said, the purpose of this APR concept is to compare different financial operations
with just one indicator in order to make it easier for people who is not used to work with financial
mathematics.
To assess whether an investment is convenient or not it makes sense to consider the present value
of all the future cash-flows that will be generated thanks to this investment and then compare it
with the initial expenditure.
Where,
5
BUSINESS MATHEMATICS
Initial expenditure: Refers to the amount of money necessary to carry out the investment
CFn: Cash-flow expected in the n-th period. It is calculated by adding the revenues and subtracting
the expenses for the whole period. Normally, the length of the periods considered is a year.
i: This item is called discount rate and the criteria to fix it is subjective and could differ from person
to person. It can be fixed, for instance, as the return expected by an investment with similar risk
(not always easy to quantify) or the return that can be obtained by an almost risk-zero operation
(easier to know).
A positive NPV is interpreted as follows: the present value of all the cash-flows generated by the
investment are larger than the initial expenditure. Therefore, this investment is advisable.
Obviously, the opposite conclusions could be drawn for negative NPV values.
Nevertheless, this criterion might be not enough to choose between two (or more) investment
alternatives. Choosing the highest NPV is not always a reasonable strategy.
Investment 1 Investment 2
Probably you would prefer to spend your money in Investment 1. The NPV is just slightly smaller
compared to Investment 2 but the difference is that initially you need to invest much less money
(i.e., investing in 1 would allow you to have 900.000€ extra to invest somewhere else).
So, this is a valid criterion to check the convenience of a particular investment or to compare two
(or more) investments with similar initial expenditures. However, to assess investments with
substantially different initial expenditures we might need another tool.
Conceptually, the IRR has the same intuition as the APR seen in Section 2. The only difference is
that IRR is used to check how profitable is the money you invest, and APR is used to check how
expensive it is for you to borrow money.
Therefore, the IRR is the discount rate at which the Cash-Flows generated by an investment equal
the initial expenditure. In other words, which rate makes the NPV equal to zero.
6
BUSINESS MATHEMATICS
As it happened in Section 2 isolating IRR from this equation is only manageable in few situations.
In general, you need a software that approximates the answer.
This figure shows the relationship of three of the components used in this Section 3 (NPV, IRR and
discount rate). As you can observe any positive NPV shows that the IRR of the investment is bigger
than the discount rate used to perform this NPV calculation. Inversely, a negative NPV indicates
that IRR < Discount rate.
The French loan is characterised by a constant fee over the whole period. This constant fee is
calculated with the following formula:
𝑖 ∗ (1 + 𝑖)𝑛
𝐹𝑒𝑒 = 𝐶0 ∗
(1 + 𝑖)𝑛 − 1
Where,
Here, it is crucial to link the i and the n with the same periodicity (i.e., if the interest is a monthly
rate the number of periods should be expressed in months while if the interest is an annual rate the
number of periods should be expressed in years).
7
BUSINESS MATHEMATICS
After calculating the fee to be paid periodically, the following table could be calculated to track the
state of the loan over the whole period. Let’s review it with an example:
C0 = 100,000€
n = 4 years
0,02 ∗ (1 + 0,02)4
𝐹𝑒𝑒 = 100,000 ∗ = 26,262.38€
(1 + 0,02)4 − 1
Now, let’s calculate some interesting values to track the state of the loan at the end of every year:
Y0 - - - 100.000
• The fee is the addition of two different concepts: part of the fee is used to pay the
interests generated by the loan and the rest is used to amortise it.
• The interests generated in every period are calculated using the interest rate over
the last pending amount available.
• The pending amount is calculated by subtracting the amount amortised in year n to
the pending amount in year n-1.
• Last column is useful in order to know which is the pending amount you would need
to pay in case you want to fully amortise the loan at any moment of time.
The American method is easier to calculate and quite different in terms of periodic payments in
comparison with the French one. Amortising a loan by this method means that during the
8
BUSINESS MATHEMATICS
established period you will only be paying interests, and at the end of that period you will return
the total amount of the quantity borrowed.
So, the only calculation that needs to be made here is the periodic payment of interests that needs
to be done. This is as easy as multiplying the quantity borrowed times the interest rate applied.
Let’s take the example on the last section to draw the amortization table:
Y0 - - - 100.000
The German method consists on a series of payments which has a common amortization fee and a
decreasing interest fee, which leads to an overall total fee which decreases over time. We will
illustrate it with the same example used in previous sections.
Obviously, the formula to calculate this constant amortization fee (do not mix it up with the total
fee) you just need to calculate the quotient between the quantity borrowed and the number of
periods:
𝐶0
𝐴𝑚𝑜𝑟𝑡𝑖𝑧𝑎𝑡𝑖𝑜𝑛 𝐹𝑒𝑒 =
𝑛
In this case:
100.000
𝐴𝑚𝑜𝑟𝑡𝑖𝑧𝑎𝑡𝑖𝑜𝑛 𝐹𝑒𝑒 = = 25.000
4
Y0 - - - 100.000
9
BUSINESS MATHEMATICS
To calculate the values of the different columns the same logic used for the French method holds.
However, now the constant item is the amount amortised (not the Total Fee) while the item you
need to calculate is this Total Fee (not the amount amortised). As you can observe, this method
implies decreasing total fees over time.
10