Income Tax 2021 2022 Income Tax formula using tax software, get ready to get refunds to the max diving into income tax 2021 2022. Here we are in our Lacerte tax software, you don’t need access to the Lacerte tax software to follow along.
00:18
If you don’t have access to it or any software, then you might want to have the PDF formats of the forms which you can find on the IRS website@irs.gov IRS dot Govt.
00:31
So as we take a look at the software, we want to think about the three different angles that we’re considering the tax preparation from all of them somewhat related, one being the actual tax forms, including the form 1040 for individual taxes, the other being the software, which is helping us to do the data input to create the form 1040.
00:49
Although when we do the data input of 1040 is created basically automatically, when we’re thinking about looking at the data with the forms we’re talking about actually reading through line by line in essence on the forms to understand it.
01:02
And that form that data input format with the software is us putting the data into the system and letting it then generate oftentimes we look at the check numbers at that point in time.
01:12
The bottom line in terms of what the refund or the tax due would be, for example, and then a tax formula, which we’re often going to be looking at in terms of an Excel worksheet.
01:22
So an Excel worksheet looking like this, this looks like the formula that we put together, or we looked at in a prior presentation. And this helps us to visualize the tax return,
01:32
it also helps us to give kind of a double check to the data input in the software, a double check, which is nice, because note that when we do taxes, unlike when you do accounting, there’s no double entry accounting system because we’re just basically looking at an income statement.
01:46
So a double check of some kind is useful to have. So if you look at the formula here, and basically an Excel worksheet type format, you can think about it in terms of the actual tax formula being the end result, and then possibly having your other sheets that would expand on that giving more detail that then pulls over to the summary sheet.
02:07
That is a similar format that you can think of as the actual tax return is meaning the form 1040 is like the summary sheet.
02:16
All other forms and schedules are basically falling into or giving more information on expanding to the data that is ultimately pulling over to the tax formula. So when you start to visualize this thing, we’re gonna say,
02:29
Okay, here’s the income line item, what are the things that are going to pull into that line item in my tax formula, if you visualize it this way, it becomes a lot easier to actually pull off this data and you got to kind of organize it in some way. And this is actually possible to do with, you know, in a way to visualize it.
02:48
So then you could say, okay, all the income things that might go in there, w two income, of course, interest income, dividend income, retirement plan, income, so on and so forth. All that stuff that we’re going to then categorize them we’ll talk more about that later is all income stuff, which would pull into the income line item.
03:05
So with the whole schedule C for for businesses, that would be the net income on the schedule C would pull into the top line item.
03:12
So with a Schedule E for rental income, for example, then we have the adjustments to income, the adjustments to income is going to be here in the formula.
03:20
So income minus the adjustments, or you could call them above the line deductions. And that will give you to the AGI those adjustments, then you can start to think what categorizes as an adjustment.
03:32
You’ve got the one half of a self employment typically self employed Sep, self employed health insurance, alimony paid possibly penalty on savings, IRAs, individual retirements, and so on so forth, are kinds of things which we’ll get into more detail later, that might go into this category.
03:49
And then you can visualize them there and say, Okay, that’s going to be subtracted out to get to the AGI,
03:54
then you’ve got the itemized deductions and the standard deductions, you’re going to take the greater of the two. So you could start to think of what’s the floor on the standard deduction.
04:03
And you want to think about that by filing status, single 12,005 50, Married 25 One, for example, and so on. And the itemized deductions, we can see a sub Schedule A Schedule A, which is going to give us the more detail we can start to think okay, medical taxes, interest.
04:21
And when you think about itemized deductions, now we have to think, okay, are they going to itemize and when they do itemize is that particular deduction deduction have some kind of AGI phase out limitation on it, for example,
04:33
and then what’s going to be the impact if I pull it over to the front line of the formula. And so then if I go on, and then you got down below the credits, of course, they’re going to be after the taxes down below,
04:44
and then the payments that are taking place, and again, you could break those out in like sub schedules. That’s the same kind of thing that’s happening here, on the actual form 1040.
04:54
So you can see up top here’s this whole top section is basically the income type of section Notice that they’re breaking out some of the detail instead of on a separate schedule,
05:04
they’re just putting it on the first page of the 1040. But then you have, if I hit the little plus button here, on the schedule one, then you have this additional income.
05:14
Other stuff, just like we saw here with our second page, that’s going to pull in to the first line on basically our formula, which you can kind of think of basically the front page of the 1040. So the 1040 is a little bit more expanded in its format.
05:32
And it doesn’t look exactly like if you were to create this, for example, from scratch, and it hadn’t been something that has always been modified and built on and so on, then you would probably make it looks, your 1040 looks something like this, you’d say,
05:45
Okay, I’m just going to put the tax formula up front, and then I’m going to have a separate schedule for all the other detail that I’m going to pull into that line item, the actual tax form has been, has been evolving for, you know, as long as it’s been in existence,
05:59
So they did a big revamp on it. And they did do some of that they put these schedules in line here, which kind of simplified it. So you have less need for like different kinds of form 1040, like an easy 1040 And a moderate 1040.
06:13
Because if it’s easy or moderate, it should be on a different scheduled, right, you should just be adding more schedules to make it more complex or not you would think would be one way you can think about it a very common way that many people would structure it.
06:25
So in any case, then you can go through the through the different line items here, and you’ve got the the adjustments to income. And those would then be found in the schedule one, page two, and these adjustments, then are going to be on a separate page, and then they pull in to the 1040.
06:45
So you can see when you’re actually visualizing this, you’re probably not visualizing each line, you’re not going to be like unless you have a good like photographic memory or something, you’re not going to be like,
06:53
Okay, there’s line, whatever, there’s line, whatever I’m pulling it in from this other schedule, you’re probably going to visualize it more like a formula.
07:01
And say that’s the income line, which is supported by like the Schedule C, which would break out the detail of income and expenses. That’s the adjustments to income line that you’re talking about, which is supported by this other schedule that I’m going to basically be pulling in.
07:16
So if we if we start to think about it that way, we could say, okay, obviously, the first thing would be like, income would be involved. If you had w two income,
07:24
I’d say okay, that’s gonna be in the income line, I might have another schedule in my worksheet saying that’s w two income, which would flow through the to the first page of my tax formula, what would be the impact if that was the only thing involved?
07:36
Well, then if they’re taking the standard deduction, they’d have a standard deduction, which would be dependent upon whether they’re single married or so on, which you can have a schedule for, and you can start to kind of get that number down increases each years typically.
07:50
And if that’s the only thing involved, then you can basically say, okay, then the income minus that standard deduction would give us the taxable income at seven 450. So I could come back over here and say,
08:00
Let’s double check that in the software, the 100,000, minus the 12,005, which they’re getting from the standard deduction, which we’ll talk about later, 12,005 50, of single 25 100, if married, and so on, gets us to the taxable income of the 87 450.
08:16
Notice that this, this whole income statement is something that you could start to visualize what you can’t visualize in your mind very easily, again, unless you’re like a math whiz, you got some kind of kind of thing,
08:27
but you can’t calculate the progressive tax system in your mind. Why? Because it’s a progressive tax system, they have to use the tables. And you might have things like dividends and capital gains.
08:37
So that’s where you have to rely on the software, typically, you can double check it, but you’re basically relying on the software to actually calculate the tax, in this case, 1515. So it’s okay, the tax, the tax is actually 15015.
08:53
And then you can get the average rate. And then you’ve got the second half, which has to do with any credits that are involved in payments that are going to be involved, which you can visualize as well, because you can say,
09:04
Okay, what happened on the W two, I made a payment on the W two in terms of withholdings. And so you could say, well, once I have the tax, which I can’t really visualize the Calculate,
09:13
but I know that the payment is whatever that that tax is is going to is going to lower the amount of tax that is actually due, and possibly lead to a refund in a similar kind of thing as the credits. So that’s how you would kind of visualize it. And then you can see each of these categories, I could go back to the first page of the 1040 and say,
09:31
Okay, well, what if there was something else happening in income, such as interest or something like that? Well, that’s another income line items. So you’re saying income line item interest, another $1,000 of interest,
09:43
I would expect that would increase my income line, which would increase my income line here, possibly having no effect if the only other thing is the standard deduction.
09:51
So I would think that would increase my taxable income. And then I would think if I knew my marginal tax rate, that would increase my taxes not by the average tax, but by the marginal tax,
10:02
I would have to then put in the tax here. Again, if I go into the tax software, I could go into the data input and say, Okay, there’s income. And this I’m doing this unless cert, but whatever tax software would work, I can kind of double check that and say this is from day one, income. And we’ll say that this is 1000.
10:23
And bring it on back on over to the forums and see that the forms calculated. Now notice I’m inputted with the software, I can also double check it with the form by ACH by adding up the form right there, here’s the 100,000. There’s the 1000 line, taxable interest,
10:38
then this line 19 says adds line one, two, B, three, B, four, B, five, b, six, B and so on, there’s the one a 1000, you’re probably not going to think in your head will line nine says add line one, two, B, three B, that’s why the form is way too tedious to visualize. But then then you got the 12,005 50.
10:59
Which brings us down to the 88 450, which which we can visualize as an income statement, we can’t visualize the actual tax calculation again, because it’s a progressive tax, we might be able to get an idea of what the added tax would be,
11:13
by applying the marginal tax rate seeing where we left off last time, and then saying, well, it’s another $1,000, that are going to be taxed at the highest tax bracket. And that will be the 15 to 55. So the 15 to 55. If we go back on over here, when five, to 55.
11:30
And so that’s in the wrong spot, we’re gonna say 152 55, and then about a marginal tax rate of 1702. And there we have it. Now, tax software will often give you a format, the cert has it here, most software will have like a formula summary.
11:47
Because it’s easier, easier to visualize this looks a lot similar to the Excel worksheet, and the tax formula that we set up here. And it’ll also give you this one will give you the marginal tax rate at 24.
11:58
So I would have expected that that last 1000 increased the tax liability times 1000 times the marginal tax rate the 24%. Right. So if I, if that was the if we didn’t go up to another tax rate. So if I go back on over and say, let’s, let’s delete that one, let’s bring it back to where we were.
12:17
Let’s bring it back to our baseline of 100,000. And let’s say that something happened on this line, we’re gonna say, okay, something happened, that’s an adjustment to income. Well, I could say, okay, adjustment to income, is going to be here, let’s say they put money into an IRA, they put, you know, 1000, into an IRA now, so 1000 into an IRA.
12:37
Well, what’s that going to do, I can visualize that that is going to be here pulling into my first line item on the formula. And that’s going to take my income, which I’m going to bring it back down to one, back down to 100,000. What happened, income is back down to 100,000. There it is.
12:57
And then my adjustment will be 1000, bring it down to 99,000. So I could start to visualize what’s going to happen on this is going to be above the line deduction, it’s going to have an impact on AGI.
13:07
And if it has an impact on AGI, that’s also possibly going to have an impact on any phase outs and credits that have phase outs and deductions that have phase outs, I don’t think it’s going to have an impact on the standard deduction.
13:18
Generally, if that’s what they’re taking, so that should give us to the 8086 450. I could check that in the software and say,
13:25
Okay, let’s go to the software. And let’s say we’ve got a deduction for an IRA. And I’m just gonna say, All right, it’s $1,000, Ira deduction, pulling it back over, I can kind of double check this scenario, and then look at it in terms of the tax software. So I could say,
13:42
Okay, there’s my 100,000. And then I’ve got the 1000, here that pulls into kind of like the first page or kind of like my formula, the 1000, which is pulling in from schedule one, I can see how it works in the software now, or in the tax form by reading it and say,
13:57
Okay, it says adjustments to income from schedule one, line 26. Well, now schedule one is something I have to use. That’s why it’s bold, and wizard here. And I can go in here and say, All right, now I got to go to page two.
14:08
And there’s the 1000, right there on the IRA that pulled into page one of the form 1040, bringing the adjusted gross income to the 99,000, matching out to what we have here, and then the deduction standard still up at 1255. Five, that brings us to the 86 450 86 450,
14:28
which I can verify kind of in my mind almost or just think about the differences or at least the impacts. I can’t verify the tax in my mind, because it’s the progressive tax system. But if I knew where I was at on the baseline of the 100,000,
14:43
I can predict that I’m going to have a tax benefit. If I get this full deduction of 1000 of the marginal tax rate, the highest tax rate that we’re at.
14:52
So I could go back on over and say, okay, then that’s going to be that’s going to be for the taxes 1417 Seven, five now so I could see okay, 14 775 on the tax here 14775.
15:08
And then that gives us the average tax of 20.6. Is that right? So then if I go to the tax summary, the average tax, something doesn’t seem right there 14 775.
15:22
Let’s go back on over 14 sevenths, that should be 14775. There it is 17.1 17.1 on the average or effective 20, fours to the highest tax bracket. And so you can go into each of these line items. And I can say,
15:40
Okay, let’s go back to the baseline and say, Well, what if I go back to the 100,000 starting point, it’s easier if you go back to the 100. Obviously, this becomes more and more complex when you have all these things building up on each other.
15:54
But if something’s in the itemized deductions, then I have to say, okay, that’s going to be an itemized deduction, is it going to be relevant is it going to be greater than the standard deduction, and if it is,
16:05
then then what’s going to be the benefit on that one, so that would be on the Schedule A, so let’s go to the interest. And let’s make the interest just 15,000, just to make it higher than the standard.
16:16
So now I’m going to take the higher of the two. So I’m taking the itemized as opposed to the standard, I have my formulas, which are the if then formulas helping me figure that out.
16:26
And so we’ll pick up the 15. And so then that’s going to have an impact. In this case, it’s a little tricky, because the only real benefit I’m getting from that is the difference between the 12 550 I would have got before and the 15.
16:40
So although I’m getting a whole $15,000 deduction, really, I’m only getting a benefit from the difference of what I would have got to deduct before, and how much more I get to deduct after.
16:50
So in any case, I can see that. So now I’m going to have the taxable income of the 85,000. And they don’t have to figure out the tax. If I was to go to the tax software, say okay, what let’s check that out, let’s get us back to the baseline. Let’s go to the deductions for the Schedule A,
17:07
let’s bring it down to the interest and say we had mortgage interest, mortgage interest, I said 15,000, and bring that in. So now I’ve got the 15,000 on the interest. And notice it’s a little bit different, right? It’s a calculated 15 875. Why? Because I might be able to get other items here.
17:30
So now I gotta go to the standard to this item. I also had state taxes, because state taxes of 879. So I’m going to add that in because now that I’ve accessed the ability to have those taxes taken, so I’m going to we’ll get into that later 879. I’ll add that in.
17:48
So now I can see, okay, I’m at the 15 879 Pulling over to the front page in my formula, that gives me my taxable income at 4121. So that pulls into the first page of the 1040.
18:02
So I can say okay, 15, and there’s the ad for one to one, and then I’ll let the software calculate the tax. So the software is going to calculate the tax at the 14 to 56. So I’m going to sit Okay, 14256.
18:17
And so there we have it. And so and again, we’d have to do the same thing for any credits that would be applied down below. And then on the payments, typically payments, for example, withholdings from the W two or other line items that you could start to visualize.
18:31
But that’s the general idea, we’ll start to go through this on a line by line component. But that’s how you that’s how you want to start to think about it.
18:38
When people ask you questions when you just do the tax returns. If you’re not talking to anybody when you do the tax returns, then clearly you’re just going to do the data input into the system.
18:47
And you still want to be able to visualize the line by lines that will be impacted, so that you can go to the form 1040, and then be able to go to the detailed reports and see how the detailed reports fit into the 1040. So that if there’s any problems, you can visualize how it is happening.
19:03
And then when people ask you questions, you can you can tell them what you can know. And what you can’t know, what you can know if it’s an income line item is that the income will probably increase.
19:14
And that’s going to have generally an increase to the AGI which could affect any phase outs could affect any deductions and so on.
19:21
And if there’s a phase out component, and it’s normally going to increase the taxes, you can know that if you visual if someone asks you about something and you know that it falls into the adjusted to income or the above the line deduction,
19:34
well, that’s going to be a kind of deduction above the line, you should be able to get it without itemizing it’s going to decrease your AGI could have a positive impact on phase outs for credits and deductions and so on should be tax benefit.
19:46
I don’t know what the tax benefit will be exactly, because the tax rate is complex, but it should be in alignment with your highest tax bracket your
19:54
marginal tax bracket. And then itemized deductions will do you itemize Do you have the capacity to itemize Only if you itemize, is it going to be beneficial? Is that deduction going to take you over the capacity to itemize? If so, you’re probably going to get,
20:08
you know, you’re going to get a benefit on in terms of a deduction, it’s going to take down your taxes, right?
20:12
And then you go into the tax software, and actually input that into the system and be able to see whether or not what you predicted should happen is actually what’s what’s going to happen with the software.
20:24
And usually people do that somewhat intuitively right, we have an idea of what’s going to happen, I’m going to put it into the software,
20:30
I’m going to see that what I thought was going to happen, it’s going to happen if it didn’t, then I’m going to go in and try to figure out why instead of every time you go into the software, you reread every line,
20:41
it’s useful to reread every line in the software like once or twice, or to do a whole tax return by hand without software useful tool, not practical in practice, because you can’t visualize the whole sock too tedious to read through the line by line instructions,
20:59
you got to you got to have a more simplified kind of model in your mind other than memorizing every line item and the text in terms of which boxes are going to be added together so that you can get an intuitive understanding,
21:13
and then use the software to help you to build that intuitive understanding as you work practice problems. And as you run scenarios, and as you do projections,