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.
I’ve now expanded this file to include:
- Balance Sheet
- Income Statement
- Some General Metrics (e.g. Working Capital, Gross Profit Margin, Inventory Turnover).
Links:
Deceptively Blonde 