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 1 year 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...

You are trying to get an idea of how predictable a firm future FCF’s will be...

You are trying to get an idea of how predictable a firm future FCF’s will be so you look at the last 10 years FCF’s and find that the average was 25 million and that the standard deviation was 18 million. You decide to find the range of outcomes 95% of the time. How should you interpret this? a. The range of outcomes are from 7 to 43 million b. The range of outcomes are from -11 to 61 million...

(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)

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...

how do create a relationship in excel

Question