Post by Old Regional Reserve - CTE on Feb 6, 2019 1:14:11 GMT -5
Certificates of Deposit- General Guidelines and Rules
Who is eligible?
Any Active Account Holder (Individual, Business, or Stock), whom has an open thread here Shop Purchase Thread
Types of CDs and Limitations
Small CDs | Large CDs | |
Minimum: | 1,000₸ | 100,000₸ |
Maximum: | 100,000₸ | 500,000₸ |
Increments: | 500₸ | 5,000₸ |
Terms
RL Terms | NS Terms |
2 months (RL) | 1 NS years |
3 months (RL) | 2 NS years |
5 months (RL) | 5 NS years |
10 NSyears |
NS years time will be decided based on this explanation: 10000islands.proboards.com/thread/5793/nationstates-relative-time
We have devised the following formula for the regional reserve sheet to determine maturity date for CDs:
IF(OR([@Term]="2 RL",[@Term]="3 RL", [@Term]="5 RL"),EDATE([@[Start Date]],IF([@Term]="2 RL",2,IF([@Term]="3 RL",3,IF([@Term]="5 RL",5,0)))),IF(OR([@Term]="1 NS",[@Term]="2 NS",[@Term]="5 NS",[@Term]="10 NS"),[@[Start Date]]+IF([@Term]="1 NS",20,IF([@Term]="2 NS",40,IF([@Term]="5 NS",100,IF([@Term]="10 NS",200,0)))),"N/A"))
EDATE is a pure increase of months. For NS Dates - 1 NS will be 20 days, 2 NS will be 40 days, 5 NS will be 100 days, and 10 NS will be 200 days. While there is a bit of wobble in relationship to the RL year, We felt this was a consistent rule that is able to applied uniformly for the purpose of applying interest and calculating maturity.
Rate of interest
Small CD | Large CD |
2% per NS Year | 3.5% per NS Year |
The interest is compounded yearly (1 NS Year) by the Regional Reserve. Here is the code:
=MROUND(IF([@[Opt.]]="Large",IFS([@Term]="2 RL", [@Amount]*(1.035^3),[@Term]="3 RL",[@Amount]*(1.035^4.5),[@Term]="5 RL", [@Amount]*(1.035^7.5),[@Term]="1 NS", [@Amount]*(1.035^1),[@Term]="2 NS", [@Amount]*(1.035^2),[@Term]="5 NS", [@Amount]*(1.035^5),[@Term]="10 NS", [@Amount]*(1.035^10)),IF([@[Opt.]]="Small",IFS([@Term]="2 RL", [@Amount]*(1.02^3),[@Term]="3 RL",[@Amount]*(1.02^4.5),[@Term]="5 RL", [@Amount]*(1.02^7.5),[@Term]="1 NS", [@Amount]*(1.2^1),[@Term]="2 NS", [@Amount]*(1.02^2),[@Term]="5 NS", [@Amount]*(1.02^5),[@Term]="10 NS", [@Amount]*(1.02^10)),"N/A")),5)
Maturity and Payment
Your payment will come at the end of the term of maturity which is determined by your application. Once you chose a type of CD with the requisite interest rate you cannot change it. When you apply and are approved the Reserve will state in the acceptance your Maturity Date which will be the date you are given all funds, unless you picked the Renewable Option on one of the CDs. Renewable CDs will be paid out the accrued interest and retain over the initial deposit. Renewable CDs shall renew into a non-renewal CD automatically.
Penalty
Early Withdraw Penalty if withdraw occurs prior to maturity date. Small CD = 25% of the CD value is forfeit to the Regional Reserve at withdraw
Large CD= 50% of the CD value is forfeit to the Regional Reserve at withdraw.
The individual must state in writing that they are withdrawing a CD. Private Message the Regional Reserve account in this scenario.
Estate
Payable on Death (Ceasing To Exist); May name upto 3 beneficiaries to spit the CD in the event the main account holder CTE's prior to maturity of the CD. Any remaining beneficiaries who have not CTE'd will recieve the split of the CD at maturity. If a beneficiary is unnamed the CD shall be applied to the account holder's extant will, and may delay the settlement of an estate until maturity. Certificate of Deposit Application
Cut and paste this application into a new post below and fill it out:
[center]Certificate of Deposit Application[/center]
1. Please list each type of CD you want (small or large). List the term you want for each CD ( see above guidelines):
2.Are you applying as a business or individual? (Please state the name of the business if applying as one):
3. Do you want any of the CDs to have the renewable option?:
4. Please describe any beneficiaries you want to receive your funds should you CTE (this is optional):
Please note that you must send the appropriate amount of money for [i]each[/i] Certificate of Deposit to the Regional Reserve.
I, (name here), understand that there is a Early Penalty Withdraw Fee and that any early withdraw will significantly takeaway from the value of the Certificate of Deposit.
Submittal of this application will immediately notify: @royaleuramathania and @regionalreserveii
Certificate Holders:
Certificate Holders Paid:
Updated : September 21st, 2019
1. Jabberwocky
1 large CD 101,000 Tacos; Maturity Date: July 6, 2019, no renewal - 130,730 Tacos Paid 7/6/2019.
2. Sargon Reman
1 large CD 250,000 Tacos; Maturity Date: August 24th, 2019, no renewal - 352,650 Tacos Paid 8/26/2019.
3. Baden-Wuerttemberg
1 Large CD 250,000 Tacos; Maturity Date August 25th, 2019, renewal - 102,650 Tacos Paid 8/26/2019.
4. Taco Island Charities
1 Large CD 250,000 Tacos; Maturity Date August 25th, 2019, renewal - 102,650 Tacos Paid 8/26/2019.
5. Taco Island Charities
1 Large CD 250,000 Tacos; Maturity Date August 25th, 2019, no renewal - 352,650 Tacos Paid 8/26/2019.
6. Taco Island Charities
1 Large CD 250,000 Tacos; Maturity Date August 25th, 2019, no renewal - 352,650 Tacos Paid 8/26/2019.
7. Paffnia
1 Large CD 250,000 Tacos; Maturity Date August 31st, 2019, no renewal - 352,650 Tacos Paid 9/20/2019.
8. Paffnia
1 Large CD 250,000 Tacos; Maturity Date September 13th, 2019, no renewal - 352,650 Tacos Paid 9/20/2019.
9. Woonsocket
1 Large CD 250,000 Tacos; Maturity Date September 14th, 2019, renewal - 102,650 Tacos Paid 9/20/2019.
10. Woonsocket
1 Large CD 250,000 Tacos; Maturity Date September 14th, 2019, no renewal - 352,650 Tacos Paid 9/20/2019.
11. Woonsocket
1 Large CD 250,000 Tacos; Maturity Date September 14th, 2019, no renewal - 352,650 Tacos Paid 9/20/2019.