Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
rg2 rg2 is offline
external usenet poster
 
Posts: 1
Default Formula to determine selling price with cost known @ X margin?

I'm trying to create a formula in Excel to project a selling price of a
product using the margin I wish to make as the variable. Any help would be
greatly appreciated.
Thanks.
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2,202
Default Formula to determine selling price with cost known @ X margin?

I'm an engineer-type person, not a business-type person; but, as I
understand the terms, I think you want this...

=A1*(1+B1)

where A1 holds the price you paid for the item and B1 holds the margin as a
fraction (0.30 for 30%).

Rick


"rg2" wrote in message
...
I'm trying to create a formula in Excel to project a selling price of a
product using the margin I wish to make as the variable. Any help would be
greatly appreciated.
Thanks.


  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 733
Default Formula to determine selling price with cost known @ X margin?

"Rick Rothstein \(MVP - VB\)" wrote...
I'm an engineer-type person, not a business-type person; but, as I
understand the terms, I think you want this...

=A1*(1+B1)

where A1 holds the price you paid for the item and B1 holds the
margin as a fraction (0.30 for 30%).

....

That's mark-up. Margin is expressed as a percentage of revenue, not
cost of goods sold. Given your set-up, the correct formula is

=A1/(1-B1)

Another way to think about it: you can't have more than 100% margin,
but you can have more than 100% mark-up.

  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2,202
Default Formula to determine selling price with cost known @ X margin?

I'm an engineer-type person, not a business-type person; but, as I
understand the terms, I think you want this...

=A1*(1+B1)

where A1 holds the price you paid for the item and B1 holds the
margin as a fraction (0.30 for 30%).

...
That's mark-up. Margin is expressed as a percentage of revenue, not
cost of goods sold. Given your set-up, the correct formula is

=A1/(1-B1)


Damn! I mixed them up. Thanks for the correction Harlan... much appreciated.

Another way to think about it: you can't have more than 100% margin,
but you can have more than 100% mark-up.


You know, if I had thought of about it that way, I probably would have
gotten it right.

Rick

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Cost to Retail Price Formula - some help pse Eurbiz Excel Worksheet Functions 2 May 31st 06 10:34 AM
formula for cost as percentage of sale price elisabeth New Users to Excel 2 January 21st 06 06:43 PM
find selling price of bonds charlene Excel Worksheet Functions 2 December 19th 05 04:30 AM
looking for latest selling price.. Lawrence Excel Worksheet Functions 4 November 12th 05 05:49 PM
LOOK FOR LATEST SELLING PRICE Lawrence Excel Worksheet Functions 8 October 5th 05 10:27 AM


All times are GMT +1. The time now is 06:28 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"