Wall Street

Wall Street Prep Excel -Exam Questions and Answers Add/delete worksheets alt i w Move back and forth to different worksheets ctrl page up and down Open a new file alt f n, ctrl n open a file alt f o, ctrl o save a file alt f s, ctrl s, alt f a(save as) print a file alt f p, ctrl p Navigating to the toolbars without the mouse Hit alt and the corresponding letter and then use tab and shift-tab to navigate Access Excel options alt f t, alt t o Bold ...

Wall Street Prep Accounting-Exam with complete solutions Liquidity Ratios measures of a firm's short-term ability to meet its current obligations Profitability Ratios measures of a firm's profitability relative to its assets (operating efficiency) and to its revenue (operating profitability) Activity Ratios Measure of efficiency of a firm's assets Solvency Ratios Measure of a firm's ability to pay its obligations Inventory Turnover COGS / avg inventory Receivab...

Excel Crash Course Exam from Wall Street Prep - Wall Street Prep. Instructions: Questions 1-4 use the financial model on tab Q1-4 in the Exam Workbook. Complete the model by filling in the blank cells before answering the question below. Answers should be rounded to the nearest whole number, comma separating 000s, NOT written in currency format. So if the answer is $5,505,210.50, you would input 5,505,210. 1. What is forecast Revenue in 2017? 13,642,021 2. What is forecast Net Income ...

WALL STREET PREP: EXCEL CRASH COURSE QUESTIONS AND CORRECT ANSWERS Keyboard Versus the Mouse Almost 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 Tells you what cell you are in (top left below the ribbon) Formula Bar When you insert a formula into a cell and hit return, the cell will show you the output The formula bar, however, wil...

Wall Street Prep Premium Exam 2023 Questions with 100% correct Answers What is generally not considered to be a pre-tax non-recurring (unusual or infrequent) item? Extraordinary gains/losses what is false about depreciation and amortization 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 ...

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

WallStreet Prep: Analyzing Financial Reports Exam Questions and Answers True or false: 10-Q's must be filed four times a year for publicly traded companies. False; only 3x a year True or False: Both the 10-K and 10-Q filings are audited. 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. False True or false: For large accelerated filers, 10-K's must ...

Wall Street Prep Excel -Exam Questions and Answers Add/delete worksheets alt i w Move back and forth to different worksheets ctrl page up and down Open a new file alt f n, ctrl n open a file alt f o, ctrl o save a file alt f s, ctrl s, alt f a(save as) print a file alt f p, ctrl p Navigating to the toolbars without the mouse Hit alt and the corresponding letter and then use tab and shift-tab to navigate Access Excel options alt f t, alt t o Bold ...

Wall Street Prep Accounting-Exam with complete solutions Liquidity Ratios measures of a firm's short-term ability to meet its current obligations Profitability Ratios measures of a firm's profitability relative to its assets (operating efficiency) and to its revenue (operating profitability) Activity Ratios Measure of efficiency of a firm's assets Solvency Ratios Measure of a firm's ability to pay its obligations Inventory Turnover COGS / avg inventory Receivab...