Finance 380: Financial Modelling

profilejaymudda
f380.fall19.hwk1.xlsx
Home>Business & Finance homework help>Finance 380: Financial Modelling

BREW

State BCPC INC MB TAX FPCT POP TEMP
Alabama 30.2 $44,765 28 $1.05 51.5 4.87 62.8
Alaska 28.7 $73,355 32 $1.07 47.6 0.74 26.6
Arizona 29.5 $51,492 86 $0.16 50.3 7.02 60.3
Arkansas 26.7 $41,995 28 $0.35 50.9 3.00 60.4
California 25.5 $64,500 623 $0.20 50.3 39.54 59.4
Colorado 30.0 $63,909 334 $0.08 49.8 5.61 45.1
Connecticut 22.0 $71,346 49 $0.23 51.2 3.59 49.0
Delaware 33.6 $61,255 19 $0.16 51.6 0.96 55.3
Florida 27.4 $49,426 195 $0.48 51.1 20.98 70.7
Georgia 25.7 $51,244 53 $1.01 51.1 10.43 63.5
Hawaii 30.4 $73,486 14 $0.93 49.5 1.43 70.0
Idaho 27.8 $48,275 53 $0.15 49.9 1.72 44.4
Illinois 29.1 $59,588 181 $0.23 50.9 12.80 51.8
Indiana 25.9 $50,532 127 $0.12 50.7 6.67 51.7
Iowa 33.6 $54,736 70 $0.19 50.4 3.15 47.8
Kansas 28.3 $53,906 31 $0.18 50.2 2.91 54.3
Kentucky 24.4 $45,215 34 $0.84 50.8 4.45 55.6
Louisiana 33.9 $45,727 26 $0.32 51.1 4.68 66.4
Maine 34.0 $51,494 77 $0.35 51.0 1.34 41.0
Maryland 23.2 $75,847 65 $0.49 51.5 6.05 54.2
Massachusetts 26.2 $70,628 110 $0.11 51.5 6.86 47.9
Michigan 26.8 $51,084 222 $0.20 50.9 9.96 44.4
Minnesota 28.5 $63,488 112 $0.47 50.3 5.58 41.2
Mississippi 33.9 $40,593 9 $0.43 51.4 2.98 63.4
Missouri 31.0 $50,238 78 $0.06 51.0 6.11 54.5
Montana 41.0 $49,509 68 $0.14 49.8 1.05 42.7
Nebraska 35.2 $54,996 42 $0.31 50.2 1.92 48.8
Nevada 35.8 $52,431 37 $0.16 49.6 3.00 49.9
New Hampshire 43.9 $70,303 54 $0.30 50.6 1.34 43.8
New Jersey 22.4 $72,222 82 $0.12 51.2 9.01 52.7
New Mexico 32.4 $45,382 57 $0.41 50.4 2.09 53.4
New York 22.4 $60,850 269 $0.14 51.5 19.85 45.4
North Carolina 27.1 $47,830 200 $0.62 51.3 10.27 59.0
North Dakota 45.8 $60,557 10 $0.39 48.9 0.76 40.4
Ohio 30.1 $51,075 177 $0.18 51.1 11.66 50.7
Oklahoma 28.3 $48,568 20 $0.40 50.5 3.93 59.6
Oregon 30.3 $54,148 243 $0.08 50.5 4.14 48.4
Pennsylvania 28.6 $55,702 205 $0.08 51.1 12.81 48.8
Rhode Island 26.3 $58,073 15 $0.12 51.6 1.06 50.1
South Carolina 32.7 $47,238 50 $0.77 51.3 5.02 62.4
South Dakota 38.9 $53,017 15 $0.27 49.8 0.87 45.2
Tennessee 26.2 $47,275 66 $1.29 51.2 6.72 57.6
Texas 34.4 $55,653 201 $0.20 50.3 28.30 64.8
Utah 20.2 $62,912 27 $0.41 49.7 3.10 48.6
Vermont 35.3 $56,990 50 $0.27 50.7 0.62 42.9
Virginia 26.7 $66,262 164 $0.26 50.8 8.47 55.1
Washington 24.8 $64,129 334 $0.26 50.0 7.41 48.3
Washington DC 28.3 $75,628 12 $0.64 52.6 0.69 55.7
West Virginia 30.3 $42,019 15 $0.18 50.6 1.82 51.8
Wisconsin 36.2 $55,638 138 $0.06 50.3 5.80 43.1
Wyoming 33.0 $60,214 23 $0.02 49.0 0.58 42.0

