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]

Пікірлер: 34

  • @Elephantine999
    @Elephantine9994 ай бұрын

    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

    @professorikram

    3 ай бұрын

    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
    @bonjoursaigonАй бұрын

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

  • @WelamAne
    @WelamAne7 ай бұрын

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

  • @malinhiles
    @malinhiles2 ай бұрын

    Incredibly helpful, thanks!

  • @samblasc
    @samblascАй бұрын

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

  • @matthew5775
    @matthew57757 ай бұрын

    Thank you for this.

  • @edsterling5258
    @edsterling525810 ай бұрын

    Great video

  • @dennissanchez5171
    @dennissanchez51713 ай бұрын

    Thanks, that's great!

  • @peterneame8295
    @peterneame829522 күн бұрын

    Excellent explanation - thanks

  • @gloriamwaba640
    @gloriamwaba6404 ай бұрын

    Very clear

  • @mariojavierjimenezrosario5793
    @mariojavierjimenezrosario5793Ай бұрын

    Great video !!!

  • @mwa1252
    @mwa125210 ай бұрын

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

  • @professorikram

    @professorikram

    10 ай бұрын

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

  • @professorikram

    @professorikram

    3 ай бұрын

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

  • @UrAvgTxDad
    @UrAvgTxDad6 ай бұрын

    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

    @professorikram

    3 ай бұрын

    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

  • @garycurtis
    @garycurtis2 ай бұрын

    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?

  • @mbeydiya1
    @mbeydiya16 ай бұрын

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

  • @professorikram

    @professorikram

    6 ай бұрын

    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!

  • @gethachellaiah7756
    @gethachellaiah77565 ай бұрын

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

  • @BaldytheBear
    @BaldytheBear28 күн бұрын

    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

    @professorikram

    27 күн бұрын

    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.

  • @usmaniqbal1836
    @usmaniqbal18367 ай бұрын

    Sr, please share Excel file for practice

  • @professorikram

    @professorikram

    3 ай бұрын

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

  • @natalieomeara6280
    @natalieomeara62805 ай бұрын

    What would the formula look like for D26 & D45

  • @natalieomeara6280

    @natalieomeara6280

    5 ай бұрын

    I figured it out 🙂

  • @gabesellsatx
    @gabesellsatx2 ай бұрын

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

  • @professorikram

    @professorikram

    Ай бұрын

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

  • @spoothayil
    @spoothayil4 ай бұрын

    Can you share this excel with me?

  • @professorikram

    @professorikram

    3 ай бұрын

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

  • @Mr._L30.
    @Mr._L30.6 ай бұрын

    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

    @professorikram

    3 ай бұрын

    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

Келесі