Sheet1
|
|
|
|
|
|
Please enter values in Orange Cells only
|
|
|
|
|
|
|
|
|
|
Year
|
1
|
2
|
3
|
|
Month
|
Monthly Saving
|
Monthly Saving
|
Monthly Saving
|
|
Year Begin Balance
|
HK$0
|
HK$12,809
|
HK$40,053
|
|
Jan
|
HK$1,000
|
HK$2,000
|
HK$2,000
|
|
Feb
|
HK$1,000
|
HK$2,000
|
HK$2,000
|
|
Mar
|
HK$1,000
|
HK$2,000
|
HK$2,000
|
|
Apr
|
HK$1,000
|
HK$2,000
|
HK$2,000
|
|
May
|
HK$1,000
|
HK$2,000
|
HK$2,000
|
|
Jun
|
HK$1,000
|
HK$2,000
|
HK$2,000
|
|
Jul
|
HK$1,000
|
HK$2,000
|
HK$2,000
|
|
Aug
|
HK$1,000
|
HK$2,000
|
HK$2,000
|
|
Sep
|
HK$1,000
|
HK$2,000
|
HK$2,000
|
|
Oct
|
HK$1,000
|
HK$2,000
|
HK$2,000
|
|
Nov
|
HK$1,000
|
HK$2,000
|
HK$2,000
|
|
Dec
|
HK$1,000
|
HK$2,000
|
HK$2,000
|
|
|
|
|
|
|
Average Annual Return (%)
|
12.00%
|
12.00%
|
12.00%
|
|
End of the Period
Balance (HKD)
|
HK$12,809
|
HK$40,053
|
HK$70,751
|
|
|
|
|
|
|
Assumptions:
|
|
|
|
|
Monthly Saving is deposited into the investment account in the beginning of each month
|
|
|
|
|
All the saving is reinvested in the Average Annual Return (%)
|
|
|
|
|
Investment period is 36 months and withdrawal is only allowed at the end of the 36th month
|
|
|
|
|
Transaction, Brokerage and Management fee are assumed to be negligible
|
|
|
|
|