Financial Projections and Capital Amortization
Financial Projections and Capital Amortization
Financial
Projected
The projections of the Financial Statements aim to
show in advance the impact that the situation will have
financial and the outcome of the future management of the company to
include operations that have not been carried out.
1
Fixed Assets
Investments Working Capital
Pre-operative
Variables
EXPENSES Costs
Fixed
Administrative
Expenses Sales
Distribution
DLR(VA–VS)/n
Where:
DLRDepreciation by straight-line method
VAAcquisition value of the asset
VSSalvage value of the asset
They refer to the necessary expenses for
operate the business, the most important concepts
common:
AD(j) = (GPO/5)
WHERE:
Amortization of deferred items in the period
j;
GPO : Gastos pre-operativos y
They are basically composed of two rubles,
which are related to financing
what suppliers and financing offer
what is obtained from the financial sector.
Interests about
bank loans
4
AMORTIZATION OF CREDITS
BANKING
In practice, different are used.
forms of loan amortization,
the most common are:
Constant principal repayment plan.
Constant installment plan.
Increasing payment plan or
decreasing arithmetically.
Growing installment plan or
decrecientes geométricamente.
PLAN OF CONSTANT SUBSCRIPTIONS TO
CAPITAL
To illustrate this type of amortization, the following example is used:
Find the amortization schedule for the loan of $155,000,000 for which
equal capital payments are agreed for 3 years, with an effective interest
annual of 30%. QUOTE CREDIT OF
PERIOD INTERESTS BALANCE
SEMESTRAL CAPITAL
0 155,000,000
1 98,166.666 46,500,000 51,666.666 103,333.334
2 82,666.666 31,000,000 51,666.666 51,666.668
3 67,666,666 15,500,000 51,666.666 2
. The repayment of the principal is calculated as the value of the debt divided by
for the number of periods
. The fee is calculated as the sum of the principal fee plus the
intereses
PLAN OF CONSTANT INSTALLMENTS
It consists of making constant payments in each
one of the agreed periods for the
debt cancellation. For the preparation of
the amortization table must refer to the
financial mathematics, particularly to the
formulation that allows determining the Vp of
a constant fee for an interest (i) during
in periods
Vp = A[ ( 1 - (1 + i)-n) / ( i )
PLAN OF CONSTANT INSTALLMENTS
To illustrate this type of amortization, the following example is used:
Find the amortization plan for the loan of $30,000,000 for which
agreement for equal capital payments over 6 semesters, with effective interest
6%.
annual del1PERIOD QUOTA CREDIT OF
INTERESTS BALANCE
O SEMESTRAL CAPITAL
0 30,000,000
1 8,141,696.11 4,800,000.00 3,341,696.11 26,658,303.89
n(1+i)-n]
The 2nd semiannual installment is calculated as A+100,000; the 3rd as A+2(100,000); the 4th
like A+3(100,000) and so on.
GROWING INSTALLMENT PLAN OR
Geometrically decreasing
For this payment method, the installments for each
periods are agreed upon in an increasing or decreasing manner.
Each installment is formed by increasing or decreasing by
a percentage of the previous fee.
Resorting to financial mathematical formulation, in
particularly the one that relates Vp with an increasing fee
geometric for an interest (i) during n periods
Vp = A[((1+t)/(1+i))n-1]/(t-i); if t ≠ i
Vp = An / (1+i); if t = i
GROWING INSTALLMENT PLAN OR
Decreasing geometrically
To illustrate this type of amortization, the following example is used:
Find the amortization plan for the loan of $30,000,000 for which terms are agreed
equal capital payments for 6 semesters, with an annual effective interest rate of 16%
and gradient
PERIODt=12% QUOTE PAYMENT OF
INTERESTS BALANCE
O SEMESTRAL CAPITAL
0 30,000,000
1 6,320,454.41 4,800,000.00 1´520.454,41 28,479,545.59
2 7,078,908.94 4,556,727.29 2´522.181,64 25´957.363,95
3 7,928,378.01 4,153,178.23 3,775,199.78 22,182,164.17
4 8´879.783,37 3,549,146.27 5,330,637.10 16,851,527.06
5 9´945.357,38 2,696,244.33 7,249,113.05 9,602,414.02
6 11,138,800.26 1,536,386.24 9,602,414.02 0
0 1 2 3 4 … n-1 n
Cash Outflows
FLOW CHART OF
PROJECT
OPERATION MOMENT
0 1 2 3 4 … n-1 n