Username:   Password:   
   
   Investment & Money Forum
Index  FAQ  Search  Memberlist  Usergroups  Profile  Register
 Log in to check your private messages
calculation pension fund investment yield (excel)
  Post new topic   Reply to topic x-investment-x.com Forum Index » General Investment & Money Forum     
Message
Pulse     Reply with quote
A pension fund is making an investment of $100,000 today and expects to receive $1500 at the end of each month for the next five years.At the end of the fifth year, the capital investment of 100000 will be returned? What is the investment yield? l used excel and got 18%,but when using a investment yield calculator l get 13.% Can someone help?
Cool     Reply with quote
Firts of all, $1500 times sixty months (5 * 12) will get you an extra $90,000. At the end of the fifth year only $90,000 will be returned, NOT the full 100,000!
You're getting a 1.5% interest increase each month, or a 18% annual increase.
electrode     Reply with quote
Since the entire 100k will be returned at the end of the period, the '5 years' is irrelevant..

If u r going to get the entire 100k back, then 100k has to generate 1,500 in one month, & has to do this every month for as long as u care to leave it invested.

Simple yield is thus 1,500/100,000 * 12 = 18%.

To calculate AER (Annual Equivalent Rate) u have to assume that the 1500 is not withdrawn ie. that after the first month, the 1500 will be added to the investment for the second month & so on for the second etc.

After 12 months u will have 119,561.82 in the account (rather than 118,000)

This gives an AER of 19.56%
Melody     Reply with quote
Dear friends:
We r a large internet trade wholesaler,we have got many kinds of products ready for export, which includes shoes, handbags, garments, jewellery,watch,jeans & millions of accessories, & the brand varies as Nike, Jordan, Gucci, Prada, Puma, D&G,UGG,Abercrombie & Fitch, Rolex, Cartier, Diesel, Raulph Lauren, Lacoste,G-star, Tommy Hilfiger, Levi's..
Both wholsale & retail orders accepted.More discounts for larger orders.
Any need, please contact us either on website or by MSN.
Website: http://ebuy-lucky.com (accept paypal)
MSN: happylyshoppinghotmail.com
E-mail: happylyshoppinghotmail.com
Display posts from previous:   
  Post new topic   Reply to topic x-investment-x.com Forum Index » GeneralInvestment & Money Forum     

Lates Messages
Powerful trade unions (trading blocs)
If you have a $100,000,how should you invest that money
How do you do your trading?
I have just inherited 2000 acres of land in india (150 kms fm mumbai) and want a suggestion for a mega projec
What are good stocks to invest in ?
which one is the best forex signal software to use in forex trading
what is the difference between quoted shares and listed shares
I want to invest for my 2 year old daughters future, any ideas
how can i set ticker of NSE at my desktop, i want from google desktop
Which way is feasible for trading stocks and shares.... online trading or through brokers
stock market question
Buying Stocks
where can i find market values of shares of companies in may 2008 (each day) in BSE or NSE
What is the present value of an annuity of $900 per year for 14 years (with the first payment to be made?
CBS News Segment few years ago Gas Lock in Investment.
Dow & crude oil future at expiration
Please state the value of i and n for the following situation A=P(1+i)^n
Explain how HOD DUG short oil, percentages, etc.
EXPLAIN two ways in which a company can generate internal funds to support sales growth
If I just turned 18 and live in NJ can I have my moms custodian name taken off of my college money account
how mch the nokia5310 in kuwait dinar
If there is a 2 for 1 stock split accomplished through a stock dividend, do you pay taxes on the stock div
HI everybody.i dont know ABC of shares.
math question
How can we find out the name of the person recently gave my chldren very generous Patriot EE Bonds?
Gold Future contract
where i can check my status of reliance power demat account
What is the stock that used to be alcan called now?
what is the future of relience power equity
law of diminishing marginal utility
i want to all ratio list of sbi (latest) early
I am 41 & still do not have a retirement plan. What are the options ? Please elaborate.??
How to invest my money.?
More Endless Questions About Investing Money... (Sigh)
If you made 10,000 dollars per day, what would you do with it
Candlestick chart app and a source of historical market data
Is anyone know which one is Natural Gas stock?
Investment Explanations..please help!
commodity broker in India
Question on stocks!?!?
Help With stocks and Etrade
what games will be out of stock when they come out
Is it possible for Canadians to open an ingdirect sharebuilder account?
What is Nasdaq? I understand it's a "benchmark but what does that mean??
This week ending June 13 i noticed that mortgages went up. What do u think next week? The market was up today??
how much would 100 shares of bob evans stock purchased in 1985 be worth
Stock basics
How much per share did PBR pay as dividend this past Monday?
Is it illegal for a broker to execute a market stock order not on the same day?
First potential investment.....ideas
rubber horse mat forums , stove hoods forums , credit counseling services forums , credit card for students forums , consolidation loan forums , commercial coffee machine forums , chanel sunglasses forums , cement industry forums , ceiling grid forums , carbon steel pipe forums , calcium carbonate forums , ca hats forums , buy health insurance forums , building material forums , bottled water forums , best quality forums , bedding sets forums , bathroom mosaic forums , banking forums , baby care forums , aig insurance forums , advertising products forums , adhesive tape forums , insurance lead forums , insulation materials forums , injection parts forums , health insurance quote forums , glass bathroom furniture forums , furniture glass forums , fico score forums , feed mill forums , debt loan forums , curtain wall forums , credit resources forums , radiator support forums , projection screen forums , pet beds forums , motorcycle insurance forums , letter of credit forums , led lights forums , leather products forums , laminate flooring tile forums , york mortgages forums , water heater forums , used machine forums , truck parts forums , textured glass forums , stone cutter forums , sodium carbonate forums , soda ash forums ,



You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum