Wall Street

1. Add/delete worksheets: alt i w 2. Move back and forth to different worksheets: ctrl page up and down 3. Open a new file: alt f n, ctrl n 4. open a file: alt f o, ctrl o 5. save a file: alt f s, ctrl s, alt f a(save as) 6. print a file: alt f p, ctrl p 7. Navigating to the toolbars without the mouse: Hit alt and the corresponding letter and then use tab and shift-tab to navigate 8. Access Excel options: alt f t, alt t o 9. Bold: Ctrl B 10. Highlight Column: ctrl spacebar 11. Auto fit...

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 4. Solvency Ratios: Measure of a firm's ability to pay its obligations 5. Inventory Turnover: COGS / avg inventory 6. Receivables Turnover: revenue / average accounts receivable 7. DS...

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

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

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

Wall Street Prep Premium Exam 2023 Questions with 100% correct Answers Score: 95%, 38 correct out of 40 | Taken On: Question 1 Assume US GAAP to answer this question. In 2017, $2 million in wages were earned and no cash wages were paid. In 2018, $8 million in wages were earned and $7 million in cash wages were paid. Cash wages were used to first pay wages earned in 2017 with the remainder used to pay wages earned in 2018. Any earned but unpaid wages will be paid during the first quart...