How do I calculate operating expense
KAE1994
--
K.E.
Tx.
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.
"KAE1994" <KAE...@discussions.microsoft.com> wrote in message
news:D85E9D14-2C13-49D3...@microsoft.com...
>
> --
> K.E.
> Tx.
KAE1994
--
K.E.
Tx.
KAE1994
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.
DaveB
don't have an Excel question then don't post.
--
Regards,
Dave
DaveB
Please don't post the same question more than once, you will find most
people here read every thread and it gets annoying to read exact duplicates.
With that said, and reading your previous post, this sounds like a math or
finance question. This is an Excel help chat so if you don't have a question
specific to Excel then please don't post.
Your best bet would be to search through the templates offered on office
online, they may have something to deal with what you are after:
http://office.microsoft.com/en-us/templates/default.aspx?Application=XL&Ver=11
As far as any kind of exact finance formula, ask your prof.
--
Regards,
Dave
"KAE1994" wrote:
>
> --
> K.E.
> Tx.
Gordon
> 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
--
Gordon Burgess-Parker
Systems and Management Accounting
www.gbpcomputing.co.uk
KAE1994
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.E.
Tx.
KAE1994
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
--
K.E.
Tx.
Conrad Carlberg
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
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.news:292ADBD0-D429-43F9...@microsoft.com...