My assumption is that you believe the LIFO should be valued at (40 x $4.60). However, this method is incorrect as LIFO takes into account the timing of sales; for example, when you first sell your goods on 12 November, you are already using LIFO then. This means that, as John said in the video, the cost of sales will be valued at (80 x $ 4.40).
If the sales end on 12th November (i.e no more sales after 12th November), the method which you use is correct (similar to FIFO, where you find total purchases & OP inv, deducted by the sales. Only difference is you use the cost of the most recently purchased goods for the cost of sales. This means that the method (the one similar to calculation of FIFO can be used since timing is not taken into account) can be used. Similarly, if there are only 2 changes (R for receipt, I for issues. RRRRII or RRIII), the method should also be correct. However, when it comes to RRRIIIRR or RIIIRR, where it switches back from R to I to R again, timing matters and hence you have to calculate the LIFO valuation step by step, and not like FIFO.
I feel that this misconception is also analogous to the cumulative weighted average cost and periodic weighted average cost. You can search it up if it helps to clear up your misunderstanding. This is also explained in the FA exam in John’s videos.
Thank you Mr Moffat. You’re literally the only person I have come across who has helped me FINALLY understand this and I’ve gone through multiple sources looking for help. Great at explaining and made it extremely easy to comprehend. Thank you so much!
brother how you divide 40 into 20 each and the values 4&4.40……i didnt understand….is there any equation for finding this easy way….till 260 minus 220=40 i understood….but afterwards can you explain it
Sir for LIFO, since they are accounted on the year end, and not perpetually like Avg, can we not just do: 20 + 140 + 100 – 80 – 140 = 40 (20 x 4) + (20 x 4.4) = 168.
Simple calculation of quantity like FIFO, then take cost from old stock instead of new stock for LIFO reasons.
ββββ
Sir for Avg cost, can we simply do: 20 + 140 + 100 – 80 – 140 = 40
(4 + 4.4 / 2) = 4.2 (4.2 + 4.6 / 2) = 4.4
40 x 4.4 = 176
Your answer was around 180.
Is this method good enough ? Is this small difference of value an issue ?
Well simplified lecture, sir ! And really a funny adorable comment for shopping in the Supermarket – LIFO style , made me laugh off loud.
Sir, if you may, shall you be covering about periodic weighted avg later on? I saw it briefly mentioned alongside Weighted Avg, in my Tuition Notes of the Institute I go to. Or it wonβt appear in the Exams and we donβt need to know.
sir, i don’t understand how we 40*4.49 instead of 140*4.49 in example 3 (Weighted average cost. The last issue). in the lecture it says its because we sold 100 units. so why didnt we apply that in the previous issue?
why ias2 do not accept LIFO?
It can distort the financial statements. For example in the SOFP it shows outdated inventory values.
Thank you so much for these lectures! You explain everything so clearly.
I was so confused until I found these.
Thank you for your comment π
Purchases & OP Inv:(20 + 140 +100) = 260
Sales: ( 80 + 140) = 220
Closing Inventory: 260 β 220 = 40
LIFO Valuation: (20 x $4.00) + (20 x $4.40) = $168.
how it comes ???
can u explain it …pls
Hi Jith,
My assumption is that you believe the LIFO should be valued at (40 x $4.60). However, this method is incorrect as LIFO takes into account the timing of sales; for example, when you first sell your goods on 12 November, you are already using LIFO then. This means that, as John said in the video, the cost of sales will be valued at (80 x $ 4.40).
If the sales end on 12th November (i.e no more sales after 12th November), the method which you use is correct (similar to FIFO, where you find total purchases & OP inv, deducted by the sales. Only difference is you use the cost of the most recently purchased goods for the cost of sales. This means that the method (the one similar to calculation of FIFO can be used since timing is not taken into account) can be used. Similarly, if there are only 2 changes (R for receipt, I for issues. RRRRII or RRIII), the method should also be correct. However, when it comes to RRRIIIRR or RIIIRR, where it switches back from R to I to R again, timing matters and hence you have to calculate the LIFO valuation step by step, and not like FIFO.
I feel that this misconception is also analogous to the cumulative weighted average cost and periodic weighted average cost. You can search it up if it helps to clear up your misunderstanding. This is also explained in the FA exam in John’s videos.
Thank you Mr Moffat. You’re literally the only person I have come across who has helped me FINALLY understand this and I’ve gone through multiple sources looking for help. Great at explaining and made it extremely easy to comprehend. Thank you so much!
Thank you for your comment π
Am I provided by calculator and paper-list for notes in cbe exam
Dear John,
For LIFO, since they are accounted on the year end and not perpetually,
Is the below method; a valid approach of arriving at the answer?
Purchases & OP Inv:(20 + 140 +100) = 260
Sales: ( 80 + 140) = 220
Closing Inventory: 260 – 220 = 40
LIFO Valuation: (20 x $4.00) + (20 x $4.40) = $168.
Please Advice,
Thank You!
brother how you divide 40 into 20 each and the values 4&4.40……i didnt understand….is there any equation for finding this easy way….till 260 minus 220=40 i understood….but afterwards can you explain it
Very simple and understood. Thanks Mr. Moffat…Your lectures are quite easy.
Woooooowwww I am at y third year University and had never understood these methods of stock valuation but today I have. Thanks to open tuition
Great π π
Hi with the LIFO example, 12th Nov- ‘Sold 80 Units’ why is it that:
You’ve written down, sold 60*Β£4.40 + 20*Β£4.00.
The last most recent purchases was from the 140 units, so why is it not:
80*Β£4.40
Ignore me, I think its the way that you’ve done your calculations that’s confused me.
Many thanks
OK π
I don’t get it. I have the same questions.
well Explained
Beautiful! Well simplified and understandable.
Thank you Sir
Thank you for your comment π
Thank you so much Mr. Moffat the lecture was so beneficial.
You are welcome π
Sir for LIFO, since they are accounted on the year end, and not perpetually like Avg, can we not just do:
20 + 140 + 100 – 80 – 140 = 40
(20 x 4) + (20 x 4.4) = 168.
Simple calculation of quantity like FIFO, then take cost from old stock instead of new stock for LIFO reasons.
ββββ
Sir for Avg cost, can we simply do:
20 + 140 + 100 – 80 – 140 = 40
(4 + 4.4 / 2) = 4.2
(4.2 + 4.6 / 2) = 4.4
40 x 4.4 = 176
Your answer was around 180.
Is this method good enough ? Is this small difference of value an issue ?
I want to know the same!! Iβm so confused
Well simplified lecture, sir ! And really a funny adorable comment for shopping in the Supermarket – LIFO style , made me laugh off loud.
Sir, if you may, shall you be covering about periodic weighted avg later on? I saw it briefly mentioned alongside Weighted Avg, in my Tuition Notes of the Institute I go to. Or it wonβt appear in the Exams and we donβt need to know.
Thank you very much for the class Sir. It was beautiful and understandable.
Thank you for your comment π
A thoroughly enjoyable lecture indeed ! Thank you so much Mr.Moffat.
Thank you for your comment π
Is there not periodic weighted avg. method in f2?
sir, i don’t understand how we 40*4.49 instead of 140*4.49 in example 3 (Weighted average cost. The last issue). in the lecture it says its because we sold 100 units. so why didnt we apply that in the previous issue?
sorry i realised my mistake. i had forgotten the role of the units currently in store i.e 180!!Thanks anyways!
You are welcome π