Scribd
Upload
75 views1 page

Financial Data Analysis 2009-2014

This document appears to be an amortization table showing the quarterly amortization of a $1,470,000 bond over 10 years. It lists the date, beginning carrying value, interest expense, interest payable, amortization, and unamortized amount for each quarter through Q2 2016. The carrying value and unamortized amount decrease each quarter as the bond balance is amortized down, while the interest expense and interest payable amounts remain constant each quarter.

Uploaded by

cthunder_1
Copyright
© Attribution Non-Commercial (BY-NC)
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
75 views1 page

Financial Data Analysis 2009-2014

This document appears to be an amortization table showing the quarterly amortization of a $1,470,000 bond over 10 years. It lists the date, beginning carrying value, interest expense, interest payable, amortization, and unamortized amount for each quarter through Q2 2016. The carrying value and unamortized amount decrease each quarter as the bond balance is amortized down, while the interest expense and interest payable amounts remain constant each quarter.

Uploaded by

cthunder_1
Copyright
© Attribution Non-Commercial (BY-NC)
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

Execise

07.xls
Step1

A
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43

Date
1/1/09
3/31/09
6/30/09
9/30/09
12/31/09
3/31/10
6/30/10
9/30/10
12/31/10
3/31/11
6/30/11
9/30/11
12/31/11
3/31/12
6/30/12
9/30/12
12/31/12
3/31/13
6/30/13
9/30/13
12/31/13
3/31/14
6/30/14
9/30/14
12/31/14
3/31/15
6/30/15
9/30/15
12/31/15
3/31/16
6/30/16

C
D
E
BFSC Financial Inventement, Inc.
Bond Amor:za:on Table

Beginning Carrying Value Interest Expense Interest Payable Amor:za:on Unamor:zed Amount
30,000.00
1,470,000.00 23,250.00 22,500.00

750.00 29,250.00
1,470,750.00 23,250.00 22,500.00

750.00 28,500.00
1,471,500.00 23,250.00 22,500.00

750.00 27,750.00
1,472,250.00 23,250.00 22,500.00

750.00 27,000.00
1,473,000.00 23,250.00 22,500.00

750.00 26,250.00
1,473,750.00 23,250.00 22,500.00

750.00 25,500.00
1,474,500.00 23,250.00 22,500.00

750.00 24,750.00
1,475,250.00 23,250.00 22,500.00

750.00 24,000.00
1,476,000.00 23,250.00 22,500.00

750.00 23,250.00
1,476,750.00 23,250.00 22,500.00

750.00 22,500.00
1,477,500.00 23,250.00 22,500.00

750.00 21,750.00
1,478,250.00 23,250.00 22,500.00

750.00 21,000.00
1,479,000.00 23,250.00 22,500.00

750.00 20,250.00
1,479,750.00 23,250.00 22,500.00

750.00 19,500.00
1,480,500.00 23,250.00 22,500.00

750.00 18,750.00
1,481,250.00 23,250.00 22,500.00

750.00 18,000.00
1,482,000.00 23,250.00 22,500.00

750.00 17,250.00
1,482,750.00 23,250.00 22,500.00

750.00 16,500.00
1,483,500.00 23,250.00 22,500.00

750.00 15,750.00
1,484,250.00 23,250.00 22,500.00

750.00 15,000.00
1,485,000.00 23,250.00 22,500.00

750.00 14,250.00
1,485,750.00 23,250.00 22,500.00

750.00 13,500.00
1,486,500.00 23,250.00 22,500.00

750.00 12,750.00
1,487,250.00 23,250.00 22,500.00

750.00 12,000.00
1,488,000.00 23,250.00 22,500.00

750.00 11,250.00
1,488,750.00 23,250.00 22,500.00

750.00 10,500.00
1,489,500.00 23,250.00 22,500.00

750.00 9,750.00
1,490,250.00 23,250.00 22,500.00

750.00 9,000.00
1,491,000.00 23,250.00 22,500.00

750.00 8,250.00
1,491,750.00 23,250.00 22,500.00

750.00 7,500.00

[Page1]

Ending Carrying Value


1,470,000.00
1,470,750.00
1,471,500.00
1,472,250.00
1,473,000.00
1,473,750.00
1,474,500.00
1,475,250.00
1,476,000.00
1,476,750.00
1,477,500.00
1,478,250.00
1,479,000.00
1,479,750.00
1,480,500.00
1,481,250.00
1,482,000.00
1,482,750.00
1,483,500.00
1,484,250.00
1,485,000.00
1,485,750.00
1,486,500.00
1,487,250.00
1,488,000.00
1,488,750.00
1,489,500.00
1,490,250.00
1,491,000.00
1,491,750.00
1,492,500.00

You might also like