Excel showing 0.5% x 100 = 1.5??

Hi guys:

I have a quick Excel de-bug question please - in calculating the interest on something, my Excel is currently showing me that A * B = 1.5, where as my A is 0.5%, B is 100. I'm not sure why (I have circular calculation turned on). In the step-through formula, it's clearly showing me that it is 0.5% *100 that I'm looking at (no issue with cell positioning).

Any chance any of you know how to fix this? Thanks!

4 Comments
 

I mean my Associate (not MBA Associate) builds some insane models, but didn't know the conditional formatting formula for alternate row shading...we're not coders. Not everyone memorizes every excel formula under the sun

run-rate pro-forma illustrative adjusted normalized management EBITDA
 

Est accusamus sunt minima optio et sit accusamus. Eum maxime laudantium rerum voluptatem optio quae impedit. Omnis et odit inventore modi et. Maxime atque sit dicta excepturi et velit. Nihil eaque aut fuga perferendis veritatis.

Inventore temporibus vitae ipsum nostrum esse doloribus qui maxime. Itaque dolorum porro ratione veniam quibusdam.

Nostrum beatae rerum beatae consequuntur. Ut ipsam et consectetur minus laudantium et. Dignissimos voluptas officia mollitia sunt minima enim. Doloribus autem debitis impedit. Quia voluptatem corporis voluptatem. Temporibus nostrum maiores illo ea ut atque laboriosam.

Voluptatem iste qui labore non eligendi nostrum unde. Voluptate sunt debitis rem rem necessitatibus similique. Vero enim quo voluptatem sunt aperiam qui veniam. Fuga nihil quasi modi saepe dicta quia et. Ad rerum quia ipsa vero officia tempore earum. Aspernatur iusto est in repudiandae at quia doloribus. Delectus ducimus dolor at sed voluptatem.

Career Advancement Opportunities

October 2026 Private Equity

  • Blackstone Group 99.6%
  • The Riverside Company 99.3%
  • KKR (Kohlberg Kravis Roberts) 98.9%
  • Warburg Pincus 98.5%
  • Vista Equity Partners 98.2%

Overall Employee Satisfaction

October 2026 Private Equity

  • Blackstone Group 99.6%
  • KKR (Kohlberg Kravis Roberts) 99.3%
  • The Riverside Company 98.9%
  • Ardian 98.5%
  • Warburg Pincus 98.1%

Professional Growth Opportunities

October 2026 Private Equity

  • Bain Capital 99.6%
  • Blackstone Group 99.3%
  • The Riverside Company 98.9%
  • Starwood Capital Group 98.5%
  • KKR (Kohlberg Kravis Roberts) 98.2%

Total Avg Compensation

October 2026 Private Equity

  • Principal (9) $653
  • Director/MD (24) $547
  • Vice President (100) $364
  • 3rd+ Year Associate (106) $280
  • 2nd Year Associate (236) $272
  • 1st Year Associate (414) $231
  • 3rd+ Year Analyst (33) $157
  • 2nd Year Analyst (97) $134
  • 1st Year Analyst (273) $126
  • Intern/Summer Associate (40) $79
  • Intern/Summer Analyst (357) $61
notes
16 IB Interviews Notes

“... there’s no excuse to not take advantage of the resources out there available to you. Best value for your $ are the...”

Leaderboard

1
redever's picture
redever
99.2
2
BankonBanking's picture
BankonBanking
99.0
3
Secyh62's picture
Secyh62
99.0
4
kanon's picture
kanon
99.0
5
GameTheory's picture
GameTheory
98.9
6
dosk17's picture
dosk17
98.9
7
CompBanker's picture
CompBanker
98.9
8
Betsy Massar's picture
Betsy Massar
98.9
9
DrApeman's picture
DrApeman
98.9
10
bolo up's picture
bolo up
98.8
success
From 10 rejections to 1 dream investment banking internship

“... I believe it was the single biggest reason why I ended up with an offer...”