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.
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: Yani has $12,000 for investment purposes. His bank has offered the following three choices: Choice…
A: The annual worth refers to an equivalent uniform distribution of the present value of any payment or…
Q: You may use your financial calculator or excel for calculations but be sure to show your work (i.e.…
A: Part 1: Future Value = $400,000 Rate = 2% Time period = 18 months - 12 months = 6 months Present…
Q: You have just received a bonus of $10,000 and are looking to deposit the money in a bank account for…
A: Value after a period can be calculated as: = Principal * (1 + Periodic Interest rate)^number of…
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: Yani has $12,000 for investment purposes. His bank has offered the following three choices. 1. A…
A: The internal rate of return is a capital budgeting technique for evaluating the profitability of…
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: 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: 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: If you are planning to apply for a personal loan and borrow PhP 50,000 and repay the principal and…
A: A study that proves that the 1value of money today is higher than the future value of money is term…
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: Answer the following questions and show all working using a financial calculator. Do NOT use excel:…
A: “Since you have asked multiple questions, we will solve the first question for you. If you want any…
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: 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: There is an investor stating they will pay out $84,000 at the end of 4 years. In order to invest…
A: Value at end of 4 years = 84000 N = 4 Deposit = 10,000 Annual Rate of Return using excel = ?
Q: Assume that you are nearing graduation and have applied for a job with a local bank. As part of the…
A:
Q: Your friend has offered to lend you some money. You decide to borrow $1,800 and agree to pay back…
A: The borrowing options can be compared by making a comparison between deferred repayment amount…
Q: Wells Fargo Bank lent a newly graduated engineer $1,000 at i = 5 % per year for 4 years to buy home…
A: Here, Lending Amount is $1,000 Interest Rate is 5% Time Period is 4 years Equivalent Net Cash Flow…
Q: You decide that you need $47,000 in 3 years to make a down payment on a house. You plan to make…
A: Since you have asked multiple questions, we will solve the first question for you. If you want any…
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: Suppose you are a relationship manager at an international bank. A customer who recently got…
A: To create the amortization table, first we will have to find the EMI. To find the EMI, we will use…
Q: If you are planning to apply for a personal loan and borrow PhP 30,000 and repay the principal and…
A: Loan Amount = Php 30,000 Time Period = 3 Years
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: Read and analyze each given scenario and provide what is asked. Show your complete solutions. 1. It…
A: Note: “Since you have asked multiple question, we will solve the first question for you. If you want…
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: 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: You are considering purchasing a lot adjacentto your laundry business to provide adequate parking…
A: Initial Loan amount=$ 75,000 Period % of initial amount to be repaid Repayment amount ($) 1 14…
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: 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 teacher is interested to open investments account at an interest rate of 12% compounded…
A: Perpetual annuity is one of type of annuity which lasts forever. The sequence of cashflows will…
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: 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: 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: Ishraf got his driving license one week back, and he wants to buy a new car for 12,50000Tk. He has…
A: Time value of money-It is based on the concept that money earned today is worth more than similar…
Q: How large must the deposit be? $ How much will be in the account immediately after you make the…
A: Present Value of Annuity: It is the present worth of the future annuity payments made at the end…
Q: A friend of yours is interested in purchasing a motor vehicle with at a cost of $3.5 million. The…
A: The spending required to generate and sell products and services, or to acquire assets, is referred…
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: 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: Yani has $12,000 for investment purposes. His bank has offered the following three choices. Solve,…
A: Investment = 12000 Monthly Payout = 100 Time Period = 5 years*12 = 50 months Lump Sum Amount at…
Q: Having P10,000 to invest and do not want to take any risk, it will put the funds in a savings…
A: Let us assume the interest rate (i) is 10% = 0.10 Principal Amount (P) = P10,000 Time, t = 3 years…
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…
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
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 1 images
- 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. Please make sure that you use every argument in EXCEL, Please leave nothing blank! ThanksWhat 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?
- You are shopping around to determine which bank account yields the highest return. You have three choices: 1st - Wesbanco offers an account compounded semi-annually at 3.99% 2nd - PNC offers an account compounded annually at 3.89% 3rd - United offers an account compounded daily at 3.82% You have $2,200 to invest for 2 years. Which account should you choose to have the best return on your investment?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.Your financial advisor from Bluerock recommends you to invest in one of the plan. You want to compare and verify which of the following is the best investment option. Investment Plan A: Deposit $125,000 at the beginning and obtain $175,318.97 after 5 years.Investment Plan B: Deposit $243,000 at the beginning and obtain $319,771.42 after 7 years.Investment Plan C: Deposit $314,000 at the beginning and obtain $530,496.39 after 9 years. 1. Compute interest rate for all 3 plans. Which investment plan provides you the highest rate? 2. Your advisor updated the investment plan information yesterday. While the interest rate did not change for all 3 plans, future values of each investment are 210382.76, 415702.85, 742694.95, respectively. What would be the investment period for each plan? 3. Your advisor thinks it would be a good investment if you make an investment portfolio using all 3 investment plans suggested. He recommends investing in all 3 plans at year 0 and reinvest the money to…
- 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?Mitchell Investments has offered you the following investment opportunity: $8,000 at the end of each year for the first 3 years, plus $7,000 at the end of each year from years 4 through 6, plus $3,000 at the end of each year from years 7 through 19. 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 12 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
- You plan to use a 15 year mortgage obtained from a local bank to purchase a house worth $124,000.00. The mortgage rate offered to you is 7.75%. You will make a down payment of 20% of the purchase price. a. Calculate your monthly payments on this mortgage. List in a spreadsheet the cash flow the bank expects to receive from you. Submit the spreadsheet with your answers. b. Calculate the amount of interest and principal for the 60th payment. Show your work. c. Calculate the amount of interest and principal to be paid on the 180th payment. Show your work. d. What is the amount of interest paid over the life of this mortgage?Suppose you are a relationship manager at an international bank. A customer who recently got admission at a prestigious Business School approached you for an education loan of Rs. 36,00,000. Your bank offers the education loan at 9.6 percent to be repaid in 10 years in EMIs. You are assigned the task of preparing the amortization schedule for the customer and answer the following. Prepare the amortization schedule for the first 5 EMIs. What will be interest paid for 93th EMI? What will be the loan balance after 93th EMI? What is the total interest paid for the loan?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…