Wednesday, October 14, 2009

Templates

Today we ran through templates:Excel Spreadsheets. So there are 3 things that go hand in hand with that they are:
  1. Net Work:Statment(spreedsheet)
  2. Debt Equity Ratio (Calculation)
  3. G.D.S.R.=Gross Debt Service Ratio(Calculation)
Measures of Financial "Heath"

Network=total asset(own) - Total liabilities(owe)
***Net worth can be negative, and is dynamic, throughout ones life***

Debt Equity Ratio= DxE =(total liabilities-mortgage) divided by network x 100
***Most desirable DxE ratio is 0%****

G.D.S.R=(monthly rent/mortgage+ monthly taxes+ monthly heat) divided by gross household monthly salary x 100
Then we went through a question with the class. This stuff is really good to know for when going into the world and when i have to deal all this good stuff. .

No comments:

Post a Comment