Find the effective annual rate of interest (as a %, 2 decimal places) at which an...

Find the effective annual rate of interest (as a %, 2 decimal places) at which an amount of $2,000 today will accumulate to $4900 in 8 years.

(Solve using excel =RATE function; Answer in percentage rounded to two decimals without the % sign e.g. 1.8891 is 1.89)

Expert Solution

The question demands me to use the RATE function in excel to solve the question which I have done.

The key here is to take the Initial Investment which is Present Value to be negative as it is a cash outflow.

The Answer is 11.85% and how I have used the formula has also been showcased.

Starting Amount	($2,000)
Future Value	$4,900
Number of Periods	8
The effective annual rate of interest	11.85%

RATE Formula in Excel (nper, pmt, pv, [fv], [type], [guess])
nper - The total number of payment periods =	8
pmt - The payment made each period =	0
pv - The present value (Which needs to be negative as it as outflow)	$ (2,000)
fv - [optional] is the future value	$ 4,900
type - [optional] When payments are due. 0 = end of period. 1 = beginning of period. Default is 0	0
guess - [optional] Your guess on the rate. Default is 10%	0

jeff jeffy answered 1 year ago

Q1: Find the effective annual rate of interest (as a %, 2 decimal places) at which...

Q1: Find the effective annual rate of interest (as a %, 2 decimal places) at which an amount of $2,000 today will accumulate to $6000 in 8 years. (Solve using excel =RATE function; Answer in percentage rounded to two decimals without the % sign e.g. 1.8891 is 1.89) Q2: Which of the following is CORRECT? When discounting an amount to be received in one years' time at a rate that is quoted as 12% compounding quarterly, we can: Select one:...

effective annual interest rate

You have received a loan from a bank with a quoted rate of 18 percent compounded monthly. What is the Effective annual interest rate of the loan?

rounded off to 2 decimal places 1. FInd the ordinary interest on P500,000 at 5.5% invested...

rounded off to 2 decimal places 1. FInd the ordinary interest on P500,000 at 5.5% invested from April 1, 2017 to December 24, 2017? 2. How long will it take 200,000 to amount half a million pesos if the simple interest rate is 8.25% per annum? 3. Find the simple interest on 20,000 borrowed on May 1 and will be paid after 6months at 6.25% interest using exact time. 4. How much must be paid on the due date of...

Suppose the annual effective interest rate on an account is 13.2%. Find the equivalent nominal interest...

Suppose the annual effective interest rate on an account is 13.2%. Find the equivalent nominal interest rate compounded monthly, the effective monthly interest rate, the equivalent discount rate compounded monthly, and the effective monthly discount rate.

Find the value x for which: (Round your answers to 2 decimal places. You may find...

Find the value x for which: (Round your answers to 2 decimal places. You may find it useful to reference the appropriate table: chi-square table or F table) x a. P(F(7,13) ≥ x) = 0.100 2.23 2.23 Correct b. P(F(7,13) ≥ x) = 0.010 4.44 4.44 Correct c. P(F(7,13) < x) = 0.100 0.14 0.14 Incorrect d. P(F(7,13) < x) = 0.010 0.26 0.26 Incorrect

Problem 4-15 (Effective Rate of Interest) Effective Rate of Interest Find the interest rate (or rates...

Problem 4-15 (Effective Rate of Interest) Effective Rate of Interest Find the interest rate (or rates of return) in each of the following situations. Do not round intermediate calculations. Round your answers to the nearest whole number. You borrow $650 and promise to pay back $676 at the end of 1 year. __________% You lend $650 and receive a promise to be paid $676 at the end of 1 year. __________% You borrow $80,000 and promise to pay back $101,342...

Suppose the 1-year effective annual interest rate is 4.6% and the 2-year effective rate is 3.2%....

Suppose the 1-year effective annual interest rate is 4.6% and the 2-year effective rate is 3.2%. Compute the fixed rate in a 2-year amortizing interest rate swap based on $440,000 of notional principal in the first year and $240,000 in the second year. Please show steps a. 4.11% b. 3.91% c. 4.69% d. 3.22% e. 3.63%

1.a The annual interest rate is 8% with annual compounding. Please calculate effective annual rate, effective...

1.a The annual interest rate is 8% with annual compounding. Please calculate effective annual rate, effective semi-annual rate, effective quarterly rate, effective monthly rate, effective weekly rate (1 year = 52 weeks), effective daily rate (1 year = 365 days). 1.b The annual interest rate is 8% with monthly compounding. Please calculate effective monthly rate, effective annual rate, effective semi-annual rate, effective quarterly rate.

The stated annual interest rate is 2 percent, couponed continuously. What is the equivalent effective annual...

The stated annual interest rate is 2 percent, couponed continuously. What is the equivalent effective annual interest rate (to 6 places past the decimal point) associated with this stated rate? Solution Ear = (1+2%/1)^1=0.02 Ear = Exp(0.2)-1 =1.0202-1=2.02% The effective monthly rate is .0025 (i.e., a quarter of a percent per month). If you have a 30-year mortgage for $500,000 with monthly payments, what are your monthly payments? What is the present value (i.e., the value at...

A deposit of X is made into a fund which pays an annual effective interest rate...

A deposit of X is made into a fund which pays an annual effective interest rate of 8% for 5 years. At the same time, 2X is deposited into another fund which pays an annual effective rate of discount of d for 3 years. The amounts of interest earned over the 10 past years are equal for both funds. Calculate d.

Question