How do I amount out this request for information using excel?
Question:
$2000 is invested at the beginning of respectively month for 15 years, compounded monthly at 12% interest. How much money do I have at the expire and how do I come to that answer using excel?
Thanks.
Answer:
I get $1,009,151.99 using Excel.
I will post explanation within one minute.
...
You can also use a Future Value (FV) of Money function related to annuities if you wanted to solve this. That is basically as easy on a graphing calculator (TI models) than a computer. However, I assumed you needed to see the full schedule, so here is how you can compute it:
Start near what you are given.
You can put these in any cell, really.
(cell) [A1] = 2000 {[The monthly investment]}
[A2] = 0.12 {[The interest rate in annual terms]}
[A3] = A2/12 (or 0.01) {[The interest rate within monthly terms]}
[A4] = 15 {[Number of years]}
[A5] = 180 {[Number of months in 15 years]}
...
I intuitively like to use headers, so I also include the following prior to the calculation:
[B1] = "Mo." (or month #)
[C1] = "Start" (or start of month)
[D1] = "End" (or end of month)
[E1] = "Invested" (or total $s invested)
...
consequently on to the calculation.
[B2] = 1
[B3] = [B2] + 1
[B4] = [B3] + 1
... Just use a teem or drag to reach 180 months total
[C2] = [$A$1] (*use out-and-out reference) = $2000.00
[D2] = [C2] + [C2] * [$A$3] (*use absolute reference) = $2,020.00
or [D2] = [C2] * (1 + [$A$3])
[E2] = [$A$1] * [B2]
...
only add:
[C3] = [D2] + [$A$1] = $4,020.00
and you're organized to fill surrounded by the rest.
Drag [D2] & [E2] to [D3] & [E3] respectively.
Then select [C2:E2] and double click on fill deity found at the bottom right corner of [E2].
Note: This only automates if you own dragged the [B] Months column all the style down to 180 total.
Please let me know if that help, or if you have any question about the explanation.
What do i do?? surrounded by a problem such as...?
Question:
I LOST MY JOB SINCE DEC, 2006 AND I CAN'T PAY MY BILL'S, AND I OWE ALOT OF COMPANY MONEY... I CAN'T FIND A JOB AS IS ROUGH,,, SHOULD I FILE A BANKRUPTVY, AND SHOULD SOME COMPANY LET ME BARROW MONEY UNTIL I FIND A JOB?? PLEASE NEED TO DO SOMETHING FAST BEFORE IT GET MORE WORST..
THANK'S...
Answer:
Phone Social Services or whatever it's call where you live (Welfare). They will grant you some money to live on.
Also go to Credit Counselling. There is no charge for this service. They will dance over your debts with you and push for you of what to do.
Call the companies to whom you owe money and ask for forbearance. Don't borrow any more money. Stay with people or friends til you find a job & wish the assistance of social services. Try not to file for ruin unless there is in recent times no recourse. I can't imagine a company extending you unknown credit if you are delinquent with others. The interest rates would be outlandish and you don't entail more debt. Good luck!
This is a alert 2 travelers out in attendance near pets concerning EXTENDED STAY HOTELS.They will report u that they r
Question:
pet freindly but will fail 2 inform u that they charge u $25.00 per pet ,per hours of darkness until after the fact that u own made reservations with them.Yet they r missing rime cube boxes half the time and alot of their guest r kids who love 2 gala all darkness and keep every1 awake even though U r within there 2 sleep.Most enjoy no security.So b forwarned citizens and dont fall 4 their road of suckering u on their pet fee's, cause they will staple u good.
Answer:
wow sounds close to someone didn't get the fine print read to them. I would hail as that place back and speak to a chief. Thats info they need to make clear to u when u make the reservation (i'm discussion about the pet friendly thing). As far as the "guests" and the disturbance, u were probably already surrounded by a not so good mood and that aspect of the stay worsened the situation. Hope u can gain some $ back.
As beside any purchase or transaction, it's up to you to ask questions, read fine print and check out things earlier you commit.
And any accomodations run the risk of having strident guests down the hall.
what is ebay?how to buy n flog contained by ebay?
Question:
Answer:
eBay is the world's online marketplace; a place for buyers and seller to come together and buy or sell almost anything!
Here's how eBay works:
A vendor lists an item on eBay, from antiques to cars, books to sporting merchandise. The seller chooses to adopt only bids for the item (an auction-type listing) or to submission the Buy It Now option, which allows buyers to purchase the item straight away at a fixed price.
In an online auction, the bidding open at a price the seller specifies and remains on eBay for a confident number of days. Buyers then place bids on the item. When the fact list ends, the buyer with the extreme bid wins.
In a Buy It Now information bank, the first buyer willing to pay envelope the seller's price gets the item.
Buying and selling on eBay is smooth and it's fun. Best of all, you'll never know what you can find.
The following Learning Centre tours will show you the nuts and bolts of buying and selling on eBay and will help you grasp going.
How to buy on eBay? Click the link below.
http://pages.ebay.co.uk/help/ebayexplain...
How to flog on eBay? Click the link below.
http://pages.ebay.co.uk/help/ebayexplain...
ebay.com is a site where on earth people put near stuff up on auction or at buy now prices, any point they want so long as it's legal, and you can buy stuff in attendance with your ebay picture if you have a funds to pay. spot on auctions will ask for certain types of donation that you have to check first. some seller raise thier shipping price to spawn profit and that is something you own to beware of. Also the most common giving is paypal credit, which works kind of close to a credit card or debit card and you can register for it at https://paypal.com
you can find things by price, location of seller, by dedicated seller, by knob words that you're looking for or eliminating, and by whether it's surrounded by a lot of items together, etc.
selling would require also verify your address and your bank rationalization or credit card. they charge small fees depending on how much you sell for.
ebay is a great website where on earth you can find a lot of things to buy and you could go anything you don't need. to buy something you type surrounded by a toy or any item you would want to buy. you type this in the scrabble box or you could just click the buy button and scrabble by catergorey. to sell you click the put up for sale button. then you hold to type in what you are selling. after it will ask you to type in your ebay user ID term. if you don't have one you enjoy to register. it will ask you questions and you will hold to answer them. <<<And this is all i know Hope I help : )
I just now get discharged from Ch 7 Bankruptcy and inevitability an auto loan. Who is the best lender to work near?
Question:
I literally just get discharged. I can afford a car grant, but I want to know will give me the best rates and language possible. I understand I'm not going to get hold of good jargon, but I don't want to get ripped past its sell-by date either. Thanks!
Answer:
This is what I do for a living. Consult Sundays classified add and find a dealership that advertises Special Finance.
There are several lenders out nearby that loan money to people that own recently discharged bankruptcy's. Capital-One, H.S.B.C., Wells Fargo, Citifinancial, Tidewater Financial merely to name a few.
The Manager of the Special Finance Department will grasp you the best deal he/she can. As far as interest rates, that will depend on your loan to pro. Could be anywhere from 16.95 to whatever your state maximum is.
Whatever you do, do not stir to a buy here pay here lot. They are a rip stale and most do not report to the credit bureaus.
if you have a position there are auto dealer that will loan money on the cars they sell,, within my area a nation huge firm called Car Mart does this,, and they give the impression of being to have accurate cars
I had obedient success by purchasing a saloon through CarMax. This was appx. 4-5 mo. after ruin discharge. They were the best concord we could find.
GOD
i think that the below website will lend a hand you to find the right solution
Hello,
This is Mr Terry Ballack.I am a legitimate loan lender who give out loan at a very low interest rate of 3%.Are you financially down?Do you want to recompense up your bills?Do you have a totally low credit score and you do not own a job.Come today and apply for a loan for a minimum duration of 12 months and a maximum of 14 years.I do provide out loans from the range of $3,000 to $10 million dollars.I will be expecting your correspondence oon with the amount of loan you call for so that my loan terms and condition can be emailed to you.Contact me via email at terryballacklender@yahoo.com
Thanks for your compassion.
Mr Terry
Mostly sub-prime lenders want to work with ruin debtors. You will pay a elevated rate to get an auto loan. Avoid most of them.
US Bank does enjoy a program for people who just this minute filed ruin which at least is reputable.
If you can afford a monthly donation, can you consider saving for that motor over a period of time and using public transportation contained by the meantime?
how do i achieve my 401K and what do I do next to when I alter job?
Question:
I just changed job and don't know how to get my 401K from my former member of staff and what I do with it when I do catch it
Answer:
Im currently in alike situation. You have sevarl option.
1. Call the company your employer funds their 401K through, you might be able to roll it over into an IRA and not hold to pay anything within taxes.
2. You cant cash it out but you will be penalize 20% income tax and consequently a 10% early withdrawl..and thats not counting if your state have they own state tax.
3. some employer let you keep hold of your money in matching 401k but you can no longer contribute to it, so it just sits near until you are ready to use it. i wouldnt reccommend this.
Fortunately my employer uses Fidelity , which is significantly reputable so i intend on just rolling it over into an IRA.
If the company you own gone to work for has a 401K plan you can verbs it over to the 401K where you are working on. The best approach is to go converse to your company personal officers nearly it as rules are different from company to company about how you verbs your 401K plan.
If the company you are working for now does not hold a 401K plan you can transfer your 401K into a private income fund at your bank. You will requirement to go to your sandbank and talk to the sandbank officer who hands those funds. Most sizeable banks own them. Just ask for him or her and explain what you are wanting to do.
If you have pattern access to your 401k account, in attendance should be a phone number you can call. Otherwise you can look up the number of the edge that it was at. If you don't remember that, you'll enjoy to find a 401k statement or call your infirm work.
Once you call them you'll own a couple of options. One is to enjoy them roll your old 401k into your strange one. This may or may not be possible, depending on your old/new work and who they use.
Another option is to set up an IRA beside someone like Etrade or whoever. Then your 401k company can convey you a check made out to your new IRA portrayal. Your money will go into the IRA and you can invest it within a mutual fund or whatever you similar to, just as you did near your 401k.
Whatever you do, do NOT let them distribute the funds directly to you. This will cost you greatly of money (in early debt penalties), plus you need to hang on to that in your retirement fund.
Who manage the previous 401K? They might also manage the 401K of your unusual employer which would make it simple. If not you want to get the address of the 401K inspector from your previous employer and tell them you want to roll it over to the 401K of you current employer. If your current employer doesn't hold a 401K then you can roll it over into an IRA offered by places resembling Fidelity, T Rowe Price, etc.
Transferring utility bills from one given name to another.?
Question:
My mom is moving out and i want all the utility bills to to be transferred to my signature. Can this be done and do I have to enjoy a bank narrative to do so? I have no credit and i am surrounded by chexsystems will this affect it in anyway. I enjoy a steady job I a short time ago had a impossible experience with the edge hence chexsystems. Can i just foot them with money advice or prepaid credit cards for the time being?
Answer:
You will own to call the utility company and ask to hold the utilties switched over into your name. That have nothing to do near having a sandbank account, unless you considered necessary to have your utility bill automatically debit from a bank commentary. The utility company can still send you a quality newspaper bill, which you can then salary with a money instruct.
to get the utilities transferred to your mark you may have to put up a deposit,, next you can pay by lolly or money order,,, but be sure to achieve a receipt.
This can be done Chexsystems is a bank thing. Credit reporting agencies do not acquire this info unless you are deliquent on your bills. Good luck
Bob Laibach
www.gogreedy.com
Need a private loan lender?
Question:
i will pay extra backbone need 2.000 pound if some one can sustain please u.k only
Answer:
Try avoid lenders who are not reputable - you will lone make natural life harder for yourself in the long run! Do a G00GLE furrow for loan lenders or maybe try http://www.moneysupermarket.com/loans/... they appear to have the souk covered.
Hope it works out for you.
Yes there are heaps Loan sharks.
I have a inventory of some good websites offering Loans next to low Interest rate and fast approval. Its a policy voilation of yahoo if i post any connection here.
Just mail me at solidoffer11@yahoo.com next to subjet- Loan . I will send a cooperation of best website where you can find best Loan offer,tips and resources.
best wishes
i think that the below website will minister to you to find the right solution
Hello,sequel to your question,I will direct you to a loan consultant you can trust.Visit Long Term Loan Company Ltd and savour an unmatched interest rates,honest lending and more.To apply online,newly write to Mr.Benjamin Smith via email:longterm.loan@yahoo.com
Can you use debit cards from local bank on most websites?
Question:
Answer:
You can use a debit card that has the mastercard or visa logo anywhere mastercard or visa is permitted. If making purchases online you will need the numbers on the subsidise as well.
As long as it's a debit/credit card. It still comes out of your ridge account, but there's a visa symbol or something on it, so to companies, it works as a credit card.
If you own the money in your story
yes
As long as your debit card has any the Visa or Mastercard logo on it, you can use it. Just make sure that you hold the card present because you will more than likely hold to enter the expiration date and the 3 digit code on the back of your card.
Yes.
When would you consider yourself rich (fiancially speaking) near what species?
Question:
of salary, reserves, money left for fun every month, property etc?
Answer:
I'd consider myself "rich" next to:
1. $100,000 salary (10% to be in motion to "fun money" every month), 2. $5,000,000 net worth (a third retirement, a third rental properties, a third juice savings)
3. And a beautiful home, salaried in full.
when I'am competent to keep and enjoy an abundance of disposable income or what's vanished after bills.
If you spend less than 30% of your earnings on your housing costs and can afford to save 10% of your remuneration cheque you're doing well. If you own property and enjoy life insurance you can also work out that as your net worth.
RIch (in financial terms) to me, would be the power to contribute 30% of my monthly earnings to nest egg religiously every month in an interest attitude account.
Financially, I would consider myself 'rich' if:
I be making over 100,000 per year. That would be about $6000/month after taxes. Per month:
1500 to mortgage (1700 sq ft, 3 BR, 1.5 tub, 1/3 acre, small mortgage) Mortgage would be paid stale in 10 years
1500 to bills such as utilities, saloon payments and insurances, property taxes, etc
1000 for groceries (that's living GOOD)
1000 for savings (double when mtg is compensated off)
1000 disposable (fun) (that's living awesome)
That's me. Others might have bigger mortgages, let go more, or want to put a lot of money into a motor. A lot of people next to these huge new homes at the moment are working like wacky just to afford them. If you live 'below' your mechanism, then you are 'rich' near disposable income at a much lower figure.
You are well-off when you have money making money for you so you do not enjoy to work very unyielding. I prefer real estate, buying it low and selling it glorious then investing the profit so it make even more.
: )
IMO a million in bonds will throw sour enough income to live on. That plus a compensated for home and half a mil contained by stocks. That way you could live exceptionally well forever and not enjoy to work if you didn't want to. That's my definition of "rich." It's all a thing of opinion.
Does anyone know if in attendance is a credit/debit card that doesn't charge the "foreign purchase transaction fee"?
Question:
Since I am going to travel abroad soon, I want to find out a flowing and safe path to spend money abroad. Sadly, most credit cards and debit cards charge 1% to 3% "Foreign purchase transaction fee". so I am wondering if within is a card that does not charge for that.
Answer:
Use an American Express or Discover Card? I prefer Amex because they are accepted more places than Discover and own better rewards
If adjectives I enjoy is a non-interest checking explanation and I want to switch on abiding money, what is my best prospect?
Question:
Savings Account?
Money Market Account?
CD?
Stock Market?
Answer:
Start small and interested a savings details. Then open mutual funds when you become more comfortable. Always remember to never put adjectives your eggs in one picnic basket. So you in the come to an end should have assets surrounded by checking, savings, mutual funds, and stocks. Check your financial advisor at your local edge to see what is the best thing for you do to do contained by terms of stock.
I'd outstandingly recommend opening an ING Direct reserves account. It currently offer a 4.5% interest rate with no fees. If you are interested surrounded by opening an details let me know I can refer you and you may be capable of get a $25 bonus.
I hope this help.
Stop writing checks and open a money souk account.
Savings accounts gross the bank money and the interest they payment lags inflation.
The stock market is too speculative and unstable. You obligation to have money to brand name money there also.
Once the money flea market account have increased your savings satisfactory put most of it into a CD and start a building up to date money market side.
CD's are safe and wage interest but do have precipitate withdrawl penalties which inspires plentiful to not take an rash cashout. A sort of forced savings plan surrounded by essence. Budget a reasonable amount to put contained by each month and bring in adjustments for non essential expenses from whats disappeared after paying bills.
Mutual Fund
They'll start you with a hoard or money market story. If you have steady reserves, it will be the money market. If you own enough to put aside, walk with the CD's. The stock souk, stay blue chip, thank you.
Mutual funds are a good walk at around a 12% rate. Contact your local Primerica office. They should be capable of get you started for as little as $25 a month.
The most influential thing is you start positive. It's less exalted where you put your money. You can other move it somewhere else. And before you shift into the market variety sure you understand it. Get into the obsession of saving A.S.A.P.
One of the best things you can ever do for yourself. Good Luck.
125% Loan?
Question:
Can you get a 125% loan on a dune balance fairly than a house?
For example, you have $100,000. You agree to freeze the go together for the term of the loan (or put it into some sort of garanteed investment) and draw from $125,000.
Would banks be more or smaller amount willing if you considered necessary a bigger loan, for example, $1,000,000 with a 1.25 Million loan.
Just curious... appreciation.
Answer:
Highly unlikely. Banks only lend more than 100% of the efficacy of property in pious times when they are confident their arses are well covered if you founder to pay. Money sitting within their bank is still worth $100K (probably rather less if you factor inflation into account), meanwhile you own left the country beside $125K, nice little earner really.
With the house the banks know they can lurk a bit and recover pretty much their entire investment. You will also mostly pay a sophisticated rater of interest for a riskier loan (such as more than 75% loading).
if the money is not secured against anything then i would enunciate 'no chance'.
no.i had 45,000.00 within a bank and applied for 9000.00 loan.they turned me down because i didn't hold a "checking account"
If that was possible next you would put $125,000.00 and ask for a $156,250.00 loan and then you woul put $156,250...
You would go and get eventually enough billions to buy the edge and become the CEO and cancel adjectives your loans.
Hello there, I am Mr chris peter.A legit loan lender.Are you into debts? Do you hold a bad credit?Are you financialy down.I dispense out loans at low interest rate of 3%.I give out loan to Business,Auto and personal loan to Men and women who are into Business transaction, I dispense out long term loan for three to five years maximum beside your interest in this you can as economically tell me the amount you requirement so that I send to you the jargon and condition that is if you are realing interested surrounded by getting a loan from me, Loan is given out in Pounds and $US and SGD the maximum I offer is 5,000,000 both in pounds and $US and the minimum 1,000 pounds and US$ and SGD so if really you are interested letters for more info on how the loan can be transfered to you. There is one Question i have to ask are a serious individual that we help yourself to a loan and pay put money on after duration with the interest, if you are honest I will trust you because I close to to do business with Honest family if you are one you will get the loan next to out problem and for your information if you should more loan like $10,000,000m I can donate only if you are one of these cartigories: Manager of a company A private Holder A broker surrounded by banks A director surrounded by any office or company A illustrious investor of and compay If you are one of the following you can get $10,000,000US as loan or if personal loan you can request for 5,000-5,000,000 as loan. hope to here from you soon. NAME: PHONE:... COUNTRY:.
LOAN AMOUNT NEEDED.sen... these info it is esteemed. Mind you loans is given to every part of the world just if i see you to be honest and will pay subsidise after duration. If you are interested you have to distribute the amount you need as loan so that i can make a contribution you the terms and condition on the loan for your information loan are given to every sector of the world on honest people so if you are honest apply for the loan in a minute at cpc_consultant@yahoo.com
If you lug out a personal loan, and they ask for money as insurance incase you dont repay it hindmost is that permitted
Question:
Answer:
I would be be very suspicious of any "private loan company" asking for money upfront for any grounds. There are many scam where companies ask for money upfront and they help yourself to your money and run. Legitimate loan companies do not usually do this. They may ask for collateral, but rarely money. See the connect below:
I think you be going to is the bank asking for brass as collateral and no this is not illegal. People use wall CD's and other funds as collateral for loans for anything from personal expenses to buying land and cars.
This sort of lending is usually referred to as outside edge lending. They will underpinning the interest rate on the loan based on what interest rate your earn on your CD or other financial instrument.
However, contained by your case they may be asking for optional collateral since they may feel that a non-attendance on the loan would put them at a loss. Hope this information is helpful.
Yes it is permissible. Banks ask for colateral in almost adjectives cases. they use your credit history to determine what the risk of non payment is. If you enjoy a long history of good clearing they may not ask for collateral. when you buy a car they put a lien on it to be sure that if you market it they will get their money put a bet on.
I recommend you do not use this place for your loan. I found that the ones who are asking for the security are usually charging illustrious interest rates. Yes it is legal to ask for financial guarantee, but be aware of the fine print
Bob Laibach
www.gogreedy.com
Any place that needs your money surrounded by order to administer you a loan is probably a scam and NOT legit. Run away.
A bank MAY put a hold on your picture up to a certain amount, but collectively won't do this. If you're a good satisfactory risk to loan the money to, they won't need to do this.
Can a parent/guardian create a guard statement for their child?
Question:
I need a sandbank account, but due to a fire a year ago, my birth cert. be lost. I need a dune account immediatly, and be wondering if a parent/guardian could create one in my given name.
Thanks
Answer:
Yes - it's called a "custodial" sketch.
yea of course jus hold all the kids papers close to birth certificate and social s. card
Parents can set up an picture however some sort of ID is still needed.
yes
uh yeah, if you are a kid. if you are grown, just replace your b.c. it's not that rugged.
Yes but it has to be lower than your parents name.
Yes, I focus that they can. If you want a more definite answer, check beside the bank you want to do business next to.
Yes. You can get another birth permit but it takes some time because you enjoy to have some other form of Id and they hold to send the unmarked birth certificate to you.
yes as you would expect they can
When you finally do get the side, get a risk-free deposit box to put things like your birth authorization in (once you acquire a replacement) so you won't have this problem again.
Yes, they can create one within your name.
yea lately go to edge together
A minor can have a edge account within their name as long as their parent/guardian is also on the narrative. Now, it would be up to the bank policies but the financial institution that I work for allows the parent to widen up the account next to the minor primary and the parent secondary for any minor up to the age of 15 short the minor needing an ID. This side would be a savings one and only. If the minor is 16 years old or desires a checking account consequently they would need a State ID. We never require the birth pass to open the report, only the ss card and ID if 16 & elder.