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 ALL WORK IN EXCEL!!!!!!! SHOW CALCULATIONS / FORMULAS IN ANSWER!!!!!!!! You need to buy...
PLEASE SHOW ALL WORK IN EXCEL!!!!!!! SHOW CALCULATIONS / FORMULAS IN ANSWER!!!!!!!! You need to buy raw materials for your production process. You use 2,000 units of the raw material each year. The supplier quotes you a price of $9.50 per unit for an order size of 499 units or less, a price of $9 per unit for orders of 500 to 1499 units, and a price of $8.50 per unit for an order of 1,500 or more units. You...
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...
PLEASE SHOW ALL WORK IN EXCEL!!!!!!! SHOW CALCULATIONS / FORMULAS IN EXCEL!!!!!!!! Voters arrive at a...
PLEASE SHOW ALL WORK IN EXCEL!!!!!!! SHOW CALCULATIONS / FORMULAS IN EXCEL!!!!!!!! Voters arrive at a polling station at an average of 4 per minute (Poisson) where the service rate is 50 per hour (Poisson). a. What is the average number of voters in the system with 5 voter booths? (10 pts) b. What is the minimum number of voting booths needed to keep the average time in the system under three minutes? (10 pts) PLEASE SHOW ALL WORK IN...
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)...