Question
using the data table process in excel, design and develop a compound interest data table using...
using the data table process in excel, design and develop a compound interest data table using the following information. A) The two (2) variables to be manipulated are: [1) the dollar amount invested (100-500 in increments of 100), 2) the number of years invested (2-10 in increments of 2)]; B) the constant, annual interest rate is to be 4.25%; C) Round the formula for computing compound interest to 2 decimals using the following compounding formula: the dollar amount invested multiplied by (1+interest rate) raised to the number of years; D) Label and format the table appropriately.
Homework Answers
Answer #1
FAF ( 4.25% , n years) indicates compound interest factor upto 2 decimals
FAF(4.25%, 2years ) =1+interest rate raised by
n= 
=
1.09 (rounded off to 2 decimals )
Not the answer you're looking for?
Similar Questions
1.)Calculate the annual compound interest rate if you invest $100 today and the value grows to...
1.)Calculate the annual compound interest rate if you invest
$100 today and the value grows to $120 two years from now. Two
decimals, whole percent (e.g. 5.23).
2.)How many years will it take $100 to grow to $133.82, if
annual compound interest is 6%? # no decimals
3.)Calculate the future value of $100 invested today for 3
years, where the nominal annual interest rate of 4% is compounded
quarterly? To two decimals.
4.)Your friend borrowed $5,000 three years ago and...
Using Interest Factor Table Ali invested $300,000 in a small project for an interest rate of...
Using Interest Factor Table
Ali invested $300,000 in a small project for an interest rate
of 8%. Four years later, he invested another $600,000 in the same
project but this time for an interest rate of 10%. What is the
total amount of money he is going to receive after 12 years of his
investment period?
Compressor that has the following costs are under consideration
for using in a new chemical plant. Using interest rate of 10% per
year. Calculate...
Below is a table for the present value of $1 at Compound interest. Year 6% 10%...
Below is a table for the present value of $1 at Compound
interest.
Year
6%
10%
12%
1
0.943
0.909
0.893
2
0.890
0.826
0.797
3
0.840
0.751
0.712
4
0.792
0.683
0.636
5
0.747
0.621
0.567
Below is a table for the present value of an annuity of $1 at
compound interest.
Year
6%
10%
12%
1
0.943
0.909
0.893
2
1.833
1.736
1.690
3
2.673
2.487
2.402
4
3.465
3.170
3.037
5
4.212
3.791
3.605
Using the tables...
Below is a table for the present value of $1 at Compound interest. Year 6% 10%...
Below is a table for the present value of $1 at Compound
interest.
Year
6%
10%
12%
1
0.943
0.909
0.893
2
0.890
0.826
0.797
3
0.840
0.751
0.712
4
0.792
0.683
0.636
5
0.747
0.621
0.567
Below is a table for the present value of an annuity of $1 at
compound interest.
Year
6%
10%
12%
1
0.943
0.909
0.893
2
1.833
1.736
1.690
3
2.673
2.487
2.402
4
3.465
3.170
3.037
5
4.212
3.791
3.605
Using the tables...
Below is a table for the present value of $1 at Compound interest. Year 6% 10%...
Below is a table for the present value of $1 at Compound
interest.
Year
6%
10%
12%
1
0.943
0.909
0.893
2
0.890
0.826
0.797
3
0.840
0.751
0.712
4
0.792
0.683
0.636
5
0.747
0.621
0.567
Below is a table for the present value of an annuity of $1 at
compound interest.
Year
6%
10%
12%
1
0.943
0.909
0.893
2
1.833
1.736
1.690
3
2.673
2.487
2.402
4
3.465
3.170
3.037
5
4.212
3.791
3.605
Using the tables...
Below is a table for the present value of $1 at compound interest. Year 6% 10%...
Below is a table for the present value of $1 at compound
interest.
Year
6%
10%
12%
1
0.943
0.909
0.893
2
0.890
0.826
0.797
3
0.840
0.751
0.712
4
0.792
0.683
0.636
5
0.747
0.621
0.567
Below is a table for the present value of an annuity of $1 at
compound interest.
Year
6%
10%
12%
1
0.943
0.909
0.893
2
1.833
1.736
1.690
3
2.673
2.487
2.402
4
3.465
3.170
3.037
5
4.212
3.791
3.605
Using the tables...
Determinants of Interest Rates Using the following DATA: R*= 4.25% I1 = 2% I2 = 4%...
Determinants of Interest Rates
Using the following DATA:
R*= 4.25%
I1 = 2%
I2 = 4%
I3 = 5%
I4→= 6.5%
MRP = .40% ( t - 1) (NOTE: This is a
PERCENTAGE, not a DECIMAL MRP!) t = number of years to
maturity
DRP = 7.2%
LP = 2.8%
CALCULATE:
4 year TREASURY BOND RATE
6 year CORPORATE BOND RATE
If $4,000 is invested now, $4,800 two years from now, and $5,200 fouryears from now at...
If $4,000 is invested now, $4,800 two years from now, and $5,200
fouryears from now at an interest rate of 8% compounded annually,
what will be the total amount in 10 years? The total amount in 10
years will bes[
NEED STEP BY STEP SOLUTION WITH DATA GIVEN , USED FORMULA ,
CALCULATION****DON'T USE TABLE FORMAT***** the
correct answer with a good solution will be provided with
100% rating THUMB UP and good comments and vice-versa if
incorrect
Amortization Schedule Project Program an Excel Spreadsheet to complete a Fixed Payment Loan Amortization Schedule based...
Amortization Schedule Project
Program an Excel Spreadsheet to complete a Fixed Payment Loan
Amortization Schedule based on the 5 inputs (see 1a below). This
spreadsheet should work for any scenario chosen using the 5 inputs
below that does not exceed 360 periods. You may start with any 5
inputs as these will be changed multiple times during grading. All
cells with number format should have no decimal places. All cells
with accounting format should have 2 decimal places. All cells...
2 year(s) ago, Mary invested 32,663 dollars. She has earned and will earn compound interest of...
2 year(s) ago, Mary invested 32,663 dollars. She has earned and
will earn compound interest of 9.95 percent per year. In 1 year(s)
from today, Albert can make an investment and earn simple interest
of 4.91 percent per year. If Albert wants to have as much in 6
years from today as Mary will have in 6 years from today, then how
much should Albert invest in 1 year(s) from today?
1 year(s) ago, Goran invested 56,351 dollars. He has...
ADVERTISEMENT
Need Online Homework Help?
Get Answers For Free
Most questions answered within 1 hours.
ADVERTISEMENT
Active Questions
asked 3 minutes ago
asked 33 minutes ago
asked 35 minutes ago
asked 37 minutes ago
asked 1 hour ago
asked 1 hour ago
asked 1 hour ago
asked 1 hour ago
asked 1 hour ago
asked 1 hour ago
asked 1 hour ago
asked 1 hour ago