Questions tagged [compound-interest]
Compound interest is the result of reinvesting interest so that interest in the next period is then earned on the principal sum plus previously accumulated interest.
199
questions
2
votes
1
answer
2k
views
How are compound interest factor tables calculated?
In my economics class, our textbook provides these massive tables for looking up these compound interest factors to put in worth equations. They look something like this:
There has to be some formula ...
- 121
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 ...
- 167
1
vote
1
answer
2k
views
TreasuryDirect Reinvest T-Bills (Gap or no Gap)
When you set a T-Bill (say 3M) to reinvest on TreasuryDirect, will there be a one week gap when reinvesting (due to auction scheduling) or will you be fully vested for 2 years (get 2 year's worth of ...
- 297
0
votes
1
answer
149
views
How to calculate Average CAGRs?
I have sales by 30 different products over years (2015-2022). I need to compute Compound Annual Growth Rate, however some of the product groups have high CAGR and some of them have quite low CAGR. So ...
- 101
-2
votes
1
answer
114
views
Are there any home-loans that compound every quarter or half-year or annually?
Are there any home-loans that compound every quarter or half-year or annually?
Asking for a friend who keeps bugging my other friend to give them money to buy a house, and the friend doesn't want to ...
- 157
1
vote
2
answers
148
views
Is this a weekly compounding loan amortization schedule?
I am currently having a disagreement with my colleagues regarding whether a loan is compounding or not.
I have linked below an image of a amortization schedule for a 52 week term for a $50,000 loan. ...
0
votes
1
answer
76
views
If you pay off a variable APR daily accruing credit card before the end of the month, is there interest?
Can you avoid 100% of interest on a card that accrues interest daily, by paying it off in full before the end of each billing cycle?
- 11
2
votes
2
answers
64
views
CAGR of Monthly Close Prices
In step 7 in this tableau tutorial he uses the number of periods as 12 I believe this number should change. So for instance if we started with January to March, the number of period would be 3. Then ...
- 133
1
vote
2
answers
137
views
Calculating cumulated interest of mortgage within a specific time span
I like to use google sheets because of its ease of access with just a link. I have a mortgage and I need to be able to calculate the interest within a year (but I'd like to be able to do it within any ...
- 11
-1
votes
2
answers
192
views
What's the formula behind these two stock trading scenarios?
Let's say I have $10,000 in my account.
Scenario 1:
If I make 10 trades in a year and each trade I position size using only 25% every time and exit the trade after a 10% gain, my account would grow by ...
- 1
1
vote
2
answers
105
views
How long will it take to pay off a Virgin Money Transfer principal balance of £ 5,816.21 at 23.29% variable interest?
I'm thick when it comes to finances. I don't understand how interest and compound interest works, so I'm seeking help.
I have a Virgin Money Transfer principal balance of £ 5,816.21.
Interest rate ...
- 13
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 ...
0
votes
2
answers
336
views
Calculate interest rate APR (compound and normal) on a daily basis
Let's assume there is an interest rate of 0.61%. So, the interest is 0.61% AER which is then divided by 365 and paid daily. The interest rate is for the year, not per day however interest is paid ...
- 217
1
vote
2
answers
1k
views
Calculating Effective Annual Interest Rate & Annual Percentage Rate with fees (in R)
Problem
How to calculate Effective Annual Interest Rate (EAR) and Annual Percentage Rate (APR) with fees (in R) ?
I am interested in getting to know how much I am actually paying interest when fees ...
- 69
1
vote
1
answer
62
views
How to find CAGR from absolute return in a given duration?
What is the formula to figure out "Compound Annual Growth Rate (CAGR)" from absolute returns?
Say, if 100% is the absolute return in 5 years tenure, then how would I find what is the CAGR ...
- 143