Sales Order ID Customer Order Date Order Amount Salesperson

50325 Target 9/1/2009 73192 F. Lemming

50326 Wal-Mart 9/1/2009 51924 S. Moore
50327 Kmart 9/2/2009 39419 G. Sammy
50328 Target 9/2/2009 52455 A. Foreman
50329 Costco 9/3/2009 16461 R. Clemens
50330 Sears 9/4/2009 49516 A. Rod
50331 Costco 9/7/2009 30177 S. Moore
50332 Target 9/8/2009 21090 G. Sammy
50333 Kmart 9/9/2009 71433 A. Foreman
50334 Target 9/10/2009 54275 S. Moore
50335 Costco 9/11/2009 16276 R. Clemens
50336 Kmart 9/14/2009 21028 A. Rod
50337 Kmart 9/15/2009 32809 A. Foreman
50338 Wal-Mart 9/16/2009 22663 R. Clemens
50339 Kmart 9/17/2009 39509 A. Rod
50340 Target 9/18/2009 26616 S. Moore
50341 Costco 9/18/2009 57573 G. Sammy
50342 Sears 9/21/2009 36967 A. Rod
50343 Wal-Mart 9/21/2009 35274 R. Clemens
50344 Kmart 9/22/2009 63419 F. Lemming
50345 Target 9/23/2009 23817 S. Moore
50346 Costco 9/24/2009 39705 G. Sammy
50347 Sears 9/25/2009 70546 A. Foreman
50348 Wal-Mart 9/28/2009 60482 R. Clemens
50349 Kmart 9/28/2009 47847 A. Rod
50350 Target 9/28/2009 57965 R. Clemens
50351 Costco 9/29/2009 16441 A. Rod
50352 Sears 9/30/2009 65793 S. Moore

1194672
Store Location
CA
FL
AZ
WA
OR
TX
CA
FL
AZ
WA
OR
TX
WA
FL
AZ
WA
OR
FL
OR
CA
AZ
FL
AZ
WA
OR
FL
OR
CA
 1. Sort

Sales Order ID Customer Order Date Order Amount Salesperson

50341 Costco 9/18/2009 57573 G. Sammy
50346 Costco 9/24/2009 39705 G. Sammy
50331 Costco 9/7/2009 30177 S. Moore
50329 Costco 9/3/2009 16461 R. Clemens
50351 Costco 9/29/2009 16441 A. Rod
50335 Costco 9/11/2009 16276 R. Clemens
50333 Kmart 9/9/2009 71433 A. Foreman
50344 Kmart 9/22/2009 63419 F. Lemming
50349 Kmart 9/28/2009 47847 A. Rod
50339 Kmart 9/17/2009 39509 A. Rod
50327 Kmart 9/2/2009 39419 G. Sammy
50337 Kmart 9/15/2009 32809 A. Foreman
50336 Kmart 9/14/2009 21028 A. Rod
50347 Sears 9/25/2009 70546 A. Foreman
50352 Sears 9/30/2009 65793 S. Moore
50330 Sears 9/4/2009 49516 A. Rod
50342 Sears 9/21/2009 36967 A. Rod
50325 Target 9/1/2009 73192 F. Lemming
50350 Target 9/28/2009 57965 R. Clemens
50334 Target 9/10/2009 54275 S. Moore
50328 Target 9/2/2009 52455 A. Foreman
50340 Target 9/18/2009 26616 S. Moore
50345 Target 9/23/2009 23817 S. Moore
50332 Target 9/8/2009 21090 G. Sammy
50348 Wal-Mart 9/28/2009 60482 R. Clemens
50326 Wal-Mart 9/1/2009 51924 S. Moore
50343 Wal-Mart 9/21/2009 35274 R. Clemens
50338 Wal-Mart 9/16/2009 22663 R. Clemens

1194672
Store Location
OR
FL
CA
OR
OR
OR
AZ
CA
OR
AZ
AZ
WA
TX
AZ
CA
TX
FL
CA
FL
WA
WA
WA
AZ
FL
WA
FL
OR
FL
 2. Filter

Sales Order ID Customer Order Date Order Amount Salesperson Store Location
50325 Target 9/1/2009 73192 F. Lemming CA
50328 Target 9/2/2009 52455 A. Foreman WA
50332 Target 9/8/2009 21090 G. Sammy FL
50334 Target 9/10/2009 54275 S. Moore WA
50340 Target 9/18/2009 26616 S. Moore WA
50345 Target 9/23/2009 23817 S. Moore AZ
50350 Target 9/28/2009 57965 R. Clemens FL
3. Pivot-Table

Sales Order ID Customer Order Date Order Amount Salesperson Store Location
50325 Target 9/1/2009 73192 F. Lemming CA
50326 Wal-Mart 9/1/2009 51924 S. Moore FL
50327 Kmart 9/2/2009 39419 G. Sammy AZ
50328 Target 9/2/2009 52455 A. Foreman WA
50329 Costco 9/3/2009 16461 R. Clemens OR
50330 Sears 9/4/2009 49516 A. Rod TX
50331 Costco 9/7/2009 30177 S. Moore CA
50332 Target 9/8/2009 21090 G. Sammy FL
50333 Kmart 9/9/2009 71433 A. Foreman AZ
50334 Target 9/10/2009 54275 S. Moore WA
50335 Costco 9/11/2009 16276 R. Clemens OR
50336 Kmart 9/14/2009 21028 A. Rod TX
50337 Kmart 9/15/2009 32809 A. Foreman WA
50338 Wal-Mart 9/16/2009 22663 R. Clemens FL
50339 Kmart 9/17/2009 39509 A. Rod AZ
50340 Target 9/18/2009 26616 S. Moore WA
50341 Costco 9/18/2009 57573 G. Sammy OR
50342 Sears 9/21/2009 36967 A. Rod FL
50343 Wal-Mart 9/21/2009 35274 R. Clemens OR
50344 Kmart 9/22/2009 63419 F. Lemming CA
50345 Target 9/23/2009 23817 S. Moore AZ
50346 Costco 9/24/2009 39705 G. Sammy FL
50347 Sears 9/25/2009 70546 A. Foreman AZ
50348 Wal-Mart 9/28/2009 60482 R. Clemens WA
50349 Kmart 9/28/2009 47847 A. Rod OR
50350 Target 9/28/2009 57965 R. Clemens FL
50351 Costco 9/29/2009 16441 A. Rod OR
50352 Sears 9/30/2009 65793 S. Moore CA

1194672
Sum of Order Amount
Salesperson Total
A. Foreman 227243
A. Rod 211308
F. Lemming 136611
G. Sammy 157787
R. Clemens 209121
S. Moore 252602
Grand Total 1194672
Sum of Order Amount
Customer Total
Costco 176633
Kmart 315464
Sears 222822
Target 309410
Wal-Mart 170343
Grand Total 1194672
Q1: The following data shows sale figures of various office products by different salesperson.
Required: Arrange all of data in this table based on ( color ) from ( z to a ).

Date Salesperson Item Color Units Price Total Sales

2/28/2004 Jones Pens Red 22 $4.99 $109.78
1/29/2004 Ho Binders Red 23 $19.99 $459.77
1/29/2004 Gill Clipboards Red 38 $4.99 $189.62
1/15/2004 Jones Pens Red 40 $1.29 $51.60
1/15/2004 Jones Pens Red 8 $4.99 $39.92
1/15/2004 Jones Pencils Red 17 $1.99 $33.83
1/15/2004 Jones Pens Red 13 $1.29 $16.77
1/2/2004 Jones Clipboards Red 49 $4.99 $244.51
1/2/2004 Ho Pencils Red 29 $1.99 $57.71
1/2/2004 Ho Pens Red 4 $1.29 $5.16
1/2/2004 Gill Clipboards Red 33 $4.99 $164.67
1/2/2004 Gill Pens Red 28 $4.99 $139.72
2/28/2004 Ho Pens Blue 25 $4.99 $124.75
2/20/2004 Jones Binders Blue 36 $19.99 $719.64
2/20/2004 Jones Binders Blue 28 $19.99 $559.72
2/20/2004 Jones Binders Blue 50 $8.99 $449.50
2/20/2004 Jones Binders Blue 44 $8.99 $395.56
2/20/2004 Ho Pencils Blue 37 $1.99 $73.63
2/20/2004 Ho Pencils Blue 5 $1.99 $9.95
1/29/2004 Jones Pens Blue 31 $1.29 $39.99
1/15/2004 Jones Pencils Blue 48 $1.99 $95.52
1/15/2004 Ho Binders Blue 32 $19.99 $639.68
1/15/2004 Ho Pens Blue 41 $4.99 $204.59
1/15/2004 Gill Binders Blue 28 $19.99 $559.72
1/15/2004 Gill Clipboards Blue 31 $4.99 $154.69
1/15/2004 Gill Clipboards Blue 12 $4.99 $59.88
1/2/2004 Ho Pens Blue 49 $4.99 $244.51
1/2/2004 Ho Binders Blue 9 $8.99 $80.91
2/28/2004 Ho Clipboards Black 49 $4.99 $244.51
2/28/2004 Ho Clipboards Black 26 $4.99 $129.74
2/28/2004 Gill Pens Black 9 $1.29 $11.61
2/20/2004 Ho Pens Black 33 $1.29 $42.57
1/29/2004 Jones Pens Black 38 $4.99 $189.62
1/29/2004 Jones Clipboards Black 9 $4.99 $44.91
1/29/2004 Jones Pens Black 3 $4.99 $14.97
1/29/2004 Gill Binders Black 42 $8.99 $377.58
1/29/2004 Gill Pencils Black 49 $1.99 $97.51
1/15/2004 Gill Binders Black 37 $8.99 $332.63
1/2/2004 Jones Binders Black 3 $19.99 $59.97
1/2/2004 Jones Pens Black 40 $1.29 $51.60
1/2/2004 Ho Binders Black 39 $19.99 $779.61
1/2/2004 Gill Binders Black 21 $15.00 $315.00
Q2: The following data shows sale figures of various office products by different salesperson.
Required: Show all items that sold by the salesperson ( Gill ).

Date Salesperson Item Color Units Price Total Sales

1/2/2004 Gill Pens Red 28 $4.99 $139.72
1/2/2004 Gill Clipboards Red 33 $4.99 $164.67
1/2/2004 Gill Binders Black 21 $15.00 $315.00
1/15/2004 Gill Binders Blue 28 $19.99 $559.72
1/15/2004 Gill Clipboards Blue 12 $4.99 $59.88
1/15/2004 Gill Binders Black 37 $8.99 $332.63
1/15/2004 Gill Clipboards Blue 31 $4.99 $154.69
1/29/2004 Gill Binders Black 42 $8.99 $377.58
1/29/2004 Gill Pencils Black 49 $1.99 $97.51
1/29/2004 Gill Clipboards Red 38 $4.99 $189.62
2/28/2004 Gill Pens Black 9 $1.29 $11.61
 Coast Jewelers, Inc.
Citizen Watch Sales
Week of November 11,2012

Product Cost Markup Price Discount Quantity

Promaster Navihawk 265.00 50% 397.50 20% 5
Ladies Citizen 200.00 60% 320.00 15% 4
Solar Tech Chronograph 283.33 50% 425.00 20% 8
Ladies Titanium 195.00 60% 312.00 15% 10
Total

Product Cost Markup Price Discount Quantity

Promaster Navihawk 265 50% 397.5 20% 5
Ladies Citizen 200 60% 320 15% 4
Solar Tech Chronograph 283.33 50% 424.995 20% 8
Ladies Titanium 195 60% 312 15% 10

