All Questions
3 questions
0
votes
1
answer
9k
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 ...
- 167
0
votes
1
answer
120
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 ...
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 ...
- 301