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.
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…
A:
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…
A:
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…
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. 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.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.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?
- 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 functionMitchell 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?$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…
- 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?You are shopping around to determine which bank account yields the highest return. You have three choices: 1st - Wesbanco offers an account compounded annually at 7.2% 2nd - PNC offers an account compounded semi-annually at 6.29% 3rd - United offers an account compounded daily at 6.5% You have $2,000 to invest for 1 years. Which account should you choose to have the largest account balance in 1 years? O Wesbanco United PNC Wesbanco will produce $ Number in 1 years. PNC will produce $ Number in 1 years. United will produce $ Number in 1 years. (round dollar values to the nearest cent (two decimal places))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?