babdyragon0123
New Member
- Joined
- May 8, 2018
- Messages
- 1
Hi, i am new and i need help about compound interest based on 365 days excel
I'm creating a file to monitor my bank investment. Here is the link https://docs.google.com/spreadsheets/d/1u8mqweR4PU0n9itwlN945a79R0ueMpRPc1SL2PGadsU/edit
This year, my goverment change the way to calculate interest base on the number of days actually sent
Ex: Sent $1.000 from 1/2/2018 to 1/3/2018 with interest 10%/year
Interest amount = 1.000*10%/365*28
I have a trouble to use formula for "Expected amount upon maturity" cell when the investment is renew
Ex: Sent $1.000.000 from 7/4/2018 with 1 month period with interest 5,35%/year
Interest amount until 7/5: 1.000.000*5,35%/365* 30 = 1.004.397
Interest amount until 7/6: 1.004.397*5,35%/365* 31
Previous i use formula {(1+r * t)^k * t } but now the actual date fluctuate so it doesn't right anymore. Can you help me with that? Thank you
P/s: This file can be edited. You can make change directly to the file.
I'm creating a file to monitor my bank investment. Here is the link https://docs.google.com/spreadsheets/d/1u8mqweR4PU0n9itwlN945a79R0ueMpRPc1SL2PGadsU/edit
This year, my goverment change the way to calculate interest base on the number of days actually sent
Ex: Sent $1.000 from 1/2/2018 to 1/3/2018 with interest 10%/year
Interest amount = 1.000*10%/365*28
I have a trouble to use formula for "Expected amount upon maturity" cell when the investment is renew
Ex: Sent $1.000.000 from 7/4/2018 with 1 month period with interest 5,35%/year
Interest amount until 7/5: 1.000.000*5,35%/365* 30 = 1.004.397
Interest amount until 7/6: 1.004.397*5,35%/365* 31
Previous i use formula {(1+r * t)^k * t } but now the actual date fluctuate so it doesn't right anymore. Can you help me with that? Thank you
P/s: This file can be edited. You can make change directly to the file.
