You have a sum on money in an account, and it grows from $1,230 to $ 2,244 over a period of 5 years. What average annual rate (%) will produce this result? I know how to use the rate formula in excel but I am confused about which of the values equate to the "Nper", "Pmt", "Pv", "Fv" and the "type". If someone could explain which is the nper versus the pmt etc.. I would appreciate it thanks!

You have a sum on money in an account, and it grows from $1,230 to $ 2,244 over a period of 5 years. What average annual rate (%) will produce this result? I know how to use the rate formula in excel but I am confused about which of the values equate to the "Nper", "Pmt", "Pv", "Fv" and the "type". If someone could explain which is the nper versus the pmt etc.. I would appreciate it thanks!

Essentials Of Investments

11th Edition

ISBN:9781260013924

Author:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Publisher:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Chapter1: Investments: Background And Issues

Section: Chapter Questions

Problem 1PS

See similar textbooks

Similar questions

For each of the following situations involving single amounts, solve for the unknown. Assume that interest is compounded annually. (/= interest rate, and n=number of years) Note: Use tables, Excel, or a financial calculator. Round your final answers to nearest whole dollar amount. (FV of $1. PV of $1. EVA of $1. PVA of $1. FVAD of $1 and PVAD of $1) 1. 2 3. 4. 5. Present Value Future Value 1 $ 36,600 $ 62,000 $ 28,644 $ 76,000 $ 11,758 $ 45,500 68.822 $ 155,000 13,796 $ $ 5% 7% 8% n 20 12 10
You plan to invest in an account which pays 3.5% compounded continuously. If the investment period is for 12 years, then A(P) = P e 0.035 · 12 = P e 0.42 gives the total balance of P dollars. Find a formula for A'(P). Find and interpret A'(4000). Compare the approximation to the actual change. a. b. С. a. A'(P) =| (Type an exact answer in terms of e.) b. A'(4000) = %3D (Round to the nearest cent as needed.) Interpret A'(4000) = 1.52 O A. The future value of a 13 year investment of $4001 will be $ more than the future value of a 13 year investment of $4000. O B. The future value of a 13 year investment of $4000 will be $ more than the future value of a 13 year investment of $4000. O C. The future value of 12 year investment of $4000 at 4.5% will be $ more than the future value of a 12 year investment of $4000 at 3.5%. O D. The future value of a 12 year investment of $4001 will be $ more than the future value of a 12 year investment of $4000. c. A(4001) – A(4000) = dollars per year.…
For each of the following situations involving annulties, solve for the unknown. Assume that interest is compounded annually and that all annulty amounts are received at the end of each period. (/= Interest rate, and n = number of years) Note: Use tables, Excel, or a financial calculator. Round your final answers to nearest whole dollar amount. (FV of $1, PV of $1, FVA of $1, PVA of $1, FVAD of $1 and PVAD of $1) 1. 2. 3. 4. 5. Present Value 248, 196 442,750 650,000 175,000 Annuity Amount $ 5,000 80,000 60,000 155,040 8% 11% 10% n = 5 4 10 4
Assume the returns from holding an asset are normally distributed. Also assume the average annual return for holding the asset a period of time was 15.3 percent and the standard deviation of this asset for the period was 33.2 percent. Use the NORMDIST function in Excel® to answer the following questions. a. What is the approximate probability that your money will double in value in a single year? (Do not round intermediate calculations and enter your answer as a percent rounded to 3 decimal places, e.g., 32.161.) b. What is the approximate probability that your money will triple in value in a single year? (Do not round intermediate calculations and enter your answer as a percent rounded to 8 decimal places, e.g., 32.16161616.)
The present value represents the amount of money you would have to deposit today in order to match what you would get from the income stream at the future date. The formula is Time = M = i Future value represents the total amount of money you would have if you deposit the income stream until a future date. The formula is To start our problem we need to identify the variables. Rate =r= i Income Stream S(t) = i Present Value = years % M 1. 0 S (t) et dt. Future Value = Present Value* erM dollars/year
For each of the following situations involving single amounts, solve for the unknown. Assume that Interest is compounded annually. (/- interest rate, and n-number of years) Note: Use tables, Excel, or a financial calculator. Round your final answers to nearest whole dollar amount. (EV of $1. PV of $1. EVA of $1. PVA of $1. EVAD of $1 and PVAD of $1) Present Value Future Value $ 36,018 S 72,000 S 43,718 S S 13,720 $ 4. S 51,746 S 5. 5 22,649 1234 86,000 48,000 180,000 8% 11% 9% n 9 10 11 15
Assume that at the beginning of the year, you purchase an investment for $7,200 that pays $100 annual income. Also assume the investment's value has decreased to $6,800 by the end of the year. (a) What is the rate of return for this investment? (Input the amount as a positive value. Enter your answer as a percent rounded to 2 decimal places.) Rate of return % (b) Is the rate of return a positive or negative number? Positive O Negative
Assume the returns from holding an asset are normally distributed. Also assume the average annual return for holding the asset a period of time was 16.3 percent and the standard deviation of this asset for the period was 33.5 percent. Use the NORMDIST function in Excel® to answer the following questions. a. What is the approximate probability that your money will double in value in a single year? (Do not round intermediate calculations and enter your answer as a percent rounded to 3 decimal places, e.g., 32.161.) b. What is the approximate probability that your money will triple in value in a single year? (Do not round intermediate calculations and enter your answer as a percent rounded to 8 decimal places, e.g., 32.16161616.) a. b. X Answer is complete but not entirely correct. Probability Probability 0.624 % 0.00000200 X %
Assume the returns from holding an asset are normally distributed. Also assume the average annual return for holding the asset a period of time was 16.3 percent and the standard deviation of this asset for the period was 33.5 percent. Use the NORMDIST function in Excel® to answer the following questions. a. What is the approximate probability that your money will double in value in a single year? (Do not round intermediate calculations and enter your answer as a percent rounded to 3 decimal places, e.g., 32.161.) b. What is the approximate probability that your money will triple in value in a single year? (Do not round intermediate calculations and enter your answer as a percent rounded to 8 decimal places, e.g., 32.16161616.) a. b. Probability Probability Answer is not complete. 0.624 % %
ok Assume the returns from holding an asset are normally distributed. Also assume the average annual return for holding the asset a period of time was 15.4 percent and the standard deviation of this asset for the period was 33.3 percent. Use the NORMDIST function in Excel to answer the following questions. a. What is the approximate probability that your money will double in value in a single year? Note: Do not round intermediate calculations and enter your answer as a percent rounded to 3 decimal places, e.g., 32.161. b. What is the approximate probability that your money will triple in value in a single year? Note: Do not round intermediate calculations and enter your answer as a percent rounded to 8 decimal places, e.g., 32.16161616. ences a. Probability b. Probability % %
If a cell in an Excel spreadsheet uses the following formula to determine the future value of an investment: =FV(0.0745/12, 12*30,-145) How much money is being invested each month? (Express your answer rounded correctly to the nearest cent!) %$4 What is the APR? (Express your answer correctly rounded to the nearest hundredth of a percent!) % If you haven't answered the question correctly in 3 attempts, you can get a hint.
Assume the returns from holding an asset are normally distributed. Also assume the average annual return for holding the asset a period of time was 17.1 percent and the standard deviation of this asset for the period was 35 percent. Use the NORMDIST function in Excel to answer the following questions. a. What is the approximate probability that your money will double in value in a single year? Note: Do not round intermediate calculations and enter your answer as a percent rounded to 3 decimal places, e.g., 32.161. b. What is the approximate probability that your money will triple in value in a single year? Note: Do not round intermediate calculations and enter your answer as a percent rounded to 8 decimal places, e.g., 32.16161616. a. Probability b. Probability % %

