What is the excel function and formula for this question? 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 this investment?

What is the excel function and formula for this question? 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 this investment?

Entrepreneurial Finance

6th Edition

ISBN:9781337635653

Author:Leach

Publisher:Leach

Chapter1: Introduction To Finance For Entrepreneurs

Section: Chapter Questions

Problem 4EP

See similar textbooks

Similar questions

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 written and 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. Please make sure that you use every argument in EXCEL, Please leave nothing blank! Thanks
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.
Please provide the steps to solving this problem using a financial calculator: You just opened a brokerage account, depositing $3,500. You expect the account to earn an interest rate of 9.652%. You also plan on depositing $4,500 at the end of years 5 through 10. What will be the value of the account at the end of 20 years, assuming you earn your expected rate of return?
If an investor invests her money in a project with a 10% annual return. What is her nominal rate of return after two years. What is her effective rate of return after two years.1) Do the calculations manually then check them using an online financial calculator. You may also use financial software. 2) In your deliverable, you need to describe the tool you used
Mitchell Investments has offered you the following investment opportunity: $7,000 at the end of each year for the first 7 years, plus $6,000 at the end of each year from years 8 through 14, plus $3,000 at the end of each year from years 15 through 21. Use Table II and Table IV or a financial calculator to answer the questions. Round your answers to the nearest dollar. How much would you be willing to pay for this investment if you required a 8 percent rate of return?$ If the payments were received at the beginning of each year, what would you be willing to pay for this investment?$
Company investment says will pay out $64,000 at the end of 3 years. To invest, you'll need to deposit $9,900 to their bank account and keep the information private. What is the average annual return on this investment? Remember to use a TVM function. the answer is provided: 86.29% Please show how to get on EXCEL in one function
Think about the cash flows associated with putting in the bank for five years, assuming you draw out the interest each year and then close the account. Now think about a set of hypothetical cash flows associated with putting the same money in a business, operating for five years, and then selling out. Write an explanation of why the IRR on the business project is like the bank’s interest rate. How are the investments different?
You are planning to buy a CD for $1,352. You will receive $1,500 in 2 years. Use a financial calculator to find the interest rate you will receive on that investment, assuming annual compounding. I can do this manually, but can't seem to figure out how to correctly input this into a financial calculator using N, I/Y, PV, PMT, and FV.
Please indicate what you entered into your calculator to solve these problems. 1. You graduated with $28,000 in school loans. You will make annual payments of $4,000 at the beginning of each year for the next 10 years. What annual rate of interest are you being charged on your school loans? 2. You bought equipment for $23,000 and agreed to make monthly payments at the end of each quarter for 5 years. Assuming you are being charged 9% interest compounded QUARTERLY, how much will your QUARTERLY payments be? 3. You currently have $750,000 in your building fund. If you start depositing an additional $20,000 per year into this account at the beginning of each year, how much will be in the account after 6 years assuming 5.5% interest compounded annually? 4. You want to start saving for a new car and have decided to put S$90 per month at the beginning of each month into an account which earns 6% compounded monthly. You would like to be able to buy a car for $25,000. (a) How many deposits will…
Assume that you have $10,000,000 in your bank account. You wish to withdraw $400,000 per year, at the end of each year, for the next 5 years, after which you wish to have $11,000,000 in the bank. What is the balance in your account after the 2nd year (after the withdrawal)? Hint: you will need first to solve for rate in Excel given all other parameters. Watch signs. Select one: a. $10,366,644 b. $10,600,000 c. $9,600,000 d. $10,488,912