Wall Street Prep

Excel Crash Course Exam from Wall Street Prep (Wall Street Prep)2023/2024

Liquidity Ratios CORRECT ANS - measures of a firm's short-term ability to meet its current obligations Profitability Ratios CORRECT ANS - measures of a firm's profitability relative to its assets (operating efficiency) and to its revenue (operating profitability) Activity Ratios CORRECT ANS - Measure of efficiency of a firm's assets Solvency Ratios CORRECT ANS - Measure of a firm's ability to pay its obligations Inventory Turnover CORRECT ANS - COGS / avg inventory Receivables Turnov...

Assets - CORRECT ANS resources a company uses to operate its business includes cash, A/R, PP&E Liabilities - CORRECT ANS represents the company's contractual obligations and includes A/P, debt, accrued expenses Shareholder's equity - CORRECT ANS is the residual the value of the business available to the owners (shareholders) after debts have been paid off Income statement - CORRECT ANS illustrates the profitability of the company over a specified period of time broad sense: shows reve...

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

What is generally not considered to be a pre-tax non-recurring (unusual or infrequent) item? - CORRECT ANS Extraordinary gains/losses what is false about depreciation and amortization - CORRECT ANS 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 - CORRECT ANS a decrease of 15 million the final ...

True or false: 10-Q's must be filed four times a year for publicly traded companies. - CORRECT ANS False; only 3x a year True or False: Both the 10-K and 10-Q filings are audited. - CORRECT ANS False; only 10-K filings are audited True or false: All publicly traded companies and private companies with revenues greater than $850m must file 10-K's annually with the SEC. - CORRECT ANS False True or false: For large accelerated filers, 10-K's must be filed no later than 90 days after the ...

1. What is generally not considered to be a pre-tax non-recurring (unusual or infrequent) item?: Ans- Extraordinary gains/losses 2. what is false about depreciation and amortization: Ans- D&A may be classified within interest expense 3. 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: Ans- a decrease of 15 million 4. the final component of...