V_Lookup(1)

# Use a lookup formula to populate the marginal rate

This preview shows page 1. Sign up to view the full content.

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

Unformatted text preview: ookup formula to populate the Add: Tax of previous brackets cell. Settings Taxable Income \$40,500 Results Taxable Income Less: Income not in tax bracket \$40,500 Income taxed in bracket Marginal rate \$40,500 Tax of current bracket Add: Tax of previous brackets \$- Total Tax \$- Tax Table - Single - 2012 If your income is From But not over To \$\$8,701 \$35,351 \$85,651 \$178,651 \$388,351 \$8,700 \$35,350 \$85,650 \$178,650 \$388,350 The tax is Cumulative Tax \$Err:508 Err:508 Err:508 Err:508 Err:508 Plus Marginal Rate Of the amount over Range 10% \$15% \$8,700 25% \$35,350 28% \$85,650 33% \$178,650 35% \$388,350 O n Yo ur Own 3 Plea se perform the following: Restrict the Da te input cell to a ccept va lid da tes between the Begin a nd End da te Settings below. Use a lookup formula to retrieve the Adjusted Close price for the da te entered. If the da te entered does not a ppea r in the historica l list, the price a s of the previous close should be used. For exa mple, if the user enters a da te of 1/9 /2000, since 1/9 /2000 is not in the Ta ble below the va lue for 1/7/2000 should be returned to the cell. Price Da te Adj Close 2/1/2000 Settings Begin da te End da te 1/3/2000 7/31/2012 Historical Stock Quote for GE Da te Open High Low Close Volume Adj Close 1/3/2000 153 153.6 9 14 9 .19 150 2206 9 800 34 .51 1/4 /2000 14 7.25 14 8 14 4 14 4 221214 00 33.13 1/5/2000 14 3.75 14 7 14 2.56 14 3.75 2729 2800 33.07 1/6 /2000 14 3.13 14 6 .9 4 14 2.6 3 14 5.6 7 19 873200 33.52 1/7/2000 14 8 151.88 14 7 151.31 2014 14 00 34 .81 1/10/2000 152.6 9 154 .06 151.13 151.25 15226 500 34 .8 1/11/2000 151 152.6 9 150.6 3 151.5 15123000 34 .86 1/12/2000 151.06 153.25 150.56 152 1834 2300 34 .9 7 1/13/2000 153.13 154 .9 4 153 153.75 14 9 53500 35.37 1/14 /2000 153.38 154 .6 3 14 9 .56 151 184 80300 34 .74 1/18/2000 14 9 .6 3 14 9 .6 3 14 6 .75 14 8 1829 6 700 34 .05 1/19 /2000 14 6 .5 150.9 4 14 6 .25 14 8.72 14 84 9 700 34 .22 1/20/2000 14 9 .06 14 9 .75 14 2.6 3 14 5.9 4 30759 000 33.58 1/21/2000 14 7.9 4 14...
View Full Document

## This note was uploaded on 03/28/2014 for the course ACC 562 taught by Professor Staff during the Spring '14 term at Arizona.

Ask a homework question - tutors are online