All Questions
Tagged with compound-interest calculation
34
questions
1
vote
2
answers
89
views
For mutual funds, does average annual return mean compounded annually or continually or daily?
Vanguard's Portfolio Allocations page (1926-2019) shows 9.21% Average annual return for 70% Equity and 30% Fixed income.
Does this mean 9.21% compounded annually?
GOAL...
If at age full retirement age ...
- 676
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 ...
0
votes
1
answer
44
views
Calculating real rate after taxation - is there a better way?
First I need a sanity check for my calculations.
Say I have this scenario:
Nominal Rate (per year) [r]
13%
Inflation Rate (per year) [i]
5%
Initial investment [x]
$ 100.00
Time (years) [t]
10
Tax ...
- 125
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 ...
- 69
2
votes
2
answers
123
views
Find ending balance given return rate and amount added each year
If I have an investment that grows 10% per year, and every year I add an amount, is there a formula that can be used to find my ending balance after n years?
The following demonstrates this:
year 0: ...
- 174
3
votes
3
answers
2k
views
How do compound interest calculations interact with penny round-off?
[As I have very little experience on money.SE, I welcome feedback about the following question, in addition to any answers of course.]
The balance on a loan or deposit is always reported as an ...
- 162
3
votes
4
answers
2k
views
What formula can I use to calculate compounding interest with recurring investments?
Assume I am saving X dollars per year every year, and every year I earn 10 percent on what I saved the previous year. e.g. if I am saving 100 dollars every year I would see the trend: 100, 210, 331, ...
- 2,592
3
votes
4
answers
285
views
What is an appropriate metric measure average annualized rate of return for an average investor?
Let us say an investor invests $X per year for N years. Let us say the final portfolio value is $Y. In this scenario, how should I measure a metric that quantifies "average annualized return"?
I ...
- 51
3
votes
3
answers
948
views
How to calculate the return from a mutual fund?
How do I calculate the return from a mutual fund invested as a monthly SIP of Rs. 5000 over a period of 3 years at a return rate of 20.4% per annum?
The projected amount for the same is calculated by ...
- 261
2
votes
1
answer
621
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
3
answers
620
views
How to know how much money was paid, and how much was spent paying off interest
I would like to buy a car, and found out about the 20/4/10 rule today. I definitely have more than 20% downpayment saved up, due to that I am not concerned with the 20 part. I am more concerned about ...
- 133
1
vote
1
answer
316
views
How are CAGR and compounding frequency related?
I am newbie, so forgive me if my question seems trivial. I have a numerical where a bank scheme triples a person's investment in 5 years but it doesn't talk about the compounding frequency. Assuming ...
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 ...
- 13
3
votes
2
answers
272
views
How to compare loans of same principal, same interest but with different tenors
I have a scenario where there are 2 loans that can be provided (assuming I am providing the loan). The principal amount is the same, 30,000 in case of both the loans. The interest is also same at 17%. ...
- 1,185
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