SEE MORE QUESTIONS

Recommended textbooks for you

Essentials Of Investments

Finance

ISBN:

9781260013924

Author:

Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Publisher:

Mcgraw-hill Education,

FUNDAMENTALS OF CORPORATE FINANCE

Finance

ISBN:

9781260013962

Author:

BREALEY

Publisher:

RENT MCG

Financial Management: Theory & Practice

Finance

ISBN:

9781337909730

Author:

Brigham

Publisher:

Cengage

Foundations Of Finance

Finance

ISBN:

9780134897264

Author:

KEOWN, Arthur J., Martin, John D., PETTY, J. William

Publisher:

Pearson,

Fundamentals of Financial Management (MindTap Cou…

Finance

ISBN:

9781337395250

Author:

Eugene F. Brigham, Joel F. Houston

Publisher:

Cengage Learning

Corporate Finance (The Mcgraw-hill/Irwin Series i…

Finance

ISBN:

9780077861759

Author:

Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Jeffrey Jaffe, Bradford D Jordan Professor

Publisher:

McGraw-Hill Education

Essentials Of Investments

Finance

ISBN:

9781260013924

Author:

Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Publisher:

Mcgraw-hill Education,

FUNDAMENTALS OF CORPORATE FINANCE

Finance

ISBN:

9781260013962

Author:

BREALEY

Publisher:

RENT MCG

Financial Management: Theory & Practice

Finance

ISBN:

9781337909730

Author:

Brigham

Publisher:

Cengage

Foundations Of Finance

Finance

ISBN:

9780134897264

Author:

KEOWN, Arthur J., Martin, John D., PETTY, J. William

Publisher:

Pearson,

Fundamentals of Financial Management (MindTap Cou…

Finance

ISBN:

9781337395250

Author:

Eugene F. Brigham, Joel F. Houston

Publisher:

Cengage Learning

Corporate Finance (The Mcgraw-hill/Irwin Series i…

Finance

ISBN:

9780077861759

Author:

Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Jeffrey Jaffe, Bradford D Jordan Professor

Publisher:

McGraw-Hill Education

SEE MORE TEXTBOOKS