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
| +416 | Is UBS really that bad? | 76 | 40m |
| +259 | Investment Banking is Divine | 40 | 2d |
| +219 | Another $115bn Mega deal for these banks. Congrats! | 46 | 5h |
| +216 | US 2027 SA IB worried about background check | 53 | 2d |
| +54 | Useless associates | 11 | 4h |
| +48 | Differences in Restructuring Teams? | 24 | 1h |
| +40 | Is Houston SA 28 recruiting already over? | 34 | 1d |
| +36 | How do you manage nerves in IB technical interviews? | 8 | 8h |
| +34 | FIG Pigeonholes you - is it true? | 13 | 1h |
| +34 | Roku-Fox Deal - UBS Misses Out on yet another deals after years chasing this deal | 6 | 34m |
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
Nihil veniam itaque dolores nobis deleniti. Voluptates facere ut officia voluptates earum. Ipsum sit aut quibusdam qui a.
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...