[PDF] Financial Modeling 1-page Tutorial - Wall Street Training

105644_2WST_Financial_Modeling_Steps.pdf Wa ll S t . T r a i n i n g i s a r e g i s t e r e d s e rv i c e m a r k o f H L C a p it a l P a r t n e r s , L t d . Hamilton Lin, CFA W a ll S t. T r a i n i ng President + 1 ( 212
) 537
- 663

1 www.wallst-training.com

i nf o @ w a ll s t - t r a i n i n g . c om www.wstselfstudy.com TRAININGwww.wallst-training.com P r o v i d i n g f i n an c i a l t r a i n i n g t o W a l l S t r eet®WALL ST T R A I N I

NGwww.wallst-training.com

P r o v i d i n g f i n an c i a l t r a i n i n g t o W a l l S t r eet®WALL ST FINANCIAL STATEMENT MODEL

BUILDI

N G A

FULLY-INT

E G R A TED ,

SELF-BALANCI

N G

MODEL

O V E RV I E W O F S TE P S I NC O M E S T A T E M E NT E n t e r h i s t o r i c a l f i n a n c i a l i n f o r m a ti o n , d e c i p h e r h i s t o r i ca l t r e n d s E s ti m a t e r e v e n u e g r o w t h , e x p e n s e m a r g i n s C a l c u l a t e I S t h r u t o E PS , l e a v e p r o j ec t e d i n t e r e s t e x p e n s e a n d i n t e r e s t i n c o m e b l a n k B A L ANC E S H E ET E n t e r h i s t o r i c a l f i n a n c i a l i n f o r m a ti o n , c a l c u l a t e b a l a n c e r a t i o s E s ti m a t e r u n - r a t e r a t i o s P r o j e c t a ll a cc o u n t s e x c e p t f o r c a s h , PP E , d e b t a nd e q u it y ( A / R , I nv e n t o r y , A / P, e t c ) CA S H F L O W S T A TE M E NT C a l c u l a t e C a s h F l o w f r o m O p e r a t i o n s E s ti m a t e C a p i t a l E xp e n d i t u r e s a nd C a s h F l o w f r o m I nv e s t i ng E s ti m a t e C a s h F l o w f r o m F i n a n c i n g , e x c e p t f o r d e b t - r e l a t e d i t e m s C a l c u l a t e " C a s h A v a i l a b l e / R e q u i r e d B e f o r e D e b t " B A L ANC E S H E ET P r o j e c t PP E a nd e q u i t y a cc o u n t s , o n l y c a s h a n d d e b t r e m a i n i n g on B S no w D EB T S W EE P AND I N TE R E S T S C H E DU LE C a l c u l a t e r e q u i r e d b o rr o w i n g s F i l l i n d e b t t r a n c h e d a t a a nd m a n d a t o r y f u t u r e r e p a y m e n t s C a l c u l a t e r e vo l v e r p a y do w n / b o rr o w i n g s C a l c u l a t e d e b t s ub t o t a l s U s i ng n e w d e b t b a l a n c e s , e s ti m a t e i n t e r e s t r a t e s a nd c a l c u l a t e i n t e r e s t e x p e n s e a nd i n c o m e I N TE G R A T I N G T H E M O D EL C a s h F l o w S t a t e m e n t : C o m p l e t e C a s h F l o w f r o m F i n a n c i n g a n d c a l c u l a t e c h a ng e i n c a s h a n d n e w c a s h b a l a n ce s B a l a n c e S h ee t : L i n k i n n e w c a s h b a l a n c e s f r o m C a s h F l o w S t a t e m e n t a nd d e b t b a l a n c e s f r o m D e b t S w ee p I n c o m e S t a t e m e n t : L i n k i n i n t e r e s t e x p e n s e a n d i n t e r e s t i n c o m e f r o m I n t e r e s t S c h e d u l e