Off-The-Books Investment Firm, LLC, has offered you an investment it says will return to you $20,000 in 2 years. To get in, you'll need to make a $10,000 deposit to their receivables account and promise not to tell anyone about it. What is the annual return on investment? Answer in Excel.

Off-The-Books Investment Firm, LLC, has offered you an investment it says will return to you $20,000 in 2 years. To get in, you'll need to make a $10,000 deposit to their receivables account and promise not to tell anyone about it. What is the annual return on investment? Answer in Excel.

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: plete your last year in business school and then go through law school, you will need $10,000 per…

A: The present value of the money needed today is the required money to sustain the four year…

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: You want to quit your job and return to school for an MBA degree 3 years from now, and you plan to…

A: Annuity due : It is an annuity in which the periodic payment is paid at the beginning of each…

Q: You are a personal finance advisor at the BQ bank, and you receive in your office a young couple who…

A: Since we only answer up to 3 sub-parts, we’ll answer the first 3. Please resubmit the question and…

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: 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: 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: To complete your last year in business school and then go through law school, you will need $20,000…

A: Using excel PV function

Q: how long it will take for $1,000 to amount to $1,900 at a simple interest rate of 12 1/2 percent.…

A: In this we have to calculate future value using simple interest rates.

Q: You are saving to buy a $150,000 house. There are two competing banks in your area, both offering…

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: a) You are considering moving your money to a new bank offering a one-year GIC that pays an 8% APR…

A: Since you have asked multiple questions, we will solve the first question(part a.) for you. If you…

Q: A local bank is running the following advertisement in the newspaper: "For just $4,000 we will pay…

A: A perpetuity is a stream of cash flows wherein an equal amount is paid each period indefinitely.

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: As a small software developer firm, you have approached the AXZ Bank to obtain a term loan so that…

A: Given: Option 1: Loan amount = $100,000 Period = 5 years interest rate = 7.65%…

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: Suppose a certain hardware store has been in business for a few years and is doing well. The owner…

A: Investor invests at the end of every month which indicates ordinary annuity.

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: Suppose you invest $130 a month for 5 years into an account earning 8% compounded monthly. After 5…

A: A study that proves that the future worth of the money is lower than its current value due to…

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

Q: If you are planning a trip to other place after 3 years. And, if you intend to deposit savings of…

A: According to the time value principle, a sum of money may have different purchasing powers in…

Q: You are in desperate need of cash and turn to your uncle, who has offered to lend you some money.…

A: Loan options are analyzed based on the repayment amount where loan option with lower repayment…

Q: You have just completed your bachelor’s degree in business and applied for a job with a local bank.…

A: Hi, since you have posted multiple questions, I will answer only the first one as per our…

Q: Create a data table that calculates the Future Value of a 401(k) using the following information:…

A: Here we will use the FV function in excel. The syntax is: FV (rate, nper, pmt) where rate = interest…

Q: Suppose a certain hardware store has been in business for a few years and is doing well. The owner…

A: given, A= $4000 R=12% M=12 (monthly compounding)

Q: After graduation, you just got hired by an engineering company and you were planning to take a loan…

A: This question can be solved in light of annuity and present value. As the loan is repaid in equal…

Q: You borrow Php 1,000,000.00 for one year from a friend at an interest rate of 14 per month instead…

A: Borrowing = 1,000,000 Time Period (N) = 1 year Option 1. Bank Loan at 13% per year Option 2.…

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: If you are planning to apply for a personal loan and borrow PhP 30,000 and repay the principal and…

A: The question is based on the concept of loan repayment by the use of amortization of funds. The loan…

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: When payments are made at the end of each period, you will treat them as . You are planning to…

A: Introduction: An annuity is an arrangement to receive stable income after retirement, in which a…

Q: A credit card company wants your business. If you accept their offer and use their card, they will…

A: Deposit amount into a savings account= 1% of your monetary transactions Return= 5% per year Annual…

Q: Jake has approached you for a loan and based on your assessment, his cash-flow will accommodate a…

A: Loan is repaid in 5 years, on monthly basis. No. of repayments = 5yrs*12 = 60 Total Repayment = No.…

Q: Please teach me how to solve this, thanks! ABC would like to hire two loan collectors to speed up…

A: Given Information: Total annual benefits for each loan collectors = P150,000 Sales = P30,000,000…

Q: PLEASE, PERFORM THE EXERCISE IN EXCEL AND SHOW THE FORMULAS 3.- Andres Rosas wants to know how much…

A: Discounting is a technique through which present value (PV) of future cashflows is computed by using…

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: You are negotiating to make a 7-year loan of $37,500 to Breck Inc. To repay you, Breck will pay…

A: Using the concept of time value of money, net present value should be zero. Here, initial investment…

Q: (Hard) You are negotiating to make a 7-year loan of $25,000 to Breck Inc. To repay you, Breck will…

A: For solving this we have to calculate present value of payment today and than find out remaining…

Q: Starting next year, you will need Php120,000 annually for three years to complete your education.…

A: The amount of deposit can be find out by using the formula of present value of ordinary annuity.

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: Suppose a certain hardware store has been in business for a few years and is doing well. The owner…

A: Future value = Present value * ( 1 + Interest rate )TIme

Q: an investment has been made to an account at a simple interest rate of 12.122% and is expected to…

A: Here, Simple Interest rate (r) = 12.122% Total Interest = P 350,475 Time period (n) = 8 years and 5…

Q: You are a financial adviser, and your client wants to save $6,000 in order to make a downpayment for…

A: Future value (FV) = $6,000 Quarterly interest rate (r) = 0.009 (0.036 / 4) Quarterly period (n) = 8…

Q: Suppose a certain hardware store has been in business for a few years and is doing well. The owner…

A: Amount Saved Each month = 2000 Interest Rate = 12% interest Rate per month =12%/12 =1% =0.01 Future…

Q: Jefferson Bank lent a newly graduated engineer $1000 at i = 10% per year for 4 years to buy home…

A: Interest should be charged on the outstanding balance or unrecovered balance from the borrower…

Q: An accounting firm agrees to purchase a computer for $130,000 (cash on delivery) and the delivery…

A: In the given question, we are given with the future value and the delivery time. Hence, we need to…

Question

Expert Solution

This question has been solved!

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

This is a popular solution!

SEE SOLUTION Check out a sample Q&A here

Step 1

VIEW

Step 2

VIEW

Trending now

This is a popular solution!

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

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?
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?
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