Wall street prep stuvia - Study guides, Class notes & Summaries

Wall Street Prep Accounting Exam 2023 – 2024 with complete solutions 1. Liquidity Ratios: measures of a firm's short-term ability to meet its current obligations 2. Profitability Ratios: measures of a firm's profitability relative to its assets (op- erating efficiency) and to its revenue (operating profitability) 3. Activity Ratios: Measure of efficiency of a firm's assets 1. Liquidity Ratios: measures of a firm's short-term ability to meet its current obligations 2. Profitabili...

What is generally not considered to be a pre-tax non-recurring (unusual or infrequent) item? - ANSWER-Extraordinary gains/losses what is false about depreciation and amortization - ANSWER-D&A may be classified within interest expense Company X's current assets increased by $40 million from while the companies current liabilities increased by $25 million over the same period. the cash impact of the change in working capital was - ANSWER-a decrease of 15 million the final component of a...

Wall Street Prep Premium Exam 2023/2024 Questions And Answers Graded A+ What is generally not considered to be a pre-tax non-recurring (unusual or infrequent) item? - Answer Extraordinary gains/losses what is false about depreciation and amortization - Answer D&A may be classified within interest expense Company X's current assets increased by $40 million from while the companies current liabilities increased by $25 million over the same period. the cash impact of the change in working c...

Average Function - ANSWER-Definition: An Excel function that adds a group of values, and then divides the result by the number of values in the group. IF Statement Function - ANSWER-Definition: A function that returns one value when a condition you specify evaluates to true and a different value if it evaluates to false. Explanation: First you begin with the logical test for the function, and then provide the value the function should output if the logical test is evaluated to true, and last...

=AVERAGE(number1,[number2],...) - ANSWER-Average Function =IF(logical test, [value if true], [value if false]) - ANSWER-Simple IF Function =IFS(logical test n, value if true n, value if false n) - ANSWER-IFS Function =IFERROR(value, value_if_error) - ANSWER-IFERROR Function =EOMONTH(start_date,months) - ANSWER-EOMONTH Function =EDATE(start date,months) - ANSWER-EDATE Function =ISNUMBER(value) - ANSWER-ISNUMBER Function =ISTEXT(value) - ANSWER-ISTEXT Function =YEARFRAC(sta...

Keyboard Versus the Mouse - ANSWERSAlmost everything that can be done in Excel using a mouse can also be done using the keyboard shortcuts Best way to learn is to disconnect the mouse and work through Excel using only the keyboard Name Box - ANSWERSTells you what cell you are in (top left below the ribbon) Formula Bar - ANSWERSWhen you insert a formula into a cell and hit return, the cell will show you the output The formula bar, however, will show you the formula Next to "fx" right b...

What is the latest actual share count reported in the 2013 Colgate-Palmolive 10-K? Please provide your answer without comma separator or decimal (Ex: ) - ANSWER- According to its 2013 10-K, how many more shares can Colgate repurchase in the future under it share repurchase program? - ANSWER-25,937,562 According to Colgate's 2013 10-K, what factors led to lower effective non-GAAP tax rate during the year as compared to the company's effective GAAP tax rate? I. 2012 Restructuring Program ...

What is Accounting? - ANSWERSAccounting is the language of business; it is a standard set of rules for measuring a company's financial performance. Assessing a company's financial performance is important for: The firm's officers (managers and employees) Investors Lenders General public Standard financial statements serve as a "yardstick" of communicating financial performance to the general public. Why is Accounting Important? - ANSWERSEnables managers to make corporate decisions ...

FASB - ANSWER-Financial Accounting Standards Board, which oversees GAAP through issuance of SFAS, oversight by the SEC SFAS - ANSWER-Standard Financial Accounting Statements, issued by the FASB AA,P,C: Accounting Entity - ANSWER-The assumption that a corporation is an entity separate from any person AA,P,C: Going Concern - ANSWER-The Assumption that a corporation will continue to exist for the foreseeable future AA,P,C: Measurement & Units - ANSWER-The principle that financial statem...

Add/delete sheets - ANSWER-alt-i-w OR alt h-i-s Moving around task ribbon - ANSWER-Tab and shift (to select) Auto fit cell - ANSWER-alt-h-o-i Custom fit columns - ANSWER-alt h-o-w Custom fit rows - ANSWER-alt h-o-h Select entire column/row - ANSWER-ctrl shift-arrow key Format cells - ANSWER-ctrl 1 Paste special - ANSWER-alt e-s Freeze panes - ANSWER-alt w-f-f Split panes - ANSWER-alt w-s Move between panes - ANSWER-F6 Get in cell AND navigate to others while insi...