SAT

STATE SAT Participation Rate 2004 SAT Average Per Pupil Exp Per Capita Income
Alabama 10% 1,113 $ 8,391 $ 28,989.76
Alaska 53% 1,032 $ 12,300 $ 35,892.17
Arizona 32% 1,047 $ 7,196 $ 29,334.74
Arkansas 6% 1,124 $ 8,284 $ 26,641.15
California 49% 1,020 $ 9,152 $ 37,184.63
Colorado 27% 1,107 $ 8,167 $ 36,889.43
Connecticut 85% 1,030 $ 12,979 $ 47,765.16
D.C. 77% 965 $ 11,829 $ 36,589.68
Delaware 73% 999 $ 14,324 $ 53,324.79
Florida 67% 998 $ 8,514 $ 34,154.78
Georgia 73% 987 $ 9,127 $ 30,391.03
Hawaii 60% 1,001 $ 11,060 $ 34,662.24
Idaho 20% 1,079 $ 6,625 $ 27,605.19
Illinois 10% 1,182 $ 9,555 $ 36,327.93
Indiana 64% 1,007 $ 8,938 $ 30,702.05
Iowa 5% 1,195 $ 8,769 $ 31,394.21
Kansas 9% 1,169 $ 8,988 $ 32,573.66
Kentucky 12% 1,116 $ 8,309 $ 28,140.10
Louisiana 8% 1,125 $ 8,928 $ 26,324.77
Maine 76% 1,006 $ 11,387 $ 30,900.38
Maryland 68% 1,026 $ 11,724 $ 41,495.36
Massachusetts 85% 1,041 $ 12,738 $ 43,596.83
Michigan 11% 1,136 $ 9,912 $ 32,715.30
Minnesota 10% 1,180 $ 9,539 $ 36,960.04
Mississippi 5% 1,109 $ 7,473 $ 25,537.43
Missouri 8% 1,172 $ 8,529 $ 31,163.07
Montana 29% 1,076 $ 9,078 $ 28,841.61
Nebraska 8% 1,145 $ 9,141 $ 32,725.06
Nevada 40% 1,021 $ 7,993 $ 36,222.71
New Hampshire 80% 1,043 $ 10,723 $ 37,331.55
New Jersey 83% 1,015 $ 15,691 $ 43,504.04
New Mexico 14% 1,097 $ 8,635 $ 27,810.50
New York 87% 1,007 $ 15,981 $ 40,987.92
North Carolina 70% 1,006 $ 7,883 $ 30,103.17
North Dakota 5% 1,183 $ 9,022 $ 31,932.50
Ohio 28% 1,080 $ 9,799 $ 31,867.32
Oklahoma 7% 1,135 $ 7,420 $ 29,763.28
Oregon 56% 1,055 $ 9,000 $ 31,061.50
Pennsylvania 74% 1,003 $ 11,098 $ 34,817.06
Rhode Island 72% 1,005 $ 12,612 $ 36,146.89
South Carolina 62% 986 $ 8,533 $ 27,881.99
South Dakota 5% 1,191 $ 7,944 $ 31,281.73
Tennessee 16% 1,124 $ 7,113 $ 30,392.92
Texas 52% 992 $ 7,818 $ 32,481.03
Utah 7% 1,121 $ 5,683 $ 27,196.51
Vermont 66% 1,028 $ 13,471 $ 32,727.86
Virginia 71% 1,024 $ 10,210 $ 37,598.17
Washington 52% 1,059 $ 8,377 $ 35,264.00
West Virginia 19% 1,038 $ 9,611 $ 26,509.12
Wisconsin 7% 1,183 $ 10,267 $ 32,653.87
Wyoming 12% 1,097 $ 13,217 $ 36,855.75

TAXES1

Gross Income
State of Residence
Federal Tax Liability
Social Security Tax Liability
Medicare Tax Liability
State Tax Liability
Total Tax Liability
Average Tax Rate
Marginal Tax Rate

TAXES2

Federal
Gross Income

Administrator: Administrator: In this cell, the user should enter the amount earned over the year (gross).		 PE and SD $ 12,200
Social Security 6.20% Up to $132,900
Medicare 1.45%
Adjust Gross Income
Min Max Rate
$ - 0 $ 9,700 10.0%
$ 9,700 $ 39,475 12.0%
$ 39,475 $ 84,200 22.0%
$ 84,200 $ 160,725 24.0%
$ 160,725 $ 204,100 32.0%
$ 204,100 $ 510,300 35.0%
$ 510,300 ¥ 37.0%
Total
Federal Income Tax
Social Security Tax
Medicare Tax
Total Federal Tax
Average Tax Rate
Marginal Tax Rate

TAXES3

Massachusetts Connecticut Rhode Island
PE and SD $ 4,400 $ 14,000 $ 12,525
Massachusetts Connecticut Rhode Island
Min Max Rate Min Max Rate Min Max Rate
$ - 0 ¥ 5.05% $ - 0 $ 10,000 3.00% $ - 0 $ 62,550 3.75%
$ 10,000 $ 50,000 5.00% $ 62,550 $ 142,150 4.75%
$ 50,000 $ 100,000 5.50% $ 142,150 ¥ 5.99%
$ 100,000 $ 200,000 6.00%
$ 200,000 $ 250,000 6.50%
$ 250,000 $ 500,000 6.90%
$ 500,000 ¥ 6.99%

GRADES

ATT HWK1 HWK2 HWK3 HWK4 HWK5 HWK6 HWK7 HWK8 Mid-Term1 Mid-Term 2 Final
Aas, Nils 34 6 8 9 7 2 4 75 66 91
Abair, Steve 32 2 2 9 8 4 10 48 49 52
Aguirre, Pam 35 4 7 2 9 2 8 9 85 89 91
Beane, John 32 2 4 7 7 3 4 3 94 99 100
Beaupre, Patty 41 8 3 3 7 2 2 6 72 72 73
Bechtel, Charlie 35 9 3 8 7 5 6 5 2 79 81 82
Chamberlain, Doug 34 3 4 2 4 4 4 5 5 63 57 54
Egolf, Jan 42 9 2 2 5 9 2 3 3 86 77 67
Ennis, Nancy 41 2 10 2 5 4 4 87 89 89
Gobin, Mike 36 9 4 7 2 8 53 75 90
Hagadorn, Judy 34 9 10 8 10 9 10 9 8 91 97 94
Heath, Ray 35 10 7 4 3 4 3 8 10 64 86 76
Irish, Patty 32 6 6 9 7 6 3 8 89 67 79
Kelly, Martha 41 6 5 10 10 9 8 5 10 98 94 92
Kennison, Brad 32 10 10 9 7 6 6 6 5 95 94 97
Kerner, Marlene 42 9 8 8 3 9 5 2 8 71 83 98
Laird, Nancy 32 10 10 7 9 10 9 8 8 93 89 98
Leary, Karen 35 2 10 1 8 9 10 96 82 76
LeVigne, Stewart 41 10 10 10 8 9 7 8 6 93 91 90
Murray, Sharon 35 7 7 5 8 6 6 6 72 89 72
O"Brien, Bill 33 4 8 7 6 5 10 2 10 70 73 77
Pecor, Cedric 35 6 5 2 6 1 3 9 79 78 77
Ray, Bobby 33 7 6 3 9 2 4 72 76 80
Reed, Martha 40 6 3 7 3 8 8 4 79 63 82
Scotton, George 41 2 3 9 4 4 80 85 89
Shortsleeve, Debbie 38 7 4 4 5 7 4 9 92 68 80
Snider, Virginia 42 10 8 9 6 6 9 5 3 64 61 97
Taft, Debbie 39 6 6 9 5 8 10 9 10 68 76 84
Thomas, Frank 36 7 4 2 8 7 3 3 10 68 52 89
Torrey, Pam 36 7 6 4 7 4 2 68 76 84
Varney, Chuck 40 7 6 6 6 8 6 8 5 99 72 85
Weatherbee, Penny 36 6 5 9 3 9 8 8 10 85 89 91
Williams, Delores 32 5 8 7 10 9 4 2 5 83 88 93
Wood, Patty 40 3 9 9 3 6 2 3 3 87 71 88