Results 1 to 3 of 3

Day Sales Outstanding (Countback Method) formul

This is a discussion on Day Sales Outstanding (Countback Method) formul within the Excel Questions forums, part of the Question Forums category; Dear Expert i Hope you know the method of to calculate Day Sales outstanding (DSO) from countback method i have ...

  1. #1
    Board Regular
    Join Date
    Apr 2012
    Posts
    217

    Thumbs up Day Sales Outstanding (Countback Method) formul

    Dear Expert

    i Hope you know the method of to calculate Day Sales outstanding (DSO) from countback method
    i have tryied with formula but not get answer in single cell
    i explan here what is the method of DSO with count back method

    My Oct Nov and Dec Sales Are 150 100 250 Respectively
    and my Dec closing Account receivable (AR) is 400

    now in formual we are deduct last month sale from Account receivable till the Account Receivable is nill
    for example first i deduct 250 (Dec Sale) from 400 (AR) and the balance is (150) so i will take 30 days, then i will deduct 100 (Nov Sale) the balance is (50) so i will take 30 Days, now my AR is less than Oct sale so i will devide (50/150)*30= 10 Days, so i my resul is (30+30+10)= 70 DSO

    i need formula so i can pate in Dec month and get the 70 Days,

    i need DSO for whole year so i need last 6 to 9 month Sales figure and Closing AR (both i have)

    i hope you understand the method, and will make some formula to calculate in single cell...

    also this formula wokring in prev month, i have closing AR for whole year

    Best of luck, if i get it i will be happly excel lover among this forum..
    Regards
    Atul Jadhav

    Always learning excel

  2. #2
    Board Regular
    Join Date
    Apr 2012
    Posts
    217

    Default Re: Day Sales Outstanding (Countback Method) formul

    please do the needful
    Regards
    Atul Jadhav

    Always learning excel

  3. #3
    Board Regular
    Join Date
    Apr 2012
    Posts
    217

    Default Re: Day Sales Outstanding (Countback Method) formul

    Dear Exper i am expecting solution
    please revert
    Regards
    Atul Jadhav

    Always learning excel

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


DMCA.com