Excel On Stock Markets

Page 8 of 50 - About 500 Essays
  • Premium Essay

    Account

    12 Calculations In order to calculate the current market price of these bonds, I will use the formula for the bond price on the date of a coupon payment. The bond price on the date of a coupon payment is the PV of all coupons + the PV of the maturity value *. means multiplication The present value of all coupons = M * r* [1-(1+i)-n]/i The present value of the maturity date = C * [(1+i)-n] The current market price of these bonds is M * r* [1-(1+i)-n]/i + C * (1+i)-n] =

    Words: 1049 - Pages: 5

  • Premium Essay

    Samad

    Reliability Biasness Towards Aggressive Stocks: An Empirical Evidence From NSE * Dr. Neeraj Sanghi ** Dr. Gaurav Bansal INTRODUCTION While investing in a capital market, investors always have concern about the market movements or changes in the value of capital market index. This tendency of investors' behavior is related to a psychological factor that reveals that market movements and prices of stocks are closely related to each other. Upward / downward movement in market index gives trigger to the expectation

    Words: 4344 - Pages: 18

  • Premium Essay

    Analyze the Performance of Metcash and Woolworths

    making decisions about investments between these two companies. Two methods of DCF valuation and relative valuation are used during the analysis. Firstly, we estimate FCFF with calculated WACC to determine the two companies’ stock price, comparing their actual current stock price. Secondly, we analyze P/E Ratio, P/S Ratio and EV/EITDA Ratio to make a comparison between the two companies and average industry. Our estimation will show that both Metcash and Woolworth are undervalued and suitable for

    Words: 2467 - Pages: 10

  • Premium Essay

    Fi504-Project

    Microsoft 2007  Annual net income = Average Stock Holders Equity= Preferred Stock Divendends= Weighted Average Common Shares Outstanding= Total Current Liabilities= Common Stock Cash Dividends= Stock Holders Equity (Beginning of the period)= Stock Holders Equity (End of the period)= Average Stock Holders Equity= Net Cash from Operation(income)= Capital Expenditures= Total Assets= Cash Dividends Paid= Free Cash Flow= Average Current Liabilities= Average Total Liabilities= Earning Per Share (Basic)A/B=

    Words: 2192 - Pages: 9

  • Premium Essay

    Finance Class

    Tango Course Project Part 2 Task 4 1. The project’s IRR is going to be 22%. The way to figure it out is going to be on the excel spreadsheet that is attached to this project 2. To calculate the NPV you are going to use the formula NPV=(1,100,000/1.15)+(1,450,000/1.15)^2+(1,300,000/1.15)^3+ (950,000/1.15)^4-3,000,000=$450,866.74. Attached is the excel spreadsheet that shows the work. 3. Based on what the NPV is for this project the company should definitely consider accepting

    Words: 1651 - Pages: 7

  • Premium Essay

    Portfolio Investment and Financial Planning

    Ran Li_210037023 Yichao FU_900387184 Contents Question 1 3 Analysis of securities and the market index 3 Summary 3 Question 2 7 Question 3 8 Question 4. 9 Standard Consumption of CAPM 9 Expectation errors relied on ex-post data 12 Reference List 14 Question 1 Analysis of securities and the market index Summary Firstly we calculated the monthly return of each securities which depend on the data of adjust close price every month. The

    Words: 3831 - Pages: 16

  • Premium Essay

    Acf 504

    ACF 504: FINANCIAL MARKETS Coursework Assignment II GROUP 20 Definition of the Dataset (Word Count 1938) The dataset used in this report is derived from Thomson ONE Banker. The spreadsheet in Appendix contains the daily price of the TESCO and the FTSE All Share index during the period from 1 December 2014 to 30 November 2015. Each closing price includes 254 observations. We obtain 253 daily returns of the TESCO and 253 daily returns of FTSE index after calculating daily simple returns

    Words: 2496 - Pages: 10

  • Free Essay

    Paper

    Assignment 3 1. Design a multifactor model with at least 2 factors besides the market factor, and answer the following questions. a) What makes your choice of factor a “factor” in multifactor model? b) Does the factor of your choice co-move with the market factor? If yes, should you include it along with the market factor? c) Describe how the stock return would be affected when the factor of your choice changes. d) Describe a scenario where one can benefit from trading

    Words: 2090 - Pages: 9

  • Premium Essay

    Stock Market

    selling of stocks that we purchased using $ 100,000 USD (Monopoly money) given to us by our instructor. Our assignment was to invest the stock in any way seen best fit to gain the most profit. We were to track our stocks three times a week and document the results using Microsoft Excel. The requirements for the assignment were to include two stock trades and to try to make our portfolio diverse using different sectors. The purpose of this project is to understand how the stock market works, and

    Words: 2032 - Pages: 9

  • Premium Essay

    Finance Analysis

    INTRODUCTION We are required to collect stock prices of 35 public listed companies. There are 20 Malaysia, 5 United State, 5 United Kingdom, 5 Indonesia and KLCI index for the period of 2006 until 2013 based on weekly basis. Malaysia stock prices in this project based on Bursa Saham Malaysia. The stock prices of 20 Malaysia public listed company named by Prostaco, Raya International, Tiong Nam, Tong Herr, Toyo Ink, TSH, Turiya, United, Vitrox, UPA Corporation, Zecoon, Yokohama Industries, Woodlandoor

    Words: 2070 - Pages: 9

Page   1 5 6 7 8 9 10 11 12 50