All Questions
Tagged with compound-interest spreadsheet
10 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
2
votes
1
answer
2k
views
Google Sheet formula for annualized returns - doubts
I'm trying to setup a calculator in google sheets where I calculate the future value of investing for example:
a principal of 10.000
into which I deposit 1.000 every month
the investment doesn't give ...
- 23
0
votes
0
answers
28
views
How much benefit we earn with no cost emi on CC
I am thinking to take a policy on no cost emi of CC. I want to find money I saved annually by opting to no cost emi against paying all premium lumpsum at the start of the year. I want to consider ...
- 173
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 ...
2
votes
1
answer
639
views
Building Marcus Savings Calculator in Excel
I'm trying to do some analysis in Google Sheets which involves putting money in Marcus' High Yield savings account. For some reason, I can't seem to get my numbers to match the values from their ...
- 135
3
votes
2
answers
7k
views
Compound daily interest with monthly deposits over x amount of years in excel
This is compound interest calculated daily and topped up with deposits every month e.g Begin with $100, earn 2% interest earned daily even on weekends, and then come month end invest another $100 on ...
- 31
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
2
votes
3
answers
2k
views
Looking for Excel formula to calculate the benefit of making additional payments on a loan with interest daily compounded monthly
I'm looking to make extra payments to my student loans. I currently owe $30,000 at 5.25%. I pay $250 on the 15th of every month. My loans accrue interest daily that are then compounded monthly. I want ...
- 37
2
votes
1
answer
8k
views
Annual compounding with monthly payments
I'm trying to solve the following problem using the Time Value of Money formulae on MS Excel and getting nowhere. Can someone please help me?
X makes monthly payments of $3500 at the end of each ...
- 121
0
votes
2
answers
102
views
Find the compound return
If I have a specific amount of money. For example 1000€ at the beginning of the 2008 year.
-65.55 2008
91.25 2009
17.74 2010
-42.87 2011
18.32 2012
-18.82 2013
56.57 2014
How much money i ...
- 109