 Is it a bad idea to go bankrupt? |
What is the process, will i never be able to get credit again? will i ever have a mortgage?
All answers much welcome.... |
|
 How can i make 200 dollars in a week? |
| Help! Im in college right now, without a job and with only $50 in my pocket.I need $200 dollars to fix my car, and i need it in a week so that i can be able to go home for the summer. Is there any ... |
|
 What happens to the money after I die? |
| I have a savings account that I put in trust for my daughter. What happens with the money when I die and she's still a minor?... |
|
 I need $50 fast so that I don't bounce a check. What can I do w/ in 24 hrs? |
| I have thought of ebay, but I probably won't get the money in time even with a 24 hr. auction. It is raining, so no go on a yard sale. I have posted for sale items and for babysitting on ... |
|
 Get a car or a house? |
| I'm in point of my life where i have to choose from a house or a new car. My delima is, i need a new and reliable car to get to work in. My car is my asset, and i drive a good amount of miles. I ... |
|
 Can I have a dollar? |
Additional Details
neilb_81 - lol ... |
|
 Job on net????????? |
| hi im a full time mum but want to earn some extra cash i have tried to go to different web-sites but no good, can some one help me with thier brilliant ideas or wat else i can do from home.... |
|
 Can you legally host a fundraising event (i.e. golf tournament) for the sole reason of individual profit? |
Is it ethical?
If you do all the planning, financing, and preparation...and everyone has a great time...can you make a huge profit off of an event that makes more money that you put in?
Do ... |
|
| PLEASE HELP!!! how do you budget? |
i bring home $1000.00ish CDN every two weeks, and i am broke all the time, how do i budget?
i would like to save about 5k by jan 07. for a down payment on a house, but i am having a hard time to ... |
|
 I won an auction on ebay, but i decided i didn't want it because i didn't read it carefully, what should i do? |
I know it was my fault for not reading the description carefully.
I won an auction on ebay and i would like to cancel my bid, is this possible? I would like to cancel my bid and avoid ... |
|
 Do I make good money for my age? |
I am a sales engineer for a robotics company. I am 27 (almost 28 years old).... Associates degree and 8 years work experience. I make around 45k a year. (23/hr)
Is this a good wage?
... |
|
 Am I overreacting - should I cosign loan for sister? |
Hello,
My sister who is 10 years old than me, I'm in my 20's wants me to cosign a loan for her for a car. The car is only going to be $100-$200 per month in payments. She says ... |
|
 Make money online? |
websites where i can take qizzes or questionairres to make mney?
Additional Details
calfritch- thanks 4 the advice! i amhaving a friend who knows more about this stuff then i do look at ... |
|
 What kind of credit card is the best to get when I don't have 2 much credit and I don't own any credit cards?? |
| Obviously I don't want it to have 2 many fees, but I've never gotten a credit card before and I want to make the best decision possible.... |
|
|  |
Ivri_Anokhi | How do I calculate whether to take monthly pension payments or a lump sum and invest it myself? |
I have the choice of monthly pension payments or taking a lump sum. I need to calculate, based on a certain interest rate, how many years I could invest the lump sum and take monthly payments, until it runs out.
This is another way of saying that I wish to calculate how long I would have to live in order for it to be worthwhile to receive monthly pension payments rather than take a lump sum.
Is there a built-in function in Microsoft Excel for calculating this?
.
Additional Details
To clarify, I wish to assume no taxation in any event, and I can add in the taxation details at a later stage. What I am looking for is a formula for calculating the remaining capital (including accrued interest) after every monthly payment that I take from a one-time investment, until the balance reaches zero. To simplify matters, I can make do with just the amount of time until the money is depleted.
I would be pleased to receive a formula that I could use in Excel. |
 |
 
Arafat
 |
I don't have an answer, but just several comments.
The fellow has asked for a formula. Only one answerer has tried to supply one, and that appears not to be applicable.
Two opposite recommendations have been given, with no expressed doubts: take the lump sum, and don't even dream about taking the lump sum.
Can't anyone supply a method of calculation?
Here's an idea. Find a company that will sell you an annuity. Supply your age and the lump sum amount, and see what sort of annuity you can buy for that amount.
If you are being offered a monthly payment greater than that, you should take the monthly payment option. |
|
Silke
 |
You are not providing enough information to answer properly.
In general it is best to commute as much of your pension as you can and take a lump sum, because the lump sum is the only truly tax free money you'll get. If you took everything as a regular monthly pension payment you will be taxed on this.
Problem is you will have to be careful with the money you take as a lump sum as you'll have to live on it.
Most people have to buy an annuity with the money they leave to pay a pension. If everyone in your family lives to 105 and you expect to also. It might be worth looking at the pension option.
You need to take advice which is based on all the information. |
|
mudd0gg
|
Certain rules apply to each pension provider i.e. are you gettinh 25% tax free and then the rest as a pension? or do you qualify for the full lump sum i.e. under a certain amount and you are over a certain age? i would base it on how much it taxed of the lump sum then see if the same tax rules apply for the monthly/annual payments |
|
luckyzimmy
|
Here is a very simple alternative. Figure what a 6% return on the lump sum will bring you. You can have that guaranteed for as long as you live with some growth potential in addition.
Compare that to the monthly pension alternative and then decide.
If you would like further explanation, let me know at
info@safemoney-plus.com |
|
Richard M
|
It may be a good idea to seek assistance by a Independant Financial Advisor. |
|
radar
|
Don't even think of a lump sum.
These plans are devised by crooks with their interests in mind not yours. |
|
Steve B
 |
