Calculating Federal Income Taxes Using Excel | 2023 Tax Brackets

Подписаться 7 тыс.

Просмотров 39 тыс.

50% 1

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]

Развлечения

Опубликовано:

10 авг 2023

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 34

@peterneame8295 11 дней назад

Excellent explanation - thanks

@Elephantine999 4 месяца назад

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 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 Месяц назад

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

@samblasc 19 дней назад

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

@WelamAne 7 месяцев назад

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

@malinhiles Месяц назад

Incredibly helpful, thanks!

@matthew5775 6 месяцев назад

Thank you for this.

@edsterling5258 9 месяцев назад

Great video

@dennissanchez5171 3 месяца назад

Thanks, that's great!

@gloriamwaba640 4 месяца назад

Very clear

@mariojavierjimenezrosario5793 Месяц назад

Great video !!!

@mwa1252 10 месяцев назад

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

@professorikram 10 месяцев назад

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

@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 6 месяцев назад

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 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 Месяц назад

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 6 месяцев назад

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

@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!

@BaldytheBear 17 дней назад

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 16 дней назад

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 7 месяцев назад

Sr, please share Excel file for practice

@professorikram 3 месяца назад

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

@gethachellaiah7756 5 месяцев назад

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

@gabesellsatx 2 месяца назад

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 5 месяцев назад

What would the formula look like for D26 & D45

@natalieomeara6280 5 месяцев назад

I figured it out 🙂

@spoothayil 3 месяца назад

Can you share this excel with me?

@professorikram 3 месяца назад

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

@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 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