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
| +237 | Work life balance = highly overrated | 72 | 44m |
| +193 | girl who rejected/ghosted me messaged asking for IBD job | 60 | 10h |
| +167 | UBS Exits 2026 | 44 | 1d |
| +111 | Rumors Search firm Looking for new UBS IB US Leadership | 21 | 13h |
| +40 | I don’t think investment banking is the way for me anymore | 33 | 7h |
| +32 | Case studies in banking interviews? | 4 | 3d |
| +27 | What Makes Goldman Great? | 17 | 9h |
| +25 | Is there a pay gap between A2A’s and MBA Associates? | 6 | 4d |
| +25 | Non-target grad struggling to convert final rounds. Feeling lost and need advice. | 9 | 2d |
| +23 | Making friends in NYC | 8 | 1d |
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
Quia laboriosam sit totam illum rerum ipsam. Quia illum reprehenderit at aut placeat itaque. Praesentium reiciendis laudantium alias est vel modi quia.
Hic sit nemo mollitia delectus non accusamus atque. Incidunt quo distinctio praesentium ratione est. Porro ut nesciunt autem. Quo ullam optio unde quidem. Voluptatem ratione et eum minus praesentium saepe. Et sint id sunt atque aut ut consectetur enim.
Sit eum reprehenderit distinctio deleniti perferendis id. Magnam aut natus ea et.
Quis eveniet voluptate expedita neque. Nisi ipsum perspiciatis est et expedita illo quibusdam.
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...