11% Monthly Regions Best 12.57% Semiannually 1. Assuming that Coca Cola is considering loans from National First and Regions Best, what are the EARs for these two banks? (15 pts) Bank EAR National First 11.57% Regions Best 12.97% See Excel attachment for calculations 2. Based on your calculations above, which of the two banks would you recommend and why? Explain your rationale. (15 pts) Based on the calculations above I recommend Coca Cola obtain a loan from National First Bank
Words: 1345 - Pages: 6
primary market and new issued shares are traded in the secondary market. BSE and NSE are two renowned stock exchanges which plays an important role in Indian stock market. Most of the big companies in India are listed in these stock exchanges. The companies are enlisted with these stock exchanges as per rules and regulation specified by particular stock exchanges (Greer and Kolbe, 2008). In Indian context the company distributes the shares in lieu of capital with the help of these stock exchanges
Words: 2176 - Pages: 9
review basic hypothesis testing and regression techniques. There is an appendix in your textbook, Appendix C: Using Excel to Conduct Analysis, which may help you with running regressions in Microsoft Excel. You may also wish to use a basic statistics text for guidance if needed. I have also provided you with a table with the t distribution. If you have an older version of EXCEL and have not previously loaded the Analysis ToolPak, go to TOOLS, ADD-INS, Analysis Tool Pak. This will load the
Words: 1552 - Pages: 7
futures contracts to hedge can reduce exposure to market risk over a period of time. This project covered both stock portfolios and bond portfolios. To illustrate this, the method of linear regression and least squares was used. We used linear regression to regress the spot rate against the futures contract return. To complete this project both EViews and Microsoft Excel was used. Summary of Points Stock Regression 2008-2009 Around 96% of the stock portfolio returns can be explained. This was
Words: 714 - Pages: 3
MM) Short term Borrowings Revolver Bonds Of which Convertible Bonds Convertible Preferred Stock Due Date 15-Aug-09 31-May-10 31-Dec-12 31-May-10 1-Aug-12 31-Mar-14 31-Dec-10 5.2 14.2 80.0 12.0 7.0 Notes 3.2% coupon Due 5/31/2010 7.5% coupon, amortizing Bond Amortizing portion 4.5% coupon, conversion price $25, 1 bond of Fair value $100 converts into 4 shares 9.0 3% coupon, conversion price $20, 1 preferred stock of Fair value $18 converts into 1 share UNDERSTANDING THE CAPITAL STRUCTURE OF THE FIRM
Words: 2396 - Pages: 10
Executive Summary Henkel AG is a worldwide company, which headquarter is located in Düsseldorf, Germany. Since 1876, holds a well-known leading market positions in both industrial and consumer businesses. It employs around 47,000 people, from at least 6 different areas worldwide. The company has brands and technologies which focused in three globally operating areas: Laundry & Home Care, Beauty Care and Adhesive technologies (Henkel AG & Co. KGaA, 2012). From 2012 their sales values
Words: 4435 - Pages: 18
makes an equal contribution to the assignment, as far as possible. Free riders should be reported to me and may be penalised. 4. You are expected to make this assignment an opportunity to develop you spreadsheet computational skills. Make use of Excel to do your calculations and charts/graphs. 5. Assignments must be presented in a professional and reader-friendly manner. The key results or summaries of your calculation and your comments must be shown in the body of the report. Make sure the
Words: 1087 - Pages: 5
number. When answering the questions, put your team number in the places where it says yourteamnumber. If you do not know your team number, please contact Mr. Boyacı. * It is recommended that you use Excel to answer the questions. Please refer to the Lab Sheets and handouts for relevant Excel functions (the course package contains these). * If you have a “ghost” teammate who did not show up for meetings and did not contribute to the project at all, please leave out his/her name from the list
Words: 1771 - Pages: 8
always something that can be edited. Can be exported to excel. * Diff between static (raw data can be taking out without being protected) and dynamic data. There’s a way to pull Bloomberg data in excel without being in Bloomberg. * Financial analysis page. (equity analysis )Useful if taking accounting. For public companies. Market cap, revenue. For fundamental analysis, see what makes a company tick. Can be transported to excel * Only work if on same computer. If values are formula
Words: 523 - Pages: 3
analyze a stock. Before I analyze my quantitative data from my excel I’m going to discuss Beta in general. For my discussion of beta I will be using 3 examples of stocks that each have a different beta. Apple (AAPL) with a beta of .93, fluctuates close to the overall market. Walmart (WMT) has a beta of .3 which will be the lowest of the group. The last stock I will be analyzing for my discussion of beta is SanDisk Corp. (SNDK) with 2.21. What is beta, what does it tell you about the stock? The number
Words: 649 - Pages: 3
