Financial Model Sample

Learning to make financial model may do well for your career. It requires basic knowledge of MS excel and good knowledge of finance.

The model I have made is a basic one , but here you learn to make profit & loss, balance sheet and cashflow statements. Profit & loss statement are easier to make, whereas Balance sheet and Cashflow statements are relatively difficult to make and understand as well.

As I said earlier the model is basic one, you can add as much as detail you want to make it work for you. It can be in terms of products, variable or fixed cost, tax rates, depreciation, working capital etc.

Image

I have wound up the Depreciation & Term loan in brief. Please refer to my earlier post on Depreciation and Term Loan schedule for details

https://prashant99.wordpress.com/2013/09/24/term-loan-schedule/

https://prashant99.wordpress.com/2013/10/06/depreciation-schedule/

the link to file :

https://drive.google.com/file/d/0B2FLZ9YjqpJTR3J0bHBJTUtuLVU/edit?usp=sharing

 

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s