How do you build a volatility model on excel from scratch

Assignment Help Financial Management

Reference no: EM131913796

1. When her great niece Alexis is born, Great Aunt Florence deposits $25,000 in a 529 college savings account that grows annually at a rate of 6%. How much money will be in Alexa’s 529 account when she is ready to go to college 18 years from now?

2. How much interest did Great Aunt Florence’s $25,000 deposit earn over the 18 years it was invested?

3. Re-compute Question #1 assuming a 6% annual rate compounded monthly for 18 years.

4. How do you build a volatility model on excel from scratch?

Reference no: EM131913796

Questions Cloud

Profit-maximizing quantity : Also, solve for a single, profit-maximizing quantity in terms of p.

Dividend paid by company to barry will he get to keep : Suppose the Gingridge pays a dividend per share of $3.00. How much of the total dividend paid by the company to Barry will he get to keep?

Explain the estimating and recording warranty expense : Explain to Tom: The rational for accounting for contingent liabilities, and The procedure for estimating and recording warranty expense

Derive the firm average cost and average variable : Referring again to Acme Laundry (its cost function is still C(q) = 10 + 9q +0.75q2), derive the firm's average cost and average variable cost curves.

How do you build a volatility model on excel from scratch : Re-compute assuming a 6% annual rate compounded monthly for 18 years. How do you build a volatility model on excel from scratch?

Write down the inverse demand function : The demand function for tickets at a stadium is given by D(p) = 200, 000 - 10, 000p. The stadium can hold 100,000 spectators.

Explain different methods used to calculate depreciation : Your friend Tom Smith has decided to expand Smith Sales Company. Explain the different methods that can be used to calculate depreciation

Provide a definition of consumer indebtedness : Provide a definition of consumer indebtedness that is consistent with consumer indebtedness indicators

Market face a surplus or a surplus : If a price of $10 is imposed in this market, does the market face a surplus or a surplus? How many units?

User Account

All Pages