pls do it on excel: To get an idea just how powerful compound interest is compared...

pls do it on excel:

To get an idea just how powerful compound interest is compared to simple interest, calculate the accumulated value of a $8000 deposit after 0.10, 0.50, 0.80, 1, 3, 6, 12, 20, 30, 40 and 50 years using rates of interest of 3%, 6% and 9%. For each interest rate, do SIX calculations: one assuming simple interest, and four assuming compound interest rates of i, i (2) , i (4) and i (12) , along with calculating the difference between the accumulated values under compound interest at i and under simple interest (just the i vs. simple interest, not the i (2), etc)

Expert Solution

milcah answered 10 months ago

EXCEL: (show equations pls)Fred Flintstone has just become the product manager for Yabba Dabba Doo, a...

EXCEL: (show equations pls)Fred Flintstone has just become the product manager for Yabba Dabba Doo, a consumer packaged product with a retail price of $2.00. Retail margins on the product are 33%, while wholesalers take a 12% margin. Yabba and its direct competitors sell a total of 40 million units annually, and Yabba has 24% market share of this total. Variable manufacturing costs for Yabba are $0.09 per unit. Fixed manufacturing costs are $1,800,000. The advertising budget for Yabba is...

(Compound interest with? non-annual periods?) You just received a bonus of ?$4,000.

(Compound interest with? non-annual periods?) You just received a bonus of ?$4,000. a. Calculate the future value of $1,000, given that it will be held in the bank for 8 years and earn an annual interest rate of 7 percent. b.Recalculate part (a) using a compounding period that is (1) semiannual and? (2) bimonthly. c.Recalculate parts (a) and (b) using an annual interest rate of 14 percent. d.Recalculate part (a) using a time horizon of 16 years at an annual...

Question: How does compound interest differ from simple interest?

DO NOT USE EXCEL PLS EXPLAIN EACH STEP Use AstroTurf Company's income statement below to answer...

DO NOT USE EXCEL PLS EXPLAIN EACH STEP Use AstroTurf Company's income statement below to answer the following two questions. a. Calculate AstroTurf’s EBITDA. b. Determine what level of sales would generate $3.3m in net income for the following year (Year 2), knowing that operating costs (excl. depreciation and amortization) will increase by 5%. The tax rate will not change. Year 1 Income Statement: Sales: $11,000,000 Operating costs (excl. depreciations & amortization): $4,500,000 Depreciation and amortization: $1,500,000 Interest: $700,000 Net...

Show work and explain how you got your answer, do not just post an excel spreadsheet...

Show work and explain how you got your answer, do not just post an excel spreadsheet with answers please. You are deciding between two mutually exclusive investment opportunities. Both require the same initial investment of $ 10.3 million. Investment A will generate $ 2.18 million per year (starting at the end of the first year) in perpetuity. Investment B will generate $ 1.51 million at the end of the first year, and its revenues will grow at 2.2 % per...

(Compound interest with non-annual periods ) You just received a bonus of 2,000. a. Calculate the...

(Compound interest with non-annual periods ) You just received a bonus of 2,000. a. Calculate the future value of 2,000 given that it will be held in the bank for 5 years and earn an annual interest rate of 4 percent .b. Recalculate part (a ) using a compounding period that is (1) semiannual and (2) bimonthly. c. Recalculate parts (a ) and (b )using an annual interest rate of 8 percent. d. Recalculate part (a ) using a time...

If $300 is invested at a 4% interest rate, how much compound interest will be earned...

If $300 is invested at a 4% interest rate, how much compound interest will be earned in 4 years? (Round to the nearest cent and do not enter the dollar sign) Exactly how many quarters will it take to double: $40 at 1% per quarter (Round to two decimal places)

how do create a relationship in excel

how do you make sure you obtain vectors with the gene of interest and not just...

how do you make sure you obtain vectors with the gene of interest and not just some random fragment of DNA that a restriction enzyme also cut out.(both the GOI and the random fragment have the same ends)

Use compound interest factors and formulas to solve (NO EXCEL TABLES). Show work neatly. Barron Chemical...

Use compound interest factors and formulas to solve (NO EXCEL TABLES). Show work neatly. Barron Chemical uses a thermoplastic polymer to enhance the appearance of certain RV panels. The initial cost of one process was $124,000 with annual costs of $47,000. Revenues are $77,000 in year 1, increasing by $1000 per year. A salvage value of $22,000 was realized when the process was discontinued after 8 years. What rate of return did the company make on the process? The rate...

Question