Personal Financial Statement Mapped to Consolidated Financial Statement

The table that follows outlines the way rows from a Baker Hill Statement Analyzer personal financial statement spread are mapped into the Consolidated Financial Statement format.

This row in the Consolidated Financial Statement...

Represents the consolidation of these row values in Statement Analyzer...

1 Cash and Liquid Assets

1 Cash on hand in banks

2 Savings and CD’s

3 Government Securities

4 Stocks & Bonds – Marketable

2 Accounts Receivable

6 Accounts and Notes Receivable

4 Other Current Assets

7 Other Assets Readily Convertible to Cash

5 TOTAL CURRENT ASSETS

9 Liquid Assets

7 Fixed Assets

11 Residence
12 Income Producing RE
13 Partnerships RE
14 Other RE

8 Other Assets

18 Notes Receivable

19 Stocks & Bonds – Unlisted

20 Investments in Closely Held

21 Partnership Interests

22 Oil & Gas Interests

23 Other Investments

25 Life Insurance – Cash Value

26 Profit Sharing Pension Fund

27 IRA/Keough

28 Due from Relatives

29 Automobiles

30 Equipment

31 Personal Property

32 Other Assets

10 Total Assets

Sum of Total Current Assets, Fixed Assets, and Other Assets

12 Notes Payable – Bank

36 Notes Payable to Banks

39 Credit Card Balances

13 Notes Payable – Other

37 Notes Payable Relatives
38 Notes Payable other

14 Taxes Payable

96 Taxes Payable (Line 63)

16 TOTAL CURRENT LIABILITIES

42 Total Current Liabilities

18 Long Term Debt

44 Personal Residence Mortgage

45 Income Producing Mortgage

46 Partnership Mortgage

47 Other Mortgage

48 Long Term Debt – Auto

49 Long Term Debt – Per. Prop.

50 Long Term Debt – Other

19 Other Liabilities

51Other Liabilities

21TOTAL LIABILITIES

53 Total Liabilities

23 TOTAL EQUITY

55 Personal Net Worth

25 Salary & Wages

59 Salary & Wages

26 Other Income

60 Interest Income (Line 8)

61 Dividend Income (Line 9)

62 Tax Refund Line (10)

63 Alimony Received (Line 11)

64 Business Income (Line 12)

66 Capital Gains or Loss (Line 13)

67 Other Gains / Losses From 4797 (Line 14)

69 IRA Distributions (Line 15a)

70 Pensions and annuities

72 Rental RE, Partnerships, etc (Line 17)

74 Farm Income (Line 18, Schedule F)

76 Subtract the Adjusted Gross Income Expense (Lines 36)

89 Non Recurring Capital Gains/Losses

90 Non Taxable Social Security Income

92 Other Income, Expense, K-1, and other Adjustments

28 Total Income

Salary + Wages + Other Income

30 Living & Other Expenses

Sum of 99 (Personal Living Expense (FI Policy) +100 Other

31 Depreciation & Amortization

80 Business Depreciation (Sched C)

83 Rental Depreciation (Sched E)

86 Farm Depreciation (Sched F)

32 Interest Expense

81 Business Interest ( Sched C)

84 Rental Interest ( Sched E)

87 Farm Interest (Sched F)

97 Personal Interest Exp (Sched A Line 14)

33 Taxes

96 Taxes Payable (Line 63)

98 Taxes Paid (Sched A Line 9)

35 Cash Available to Service Debt

CFS Line 28 (Total Income) - Line 30 (Living and Other Expenses) + Line 31 (Depreciation & Amortization) + Line 32 (Interest Expense) - Line 33 (Taxes)

37 Personal Debt Payments

109 (Total All Payments) = 104 (Total Mortgage Payments) + 105 (Total Installment Payments) + 106 (Total Revolving Payments) + 107(Total Other Payments)