SOLVED

Excel

%3CLINGO-SUB%20id%3D%22lingo-sub-1590824%22%20slang%3D%22en-US%22%3EExcel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1590824%22%20slang%3D%22en-US%22%3EHow%20to%20forcast%20sales%20of%20year%20for%20the%20future%20sales.%20Secondly%2C%20how%20to%20calculate%20year%20of%20year%20(YOY)%20sales%20and%20Profit%20Margin%20Year%20of%20Year%20(PM%20YOY).%20Below%20is%20the%20sheet%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1590824%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3E2016%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EAdmin%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1590882%22%20slang%3D%22de-DE%22%3ESubject%3A%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1590882%22%20slang%3D%22de-DE%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F760663%22%20target%3D%22_blank%22%3E%40Chibz_13%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22tlid-translation%20translation%22%3E%3CSPAN%20class%3D%22alt-edited%22%3E%3CSTRONG%3ESales%20forecasts%20easily%20create%3A%3C%2FSTRONG%3E%20Use%20the%20FORECAST%20function%20(Please%20see%20the%20attached%20file).%3CBR%20%2F%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22tlid-translation%20translation%22%3E%3CSPAN%20class%3D%22alt-edited%22%3E%3DFORECAST(B8%2CC2%3AC7%2CB2%3AB7)%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CDIV%20class%3D%22text-wrap%20tlid-copy-target%22%3E%3CDIV%20class%3D%22result-shield-container%20tlid-copy-target%22%3E%3CSTRONG%3E%3CSPAN%20class%3D%22tlid-translation%20translation%22%3E%3CSPAN%20class%3D%22%22%3EMargin%3A%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSTRONG%3E%3CSPAN%20class%3D%22tlid-translation%20translation%22%3E%3CSPAN%20class%3D%22%22%3EThis%20value%20is%20usually%20calculated%20using%20the%20following%20formula%3A%3C%2FSPAN%3E%3CBR%20%2F%3E%3CSPAN%20class%3D%22%22%3EProfit%20%2F%20turnover%20x%20100%25%20%3D%20profit%20margin.%3C%2FSPAN%3E%3CBR%20%2F%3E%20%3CSPAN%20class%3D%22%22%3E(Sales%20-%20Cost%20of%20Products%20Sold)%20%2F%20Sales%20%3D%20Gross%20Profit%20Margin.%3C%2FSPAN%3E%3CBR%20%2F%3E%20%3CSPAN%20class%3D%22%22%3E(Sales%20price%20-%20production%20costs)%20%2F%20production%20costs%20*%20100%20%3D%20surcharge.%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FDIV%3E%3CDIV%20class%3D%22result-shield-container%20tlid-copy-target%22%3E%3CSPAN%20class%3D%22tlid-translation%20translation%22%3E%3CSPAN%20class%3D%22%22%3EExample%3A%20A%20bread%20costs%20%E2%82%AC%200.74%20to%20buy%20and%20%E2%82%AC%201.29%20to%20sell%20%3CBR%20%2F%3E%20That%20is%20then%20x%20percent%20margin.%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FDIV%3E%3CDIV%20class%3D%22result-shield-container%20tlid-copy-target%22%3E%3CSPAN%20class%3D%22tlid-translation%20translation%22%3E%3CSPAN%20class%3D%22%22%3ECalculation%20%3A%20%3D1.29%2F0.74-1*100%25%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FDIV%3E%3CDIV%20class%3D%22result-shield-container%20tlid-copy-target%22%3E%26nbsp%3B%3C%2FDIV%3E%3CDIV%20class%3D%22result-shield-container%20tlid-copy-target%22%3E%3CP%3EI%20would%20be%20happy%20to%20know%20if%20I%20could%20help.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20you%20find%20this%20helpful%2C%20please%20mark%20it%20as%20%22Best%20Answer%22%20and%20as%20Like%20(click%20thumbs%20up)%2C%20it%20will%20be%20beneficial%20to%20more%20community%20members%20reading%20here.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENikolino%3C%2FP%3E%3CP%3EI%20know%20I%20don't%20know%20anything%20(Socrates)%3C%2FP%3E%3C%2FDIV%3E%3C%2FDIV%3E%3CDIV%20class%3D%22tlid-result-transliteration-container%20result-transliteration-container%20transliteration-container%22%3E%3CDIV%20class%3D%22tlid-transliteration-content%20transliteration-content%20full%22%3E%26nbsp%3B%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1591482%22%20slang%3D%22en-US%22%3EBetreff%3A%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1591482%22%20slang%3D%22en-US%22%3EThanks%20Betreff%20you%20are%20such%20a%20wonderful%20genius%3C%2FLINGO-BODY%3E
Highlighted
New Contributor
How to forcast sales of year for the future sales. Secondly, how to calculate year of year (YOY) sales and Profit Margin Year of Year (PM YOY). Below is the sheet
2 Replies
Highlighted
Best Response confirmed by Chibz_13 (New Contributor)
Solution

@Chibz_13 

 

Sales forecasts easily create: Use the FORECAST function (Please see the attached file).

=FORECAST(B8,C2:C7,B2:B7)

Margin:This value is usually calculated using the following formula:
Profit / turnover × 100% = profit margin.
(Sales - Cost of Products Sold) / Sales = Gross Profit Margin.
(Sales price - production costs) / production costs * 100 = surcharge.
Example: A bread costs € 0.74 to buy and € 1.29 to sell
That is then x percent margin.
Calculation : =1,29/0,74-1*100%
 

I would be happy to know if I could help.

 

If you find this helpful, please mark it as "Best Answer" and as Like (click thumbs up), it will be beneficial to more Community members reading here.

 

Nikolino

I know I don't know anything (Socrates)

 
Highlighted
Thanks Betreff you are such a wonderful genius