simple calculation problem

Options
gingervicki
gingervicki Registered Posts: 87 Regular contributor ⭐
hi i need to work out how to calculate debtors days in months and then be able to re- work the figs when it tells me to shorten the period.

eg

debtors 35040
turnover 560640 show in months???

then its shortened to 0.5 of a month ???

not sure whan im doing??

vicki

Comments

  • Gem7321
    Gem7321 Registered Posts: 1,438 Beyond epic contributor 🧙‍♂️
    Options
    hi i need to work out how to calculate debtors days in months and then be able to re- work the figs when it tells me to shorten the period.

    eg

    debtors 35040
    turnover 560640 show in months???

    then its shortened to 0.5 of a month ???

    not sure whan im doing??

    vicki

    So your debtor days would be 35,040/560,640*12=0.75 months

    And I take it you mean what would the debtors have to be to make it 0.5 months?
    560,640/12*0.5 = 23,360

    I hope this helps, sorry if I've misunderstood!
  • gingervicki
    gingervicki Registered Posts: 87 Regular contributor ⭐
    Options
    AMAZING!!!

    i just couldnt see it for looking, thanks so much

    vicki:thumbup::thumbup::thumbup::thumbup:
Privacy Policy