Find Jobs
Hire Freelancers

USA Taxation - Excel formula

$30-250 USD

已完成
已发布将近 7 年前

$30-250 USD

货到付款
I have built most of the excel spreadsheet. I am looking for assistance with the formula I want inputted in cell D15. Most of the work is done, however, I need assistance with the big formula to be placed in cell D15. Please also look over my formulas, but please do not change any of the formatting in others cells. I am looking to get an estimated tax payment from a federal, state, and NIIT (Medicare tax) perspective. I only have 3 state inputs currently, which are the most important, which will be New York, New Jersey and Connecticut. If you can make it love for all states, that would be very helpful, but not necessary. I have created minor formulas , starting in cell O58, to calculate each the tax from a state perspective. I have inputted the state tax brackets beginning in cell O47, with an active formula in cells O58:O65, T58:T64, Y58:Y64. Federal tax bracket (Married Filing Jointly) is inputted in O35, with an active formula from R35:R4. I believe my active formulas are accurate outputs. NIIT (Medicare Tax) only comes applicable if you have over $250,000 of taxable income. that formula is in cell N44. N35, N44 and N47 hold the necessary output depending on their taxable income (therefore, determining their tax rate). I have inputted a small state input in cell B14. Again, only change I want is in cell D15. In terms, I essentially want the output to be , If you make X, and you are from New Jersey or New York, or Connecticut, this is how much you will pay total from a federal, state and medicare tax perspective. Keep in mind that i want Marginal numbers. For example, If a guy makes $150,000, from a federal perspective, he is charged 10% on 18,650, then 15% on 57,249 (75,900-18,651), then 25% on 74,099 (150,000-75,901). Any questions please let me know. Looking for, again, as described above, If a guy makes x, and is from New York or New Jersey or Connecticut, how much do they pay in taxes (Federal + State + NIIT). that's the solve.
项目 ID: 14647608

关于此项目

6提案
远程项目
活跃7 年前

想赚点钱吗?

在Freelancer上竞价的好处

设定您的预算和时间范围
为您的工作获得报酬
简要概述您的提案
免费注册和竞标工作
颁发给:
用户头像
Hi, I am interested to work with you. Please send me a message so that we can discuss more. You may Check my experiance by visiting my Profile. Thanks, Sajib Relevant Skills and Experience excel Proposed Milestones $100 USD - project
$100 USD 在3天之内
5.0 (62条评论)
5.6
5.6
6威客以平均价$168 USD来参与此工作竞价
用户头像
Hello, I’m an Excel expert and I would like to help you with your project. Please check my profile and contact me to discuss further details. Regards. Stay tuned, I'm is still working on this proposal.
$150 USD 在3天之内
4.9 (273条评论)
7.2
7.2
用户头像
I have experience in accounting, Financial Report Tools, and in Excel/VBA. I served as CFO, Controller, and Chief Accountant at global parent companies, and I have extensive experience in accounting, consolidating, forecasting, budgeting, and costing I am a specialist in managing cash flow and liquidity solutions for the multi-currency environment and globally including collections, payments, inventory, and taxation. I am a financial professional and a guru in Excel and VBA. I create creative and sophisticated financial & statistic models in a simplified and logical manner. I have extensive knowledge and expertise in advanced formulas, Pivot Tables, Visual Basic Application including preparation of dynamic dashboards, screen layout's (user-forms), drop-down boxes, generator reports, and charts. More on that, I develop financial modules including business valuation methodology & ratios (INPV, IRR, DCF, MCDA, CPI, SPI, EVM, KPI, SPE, SPV FVC, sensitive analysis, correlation, and regression, etc.)Therefore, I can help you design, build or modify spreadsheets in Excel to deliver professional analysis and reliable functionality suited to your needs. I offer you 35+ years of experience working on a variety of companies including, VC's, privet investors, entrepreneurs, startups, retailers, power plants, farms, insurance, universities, constructions, medical equipment manufacturer companies, among others.
$250 USD 在3天之内
4.9 (71条评论)
6.9
6.9
用户头像
Hello. I checked your Excel spreadsheet. I have extensive experience in Excel, Coding and Data processing.I can do your project in less than 5 Days according to your description with full delivery and without error. I would also complete your project with the highest precision and quality.
$250 USD 在5天之内
4.9 (86条评论)
5.6
5.6
用户头像
I’ve great understanding of MS Excel especially with pivot tables, charts, advance formulas and VBA codes. Just reviewed attached file. do let me know i can work on it. Relevant Skills and Experience MS Excel Proposed Milestones $100 USD - Upon Completion
$100 USD 在1天之内
4.5 (34条评论)
5.2
5.2
用户头像
Hi, I have gone through the project thoroughly and understood your project requirements. With years of experience and dedicated efforts, I will be glad to offer an outstanding services; if you can be kind enough to shortlist me for this project. Please give me a chance and initiate a chat so we can discuss further. Looking forward to work with you. Thanks
$155 USD 在3天之内
4.8 (2条评论)
2.8
2.8

关于客户

UNITED STATES的国旗
New York, United States
5.0
1
付款方式已验证
会员自6月 14, 2017起

客户认证

谢谢!我们已通过电子邮件向您发送了索取免费积分的链接。
发送电子邮件时出现问题。请再试一次。
已注册用户 发布工作总数
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
加载预览
授予地理位置权限。
您的登录会话已过期而且您已经登出,请再次登录。