There is an investor stating they will pay out $84,000 at the end of 4 years. In order to invest into the opportunity, you'll need to make a deposit of $10,000 to thier indicated bank account. What is the average annaul return rate. Use excel functions to indicate your steps

There is an investor stating they will pay out $84,000 at the end of 4 years. In order to invest into the opportunity, you'll need to make a deposit of $10,000 to thier indicated bank account. What is the average annaul return rate. Use excel functions to indicate your steps

EBK CONTEMPORARY FINANCIAL MANAGEMENT

14th Edition

ISBN:9781337514835

Author:MOYER

Publisher:MOYER

Chapter5: The Time Value Of Money

Section: Chapter Questions

Problem 22P

See similar textbooks

Related questions

Q: Off-The-Books Investment Firm, LLC, has offered you an investment it says will return to you $20,000…

A: Annual return on investment is 41.42%. Computation of annual return on investment: Excel spread…

Q: USE EXCEL TO SOLVE THIS PROBLEM AND SHOW THE FORMULA! Jake Mai deposited ¥300,000 in a bank account…

A: The present value is the value of the sum received at time 0 or the current period. It is the value…

Q: Solve each of the following questions using both pricing formulas and Excel. 1. If you wish to…

A: Present value refers to the current value of money which is required to put for a certain amount in…

Q: Joe opens an investment account with an initial deposit of $200. He then sets up monthly deposits of…

A: Future value = Present value * (1+r)^n Where r =rate of interest per period i.e. 5.25%/12 = 0.4375%…

Q: An account executive at Santander branch CETYS, receives a deposit from an important client-student,…

A: The future value of a deposit is the value that a deposit has after it has earned interest for a…

Q: A woman went to the Beneficial Loan Company and borrowed ST0,000. She must pay $323.53 At the end of…

A: Monthly interest rate can be calculated by excel formula PMT and by IRR formula with series of cash…

Q: Off-The-Books Investment Firm, LLC, has offered you an investment it says will return to you $20,000…

A: Calculate the annual rate of return as follows:

Q: A friend has $1,200 that he has saved from his part-time job. He will need his money, plus any…

A: The interest earned on the savings account is determined by multiplying the amount invested with the…

Q: You invest 1,000 today in a bank, which of the following one refers to the value of your investment…

A: Given: Amount = 1,000 Years = 5

Q: Hamad is saving to establish a small business. He deposits a fixed amount of money every month in a…

A: Annuity refers to series of equalized payments that are made either at start or end of specific…

Q: you are planning to start a business with an initial capital of P100,000. you decided to put up a…

A: Initial capital is P100,000 time period is 4 years To Find: Monthly deposit Annual interest rate

Q: Off-The-Books Investment Firm, LLC, has offered you an investment it says will return to you $20,000…

A: Calculate the annual rate of return as follows:MS-Excel --> Formulas --> Financials -->…

Q: Suppose you invested $50,000 into an account at a private bank that attracts annual interest of 20%…

A: The present value of a sum shows the amount of money available today. It is the discounted value of…

Q: Jamil invested $9,500 in an account he expects will earn 5% annually. Approximately how many years…

A: The number of years taken is calculated using the log function.

Q: One year ago, JK Mfg. deposited $12,000 in an investment account for the purpose of buying new…

A: Value of $12000 today deposited 4 years ago using financial calculator, N =4 I/Y = 5.5 PV = -12000…

Q: If you deposit $8,000 in a bank account that pays 4% interest annually, how much will be in your…

A: Deposit=$8000Interest rate=4%Number of years=5

Q: You are shopping around to determine which bank account yields the highest return. You have three…

A: Future Value = Present Value x (1 + r)^n

Q: A bank projects that the value of an account they hold will be $2, 000, 000 in 5 years. If the…

A: Future value (FV) = $2,000,000 Period (t) = 5 Years Interest rate (r) = 5% Mathematics constant (e)…

Q: You are shopping around to determine which bank account yields the highest return. You have three…

A: Amount = $2,200 Time Period = 2 Years

Q: How much is the amount of his investment after 3 years?

A: Future Worth: It is the future value of the present sum of money compounded at an interest rate.…

Q: Assume that you are nearing graduation and have applied for a job with a local bank. As part of the…

Q: When you were born, your parents opened an investment account in your name and deposited $500 into…

A: Solution-Given thatDeposite on time of birth=$500Annual rate of return=4.8%Value of account…

Q: Swee King makes a single deposit now in an account that pays 4% interest per year, and after 5…

A: The question is related to Interest effect of amounted deposits if interest rates increases.

Q: Suppose that $10,000 is deposited into a saving account that earns 6% interest, compounded annually.…

A: Present Value of deposit (PV)=$10,000 Rate of interest (i)=0.06 Future Value after 5 years=…

Q: Sandra Alcocer goes to her bank to ask for your help to get her out of her current predicament. She…

A: Here, Note: Here, two years to complete is considered as amount deposited after 2 years.

Q: Grand Opening Bank is offering a one-time investment opportunity for its new customers. A customer…

A: Bond is long-term debt raising instrument used by organizations and government to raise funds from…

Q: You want to be able to withdraw $5000 from an account at the end of each year for the next 12 years.…

A: Information Provided: Payment = $5000 Term = 12 years Interest rate = 5.5% compounded annually

Q: Compute for the total interest and amount to be received or paid at the end of the term for each…

A: Since you have asked multiple questions, we will solve the first question for you. If you want any…

Q: If PhP75,000 in a savings account earns PhP3,825interest, in a year and PhP75,000 worth of stock…

