You receive a phone proposal to invest in a new business. The caller informs you that it will take a $70,000 down payment and the investment will earn $10,000 a year for the next 10 years.  He tells you that the investment will return 14 percent. a) If current interest rates are 8 percent, what is the present value of the investment? (Please provide in excel with explanation of the math) b) How did the caller get 14 percent?

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: : identify the values for the variables, in write an equation that can be used to find the amount of…

A: Future Value: It is the future worth of the present sum of the amount and is estimated by the…

Q: What will be the value of the investment in two years? Select one A. 5441 OMR b. None of these c.…

A: Information Provided: Pricipal = 5000 Term = 2 years Interest rate = 4.25% quarterly

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: If you accumulated P 70,700.00 from an investment of P 10,005.00 in 240 months, what is the rate of…

A: The formula for simple interest  is:  A = P*(1+rt) where A is the final amount P is the initial…

Q: st inherited some money, and a broker offers to sell you an annuity that pays $16,800 at the end of…

A: Value of annuity is present value of all year end money received over the period of life.

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: 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: A student invests $1000 in a bank account that pays an interest rate of 3.25% compounded monthly. a)…

A: given, A=$1000 r=3.25% m=12

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: A business promises to pay the investor of $2,000 today for a payment of $500 in one year's time,…

A: We need to use the concept of time value of money to solve the question. According to the concept of…

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: If you would like to accumulate $4,200 over the next 6 years when the interest rate is 8%, how much…

A: PV=FV/(1+i)^n (PV= present value FV= Future value i= discount rate  n= Number of period ) FV=…

Q: 3.- Carmen Arámbula received her paycheck on August 15 for $23,450.00, and decided to invest it…

A: Annualized return or interest rate shows the return that an investment will generate if the amount…

Q: Harley worked for many years to save enough money to start his own residential landscape design…

A: External rate of return It  is the rate of return on a project  on any  extra  cash from a project…

Q: What rate of return would be needed for that prediction to come true?

A: Rate of Return: It is the net profit or loss made by an investment over a certain period. It is…

Q: 6. A) If a company will pay $100,000 for a truck that will increase deliveries to be made, giving an…

A: Net present value is used as a tool to value a project or investment that adds to a business entity.…

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: 8.- A property worth $300,000.00 is sold with a down payment of $80,000.00 and the balance in…

A: For determining the total interest, monthly payment will be computed using PMT formula present of…

Q: Please use excel and explain how you solved it step by step thank you How much income should an…

A: The equivalent annual return is the periodic payment made towards the acquisition of an asset or…

Q: jacob has an opportunity to invest in a new retail development in his building. The initial…

A: The internal rate of return is one of the capital budgeting techniques used to know the…

Q: An investor has an opportunity to buy a commercial property and to sell it after 15 years. Rents…

A: Holding Period = 15 years Rent = 24000 Annual Increase in rent = 3%  Required Return = 12%   He…

Q: a) Let's say you invest $10,000 into each account. What is the final amount after 10 years? b) How…

A: Future Value: It represents the future worth of the present amount and is estimated by compounding…

Q: Direction/s: Answer the following problems. Show your complete solutions. 1. Find the compound…

A: In this we need to use future value formula to get answers.

Q: nvestment promises to pay into an account that pays you 6 percent annually, $150 per month for the…

A: because you have posted multiple questions, we will answer the first question only, for the…

Q: Assume you expect to earn 12% annually on your investment account. You already have $33,556.25 in…

A: The present value of a future cash flow is computed by dividing it by a discount factor that takes…

Q: You want to be able to withdraw $5000 from an account at the end of each year for the next 12 years.…

A: Information Provided: Payment = $5000 Term = 12 years Interest rate = 5.5% compounded annually

Q: Find the required value for each problem. Show the formula used and the counts for each problem. 1.…

A: Because you have psoted multiple questions, we will answer the first question only, for the…

Q: TAMIMA is planning to expand their firm by building a new branch in Dipatiukur. After seeking advice…

A: a) The question gives the following information:

Q: After hearing a knock at your front door, you are surprised to see the Prize Patrol from a large,…

A: The concept of time value of money (TVM) states that money accessible now is valued more than the…

Q: Please calculate the interest that has been accrued as of December 31, 2014 in the given scenario.…

A: Step 1 Accrued interest refers to the amount of interest that has been incurred or Outstand as of a…

Q: Your company needs $500,000 in two years' time for renovations and can earn 9% on investments. a)…

A: Discounting is a technique through which PV of future amount is computed by using discounting…

Q: Harley worked for many years to save enough money to start his own residential landscape design…

A: External rate of return is the rate at which the extra cash flow form the project is expected to…

Q: Which investment will help him reach his goal faster? Approximate the time that each investment will…

A: Time value of money (TVM) refers to the method used to measure the amount of money at different…

Q: 2. (a) If a developer plans to purchase a site for $150,000,000 on borrowed money at 6 per cent and…

A: Future Value :— Value of any cash flow in future date. It is calculated by using time value of…

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 have been offered $3,000 in 4 years for providing $2,000 today into a business venture with a…

A: Offer amount after 4 years = $ 3000 Amount today = $ 2000 Interest rate = 10%

Q: 1. An investor who recently returned from overseas has decided to invest in a venture which has been…

A: Since you have asked multiple questions, we will solve the first question for you. If you want any…

Q: How large of a repayment must an engineer make each year starting next year if she borrows $60,000…

A: loan amount = 60000 time period = 5 years interest rate = 8% here the payment will be repaid making…

Q: Solve each of the following questions using both pricing formulas and Excel.  3. You plan to retire…

A: The payment discussed here is a form of an annuity, wherein an equal amount is deposited every…

Q: You invest $5,000 into a money market account that pays interest monthly (e.g., interest is…

A: The future value is the amount that will be received at the end of a certain period. In simple…

Q: Coming Up Roses has grown into a very successful business and you have just received an offer from…

A: We will use the XNPV function. We will apply the XNPV formula where the inflows anad dates are…