Average of three month return for the stock price

Assignment Help Financial Management
Reference no: EM131332179

Practice; create a macro to create the moving average of three month return for the stock price . Date Price Jan 100 Feb 110 Mar 115 Apr 140 May 120 Jun 132 Jul 124 Aug 120 Sep 115 Oct 132 Nov 143 Dec 128

Reference no: EM131332179

Questions Cloud

Write a draft paper about the drug vyvanse : Discuss about the drug Vyvanse.History and epidemiology of the drug,The pharmacology, how does it work in the system,How is it grown, manufactured, transported and marketed.
What does the IRR rule advise regarding payment arrangement : Professor Wendy Smith has been offered the following? opportunity: A law firm would like to retain her for an upfront payment of $49,000. In return, for the next year the firm would have access to eight hours of her time every month. Smith's rate is ..
Both perpetuities have the same present value : One perpetuity-imediate with annual payments of $50 has a present value of $300. A second perpetuity has first payment equal to $35, increasing by 3% each year for the next 5 years; the payments are $X thereafter. Both perpetuities have the same pres..
What is the expected return of stock : The stock of company A has a beta of 1.5. The return of market portfolio is 9% and the risk-free rate is1%. 1) According to the Capital Asset Pricing Model (CAPM), what is the expected return of this stock?
Average of three month return for the stock price : Practice; create a macro to create the moving average of three month return for the stock price . Date Price Jan 100 Feb 110 Mar 115 Apr 140 May 120 Jun 132 Jul 124 Aug 120 Sep 115 Oct 132 Nov 143 Dec 128
Prepare an amortization schedule using excel : ACC3300- On December 31, 2016, Carson Company rendered services to Lincoln Corporation at an agreed price of $125,939. Prepare amortization schedule using excel. Use effective-interest method for amortization purposes.
Describe your own personal perspective of reform : Describe your own personal perspective of reform (Islah) and revivalism (ihya). In this essay, you must support and justify your outlook on the topic and mention how Islah /Ihya should begin and where it should start
What is the current yield on bond : Consider $1000 par value bond with a 7 percent annual coupon. The bond pays interest annually. There are 9 years remaining until maturity. What is the current yield on the bond assuming that the required return on the bond is 10 percent?
Draw the extensive form of the game : Draw the extensive form of the game.- Write down strategic form of the game.- Find two equilibria in pure strategies.

Reviews

Write a Review

Financial Management Questions & Answers

  What interest rate is being applied to value this perpetuity

An inheritance provides an award of $999 at the end of each year, beginning in one year that continues forever. At the reading of the will you learn that you can instead trade this award for a one-time immediate (time 0) payment of $12,488. Approxima..

  Cash conversion cycle

Primrose Corp has $20 million of sales, $3 million of inventories, $3 million of receivables, and $2 million of payables. Its cost of goods sold is 65% of sales, and it finances working capital with bank loans at an 7% rate. Assume 365 days in year f..

  How much will joe have in his account by the end of year

Joe plans to deposit $200 at the end of each month into a bank account for a period of 3 yr, after which he plans to deposit $300 at the end of each month into the same account for another 4 yr. If the bank pays interest at the rate of 7%/year compou..

  Before the recapitalization

Tapley Inc. currently has total capital equal to $6 million, has zero debt, is in the 40% federal-plus-state tax bracket, has a net income of $2 million, and pays out 40% of its earnings as dividends. What is the stock's current price per share (befo..

  Continental carriers cash study

Has anybody worked on the "Continental Carriers, Inc." case study? If so, what's the best response to the following question? How should the acquisition of Midland Freight be financed, taking into account to cost of comparisons and other appropriate ..

  Required return on riskier stock exceed-on less risky stock

Stock R has a beta of 1.5, Stock S has a beta of 0.75, the expected rate of return on an average stock is 13%, and the risk-free rate is 7%. By how much does the required return on the riskier stock exceed that on the less risky stock?

  What are days sales outstanding-average amount of receivable

McDowell Industries sells on terms of 3/10, net 30. Total sales for the year are $715,000; 40% of the customers pay on the 10th day and take discounts, while the other 60% pay, on average, 50 days after their purchases. Assume 365 days in year for yo..

  Why might forward contracts be advantageous for transactions

Why might forward contracts be advantageous for committed transactions, and currency options be advantageous for anticipated transactions?

  Look for the balance amount due to be paid by bank

you have taken a loan of 320000 from a bank for the 5 years at the prevailing rate of 3.75% , Calculate the annual instalment you are liable to pay to the bank and create a loan amortization table for a quick access to the principle and interest paid..

  About the self-supporting growth rate

Maggie's Muffins, Inc., generated $2,000,000 in sales during 2015, and its year-end total assets were $1,400,000. Also, at year-end 2015, current liabilities were $1,000,000, consisting of $300,000 of notes payable, $500,000 of accounts payable, and ..

  Evaluate the proposed acquisition of a new special-purpose

You have been asked by the president of your company to evaluate the proposed acquisition of a new special-purpose truck for $320,000. The truck falls into the MACRS 10-year class, and it will be sold after 10 years for $57,000. The firm's marginal t..

  What is the price of the product under this expense model

A company is considering a project to manufacture a product with the following pro forma cost and sales information: Accounting Breakeven QUANTITY = 10,500 units; Cash Breakeven QUANTITY = 8,200 units; What is the PRICE of the product under this expe..

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd