Question

Required information A friend tells you she has saved for seven years and has a present sum of $26,000, which she earned at the rate of 11% per year, compounded annually. Using the EFFECT function, find the effective rate per year. The effective rate per year is L 7%

0 0
Add a comment Improve this question Transcribed image text
Answer #1

SEE THE IMAGE. ANY DOUBTS, FEEL FREE TO ASK. THUMBS UP PLEASE

Home nert Page Layout Formulas Data Review View dd-Ins Cut Σ AutoSum ー E ゴWrap Text ta copy. ▲· 逻锂函Merge & Center. $, % , 弼,8 Paste B I 프 . 灬 Conditional Format CeInsert Delete Format Formatting, as Table w styles. ▼ ㆆ ▼ Sort &Find & 2 ClearFe Select Edting Format Painter Clipboard Font Alignment Number Cells LP157 LM LN LO LP LQ LR LS LT LU LV LW LX LY 145 146 147 148 149 150 151 152 153 154 155 ANS 156 157 158 159 160 161 162 163 11 1 トーCALCULATOR ( LOAN OPTIONS | pv, fv, annuity i CAP STRU VALUE AS INTEREST IS COMPOUNDED ANNUALLY EFFECTIVE RATE = APR = 11% ONLY USING EFFECT FUCNTION RATE PER YEAR NO OF COMPOUNDING IN A YEAR 11% EXCEL FUNCTION EFFECTIVE RATE PER YEAR= 11% EFFECT(LP151,LP152) BOX ! DILUTION DOLLAR COST AVG MORTGAGE.. EXPO ( Sheet1 . Sheet2. Shell- rences: x261 福 130% 04:08 27-01-2019

Add a comment
Know the answer?
Add Answer to:
Required information A friend tells you she has saved for seven years and has a present...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • Required information A friend tells you she has saved for seven years and has a present...

    Required information A friend tells you she has saved for seven years and has a present sum of $26,000, which she earned at the rate of 11% per year, compounded annually Determine the equivalent amount she had to start with seven years ago. The equivalent amount she had to start with seven years ago is $

  • Required information A friend tells you she has saved for seven years and has a present...

    Required information A friend tells you she has saved for seven years and has a present sum of $30,000, which she earned at the rate of 9% per year, compounded weekly. Determine the equivalent amount she had to start with seven years ago. The equivalent amount she had to start with seven years ago is?

  • Problem 2-39 (book/static) What equal annual payment series is required to repay the following present amounts?...

    Problem 2-39 (book/static) What equal annual payment series is required to repay the following present amounts? (a) $15,000 in six years at 3.5% interest compounded annually (b) $7,500 in seven years at 7.5% interest compounded annually (c) $2,500 in five years at 5.25% interest compounded annually (d) $12,000 in 15 years at 6.25% interest compounded annually (a) The annual payment is S. (Round to the nearest dollar.) Enter your answer in the answer box and then click Check Answer equipment...

  • 7 years ago, you put $166,308 into an interest-earning account. Today it is worth $255,924. What...

    7 years ago, you put $166,308 into an interest-earning account. Today it is worth $255,924. What is the effective annual interest earned on the account? Round your answer to the nearest tenth of a percent. For example, if you get 15.1 %, write 0.151. Your friend just won the lottery. He has a choice of receiving $122,788 a year for the next 18 years or a lump sum today. The lottery uses a 8% discount rate. What would be the...

  • A friend tells you that she has conducted a survey to find the proportion of people...

    A friend tells you that she has conducted a survey to find the proportion of people in her university that utilize the campus internet cafe at least once a day. She has collected a sample and calculated a sample proportion of β = 0.34. She uses this value to calculate a confidence interval for the population proportion. Your friend says that she is not going to tell you the sample size or the level of confidence used in her construction,...

  • A friend tells you that she has conducted a survey to find the proportion of people...

    A friend tells you that she has conducted a survey to find the proportion of people in her university that utilize the campus internet cafe at least once a day. She has collected a sample and calculated a sample proportion of Ô = 0.54. She uses this value to calculate a confidence interval for the population proportion. Your friend says that she is not going to tell you the sample size or the level of confidence used in her construction,...

  • Problem 1.8 You deposit $5,000 in an account earning 5% interest compounded semi-annually for 2 years...

    Problem 1.8 You deposit $5,000 in an account earning 5% interest compounded semi-annually for 2 years and 7% interest compounded quarterly thereafter. What is the account value after 7 years? Problem 1.9 What is the equivalent effective annual (compound) interest rate in Problem 1.8? Problem 1.10 You deposit $5,000 in an account that earns 5% interest compounded annually in years 1 and 2, and thereafter a continuous rate δ(t) = 2/(t + 1) (t > 0). What is the value...

  • Problem 1.8 You deposit $5,000 in an account earning 5% interest compounded semi-annually for 2 years...

    Problem 1.8 You deposit $5,000 in an account earning 5% interest compounded semi-annually for 2 years and 7% interest compounded quarterly thereafter. What is the account value after 7 years? Problem 1.9 What is the equivalent effective annual (compound) interest rate in Problem 1.8? Problem 1.10 You deposit $5,000 in an account that earns 5% interest compounded annually in years 1 and 2, and thereafter a continuous rate δ(t) = 2/(t + 1) (t > 0). What is the value...

  • A friend in another city tells you that she has two organ pipes of different lengths,...

    A friend in another city tells you that she has two organ pipes of different lengths, one open at both ends, the other open at one end only. In addition, she has determined that the beat frequency caused by the second-lowest frequency of each pipe is equal to the beat frequency caused by the third-lowest frequency of each pipe. Her challenge to you is to calculate the length of the organ pipe that is open at both ends, given that...

  • 5. Based on the data if Kathy tells her grandchildren how she found bones in her...

    5. Based on the data if Kathy tells her grandchildren how she found bones in her yard the 1948 with only 99.89% of carbon- 14 inside of them. How old would the bones be in today? 6. Susan wants to sale her chemicals to the public health association. She states that her chemicals can reduce a radio-active substance from 12g initially down to 6g four years later. The president of the association asked her to prove her findings by telling...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT