Finance/Accounting 101: Direct and Indirect Costs

Direct Cost (Finance/Accounting): Can consist of fixed and variable costs, but that is 100% dedicated to a service, an asset, etc (Apptio, 2018; Investopedia, n.d.a.).  Imagine you buy a new laptop.  The cost is fixed direct cost to acquire it.

Indirect Cost (Finance/Accounting): Are costs that are shared amongst a service, an asset, etc. (Apptio, 2018).  Let’s look at the laptop you just bought above.  Even though the price of the physical laptop is fixed and direct, you have indirect fixed and variable costs associated with it.  Some of the indirect fixed cost will come from purchasing software, OS license, virus and malware detection software, etc. While some of the indirect variable cost will come with how much electricity you will spend to keep your laptop’s battery charged. Indirect costs can be hard to find if your budget isn’t transparent (Apptio, 2018).

Resources:

Finance/Accounting 101: Fixed and Variable Costs

Fixed Expense (Finance/Accounting): Are expenses that remain the same over time (Apptio, 2018; Investopedia, n.d.a.).  If you have a gym membership, you are charged a flat membership fee each and every period.  Thus, you know how much you can and should budget for.

Variable Expense (Finance/Accounting): Are expenses that change over time (Apptio, 2018; Investopedia, n.d.b.).  A great example is for those people who don’t have unlimited talk, text and data plan on their cell phone.  Given that we are measuring the exact minutes we spend each month talking, or the amount of text we send or receive, or how much data we download, this person’s cell phone bill will be variable. Here, you don’t know how much you can budget for.  Things happen.

Variable expense isn’t necessarily bad nor is fixed expenses good.  It depends on context, asset, service, etc.  Therefore, one should regularly evaluate their budget and see if what they have as fixed or variable expenses are justified. The benefit of a variable expense is you have the most leverage on how much you can consume or spend, giving you greater control over your budget rather than a fixed expense.  This leverage gives you budget flexibility (Apptio, 2018).

A healthy budget would take into account fixed and variable costs and will have an appropriate mix of the two.

Resources:

Finance/Accounting 101: Amortization and depreciation

The Matching Principle (accounting): Expenses are matched to and recorded in the period where you have realized the benefits (Accounting Coach, n.d.).  It doesn’t matter when you received or sent an invoice out, it matters only when you get paid or you pay the invoice (Apptio, 2018).  In other words, I get my credit card statement on the 23rd of the month (a weird date, but it is what it is).  The credit card company cannot realize the benefit/payment of the invoice until I pay it, therefore it is a liability for them (Accounting Coach, n.d.).  Usually, people have about a month or less to pay back their balance in part or in full.  Until I decide to pay them the credit card company cannot account for the money, which means the credit card company cannot say it is Revenue (Accounting Coach, n.d., Apptio, 2018).  This is because, how can the credit card company say I paid them for the service rendered if I haven’t cut the check or e-paid my bill? However, when I do pay, I can pay it on the 23rd, 24th or the 2nd of the month. Once I pay my bill, either in part or the full amount, the credit card company can say they realized the benefits for the service rendered (in this case, me borrowing money on credit).

Depreciation and Amortization (accounting/finance): This refers to how money is spread throughout the lifetime of the product or service (Apptio, 2018).  The best example we have for amortization is a mortgage on a house.  When I bought my house, I got a long printout (excel sheet style and a waste of trees) of how much I will be paying for my mortgage, how much of that will go to escrow, how much of that will go to the principle and how much of that goes to the interest.  The mortgage schedule shows that over time I will pay more into my principle and less into the interest, which tends to lower the book value of my housing loan (Investopedia n.d.a.).   If I were to sell the house, and it losses value during a housing bubble, then I will be in a budget shock (Apptio, 2018). The reason is that the entire amortization schedule is due in full at the date of closing, and I will be on the hook for the difference.

So, let’s look into buying a new car! When we buy a shiny new car and drive it off the lot, it is said to depreciate over 20% in a matter of seconds.  Over the course of the first two years, the cost of the car will further depreciate, therefore the best advice usually is to wait 2-5 years after the car has been manufactured to keep most of your money, given that the most depreciation occurs in the first 2-5 years (2 Cents, 2018).  Thus, depreciation is not necessarily the loss of intrinsic value for car usage, just a loss of financial value over time (Apptio, 2018).  Depreciation is accounted for in taxes or in accounting books, it can be used to illustrate the loss of value of an asset over the life of the asset (Apptio, 2018; Investopedia, n.d.b.).

Note that in business, assets can be tangible, usually a physical server, a building, etc., or intangible, like patents or copywrites, etc. (Apptio 2018).

Resources:

Adv Database Management: SQL Unions

Please note that the following blog post provides a summary view for what you need to get done (left column) and quick examples that illustrate how to do it in SQL (right column with SQL code in red). For more information please see the resources below:

Union
SELECT ename, job, deptno
  FROM emp
  UNION
SELECT name, title, deptid
  FROM emp_history
Intersect
SELECT ename, job, emptno
  FROM emp
  INTERSECT
SELECT name, emptid, title
  FROM emp_history
Union all (will include duplicate values)
SELECT ename, job, emptno
  FROM emp
  UNION ALL
SELECT name, emptid, title
  FROM emp_history

Adv Database Management: SQL Sub-queries and views

Please note that the following blog post provides a summary view for what you need to get done (left column) and quick examples that illustrate how to do it in SQL (right column with SQL code in red). For more information please see the resources below:

Subquery
SELECT enames
  FROM emp
  WHERE sal >
    (SELECT sal
     FROM emp
     WHERE empno = 7566)
Correlated Subqueries
SELECT empno, sal, deptno
  FROM   emp outr
  WHERE  sal >
    (SELECT AVG(sal)
     FROM   emp innr
     WHERE  outr.deptno = innr.deptno)
Exists
SELECT empno, ename, job, deptno
  FROM   emp outr
  WHERE  EXISTS
    (SELECT empno
     FROM   emp innr
     WHERE  innr.mgr = outr.empno)
Not Exists
SELECT dname, deptno
  FROM   dept d
  WHERE  NOT EXISTS
    (SELECT *
     FROM   emp e
     WHERE  d.deptno = e.deptno)
In
SELECT empno, ename, job, deptno
  FROM   emp outr
  WHERE empno IN
    (SELECT mgr
     FROM   emp)

Creating a view
CREATE VIEW empvu10
  AS SELECT empno, ename, job
     FROM emp
     WHERE deptno = 10
Drop view
DROP VIEW empvu10

Adv Database Management: SQL Group functions

Please note that the following blog post provides a summary view for what you need to get done (left column) and quick examples that illustrate how to do it in SQL (right column with SQL code in red). For more information please see the resources below:

AVG, COUNT, MAX, MIN, STDDEV, SUM, VARIANCE
SELECT AVG(sal), MAX(sal), MIN(sal), SUM(sal)
  FROM emp
  WHERE jobs LIKE ‘Sales%’
COUNT
SELECT COUNT(*)
  FROM emp
  WHERE deptno = 30
Group By
SELECT deptno, AVG(sal)
  FROM emp
  GROUP BY deptno
Rollup and cube
SELECT   deptno, MAX(sal)
  FROM     emp
  GROUP BY deptno WITH ROLLUP [CUBE]
Having
SELECT   deptno, MAX(sal)
  FROM     emp
  GROUP BY deptno
  HAVING max(sal)>2900

 

Database Management: SQL Joins

Please note that the following blog post provides a summary view for what you need to get done (left column) and quick examples that illustrate how to do it in SQL (right column with SQL code in red). For more information please see the resources below:

Equijoins
SELECT e.ename, e.deptno,  d.deptno, d.name
  FROM emp e INNER JOIN dept d
  ON e.deptno = d.deptno
Non-Equijoins
SELECT e.ename, e.sal,  s.grade
  FROM emp e INNER JOIN salgrade s
  WHERE e.sal
  BETWEEN  s.losal  AND  s.hisal

From:
grade      losal        hisal
-----      -----        ------
1            700        1200
2           1201        1400
3           1401        2000
4           2001        3000
5           3001        9999

Gives the following solution:
ename           sal     grade
----------   --------- ---------
JAMES            950         1
SMITH            800         1
ADAMS           1100         1
Outer joins
SELECT e.ename, e.deptno,  d.deptno
  FROM emp e RIGHT JOIN dept d
  ON e.deptno = d.deptno

SELECT e.deptno,  d.deptno, d.name
  FROM emp e LEFT JOIN dept d
  ON e.deptno = d.deptno
Self Joins
SELECT worker.ename +’ works for’+ manager.ename
  FROM emp worker, emp manger
  ON worker.mgr = manager.empno