A: if php deposits 75000 in savings accounts that mean he getting 5.1 percentage but in stocks he…

Q: Answer the questions below and show all working from a financial calculator. Do not use excel: 1.…

A: The question is based on the concept of Annuity

Q: Problem 5: An account executive at Santander branch CETYS, receives a deposit from an important…

A: The future value is the accumulated value of a deposit along with interest. Annual deposits are the…

Q: You are planning on enrolling in the Master of Finance in 4 years time and will be required to pay…

A: We need to calculate present value of fees to be paid at enrolment. the $45,000 fees is the future…

Q: You are a CEO of a company and your company wants to invest $100,000 for the period of five years.…

A: The future value of an investment represents the initial value invested plus accumulated interest…

Q: You have decided to open a savings account and put $5000 in your local bank. If you had an interest…

A: Calculation:

Q: Which of the following investment alternatives would provide the greatest ending wealth for your…

A: As per our guidelines we are supposed to answer only one question (if there are multiple questions…

Q: A business owner plans to deposit their annual profits in an investment account earning a 9% annual…

A: Solution:- When an equal amount is deposited each period at beginning of each period, it is called…

Q: Assume that you are nearing graduation and have applied for a job with a local bank. As part of the…

A: “Since you have posted a question with multiple sub-parts, we will solve first three sub-parts for…

Q: Think about the cash flows associated with putting in the bank for five years, assuming you draw out…

A: Internal Rate of Return (IRR) of a project can be analysed as the return the investment earns. It…

Q: a business owner plans to deposit annual profits in an investment account earning a 9% annual…

A: Annual interest rate (r) = 9% Annual investment (P) = 22,000 Number of annual deposits (n) = 1+7 = 8

Q: You want to quit your job and return to school for an MBA degree 3 years from now, and you plan to…

A: In the given question $ 7,000 will invested 5% each year for 3 years beginning immediately. Future…

Q: You, as a University of Bahrain Business School student, plan to make a series of deposits in an…

A: Here, Deposit in First year is BHD 55,692 Deposit in Second year is BHD 55860 Deposit in third year…

Q: You are a financial adviser working with a client who wants to retire in eight years. The client has…

Q: You wish to invest ₱10,000 for a period of 5 years. Which of the following investments would be best…

A: Bank A - Simple Interest Future Value = (Principal + ( Principal * Interest rate * Number of…

Q: Create a system of linear equations to describe the behavior. Then, solve the system using Cramer's…

A: Answer Investment amount = $3,000 Interest rate = 4% and 8% After 1 year receive = $3,160

Q: You deposited PHP1,500 in a bank with an interest rate of 5% for 1 year. What is the future value of…

A: The future value is the amount that will be received at the end of a certain period. In simple…

Q: You invest $5,000 into a money market account that pays interest monthly (e.g., interest is…

A: The future value is the amount that will be received at the end of a certain period. In simple…

Question

Use excel functions to indicate your steps.

Expert Solution

This question has been solved!

Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.

SEE SOLUTION Check out a sample Q&A here

Inputs

VIEW

Answer

VIEW

Step by step

Solved in 2 steps with 1 images

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, finance and related others by exploring similar questions and additional content below.

Similar questions

You put $600 in the bank for 3 years at 15%. A. If Interest Is added at the end of the year, how much will you have in the bank after one year? Calculate the amount you will have in the bank at the end of year two and continue to calculate all the way to the end of the third year. B. Use the future value of $1 table In Appendix B and verify that your answer is correct.
You put $250 in the bank for S years at 12%. A. If interest is added at the end of the year, how much will you have in the bank after one year? Calculate the amount you will have in the bank at the end of year two and continue to calculate all the way to the end of the fifth year. B. Use the future value of $1 table in Appendix B and verity that your answer is correct.
Refer to the present value table information on the previous page. What amount should Brett have in his bank account today, before withdrawal, if he needs 2,000 each year for 4 years, with the first withdrawal to be made today and each subsequent withdrawal at 1-year intervals? (Brett is to have exactly a zero balance in his bank account after the fourth withdrawal.) a. 2,000 + (2,000 0.926) + (2,000 0. 857) + (2,000 0.794) b. 2,0000.7354 c. (2,000 0.926) + (2,000 0.857) + (2,000 0.794) + (2,000 0.735) d. 2,0000.9264
Use the tables in Appendix B to answer the following questions. A. If you would like to accumulate $4,200 over the next 6 years when the interest rate is 8%, how much do you need to deposit in the account? B. If you place $8,700 in a savings account, how much will you have at the end of 12 years with an interest rate of 8%? C. You invest $2,000 per year, at the end of the year, for 20 years at 10% interest. How much will you have at the end of 20 years? D. You win the lottery and can either receive $500,000 as a lump sum or $60,000 per year for 20 years. Assuming you can earn 3% interest, which do you recommend and why?
Use the tables in Appendix B to answer the following questions. A. If you would like to accumulate $2,500 over the next 4 years when the interest rate is 15%, how much do you need to deposit in the account? B. If you place $6,200 in a savings account, how much will you have at the end of 7 years with a 12% interest rate? C. You invest $8,000 per year for 10 years at 12% interest, how much will you have at the end of 10 years? D. You win the lottery and can either receive $750,000 as a lump sum or $50,000 per year for 20 years. Assuming you can earn 8% interest, which do you recommend and why?
Samuel Ames owes 20,000 to a friend. He wants to know how much he would have to pay if he paid the debt in 3 annual installments at the end of each year, which would include interest at 14%. Draw a time line for the problem. Indicate what table to use. Look up the table value and place it in a brief formula. Solve.