Written by students who passed Immediately available after payment Read online or as PDF Wrong document? Swap it for free 4.6 TrustPilot
logo-home
logo
  • FINANCIAL STATEMENT MODELING
  • FINANCIAL STATEMENT MODELING
To add items to your wishlist, you must be logged in
Document preview thumbnail
Preview 2 out of 5 pages
Exam (elaborations)

WSP- FINANCIAL MODELING EXAM QUESTIONS AND CORRECT DETAILED / VERIFIED ANSWERS

0.0
(0 reviews)
- sold
5 pages
2024/2025 Written for academic year
Institution FINANCIAL STATEMENT MODELING
Course FINANCIAL STATEMENT MODELING
Document preview thumbnail
Preview 2 out of 5 pages

Why do you never want to re-enter the same input more than once in your model? - ANS Bc. you want your model to be dynamic Components of a financial statement model? - ANS Income statement Balance sheet Statement of cash flows Both historical results and forecasts What colour text should you use for: Hard-coded inputs Formulas Links to other worksheets Links to other files Links to data providers - ANS Hard-coded inputs - blue Formulas - black Links to other worksheets - green Links to other files - red Links to data providers - dark red Should you hide rows? - ANS No, grouping is better Should you merge cells? - ANS No, centering across selection is better Footnotes vs comments? - ANS Footnotes will show up when model is printed Comments for internal purposes If you want to delete a worksheet and want to know if there are any links to that worksheet, how can you do this? - ANS Ctrl + F and then search for the name of the worksheet you want to delete What documents would you gather prior to starting to model? - ANS Latest annual report and corresponding 4th quarter press release and earnings call transcript Latest equity research & EPS consensus estimates Last 6 months news run (stock splits, acquisitions and other material changes) For quarterly models and LTM calculations... -also get latest 3 quarterly reports and corresponding press releases & earnings calls

Content preview

WSP- FINANCIAL MODELING
EXAM QUESTIONS AND




K
CORRECT DETAILED /




C
VERIFIED ANSWERS

LO
YC
D
U
ST

, Why do you never want to re-enter the same input more than once in your model? - ANS Bc.
you want your model to be dynamic

Components of a financial statement model? - ANS Income statement
Balance sheet
Statement of cash flows

Both historical results and forecasts




K
What colour text should you use for:
Hard-coded inputs
Formulas




C
Links to other worksheets
Links to other files
Links to data providers - ANS Hard-coded inputs -> blue




LO
Formulas -> black
Links to other worksheets -> green
Links to other files -> red
Links to data providers -> dark red
YC
Should you hide rows? - ANS No, grouping is better

Should you merge cells? - ANS No, centering across selection is better

Footnotes vs comments? - ANS Footnotes will show up when model is printed
D

Comments for internal purposes

If you want to delete a worksheet and want to know if there are any links to that worksheet, how
U


can you do this? - ANS Ctrl + F
and then search for the name of the worksheet you want to delete
ST




What documents would you gather prior to starting to model? - ANS Latest annual report and
corresponding 4th quarter press release and earnings call transcript

Latest equity research & EPS consensus estimates

Last 6 months news run (stock splits, acquisitions and other material changes)

For quarterly models and LTM calculations...
-also get latest 3 quarterly reports and corresponding press releases & earnings calls

Document information

Uploaded on
December 4, 2024
Number of pages
5
Written in
2024/2025
Type
Exam (elaborations)
Contains
Questions & answers
Report Copyright Violation
$12.99
Wrong document? Swap it for free Within 14 days of purchase and before downloading, you can choose a different document. You can simply spend the amount again.
Written by students who passed
Immediately available after payment
Read online or as PDF
Seller avatar
Reputation scores are based on the amount of documents a seller has sold for a fee and the reviews they have received for those documents. There are three levels: Bronze, Silver and Gold. The better the reputation, the more your can rely on the quality of the sellers work.
Studyclock
4.2
(234)
Sold
886
Followers
492
Items
8765
Last sold
1 week ago
Available in package deal
Product Image
Package deal
WALL STREET PREP FINANCIAL MODELING EXAM PACKAGE DEAL
-
-
Sold
6
item
Dec 2024
$78.94
$39.99
You save 49% More Info

Browse related subjects

Subjects

Why students choose Stuvia

Created by fellow students, verified by reviews

Quality you can trust: written by students who passed their tests and reviewed by others who've used these notes.

Didn't get what you expected? Choose another document

No worries! You can instantly pick a different document that better fits what you're looking for.

Pay as you like, start learning right away

No subscription, no commitments. Pay the way you're used to via credit card and download your PDF document instantly.

Student with book image

“Bought, downloaded, and aced it. It really can be that simple.”

Alisha Student

Working on your references?

Create accurate citations in APA, MLA and Harvard with our free citation generator.

Learn more Create citation
Working on your references?

Frequently asked questions