Tag Archives: Income Statement

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.

I’ve now expanded this file to include:

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

Understanding the #IncomeStatement

5 Apr

As always, this lesson is not intended to be professional advice. This is simply lesson material for ESL students in a Managerial Economics and International Finance class. Posted here for their use or for helping other students.

There are 3 main Financial Documents you should be familiar with. Each paper is typically published once a year, so we say they are annual reports (年波).

**Please notice that all three documents only count and discuss EXPLICIT COSTS (明确的成本).  These documents are working with numbers and math, so the Explicit Costs includes only the money paid out to market-suppliers. It does not include any of the Implicit Costs like time and effort that the owner loses.  Therefore, the profits we see are only ACCOUNTING PROFITS (会计利润).  You can find a more detailed explanation of Costs and Profits here.

The Income Statement (损益表)~ Tells the reader very specifically (with a lot of detail):

• How much REVENUE (收入) they earned and where it came from,
• Revenue = Income, Sales, Yield, Gains
• How much COST (成本) they had and what the money was spent on,
• Cost = Expenses, Loss
• How much PROFIT (收益) was left at the end and what of that the owners will be paid.
• Profit = Returns, Sales, Yield, Income