`
 Price = Cost + Cost * Markup
= Cost * (1 + Markup)
Total = (Price - (Price * Discount)) * Quantity
= Price * Quantity * (1 - Discount)
Total = (Price * Quantity) - (Price * Quantity * Discount)
1,590.00
1,088.00
2,719.97
2,652.00
8,049.97

Total
1590
1088
2719.968
2652
8049.968
8049.968
 Coast Jewelers, Inc.
Citizen Watch Sales
Week 1 , December , 2014

Product Cost Markup Price Quantity Total

Promaster Navihawk 265.00 50% 397.50 5 1,629.75
Ladies Citizen 200.00 60% 320.00 4 1,049.60
Solar Tech Chronograph 283.33 50% 425.00 8 2,787.97
Ladies Titanium 195.00 60% 312.00 10 2,558.40
Total 8,025.72

Discount 18%

Product Cost Markup Price Quantity Total

Promaster Navihawk 265.00 50% 397.50 5 1,629.75
Ladies Citizen 200.00 60% 320.00 4 1,049.60
Solar Tech Chronograph 283.33 50% 425.00 8 2,787.97
Ladies Titanium 195.00 60% 312.00 10 2,558.40
Total 943.33 2.20 1,454.50 27.00 8,025.72
 Coast Jewelers, Inc.
Citizen Watch Sales
Week 2 , December , 2014

Product Cost Markup Price Quantity Total

Promaster Navihawk 265.00 50% 397.50 10 2,941.50
Ladies Citizen 200.00 60% 320.00 9 2,131.20
Solar Tech Chronograph 283.33 50% 425.00 1 314.50
Ladies Titanium 195.00 60% 312.00 16 3,694.08
Total 9,081.28
Discount
26%
 Coast Jewelers, Inc.
Citizen Watch Sales
Week 3 , December , 2014

Product Cost Markup Price Quantity Total

Promaster Navihawk 265.00 50% 397.50 20 5,247.00
Ladies Citizen 200.00 60% 320.00 18 3,801.60
Solar Tech Chronograph 283.33 50% 425.00 5 1,402.48
Ladies Titanium 195.00 60% 312.00 3 617.76
Total 11,068.84

Discount 34%
 Coast Jewelers, Inc.
Citizen Watch Sales
Week 4 , December , 2014

Product Cost Markup Price Quantity Total

Promaster Navihawk 265.00 50% 397.50 9 2,146.50
Ladies Citizen 200.00 60% 320.00 14 2,688.00
Solar Tech Chronograph 283.33 50% 425.00 19 4,844.94
Ladies Titanium 195.00 60% 312.00 16 2,995.20
Total 12,674.64

Discount 40%
 Coast Jewelers, Inc.
Citizen Watch Sales
December , Summary , 2014

Product Week1 Week2 Week3 Week4 Total

Promaster Navihawk 1,590.00 2,941.50 5,247.00 2,146.50 11,925.00
Ladies Citizen 1,088.00 2,131.20 3,801.60 2,688.00 9,708.80
Solar Tech Chronograph 2,719.97 314.50 1,402.48 4,844.94 9,281.89
Ladies Titanium 2,652.00 3,694.08 617.76 2,995.20 9,959.04
Total 8,049.97 9,081.28 11,068.84 12,674.64 40,874.73
 cost markup price discount
A 600 750 300
B 0.15 920 230
C 400 0.25 500 150
D 1000 -0.3 700
Total
quantity total
4 1800
2 1380
2100
8 4000
9280
 product cost gross margin sale price discount quantity
a $ 18.00 40% $ 25.20 20% 50
b $ 45.00 33% $ 60.00 15% 100
c $ 22.73 10% $ 25.00 30% 140
d $ 35.00 100% $ 70.00 10% 70
e $ 40.63 60% $ 65.00 24% 35
total 395

product cost gross margin sale price discount quantity

a $ 18.00 40% 20% 50
b $ 45.00 $ 60.00 15%
c 10% $ 25.00 140
d $ 35.00 10% 70
e 60% 24% 35
total 295
 total sales
$ 1,008.00
$ 5,100.00
$ 2,450.00
$ 4,410.00
$ 1,729.00
$ 14,697.00

total sales

$ 5,100.00
$ 2,450.00
$ 4,410.00
$ 1,729.00
14697
 Product Cost Markup Price Discount $ Discount % quantity $

Promaster Navihawk 265 0.5 397.5 79.5 0.2 377.5

Ladies Citizen 200 0.6 320 48 0.15 297.333333

Solar Tech Chronograph 283.33 0.5 424.995 84.999 0.2 392.995

Ladies Titanium 195 0.6 312 46.8 0.15 255.333333
Total
Quantity # Total

5 1590

4 1088

8 2719.968
10 2652
8049.968
Q2: The following data shows details about ABC's sales for June, 2014:
Required: Fill in the table from your Exam paper to the following table that appear below, and find the markup an

ABC Corporation - June Sales 2014

Week 1
Product Cost Markup Price Discount Quantity Total
Product A 450 65% 743 10% 84 56,171
Product B 620 45% 899 10% 60 48,546
Product C 900 15% 1,035 10% 32 29,808
Total 176 134,525

ABC Corporation - June Sales 2014

Week 3
Product Cost Markup Price Discount Quantity Total
Product A 440 60% 704 20% 90 50,688
Product B 600 40% 840 20% 74 49,728
Product C 870 25% 1,088 20% 40 34,816
Total 204 135,232
w, and find the markup and total sales for each product that appears below:

ABC Corporation - June Sales 2014

Week 2
Product Cost Markup Price Discount Quantity Total
Product A 470 55% 729 15% 100 61,965
Product B 680 35% 918 15% 66 51,500
Product C 970 20% 1,164 15% 19 18,799
Total 185 132,263

ABC Corporation - June Sales 2014

Week 4
Product Cost Markup Price Discount Quantity Total
Product A 450 70% 765 30% 60 32,130
Product B 715 50% 1,073 30% 90 67,599
Product C 910 30% 1,183 30% 25 20,703
Total 175 120,432
Q3: The following data shows details about ABC's sales fo
Required: By using the data that shown in Question
Make a summary about all sales that made in june:

ABC Corpo
June Sales 2014
Product Week 1
Product A 56,171
Product B 48,546
Product C 29,808
Total 134,525
shows details about ABC's sales for June, 2014:
the data that shown in Question 1 about weekly sales for month of June 2014,
bout all sales that made in june:

ABC Corporation
June Sales 2014 - Summary
Week 2 Week 3 Week 4 Total
61,965 50,688 32,130 200,954
51,500 49,728 67,599 217,373
18,799 34,816 20,703 104,125
132,263 135,232 120,432 522,452
 Coast Jewelers, Inc.
1. Vertical Analysis
Income Statement

12/31/11 % of Sales 12/31/12 % of Sales

Sales Revenue ### 100% ### 100%
Less: Cost of Goods Sold 489,547.25 59% 500,000.00 53%
Gross Margin 336,426.90 41% 450,000.00 47%
Expenses:
Advertising 26,548.55 3% 30,000.00 3%
Depreciation 22,000.00 3% 25,000.00 3%
Interest 32,338.94 4% 50,000.00 5%
Payroll 129,547.97 16% 160,000.00 17%
Utilities 27,546.16 3% 35,000.00 4%
Net income before taxes 98,445.28 12% 150,000.00 16%
Income taxes 31,600.00 4% 30,000.00 3%
Net income $66,845.28 8% ### 13%

Expenses 2011 Expen

Utilities Advertising Utilities
12% 11% 12%
Depreciation
9%

Interest
14%
Payroll Payroll
54% 53%
For the Year Ended

change base current

15% 825974.15 950000
2% 489547.25 500000
34% 336426.9 450000

13% 26548.55 30000

14% 22000 25000
55% 32338.94 50000
24% 129547.97 160000
27% 27546.16 35000
52% 98445.28 150000
-5% 31600 30000
80% 66845.28 120000

Expenses 2012 expenses

Advertising 27,546.16 ; 12% 26,548.55 ; 11%
Utilities
12% 10% 22,000.0

Depreciation
8%
32,338

129,547.97 ; 54%

Advertising Depreciation Interest Payroll U

Interest
17%
Payroll
53%
 expenses
12% 26,548.55 ; 11%
22,000.00 ; 9%

32,338.94 ; 14%

ciation Interest Payroll Utilities

 Coast Jewelers, Inc.
Balance Sheet
as of

Assets 12/31/11 % of Assets 12/31/12

Current Assets:
Cash $20,182.15 3% $35,000.00
Accounts Receivable 102,544.24 14% 60,000.00
Inventory 152,154.21 21% 115,000.00
Prepaid Expenses 15,241.75 2% 10,000.00
Supplies 6,578.24 1% 8,000.00
Property, Plant, and Equipment:
Land 120,000.00 17% 120,000.00
Building 315,000.00 44% 300,000.00
Equipment 70,000.00 10% 67,000.00
Less: Accumulated Depreciation (90,000.00) -13% ###
Total ### 100% ###

Liabilities and Stockholders' Equ 12/31/11 % of Assets 12/31/12

Liabilities
Current Liabilities:
Accounts Payable $84,005.70 12% $52,000.00
Payroll Liabilities 8,152.25 1% 8,457.36
Long-Term Debt 350,000.00 49% 150,000.00
Stockholders' Equity
Common Stock 10,000.00 1% 10,000.00
Retained Earnings 259,542.64 36% 379,542.64
Total ### 100% ###

Assets 2011

Cash Less: Accumulated Dep

Less: Accumulated Depreciation 14%
10% 2% Accounts Receivable
11%
Equipment
8%

Eq

Inventory
17%

Building Prepaid Expenses

35% 2%
Land Supplies
 Eq

Inventory
17%

Building Prepaid Expenses

35% 2%
Land Supplies
13% 1%
% of Assets change Base Current

6% 73% ### $ 35,000.00

10% -41% ### $ 60,000.00
19% -24% ### $115,000.00
2% -34% ### $ 10,000.00
1% 22% $ 6,578.24 $ 8,000.00

20% 0% ### $120,000.00

50% -5% ### $300,000.00
11% -4% ### $ 67,000.00
-19% 28% ### ###
100% -16% ### $600,000.00

% of Assets change Base Current

9% -38% ### $ 52,000.00

1% 4% $ 8,152.25 $ 8,457.36
25% -57% ### $150,000.00

2% 0% ### $ 10,000.00
63% 46% ### $379,542.64
100% -16% ### $600,000.00
0 0
0
Assets
0
2012 00
0 0
Cash
Less: Accumulated Depreciation 4% Accounts Receivable
14% 7%

Equipment Inventory
8% 14%

Prepaid Expenses
1%
Supplies
1%
Land
Building 14%
Equipment Inventory
8% 14%

Prepaid Expenses
1%
Supplies
1%
Land
Building 14%
36%
 Coast Jewelers, Inc.
2. Horizontal Analysis

Income Statement
For the Year Ended
Base Year Current Year
12/31/11 12/31/12 % Change
160,000.00
Sales Revenue ### ### 15%
140,000.00
Less: Cost of Goods Sold 489,547.25 500,000.00 2%
120,000.00
Gross Margin 336,426.90 450,000.00 34%
100,000.00
Expenses:
80,000.00
Advertising 26,548.55 30,000.00 13%
60,000.00
Depreciation 22,000.00 25,000.00 14%
40,000.00
Interest 32,338.94 50,000.00 55%
20,000.00
Payroll 129,547.97 160,000.00 24%
-
Utilities 27,546.16 35,000.00 27% Advertis-
ing
Net income before taxes 98,445.28 150,000.00 52%
Income taxes 31,600.00 30,000.00 -5%
Net income $66,845.28 ### 80%

Operating Expenses 2011-2012

180,000.00
160,000.00
140,000.00
120,000.00
100,000.00
12/31/11 80,000.00
12/31/12 60,000.00
40,000.00
20,000.00
-
es ll es
t
on g
liti ro er
in
ti Pa
y t ic ati r tis
U In e ve
pr Ad
De

All Expenses 2011-2012 600,000.00

500,000.00

400,000.00

300,000.00

12/31/11 200,000.00
12/31/12
100,000.00

-
es es ll st on g ld
ax liti ro re in So
e t ti Pa
y te ic ati r tis s
U In re ve d
co
m p Ad oo
In De f G
to
Cos
s:
12/31/11
12/31/12
100,000.00

-
es es ll st on g d
ax liti ro re sin ol
e t ti P ay te ic ati r ti
ds
S
U In re ve
co
m p Ad oo
In De o f G
ost
:C
ss
Le
 operating expenses

160,000.00
140,000.00
120,000.00
100,000.00 2011
80,000.00 2012
60,000.00
40,000.00
20,000.00 2012
- 2011
Advertis- Deprecia- Interest Payroll Utilities
ing tion

600,000.00

500,000.00

400,000.00

300,000.00

200,000.00

100,000.00

-
100,000.00

-
 Coast Jewelers, Inc.
Balance Sheet
as of

Assets 12/31/11 12/31/12 % Change

Current Assets:
Cash $20,182.15 $35,000.00 73%
Accounts Receivable 102,544.24 60,000.00 -41%
Inventory 152,154.21 115,000.00 -24%
Prepaid Expenses 15,241.75 10,000.00 -34%
Supplies 6,578.24 8,000.00 22%
Property, Plant, and Equipment:
Land 120,000.00 120,000.00 0%
Building 315,000.00 300,000.00 -5%
Equipment 70,000.00 67,000.00 -4%
Less: Accumulated Depreciation (90,000.00) ### 28%
Total ### ### -16%

Liabilities and Stockholders' Equ 12/31/11 12/31/12 % Change

Liabilities
Current Liabilities:
Accounts Payable $84,005.70 $52,000.00 -38%
Payroll Liabilities 8,152.25 8,457.36 4%
Long-Term Debt 350,000.00 150,000.00 -57%
Stockholders' Equity
Common Stock 10,000.00 10,000.00 0%
Retained Earnings 259,542.64 379,542.64 46%
Total ### ### -16%

Assets 2011 - 2012

$800,000.00
$700,000.00
$600,000.00
$500,000.00
$400,000.00
$300,000.00
12/31/11 $200,000.00
12/31/12 $100,000.00
$-
le
t

ies

y
l

sh
nd
on
ta

en

se
in

or

$(100,000.00)
ab

Ca
To

La
iati

pl
ild

en
m

nt

iv
p
ip

ve
Bu

p
ec

ce
Su

Ex
u

In

Re
pr

$(200,000.00)
Eq

aid
De

ts
ep

un
ed

Pr

co
at

Ac
ul
um
cc
A
s:
es
Le
ss
:A
cc
um To
ul ta
at
ed l
De
pr
ec
iati
on

Eq
u ip
m
en
t

Bu
ild
in
g

La
nd

Su
p pl
Pr ies
ep
aid
Ex
p en
se
s

In
ve
nt
Ac or
co y
un
ts
Re
ce
iv ab
le

Ca
sh
$-

$(200,000.00)
$(100,000.00)
 $800,000.00
$700,000.00
$600,000.00
$500,000.00
$400,000.00
$300,000.00
$200,000.00
$100,000.00
$-
sh

$(100,000.00)
Ca

$(200,000.00)
 sh $-
$(100,000.00)
Ca

$(200,000.00)
3. Ratios Analysis

Coast Jewelers, Inc.

Income Statement
For the Year Ended

12/31/11 12/31/12 #NAME? current

Sales Revenue ### ### 100% 100%
Less: Cost of Goods Sold 489,547.25 500,000.00 59% 53%
Gross profit 336,426.90 450,000.00 41% 47%
Expenses:
Advertising 26,548.55 30,000.00 3% 3%
Depreciation 22,000.00 25,000.00 3% 3%
Interest 32,338.94 50,000.00 4% 5%
Payroll 129,547.97 160,000.00 16% 17%
Utilities 27,546.16 35,000.00 3% 4%
Net income before taxes 98,445.28 150,000.00 12% 16%
Income taxes (%30) 31,600.00 30,000.00 4% 3%
Net income $66,845.28 ### 8% 13%
change base current
15% ### 950000
2% ### 500000
34% ### 450000

13% ### 30000

14% ### 25000
55% ### 50000
24% ### 160000
27% ### 35000
52% ### 150000
-5% ### 30000
80% ### 120000
 Coast Jewelers, Inc.
Balance Sheet
as of

Assets 12/31/11 12/31/12 change

Current Assets:
Cash $20,182.15 $ 35,000.00 $ 0.73
Accounts Receivable 102,544.24 60,000.00 $ (0.41)
Inventory 152,154.21 122,726.39 $ (0.19)
Prepaid Expenses 15,241.75 10,000.00 $ (0.34)
Supplies 6,578.24 8,000.00 $ 0.22
Property, Plant, and Equipment:
Land 120,000.00 120,000.00 $ -
Building 315,000.00 300,000.00 $ (0.05)
Equipment 70,000.00 67,000.00 $ (0.04)
Less: Accumulated Depreciation (90,000.00) ### $ 0.28
Total ### ### $ (0.15)

Liabilities and Stockholders' Equity12/31/11 12/31/12 change

Liabilities
Current Liabilities:
Accounts Payable $84,005.70 $ 52,000.00 $ (0.38)
Payroll Liabilities 8,152.25 8,457.36 $ 0.04
Long-Term Debt 350,000.00 150,000.00 $ (0.57)
Stockholders' Equity
Common Stock 10,000.00 10,000.00 $ -
Retained Earnings 259,542.64 379,542.64 $ 0.46
Total ### ### $ (0.16)
Current base

35000 20182.15
60000 102544.24
122726.39 152154.21
10000 15241.75
8000 6578.24

120000 120000
300000 315000
67000 70000
-115000 -90000
607726.39 711700.59

Current base

52000 84005.7
8457.36 8152.25
150000 350000

10000 10000
379542.64 259542.64
600000 711700.59
 Coast Jeweler
Ratio Analy
Ratio Analysis

Profitability 2011
Return on owners' investment (ROE) 20%
Return on total investment (ROA) 14%
Profit margin 8%
Gross margin 41%
Liquidity
Current ratio 322%
Quick ratio (Acid-Test Ratio) 133%
Receivable turnover 10.1630688359058
*Collection Period 36
Inventory turnover 356%
*Days to Sell Inventory 102
Solvency
Debt-to-Equity 164%
Liability Ratio 62%
Coast Jewelers, Inc.
Ratio Analysis
Ratio Analysis 2012
test
2012 2011 2012
36%
23%
13%
47%

390%
157%
1169%
31
364%
100

54%
35%
 Ratio Formula
Net Income Average Equity * ROE
Net Income Net Sales * Profit Margine
Average Total Assets (NI+(Intrest*(1-Tax))) / ROA
Net Sales NI / Profit Margin
Net Sales Gross Profit / Gross Margin
Gross Profit Gross Margine * Net Sales
Current Liabilities Current Assetes / Current Ratio
Current Liabilities (Cash+A/R+N/R+Trading) / Quick Ratio
Current Assets Current Liabilities * Current ratio
Account Recivable ( Current Liabilities * Quick ratio ) - Cash
Note Payable ( Current Assets / Current Ratio ) - A/P
CGS Average Inventory * Inventory Turnover
Total Liabilities Equity * ( dept-equity ratio )
Total Liabilities Total Assets * liability Ratio
Total Assets Total Liabilities / liability Rtio
Total Equity Total Liablities / (Debt-Equity Ratio)
Average Equity NI / ROE
 2011 2012
$ 66,845.28
$ 66,845.28
$ 659,713.49
$ 825,974.15
$ 825,974.15
$ 336,426.90
$ 92,157.95
$ 92,157.95
$ 296,700.59
$ 102,544.24 $ 60,000.00
$ 8,152.25 $ 52,000.00
$ 489,547.25
$ 442,157.95
$ 442,157.95
$ 711,700.59
$ 269,542.64
$ 329,542.64
 Coast Jewelers, Inc.
Ratio Analysis
Ratio Analysis 2011

Profitability
Return on owners' investment " Equity "(ROE) 20% 1
Return on total investment " Assets "(ROA) 14% 2
Profit margin 8% 3
Gross margin 41% 4
Liquidity 5
Current ratio 322% 6
Quick ratio (Acid-Test Ratio) 1.33 7
Receivable turnover 10.16 8
* Collection Period Ratio 35.91 9
Inventory turnover 3.56 10
* Days to sell Inventory Ratio 102.47 11
Solvency 12
Debt-to-equity 164%
Liability 62%
 RATIO ANSWER Test
Net income $ 66,845.28
AVG Total assets $ 659,713.49
Net Sales $ 825,974.15
Gross profit $ 336,426.90
Curren liabilities $ 92,157.95
A/R in 2011 $ 102,544.24
Cost of good sold $ 489,547.25
Total Liabilities $ 442,157.95
Total Assets $ 711,700.59
Payroll payable $ 8,152.25
Net sales $ 825,974.15
Total Liabilities $ 442,157.95
Q5: The following is ABC Corp. Income Statements & Balance Statements for years (2010,2011, and 2012).
Required:
A. Create a Vertical Analysis for Income Statement and Balance Sheet for year ( 2011 ) .
B. Create a Horizontal Analysis for Income Statement and Balance Sheet for both of years (2010 - 2011) .
C. Compute the financial ratios that appear in the following table for year ( 2011 ) .

ABC Corperation
Income Statemnt
for the period ended at Dec. 31, 2010 & 2011 & 2012
2010 2011 2012
Sales $ 481,250 $ 810,000 $ 891,000
Less: Cost of Goods Sold 201,250 427,500 521,550
Gross Margin 280,000 382,500 369,450
Operating Expenses:
Advertising 12,250 21,600 19,440
Marketing 8,750 12,600 9,828
Depreciation 14,000 14,400 14,400
Salary 87,500 126,000 130,000
Wages 35,000 45,000 48,000
Supplies 8,050 13,500 11,880
Utilities 12,950 18,000 23,400
Operating Income 101,500 131,400 112,502
Interest 7,000 4,500 6,000
Net income before taxes 94,500 126,900 106,502
Income taxes (30%) 28,350 38,070 31,951
Net income $ 66,150 $ 88,830 $ 74,551

ABC Corperation
Balance Sheet
As of December 31, 2010 & 2011 & 2012
2010 2011 2012
Assets
Current Assets:
Cash $ 12,500 $ 24,000 $ 28,800
Short-Term Investments 5,000 30,000 36,000
Accounts Receivable 15,000 18,000 34,200
Inventory 16,250 38,400 65,280
Prepaid Expenses 1,750 4,800 5,760
Supplies 4,500 12,000 14,400
Non-Current Assets:
Equipments (net) 90,000 85,600 81,200
Buildings (net) 160,000 150,000 140,000
Total Assets $ 305,000 $ 362,800 $ 405,640
Liabilities
Current Liabilities:
Accounts Payable $ 40,000 $ 36,000 $ 61,200
Income tax Payable 15,000 14,400 24,480
Salaries Payable 12,000 10,800 18,360
Notes Payable -short term 45,000 27,000 45,900
Non-Current Liabilities:
Bonds - long term 20,000 40,000 60,000
Total Liabilities $ 132,000 $ 128,200 $ 209,940

Owner's Equity
Share Capital - Ordinary $ 100,000 $ 100,000 $ 100,000
Retained Earnings 73,000 134,600 95,700
Total Owner's Equity $ 173,000 $ 234,600 $ 195,700
Total Liabilities & Owner's $ 305,000 $ 362,800 $ 405,640
011, and 2012).

r ( 2011 ) .
both of years (2010 - 2011) .
2011 ) .

Answer Answer
t t
A e B e
s s
% Sales t % Change t

100% 68.31%
53% 112.42%
47% 36.61%

3% 76.33%
2% 44.00%
2% 2.86%
16% 44.00%
6% 28.57%
2% 67.70%
2% 39.00%
16% 29.46%
1% -35.71%
16% 34.29%
5% 34.29%
11% 34.29%

Answer Answer
t t
A e B e
s s
% Sales t % Change t

7% 92.00%
8% 500.00%
5% 20.00%
11% 136.31%
1% 174.29%
3% 166.67%

24% -4.89%
41% -6.25%
100% 18.95%
Answer t Answer t
A
e B
e
s s
% Sales t % Change t
10% -10.00%
4% -4.00%
3% -10.00%
7% -40.00%

11% 100.00%
35% -2.88%

28% 0.00%
37% 84.38%
65% 35.61%
100% 18.95%
 Answer C
ABC Corporation
Ratios Analysis
for year ( 2011 )
Ratio Answer Test
Return on total investment 28%
Profit margin 11%
Quick ratio 82%
Debt-to-equity 55%
Days to sell Inventory 23.33
Collection Period 7.44
Q4: The following is ABC Corp. Income Statement & Balance Sheet for years (2012, 2013, and 2014).
Required:
A)) Create a "Vertical Analysis" for Income Statement and Balance Sheet for year ( 2014 ).
B)) Create a "Horizontal Analysis" for Income Statement and Balance Sheet for both of years ( 2012 - 2013 ) .
C)) Compute the "Financial Ratios" that appear in the following table for year ( 2014 ).

ABC Corporation
Income Statement
for the period ended at Dec. 31, 2012, 2013, and 2014
2012 2013 2014
Sales $ 891,000 $ 914,000 $ 986,000
Less: Cost of Goods Sold 521,550 622,150 599,500
Gross Margin 369,450 291,850 386,500
Operating Expenses:
Advertising 19,440 16,000 24,000
Marketing 9,828 14,440 16,874
Depreciation 14,400 14,000 13,600
Salary 130,000 133,400 140,100
Wages 48,000 35,000 56,500
Supplies 11,880 1,480 9,874
Utilities 23,400 13,352 17,890
Operating Income 112,502 64,178 107,662
Interest 6,000 9,800 11,400
Net income before taxes 106,502 54,378 96,262
Income taxes (40%) 42,601 21,751 38,505
Net income $ 63,901 $ 32,627 $ 57,757

ABC Corperation
Balance Sheet
As of December 31, for years (2012, 2013, and 2014)
2012 2013 2014
Cash $ 28,800 $ 16,980 $ 32,500
Short-Term Investments 36,000 32,000 47,000
Accounts Receivable 75,400 75,900 97,510
Inventory 65,280 71,000 111,200
Prepaid Expenses 5,760 3,540 1,150
Supplies 14,400 9,700 11,400
Equipments (net) 81,200 76,800 72,400
Buildings (net) 140,000 130,000 120,000
Total Assets $ 446,840 $ 415,920 $ 493,160

Accounts Payable $ 61,200 $ 44,500 $ 74,100

 Income tax Payable 24,480 10,400 16,900
Salaries Payable 18,360 13,980 9,800
Notes Payable -short term 45,900 87,000 67,200
Long-term Loans 31,200 14,000 28,300
Bonds - long term 70,000 60,000 40,000
Total Liabilities $ 251,140 $ 229,880 $ 236,300

Share Capital - Ordinary $ 100,000 $ 120,000 $ 150,000

Retained Earnings 95,700 66,040 106,860
Total Owner's Equity $ 195,700 $ 186,040 $ 256,860
Total Liabilities & Owner's $ 446,840 $ 415,920 $ 493,160
, 2013, and 2014).

year ( 2014 ).
or both of years ( 2012 - 2013 ) .
ar ( 2014 ).

Answer Answer
of of ABC Corporation
(A) (B) Ratios Analysis
% % for year ( 2014 )
100% 3% 2014
61% 19% Gross margin 0.39
39% -21% Return on assits's investment (ROA 0.14
Quick ratio (Acid-test) 1.05
2% -18% Receivable turnover on day's 11.37
2% 47% Collection period 32.10
1% -3% Liability to equity ratio 0.92
14% 3%
6% -27%
1% -88%
2% -43%
11% -43%
1% 63%
10% -49%
4% -49%
6% -49%

Answer Answer
of of
(A) (B)
% %
7% -41%
10% -11%
20% 1%
23% 9%
0% -39%
2% -33%
15% -5%
24% -7%
100% -7%

15% -27%
 3% -58%
2% -24%
14% 90%
6% -55%
8% -14%
48% -8%

30% 20%
22% -31%
52% -5%
100% -7%
2013
Coast Jewelers, Inc. Depreciation Schedule

Asset # 1001
Asset Display Cases SLN (Dep Exp)=
Date acquired 1/1/2009 Accumulated Dep=
Cost 15,000 Book Value=
Depreciation metho Straight Line
Salvage value 2,000
Estimated useful life 5

Depreciation Accumulated
Year Expense Depreciation Book Value
2009 $2,600.00 $2,600.00 $12,400.00
2010 $2,600.00 $5,200.00 $9,800.00
2011 $2,600.00 $7,800.00 $7,200.00
2012 $2,600.00 $10,400.00 $4,600.00
2013 $2,600.00 $13,000.00 $2,000.00
(Cost;Salvage;Life)
Pervious Acc. Dep + Depreciation Exp
Cost - Accumulated Depreciation
Coast Jewelers, Inc. Depreciation Schedule

Asset # 1002
Asset Chairs
Date acquired 10/1/2009
Cost 6,000
Depreciation method Straight Line
Salvage value 400
Estimated useful life 5

Depreciation Accumulated
Year Expense Depreciation
2009 $280.00 $280.00
2010 $1,120.00 $1,400.00
2011 $1,120.00 $2,520.00
2012 $1,120.00 $3,640.00
2013 $1,120.00 $4,760.00
2014 $840.00 $5,600.00
Book Value
$5,720.00
$4,600.00
$3,480.00
$2,360.00
$1,240.00
$400.00
Coast Jewelers, Inc. Depreciation Schedule

Asset # 1004
Asset Computers
Date acquired 1/1/2010
Cost 40,000
Depreciation metho Sum of years digits
Salvage value 1,500
Estimated useful life 6

Depreciation Accumulated
Year
Expense Depreciation
2010 $11,000.00 $11,000.00
2011 $9,166.67 $20,166.67
2012 $7,333.33 $27,500.00
2013 $5,500.00 $33,000.00
2014 $3,666.67 $36,666.67
2015 $1,833.33 $38,500.00
Book Value
$29,000.00
$19,833.33
$12,500.00
$7,000.00
$3,333.33
$1,500.00
Coast Jewelers, Inc. Depreciation Schedule

Asset # 1005
Asset Printers
Date acquired 10/1/2010
Cost 25,000
Depreciation metho Sum of years digits
Salvage value 4,000
Estimated useful life 6

Depreciation Accumulated
Year
Expense Depreciation
1 $1,500.00 $1,500.00
2 $5,750.00 $7,250.00
3 $4,750.00 $12,000.00
4 $3,750.00 $15,750.00
5 $2,750.00 $18,500.00
6 $1,750.00 $20,250.00
7 $750.00 $21,000.00
Book Value

$23,500.00
$17,750.00
$13,000.00
$9,250.00
$6,500.00
$4,750.00
$4,000.00
Coast Jewelers, Inc. Depreciation Schedule

Asset # 1006
Asset Tools
Date acquired 1/1/2010
Cost 45,000
Depreciation method DDB
Salvage value 4,000
Estimated useful life 6

Depreciation Accumulated
Year
Expense Depreciation
1 $15,000.00 $15,000.00
2 $10,000.00 $25,000.00
3 $6,666.67 $31,666.67
4 $4,444.44 $36,111.11
5 $2,962.96 $39,074.07
6 $1,925.93 $41,000.00
Book Value
$30,000.00
$20,000.00
$13,333.33
$8,888.89
$5,925.93
$4,000.00
Coast Jewelers, Inc. Depreciation Schedule

Asset # 1006
Asset Tools
Date acquired 1/8/2010
Cost 50,000
Depreciation metho DDB
Salvage value 5,000
Estimated useful life 5

Year Depreciation Expense

Accumulated Depreciation
1 $8,333.33 $8,333.33
2 $16,666.67 $25,000.00
3 $10,000.00 $35,000.00
4 $6,000.00 $41,000.00
5 $3,136.67 $44,136.67
6 $863.33 $45,000.00
Book Value
$41,666.67
$25,000.00
$15,000.00
$9,000.00
$5,863.33
$5,000.00
Coast Jewelers, Inc. Depreciation Schedule

Asset # 1006
Asset Tools
Date acquired 1/10/2010
Cost 45,000
Depreciation method DDB
Salvage value 4,000
Estimated useful life 6

Depreciation Accumulated
Year
Expense Depreciation
1 $3,750.00 $3,750.00
2 $13,750.00 $17,500.00
3 $9,166.67 $26,666.67
4 $6,111.11 $32,777.78
5 $4,074.07 $36,851.85
6 $2,703.70 $39,555.56
7 $1,444.44 $41,000.00
Book Value
$41,250.00
$27,500.00
$18,333.33
$12,222.22
$8,148.15
$5,444.44
$4,000.00
Coast Jewelers, Inc. Depreciation Schedule

Asset # 1007
Asset Tools 2
Date acquired 1/1/2010
Cost 60,000
Depreciation method DDB
Salvage value 2000
Estimated useful life 7
Depreciation Accumulated
Year Expense Depreciation Book Value
1 $17,142.86 $17,142.86 $42,857.14
2 $12,244.90 $29,387.76 $30,612.24
3 $8,746.36 $38,134.11 $21,865.89
4 $6,247.40 $44,381.51 $15,618.49
5 $4,462.43 $48,843.93 $11,156.07
6 $3,187.45 $52,031.38 $7,968.62
7 $2,276.75 $54,308.13 $5,691.87
 Depreciation Accumulated
Straight Switch Expense Depreciation
$8,285.71 - $17,142.86 17,142.86
$6,809.52 - $12,244.90 29,387.76
$5,722.45 - $8,746.36 38,134.11
$4,966.47 - $6,247.40 44,381.51
$4,539.50 x $4,539.50 48,921.01
$4,578.03 x $4,539.50 53,460.50
$5,968.62 x $4,539.50 58,000.00
Book Value
42,857.14
30,612.24
21,865.89
15,618.49
11,078.99
6,539.50
2,000.00
Coast Jewelers, Inc. Depreciation Schedule

Asset # 1006
Asset Tools 2
Date acquired 1/1/2010
Cost 62,000
Depreciation method 4. DDB
Salvage value 2200
Estimated useful life 7
Depreciation Accumulated
Year Expense Depreciation Book Value
2010 $17,714.29 $17,714.29 $44,285.71
2011 $12,653.06 $30,367.35 $31,632.65
2012 $9,037.90 $39,405.25 $22,594.75
2013 $6,455.64 $45,860.89 $16,139.11
2014 $4,611.17 $50,472.07 $11,527.93
2015 $3,293.70 $53,765.76 $8,234.24
2016 $2,352.64 $56,118.40 $5,881.60
Straight line Depreciation Accumulated
test Switch Expense depreciation
$8,542.86 - $17,714.29 17,714.29
$7,014.29 - $12,653.06 30,367.35
$5,886.53 - $9,037.90 39,405.25
$5,098.69 - $6,455.64 45,860.89
$4,646.37 x $4,646.37 50,507.26
$4,663.97 x $4,646.37 55,153.63
$6,034.24 x $4,646.37 59,800.00
Book Value
44,285.71
31,632.65
22,594.75
16,139.11
11,492.74
6,846.37
2,200.00
Coast Jewelers, Inc. Depreciation Schedule

Asset # 1006
Asset Chairs
Date acquired 1/10/2011
Cost 15,000
Depreciation method 3. DDB
Salvage value 0
Estimated useful life 5

Depreciation Accumulated
Year Expense Depreciation Book Value
1 $1,500.00 $1,500.00 $13,500.00
2 $5,400.00 $6,900.00 $8,100.00
3 $3,240.00 $10,140.00 $4,860.00
4 $1,944.00 $12,084.00 $2,916.00
5 $972.00 $13,056.00 $1,944.00
Straight Line Depreciation Accumulated
Test Switch Expense Depreciation
$750.00 - $1,500.00 1,500.00
$3,375.00 - $5,400.00 6,900.00
$2,700.00 - $3,240.00 10,140.00
$2,430.00 x $2,430.00 12,570.00
$2,187.00 x $2,430.00 15,000.00
Book Value
13,500.00
8,100.00
4,860.00
2,430.00
0.00
 Coast Jewelers, Inc.
Depreciation Summary

Asset Date Acquired Cost Deprec. Method Deprec. 2009

Display Cases 1/1/2009 15,000 Straight Line $0.00
Chairs 10/1/2009 6,000 Straight Line $0.00
Computers 1/1/2010 40,000 Sum of years digits
Printers 10/1/2010 25,000 Sum of years digits
Tools 1/1/2010 45,000 DDB
Tools 2 1/1/2010 60,000 DDB
Total $0.00
 Coast Jewelers, Inc.
Depreciation Summary

Acc. Deprec. 2009 Deprec. 2010 Acc. Deprec. 2010 Deprec. 2011 Acc. Deprec. 2011
$0.00 $0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00
$17,142.86 $17,142.86 $12,244.90 $29,387.76
$0.00 $17,142.86 $17,142.86 $12,244.90 $29,387.76
Coast Jewelers, Inc.
1. Loan Amortization Schedule (Annually)

Amount $100,000
Rate 10%
Term 3
Payment $40,211

Payment # Payment Interest Principal

1 $40,211.48 $ 10,000.00 $30,211.48

2 $40,211.48 $ 6,978.85 $33,232.63
3 $40,211.48 $ 3,655.59 $36,555.89
 Balance
$100,000
$ 69,788.52
$ 36,555.89
$ -
Coast Jewelers, Inc.
2. Loan Amortization Schedule (Quarterlly)

Amount $100,000
Rate (annually) 10%
Term (in years) 3
Payment $9,749

Payment # Payment Interest Principal

1 $ 9,749 $ 2,500 $ 7,249

2 $ 9,749 $ 2,319 $ 7,430
3 $ 9,749 $ 2,133 $ 7,616
4 $ 9,749 $ 1,943 $ 7,806
5 $ 9,749 $ 1,747 $ 8,001
6 $ 9,749 $ 1,547 $ 8,201
7 $ 9,749 $ 1,342 $ 8,406
8 $ 9,749 $ 1,132 $ 8,616
9 $ 9,749 $ 917 $ 8,832
10 $ 9,749 $ 696 $ 9,053
11 $ 9,749 $ 470 $ 9,279
12 $ 9,749 $ 238 $ 9,511
 Balance
$ 100,000
$ 92,751
$ 85,321
$ 77,706
$ 69,900
$ 61,898
$ 53,697
$ 45,291
$ 36,674
$ 27,843
$ 18,790
$ 9,511
$ -
Coast Jewelers, Inc.
3. Loan Amortization Schedule (Monthly)

Amount $100,000
Rate (annually) 10%
Term (in years) 3
Payment $3,227

Payment # Payment Interest Principal

1 3227 833 2393

2 3227 813 2413
3 3227 793 2433
4 3227 773 2454
5 3227 753 2474
6 3227 732 2495
7 3227 711 2516
8 3227 690 2537
9 3227 669 2558
10 3227 648 2579
11 3227 626 2600
12 3227 605 2622
13 3227 583 2644
14 3227 561 2666
15 3227 538 2688
16 3227 516 2711
17 3227 493 2733
18 3227 471 2756
19 3227 448 2779
20 3227 425 2802
21 3227 401 2825
22 3227 378 2849
23 3227 354 2873
24 3227 330 2897
25 3227 306 2921
26 3227 282 2945
27 3227 257 2970
28 3227 232 2994
29 3227 207 3019
30 3227 182 3045
31 3227 157 3070
32 3227 131 3096
33 3227 105 3121
34 3227 79 3147
35 3227 53 3174
36 3227 27 3200
Balance
$100,000
97607
95193
92760
90306
87832
85337
82822
80285
77727
75148
72548
69926
67282
64616
61927
59217
56484
53728
50949
48146
45321
42472
39599
36702
33781
30836
27867
24872
21853
18808
15738
12642
9521
6374
3200
0
Coast Jewelers, Inc.
4. Loan Amortization Schedule ( Weekly )

Amount $100,000
Rate (annually) 10%
Term (in years) 7
Payment $54

Payment # Payment Interest Principal

1 $381.21 $ 191.78 $189.43

2 $381.21 $ 191.42 $189.79
3 $381.21 $ 191.05 $190.16
4 $381.21 $ 190.69 $190.52
5 $381.21 $ 190.32 $190.89
6 $381.21 $ 189.96 $191.25
7 $381.21 $ 189.59 $191.62
8 $381.21 $ 189.22 $191.99
9 $381.21 $ 188.85 $192.36
10 $381.21 $ 188.49 $192.73
11 $381.21 $ 188.12 $193.10
12 $381.21 $ 187.75 $193.47
13 $381.21 $ 187.38 $193.84
14 $381.21 $ 187.00 $194.21
15 $381.21 $ 186.63 $194.58
16 $381.21 $ 186.26 $194.95
17 $381.21 $ 185.88 $195.33
18 $381.21 $ 185.51 $195.70
19 $381.21 $ 185.13 $196.08
20 $381.21 $ 184.76 $196.45
21 $381.21 $ 184.38 $196.83
22 $381.21 $ 184.00 $197.21
23 $381.21 $ 183.63 $197.59
24 $381.21 $ 183.25 $197.97
25 $381.21 $ 182.87 $198.35
26 $381.21 $ 182.49 $198.73
27 $381.21 $ 182.11 $199.11
28 $381.21 $ 181.72 $199.49
29 $381.21 $ 181.34 $199.87
30 $381.21 $ 180.96 $200.25
31 $381.21 $ 180.57 $200.64
32 $381.21 $ 180.19 $201.02
33 $381.21 $ 179.80 $201.41
34 $381.21 $ 179.42 $201.80
35 $381.21 $ 179.03 $202.18
36 $381.21 $ 178.64 $202.57
37 $381.21 $ 178.25 $202.96
38 $381.21 $ 177.86 $203.35
39 $381.21 $ 177.47 $203.74
40 $381.21 $ 177.08 $204.13
41 $381.21 $ 176.69 $204.52
42 $381.21 $ 176.30 $204.91
43 $381.21 $ 175.91 $205.31
44 $381.21 $ 175.51 $205.70
45 $381.21 $ 175.12 $206.09
46 $381.21 $ 174.72 $206.49
47 $381.21 $ 174.33 $206.88
48 $381.21 $ 173.93 $207.28
49 $381.21 $ 173.53 $207.68
50 $381.21 $ 173.13 $208.08
51 $381.21 $ 172.74 $208.48
52 $381.21 $ 172.34 $208.88
53 $381.21 $ 171.94 $209.28
54 $381.21 $ 171.53 $209.68
55 $381.21 $ 171.13 $210.08
56 $381.21 $ 170.73 $210.48
57 $381.21 $ 170.33 $210.89
58 $381.21 $ 169.92 $211.29
59 $381.21 $ 169.52 $211.70
60 $381.21 $ 169.11 $212.10
61 $381.21 $ 168.70 $212.51
62 $381.21 $ 168.30 $212.92
63 $381.21 $ 167.89 $213.32
64 $381.21 $ 167.48 $213.73
65 $381.21 $ 167.07 $214.14
66 $381.21 $ 166.66 $214.55
67 $381.21 $ 166.25 $214.97
68 $381.21 $ 165.83 $215.38
69 $381.21 $ 165.42 $215.79
70 $381.21 $ 165.01 $216.21
71 $381.21 $ 164.59 $216.62
72 $381.21 $ 164.18 $217.04
73 $381.21 $ 163.76 $217.45
74 $381.21 $ 163.34 $217.87
75 $381.21 $ 162.93 $218.29
76 $381.21 $ 162.51 $218.71
77 $381.21 $ 162.09 $219.12
78 $381.21 $ 161.67 $219.54
79 $381.21 $ 161.25 $219.97
80 $381.21 $ 160.82 $220.39
81 $381.21 $ 160.40 $220.81
82 $381.21 $ 159.98 $221.23
83 $381.21 $ 159.55 $221.66
84 $381.21 $ 159.13 $222.08
85 $381.21 $ 158.70 $222.51
86 $381.21 $ 158.28 $222.94
87 $381.21 $ 157.85 $223.36
88 $381.21 $ 157.42 $223.79
89 $381.21 $ 156.99 $224.22
90 $381.21 $ 156.56 $224.65
91 $381.21 $ 156.13 $225.08
92 $381.21 $ 155.70 $225.51
93 $381.21 $ 155.27 $225.95
 94 $381.21 $ 154.83 $226.38
95 $381.21 $ 154.40 $226.81
96 $381.21 $ 153.96 $227.25
97 $381.21 $ 153.53 $227.68
98 $381.21 $ 153.09 $228.12
99 $381.21 $ 152.65 $228.56
100 $381.21 $ 152.22 $229.00
101 $381.21 $ 151.78 $229.44
102 $381.21 $ 151.34 $229.88
103 $381.21 $ 150.90 $230.32
104 $381.21 $ 150.45 $230.76
105 $381.21 $ 150.01 $231.20
106 $381.21 $ 149.57 $231.64
107 $381.21 $ 149.12 $232.09
108 $381.21 $ 148.68 $232.53
109 $381.21 $ 148.23 $232.98
110 $381.21 $ 147.79 $233.43
111 $381.21 $ 147.34 $233.87
112 $381.21 $ 146.89 $234.32
113 $381.21 $ 146.44 $234.77
114 $381.21 $ 145.99 $235.22
115 $381.21 $ 145.54 $235.67
116 $381.21 $ 145.09 $236.13
117 $381.21 $ 144.63 $236.58
118 $381.21 $ 144.18 $237.03
119 $381.21 $ 143.73 $237.49
120 $381.21 $ 143.27 $237.94
121 $381.21 $ 142.81 $238.40
122 $381.21 $ 142.36 $238.86
123 $381.21 $ 141.90 $239.31
124 $381.21 $ 141.44 $239.77
125 $381.21 $ 140.98 $240.23
126 $381.21 $ 140.52 $240.69
127 $381.21 $ 140.06 $241.15
128 $381.21 $ 139.59 $241.62
129 $381.21 $ 139.13 $242.08
130 $381.21 $ 138.67 $242.54
131 $381.21 $ 138.20 $243.01
132 $381.21 $ 137.74 $243.48
133 $381.21 $ 137.27 $243.94
134 $381.21 $ 136.80 $244.41
135 $381.21 $ 136.33 $244.88
136 $381.21 $ 135.86 $245.35
137 $381.21 $ 135.39 $245.82
138 $381.21 $ 134.92 $246.29
139 $381.21 $ 134.45 $246.76
140 $381.21 $ 133.98 $247.24
141 $381.21 $ 133.50 $247.71
142 $381.21 $ 133.03 $248.19
143 $381.21 $ 132.55 $248.66
144 $381.21 $ 132.07 $249.14
145 $381.21 $ 131.60 $249.62
146 $381.21 $ 131.12 $250.10
147 $381.21 $ 130.64 $250.57
148 $381.21 $ 130.16 $251.06
149 $381.21 $ 129.68 $251.54
150 $381.21 $ 129.19 $252.02
151 $381.21 $ 128.71 $252.50
152 $381.21 $ 128.23 $252.99
153 $381.21 $ 127.74 $253.47
154 $381.21 $ 127.25 $253.96
155 $381.21 $ 126.77 $254.45
156 $381.21 $ 126.28 $254.93
157 $381.21 $ 125.79 $255.42
158 $381.21 $ 125.30 $255.91
159 $381.21 $ 124.81 $256.40
160 $381.21 $ 124.32 $256.89
161 $381.21 $ 123.82 $257.39
162 $381.21 $ 123.33 $257.88
163 $381.21 $ 122.84 $258.38
164 $381.21 $ 122.34 $258.87
165 $381.21 $ 121.84 $259.37
166 $381.21 $ 121.35 $259.86
167 $381.21 $ 120.85 $260.36
168 $381.21 $ 120.35 $260.86
169 $381.21 $ 119.85 $261.36
170 $381.21 $ 119.35 $261.86
171 $381.21 $ 118.85 $262.37
172 $381.21 $ 118.34 $262.87
173 $381.21 $ 117.84 $263.37
174 $381.21 $ 117.33 $263.88
175 $381.21 $ 116.83 $264.38
176 $381.21 $ 116.32 $264.89
177 $381.21 $ 115.81 $265.40
178 $381.21 $ 115.30 $265.91
179 $381.21 $ 114.79 $266.42
180 $381.21 $ 114.28 $266.93
181 $381.21 $ 113.77 $267.44
182 $381.21 $ 113.26 $267.95
183 $381.21 $ 112.74 $268.47
184 $381.21 $ 112.23 $268.98
185 $381.21 $ 111.71 $269.50
186 $381.21 $ 111.20 $270.02
187 $381.21 $ 110.68 $270.53
188 $381.21 $ 110.16 $271.05
189 $381.21 $ 109.64 $271.57
190 $381.21 $ 109.12 $272.09
191 $381.21 $ 108.60 $272.62
192 $381.21 $ 108.07 $273.14
193 $381.21 $ 107.55 $273.66
194 $381.21 $ 107.03 $274.19
195 $381.21 $ 106.50 $274.71
196 $381.21 $ 105.97 $275.24
197 $381.21 $ 105.44 $275.77
198 $381.21 $ 104.92 $276.30
199 $381.21 $ 104.39 $276.83
200 $381.21 $ 103.86 $277.36
201 $381.21 $ 103.32 $277.89
202 $381.21 $ 102.79 $278.42
203 $381.21 $ 102.26 $278.96
204 $381.21 $ 101.72 $279.49
205 $381.21 $ 101.19 $280.03
206 $381.21 $ 100.65 $280.56
207 $381.21 $ 100.11 $281.10
208 $381.21 $ 99.57 $281.64
209 $381.21 $ 99.03 $282.18
210 $381.21 $ 98.49 $282.72
211 $381.21 $ 97.95 $283.26
212 $381.21 $ 97.40 $283.81
213 $381.21 $ 96.86 $284.35
214 $381.21 $ 96.31 $284.90
215 $381.21 $ 95.77 $285.44
216 $381.21 $ 95.22 $285.99
217 $381.21 $ 94.67 $286.54
218 $381.21 $ 94.12 $287.09
219 $381.21 $ 93.57 $287.64
220 $381.21 $ 93.02 $288.19
221 $381.21 $ 92.47 $288.74
222 $381.21 $ 91.91 $289.30
223 $381.21 $ 91.36 $289.85
224 $381.21 $ 90.80 $290.41
225 $381.21 $ 90.25 $290.97
226 $381.21 $ 89.69 $291.52
227 $381.21 $ 89.13 $292.08
228 $381.21 $ 88.57 $292.64
229 $381.21 $ 88.01 $293.20
230 $381.21 $ 87.45 $293.77
231 $381.21 $ 86.88 $294.33
232 $381.21 $ 86.32 $294.89
233 $381.21 $ 85.75 $295.46
234 $381.21 $ 85.19 $296.03
235 $381.21 $ 84.62 $296.59
236 $381.21 $ 84.05 $297.16
237 $381.21 $ 83.48 $297.73
238 $381.21 $ 82.91 $298.30
239 $381.21 $ 82.34 $298.88
240 $381.21 $ 81.76 $299.45
241 $381.21 $ 81.19 $300.02
242 $381.21 $ 80.61 $300.60
243 $381.21 $ 80.04 $301.17
244 $381.21 $ 79.46 $301.75
245 $381.21 $ 78.88 $302.33
246 $381.21 $ 78.30 $302.91
247 $381.21 $ 77.72 $303.49
248 $381.21 $ 77.14 $304.07
249 $381.21 $ 76.55 $304.66
250 $381.21 $ 75.97 $305.24
251 $381.21 $ 75.39 $305.83
252 $381.21 $ 74.80 $306.41
253 $381.21 $ 74.21 $307.00
254 $381.21 $ 73.62 $307.59
255 $381.21 $ 73.03 $308.18
256 $381.21 $ 72.44 $308.77
257 $381.21 $ 71.85 $309.36
258 $381.21 $ 71.26 $309.96
259 $381.21 $ 70.66 $310.55
260 $381.21 $ 70.07 $311.15
261 $381.21 $ 69.47 $311.74
262 $381.21 $ 68.87 $312.34
263 $381.21 $ 68.27 $312.94
264 $381.21 $ 67.67 $313.54
265 $381.21 $ 67.07 $314.14
266 $381.21 $ 66.47 $314.74
267 $381.21 $ 65.86 $315.35
268 $381.21 $ 65.26 $315.95
269 $381.21 $ 64.65 $316.56
270 $381.21 $ 64.05 $317.17
271 $381.21 $ 63.44 $317.77
272 $381.21 $ 62.83 $318.38
273 $381.21 $ 62.22 $318.99
274 $381.21 $ 61.61 $319.61
275 $381.21 $ 60.99 $320.22
276 $381.21 $ 60.38 $320.83
277 $381.21 $ 59.76 $321.45
278 $381.21 $ 59.15 $322.06
279 $381.21 $ 58.53 $322.68
280 $381.21 $ 57.91 $323.30
281 $381.21 $ 57.29 $323.92
282 $381.21 $ 56.67 $324.54
283 $381.21 $ 56.05 $325.16
284 $381.21 $ 55.42 $325.79
285 $381.21 $ 54.80 $326.41
286 $381.21 $ 54.17 $327.04
287 $381.21 $ 53.55 $327.67
288 $381.21 $ 52.92 $328.29
289 $381.21 $ 52.29 $328.92
290 $381.21 $ 51.66 $329.55
291 $381.21 $ 51.03 $330.19
292 $381.21 $ 50.39 $330.82
293 $381.21 $ 49.76 $331.45
294 $381.21 $ 49.12 $332.09
295 $381.21 $ 48.49 $332.73
296 $381.21 $ 47.85 $333.36
297 $381.21 $ 47.21 $334.00
298 $381.21 $ 46.57 $334.64
299 $381.21 $ 45.93 $335.29
300 $381.21 $ 45.28 $335.93
301 $381.21 $ 44.64 $336.57
302 $381.21 $ 43.99 $337.22
303 $381.21 $ 43.35 $337.87
304 $381.21 $ 42.70 $338.51
305 $381.21 $ 42.05 $339.16
306 $381.21 $ 41.40 $339.81
307 $381.21 $ 40.75 $340.47
308 $381.21 $ 40.09 $341.12
309 $381.21 $ 39.44 $341.77
310 $381.21 $ 38.78 $342.43
311 $381.21 $ 38.13 $343.08
312 $381.21 $ 37.47 $343.74
313 $381.21 $ 36.81 $344.40
314 $381.21 $ 36.15 $345.06
315 $381.21 $ 35.49 $345.72
316 $381.21 $ 34.82 $346.39
317 $381.21 $ 34.16 $347.05
318 $381.21 $ 33.49 $347.72
319 $381.21 $ 32.83 $348.38
320 $381.21 $ 32.16 $349.05
321 $381.21 $ 31.49 $349.72
322 $381.21 $ 30.82 $350.39
323 $381.21 $ 30.15 $351.06
324 $381.21 $ 29.47 $351.74
325 $381.21 $ 28.80 $352.41
326 $381.21 $ 28.12 $353.09
327 $381.21 $ 27.45 $353.77
328 $381.21 $ 26.77 $354.44
329 $381.21 $ 26.09 $355.12
330 $381.21 $ 25.41 $355.80
331 $381.21 $ 24.73 $356.49
332 $381.21 $ 24.04 $357.17
333 $381.21 $ 23.36 $357.86
334 $381.21 $ 22.67 $358.54
335 $381.21 $ 21.98 $359.23
336 $381.21 $ 21.29 $359.92
337 $381.21 $ 20.60 $360.61
338 $381.21 $ 19.91 $361.30
339 $381.21 $ 19.22 $361.99
340 $381.21 $ 18.52 $362.69
341 $381.21 $ 17.83 $363.38
342 $381.21 $ 17.13 $364.08
343 $381.21 $ 16.43 $364.78
344 $381.21 $ 15.73 $365.48
345 $381.21 $ 15.03 $366.18
346 $381.21 $ 14.33 $366.88
347 $381.21 $ 13.63 $367.58
348 $381.21 $ 12.92 $368.29
349 $381.21 $ 12.22 $369.00
350 $381.21 $ 11.51 $369.70
351 $381.21 $ 10.80 $370.41
352 $381.21 $ 10.09 $371.12
353 $381.21 $ 9.38 $371.83
354 $381.21 $ 8.66 $372.55
355 $381.21 $ 7.95 $373.26
356 $381.21 $ 7.23 $373.98
357 $381.21 $ 6.52 $374.69
358 $381.21 $ 5.80 $375.41
359 $381.21 $ 5.08 $376.13
360 $381.21 $ 4.36 $376.85
361 $381.21 $ 3.63 $377.58
362 $381.21 $ 2.91 $378.30
363 $381.21 $ 2.18 $379.03
364 $381.21 $ 1.46 $379.75
365 $381.21 $ 0.73 $380.48
 Balance
$ 100,000.00
$ 99,810.57
$ 99,620.77
$ 99,430.62
$ 99,240.09
$ 99,049.20
$ 98,857.95
$ 98,666.33
$ 98,474.34
$ 98,281.98
$ 98,089.26
$ 97,896.16
$ 97,702.69
$ 97,508.86
$ 97,314.65
$ 97,120.07
$ 96,925.11
$ 96,729.78
$ 96,534.08
$ 96,338.00
$ 96,141.55
$ 95,944.72
$ 95,747.51
$ 95,549.92
$ 95,351.96
$ 95,153.61
$ 94,954.89
$ 94,755.78
$ 94,556.29
$ 94,356.42
$ 94,156.16
$ 93,955.53
$ 93,754.50
$ 93,553.09
$ 93,351.30
$ 93,149.12
$ 92,946.55
$ 92,743.59
$ 92,540.24
$ 92,336.50
$ 92,132.37
$ 91,927.85
$ 91,722.94
$ 91,517.64
$ 91,311.94
$ 91,105.84
$ 90,899.36
$ 90,692.47
$ 90,485.19
$ 90,277.51
$ 90,069.43
$ 89,860.96
$ 89,652.08
$ 89,442.80
$ 89,233.13
$ 89,023.05
$ 88,812.56
$ 88,601.68
$ 88,390.39
$ 88,178.69
$ 87,966.59
$ 87,754.08
$ 87,541.16
$ 87,327.84
$ 87,114.10
$ 86,899.96
$ 86,685.40
$ 86,470.44
$ 86,255.06
$ 86,039.27
$ 85,823.06
$ 85,606.44
$ 85,389.41
$ 85,171.96
$ 84,954.09
$ 84,735.80
$ 84,517.10
$ 84,297.97
$ 84,078.43
$ 83,858.46
$ 83,638.07
$ 83,417.26
$ 83,196.03
$ 82,974.37
$ 82,752.29
$ 82,529.78
$ 82,306.84
$ 82,083.48
$ 81,859.69
$ 81,635.47
$ 81,410.82
$ 81,185.73
$ 80,960.22
$ 80,734.28
$ 80,507.90
$ 80,281.08
$ 80,053.83
$ 79,826.15
$ 79,598.03
$ 79,369.47
$ 79,140.47
$ 78,911.04
$ 78,681.16
$ 78,450.85
$ 78,220.09
$ 77,988.89
$ 77,757.24
$ 77,525.15
$ 77,292.62
$ 77,059.64
$ 76,826.21
$ 76,592.34
$ 76,358.02
$ 76,123.24
$ 75,888.02
$ 75,652.35
$ 75,416.22
$ 75,179.65
$ 74,942.61
$ 74,705.13
$ 74,467.19
$ 74,228.79
$ 73,989.93
$ 73,750.62
$ 73,510.85
$ 73,270.61
$ 73,029.92
$ 72,788.76
$ 72,547.15
$ 72,305.07
$ 72,062.52
$ 71,819.51
$ 71,576.04
$ 71,332.09
$ 71,087.68
$ 70,842.80
$ 70,597.45
$ 70,351.63
$ 70,105.34
$ 69,858.58
$ 69,611.34
$ 69,363.63
$ 69,115.45
$ 68,866.78
$ 68,617.65
$ 68,368.03
$ 68,117.93
$ 67,867.36
$ 67,616.30
$ 67,364.77
$ 67,112.75
$ 66,860.24
$ 66,607.26
$ 66,353.78
$ 66,099.83
$ 65,845.38
$ 65,590.45
$ 65,335.03
$ 65,079.11
$ 64,822.71
$ 64,565.82
$ 64,308.43
$ 64,050.55
$ 63,792.17
$ 63,533.30
$ 63,273.93
$ 63,014.07
$ 62,753.71
$ 62,492.84
$ 62,231.48
$ 61,969.62
$ 61,707.25
$ 61,444.38
$ 61,181.01
$ 60,917.13
$ 60,652.74
$ 60,387.85
$ 60,122.45
$ 59,856.54
$ 59,590.13
$ 59,323.20
$ 59,055.75
$ 58,787.80
$ 58,519.33
$ 58,250.35
$ 57,980.85
$ 57,710.83
$ 57,440.30
$ 57,169.25
$ 56,897.67
$ 56,625.58
$ 56,352.97
$ 56,079.83
$ 55,806.17
$ 55,531.98
$ 55,257.27
$ 54,982.03
$ 54,706.26
$ 54,429.96
$ 54,153.14
$ 53,875.78
$ 53,597.89
$ 53,319.47
$ 53,040.52
$ 52,761.03
$ 52,481.00
$ 52,200.44
$ 51,919.33
$ 51,637.69
$ 51,355.51
$ 51,072.79
$ 50,789.53
$ 50,505.72
$ 50,221.37
$ 49,936.47
$ 49,651.03
$ 49,365.03
$ 49,078.50
$ 48,791.41
$ 48,503.77
$ 48,215.58
$ 47,926.83
$ 47,637.53
$ 47,347.68
$ 47,057.27
$ 46,766.31
$ 46,474.78
$ 46,182.70
$ 45,890.06
$ 45,596.86
$ 45,303.09
$ 45,008.76
$ 44,713.87
$ 44,418.41
$ 44,122.38
$ 43,825.79
$ 43,528.62
$ 43,230.89
$ 42,932.59
$ 42,633.71
$ 42,334.26
$ 42,034.24
$ 41,733.64
$ 41,432.47
$ 41,130.72
$ 40,828.38
$ 40,525.47
$ 40,221.98
$ 39,917.91
$ 39,613.25
$ 39,308.01
$ 39,002.18
$ 38,695.77
$ 38,388.77
$ 38,081.18
$ 37,773.00
$ 37,464.23
$ 37,154.86
$ 36,844.91
$ 36,534.36
$ 36,223.21
$ 35,911.47
$ 35,599.13
$ 35,286.19
$ 34,972.65
$ 34,658.51
$ 34,343.76
$ 34,028.41
$ 33,712.46
$ 33,395.90
$ 33,078.74
$ 32,760.97
$ 32,442.58
$ 32,123.59
$ 31,803.98
$ 31,483.77
$ 31,162.93
$ 30,841.49
$ 30,519.42
$ 30,196.74
$ 29,873.44
$ 29,549.52
$ 29,224.98
$ 28,899.81
$ 28,574.03
$ 28,247.61
$ 27,920.57
$ 27,592.91
$ 27,264.61
$ 26,935.69
$ 26,606.14
$ 26,275.95
$ 25,945.13
$ 25,613.68
$ 25,281.59
$ 24,948.86
$ 24,615.49
$ 24,281.49
$ 23,946.84
$ 23,611.56
$ 23,275.63
$ 22,939.05
$ 22,601.84
$ 22,263.97
$ 21,925.46
$ 21,586.29
$ 21,246.48
$ 20,906.01
$ 20,564.89
$ 20,223.12
$ 19,880.69
$ 19,537.61
$ 19,193.87
$ 18,849.46
$ 18,504.40
$ 18,158.68
$ 17,812.29
$ 17,465.24
$ 17,117.52
$ 16,769.14
$ 16,420.09
$ 16,070.36
$ 15,719.97
$ 15,368.91
$ 15,017.17
$ 14,664.76
$ 14,311.67
$ 13,957.91
$ 13,603.46
$ 13,248.34
$ 12,892.53
$ 12,536.05
$ 12,178.88
$ 11,821.02
$ 11,462.48
$ 11,103.25
$ 10,743.33
$ 10,382.72
$ 10,021.42
$ 9,659.43
$ 9,296.74
$ 8,933.36
$ 8,569.28
$ 8,204.50
$ 7,839.03
$ 7,472.85
$ 7,105.97
$ 6,738.38
$ 6,370.09
$ 6,001.10
$ 5,631.40
$ 5,260.98
$ 4,889.86
$ 4,518.03
$ 4,145.48
$ 3,772.22
$ 3,398.24
$ 3,023.54
$ 2,648.13
$ 2,272.00
$ 1,895.14
$ 1,517.57
$ 1,139.26
$ 760.24
$ 380.48
$ (0.000000000)
Coast Jewelers, Inc.
5. Loan Amortization Schedule (Daily)

Amount $100,000
Rate (annually) 10%
Term (in years) 3
Payment $106

Payment # Payment Interest Principal

1 $105.72 $ 27.40 $78.32

2 $105.72 $ 27.38 $78.34
3 $105.72 $ 27.35 $78.36
4 $105.72 $ 27.33 $78.39
5 $105.72 $ 27.31 $78.41
6 $105.72 $ 27.29 $78.43
7 $105.72 $ 27.27 $78.45
8 $105.72 $ 27.25 $78.47
9 $105.72 $ 27.23 $78.49
10 $105.72 $ 27.20 $78.52
11 $105.72 $ 27.18 $78.54
12 $105.72 $ 27.16 $78.56
13 $105.72 $ 27.14 $78.58
14 $105.72 $ 27.12 $78.60
15 $105.72 $ 27.10 $78.62
16 $105.72 $ 27.07 $78.64
17 $105.72 $ 27.05 $78.67
18 $105.72 $ 27.03 $78.69
19 $105.72 $ 27.01 $78.71
20 $105.72 $ 26.99 $78.73
21 $105.72 $ 26.97 $78.75
22 $105.72 $ 26.95 $78.77
23 $105.72 $ 26.92 $78.80
24 $105.72 $ 26.90 $78.82
25 $105.72 $ 26.88 $78.84
26 $105.72 $ 26.86 $78.86
27 $105.72 $ 26.84 $78.88
28 $105.72 $ 26.82 $78.90
29 $105.72 $ 26.79 $78.92
30 $105.72 $ 26.77 $78.95
31 $105.72 $ 26.75 $78.97
32 $105.72 $ 26.73 $78.99
33 $105.72 $ 26.71 $79.01
34 $105.72 $ 26.69 $79.03
35 $105.72 $ 26.66 $79.05
36 $105.72 $ 26.64 $79.08
37 $105.72 $ 26.62 $79.10
38 $105.72 $ 26.60 $79.12
39 $105.72 $ 26.58 $79.14
40 $105.72 $ 26.56 $79.16
41 $105.72 $ 26.53 $79.18
42 $105.72 $ 26.51 $79.21
43 $105.72 $ 26.49 $79.23
44 $105.72 $ 26.47 $79.25
45 $105.72 $ 26.45 $79.27
46 $105.72 $ 26.43 $79.29
47 $105.72 $ 26.40 $79.32
48 $105.72 $ 26.38 $79.34
49 $105.72 $ 26.36 $79.36
50 $105.72 $ 26.34 $79.38
51 $105.72 $ 26.32 $79.40
52 $105.72 $ 26.30 $79.42
53 $105.72 $ 26.27 $79.45
54 $105.72 $ 26.25 $79.47
55 $105.72 $ 26.23 $79.49
56 $105.72 $ 26.21 $79.51
57 $105.72 $ 26.19 $79.53
58 $105.72 $ 26.16 $79.55
59 $105.72 $ 26.14 $79.58
60 $105.72 $ 26.12 $79.60
61 $105.72 $ 26.10 $79.62
62 $105.72 $ 26.08 $79.64
63 $105.72 $ 26.06 $79.66
64 $105.72 $ 26.03 $79.69
65 $105.72 $ 26.01 $79.71
66 $105.72 $ 25.99 $79.73
67 $105.72 $ 25.97 $79.75
68 $105.72 $ 25.95 $79.77
69 $105.72 $ 25.92 $79.79
70 $105.72 $ 25.90 $79.82
71 $105.72 $ 25.88 $79.84
72 $105.72 $ 25.86 $79.86
73 $105.72 $ 25.84 $79.88
74 $105.72 $ 25.82 $79.90
75 $105.72 $ 25.79 $79.93
76 $105.72 $ 25.77 $79.95
77 $105.72 $ 25.75 $79.97
78 $105.72 $ 25.73 $79.99
79 $105.72 $ 25.71 $80.01
80 $105.72 $ 25.68 $80.04
81 $105.72 $ 25.66 $80.06
82 $105.72 $ 25.64 $80.08
83 $105.72 $ 25.62 $80.10
84 $105.72 $ 25.60 $80.12
85 $105.72 $ 25.57 $80.15
86 $105.72 $ 25.55 $80.17
87 $105.72 $ 25.53 $80.19
88 $105.72 $ 25.51 $80.21
89 $105.72 $ 25.49 $80.23
90 $105.72 $ 25.46 $80.25
91 $105.72 $ 25.44 $80.28
92 $105.72 $ 25.42 $80.30
93 $105.72 $ 25.40 $80.32
 94 $105.72 $ 25.38 $80.34
95 $105.72 $ 25.35 $80.36
96 $105.72 $ 25.33 $80.39
97 $105.72 $ 25.31 $80.41
98 $105.72 $ 25.29 $80.43
99 $105.72 $ 25.27 $80.45
100 $105.72 $ 25.24 $80.48
101 $105.72 $ 25.22 $80.50
102 $105.72 $ 25.20 $80.52
103 $105.72 $ 25.18 $80.54
104 $105.72 $ 25.16 $80.56
105 $105.72 $ 25.13 $80.59
106 $105.72 $ 25.11 $80.61
107 $105.72 $ 25.09 $80.63
108 $105.72 $ 25.07 $80.65
109 $105.72 $ 25.05 $80.67
110 $105.72 $ 25.02 $80.70
111 $105.72 $ 25.00 $80.72
112 $105.72 $ 24.98 $80.74
113 $105.72 $ 24.96 $80.76
114 $105.72 $ 24.93 $80.78
115 $105.72 $ 24.91 $80.81
116 $105.72 $ 24.89 $80.83
117 $105.72 $ 24.87 $80.85
118 $105.72 $ 24.85 $80.87
119 $105.72 $ 24.82 $80.89
120 $105.72 $ 24.80 $80.92
121 $105.72 $ 24.78 $80.94
122 $105.72 $ 24.76 $80.96
123 $105.72 $ 24.74 $80.98
124 $105.72 $ 24.71 $81.01
125 $105.72 $ 24.69 $81.03
126 $105.72 $ 24.67 $81.05
127 $105.72 $ 24.65 $81.07
128 $105.72 $ 24.62 $81.09
129 $105.72 $ 24.60 $81.12
130 $105.72 $ 24.58 $81.14
131 $105.72 $ 24.56 $81.16
132 $105.72 $ 24.54 $81.18
133 $105.72 $ 24.51 $81.21
134 $105.72 $ 24.49 $81.23
135 $105.72 $ 24.47 $81.25
136 $105.72 $ 24.45 $81.27
137 $105.72 $ 24.42 $81.29
138 $105.72 $ 24.40 $81.32
139 $105.72 $ 24.38 $81.34
140 $105.72 $ 24.36 $81.36
141 $105.72 $ 24.34 $81.38
142 $105.72 $ 24.31 $81.41
143 $105.72 $ 24.29 $81.43
144 $105.72 $ 24.27 $81.45
145 $105.72 $ 24.25 $81.47
146 $105.72 $ 24.22 $81.50
147 $105.72 $ 24.20 $81.52
148 $105.72 $ 24.18 $81.54
149 $105.72 $ 24.16 $81.56
150 $105.72 $ 24.13 $81.58
151 $105.72 $ 24.11 $81.61
152 $105.72 $ 24.09 $81.63
153 $105.72 $ 24.07 $81.65
154 $105.72 $ 24.04 $81.67
155 $105.72 $ 24.02 $81.70
156 $105.72 $ 24.00 $81.72
157 $105.72 $ 23.98 $81.74
158 $105.72 $ 23.96 $81.76
159 $105.72 $ 23.93 $81.79
160 $105.72 $ 23.91 $81.81
161 $105.72 $ 23.89 $81.83
162 $105.72 $ 23.87 $81.85
163 $105.72 $ 23.84 $81.88
164 $105.72 $ 23.82 $81.90
165 $105.72 $ 23.80 $81.92
166 $105.72 $ 23.78 $81.94
167 $105.72 $ 23.75 $81.97
168 $105.72 $ 23.73 $81.99
169 $105.72 $ 23.71 $82.01
170 $105.72 $ 23.69 $82.03
171 $105.72 $ 23.66 $82.06
172 $105.72 $ 23.64 $82.08
173 $105.72 $ 23.62 $82.10
174 $105.72 $ 23.60 $82.12
175 $105.72 $ 23.57 $82.15
176 $105.72 $ 23.55 $82.17
177 $105.72 $ 23.53 $82.19
178 $105.72 $ 23.51 $82.21
179 $105.72 $ 23.48 $82.24
180 $105.72 $ 23.46 $82.26
181 $105.72 $ 23.44 $82.28
182 $105.72 $ 23.42 $82.30
183 $105.72 $ 23.39 $82.33
184 $105.72 $ 23.37 $82.35
185 $105.72 $ 23.35 $82.37
186 $105.72 $ 23.33 $82.39
187 $105.72 $ 23.30 $82.42
188 $105.72 $ 23.28 $82.44
189 $105.72 $ 23.26 $82.46
190 $105.72 $ 23.24 $82.48
191 $105.72 $ 23.21 $82.51
192 $105.72 $ 23.19 $82.53
193 $105.72 $ 23.17 $82.55
194 $105.72 $ 23.15 $82.57
195 $105.72 $ 23.12 $82.60
196 $105.72 $ 23.10 $82.62
197 $105.72 $ 23.08 $82.64
198 $105.72 $ 23.05 $82.66
199 $105.72 $ 23.03 $82.69
200 $105.72 $ 23.01 $82.71
201 $105.72 $ 22.99 $82.73
202 $105.72 $ 22.96 $82.76
203 $105.72 $ 22.94 $82.78
204 $105.72 $ 22.92 $82.80
205 $105.72 $ 22.90 $82.82
206 $105.72 $ 22.87 $82.85
207 $105.72 $ 22.85 $82.87
208 $105.72 $ 22.83 $82.89
209 $105.72 $ 22.81 $82.91
210 $105.72 $ 22.78 $82.94
211 $105.72 $ 22.76 $82.96
212 $105.72 $ 22.74 $82.98
213 $105.72 $ 22.71 $83.01
214 $105.72 $ 22.69 $83.03
215 $105.72 $ 22.67 $83.05
216 $105.72 $ 22.65 $83.07
217 $105.72 $ 22.62 $83.10
218 $105.72 $ 22.60 $83.12
219 $105.72 $ 22.58 $83.14
220 $105.72 $ 22.55 $83.16
221 $105.72 $ 22.53 $83.19
222 $105.72 $ 22.51 $83.21
223 $105.72 $ 22.49 $83.23
224 $105.72 $ 22.46 $83.26
225 $105.72 $ 22.44 $83.28
226 $105.72 $ 22.42 $83.30
227 $105.72 $ 22.40 $83.32
228 $105.72 $ 22.37 $83.35
229 $105.72 $ 22.35 $83.37
230 $105.72 $ 22.33 $83.39
231 $105.72 $ 22.30 $83.42
232 $105.72 $ 22.28 $83.44
233 $105.72 $ 22.26 $83.46
234 $105.72 $ 22.24 $83.48
235 $105.72 $ 22.21 $83.51
236 $105.72 $ 22.19 $83.53
237 $105.72 $ 22.17 $83.55
238 $105.72 $ 22.14 $83.58
239 $105.72 $ 22.12 $83.60
240 $105.72 $ 22.10 $83.62
241 $105.72 $ 22.07 $83.64
242 $105.72 $ 22.05 $83.67
243 $105.72 $ 22.03 $83.69
244 $105.72 $ 22.01 $83.71
245 $105.72 $ 21.98 $83.74
246 $105.72 $ 21.96 $83.76
247 $105.72 $ 21.94 $83.78
248 $105.72 $ 21.91 $83.80
249 $105.72 $ 21.89 $83.83
250 $105.72 $ 21.87 $83.85
251 $105.72 $ 21.85 $83.87
252 $105.72 $ 21.82 $83.90
253 $105.72 $ 21.80 $83.92
254 $105.72 $ 21.78 $83.94
255 $105.72 $ 21.75 $83.97
256 $105.72 $ 21.73 $83.99
257 $105.72 $ 21.71 $84.01
258 $105.72 $ 21.68 $84.03
259 $105.72 $ 21.66 $84.06
260 $105.72 $ 21.64 $84.08
261 $105.72 $ 21.62 $84.10
262 $105.72 $ 21.59 $84.13
263 $105.72 $ 21.57 $84.15
264 $105.72 $ 21.55 $84.17
265 $105.72 $ 21.52 $84.20
266 $105.72 $ 21.50 $84.22
267 $105.72 $ 21.48 $84.24
268 $105.72 $ 21.45 $84.27
269 $105.72 $ 21.43 $84.29
270 $105.72 $ 21.41 $84.31
271 $105.72 $ 21.38 $84.33
272 $105.72 $ 21.36 $84.36
273 $105.72 $ 21.34 $84.38
274 $105.72 $ 21.32 $84.40
275 $105.72 $ 21.29 $84.43
276 $105.72 $ 21.27 $84.45
277 $105.72 $ 21.25 $84.47
278 $105.72 $ 21.22 $84.50
279 $105.72 $ 21.20 $84.52
280 $105.72 $ 21.18 $84.54
281 $105.72 $ 21.15 $84.57
282 $105.72 $ 21.13 $84.59
283 $105.72 $ 21.11 $84.61
284 $105.72 $ 21.08 $84.64
285 $105.72 $ 21.06 $84.66
286 $105.72 $ 21.04 $84.68
287 $105.72 $ 21.01 $84.70
288 $105.72 $ 20.99 $84.73
289 $105.72 $ 20.97 $84.75
290 $105.72 $ 20.94 $84.77
291 $105.72 $ 20.92 $84.80
292 $105.72 $ 20.90 $84.82
293 $105.72 $ 20.87 $84.84
294 $105.72 $ 20.85 $84.87
295 $105.72 $ 20.83 $84.89
296 $105.72 $ 20.81 $84.91
297 $105.72 $ 20.78 $84.94
298 $105.72 $ 20.76 $84.96
299 $105.72 $ 20.74 $84.98
300 $105.72 $ 20.71 $85.01
301 $105.72 $ 20.69 $85.03
302 $105.72 $ 20.67 $85.05
303 $105.72 $ 20.64 $85.08
304 $105.72 $ 20.62 $85.10
305 $105.72 $ 20.60 $85.12
306 $105.72 $ 20.57 $85.15
307 $105.72 $ 20.55 $85.17
308 $105.72 $ 20.53 $85.19
309 $105.72 $ 20.50 $85.22
310 $105.72 $ 20.48 $85.24
311 $105.72 $ 20.46 $85.26
312 $105.72 $ 20.43 $85.29
313 $105.72 $ 20.41 $85.31
314 $105.72 $ 20.39 $85.33
315 $105.72 $ 20.36 $85.36
316 $105.72 $ 20.34 $85.38
317 $105.72 $ 20.32 $85.40
318 $105.72 $ 20.29 $85.43
319 $105.72 $ 20.27 $85.45
320 $105.72 $ 20.25 $85.47
321 $105.72 $ 20.22 $85.50
322 $105.72 $ 20.20 $85.52
323 $105.72 $ 20.17 $85.54
324 $105.72 $ 20.15 $85.57
325 $105.72 $ 20.13 $85.59
326 $105.72 $ 20.10 $85.61
327 $105.72 $ 20.08 $85.64
328 $105.72 $ 20.06 $85.66
329 $105.72 $ 20.03 $85.69
330 $105.72 $ 20.01 $85.71
331 $105.72 $ 19.99 $85.73
332 $105.72 $ 19.96 $85.76
333 $105.72 $ 19.94 $85.78
334 $105.72 $ 19.92 $85.80
335 $105.72 $ 19.89 $85.83
336 $105.72 $ 19.87 $85.85
337 $105.72 $ 19.85 $85.87
338 $105.72 $ 19.82 $85.90
339 $105.72 $ 19.80 $85.92
340 $105.72 $ 19.78 $85.94
341 $105.72 $ 19.75 $85.97
342 $105.72 $ 19.73 $85.99
343 $105.72 $ 19.70 $86.01
344 $105.72 $ 19.68 $86.04
345 $105.72 $ 19.66 $86.06
346 $105.72 $ 19.63 $86.08
347 $105.72 $ 19.61 $86.11
348 $105.72 $ 19.59 $86.13
349 $105.72 $ 19.56 $86.16
350 $105.72 $ 19.54 $86.18
351 $105.72 $ 19.52 $86.20
352 $105.72 $ 19.49 $86.23
353 $105.72 $ 19.47 $86.25
354 $105.72 $ 19.45 $86.27
355 $105.72 $ 19.42 $86.30
356 $105.72 $ 19.40 $86.32
357 $105.72 $ 19.37 $86.34
358 $105.72 $ 19.35 $86.37
359 $105.72 $ 19.33 $86.39
360 $105.72 $ 19.30 $86.42
361 $105.72 $ 19.28 $86.44
362 $105.72 $ 19.26 $86.46
363 $105.72 $ 19.23 $86.49
364 $105.72 $ 19.21 $86.51
365 $105.72 $ 19.18 $86.53
366 $105.72 $ 19.16 $86.56
367 $105.72 $ 19.14 $86.58
368 $105.72 $ 19.11 $86.61
369 $105.72 $ 19.09 $86.63
370 $105.72 $ 19.07 $86.65
371 $105.72 $ 19.04 $86.68
372 $105.72 $ 19.02 $86.70
373 $105.72 $ 19.00 $86.72
374 $105.72 $ 18.97 $86.75
375 $105.72 $ 18.95 $86.77
376 $105.72 $ 18.92 $86.80
377 $105.72 $ 18.90 $86.82
378 $105.72 $ 18.88 $86.84
379 $105.72 $ 18.85 $86.87
380 $105.72 $ 18.83 $86.89
381 $105.72 $ 18.80 $86.91
382 $105.72 $ 18.78 $86.94
383 $105.72 $ 18.76 $86.96
384 $105.72 $ 18.73 $86.99
385 $105.72 $ 18.71 $87.01
386 $105.72 $ 18.69 $87.03
387 $105.72 $ 18.66 $87.06
388 $105.72 $ 18.64 $87.08
389 $105.72 $ 18.61 $87.10
390 $105.72 $ 18.59 $87.13
391 $105.72 $ 18.57 $87.15
392 $105.72 $ 18.54 $87.18
393 $105.72 $ 18.52 $87.20
394 $105.72 $ 18.49 $87.22
395 $105.72 $ 18.47 $87.25
396 $105.72 $ 18.45 $87.27
397 $105.72 $ 18.42 $87.30
398 $105.72 $ 18.40 $87.32
399 $105.72 $ 18.38 $87.34
400 $105.72 $ 18.35 $87.37
401 $105.72 $ 18.33 $87.39
402 $105.72 $ 18.30 $87.42
403 $105.72 $ 18.28 $87.44
404 $105.72 $ 18.26 $87.46
405 $105.72 $ 18.23 $87.49
406 $105.72 $ 18.21 $87.51
407 $105.72 $ 18.18 $87.54
408 $105.72 $ 18.16 $87.56
409 $105.72 $ 18.14 $87.58
410 $105.72 $ 18.11 $87.61
411 $105.72 $ 18.09 $87.63
412 $105.72 $ 18.06 $87.66
413 $105.72 $ 18.04 $87.68
414 $105.72 $ 18.02 $87.70
415 $105.72 $ 17.99 $87.73
416 $105.72 $ 17.97 $87.75
417 $105.72 $ 17.94 $87.78
418 $105.72 $ 17.92 $87.80
419 $105.72 $ 17.90 $87.82
420 $105.72 $ 17.87 $87.85
421 $105.72 $ 17.85 $87.87
422 $105.72 $ 17.82 $87.90
423 $105.72 $ 17.80 $87.92
424 $105.72 $ 17.78 $87.94
425 $105.72 $ 17.75 $87.97
426 $105.72 $ 17.73 $87.99
427 $105.72 $ 17.70 $88.02
428 $105.72 $ 17.68 $88.04
429 $105.72 $ 17.65 $88.06
430 $105.72 $ 17.63 $88.09
431 $105.72 $ 17.61 $88.11
432 $105.72 $ 17.58 $88.14
433 $105.72 $ 17.56 $88.16
434 $105.72 $ 17.53 $88.19
435 $105.72 $ 17.51 $88.21
436 $105.72 $ 17.49 $88.23
437 $105.72 $ 17.46 $88.26
438 $105.72 $ 17.44 $88.28
439 $105.72 $ 17.41 $88.31
440 $105.72 $ 17.39 $88.33
441 $105.72 $ 17.36 $88.35
442 $105.72 $ 17.34 $88.38
443 $105.72 $ 17.32 $88.40
444 $105.72 $ 17.29 $88.43
445 $105.72 $ 17.27 $88.45
446 $105.72 $ 17.24 $88.48
447 $105.72 $ 17.22 $88.50
448 $105.72 $ 17.19 $88.52
449 $105.72 $ 17.17 $88.55
450 $105.72 $ 17.15 $88.57
451 $105.72 $ 17.12 $88.60
452 $105.72 $ 17.10 $88.62
453 $105.72 $ 17.07 $88.65
454 $105.72 $ 17.05 $88.67
455 $105.72 $ 17.03 $88.69
456 $105.72 $ 17.00 $88.72
457 $105.72 $ 16.98 $88.74
458 $105.72 $ 16.95 $88.77
459 $105.72 $ 16.93 $88.79
460 $105.72 $ 16.90 $88.82
461 $105.72 $ 16.88 $88.84
462 $105.72 $ 16.85 $88.86
463 $105.72 $ 16.83 $88.89
464 $105.72 $ 16.81 $88.91
465 $105.72 $ 16.78 $88.94
466 $105.72 $ 16.76 $88.96
467 $105.72 $ 16.73 $88.99
468 $105.72 $ 16.71 $89.01
469 $105.72 $ 16.68 $89.03
470 $105.72 $ 16.66 $89.06
471 $105.72 $ 16.64 $89.08
472 $105.72 $ 16.61 $89.11
473 $105.72 $ 16.59 $89.13
474 $105.72 $ 16.56 $89.16
475 $105.72 $ 16.54 $89.18
476 $105.72 $ 16.51 $89.21
477 $105.72 $ 16.49 $89.23
478 $105.72 $ 16.46 $89.25
479 $105.72 $ 16.44 $89.28
480 $105.72 $ 16.42 $89.30
481 $105.72 $ 16.39 $89.33
482 $105.72 $ 16.37 $89.35
483 $105.72 $ 16.34 $89.38
484 $105.72 $ 16.32 $89.40
485 $105.72 $ 16.29 $89.43
486 $105.72 $ 16.27 $89.45
487 $105.72 $ 16.24 $89.48
488 $105.72 $ 16.22 $89.50
489 $105.72 $ 16.20 $89.52
490 $105.72 $ 16.17 $89.55
491 $105.72 $ 16.15 $89.57
492 $105.72 $ 16.12 $89.60
493 $105.72 $ 16.10 $89.62
494 $105.72 $ 16.07 $89.65
495 $105.72 $ 16.05 $89.67
496 $105.72 $ 16.02 $89.70
497 $105.72 $ 16.00 $89.72
498 $105.72 $ 15.97 $89.75
499 $105.72 $ 15.95 $89.77
500 $105.72 $ 15.92 $89.79
501 $105.72 $ 15.90 $89.82
502 $105.72 $ 15.88 $89.84
503 $105.72 $ 15.85 $89.87
504 $105.72 $ 15.83 $89.89
505 $105.72 $ 15.80 $89.92
506 $105.72 $ 15.78 $89.94
507 $105.72 $ 15.75 $89.97
508 $105.72 $ 15.73 $89.99
509 $105.72 $ 15.70 $90.02
510 $105.72 $ 15.68 $90.04
511 $105.72 $ 15.65 $90.07
512 $105.72 $ 15.63 $90.09
513 $105.72 $ 15.60 $90.11
514 $105.72 $ 15.58 $90.14
515 $105.72 $ 15.56 $90.16
516 $105.72 $ 15.53 $90.19
517 $105.72 $ 15.51 $90.21
518 $105.72 $ 15.48 $90.24
519 $105.72 $ 15.46 $90.26
520 $105.72 $ 15.43 $90.29
521 $105.72 $ 15.41 $90.31
522 $105.72 $ 15.38 $90.34
523 $105.72 $ 15.36 $90.36
524 $105.72 $ 15.33 $90.39
525 $105.72 $ 15.31 $90.41
526 $105.72 $ 15.28 $90.44
527 $105.72 $ 15.26 $90.46
528 $105.72 $ 15.23 $90.49
529 $105.72 $ 15.21 $90.51
530 $105.72 $ 15.18 $90.54
531 $105.72 $ 15.16 $90.56
532 $105.72 $ 15.13 $90.58
533 $105.72 $ 15.11 $90.61
534 $105.72 $ 15.08 $90.63
535 $105.72 $ 15.06 $90.66
536 $105.72 $ 15.04 $90.68
537 $105.72 $ 15.01 $90.71
538 $105.72 $ 14.99 $90.73
539 $105.72 $ 14.96 $90.76
540 $105.72 $ 14.94 $90.78
541 $105.72 $ 14.91 $90.81
542 $105.72 $ 14.89 $90.83
543 $105.72 $ 14.86 $90.86
544 $105.72 $ 14.84 $90.88
545 $105.72 $ 14.81 $90.91
546 $105.72 $ 14.79 $90.93
547 $105.72 $ 14.76 $90.96
548 $105.72 $ 14.74 $90.98
549 $105.72 $ 14.71 $91.01
550 $105.72 $ 14.69 $91.03
551 $105.72 $ 14.66 $91.06
552 $105.72 $ 14.64 $91.08
553 $105.72 $ 14.61 $91.11
554 $105.72 $ 14.59 $91.13
555 $105.72 $ 14.56 $91.16
556 $105.72 $ 14.54 $91.18
557 $105.72 $ 14.51 $91.21
558 $105.72 $ 14.49 $91.23
559 $105.72 $ 14.46 $91.26
560 $105.72 $ 14.44 $91.28
561 $105.72 $ 14.41 $91.31
562 $105.72 $ 14.39 $91.33
563 $105.72 $ 14.36 $91.36
564 $105.72 $ 14.34 $91.38
565 $105.72 $ 14.31 $91.41
566 $105.72 $ 14.29 $91.43
567 $105.72 $ 14.26 $91.46
568 $105.72 $ 14.24 $91.48
569 $105.72 $ 14.21 $91.51
570 $105.72 $ 14.19 $91.53
571 $105.72 $ 14.16 $91.56
572 $105.72 $ 14.14 $91.58
573 $105.72 $ 14.11 $91.61
574 $105.72 $ 14.09 $91.63
575 $105.72 $ 14.06 $91.66
576 $105.72 $ 14.04 $91.68
577 $105.72 $ 14.01 $91.71
578 $105.72 $ 13.99 $91.73
579 $105.72 $ 13.96 $91.76
580 $105.72 $ 13.94 $91.78
581 $105.72 $ 13.91 $91.81
582 $105.72 $ 13.89 $91.83
583 $105.72 $ 13.86 $91.86
584 $105.72 $ 13.83 $91.88
585 $105.72 $ 13.81 $91.91
586 $105.72 $ 13.78 $91.93
587 $105.72 $ 13.76 $91.96
588 $105.72 $ 13.73 $91.99
589 $105.72 $ 13.71 $92.01
590 $105.72 $ 13.68 $92.04
591 $105.72 $ 13.66 $92.06
592 $105.72 $ 13.63 $92.09
593 $105.72 $ 13.61 $92.11
594 $105.72 $ 13.58 $92.14
595 $105.72 $ 13.56 $92.16
596 $105.72 $ 13.53 $92.19
597 $105.72 $ 13.51 $92.21
598 $105.72 $ 13.48 $92.24
599 $105.72 $ 13.46 $92.26
600 $105.72 $ 13.43 $92.29
601 $105.72 $ 13.41 $92.31
602 $105.72 $ 13.38 $92.34
603 $105.72 $ 13.36 $92.36
604 $105.72 $ 13.33 $92.39
605 $105.72 $ 13.30 $92.41
606 $105.72 $ 13.28 $92.44
607 $105.72 $ 13.25 $92.47
608 $105.72 $ 13.23 $92.49
609 $105.72 $ 13.20 $92.52
610 $105.72 $ 13.18 $92.54
611 $105.72 $ 13.15 $92.57
612 $105.72 $ 13.13 $92.59
613 $105.72 $ 13.10 $92.62
614 $105.72 $ 13.08 $92.64
615 $105.72 $ 13.05 $92.67
616 $105.72 $ 13.03 $92.69
617 $105.72 $ 13.00 $92.72
618 $105.72 $ 12.97 $92.74
619 $105.72 $ 12.95 $92.77
620 $105.72 $ 12.92 $92.80
621 $105.72 $ 12.90 $92.82
622 $105.72 $ 12.87 $92.85
623 $105.72 $ 12.85 $92.87
624 $105.72 $ 12.82 $92.90
625 $105.72 $ 12.80 $92.92
626 $105.72 $ 12.77 $92.95
627 $105.72 $ 12.75 $92.97
628 $105.72 $ 12.72 $93.00
629 $105.72 $ 12.70 $93.02
630 $105.72 $ 12.67 $93.05
631 $105.72 $ 12.64 $93.08
632 $105.72 $ 12.62 $93.10
633 $105.72 $ 12.59 $93.13
634 $105.72 $ 12.57 $93.15
635 $105.72 $ 12.54 $93.18
636 $105.72 $ 12.52 $93.20
637 $105.72 $ 12.49 $93.23
638 $105.72 $ 12.47 $93.25
639 $105.72 $ 12.44 $93.28
640 $105.72 $ 12.41 $93.30
641 $105.72 $ 12.39 $93.33
642 $105.72 $ 12.36 $93.36
643 $105.72 $ 12.34 $93.38
644 $105.72 $ 12.31 $93.41
645 $105.72 $ 12.29 $93.43
646 $105.72 $ 12.26 $93.46
647 $105.72 $ 12.24 $93.48
648 $105.72 $ 12.21 $93.51
649 $105.72 $ 12.18 $93.54
650 $105.72 $ 12.16 $93.56
651 $105.72 $ 12.13 $93.59
652 $105.72 $ 12.11 $93.61
653 $105.72 $ 12.08 $93.64
654 $105.72 $ 12.06 $93.66
655 $105.72 $ 12.03 $93.69
656 $105.72 $ 12.00 $93.71
657 $105.72 $ 11.98 $93.74
658 $105.72 $ 11.95 $93.77
659 $105.72 $ 11.93 $93.79
660 $105.72 $ 11.90 $93.82
661 $105.72 $ 11.88 $93.84
662 $105.72 $ 11.85 $93.87
663 $105.72 $ 11.82 $93.89
664 $105.72 $ 11.80 $93.92
665 $105.72 $ 11.77 $93.95
666 $105.72 $ 11.75 $93.97
667 $105.72 $ 11.72 $94.00
668 $105.72 $ 11.70 $94.02
669 $105.72 $ 11.67 $94.05
670 $105.72 $ 11.64 $94.07
671 $105.72 $ 11.62 $94.10
672 $105.72 $ 11.59 $94.13
673 $105.72 $ 11.57 $94.15
674 $105.72 $ 11.54 $94.18
675 $105.72 $ 11.52 $94.20
676 $105.72 $ 11.49 $94.23
677 $105.72 $ 11.46 $94.26
678 $105.72 $ 11.44 $94.28
679 $105.72 $ 11.41 $94.31
680 $105.72 $ 11.39 $94.33
681 $105.72 $ 11.36 $94.36
682 $105.72 $ 11.33 $94.38
683 $105.72 $ 11.31 $94.41
684 $105.72 $ 11.28 $94.44
685 $105.72 $ 11.26 $94.46
686 $105.72 $ 11.23 $94.49
687 $105.72 $ 11.21 $94.51
688 $105.72 $ 11.18 $94.54
689 $105.72 $ 11.15 $94.57
690 $105.72 $ 11.13 $94.59
691 $105.72 $ 11.10 $94.62
692 $105.72 $ 11.08 $94.64
693 $105.72 $ 11.05 $94.67
694 $105.72 $ 11.02 $94.70
695 $105.72 $ 11.00 $94.72
696 $105.72 $ 10.97 $94.75
697 $105.72 $ 10.95 $94.77
698 $105.72 $ 10.92 $94.80
699 $105.72 $ 10.89 $94.83
700 $105.72 $ 10.87 $94.85
701 $105.72 $ 10.84 $94.88
702 $105.72 $ 10.82 $94.90
703 $105.72 $ 10.79 $94.93
704 $105.72 $ 10.76 $94.96
705 $105.72 $ 10.74 $94.98
706 $105.72 $ 10.71 $95.01
707 $105.72 $ 10.69 $95.03
708 $105.72 $ 10.66 $95.06
709 $105.72 $ 10.63 $95.09
710 $105.72 $ 10.61 $95.11
711 $105.72 $ 10.58 $95.14
712 $105.72 $ 10.56 $95.16
713 $105.72 $ 10.53 $95.19
714 $105.72 $ 10.50 $95.22
715 $105.72 $ 10.48 $95.24
716 $105.72 $ 10.45 $95.27
717 $105.72 $ 10.43 $95.29
718 $105.72 $ 10.40 $95.32
719 $105.72 $ 10.37 $95.35
720 $105.72 $ 10.35 $95.37
721 $105.72 $ 10.32 $95.40
722 $105.72 $ 10.29 $95.42
723 $105.72 $ 10.27 $95.45
724 $105.72 $ 10.24 $95.48
725 $105.72 $ 10.22 $95.50
726 $105.72 $ 10.19 $95.53
727 $105.72 $ 10.16 $95.56
728 $105.72 $ 10.14 $95.58
729 $105.72 $ 10.11 $95.61
730 $105.72 $ 10.09 $95.63
731 $105.72 $ 10.06 $95.66
732 $105.72 $ 10.03 $95.69
733 $105.72 $ 10.01 $95.71
734 $105.72 $ 9.98 $95.74
735 $105.72 $ 9.95 $95.76
736 $105.72 $ 9.93 $95.79
737 $105.72 $ 9.90 $95.82
738 $105.72 $ 9.88 $95.84
739 $105.72 $ 9.85 $95.87
740 $105.72 $ 9.82 $95.90
741 $105.72 $ 9.80 $95.92
742 $105.72 $ 9.77 $95.95
743 $105.72 $ 9.74 $95.97
744 $105.72 $ 9.72 $96.00
745 $105.72 $ 9.69 $96.03
746 $105.72 $ 9.67 $96.05
747 $105.72 $ 9.64 $96.08
748 $105.72 $ 9.61 $96.11
749 $105.72 $ 9.59 $96.13
750 $105.72 $ 9.56 $96.16
751 $105.72 $ 9.53 $96.19
752 $105.72 $ 9.51 $96.21
753 $105.72 $ 9.48 $96.24
754 $105.72 $ 9.45 $96.26
755 $105.72 $ 9.43 $96.29
756 $105.72 $ 9.40 $96.32
757 $105.72 $ 9.38 $96.34
758 $105.72 $ 9.35 $96.37
759 $105.72 $ 9.32 $96.40
760 $105.72 $ 9.30 $96.42
761 $105.72 $ 9.27 $96.45
762 $105.72 $ 9.24 $96.48
763 $105.72 $ 9.22 $96.50
764 $105.72 $ 9.19 $96.53
765 $105.72 $ 9.16 $96.56
766 $105.72 $ 9.14 $96.58
767 $105.72 $ 9.11 $96.61
768 $105.72 $ 9.08 $96.63
769 $105.72 $ 9.06 $96.66
770 $105.72 $ 9.03 $96.69
771 $105.72 $ 9.01 $96.71
772 $105.72 $ 8.98 $96.74
773 $105.72 $ 8.95 $96.77
774 $105.72 $ 8.93 $96.79
775 $105.72 $ 8.90 $96.82
776 $105.72 $ 8.87 $96.85
777 $105.72 $ 8.85 $96.87
778 $105.72 $ 8.82 $96.90
779 $105.72 $ 8.79 $96.93
780 $105.72 $ 8.77 $96.95
781 $105.72 $ 8.74 $96.98
782 $105.72 $ 8.71 $97.01
783 $105.72 $ 8.69 $97.03
784 $105.72 $ 8.66 $97.06
785 $105.72 $ 8.63 $97.09
786 $105.72 $ 8.61 $97.11
787 $105.72 $ 8.58 $97.14
788 $105.72 $ 8.55 $97.17
789 $105.72 $ 8.53 $97.19
790 $105.72 $ 8.50 $97.22
791 $105.72 $ 8.47 $97.25
792 $105.72 $ 8.45 $97.27
793 $105.72 $ 8.42 $97.30
794 $105.72 $ 8.39 $97.33
795 $105.72 $ 8.37 $97.35
796 $105.72 $ 8.34 $97.38
797 $105.72 $ 8.31 $97.41
798 $105.72 $ 8.29 $97.43
799 $105.72 $ 8.26 $97.46
800 $105.72 $ 8.23 $97.49
801 $105.72 $ 8.21 $97.51
802 $105.72 $ 8.18 $97.54
803 $105.72 $ 8.15 $97.57
804 $105.72 $ 8.13 $97.59
805 $105.72 $ 8.10 $97.62
806 $105.72 $ 8.07 $97.65
807 $105.72 $ 8.05 $97.67
808 $105.72 $ 8.02 $97.70
809 $105.72 $ 7.99 $97.73
810 $105.72 $ 7.97 $97.75
811 $105.72 $ 7.94 $97.78
812 $105.72 $ 7.91 $97.81
813 $105.72 $ 7.89 $97.83
814 $105.72 $ 7.86 $97.86
815 $105.72 $ 7.83 $97.89
816 $105.72 $ 7.81 $97.91
817 $105.72 $ 7.78 $97.94
818 $105.72 $ 7.75 $97.97
819 $105.72 $ 7.73 $97.99
820 $105.72 $ 7.70 $98.02
821 $105.72 $ 7.67 $98.05
822 $105.72 $ 7.64 $98.07
823 $105.72 $ 7.62 $98.10
824 $105.72 $ 7.59 $98.13
825 $105.72 $ 7.56 $98.16
826 $105.72 $ 7.54 $98.18
827 $105.72 $ 7.51 $98.21
828 $105.72 $ 7.48 $98.24
829 $105.72 $ 7.46 $98.26
830 $105.72 $ 7.43 $98.29
831 $105.72 $ 7.40 $98.32
832 $105.72 $ 7.38 $98.34
833 $105.72 $ 7.35 $98.37
834 $105.72 $ 7.32 $98.40
835 $105.72 $ 7.29 $98.42
836 $105.72 $ 7.27 $98.45
837 $105.72 $ 7.24 $98.48
838 $105.72 $ 7.21 $98.51
839 $105.72 $ 7.19 $98.53
840 $105.72 $ 7.16 $98.56
841 $105.72 $ 7.13 $98.59
842 $105.72 $ 7.11 $98.61
843 $105.72 $ 7.08 $98.64
844 $105.72 $ 7.05 $98.67
845 $105.72 $ 7.02 $98.69
846 $105.72 $ 7.00 $98.72
847 $105.72 $ 6.97 $98.75
848 $105.72 $ 6.94 $98.78
849 $105.72 $ 6.92 $98.80
850 $105.72 $ 6.89 $98.83
851 $105.72 $ 6.86 $98.86
852 $105.72 $ 6.84 $98.88
853 $105.72 $ 6.81 $98.91
854 $105.72 $ 6.78 $98.94
855 $105.72 $ 6.75 $98.97
856 $105.72 $ 6.73 $98.99
857 $105.72 $ 6.70 $99.02
858 $105.72 $ 6.67 $99.05
859 $105.72 $ 6.65 $99.07
860 $105.72 $ 6.62 $99.10
861 $105.72 $ 6.59 $99.13
862 $105.72 $ 6.56 $99.16
863 $105.72 $ 6.54 $99.18
864 $105.72 $ 6.51 $99.21
865 $105.72 $ 6.48 $99.24
866 $105.72 $ 6.46 $99.26
867 $105.72 $ 6.43 $99.29
868 $105.72 $ 6.40 $99.32
869 $105.72 $ 6.37 $99.35
870 $105.72 $ 6.35 $99.37
871 $105.72 $ 6.32 $99.40
872 $105.72 $ 6.29 $99.43
873 $105.72 $ 6.26 $99.45
874 $105.72 $ 6.24 $99.48
875 $105.72 $ 6.21 $99.51
876 $105.72 $ 6.18 $99.54
877 $105.72 $ 6.16 $99.56
878 $105.72 $ 6.13 $99.59
879 $105.72 $ 6.10 $99.62
880 $105.72 $ 6.07 $99.65
881 $105.72 $ 6.05 $99.67
882 $105.72 $ 6.02 $99.70
883 $105.72 $ 5.99 $99.73
884 $105.72 $ 5.96 $99.75
885 $105.72 $ 5.94 $99.78
886 $105.72 $ 5.91 $99.81
887 $105.72 $ 5.88 $99.84
888 $105.72 $ 5.86 $99.86
889 $105.72 $ 5.83 $99.89
890 $105.72 $ 5.80 $99.92
891 $105.72 $ 5.77 $99.95
892 $105.72 $ 5.75 $99.97
893 $105.72 $ 5.72 $100.00
894 $105.72 $ 5.69 $100.03
895 $105.72 $ 5.66 $100.06
896 $105.72 $ 5.64 $100.08
897 $105.72 $ 5.61 $100.11
898 $105.72 $ 5.58 $100.14
899 $105.72 $ 5.55 $100.17
900 $105.72 $ 5.53 $100.19
901 $105.72 $ 5.50 $100.22
902 $105.72 $ 5.47 $100.25
903 $105.72 $ 5.44 $100.28
904 $105.72 $ 5.42 $100.30
905 $105.72 $ 5.39 $100.33
906 $105.72 $ 5.36 $100.36
907 $105.72 $ 5.33 $100.38
908 $105.72 $ 5.31 $100.41
909 $105.72 $ 5.28 $100.44
910 $105.72 $ 5.25 $100.47
911 $105.72 $ 5.22 $100.50
912 $105.72 $ 5.20 $100.52
913 $105.72 $ 5.17 $100.55
914 $105.72 $ 5.14 $100.58
915 $105.72 $ 5.11 $100.61
916 $105.72 $ 5.09 $100.63
917 $105.72 $ 5.06 $100.66
918 $105.72 $ 5.03 $100.69
919 $105.72 $ 5.00 $100.72
920 $105.72 $ 4.98 $100.74
921 $105.72 $ 4.95 $100.77
922 $105.72 $ 4.92 $100.80
923 $105.72 $ 4.89 $100.83
924 $105.72 $ 4.87 $100.85
925 $105.72 $ 4.84 $100.88
926 $105.72 $ 4.81 $100.91
927 $105.72 $ 4.78 $100.94
928 $105.72 $ 4.76 $100.96
929 $105.72 $ 4.73 $100.99
930 $105.72 $ 4.70 $101.02
931 $105.72 $ 4.67 $101.05
932 $105.72 $ 4.64 $101.07
933 $105.72 $ 4.62 $101.10
934 $105.72 $ 4.59 $101.13
935 $105.72 $ 4.56 $101.16
936 $105.72 $ 4.53 $101.19
937 $105.72 $ 4.51 $101.21
938 $105.72 $ 4.48 $101.24
939 $105.72 $ 4.45 $101.27
940 $105.72 $ 4.42 $101.30
941 $105.72 $ 4.39 $101.32
942 $105.72 $ 4.37 $101.35
943 $105.72 $ 4.34 $101.38
944 $105.72 $ 4.31 $101.41
945 $105.72 $ 4.28 $101.44
946 $105.72 $ 4.26 $101.46
947 $105.72 $ 4.23 $101.49
948 $105.72 $ 4.20 $101.52
949 $105.72 $ 4.17 $101.55
950 $105.72 $ 4.14 $101.57
951 $105.72 $ 4.12 $101.60
952 $105.72 $ 4.09 $101.63
953 $105.72 $ 4.06 $101.66
954 $105.72 $ 4.03 $101.69
955 $105.72 $ 4.01 $101.71
956 $105.72 $ 3.98 $101.74
957 $105.72 $ 3.95 $101.77
958 $105.72 $ 3.92 $101.80
959 $105.72 $ 3.89 $101.83
960 $105.72 $ 3.87 $101.85
961 $105.72 $ 3.84 $101.88
962 $105.72 $ 3.81 $101.91
963 $105.72 $ 3.78 $101.94
964 $105.72 $ 3.75 $101.96
965 $105.72 $ 3.73 $101.99
966 $105.72 $ 3.70 $102.02
967 $105.72 $ 3.67 $102.05
968 $105.72 $ 3.64 $102.08
969 $105.72 $ 3.61 $102.10
970 $105.72 $ 3.59 $102.13
971 $105.72 $ 3.56 $102.16
972 $105.72 $ 3.53 $102.19
973 $105.72 $ 3.50 $102.22
974 $105.72 $ 3.47 $102.24
975 $105.72 $ 3.45 $102.27
976 $105.72 $ 3.42 $102.30
977 $105.72 $ 3.39 $102.33
978 $105.72 $ 3.36 $102.36
979 $105.72 $ 3.33 $102.38
980 $105.72 $ 3.31 $102.41
981 $105.72 $ 3.28 $102.44
982 $105.72 $ 3.25 $102.47
983 $105.72 $ 3.22 $102.50
984 $105.72 $ 3.19 $102.52
985 $105.72 $ 3.17 $102.55
986 $105.72 $ 3.14 $102.58
987 $105.72 $ 3.11 $102.61
988 $105.72 $ 3.08 $102.64
989 $105.72 $ 3.05 $102.67
990 $105.72 $ 3.03 $102.69
991 $105.72 $ 3.00 $102.72
992 $105.72 $ 2.97 $102.75
993 $105.72 $ 2.94 $102.78
994 $105.72 $ 2.91 $102.81
995 $105.72 $ 2.88 $102.83
996 $105.72 $ 2.86 $102.86
997 $105.72 $ 2.83 $102.89
998 $105.72 $ 2.80 $102.92
999 $105.72 $ 2.77 $102.95
1000 $105.72 $ 2.74 $102.98
1001 $105.72 $ 2.72 $103.00
1002 $105.72 $ 2.69 $103.03
1003 $105.72 $ 2.66 $103.06
1004 $105.72 $ 2.63 $103.09
1005 $105.72 $ 2.60 $103.12
1006 $105.72 $ 2.57 $103.14
1007 $105.72 $ 2.55 $103.17
1008 $105.72 $ 2.52 $103.20
1009 $105.72 $ 2.49 $103.23
1010 $105.72 $ 2.46 $103.26
1011 $105.72 $ 2.43 $103.29
1012 $105.72 $ 2.40 $103.31
1013 $105.72 $ 2.38 $103.34
1014 $105.72 $ 2.35 $103.37
1015 $105.72 $ 2.32 $103.40
1016 $105.72 $ 2.29 $103.43
1017 $105.72 $ 2.26 $103.46
1018 $105.72 $ 2.23 $103.48
1019 $105.72 $ 2.21 $103.51
1020 $105.72 $ 2.18 $103.54
1021 $105.72 $ 2.15 $103.57
1022 $105.72 $ 2.12 $103.60
1023 $105.72 $ 2.09 $103.63
1024 $105.72 $ 2.06 $103.65
1025 $105.72 $ 2.04 $103.68
1026 $105.72 $ 2.01 $103.71
1027 $105.72 $ 1.98 $103.74
1028 $105.72 $ 1.95 $103.77
1029 $105.72 $ 1.92 $103.80
1030 $105.72 $ 1.89 $103.82
1031 $105.72 $ 1.87 $103.85
1032 $105.72 $ 1.84 $103.88
1033 $105.72 $ 1.81 $103.91
1034 $105.72 $ 1.78 $103.94
1035 $105.72 $ 1.75 $103.97
1036 $105.72 $ 1.72 $104.00
1037 $105.72 $ 1.69 $104.02
1038 $105.72 $ 1.67 $104.05
1039 $105.72 $ 1.64 $104.08
1040 $105.72 $ 1.61 $104.11
1041 $105.72 $ 1.58 $104.14
1042 $105.72 $ 1.55 $104.17
1043 $105.72 $ 1.52 $104.20
1044 $105.72 $ 1.50 $104.22
1045 $105.72 $ 1.47 $104.25
1046 $105.72 $ 1.44 $104.28
1047 $105.72 $ 1.41 $104.31
1048 $105.72 $ 1.38 $104.34
1049 $105.72 $ 1.35 $104.37
1050 $105.72 $ 1.32 $104.40
1051 $105.72 $ 1.30 $104.42
1052 $105.72 $ 1.27 $104.45
1053 $105.72 $ 1.24 $104.48
1054 $105.72 $ 1.21 $104.51
1055 $105.72 $ 1.18 $104.54
1056 $105.72 $ 1.15 $104.57
1057 $105.72 $ 1.12 $104.60
1058 $105.72 $ 1.09 $104.62
1059 $105.72 $ 1.07 $104.65
1060 $105.72 $ 1.04 $104.68
1061 $105.72 $ 1.01 $104.71
1062 $105.72 $ 0.98 $104.74
1063 $105.72 $ 0.95 $104.77
1064 $105.72 $ 0.92 $104.80
1065 $105.72 $ 0.89 $104.83
1066 $105.72 $ 0.87 $104.85
1067 $105.72 $ 0.84 $104.88
1068 $105.72 $ 0.81 $104.91
1069 $105.72 $ 0.78 $104.94
1070 $105.72 $ 0.75 $104.97
1071 $105.72 $ 0.72 $105.00
1072 $105.72 $ 0.69 $105.03
1073 $105.72 $ 0.66 $105.06
1074 $105.72 $ 0.64 $105.08
1075 $105.72 $ 0.61 $105.11
1076 $105.72 $ 0.58 $105.14
1077 $105.72 $ 0.55 $105.17
1078 $105.72 $ 0.52 $105.20
1079 $105.72 $ 0.49 $105.23
1080 $105.72 $ 0.46 $105.26
1081 $105.72 $ 0.43 $105.29
1082 $105.72 $ 0.40 $105.31
1083 $105.72 $ 0.38 $105.34
1084 $105.72 $ 0.35 $105.37
1085 $105.72 $ 0.32 $105.40
1086 $105.72 $ 0.29 $105.43
1087 $105.72 $ 0.26 $105.46
1088 $105.72 $ 0.23 $105.49
1089 $105.72 $ 0.20 $105.52
1090 $105.72 $ 0.17 $105.55
1091 $105.72 $ 0.14 $105.57
1092 $105.72 $ 0.12 $105.60
1093 $105.72 $ 0.09 $105.63
1094 $105.72 $ 0.06 $105.66
1095 $105.72 $ 0.03 $105.69
 Balance
$ 100,000.00
$ 99,921.68
$ 99,843.33
$ 99,764.97
$ 99,686.58
$ 99,608.18
$ 99,529.75
$ 99,451.30
$ 99,372.82
$ 99,294.33
$ 99,215.81
$ 99,137.28
$ 99,058.72
$ 98,980.14
$ 98,901.54
$ 98,822.92
$ 98,744.27
$ 98,665.61
$ 98,586.92
$ 98,508.21
$ 98,429.48
$ 98,350.73
$ 98,271.95
$ 98,193.16
$ 98,114.34
$ 98,035.50
$ 97,956.64
$ 97,877.76
$ 97,798.86
$ 97,719.93
$ 97,640.99
$ 97,562.02
$ 97,483.03
$ 97,404.02
$ 97,324.98
$ 97,245.93
$ 97,166.85
$ 97,087.75
$ 97,008.63
$ 96,929.49
$ 96,850.33
$ 96,771.14
$ 96,691.94
$ 96,612.71
$ 96,533.46
$ 96,454.19
$ 96,374.89
$ 96,295.58
$ 96,216.24
$ 96,136.88
$ 96,057.50
$ 95,978.10
$ 95,898.68
$ 95,819.23
$ 95,739.76
$ 95,660.28
$ 95,580.77
$ 95,501.23
$ 95,421.68
$ 95,342.10
$ 95,262.50
$ 95,182.88
$ 95,103.24
$ 95,023.58
$ 94,943.89
$ 94,864.19
$ 94,784.46
$ 94,704.71
$ 94,624.93
$ 94,545.14
$ 94,465.32
$ 94,385.48
$ 94,305.62
$ 94,225.74
$ 94,145.84
$ 94,065.91
$ 93,985.97
$ 93,906.00
$ 93,826.00
$ 93,745.99
$ 93,665.96
$ 93,585.90
$ 93,505.82
$ 93,425.72
$ 93,345.59
$ 93,265.45
$ 93,185.28
$ 93,105.09
$ 93,024.88
$ 92,944.65
$ 92,864.40
$ 92,784.12
$ 92,703.82
$ 92,623.50
$ 92,543.16
$ 92,462.79
$ 92,382.40
$ 92,302.00
$ 92,221.56
$ 92,141.11
$ 92,060.64
$ 91,980.14
$ 91,899.62
$ 91,819.08
$ 91,738.52
$ 91,657.93
$ 91,577.32
$ 91,496.69
$ 91,416.04
$ 91,335.37
$ 91,254.67
$ 91,173.95
$ 91,093.21
$ 91,012.45
$ 90,931.67
$ 90,850.86
$ 90,770.03
$ 90,689.18
$ 90,608.31
$ 90,527.42
$ 90,446.50
$ 90,365.56
$ 90,284.60
$ 90,203.61
$ 90,122.61
$ 90,041.58
$ 89,960.53
$ 89,879.46
$ 89,798.36
$ 89,717.25
$ 89,636.11
$ 89,554.95
$ 89,473.76
$ 89,392.56
$ 89,311.33
$ 89,230.08
$ 89,148.80
$ 89,067.51
$ 88,986.19
$ 88,904.85
$ 88,823.49
$ 88,742.11
$ 88,660.70
$ 88,579.27
$ 88,497.82
$ 88,416.35
$ 88,334.85
$ 88,253.34
$ 88,171.80
$ 88,090.23
$ 88,008.65
$ 87,927.04
$ 87,845.41
$ 87,763.76
$ 87,682.09
$ 87,600.39
$ 87,518.67
$ 87,436.93
$ 87,355.16
$ 87,273.38
$ 87,191.57
$ 87,109.74
$ 87,027.88
$ 86,946.01
$ 86,864.11
$ 86,782.19
$ 86,700.25
$ 86,618.28
$ 86,536.29
$ 86,454.28
$ 86,372.25
$ 86,290.19
$ 86,208.12
$ 86,126.02
$ 86,043.89
$ 85,961.75
$ 85,879.58
$ 85,797.39
$ 85,715.18
$ 85,632.94
$ 85,550.68
$ 85,468.40
$ 85,386.10
$ 85,303.77
$ 85,221.42
$ 85,139.05
$ 85,056.66
$ 84,974.24
$ 84,891.81
$ 84,809.34
$ 84,726.86
$ 84,644.35
$ 84,561.83
$ 84,479.27
$ 84,396.70
$ 84,314.10
$ 84,231.48
$ 84,148.84
$ 84,066.18
$ 83,983.49
$ 83,900.78
$ 83,818.05
$ 83,735.29
$ 83,652.51
$ 83,569.71
$ 83,486.89
$ 83,404.04
$ 83,321.17
$ 83,238.28
$ 83,155.37
$ 83,072.43
$ 82,989.47
$ 82,906.49
$ 82,823.49
$ 82,740.46
$ 82,657.41
$ 82,574.33
$ 82,491.24
$ 82,408.12
$ 82,324.98
$ 82,241.81
$ 82,158.63
$ 82,075.42
$ 81,992.18
$ 81,908.93
$ 81,825.65
$ 81,742.35
$ 81,659.02
$ 81,575.68
$ 81,492.31
$ 81,408.92
$ 81,325.50
$ 81,242.06
$ 81,158.60
$ 81,075.12
$ 80,991.61
$ 80,908.08
$ 80,824.53
$ 80,740.95
$ 80,657.35
$ 80,573.73
$ 80,490.09
$ 80,406.42
$ 80,322.73
$ 80,239.02
$ 80,155.28
$ 80,071.52
$ 79,987.74
$ 79,903.94
$ 79,820.11
$ 79,736.26
$ 79,652.39
$ 79,568.49
$ 79,484.57
$ 79,400.63
$ 79,316.66
$ 79,232.67
$ 79,148.66
$ 79,064.63
$ 78,980.57
$ 78,896.49
$ 78,812.38
$ 78,728.26
$ 78,644.11
$ 78,559.94
$ 78,475.74
$ 78,391.52
$ 78,307.28
$ 78,223.01
$ 78,138.72
$ 78,054.41
$ 77,970.08
$ 77,885.72
$ 77,801.34
$ 77,716.94
$ 77,632.51
$ 77,548.06
$ 77,463.59
$ 77,379.09
$ 77,294.57
$ 77,210.03
$ 77,125.46
$ 77,040.87
$ 76,956.26
$ 76,871.63
$ 76,786.97
$ 76,702.29
$ 76,617.58
$ 76,532.85
$ 76,448.10
$ 76,363.33
$ 76,278.53
$ 76,193.71
$ 76,108.87
$ 76,024.00
$ 75,939.11
$ 75,854.19
$ 75,769.26
$ 75,684.30
$ 75,599.31
$ 75,514.31
$ 75,429.28
$ 75,344.22
$ 75,259.14
$ 75,174.04
$ 75,088.92
$ 75,003.77
$ 74,918.60
$ 74,833.41
$ 74,748.19
$ 74,662.95
$ 74,577.69
$ 74,492.40
$ 74,407.09
$ 74,321.76
$ 74,236.40
$ 74,151.02
$ 74,065.62
$ 73,980.19
$ 73,894.74
$ 73,809.27
$ 73,723.77
$ 73,638.25
$ 73,552.70
$ 73,467.14
$ 73,381.54
$ 73,295.93
$ 73,210.29
$ 73,124.63
$ 73,038.95
$ 72,953.24
$ 72,867.50
$ 72,781.75
$ 72,695.97
$ 72,610.17
$ 72,524.34
$ 72,438.49
$ 72,352.62
$ 72,266.72
$ 72,180.80
$ 72,094.86
$ 72,008.89
$ 71,922.90
$ 71,836.89
$ 71,750.85
$ 71,664.79
$ 71,578.70
$ 71,492.59
$ 71,406.46
$ 71,320.31
$ 71,234.13
$ 71,147.92
$ 71,061.70
$ 70,975.45
$ 70,889.17
$ 70,802.88
$ 70,716.56
$ 70,630.21
$ 70,543.84
$ 70,457.45
$ 70,371.03
$ 70,284.59
$ 70,198.13
$ 70,111.65
$ 70,025.13
$ 69,938.60
$ 69,852.04
$ 69,765.46
$ 69,678.86
$ 69,592.23
$ 69,505.57
$ 69,418.90
$ 69,332.20
$ 69,245.47
$ 69,158.73
$ 69,071.95
$ 68,985.16
$ 68,898.34
$ 68,811.50
$ 68,724.63
$ 68,637.74
$ 68,550.82
$ 68,463.89
$ 68,376.92
$ 68,289.94
$ 68,202.93
$ 68,115.90
$ 68,028.84
$ 67,941.76
$ 67,854.65
$ 67,767.52
$ 67,680.37
$ 67,593.19
$ 67,505.99
$ 67,418.77
$ 67,331.52
$ 67,244.25
$ 67,156.95
$ 67,069.63
$ 66,982.29
$ 66,894.92
$ 66,807.53
$ 66,720.11
$ 66,632.67
$ 66,545.21
$ 66,457.72
$ 66,370.21
$ 66,282.68
$ 66,195.12
$ 66,107.53
$ 66,019.93
$ 65,932.29
$ 65,844.64
$ 65,756.96
$ 65,669.26
$ 65,581.53
$ 65,493.78
$ 65,406.00
$ 65,318.20
$ 65,230.38
$ 65,142.53
$ 65,054.66
$ 64,966.76
$ 64,878.84
$ 64,790.90
$ 64,702.93
$ 64,614.94
$ 64,526.92
$ 64,438.88
$ 64,350.81
$ 64,262.73
$ 64,174.61
$ 64,086.48
$ 63,998.31
$ 63,910.13
$ 63,821.92
$ 63,733.69
$ 63,645.43
$ 63,557.15
$ 63,468.84
$ 63,380.51
$ 63,292.16
$ 63,203.78
$ 63,115.37
$ 63,026.95
$ 62,938.49
$ 62,850.02
$ 62,761.52
$ 62,672.99
$ 62,584.45
$ 62,495.87
$ 62,407.28
$ 62,318.66
$ 62,230.01
$ 62,141.34
$ 62,052.65
$ 61,963.93
$ 61,875.18
$ 61,786.42
$ 61,697.63
$ 61,608.81
$ 61,519.97
$ 61,431.11
$ 61,342.22
$ 61,253.30
$ 61,164.37
$ 61,075.40
$ 60,986.42
$ 60,897.41
$ 60,808.37
$ 60,719.31
$ 60,630.23
$ 60,541.12
$ 60,451.99
$ 60,362.83
$ 60,273.65
$ 60,184.45
$ 60,095.22
$ 60,005.96
$ 59,916.68
$ 59,827.38
$ 59,738.05
$ 59,648.70
$ 59,559.32
$ 59,469.92
$ 59,380.49
$ 59,291.04
$ 59,201.57
$ 59,112.07
$ 59,022.54
$ 58,932.99
$ 58,843.42
$ 58,753.82
$ 58,664.20
$ 58,574.55
$ 58,484.88
$ 58,395.19
$ 58,305.47
$ 58,215.72
$ 58,125.95
$ 58,036.16
$ 57,946.34
$ 57,856.50
$ 57,766.63
$ 57,676.74
$ 57,586.82
$ 57,496.88
$ 57,406.91
$ 57,316.92
$ 57,226.90
$ 57,136.86
$ 57,046.80
$ 56,956.71
$ 56,866.59
$ 56,776.45
$ 56,686.29
$ 56,596.10
$ 56,505.89
$ 56,415.65
$ 56,325.39
$ 56,235.10
$ 56,144.79
$ 56,054.45
$ 55,964.09
$ 55,873.70
$ 55,783.29
$ 55,692.85
$ 55,602.39
$ 55,511.91
$ 55,421.40
$ 55,330.86
$ 55,240.30
$ 55,149.72
$ 55,059.11
$ 54,968.47
$ 54,877.81
$ 54,787.13
$ 54,696.42
$ 54,605.69
$ 54,514.93
$ 54,424.14
$ 54,333.34
$ 54,242.50
$ 54,151.64
$ 54,060.76
$ 53,969.85
$ 53,878.92
$ 53,787.96
$ 53,696.98
$ 53,605.97
$ 53,514.94
$ 53,423.88
$ 53,332.80
$ 53,241.69
$ 53,150.56
$ 53,059.40
$ 52,968.22
$ 52,877.01
$ 52,785.78
$ 52,694.52
$ 52,603.24
$ 52,511.93
$ 52,420.60
$ 52,329.24
$ 52,237.86
$ 52,146.45
$ 52,055.02
$ 51,963.56
$ 51,872.08
$ 51,780.57
$ 51,689.04
$ 51,597.48
$ 51,505.90
$ 51,414.29
$ 51,322.66
$ 51,231.00
$ 51,139.32
$ 51,047.61
$ 50,955.88
$ 50,864.12
$ 50,772.33
$ 50,680.52
$ 50,588.69
$ 50,496.83
$ 50,404.95
$ 50,313.04
$ 50,221.10
$ 50,129.14
$ 50,037.16
$ 49,945.15
$ 49,853.11
$ 49,761.05
$ 49,668.96
$ 49,576.85
$ 49,484.72
$ 49,392.56
$ 49,300.37
$ 49,208.16
$ 49,115.92
$ 49,023.66
$ 48,931.37
$ 48,839.05
$ 48,746.72
$ 48,654.35
$ 48,561.96
$ 48,469.55
$ 48,377.11
$ 48,284.64
$ 48,192.15
$ 48,099.64
$ 48,007.10
$ 47,914.53
$ 47,821.94
$ 47,729.32
$ 47,636.68
$ 47,544.01
$ 47,451.32
$ 47,358.60
$ 47,265.85
$ 47,173.08
$ 47,080.29
$ 46,987.47
$ 46,894.62
$ 46,801.75
$ 46,708.85
$ 46,615.93
$ 46,522.98
$ 46,430.01
$ 46,337.01
$ 46,243.99
$ 46,150.94
$ 46,057.86
$ 45,964.76
$ 45,871.64
$ 45,778.49
$ 45,685.31
$ 45,592.11
$ 45,498.88
$ 45,405.62
$ 45,312.34
$ 45,219.04
$ 45,125.71
$ 45,032.35
$ 44,938.97
$ 44,845.57
$ 44,752.13
$ 44,658.67
$ 44,565.19
$ 44,471.68
$ 44,378.15
$ 44,284.58
$ 44,191.00
$ 44,097.39
$ 44,003.75
$ 43,910.09
$ 43,816.40
$ 43,722.68
$ 43,628.94
$ 43,535.18
$ 43,441.38
$ 43,347.57
$ 43,253.72
$ 43,159.85
$ 43,065.96
$ 42,972.04
$ 42,878.09
$ 42,784.12
$ 42,690.12
$ 42,596.10
$ 42,502.05
$ 42,407.98
$ 42,313.88
$ 42,219.75
$ 42,125.60
$ 42,031.42
$ 41,937.22
$ 41,842.99
$ 41,748.73
$ 41,654.45
$ 41,560.14
$ 41,465.81
$ 41,371.45
$ 41,277.07
$ 41,182.66
$ 41,088.22
$ 40,993.76
$ 40,899.27
$ 40,804.76
$ 40,710.22
$ 40,615.65
$ 40,521.06
$ 40,426.44
$ 40,331.80
$ 40,237.13
$ 40,142.43
$ 40,047.71
$ 39,952.97
$ 39,858.19
$ 39,763.39
$ 39,668.57
$ 39,573.72
$ 39,478.84
$ 39,383.94
$ 39,289.01
$ 39,194.05
$ 39,099.07
$ 39,004.07
$ 38,909.03
$ 38,813.97
$ 38,718.89
$ 38,623.78
$ 38,528.64
$ 38,433.48
$ 38,338.29
$ 38,243.07
$ 38,147.83
$ 38,052.56
$ 37,957.27
$ 37,861.95
$ 37,766.60
$ 37,671.23
$ 37,575.83
$ 37,480.41
$ 37,384.96
$ 37,289.48
$ 37,193.98
$ 37,098.45
$ 37,002.89
$ 36,907.31
$ 36,811.70
$ 36,716.07
$ 36,620.41
$ 36,524.72
$ 36,429.01
$ 36,333.27
$ 36,237.51
$ 36,141.72
$ 36,045.90
$ 35,950.06
$ 35,854.19
$ 35,758.29
$ 35,662.37
$ 35,566.42
$ 35,470.44
$ 35,374.44
$ 35,278.42
$ 35,182.36
$ 35,086.28
$ 34,990.18
$ 34,894.04
$ 34,797.88
$ 34,701.70
$ 34,605.49
$ 34,509.25
$ 34,412.98
$ 34,316.69
$ 34,220.38
$ 34,124.03
$ 34,027.66
$ 33,931.27
$ 33,834.84
$ 33,738.39
$ 33,641.92
$ 33,545.41
$ 33,448.89
$ 33,352.33
$ 33,255.75
$ 33,159.14
$ 33,062.51
$ 32,965.85
$ 32,869.16
$ 32,772.45
$ 32,675.70
$ 32,578.94
$ 32,482.14
$ 32,385.32
$ 32,288.48
$ 32,191.60
$ 32,094.71
$ 31,997.78
$ 31,900.83
$ 31,803.85
$ 31,706.84
$ 31,609.81
$ 31,512.75
$ 31,415.66
$ 31,318.55
$ 31,221.41
$ 31,124.25
$ 31,027.06
$ 30,929.84
$ 30,832.59
$ 30,735.32
$ 30,638.02
$ 30,540.70
$ 30,443.35
$ 30,345.97
$ 30,248.56
$ 30,151.13
$ 30,053.67
$ 29,956.19
$ 29,858.67
$ 29,761.14
$ 29,663.57
$ 29,565.98
$ 29,468.36
$ 29,370.71
$ 29,273.04
$ 29,175.34
$ 29,077.62
$ 28,979.86
$ 28,882.08
$ 28,784.28
$ 28,686.44
$ 28,588.58
$ 28,490.70
$ 28,392.78
$ 28,294.84
$ 28,196.88
$ 28,098.88
$ 28,000.86
$ 27,902.81
$ 27,804.74
$ 27,706.64
$ 27,608.51
$ 27,510.36
$ 27,412.17
$ 27,313.96
$ 27,215.73
$ 27,117.47
$ 27,019.18
$ 26,920.86
$ 26,822.52
$ 26,724.14
$ 26,625.75
$ 26,527.32
$ 26,428.87
$ 26,330.39
$ 26,231.89
$ 26,133.36
$ 26,034.80
$ 25,936.21
$ 25,837.60
$ 25,738.96
$ 25,640.29
$ 25,541.59
$ 25,442.87
$ 25,344.12
$ 25,245.35
$ 25,146.55
$ 25,047.72
$ 24,948.86
$ 24,849.98
$ 24,751.07
$ 24,652.13
$ 24,553.16
$ 24,454.17
$ 24,355.15
$ 24,256.10
$ 24,157.03
$ 24,057.93
$ 23,958.80
$ 23,859.65
$ 23,760.46
$ 23,661.25
$ 23,562.02
$ 23,462.75
$ 23,363.46
$ 23,264.14
$ 23,164.80
$ 23,065.43
$ 22,966.03
$ 22,866.60
$ 22,767.15
$ 22,667.66
$ 22,568.16
$ 22,468.62
$ 22,369.06
$ 22,269.47
$ 22,169.85
$ 22,070.20
$ 21,970.53
$ 21,870.83
$ 21,771.10
$ 21,671.35
$ 21,571.57
$ 21,471.76
$ 21,371.92
$ 21,272.06
$ 21,172.17
$ 21,072.25
$ 20,972.30
$ 20,872.33
$ 20,772.33
$ 20,672.30
$ 20,572.24
$ 20,472.16
$ 20,372.05
$ 20,271.91
$ 20,171.75
$ 20,071.55
$ 19,971.33
$ 19,871.09
$ 19,770.81
$ 19,670.51
$ 19,570.18
$ 19,469.82
$ 19,369.44
$ 19,269.02
$ 19,168.58
$ 19,068.12
$ 18,967.62
$ 18,867.10
$ 18,766.55
$ 18,665.97
$ 18,565.37
$ 18,464.73
$ 18,364.07
$ 18,263.39
$ 18,162.67
$ 18,061.93
$ 17,961.16
$ 17,860.36
$ 17,759.53
$ 17,658.68
$ 17,557.80
$ 17,456.89
$ 17,355.95
$ 17,254.99
$ 17,154.00
$ 17,052.98
$ 16,951.93
$ 16,850.85
$ 16,749.75
$ 16,648.62
$ 16,547.46
$ 16,446.28
$ 16,345.07
$ 16,243.82
$ 16,142.56
$ 16,041.26
$ 15,939.93
$ 15,838.58
$ 15,737.20
$ 15,635.80
$ 15,534.36
$ 15,432.90
$ 15,331.41
$ 15,229.89
$ 15,128.34
$ 15,026.77
$ 14,925.16
$ 14,823.53
$ 14,721.88
$ 14,620.19
$ 14,518.48
$ 14,416.74
$ 14,314.97
$ 14,213.17
$ 14,111.34
$ 14,009.49
$ 13,907.61
$ 13,805.70
$ 13,703.76
$ 13,601.80
$ 13,499.81
$ 13,397.79
$ 13,295.74
$ 13,193.66
$ 13,091.56
$ 12,989.42
$ 12,887.26
$ 12,785.08
$ 12,682.86
$ 12,580.61
$ 12,478.34
$ 12,376.04
$ 12,273.71
$ 12,171.36
$ 12,068.97
$ 11,966.56
$ 11,864.12
$ 11,761.65
$ 11,659.15
$ 11,556.63
$ 11,454.08
$ 11,351.49
$ 11,248.89
$ 11,146.25
$ 11,043.58
$ 10,940.89
$ 10,838.17
$ 10,735.42
$ 10,632.64
$ 10,529.83
$ 10,427.00
$ 10,324.14
$ 10,221.25
$ 10,118.33
$ 10,015.38
$ 9,912.41
$ 9,809.40
$ 9,706.37
$ 9,603.31
$ 9,500.22
$ 9,397.11
$ 9,293.96
$ 9,190.79
$ 9,087.59
$ 8,984.36
$ 8,881.10
$ 8,777.81
$ 8,674.50
$ 8,571.16
$ 8,467.79
$ 8,364.39
$ 8,260.96
$ 8,157.50
$ 8,054.02
$ 7,950.51
$ 7,846.97
$ 7,743.40
$ 7,639.80
$ 7,536.17
$ 7,432.52
$ 7,328.84
$ 7,225.12
$ 7,121.38
$ 7,017.62
$ 6,913.82
$ 6,810.00
$ 6,706.14
$ 6,602.26
$ 6,498.35
$ 6,394.41
$ 6,290.44
$ 6,186.45
$ 6,082.42
$ 5,978.37
$ 5,874.29
$ 5,770.18
$ 5,666.04
$ 5,561.87
$ 5,457.68
$ 5,353.46
$ 5,249.20
$ 5,144.92
$ 5,040.61
$ 4,936.27
$ 4,831.91
$ 4,727.51
$ 4,623.09
$ 4,518.64
$ 4,414.15
$ 4,309.64
$ 4,205.11
$ 4,100.54
$ 3,995.94
$ 3,891.32
$ 3,786.67
$ 3,681.98
$ 3,577.27
$ 3,472.53
$ 3,367.77
$ 3,262.97
$ 3,158.15
$ 3,053.29
$ 2,948.41
$ 2,843.50
$ 2,738.56
$ 2,633.59
$ 2,528.59
$ 2,423.56
$ 2,318.51
$ 2,213.43
$ 2,108.31
$ 2,003.17
$ 1,898.00
$ 1,792.80
$ 1,687.57
$ 1,582.32
$ 1,477.03
$ 1,371.72
$ 1,266.37
$ 1,161.00
$ 1,055.60
$ 950.17
$ 844.71
$ 739.22
$ 633.71
$ 528.16
$ 422.59
$ 316.98
$ 211.35
$ 105.69
$ 0.00000000
 Coast Jewelers, Inc.
2. Bond Amortization Schedule

Amount $100,000
Stated Rate 10%
Market Rate 11%
Term 5
Interest Payment $10,000
Proceeds $96,304.10
(Discount) / Premium -$3,695.90

Payment # Interest Payment Interest Expense

1 $10,000.00 $ 10,593.45
2 $10,000.00 $ 10,658.73
3 $10,000.00 $ 10,731.19
4 $10,000.00 $ 10,811.62
5 $10,000.00 $ 10,900.90
 (Discount)
Amortization Carrying Value
Premium
($3,695.90) $96,304.10
($593.45) ($3,102.45) $96,897.55
($658.73) ($2,443.71) $97,556.29
($731.19) ($1,712.52) $98,287.48
($811.62) ($900.90) $99,099.10
($900.90) $0.00 $100,000.00
 Coast Jewelers, Inc.
2. Bond Amortization Schedule annually

Amount $100,000
Stated Rate 10%
Market Rate 9%
Term 5
Interest Payment $10,000
Proceeds $103,889.65
(Discount) / Premium $3,889.65

Payment # Interest Payment Interest Expense

1 $10,000.00 $ 9,350.07
2 $10,000.00 $ 9,291.57
3 $10,000.00 $ 9,227.82
4 $10,000.00 $ 9,158.32
5 $10,000.00 $ 9,082.57
 (Discount)
Amortization Carrying Value
Premium
$3,889.65 $103,889.65
$649.93 $3,239.72 $103,239.72
$708.43 $2,531.29 $102,531.29
$772.18 $1,759.11 $101,759.11
$841.68 $917.43 $100,917.43
$917.43 $0.00 $100,000.00
Assumptions: Q1 Q2 Q3
Estimated product sales revenue $425,000 $400,000 $375,000
Estimated repair hours (in hours) 1,500 1,600 1,700
Estimated repair price / hour $50

Coast Jewelers 1st 2nd 3rd

1. Sales Budget Quarter Quarter Quarter
Estimated repair hours 1,500 1,600 1,700
Professional service revenue 75,000 80,000 85,000
Estimated product sales revenue 425,000 400,000 375,000
Total Revenues 500,000 480,000 460,000
 Q4
$450,000
1,800

4th
Quarter Year
1,800 6,600
90,000 330,000
450,000 1,650,000
540,000 1,980,000
Assumptions:
Current quarter collections 80%
Subsequent quarter collections 20%
End. Balance of A/R for last year $81,000

Coast Jewelers 1st 2nd 3rd

1. Sales Budget Quarter Quarter Quarter
Estimated repair hours 1,500 1,600 1,700
Professional service revenue 75,000 80,000 85,000
Estimated product sales revenue 425,000 400,000 375,000
Total Revenues 500,000 480,000 460,000

2. Cash Receipts Budget

Current quarter collections 400,000 384,000 368,000
Subsequent quarter collections 81,000 100,000 96,000
Total Cash receipts 481,000 484,000 464,000
 4th
Quarter Year
1,800 6,600
90,000 330,000
450,000 1,650,000
540,000 1,980,000

432,000 1,584,000
92,000 369,000
524,000 1,953,000
Assumptions:
*Cost of expected sales (product) 60%
*Requierd end. inventory of next 80%
quarter's sales
*Beg. Inventory of the year $125,000
*Expected product sales at Q1 $500,000
for next year

Coast Jewelers 1st 2nd 3rd

1. Sales Budget Quarter Quarter Quarter
Estimated repair hours 1,500 1,600 1,700
Professional service revenue 75,000 80,000 85,000
Estimated product sales revenue 425,000 400,000 375,000
Total Revenues 500,000 480,000 460,000

2. Cash Receipts Budget

Current quarter collections 400,000 384,000 368,000
Subsequent quarter collections 81,000 100,000 96,000
Total Cash receipts 481,000 484,000 464,000

3. Purchases Budget
Cost of expected sales 255,000 240,000 225,000
Add: required ending inventory 192,000 180,000 216,000
Less: beginning inventory 125,000 192,000 180,000
Purchases 322,000 228,000 261,000
 4th
Quarter Year
1,800 6,600
90,000 330,000
450,000 1,650,000
540,000 1,980,000

432,000 1,584,000
92,000 369,000
524,000 1,953,000

270,000 990,000
240,000 828,000
216,000 713,000
294,000 1,105,000
Assumptions:
Current quarter payments 75%
Sybsequent quarter payments 25%
Beginning balance of A/P $16,000

Coast Jewelers 1st 2nd 3rd

1. Sales Budget Quarter Quarter Quarter
Estimated repair hours 1,500 1,600 1,700
Professional service revenue 75,000 80,000 85,000
Estimated product sales revenue 425,000 400,000 375,000
Total Revenues 500,000 480,000 460,000

2. Cash Receipts Budget

Current quarter collections $400,000 $384,000 $368,000
Subsequent quarter collections $81,000 $100,000 $96,000
Total Cash receipts $481,000 $484,000 $464,000

3. Purchases Budget
Cost of expected sales $255,000 $240,000 $225,000
Add: required ending inventory $192,000 $180,000 $216,000
Less: beginning inventory $125,000 $192,000 $180,000
Purchases $322,000 $228,000 $261,000

4. Cash Payments Budget

Current quarter payments $241,500 $171,000 $195,750
Subsequent quarter payments $16,000 $80,500 $57,000
Cash payments for purchases $257,500 $251,500 $252,750
 4th
Quarter Year
1,800 6,600
90,000 330,000
450,000 1,650,000
540,000 1,980,000

$432,000 $1,584,000
$92,000 $369,000
$524,000 $1,953,000

$270,000 $990,000
$240,000 $828,000
$216,000 $713,000
$294,000 $1,105,000

$220,500 $828,750
$65,250 $218,750
$285,750 $1,047,500