# Chapter 6 - Chapter 06 - Exercise 12 Calculate SUTA and...

This preview shows pages 1–2. Sign up to view the full content.

Calculate SUTA and FUTA Tax Due. SUTA Tax 3% First \$7,000 FUTA Tax 0.80% First \$9,000 Quarter Due First Qtr \$230,900 6,927 1,847 Second Qtr \$250,655 7,520 2,005 Third Qtr \$175,450 5,264 1,404 Fourth Qtr \$222,430 6,673 1,779 Total \$26,383 \$7,035 Directions: d. Total Column C and Column D. Gross Earnings SUTA Tax Due FUTA Tax Due a. Enter a formula in Cell C7 to calculate SUTA (SUTA = Gross Earnings x Cell B4). Copy the formula down Column C. Remember to make the reference to Cell B4 an absolute cell reference. b. Enter a formula in Cell D7 to calculate FUTA (FUTA = Gross Earnings x Cell B5). Copy the formula down Column D. Remember to make the reference to Cell B5 an absolute cell reference. c. Format the cells in Columns C and D for Currency and 0 Decimal places. Set the Currency symbol to none. e. Format the Totals for Currency and 0 Decimal places. Set the Currency symbol to \$. f.

This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document
This is the end of the preview. Sign up to access the rest of the document.

## This note was uploaded on 04/13/2010 for the course BUSINESS 15643 taught by Professor Schilz during the Spring '10 term at École Normale Supérieure.

### Page1 / 2

Chapter 6 - Chapter 06 - Exercise 12 Calculate SUTA and...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document
Ask a homework question - tutors are online