Ameritrade Case Writeup questions (do all this as if it is June 1997‚ date of the case): 1. What is Ameritrade’s capital structure? Because there is no preferred stock or long term debt‚ Ameritrade is a 100% equity firm. 2. What is Ameritrade’s cost of equity capital? CAPM= (.0643)+ (1.8264)(.188-.0559)=.2902=29.02% Return on Market=(899.470-757.12)/757.12=.188 Beta calculation on Attached Excel Spreadsheet. 3. What is Ameritrade’s cost of debt capital? Because there is
Premium Time Finance Corporate finance
didn’t know what a spreadsheet was‚ etc. So I started at: http://en.wikipedia.org/wiki/Spreadsheet. I read that and got a good base of spreadsheets and the history. First of all‚ Microsoft Excel is the industry standard in spreadsheets (history on spreadsheets can be accessed at the above website address). With Excel‚ you can create a shared workbook and place it on a network location where several people can edit‚ change‚ and work on the contents of a workbook‚ I discovered. Therefore‚ if the people
Premium Spreadsheet Microsoft Microsoft Excel
How to Use a Data Spreadsheet: Excel One does not necessarily have special statistical software to perform statistical analyses. Microsoft Office Excel can be used to run statistical procedures. Although in some respects Excel is not as preferable for data analyses as IBM SPSS‚ it is very userfriendly with simpler statistical procedures. This appendix describes how to use Excel to execute basic statistical calculations. Data from the 2004 version of the General Social Survey (GSS) is used for
Premium Spreadsheet Microsoft Excel Microsoft Office
Microsoft Excel 2007: Create a macro by using Microsoft Visual Basic | Add to Favorites | In Microsoft Excel 2007‚ macros can be created using Microsoft Visual Basic. The following will show you how to create a macro using Microsoft Visual Basic: 1. If the Developer tab is unavailable‚ complete the following to display it: a. Click the Microsoft Office Button‚ and then click Excel Options. b. In the Popular category‚ under Top options for working with Excel‚ choose
Premium Microsoft Office Microsoft Excel Microsoft
Chapter Introduction to Microsoft Excel A spreadsheet is a computer program that turns the computer into a very powerful calculator. Headings and comments can be entered along with detailed formulas. The spreadsheet screen is divided into ROWS and COLUMNS; the intersection between a row and a column is termed a CELL. Usually only a small section of the overall spreadsheet is displayed on the screen. 1 The Microsoft Excel Screen 1 Load Microsoft Excel and you should receive the following
Premium Microsoft Spreadsheet Microsoft Excel
You are already familiar with Microsoft Excel software. You have learnt some interesting and useful things that can be done in MS-Excel. Microsoft Excel is an electronic spreadsheet software which allows you to enter‚ calculate‚ manipulate‚ organize and analyze data in the form of tabular form. Let us learn more about data tools provide in Microsoft Excel. * Data Tools * Text to Columns * Remove Duplicates * Data Validation * Consolidate Data Tools With the powerful data
Premium Microsoft Excel Spreadsheet Microsoft
Microsoft Excel: Formulas‚ Formulas... Northern New York Library Network 6721 US Hwy 11 Postdam‚ NY 13676 877-833-1674 or 315-265-1119 www.nnyln.org Jim Crowley C3 - Crowley Computer Consulting 9148 State Highway 37 Ogdensburg NY 13669 315-394-7008 fax 315-394-7009 www.crowleycomputers.com jim@crowleycomputers.com Description: Excel has hundreds of functions and nobody knows them all‚ but spend some time and learn to create more powerful formulas. Students will dive into decision making functions
Premium Spreadsheet Mathematics Multiplication
Learning about Excel the past two weeks of this module have been interesting. There is more to learn about Excel than students could have anticipated. Week two of classes we were to complete an income statement‚ balance sheet‚ statement of cash flows‚ a common size income statement‚ and a common size balance sheet‚ from chapter two of Mayes & Shank (2012) problem number 3. The question that needs to be answered is what the value is in having the financial statements on a spreadsheet (Mayes &
Premium Generally Accepted Accounting Principles Spreadsheet Income statement
SIntroduction to Microsoft Excel 2007 Class learning objectives 1. What is Excel? • Spreadsheet uses & samples • Touring the Excel window • Learning important definitions • Navigating around the workbook 2. The Basics • Entering & editing data in cells • Inserting cells‚ rows‚ & columns • Formatting cells • Renaming‚ adding‚ & reorganizing worksheets 3. Formulas • Using mathematical operators • Using four sum methods • AutoCalculate 4. Customizing Your Spreadsheet • Gridlines 5. Finishing Up
Premium Microsoft Office Spreadsheet Microsoft
multiple sources of data? You: Yes‚ if the multiple sources are different worksheets in the same workbook. Question 04: Interviewer: By any means can you repeat ’row headings’ in the Pivot Table? You: Yes‚ however this option is available in Excel 2010 or later. Question 05: Interviewer: Is it possible to display the text in the data area of Pivot Table? You: No‚ it’s not possible as we could only show text either in ’Row Labels’ or ’Column Labels’. However‚ if needed‚ we can show count
Premium Spreadsheet Microsoft Excel Microsoft Office