K
KAE1994
--
K.E.
Tx.
K.E.
Tx.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
A
Alan
See how much you have to spend and deduct what you have actually spent.
Seriously though, how do you expect to get an answer on a question as vague
as this? Give some details of what you want to achieve, have a look at this
from John Walkenbachs site and try again.
http://j-walk.com/ss/help/newsgrp.htm
Regards,
Alan.
Seriously though, how do you expect to get an answer on a question as vague
as this? Give some details of what you want to achieve, have a look at this
from John Walkenbachs site and try again.
http://j-walk.com/ss/help/newsgrp.htm
Regards,
Alan.
K
KAE1994
Hello Alan,
Ok, here's as much info as I have to go by. For my college Math course, I
have to give ratios on three companies. And one of them does give the
Operating Expenses. However, it gives Net Revenue,cost of goods sold, Gross
profitsCurrent Assets, Current Liabilities, Total assets and
Liabilities,Cash, and Marketable Securities. How do I calculate Operating
Expenses with what I do have? Nothing in class text about it. Can you PLEASE
help me?
Thank you very much for any help you offer!
--
K.E.
Tx.
Ok, here's as much info as I have to go by. For my college Math course, I
have to give ratios on three companies. And one of them does give the
Operating Expenses. However, it gives Net Revenue,cost of goods sold, Gross
profitsCurrent Assets, Current Liabilities, Total assets and
Liabilities,Cash, and Marketable Securities. How do I calculate Operating
Expenses with what I do have? Nothing in class text about it. Can you PLEASE
help me?
Thank you very much for any help you offer!
--
K.E.
Tx.
Alan said:See how much you have to spend and deduct what you have actually spent.
Seriously though, how do you expect to get an answer on a question as vague
as this? Give some details of what you want to achieve, have a look at this
from John Walkenbachs site and try again.
http://j-walk.com/ss/help/newsgrp.htm
Regards,
Alan.
D
DaveB
This isn't a math or a finance help chat, this is an Excel help chat. If you
don't have an Excel question then don't post.
--
Regards,
Dave
don't have an Excel question then don't post.
--
Regards,
Dave
KAE1994 said:Hello Alan,
Ok, here's as much info as I have to go by. For my college Math course, I
have to give ratios on three companies. And one of them does give the
Operating Expenses. However, it gives Net Revenue,cost of goods sold, Gross
profitsCurrent Assets, Current Liabilities, Total assets and
Liabilities,Cash, and Marketable Securities. How do I calculate Operating
Expenses with what I do have? Nothing in class text about it. Can you PLEASE
help me?
Thank you very much for any help you offer!
G
Gordon
KAE1994 said:Hello Alan,
Ok, here's as much info as I have to go by. For my college Math
course, I have to give ratios on three companies. And one of them
does give the Operating Expenses. However, it gives Net Revenue,cost
of goods sold, Gross profitsCurrent Assets, Current Liabilities,
Total assets and Liabilities,Cash, and Marketable Securities. How do
I calculate Operating Expenses with what I do have? Nothing in class
text about it. Can you PLEASE help me?
Thank you very much for any help you offer!
Operating Expenses is Net Revenue less Cost of Goods Sold less Gross Profit.
And it would seem to be an ACCOUNTING question, not a Mathematics question,
because you wouldn't know how to do this unless you knoew about accounting
methods and terminology.
HTH
K
KAE1994
Gordon,
Thank you very much for your consideration of my problem. And your help. I
appreciate that very much. It has been a very long time since I had done any
business accounting. When I first looked at my spreadsheet, I thought the
answer your offered me was correct, even before I requested any help here.
BUt it just didn't look right after I did the calculation. Again THANK YOU
VERY MUCH for your help.
Thank you very much for your consideration of my problem. And your help. I
appreciate that very much. It has been a very long time since I had done any
business accounting. When I first looked at my spreadsheet, I thought the
answer your offered me was correct, even before I requested any help here.
BUt it just didn't look right after I did the calculation. Again THANK YOU
VERY MUCH for your help.
K
KAE1994
DaveB,
It was an Excel question, and I can not believe the rudeness in your
answer. I was TRYING to do an assignment using the EXCEL program, as it was
in excel format to begin with. I sincerely apologize for wasting your time
It was an Excel question, and I can not believe the rudeness in your
answer. I was TRYING to do an assignment using the EXCEL program, as it was
in excel format to begin with. I sincerely apologize for wasting your time
C
Conrad Carlberg
It doesn't look like this group has been very helpful as to the problem you
posted. It's an unfortunate result of Microsoft having let go of the old
CompuServe forum when they turned it over to public newsgroups. You don't
want to watch people making sausage, legislation, or answers to questions
regarding Excel.
"Business Analysis with Excel" discusses the problem you pose. The usual
definition of Operating Income (I know, your question concerns Operating
Expenses; please give me a moment here) is:
Net Sales (aka Net Revenue) less COGS less Operating Expenses
Operating Expenses is usually defined as Selling Expenses plus
Administrative Expenses. So, per Meigs and Meigs, if your net sales =
$900,000 and your COGS = $530,000, your Selling Expenses (aka Cost of Sales)
= $117,000 and your Administrative Expenses (aka G&A) = $126,000, then your
Operating Income = $127,000, and your Operating Expenses = $243,000.
Now: if you haven't been given Cost of Sales and G&A, or figures that enable
you to derive or back into them, then you can't calculate Operating
Expenses, whether you use Excel, paper and pencil, or Incan rope knots.
I think that your question is entirely appropriate to this newsgroup
(although you shouldn't cross-post, if indeed you did so; lots of us have
done that before we learned not to). I apologize on behalf of the people who
dissed you, and I hope the experience doesn't chase you away. This _can_ be
a useful way to learn about Excel, no matter what your requirements. Per
Paul Simon, just disregard the rest.
C^2
Conrad Carlberg
Excel Sales Forecasting for Dummies, Wiley, 2005
posted. It's an unfortunate result of Microsoft having let go of the old
CompuServe forum when they turned it over to public newsgroups. You don't
want to watch people making sausage, legislation, or answers to questions
regarding Excel.
"Business Analysis with Excel" discusses the problem you pose. The usual
definition of Operating Income (I know, your question concerns Operating
Expenses; please give me a moment here) is:
Net Sales (aka Net Revenue) less COGS less Operating Expenses
Operating Expenses is usually defined as Selling Expenses plus
Administrative Expenses. So, per Meigs and Meigs, if your net sales =
$900,000 and your COGS = $530,000, your Selling Expenses (aka Cost of Sales)
= $117,000 and your Administrative Expenses (aka G&A) = $126,000, then your
Operating Income = $127,000, and your Operating Expenses = $243,000.
Now: if you haven't been given Cost of Sales and G&A, or figures that enable
you to derive or back into them, then you can't calculate Operating
Expenses, whether you use Excel, paper and pencil, or Incan rope knots.
I think that your question is entirely appropriate to this newsgroup
(although you shouldn't cross-post, if indeed you did so; lots of us have
done that before we learned not to). I apologize on behalf of the people who
dissed you, and I hope the experience doesn't chase you away. This _can_ be
a useful way to learn about Excel, no matter what your requirements. Per
Paul Simon, just disregard the rest.
C^2
Conrad Carlberg
Excel Sales Forecasting for Dummies, Wiley, 2005
A
Alan
Hi Kae.
I don't really think that DaveB was really trying to be rude to you. I think
rather that what he meant was that this forum is one that looks at problems
people have with a specific Excel problem such as a VLOOKUP or SUMPRODUCT
formula that doesn't work or doesn't return the result that was expected.
To ask for a solution to an overall accounting or maths question such as you
describe is outside the scope of this forum.
You need to decide what you want to do with the spreadsheet, and how you are
going to do it to achieve your goal yourself,and at least make a start on
it.
Then, if you have a query with a formula or whatever then post here where
people will be happy to help, but I don't think anyone on here will be able
(or willing) to enter into a solution to the question you replied to me,
Don't be disheartened though, you'll get there in the end.
Regards,
Alan.
I don't really think that DaveB was really trying to be rude to you. I think
rather that what he meant was that this forum is one that looks at problems
people have with a specific Excel problem such as a VLOOKUP or SUMPRODUCT
formula that doesn't work or doesn't return the result that was expected.
To ask for a solution to an overall accounting or maths question such as you
describe is outside the scope of this forum.
You need to decide what you want to do with the spreadsheet, and how you are
going to do it to achieve your goal yourself,and at least make a start on
it.
Then, if you have a query with a formula or whatever then post here where
people will be happy to help, but I don't think anyone on here will be able
(or willing) to enter into a solution to the question you replied to me,
Don't be disheartened though, you'll get there in the end.
Regards,
Alan.
KAE1994 said:Hello Alan,
Ok, here's as much info as I have to go by. For my college Math course, I
have to give ratios on three companies. And one of them does give the
Operating Expenses. However, it gives Net Revenue,cost of goods sold,
Gross
profitsCurrent Assets, Current Liabilities, Total assets and
Liabilities,Cash, and Marketable Securities. How do I calculate Operating
Expenses with what I do have? Nothing in class text about it. Can you
PLEASE
help me?
Thank you very much for any help you offer!