_After Tax Financial Planing Example

xlsx

School

Saint Mary's College of California *

*We aren’t endorsed by this school

Course

1001

Subject

Finance

Date

Jan 9, 2024

Type

xlsx

Pages

12

Uploaded by SuperHumanPencilDragon83

Report
Average Starting Salary by Major ks edit ks edit Bay Area Average Annual Income Taxable Income Rate 10% $ - $ 9,699 12% $ 9,700 $39,474 22% $ 39,475 $84,199 24% $ 84,200 ### 32% 35% 37% $ Income Tax Owed Social Security Tax (6.2% of gross annual taxable income) Medicare (1.45% of gross annual taxable income) Average State tax 5% Average Benefits (healthcare, dental, optical) 5% Average Retirement Contributions 5% Total Taxes Owed After Tax Annual Income After Tax Monthy Income Monthly Expenses: Bay Area Average Signle Room (Studio) Rent/mo Bay Area Average Utilities 1 person Room (Studio)/mo Standard Deduction: Single 2019 Marginal Tax Brackets
Internet 8 Mbps/mo Cell Phone (Metro PCS)/mo Food at Home/mo (frugal/conservative) Miscelaneous (food outside home, apparel, travel, entertainment,etc Total Monthy Expenses Monthly Funds Lef Total Debt (including Student Loans)
Accounting Business Analytics Digital Media $58,755 $58,957 $52,017 - - - $12,200 $12,200 $12,200 = = = $46,555 $46,757 $39,817 Taxable Income $0-$9,699 970 970 970 $9,700-39,474 3,573 3,573 3,573 $39,475-84,199 1,558 1,602 75 $84,200-160,724 $160,725-204,099 $204,100-510,299 $510,300 and above sum of above $6,100 $6,145 $4,618 check to orig $0 $0 $0 $6,100.38 $6,144.82 $4,618.02 $2,886.41 $2,898.93 $2,468.65 $675.05 $677.98 $577.35 $2,328 $2,338 $1,991 $2,328 $2,338 $1,991 $2,328 $2,338 $1,991 $16,645 $16,735 $13,637 $29,909.91 $30,021.72 $26,180.43 $2,492.49 $2,501.81 $2,181.70 $1,350 $1,350 $1,350 $99 $99 $99
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
$50 $50 $50 $40 $40 $40 $175 $175 $175 c.) $50 $50 $50 $1,764 $1,764 $1,764 = = = $728 $738 $418
Economics Enterpreneurship Finance Global Business $63,185 $50,790 $58,657 $67,140 - - - - $12,200 $12,200 $12,200 $12,200 = = = = $50,985 $38,590 $46,457 $54,940 970 970 970 970 3,573 3,573 3,573 3,573 2,532 (195) 1,536 3,402 $7,075 $4,348 $6,079 $7,945 $0 $0 $0 $0 $7,074.98 $4,348.08 $6,078.82 $7,945.08 $3,161.07 $2,392.58 $2,880.33 $3,406.28 $739.28 $559.56 $673.63 $796.63 $2,549 $1,930 $2,323 $2,747 $2,549 $1,930 $2,323 $2,747 $2,549 $1,930 $2,323 $2,747 $18,623 $13,089 $16,601 $20,389 $32,361.92 $25,501.29 $29,855.67 $34,551.01 $2,696.83 $2,125.11 $2,487.97 $2,879.25 $1,350 $1,350 $1,350 $1,350 $99 $99 $99 $99
$50 $50 $50 $50 $40 $40 $40 $40 $175 $175 $175 $175 $50 $50 $50 $50 $1,764 $1,764 $1,764 $1,764 = = = = $933 $361 $724 $1,115
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
Marketing $55,003 - $12,200 = $42,803 970 3,573 732 <<< marginal bracket $5,275 $0 $5,274.94 $2,653.79 $620.64 $2,140 $2,140 $2,140 $8,549 $34,253.63 $2,854.47 $1,350 $99
$50 $40 $175 $50 $1,764 = $1,090
Editable Customize Accounting Business Analytics Average Starting Salary by Major 120,000 79,875 67,284 - - - 12,950 12,950 12,950 = = = Subtotal 107,050 66,925 54,334 - - - Retirement Contributions 2,500 2,500 2,500 = = = Adjusted Gross Income (AGI) 104,550 64,425 51,834 bottom of range top of range 10% $ - $ 9,700 970 970 970 12% $ 9,701 $ 39,475 3,573 3,573 3,573 22% $ 39,476 $ 84,200 14,316 5,489 2,719 24% $ 84,201 $ 160,725 4,884 32% $ 160,726 $ 204,100 0 35% $ 204,101 $ 510,300 0 37% $ 510,301 bottom of range top of range 1% $ - $ 10,099 101 101 101 2% $ 10,100 $ 23,942 277 277 277 4% $ 23,943 $ 37,788 554 554 554 6% $ 37,789 $ 52,455 880 1,598 0 Federal Income Tax owed sum of rows 15-18 23,743 10,032 7,262 Social Security Tax 6.2% of AGI 6,637 4,149 3,369 Medicare 1.45% of AGI 1,552 970 788 CA Income State tax owed sum fo rows 23-26 1,812 2,530 932 Average Benefits 5,228 3,221 2,592 Total Taxes and Benefits 38,971 20,902 14,942 Standard Deduction: Single 2022 Federal Marginal Tax Brackets 2022 CA Marginal Tax Brackets Med/Dent/Vis 5% of AGI
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
After Tax Annual Income 65,579 43,523 36,892 After Tax Monthy Income 5,465 3,627 3,074 Monthly Expenses: Bay Area Avg Single/Studio Rent 1,900 1,900 1,900 Bay Area Avg Utilities Single/Studio 100 100 100 Internet 8 Mbps/mo 50 50 50 Cell Phone (Metro PCS) 40 40 40 Food at Home(frugal/conservative) 175 175 175 Insurance (car, renters, etc.) 100 100 100 50 100 100 100 100 100 Trips, vacations, travel 40 50 0 500 500 500 Total Monthy Expenses sum of above 3,055 3,115 3,065 = = = Monthly Funds Left 2,410 512 9 etc.) bus, train, uber, Fastrak, Clipper, etc.) car leases, etc.) overextended
Digital Media Economics Entrepreneur Finance Global Business Data Science Marketing 55,350 83,937 55,281 89,725 77,140 103,117 83,816 55,350 - - - - - - 12,950 12,950 12,950 12,950 12,950 12,950 12,950 = = = = = = = 42,400 70,987 42,331 76,775 64,190 90,167 70,866 - - - - - - - 2,500 2,500 2,500 2,500 2,500 2,500 2,500 = = = = = = = 39,900 68,487 39,831 74,275 61,690 87,667 68,366 970 970 970 970 970 970 970 3,573 3,573 3,573 3,573 3,573 3,573 3,573 93 6,382 78 7,656 4,887 10,602 6,356 832 101 101 101 101 101 101 101 277 277 277 277 277 277 277 554 554 554 554 554 554 554 127 880 0 880 880 880 880 4,636 10,925 4,621 12,199 9,430 15,977 10,899 2,629 4,401 2,625 4,760 3,980 5,590 4,394 615 1,029 614 1,113 931 1,307 1,028 1,058 1,812 932 1,812 1,812 1,812 1,812 1,995 3,424 1,992 3,714 3,085 4,383 3,418 10,933 21,592 10,782 23,597 19,237 29,069 21,550
28,967 46,895 29,049 50,678 42,453 58,598 46,816 2,414 3,908 2,421 4,223 3,538 4,883 3,901 1,900 1,900 1,900 1,900 1,900 1,900 1,900 100 100 100 100 100 100 100 50 50 50 50 50 50 50 40 40 40 40 40 40 40 175 175 175 175 175 175 175 100 100 100 100 100 100 100 100 100 100 100 100 100 100 100 100 100 100 100 100 100 0 0 0 0 0 0 0 500 500 500 500 500 500 500 3,065 3,065 3,065 3,065 3,065 3,065 3,065 = = = = = = = (651) 843 (644) 1,158 473 1,818 836
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help