Invest some time and energy in GETTING IT RIGHT - because some decisions (Annuities) made now CAN NOT BE UNDONE, EVER !
You have exactly the right idea Re: spread-sheeting it ...
First you need to get hold of sufficient information to discover the facts - for sure you need the following :-
(Full Pension= without taking Lump Sum, Reduced Pension = after taking 25% Tax Free Lump Sum)
1) Transfer Value (if you want to think about moving the Pension into a SIPP and managing it your self either because you don't want to Retire now or because you want to avoid taking an Annuity now i.e. move into Draw-down) - see link below (NB DO NOT get ripped off by some 'Financial Consultant' - you can sort out your own SIPP without needing to 'donate' 5% of your Pension Fund to some moron from the City)
'Full Pension'
2a) What Annuity are they offering ? (and is this level or with RPI (or other) annual increase ?)
2b) What is the Open Market Option ? (this lets you judge if you would be better off getting an Annuity for another supplier === often YES (but you need to compare 'like for like' - eg. RPI annuity with RPI annuity).
NOTE - if you health is bad you might be able to get an Enhanced (Life Impaired) Annuity ...
'Reduced Pension' - you need the same 2 figures for Annuity after the lump sum
3a) & 3b)
NOTE - Pension is INCOME so will be Taxed if your total Income exceeds your annual personal Allowance (typically £5,200 / year) - so taking the Tax Free Lump Sum may reduce your Tax bill ...
Other things to consider - when you die the Annulity dies along with you (unles you die within the 'guaranteed' part of a guaranteed annuity - typically first 5 years, and unless your annuity includes a spouses pension (which will usually pay out at reduced rate - sometimes known as 'joint life') - whilst the 25% Tax Free lump sum is yours to do what you like with (eg. put into an ISA and use to generate extra (tax free) income in the future).
Spreadsheet your 'take home' Income.
w/o Lump Sum it's Full Pension Annuity minus Tax.
with Lump Sum payment, it's Reduced Pension Annuity - Tax PLUS however much of the Lump Sum you are going to 'consume' as a 'top up' each year
(as a 'ball park' you could assume 8% - this would be made up of approx 5% growth & 3% capital)
If you really want to Spreadsheet 'total retun' i.e. untill you die, you will need to check out Mortality Tables for your age - these are available off the web, but are out-iof-date (you can assume you will live longer that the predicted 'average').
To calculate NPV you will need to make assumptions about futur inflation (CPI / RPI).
Good Luck !!! |
|
foxy
|
the pension comes out of a fund which should pay out far greater than any interest from a bank,i am not sure you have understood about the lump sum payment as in the UK this is maximum 25% tax free and the rest remains in the fund which pays out a monthly premium for the rest of your life ...i think this 25% is the lump sum you are talking about....i retired from my private pension at 50 and been drawing for 2.5 years because it was not performing and although i would have got a lot more each month if i had kept it up till 65 at least the monthly pension payment is gone and i draw a nice little amount every three months |
|
jes1brian
|
easy my friend # take the lump sum . take it now. |
|
Maundy
 |
Try The Telegraph website then the your money link on the left
there is a good article on this subject. |
|
L_E_Ezer
|
I don't have the formula, but I would suggest that someone provide it on the basis of no cost of living increments (since they would apply in all cases) and with ignoring taxation.
All this fellow wants to know is how to compare the expected return from depositing his lump sum in a bank (and drawing the expected pension payment each month), with the monthly payments he would get as a pension. And thereby to determine how long he would have to live to make it worth his while to leave the money in and draw a pension.
Hasn't anyone got the formula? |
|
k_oolguy1979
|
Simple..Excel has inbuilt function to calculate Internal Rate of Return (IRR). You calculate the IRR for the pension payments you are about to receive. Suppose you get an IRR of 10%p.a., then see that in case you select the option of taking lump sum payment, will you be able to invest that money which gives you 10% p.a. return. In case you are able to invest lump sum money at a return greater than 10% then its better to take lump sum amount
http://makemoneywork.typepad.com
Cheers
Ajay |
|
| |
|
| | |
| Questions List |
Answers | Last Post
| | | |
12 | 22 minutes(s) ago
| | | |
10 | 26 minutes(s) ago
| | | |
12 | 47 minutes(s) ago
| | | |
12 | 3 hour(s) ago
| | | |
12 | 4 hour(s) ago
| | | |
12 | 8 hour(s) ago
| | | |
12 | 11 hour(s) ago
| | | |
6 | 1 day(s) ago
| | | |
12 | 2 day(s) ago
| | | |
12 | 6 day(s) ago
| |
|
Homepage 
Financial
Forum 
Personal Finance 
No Spam
Adult 
Gambling
Unfinished
Deception
Plagiarism
Not English
