FINANCIAL ACCOUNTING
FINANCIAL ACCOUNTING
10th Edition
ISBN: 9781259964947
Author: Libby
Publisher: MCG
Bartleby Related Questions Icon

Related questions

Question

Using Excel, create a table that shows the relationship between the interest
earned and the amount deposited, as shown. we will first create the dollar amount column and the interest row, as shown . Next we will type into cell B3 the formula = $A3*B$2. We can now use the Fill command to copy the formula in other cells, resulting in the table as shown. Note that the dollar sign before A3 means column A is to remain unchanged in the calculations when the formula is copied into other cells. Also note that the dollar sign before 2 means that row 2 is to remain unchanged in calculations when the Fill command is used.

The Relationship between the Interest
Earned and the Amount Deposited
TABLE 14.2
Interest Rate
Dollar Amount
0.06
0.07
0.075
0.08
1000
60
70
75
80
1250
75
87.5
93.75
100
1500
90
105
112.5
120
1750
105
122.5
131.25
140
2000
120
140
150
160
2250
135
157.5
168.75
180
2500
150
175
187.5
200
2750
165
192.5
206.25
220
3000
180
210
225
240
expand button
Transcribed Image Text:The Relationship between the Interest Earned and the Amount Deposited TABLE 14.2 Interest Rate Dollar Amount 0.06 0.07 0.075 0.08 1000 60 70 75 80 1250 75 87.5 93.75 100 1500 90 105 112.5 120 1750 105 122.5 131.25 140 2000 120 140 150 160 2250 135 157.5 168.75 180 2500 150 175 187.5 200 2750 165 192.5 206.25 220 3000 180 210 225 240
X v fr
=SA3"B$2
B3
A
D
E
F
1 Dollar Amount Interest Rate
0.06
0.07
0.075
0.08
3
1000
60
70
75
80
4
1250
75
87.5
93.75
100
1500
90
105
112.5
120
1750
105
122.5
131.25
140
7
2000
120
140
150
160
2250
135
157.5
168.75
180
2500
150
175
187.5
200
10
2750
165
192.5
206.25
220
11
3000
180
210
225
240
12
12
Sheet1
FIGURE 14.10
Excel spreadsheet for Example 14.2.
LL
expand button
Transcribed Image Text:X v fr =SA3"B$2 B3 A D E F 1 Dollar Amount Interest Rate 0.06 0.07 0.075 0.08 3 1000 60 70 75 80 4 1250 75 87.5 93.75 100 1500 90 105 112.5 120 1750 105 122.5 131.25 140 7 2000 120 140 150 160 2250 135 157.5 168.75 180 2500 150 175 187.5 200 10 2750 165 192.5 206.25 220 11 3000 180 210 225 240 12 12 Sheet1 FIGURE 14.10 Excel spreadsheet for Example 14.2. LL
Expert Solution
Check Mark
Knowledge Booster
Background pattern image
Accounting
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.
Similar questions
SEE MORE QUESTIONS
Recommended textbooks for you
Text book image
FINANCIAL ACCOUNTING
Accounting
ISBN:9781259964947
Author:Libby
Publisher:MCG
Text book image
Accounting
Accounting
ISBN:9781337272094
Author:WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:Cengage Learning,
Text book image
Accounting Information Systems
Accounting
ISBN:9781337619202
Author:Hall, James A.
Publisher:Cengage Learning,
Text book image
Horngren's Cost Accounting: A Managerial Emphasis...
Accounting
ISBN:9780134475585
Author:Srikant M. Datar, Madhav V. Rajan
Publisher:PEARSON
Text book image
Intermediate Accounting
Accounting
ISBN:9781259722660
Author:J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:McGraw-Hill Education
Text book image
Financial and Managerial Accounting
Accounting
ISBN:9781259726705
Author:John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:McGraw-Hill Education