Find Jobs
Hire Freelancers

USA Taxation - Excel formula

$30-250 USD

Terminado
Publicado hace casi 7 años

$30-250 USD

Pagado a la entrega
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 del proyecto: 14647608

Información sobre el proyecto

6 propuestas
Proyecto remoto
Activo hace 7 años

¿Buscas ganar dinero?

Beneficios de presentar ofertas en Freelancer

Fija tu plazo y presupuesto
Cobra por tu trabajo
Describe tu propuesta
Es gratis registrarse y presentar ofertas en los trabajos
Adjudicado a:
Avatar del usuario
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 en 3 días
5,0 (62 comentarios)
5,6
5,6
6 freelancers están ofertando un promedio de $168 USD por este trabajo
Avatar del usuario
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 en 3 días
4,9 (273 comentarios)
7,2
7,2
Avatar del usuario
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 en 3 días
4,9 (71 comentarios)
6,9
6,9
Avatar del usuario
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 en 5 días
4,9 (86 comentarios)
5,6
5,6
Avatar del usuario
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 en 1 día
4,5 (34 comentarios)
5,2
5,2
Avatar del usuario
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 en 3 días
4,8 (2 comentarios)
2,8
2,8

Sobre este cliente

Bandera de UNITED STATES
New York, United States
5,0
1
Forma de pago verificada
Miembro desde jun 14, 2017

Verificación del cliente

¡Gracias! Te hemos enviado un enlace para reclamar tu crédito gratuito.
Algo salió mal al enviar tu correo electrónico. Por favor, intenta de nuevo.
Usuarios registrados Total de empleos publicados
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Cargando visualización previa
Permiso concedido para Geolocalización.
Tu sesión de acceso ha expirado y has sido desconectado. Por favor, inica sesión nuevamente.