Business

FinanceQ&A LibraryOff-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! ThanksQuestion

Asked Feb 5, 2020

2 views

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

Step 1

Annual return on investment is **41.42%.**

**Computation of annual return on investment:**

**Excel spread sheet:**

...

Tagged in

Find answers to questions asked by student like you

Show more Q&A

Q: Required Return If the risk-free rate is 10.2 percent and the market risk premium is 4.4 percent, wh...

A: Given that:Risk free rate is 10.2%Market Risk Premium is 4.4%

Q: EXCEL] Income statement: Nimitz Rental Company provided the following information to its auditors. F...

A: The computation of net income is as follows: Hence, the net income is $137262.84.

Q: Coldstream Corp. is comparing two different capital structures. Plan I would result in 10,000 shares...

A: Hi, there is no numerical information provided for All-Equity firm. Hence we will calculate the EPS ...

Q: Your best taxable investment opportunity has an EAR of 4%. You best tax-free investment opportunity ...

A: Calculation of After-tax Interest Rate:The aftertax interest rate is 2.80%.

Q: Suppose you see a car with an advertised price of $14,200 at $390.83 per month for 4 years. What is ...

A: The price of the car is $14,200.Monthly payment is $390.83.Total number of payments would be 4 × 12 ...

Q: If $18,000 is invested at 2.5% for 20 years, find the future value if the interest is compounded the...

A: Compute the future value:The future value if the interest is compounded continuously is $29,676.98 a...

Q: A factory costs $320,000. You forecast that it will produce cash inflows if $100,000 in a year, $160...

A: The value of factory can be determined with the help of below expression:

Q: You have been asked by the president of your company to evaluate the proposed acquisition of a new s...

A: With the given information, we need to determine the operating cash flows for the project during yea...

Q: The Drogon Co. just issued a dividend of $2.96 per share on its common stock. The company is expecte...

A: Calculation of cost of equity:Hence, the cost of equity is 12.97%.