,,,,,,,,,,,,,,
,short term assets,,,short term debt,,,Short Term Net,=C10+F10,,,,,,
,bank acct,4211.27,,sw card bal,-316,,Accts Rec/Pay,=C22+F22,,,,,,
,cash,0,,,,,Long Term Net,=C32+F32,,,,,,
,savings,0,,freed card bal,-1049.4,,Total Net Worth,=C10+C32+C22+F10+F32+F22,,,,,,
,owed,15,,pending,-148.57,,,,,,,,,
,,,,amex,-522.04,,,,,,,,,
,,,,pending,-57.35,,,,,,,,,
,,,,,,,,,,,,,,
,Total,=SUM(C3:C9),,Total,=SUM(F3:F9),,,,,,,,,
,,,,,,,,,,,,,,
,Acct Receivable,,,Accts Payable,,,,,,,,,,
,unpaid days worked,=4028/31*DAY(TODAY()+1)-4028/31,,rent payable,=-1000/31*DAY(TODAY()),,,,,,,,,
,last mth exp,,,utilities,=-1*(TODAY()-DATE(2014,7,1))*(867/180),,,,,,,,,
,cur mth exp,=140/30*DAY(TODAY()),,,,,,,,,,,,
,gamblin,108.17,,,,,,,,,,,,
,lunch,38,,,,,,,,,,,,
,visa cash back,24,,,,,,,,,,,,
,fee to remove,34,,,,,,,,,,,,
,,,,,,,,,,,,,,
,,,,,,,,,,,,,,
,Total,=SUM(C13:C21),,Total,=SUM(F13:F21),,,,,,,,,
,,,,,,,,,,,,,,
,long term assets,,,long term debt,,,,,,,,,,
,tdamer,973,,sallie mae,-3386.6,,,,,,,,,
,vang mmf,2000.57,,,,,,,,,,,,
,vang roth ira,1054,,,,,,,,,,,,
,selling fee,-10,,,,,,,,,,,,
,cash,0,,,,,,,,,,,,
,tax rec receivable,,,,,,,,,,,,,
,,,,,,,,,,,,,,
,Total,=SUM(C25:C31),,Total,=SUM(F25:F31),,,,,,,,,
,,,,,,,,,,,,,,
,taxes/refund owed,=VLOOKUP(MONTH(TODAY()),Taxes!A3:L15,12,FALSE)+((VLOOKUP(MIN(12,MONTH(TODAY())+1),Taxes!A3:L15,12,FALSE)-VLOOKUP(MONTH(TODAY()),Taxes!A3:L15,12,FALSE))/30*DAY(TODAY())),,,,,,,,,,,,
,,,,,,,,,,,,,,
,Non-Liquid Assets,,,,,,,,,,,,,
,Computer,700,,,,,,,,,,,,
,Car,5000,,,,,,,,,,,,
,Security Deposit,1000,,,,,,,,,,,,
,costco cashback,42,,,,,,,,,,,,
,test if I pass and stay,200,,,,,,,,,,,,
,laptop,400,,,,,,,,,,,,
,tax,=VLOOKUP(MONTH(TODAY()),Taxes!A3:L15,12,FALSE)+((VLOOKUP(MIN(12,MONTH(TODAY())+1),Taxes!A3:L15,12,FALSE)-VLOOKUP(MONTH(TODAY()),Taxes!A3:L15,12,FALSE))/30*DAY(TODAY())),,,,,,,,,,,,
,,,,,,,,,,,,,,
,Total,=SUM(C37:C44),,,,,,,,,,,,
,,,,,,,,,,,,,,
,,,,,,,,,,,,,,
,,,,,,,,,,,,,,