Case Study Of An Investment Analysis:
ASB
Disclaimer. This is my independent personal finance research, author does not take responsibility for any usage of the data. - Syaiful-
Hipotesis
Investment
Directly Through Monthly Consistent Cash Amount Is Better Than Investment Using
Loan.
Methodology
a)
FV OF ONE TIME INVESTMENT
Assumption:
1.
Based on one time investment
with return of 8% per annum, with consistent and discipline monthly loan
payment as stated below.
2.
The dividend per annum will not
withdraw and will attract next year dividend (compound interest).
3.
Future value (FV) show the
amount after certain period of the year invested as stated below.
The calculation
based on these formulas:
FV = A
(1+i)^t
ASB LOAN
|
20
yrs
|
25
yrs
|
30
yrs
|
|||
FV = A (1+i)^t
|
LOAN AMOUNT PER MONTH
|
FV
BASED ON 8% DIVIDEND
|
FV
BASED ON 8% DIVIDEND
|
FV
BASED ON 8% DIVIDEND
|
||
A= Investment
|
i = interest/ dividend
|
|||||
30,000.00
|
199.00
|
139,828.71
|
177.00
|
205,454.26
|
155.00
|
301,879.71
|
50,000.00
|
332.00
|
233,047.86
|
294.00
|
342,423.76
|
256.00
|
503,132.84
|
100,000.00
|
658.00
|
466,095.71
|
582.00
|
684,847.52
|
506.00
|
1,006,265.69
|
150,000.00
|
990.00
|
699,143.57
|
876.00
|
924,544.15
|
762.00
|
1,509,398.53
|
180,000.00
|
1,189.00
|
838,972.29
|
1053.00
|
1,164,240.78
|
917.00
|
1,811,278.24
|
200,000.00
|
1,316.00
|
932,191.43
|
1164.00
|
1,369,695.04
|
1012.00
|
2,012,531.38
|
b) FV OF AN ANNUITY
Assumption:
1.
Based on investment with return
of 8% per annum, with monthly installment the same as ASB loan above. It means
no loan involve, just save certain amount of money (we assume same as per
amount required for ASB loan) every month into ASB book.
2.
The dividend per annum will not
withdraw and will attract next year dividend (compound interest).
3.
Future value (FV) show the
amount after certain period of the year invested as stated below.
The calculation
based on these formulas:
FV = A [(1+i)^t-1/i]
Investment
|
20 YRS
|
Investment
|
25 YRS
|
Investment
|
30 YRS
|
A (MONTHLY)
|
FV
|
A (MONTHLY)
|
FV
|
A (MONTHLY)
|
FV
|
199.00
|
109,279.57
|
177.00
|
155,277.02
|
155.00
|
210,706.77
|
332.00
|
182,315.67
|
294.00
|
257,917.76
|
256.00
|
348,006.02
|
658.00
|
361,336.47
|
582.00
|
510,571.88
|
506.00
|
687,855.66
|
990.00
|
543,652.14
|
876.00
|
768,489.64
|
762.00
|
1,035,861.68
|
1,189.00
|
652,931.71
|
1,053.00
|
923,766.66
|
917.00
|
1,246,568.46
|
1,316.00
|
722,672.94
|
1,164.00
|
1,021,143.77
|
1012.00
|
1,375,711.32
|
No comments:
Post a Comment