Help with excel formula
I want to create a formula which shows daily compounding in excel. Let's say we start with $100, earning an APR of 20%. Compounding daily.
Is my formula correct?
$100 * (1+(20%/365))^number of days
Trending Content - Investment Banking Forum
| +222 | Coverage Banking is Paradise | 28 | 23m |
| +89 | London Recruiting is Paradise | 35 | 2h |
| +75 | My Motivation Is At An All Time High | 13 | 2d |
| +54 | Are Canadians still get jobs in the US? | 39 | 3h |
| +36 | Is 7 years in banking enough to retire, or am I delusional? | 23 | 1d |
| +30 | MM IB --> NYC IB? | 16 | 16h |
| +29 | Do actual investment bankers despise IB TikTokers as much as I think they do? | 17 | 1h |
| +24 | Negotiating VP Sign-On Bonus (NOT Tied to Deferred Comp)? | 21 | 23h |
| +24 | Should I escape the matrix | 3 | 2d |
| +23 | Lawyer moving into Banking | 19 | 48m |
Career Resources
Yes.
Google would've been quicker
No, it isn't correct. I think you're conflating two concept. What I think you mean is that 20% is the APY (i.e. I put in $100 today, and I get $120 in 1 year based on daily compounding) and I need to show how that compounds day-by-day.
You can show in XLS that the original formula isn't correct based on .
First, you need to calculate the periodic (i.e. daily) rate. Probably easier for you to look up how to calculate this rather than me type out formulas in the format, but it should come out at around 18.2%
Second, make yourself a list in XLS with 365 rows. In row 1, you put the formula you suggested, only you use this periodic rate rather than 20%
Good luck with the task and hope this explanation makes sense
Asperiores velit qui mollitia id. Ut ducimus voluptas aut sit facilis illum quasi. Velit facilis voluptatem ut est commodi maxime. Autem labore qui quisquam ut rerum.
Quasi officia saepe veritatis illo sapiente. Facilis sint repellat impedit. Est veniam aut voluptas est ut. Optio nihil sint repellendus quia doloribus sint rerum. Architecto illum doloremque quis totam sit. Eum praesentium modi perspiciatis magnam nihil doloribus quo.
See All Comments - 100% Free
WSO depends on everyone being able to pitch in when they know something. Unlock with your email and get bonus: 6 financial modeling lessons free ($199 value)
or Unlock with your social account...