Pf 50082900 | Accounting homework help


Step 1


Combine the wage base and FICA tax rates applied to these wage bases into a single Excel file. In the process, compute the maximum employee (and employer) contribution to Social Security, based only on the maximum wage base. Here’s an example of a portion of the table:

Step 2


FICA (Federal Insurance Contributions Act) and SECA (Self Employment Contributions Act) represent the employer/employee contributions to OASDI and Medicare and contributions

for the self-employed or sole proprietor.

Notice that a self-employed

individual didn’t have to contribute to Social Security from 1937 through 1950.

Before the 1980s, self-employed taxpayers made a contribution to Social Security that was less than the employee’s and employer’s contributions, combined. However, one of the solutions

to the Social Security shortfall at that time was to phase in a catch-up provision, where,

starting in 1990, the employer (7.65%) and employee (7.65%) and the selfemployed (15.3%) make equivalent contributions. Effectively, the self-employed taxpayer makes both employer and

employee contributions.


Into the Excel file you completed in Step 1, add columns for the SECA tax rates applied to these wage bases. In the process, compute the maximum self-employed taxpayer’s contribution to Social Security, based only on the maximum wage base.

Also add a column for both employer and employee FICA components, so that we can compare

the combined employer and employee contributions to FICA to the SECA contributions. Here’s an example of a portion of the table:

Notice that the employee and employer contributions to FICA became equivalent to the self-employed taxpayer’s contribution to SECA in 1990.

Step 3

Prepare a simple Excel graphic to illustrate the combined dollar contributions of employee and employer to FICA compared to those for the self-employed taxpayer to SECA from 1937 through 2009.

Step 4

Under current law, a taxpayer with a salary of $110,000 for 2009 would pay only 7.65% on the first $106,500. The same would be said for the employer. However, also under current law, any amount in excess of the $106,500 wage base and earned income amount for 2009 would continue to be subject to the 1.45% Medicare contribution by both employer and employee, for a total of 2.9%.

Separately compute the amounts, in addition to the $16,294.50 from the above table, that the employee and employer would have to pay for Medicare, assuming a salary level of $110,000 for the 2009 calendar and tax year. Show your calculations.


Follow this procedure to submit your assignment:

1. On your computer, save a revised and corrected version of your assignment. Be sure it includes all of the information listed in your assignment.



Calculate the price of your order

550 words
We'll send you the first draft for approval by September 11, 2018 at 10:52 AM
Total price:
The price is based on these factors:
Academic level
Number of pages
Basic features
  • Free title page and bibliography
  • Unlimited revisions
  • Plagiarism-free guarantee
  • Money-back guarantee
  • 24/7 support
On-demand options
  • Writer’s samples
  • Part-by-part delivery
  • Overnight delivery
  • Copies of used sources
  • Expert Proofreading
Paper format
  • 275 words per page
  • 12 pt Arial/Times New Roman
  • Double line spacing
  • Any citation style (APA, MLA, Chicago/Turabian, Harvard)

Our guarantees

Delivering a high-quality product at a reasonable price is not enough anymore.
That’s why we have developed 5 beneficial guarantees that will make your experience with our service enjoyable, easy, and safe.

Money-back guarantee

You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.

Read more

Zero-plagiarism guarantee

Each paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.

Read more

Free-revision policy

Thanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.

Read more

Privacy policy

Your email is safe, as we store it according to international data protection rules. Your bank details are secure, as we use only reliable payment systems.

Read more

Fair-cooperation guarantee

By sending us your money, you buy the service we provide. Check out our terms and conditions if you prefer business talks to be laid out in official language.

Read more