Skip to main content

All Questions

0 votes
1 answer
7k views

How do I calculate monthly compound interest with additional monthly deposits in Google Sheets?

I'm trying to figure out how to write a formula and/or use a function to calculate the following in Google Sheets. John deposits $1,000.00 into a savings account on Dec 31st. John also deposits $100 ...
Mr. B's user avatar
  • 167
6 votes
4 answers
589 views

Financial pros and cons of having a rainy day fund in a savings account versus invested?

I used to have about 4 months of expenses in a savings account as a "rainy day fund" in case of emergencies. The last year or so, though, I've switched to having a minimum of expenses (about ...
canary_in_the_data_mine's user avatar
0 votes
1 answer
891 views

How do I calculate Compound Interest with changing monthly contributions, quarterly contributions, and changing interest rate

John currently has $100 in a saving account that compounds quarterly at a .25% interest rate. When the account's balance reaches $2500 or more, the interest rate will change to .05%. I want to figure ...
Colin Fiedorowicz's user avatar
5 votes
3 answers
3k views

Inflation and the current value of my dollar

I am trying to figure out the value of my $100 with a hypothetical 2% constant inflation rate after 30 years. Here is the scenario: suppose I have $100 laying under my bed and the hypothetical ...
noobforever's user avatar
7 votes
3 answers
4k views

How to calculate savings account interest if you deposit and withdraw irregularly?

It's easy to calculate interest on a fixed principal. If you have for example $1000 deposit on your savings account and the rate is 0.25% compounded every whatsoever and you want to know how much is ...
user92831's user avatar
0 votes
1 answer
111 views

How do I calculate an average monthly income, with accurate yields, from dividend stocks paid quarterly and monthly?

I have a column that has evolved over months and I have another spreadsheet with my positions (my stocks, # of stocks, dividends payout and dividend yield). Those won't move. However, some of my ...
Jeremie Dumas's user avatar
0 votes
1 answer
136 views

How to calculate equivalent interest rate of gains with monthly contributions?

I started the year with a known amount of funds in my account and I make regular (assume equal) monthly payments into the account. I know how much my gain/interest for the year is. I believe the ...
Notts90's user avatar
  • 747
0 votes
2 answers
2k views

Help with a homework question calculating interest

Question : Imagine that you deposit $6,000 a year, starting one year from today, for four years into a savings account paying 6% per annum. (That is one deposit of $6,000 per year.) How much money ...
daniel blanco's user avatar
2 votes
2 answers
313 views

How much do I need to save per month in an interest-bearing account to reach a certain account balance in a certain number of years?

How do I calculate what my monthly contribution should be to an interest bearing account, knowing how much I'll need to have in the account in a given number of years? For Example, I need $8,203.03 ...
Dave Wielo's user avatar
3 votes
2 answers
2k views

interest compounded daily vs monthly

I want to compare two saving accounts with same APY, but one has interest "compounded daily and credited monthly" and the other has interest "compounded monthly and credited monthly". Which will yield ...
Tony B's user avatar
  • 131
166 votes
24 answers
59k views

Why do people save so much?

When I am old and retired (70 years +), I don't plan to spend a lot of money. I'll be living in my own house that is already paid off at that point, so no rent or mortgage payments. Since I don't need ...
cearl's user avatar
  • 1,345
1 vote
2 answers
162 views

What would be my total saving with an increasing and regular yearly deposit after 30 years?

Let's say I deposit $50,000 into the bank and in the first year I put in an installment of 5,000 and the interest is calculated monthly at 7%. In the second year, all is the same except for my yearly ...
Ray Hector's user avatar
2 votes
1 answer
224 views

Investing and compound interest? [duplicate]

I see lot of information about the power of compound interest and how it can help money grow. I understand the mathematics of compound interest but I have no idea how to take some money and make it ...
Jenna Maiz's user avatar
19 votes
2 answers
74k views

How do I calculate monthly compound interest in Google Sheets?

I have a financial spreadsheet with a column of all my deposits into my savings account. The leftmost column lists the dates of the deposits. Now, let's say my savings balance is $100.00 and my ...
grgoelyk's user avatar
  • 301
4 votes
1 answer
402 views

Future value of a compound-interest savings account when contributions are inflation linked

I've got a savings objective to achieve in 6 years and I'm trying to work out the percentage of salary I need to put towards it to achieve it. I am trying to work out how to calculate the future ...
user714852's user avatar

15 30 50 per page