Browse
Category
DiscussionsUncategorized

... I need help with Excel, lawl: Calculate Reverse PayPal fees

Closed
DrDudePhD

So, this site got it right, I crosschecked with some transactions: www.gregledet.net/ppfcm.html (formula is available on source I think but I can't read it)

My fees are 5.4% + a fixed fee of $0.30. Let's use an example of $5 USD.

I'm doing this formula, it's the value I'll recieve after fees:

*=$5+(($55.4%)+$0.30)**

Somehow it doesn't give the same results as the site:

  • Excel=$5.57
  • Site=$5.60

What I'm doing wrong?

11 years ago*

Comment has been collapsed.

6 Comments
TheAnthonyNL

Well it could be that the site use rounded up numbers ...

11 years ago
Permalink

Comment has been collapsed.
chairmankao

Yeah, could be this. If the site is rounding up, that is such bullshit.

11 years ago
Permalink

Comment has been collapsed.
Undac

5*1.054+0.3=5.57

11 years ago
Permalink

Comment has been collapsed.
DrDudePhD

The correct sum is 5.60. I need to arrive to 5.60, 5.57 is wrong.

11 years ago
Permalink

Comment has been collapsed.
bloodynosepicker

Formula used on that site looks like this:
(5+0,3)/(1-(5,4/100))&oq=(5%2B0%2C3)%2F(1-(5%2C4%2F100))&gs_l=hp.3...30609.34053.8.34634.6.6.0.0.0.0.184.679.2j4.6.0...0.0...1c.1.9.psy-ab.qi3ZahNMDTs&pbx=1&bav=on.2,or.r_qf.&bvm=bv.45175338,d.Yms&fp=2eed869a957295a1&ion=1&biw=1920&bih=989)
They're adding $0.30 before calculating percentage (IMO it should be done after) and then dividing instead of multiplying. I don't know how PayPal is doing it but result will be different, for example:
100/0.946) = 105.708245243
100*1.054 = 105.4

11 years ago
Permalink

Comment has been collapsed.
DrDudePhD

Ohh, the first formula works exactly as it should be! Thanks a lot. No idea how you reached that one, though, makes no sense to me =P

11 years ago
Permalink

Comment has been collapsed.

Closed 11 years ago by DrDudePhD.