Hi,
I have accounting related question.
I am constructing a statement of income and and have now come to EBT=earnings before taxes. When the EBT is positive, you just multiply the EBT with the tax rate and then you get the net earnings for the year. When the EBT is negative the tax that year is set to 0 but then I want to accumulate this negative amount to the next year and add this to the EBT to lower the taxes that year.
Earnings before taxes 100 50 -60 -20 70 100 100 -20 80 10
Net earnings for the year 26 13 0 0 0' 23,4" 26 0 15,6 2,6
100*26% '(-60-20+70 = -10 => 0)
"(-10+100=90, 90*26%=23,4)
Tax 26%
Can someone give me some input on how I can do this in Excel?
Best Regards,
Gustaf
Bookmarks