Geschreven door studenten die geslaagd zijn Direct beschikbaar na je betaling Online lezen of als PDF Verkeerd document? Gratis ruilen 4,6 TrustPilot
logo-home
Tentamen (uitwerkingen)

Wall Street Prep Excel -Exam Questions and Answers A

Beoordeling
-
Verkocht
-
Pagina's
9
Cijfer
A+
Geüpload op
12-04-2024
Geschreven in
2023/2024

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 Ctrl B Highlight Column ctrl spacebar Auto fit column width alt h o i, alt o c a Enter column width alt h o w, alt o c w Highlight Row Shift Spacebar

Meer zien Lees minder
Instelling
Vak

Voorbeeld van de inhoud

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: shows revenue-expenses


Balance sheet
snapshot of the company economic resources and funding for those resources at a given point in time
(A = L + SE)


Revenue
"top-line"

represents the sale of goods and services

it is recorded when earned (even though cash might not have been received at the time of
transaction)


Expenses
netted against revenue to arrive at net income

COGS (directly associate with good production), SG&A (indirectly associated with production), interest
expense (expense related to paying debt holders periodic payments), taxes, depreciation expense
(non-cash expense accounting for the use of PP&E, often imbedded within COGS and SG&A)


Net income
"bottom-line"

revenue-expenses

the profitability available to common shareholder's after debt payments have been made (interest
expense)


EPS (earnings per share)

, portion of a company's profit allocated to each outstanding share of common stock

EPS = (net income - dividends on preferred stock)/weighted average shares outstanding


Cash flow statement
While cash is not necessarily received when a sale occurs, the income statement still records the sale.
As a result, the income statement captures all the economic transactions of the business.

The cash flow statement is needed because the income statement uses what is called accrual
accounting. In accrual accounting, revenues are recorded when earned regardless of when cash is
received (revenue includes sales using cash and made on credit A/R)

Since we also want to have a clear understanding of the cash position of a company, we need the
statement of cash flows to reconcile the income statement to cash inflows and outflows.

"cash position of the company"

cash from operating activities, cash from investing activities, and cash from financing activities


Cash from operating activities
mostly indirect method

starts with net income and includes the cash effects of transactions involved in calculating net
income. reconciliation of net income.

Net income (income statement)
+ non-cash expenses
- non-cash gains
- period on period increases in working capital assets
+ period on period increases in working capital liability
= CF from operations

*for stable, mature, plain vanilla companies, a positive cash flow from operating activities is desirable


Cash from investing activities
cash related to investments in the business (additional capex or sales of assets)

for stable, mature, plain vanilla a negative cash flow from investing activities is desirable as this
indicates that the company is trying to grow by buying assets


Cash from financing activities
cash related to capital raising and payment of dividends

if the company issues more preferred stock, we will see such an increase in cash in this section

if the company pays out dividends, we will see a cash outflow

for stable, mature plain vanilla companies, there is not a preference for positive or negative cash flow
in this section


Net change in cash over period =
cash from operating activities plus cash from investing activities plus cash from financing activities

Geschreven voor

Vak

Documentinformatie

Geüpload op
12 april 2024
Aantal pagina's
9
Geschreven in
2023/2024
Type
Tentamen (uitwerkingen)
Bevat
Vragen en antwoorden

Onderwerpen

$9.99
Krijg toegang tot het volledige document:

Verkeerd document? Gratis ruilen Binnen 14 dagen na aankoop en voor het downloaden kun je een ander document kiezen. Je kunt het bedrag gewoon opnieuw besteden.
Geschreven door studenten die geslaagd zijn
Direct beschikbaar na je betaling
Online lezen of als PDF


Ook beschikbaar in voordeelbundel

Maak kennis met de verkoper

Seller avatar
De reputatie van een verkoper is gebaseerd op het aantal documenten dat iemand tegen betaling verkocht heeft en de beoordelingen die voor die items ontvangen zijn. Er zijn drie niveau’s te onderscheiden: brons, zilver en goud. Hoe beter de reputatie, hoe meer de kwaliteit van zijn of haar werk te vertrouwen is.
LectDeniz Teachme2-tutor
Volgen Je moet ingelogd zijn om studenten of vakken te kunnen volgen
Verkocht
21
Lid sinds
2 jaar
Aantal volgers
13
Documenten
4974
Laatst verkocht
7 maanden geleden
Lect Deniz Academic Resources Hub

Lect Deniz is a highly experienced academic tutor and dedicated content creator with a strong track record of developing comprehensive, high-quality study materials for a wide range of university courses across the globe. With years of experience in higher education support, he excels at transforming complex academic concepts into clear, structured, and easy-to-follow resources that enhance student understanding and confidence. He provides an extensive collection of well-researched and carefully organized documents across key disciplines, including nursing, medicine, and various science fields. His materials cover essential topics such as anatomy, physiology, pharmacology, clinical practice, and core scientific principles, making them highly valuable for both coursework and intensive exam preparation. Each document is thoughtfully designed to align with university standards and curricula, ensuring accuracy, relevance, and practical application. Lect Aziim’s work stands out for its clarity, depth, and attention to detail, offering students concise summaries, detailed explanations, and exam-focused content that supports effective revision. His commitment to academic excellence and student success is reflected in the consistency and reliability of his materials, making him a trusted resource for learners seeking to improve performance and achieve their academic goals.

Lees meer Lees minder
5.0

1 beoordelingen

5
1
4
0
3
0
2
0
1
0

Recent door jou bekeken

Waarom studenten kiezen voor Stuvia

Gemaakt door medestudenten, geverifieerd door reviews

Kwaliteit die je kunt vertrouwen: geschreven door studenten die slaagden en beoordeeld door anderen die dit document gebruikten.

Niet tevreden? Kies een ander document

Geen zorgen! Je kunt voor hetzelfde geld direct een ander document kiezen dat beter past bij wat je zoekt.

Betaal zoals je wilt, start meteen met leren

Geen abonnement, geen verplichtingen. Betaal zoals je gewend bent via iDeal of creditcard en download je PDF-document meteen.

Student with book image

“Gekocht, gedownload en geslaagd. Zo makkelijk kan het dus zijn.”

Alisha Student

Bezig met je bronvermelding?

Maak nauwkeurige citaten in APA, MLA en Harvard met onze gratis bronnengenerator.

Bezig met je bronvermelding?

Veelgestelde vragen