Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
CALCULATE PROFIT/LOSS
This is really a basic math question but I thought Excel was the Math Wizard
(more so than me) and could help, but this has opened up a bit of can of worms in our office and would like some other input. If we had a net loss the previous month of $-31,000 and this month we show a net gain of $51,000.. what is the difference and is it a gain or loss? I say that you take the negative $31000 and add it to the $51000 by that very simple formula in Excel and you end up with a net gain between the 2 months of $20,000... however, the others in my office are saying that you really end up with $82,000... which means that you would have to take that negative -31000 and subtract the 51000 in excel.. and then it's a negative (loss) of the $82000... that doesn't seem right when you did end up this month with a gain.. thanks for the help.. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
CALCULATE PROFIT/LOSS
Hi,
if the 51000 are Year today numbers that means that in this month you have a profit of 82000, however if the 51000 is this month movement you are right the year today will be the 31000 loss that I assume was year today at last month closing + the 51000 will give you the 20000 profit year today "Tree" wrote: This is really a basic math question but I thought Excel was the Math Wizard (more so than me) and could help, but this has opened up a bit of can of worms in our office and would like some other input. If we had a net loss the previous month of $-31,000 and this month we show a net gain of $51,000.. what is the difference and is it a gain or loss? I say that you take the negative $31000 and add it to the $51000 by that very simple formula in Excel and you end up with a net gain between the 2 months of $20,000... however, the others in my office are saying that you really end up with $82,000... which means that you would have to take that negative -31000 and subtract the 51000 in excel.. and then it's a negative (loss) of the $82000... that doesn't seem right when you did end up this month with a gain.. thanks for the help.. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
CALCULATE PROFIT/LOSS
I should define this a bit better I guess.. the number represents the
forecasted profit/loss at Dec 09 and the the $-31000 was what we were showing that would be last month when we did the forecast and then this month, due to changes in projects, etc..,,, the number has changed to the positive $51,000... AGain, thanks for your help and Eduardo - thank you for your very prompt response... and I'm sorry I wasn't clear on what the number was.. any other replies would also be appreciated as this is really bugging me.. Thanks again. "Tree" wrote: This is really a basic math question but I thought Excel was the Math Wizard (more so than me) and could help, but this has opened up a bit of can of worms in our office and would like some other input. If we had a net loss the previous month of $-31,000 and this month we show a net gain of $51,000.. what is the difference and is it a gain or loss? I say that you take the negative $31000 and add it to the $51000 by that very simple formula in Excel and you end up with a net gain between the 2 months of $20,000... however, the others in my office are saying that you really end up with $82,000... which means that you would have to take that negative -31000 and subtract the 51000 in excel.. and then it's a negative (loss) of the $82000... that doesn't seem right when you did end up this month with a gain.. thanks for the help.. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
CALCULATE PROFIT/LOSS
If I told you last month I project I will pay you -31000 at the end of
the year (i.e., you would pay me), but this month I say things have changed and I project I will pay you +51000 at the end of the year, what does that change mean to you? Hint: "Change" means "subtract". Don't be confused by double negative signs... they work out in the math. Tree wrote: I should define this a bit better I guess.. the number represents the forecasted profit/loss at Dec 09 and the the $-31000 was what we were showing that would be last month when we did the forecast and then this month, due to changes in projects, etc..,,, the number has changed to the positive $51,000... AGain, thanks for your help and Eduardo - thank you for your very prompt response... and I'm sorry I wasn't clear on what the number was.. any other replies would also be appreciated as this is really bugging me.. Thanks again. "Tree" wrote: This is really a basic math question but I thought Excel was the Math Wizard (more so than me) and could help, but this has opened up a bit of can of worms in our office and would like some other input. If we had a net loss the previous month of $-31,000 and this month we show a net gain of $51,000.. what is the difference and is it a gain or loss? I say that you take the negative $31000 and add it to the $51000 by that very simple formula in Excel and you end up with a net gain between the 2 months of $20,000... however, the others in my office are saying that you really end up with $82,000... which means that you would have to take that negative -31000 and subtract the 51000 in excel.. and then it's a negative (loss) of the $82000... that doesn't seem right when you did end up this month with a gain.. thanks for the help.. |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
CALCULATE PROFIT/LOSS
Hi,
Ok if you original forecast was a loss of 31000 and then after some changes you got a profit of 51000 that means that somewhere you have a profit of 82000 added, think about something suppose that you have the loss of 31K as follow Sales 100 expenses 131 (Loss)=(31) this was your original then suppose that you discover that you miss sales for 82K so your new income statement is as follow Sales 182 Expenses 131 Profit 51 Hope this explain clairly "Tree" wrote: I should define this a bit better I guess.. the number represents the forecasted profit/loss at Dec 09 and the the $-31000 was what we were showing that would be last month when we did the forecast and then this month, due to changes in projects, etc..,,, the number has changed to the positive $51,000... AGain, thanks for your help and Eduardo - thank you for your very prompt response... and I'm sorry I wasn't clear on what the number was.. any other replies would also be appreciated as this is really bugging me.. Thanks again. "Tree" wrote: This is really a basic math question but I thought Excel was the Math Wizard (more so than me) and could help, but this has opened up a bit of can of worms in our office and would like some other input. If we had a net loss the previous month of $-31,000 and this month we show a net gain of $51,000.. what is the difference and is it a gain or loss? I say that you take the negative $31000 and add it to the $51000 by that very simple formula in Excel and you end up with a net gain between the 2 months of $20,000... however, the others in my office are saying that you really end up with $82,000... which means that you would have to take that negative -31000 and subtract the 51000 in excel.. and then it's a negative (loss) of the $82000... that doesn't seem right when you did end up this month with a gain.. thanks for the help.. |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
CALCULATE PROFIT/LOSS
Perfect explanation and I greatly appreciate your guidance.. I of course feel
like an idiot, but at least now I am an enlightened idiot.. Thank you again for your time.. "smartin" wrote: If I told you last month I project I will pay you -31000 at the end of the year (i.e., you would pay me), but this month I say things have changed and I project I will pay you +51000 at the end of the year, what does that change mean to you? Hint: "Change" means "subtract". Don't be confused by double negative signs... they work out in the math. Tree wrote: I should define this a bit better I guess.. the number represents the forecasted profit/loss at Dec 09 and the the $-31000 was what we were showing that would be last month when we did the forecast and then this month, due to changes in projects, etc..,,, the number has changed to the positive $51,000... AGain, thanks for your help and Eduardo - thank you for your very prompt response... and I'm sorry I wasn't clear on what the number was.. any other replies would also be appreciated as this is really bugging me.. Thanks again. "Tree" wrote: This is really a basic math question but I thought Excel was the Math Wizard (more so than me) and could help, but this has opened up a bit of can of worms in our office and would like some other input. If we had a net loss the previous month of $-31,000 and this month we show a net gain of $51,000.. what is the difference and is it a gain or loss? I say that you take the negative $31000 and add it to the $51000 by that very simple formula in Excel and you end up with a net gain between the 2 months of $20,000... however, the others in my office are saying that you really end up with $82,000... which means that you would have to take that negative -31000 and subtract the 51000 in excel.. and then it's a negative (loss) of the $82000... that doesn't seem right when you did end up this month with a gain.. thanks for the help.. |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
CALCULATE PROFIT/LOSS
Eduardo,
Thank you for this very clear explanation - as I told smartin I feel like an idiot! Amazing how something like negative number can completely erase all you've learned... I appreciate your taking the time to help me and I now completely understand the problem and the right answer.. Thank you again so much for your time.. "Eduardo" wrote: Hi, Ok if you original forecast was a loss of 31000 and then after some changes you got a profit of 51000 that means that somewhere you have a profit of 82000 added, think about something suppose that you have the loss of 31K as follow Sales 100 expenses 131 (Loss)=(31) this was your original then suppose that you discover that you miss sales for 82K so your new income statement is as follow Sales 182 Expenses 131 Profit 51 Hope this explain clairly "Tree" wrote: I should define this a bit better I guess.. the number represents the forecasted profit/loss at Dec 09 and the the $-31000 was what we were showing that would be last month when we did the forecast and then this month, due to changes in projects, etc..,,, the number has changed to the positive $51,000... AGain, thanks for your help and Eduardo - thank you for your very prompt response... and I'm sorry I wasn't clear on what the number was.. any other replies would also be appreciated as this is really bugging me.. Thanks again. "Tree" wrote: This is really a basic math question but I thought Excel was the Math Wizard (more so than me) and could help, but this has opened up a bit of can of worms in our office and would like some other input. If we had a net loss the previous month of $-31,000 and this month we show a net gain of $51,000.. what is the difference and is it a gain or loss? I say that you take the negative $31000 and add it to the $51000 by that very simple formula in Excel and you end up with a net gain between the 2 months of $20,000... however, the others in my office are saying that you really end up with $82,000... which means that you would have to take that negative -31000 and subtract the 51000 in excel.. and then it's a negative (loss) of the $82000... that doesn't seem right when you did end up this month with a gain.. thanks for the help.. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
income and profit/loss as a percentage | New Users to Excel | |||
format of profit & loss a/c | Charts and Charting in Excel | |||
Profit and Loss Formula | Excel Worksheet Functions | |||
Calculating Profit and Loss in one column | Excel Discussion (Misc queries) | |||
Calculating Profit and Loss in one column | Excel Worksheet Functions |