Calculating Federal Income Taxes Using Excel | 2023 Tax Brackets

In this video, I use a simple Excel example to show how you can calculate federal income taxes depending on your taxable income and tax bracket. In the process you will also learn the difference between your average and marginal tax rate.
Link to Excel (Google) Sheet: docs.google.com/spreadsheets/...
Reference: Qs 2-4, Corporate Finance 13e [Ross, Westerfield, Jaffe, Jordan]

[@Elephantine999]

I had thought this calculation would be easier than it was for me. After a couple of failed attempts at doing it myself, I found this and learned some new things. Thank you!

[@professorikram]

Glad you found it useful. Here is the link to the sheet: docs.google.com/spreadsheets/d/1T-aw3ZAtEfd3lIKMwy388D3L2ubOd2In/edit?usp=sharing&ouid=109710908030830270798&rtpof=true&sd=true

[@bonjoursaigon]

Incredible and very good explanation. Great teacher! :-)

[@WelamAne]

Good👍👍. I like the way you took your time to explain in details. Makes it easier to understand. 👍👍

[@samblasc]

Thanks so much, I was doing but I couldn't find the formula for the last tax rate, thanks a lot!

[@malinhiles]

Incredibly helpful, thanks!

[@matthew5775]

Thank you for this.

[@edsterling5258]

Great video

[@dennissanchez5171]

Thanks, that's great!

[@mariojavierjimenezrosario5793]

Great video !!!

[@gloriamwaba640]

Very clear

[@peterneame8295]

Excellent explanation - thanks

[@UrAvgTxDad]

You didn't explain how to do it for the last tax bracket. How would you calculate the taxes for everything over the last amount?\

[@professorikram]

Hey buddy! Here is the link to the sheet, which shows the formula: docs.google.com/spreadsheets/d/1T-aw3ZAtEfd3lIKMwy388D3L2ubOd2In/edit?usp=sharing&ouid=109710908030830270798&rtpof=true&sd=true

[@mwa1252]

Thanks! This is good... It would be much easier to follow along if the cell references (rows and columns) were visible.

[@professorikram]

Appreciate that feedback, I realized this after the fact as well. Will be more careful in subsequent videos. 🙏

[@professorikram]

Here is the link to the sheet: docs.google.com/spreadsheets/d/1T-aw3ZAtEfd3lIKMwy388D3L2ubOd2In/edit?usp=sharing&ouid=109710908030830270798&rtpof=true&sd=true

[@garycurtis]

This is so helpful and explained very clearly. Thank you so much. Would this apply to 2024 Taxes, or have the brackets changed? Also do these taxes cover social Security?

[@usmaniqbal1836]

Sr, please share Excel file for practice

[@professorikram]

Here you go: docs.google.com/spreadsheets/d/1T-aw3ZAtEfd3lIKMwy388D3L2ubOd2In/edit?usp=sharing&ouid=109710908030830270798&rtpof=true&sd=true

[@gethachellaiah7756]

For the average tax rate (married) 17.03% is at percentage 22%

[@mbeydiya1]

Hello there and thank you for the video! What happened to the standard deduction? Where do you remove that from?

[@professorikram]

Hi! So these calculations apply to Taxable income. The standard deduction applies to your AGI (Adjusted Gross Income) and helps reduce your taxable income.
I'm glad you brought this up though. I'll do a separate video on how to go from AGI to Taxable Income. Thanks for your comment!

[@BaldytheBear]

Question. So does this include the standard deduction? For example if the taxes owed are 33000 would I then subtract the standardized deduction for whatever that year is? 33000-14000 for example would be 19000 left over that I would actually owe?

[@professorikram]

Good question. The calculation in this video is based on what you are left with AFTER the deducions and credits have been accounted for. So, no. You would NOT subtract the standard deduction from this number.

[@gabesellsatx]

I tested out your calculator some parts are wrong for the if function on the married filed jointly part!

[@professorikram]

Hey! I'll check. Thanks for pointing this out.

[@natalieomeara6280]

What would the formula look like for D26 & D45

[@natalieomeara6280]

I figured it out 🙂

[@spoothayil]

Can you share this excel with me?

[@professorikram]

Here you go: docs.google.com/spreadsheets/d/1T-aw3ZAtEfd3lIKMwy388D3L2ubOd2In/edit?usp=sharing&ouid=109710908030830270798&rtpof=true&sd=true

[@Mr._L30.]

I’m lost already. I made 63,933, so can that simply be explained cause I’m still lost and have watched your video about 5 times already.

[@professorikram]

Sorry to hear that you're feeling lost. Where exactly - I can try and help. Here is the link to the sheet also, in case you find it useful: docs.google.com/spreadsheets/d/1T-aw3ZAtEfd3lIKMwy388D3L2ubOd2In/edit?usp=sharing&ouid=109710908030830270798&rtpof=true&sd=true