Question

Please write formulas and not solve in excel, i need to hand write and show work...

Please write formulas and not solve in excel, i need to hand write and show work on the test.

1. You invested $100 in investment B for 2 years, and $100 in investment B for 1 year. Your rate of return for both years was exactly the same. If at the end of the 2 years the money grew to $215.25.
What was your compound return?

2. You invested $100 in investment A, Year 1 it grew by 10%, Year 2 by -5%, Year 3 by 7%, and Year 4 by 9%.
What was the compound return for this investment?

Homework Answers

Answer #1

Any query in this then comment below.. i will explain you..

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
Please show formulas in Excel or work - My formulas keep getting an Error and I...
Please show formulas in Excel or work - My formulas keep getting an Error and I don't know what I am doing wrong. You want to compare two separate retirement savings​ scenarios: (A) and​ (B). In scenario​ (A) you start​ immediately, contribute for a few​ years, but then stop contributing.​ However, you leave the accumulated savings to compound until retirement. In scenario​(B) you start later​ (after the end of savings in scenario​ A) and contribute all the way to retirement....
PLEASE SOLVE IN EXCEL SHOW ALL WORK! MUST USE FORMULAS!! Thank you!! You are saving for...
PLEASE SOLVE IN EXCEL SHOW ALL WORK! MUST USE FORMULAS!! Thank you!! You are saving for retirement in 40 years. You deposit $20,000 in a bank account today that pays 3.5% interest, compounded semiannually. You leave those funds on deposit until you retire. You also contribute $5,000 a year to a pension plan for 20 years and then you stop making contributions to the fund. You leave your money in the pension fund until you retire. The pension plan grows...
Please show the work in excel be sure to use appropriate formulas to solve each exercise...
Please show the work in excel be sure to use appropriate formulas to solve each exercise or problem. A1 If you deposit $12,000 in a bank account that pays 10% interest annually, how much will be in your account after 7 years? A2.    What is the present value of a security that will pay $10,000 in 20 years at an interest rate of 8%? A3.                 Find the future value of the following ordinary annuities: $600 per year for...
Show the work with formulas step by step please. - How many years will it take...
Show the work with formulas step by step please. - How many years will it take for $100,000 to grow to $500,000 if it is invested at an annual interest rate of 9.15%? Round to the nearest 0.01. - You are told that if you invest $5,000 per year for 35 years you will have accumulated $1,000,000. What is the annual rate of return on the latter investment? Round to the nearest 0.01%.
Show work through excel using formulas: but please actually show each step you use to do...
Show work through excel using formulas: but please actually show each step you use to do it on excel! 1. Assume you have taken out a balloon mortgage loan for $2,500,000 to finance the purchase of a commercial property. The loan has a term of 5 years, but amortizes over 25 years. Calculate the balloon payment at maturity (Year 5) if the interest rate on this loan is 4.5%. A. $5,637.99 B. $13, 895.82 C. $2,196,447.59 D. $2,495,479.19
Show the work with formulas. - How many years will it take for $100,000 to grow...
Show the work with formulas. - How many years will it take for $100,000 to grow to $500,000 if it is invested at an annual interest rate of 9.15%? Round to the nearest 0.01. - You are told that if you invest $5,000 per year for 35 years you will have accumulated $1,000,000. What is the annual rate of return on the latter investment? Round to the nearest 0.01%.
Must show all work and be in EXCEL format-formulas must be shown Frenchies, Inc. is considering...
Must show all work and be in EXCEL format-formulas must be shown Frenchies, Inc. is considering a major investment. The investment will have an initial cost of $630,000 and will be depreciated straight-line to a zero book value over the life of the project. The cash inflows generated by the project are estimated at $255,000 for the first three years and $25,000 for the following five years. What is the internal rate of return?
Please SHOW YOUR Calculations and formulas in Excel A shareholder’s group, in lodging a protest, claimed...
Please SHOW YOUR Calculations and formulas in Excel A shareholder’s group, in lodging a protest, claimed that the mean tenure for a chief executive officer (CEO) was at least 9 years. A survey of companies reported in the Wall Street Journal found a sample mean tenure of ?̅= 7.27 years for CEOs with a standard deviation of 6.38 years. 1) Formulate a hypothesis that can be used to challenge the validity of the claim made by the shareholder’s group. 2)...
Please show all calculations and formulas. If using Excel (or tables), please show data, formulas, etc....
Please show all calculations and formulas. If using Excel (or tables), please show data, formulas, etc. Practice question 14: Calculate the company’s w.a.c.c. using the info below. ***assume this is a corporate bond that pays 2x annually when calculating the PV of the bond Harvey LLC’s capital structure consists of a 25-year bond issued 5 years ago with a coupon of 6% and a par value of $14,000,000. The company’s main competitor just issued a similar bond paying 5%. The...
Write out the formulas, with the numbers filled in, to solve the following problems. You do...
Write out the formulas, with the numbers filled in, to solve the following problems. You do not have to do the actual calculations. Find the yield-to-maturity of a zero-coupon 10-year bond (par = $1,000) with a price of $622.44. (4 points). Find the present value of an investment that has three payments: $400 in two years, $500 in four years and $600 eight years from today. The relevant market interest rate is 4.20%. Find the future value of $100 invested...
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT
Active Questions
  • Assuming that the smallest measurable wavelength in an experiment is 0.410 fm (femtometers), what is the...
    asked 39 seconds ago
  • Sample Data:90,90,94,105,114,143,143,150,152,156,160,166,172,176,178,180,193,202,202,204,217,220,240,255,278,312,333,346,348,523 Probability that a single random person selected in your sample would weigh between 200...
    asked 40 seconds ago
  • he heights of American men are normally distributed with a mean of 71.3 inches and a...
    asked 5 minutes ago
  • An individual diagnosed with lung cancer has a 70% chance of surviving the first year after...
    asked 5 minutes ago
  • In patients with antibiotic susceptible strains of the bacterium causing tuberculosis, the symptoms of the condition...
    asked 8 minutes ago
  • how to enhance health & safety performance? Relate to relevant elements of safety & health management...
    asked 9 minutes ago
  • What is the density of Xe gas at 0.00 degrees Celsius, at a pressure of 563...
    asked 15 minutes ago
  • The grocery store we use does not mark prices on its goods. My wife went to...
    asked 15 minutes ago
  • A bond that had been issued by a subsidiary at a premium was acquired several years...
    asked 15 minutes ago
  • Gulf Shores Inn is comparing two separate capital structures. The first structure consists of 355,000 shares...
    asked 30 minutes ago
  • Comment on the following excerpt: You can criticise or add pointers. America in its ever changing...
    asked 30 minutes ago
  • A. Given that the relative wages of high skilled workers rose sharply in the 1970's and...
    asked 30 minutes ago