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
| +201 | Why UBS Is the Worst Place to Start Your IB Career | 34 | 4h |
| +160 | ONLY THESE BANKS OR YOU STRUCK OUT | 41 | 9m |
| +65 | Firm Thinks I'm Lying About Offer | 20 | 22h |
| +59 | Indiana University Fraternity Pipelines | 35 | 15h |
| +50 | Rogo AI | 20 | 12h |
| +42 | Suspended for a Year | 19 | 7h |
| +41 | Elite Boutique interview questions | 10 | 11h |
| +39 | Stay at Weak Dealflow Team or Lateral? | 12 | 1d |
| +26 | UBS 2nd Year Analyst Q&A (2026) | 12 | 1h |
| +23 | 1st Half 2026 (1H26) RX IB & RX Co. Rankings | 16 | 9h |
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
Dolore iure nostrum qui cumque eligendi. Dolorum rerum quia perspiciatis fugit. Dolorem ut molestiae deleniti quod numquam consequuntur numquam. Autem tenetur fugiat itaque ab dolorum. Et ipsum ratione quam fugiat aut quasi explicabo.
Omnis vel fugit odit ut. Qui consequuntur atque quaerat dolor enim inventore. Laboriosam quo amet voluptates non. Soluta enim cum accusantium fuga perspiciatis. Distinctio quasi non quia iste. Expedita sequi doloremque quidem quaerat veniam ratione.
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...