+ Reply to Thread
Results 1 to 2 of 2

Accounting problem

  1. #1
    Registered User
    Join Date
    05-21-2020
    Location
    perth
    MS-Off Ver
    10
    Posts
    1

    Accounting problem

    More of a accountng problem but if my turnover is 84000 and my profit from this 15500 is my percentage of profit 18.45%.

    Or do I need to take the profit away from the turnover first then work out the percentage of profit. Im a little confused in this.

  2. #2
    Forum Moderator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    Pro 2019
    Posts
    16,210

    Re: Accounting problem

    There are two figures that you care about related to profit. The first one is what you correctly showed above, and probably the one you want. Each is used for different purposes. It depends on what your purpose is.

    Margin: Profit as a percentage of sales
    (Sales - Cost)/Sales = Profit/Sales
    In your example it is 15,500/84,000 = 18.45%

    Markup: Profit as a percentage of cost
    (Sales - Cost)/Cost = Profit/Cost
    In your example it is 15,500/68,500 = 22.63%
    Making the world a better place one fret at a time | | |會 |會 |會 |會 | |:| | |會 |會
    Please read the rules
    If someone helped you, click on the star icon at the bottom of their post
    If your problem is solved, go to Thread Tools and select Mark This Thread Solved
    Don't attach a screenshot--just attach your Excel file! It's easier and will let us experiment with your data, formulas, and code.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. How to load value from cell in accounting format and save in accounting format back
    By lazyserv in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-27-2015, 01:21 PM
  2. [SOLVED] Accounting Problem. Payment need to be segregated correctly.
    By Butcherdeliz in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-24-2015, 01:19 AM
  3. Problem with Accounting Formatting Option
    By jeneeva in forum Excel General
    Replies: 11
    Last Post: 09-14-2012, 11:06 PM
  4. Automated worksheet for accounting filter problem
    By Unca Wook in forum Excel General
    Replies: 4
    Last Post: 03-20-2011, 02:56 PM
  5. Time Accounting Problem
    By Ridgebacks in forum Excel General
    Replies: 2
    Last Post: 08-01-2008, 09:31 PM
  6. Let me explain my problem... (Roommate Accounting)
    By IanMcGreene in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 08-08-2006, 04:56 PM
  7. [SOLVED] VLookup problem-accounting for a large bank
    By MParham-Business@austin.rr.com in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 10-05-2005, 08:05 AM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1