Tag Archives: Accounting

Corporate Balance Sheet & Income Statement (Automatically Formulated Worksheet with Metrics)

28 Feb

Hey guys!

A while back I posted a sample of a corporate balance sheet to use for informal work (e.g. in a classroom).  Unfortunately, that version was in Document form, rather than in Excel, so you had to do all the calculations yourself. 

This semester, I taught Introduction to Business, wherein students had to complete sample Balance Sheets and Income Statements as part of the ‘intro to accounting’ and ‘finance’ sections in the course. To help with their projects and give them a leg up in the future, I gave them an Excel version of a balance sheet.  

Balance.pngI’ve now expanded this file to include:

  • Balance Sheet
  • Income Statement
  • Some General Metrics (e.g. Working Capital, Gross Profit Margin, Inventory Turnover).

Links:

Features of the file include:

Continue reading

Sample Corporate Balance Sheet

24 Mar

Assets.png

If you are looking for a Sample Balance Sheet, here is one I created for my Corporate Finance students.  It’s not perfect of course, and you can always add or subtract things. Just download it as a Word Doc (or if that is not available, copy and paste to a word doc) and modify to suit your needs!

SAMPLE BALANCE SHEET

Here are some real-world examples you can use to compare:

%d bloggers like this: