the only thing we have to fear is fear itselfChange your mind Change your life
FAT_BEAR_room1
read my profile
sign my guestbook

Visit FAT_BEAR_room1's Xanga Site!

Name: FAT_BEAR_room1
Birthday: 7/19/1984
Gender: Male


Interests: Reading
Expertise: Analyze and Memorize
Occupation: Bank
Industry: Banking and Finance


Message: message me
MSN: fatbearroom1@hotmail.com


Member Since: 3/10/2005

SubscriptionsSites I Read
twinkle_orange
precious_joanne
grantjoe
pikpikpikwong
maxkong
Richterhui
Gunners623
katrina0927
alanwcl
Sofi_sophie
Canice51
Dick047
leungcarmen
pineey
wcytracy
kamhayfa
FanLau

Blogrings (10 of 13)
7B1 之友
previous - random - next

We are from YingLin!
previous - random - next

Chung Chi College@CUHK
previous - random - next

Wen Lin Brothers !!
previous - random - next

珍珠中的EiGeR
previous - random - next

靚蝦王~~
previous - random - next

victory in year market 132
previous - random - next

CUHK 21st Rowing 2007
previous - random - next

Big O 2005 Mattio Ricci
previous - random - next

The Chinese University of Hong Kong
previous - random - next

View all blogrings

Posting Calendar

|<< oldest | newest >>|
view all weblog archives

Get Involved!

Suggest a link

Recommend to friend

Create a site


Saturday, December 12, 2009

Today's special ~ Simple Mortgage Calculator

In EXCEL, there is a function called "PMT".
The Bank will quote the annual interest rate. Divide it by 12, we've got the monthly rate (0.00175).
Years for the payment would be 20 years. Times 12, we've got 240 payments in total.
The negative One Million represents the loan amount.



Monthly payments are divided into interest component and the principal component.
Monthly interest was calculated from the annual interest rate divided by 12, times the loan amount.
Monthly payments minus the interest component is the amount for principal repayment.
The loan amount is then reduced by this amount every month. That is why the monthly interest component will decrease with time.

The calculation for the car loan are different. We call it Flat Rate. The total interest was first calculated by multiplying the period, principal and the interest rate. And then divide it by the number of installments.
That means the total interest paid will be higher with the same quoted annual interest rate.


Sunday, October 18, 2009





Thursday, October 08, 2009

  Year-end Annual Dinners

We are in the last quarter of the year, and some of our colleagues have asked about our plan for the traditional year-end party. After considering the matter, the management felt that while the economy is showing signs of improvement, the overall financial markets remain fragile. We also note that our firm is well on the way to renewed recovery and growth, but we need to be all the more sensitive to likely market perceptions and interpretations of our actions. In light of this, the management has decided not to hold the annual year-end dinners this year. I am sure we can count on your understanding and support of this decision. It is our hope that in the near future, we will be able to bring back our tradition of coming together at the end of the year.

Warm regards,
Shengman

God bless Citibank.....


Thursday, October 01, 2009

  



Next 5 >>