Docsity
Docsity

Prepare for your exams
Prepare for your exams

Study with the several resources on Docsity


Earn points to download
Earn points to download

Earn points by helping other students or get them with a premium plan


Guidelines and tips
Guidelines and tips

Personal Financial Statement Worksheet (5).xlsx, Study notes of Financial Statement Analysis

PERSONAL FINANCIAL STATEMENT WORKSHEET. NAME: AS OF: ASSETS. Estimated. Line #. Fair Market. Value. 1. Cash on Hand. $. 2. Cash in Bank (Schedule A).

Typology: Study notes

2022/2023

Uploaded on 05/11/2023

shachi_984a
shachi_984a 🇺🇸

4.6

(15)

222 documents

1 / 8

Toggle sidebar

This page cannot be seen from the preview

Don't miss anything!

bg1
PERSONAL FINANCIAL STATEMENT WORKSHEET
NAME:
AS OF:
ASSETS Estimated
Line # Fair Market
Value
1. Cash on Hand $
2. Cash in Bank (Schedule A) -
3. Notes & Contracts Receivable (Schedule B) -
4. Stocks, Bonds & Mutual Funds - Listed (Schedule C) -
5. Stocks & Bonds - Unlisted (Schedule D) -
6. Real Estate & Buildings (Schedule E) -
7. Machinery & Equipment (Costs $ )
8. Furniture, Fixtures & Personal Property (Schedule F) -
9. Auto & Trucks (Schedule G) -
10. Cash Value of Life Insurance
11. IRA Funds (Schedule H) -
12. Qualified Retirement Plans (Schedule I) -
OTHER ASSETS (Describe)
13.
14
.
15
.
TOTA
L
ASSETS
-
$
LIABILITIES
16. Credit Cards & Installation Purchases (Schedule J) -$
17. Notes & Contracts Payable (Schedule K) -
18. Mortgages & Contracts on Real Estate (Schedule E) -
19. Auto & Truck Loans (Schedule G) -
OTHER LIABILITIES (Describe)
20
.
21.
22.
TOTAL LIABILITIE
S
-
NET
WORTH
-
$
Fill the attached schedules and
the line items on page 1 will
calculate.
0
0
0
0
0
0
0
0
0
0
0
0
0
pf3
pf4
pf5
pf8

Partial preview of the text

Download Personal Financial Statement Worksheet (5).xlsx and more Study notes Financial Statement Analysis in PDF only on Docsity!

PERSONAL FINANCIAL STATEMENT WORKSHEET

NAME:

AS OF:

ASSETS Estimated

Line # Fair Market

Value

1. Cash on Hand $

2. Cash in Bank (Schedule A) -

3. Notes & Contracts Receivable (Schedule B) -

4. Stocks, Bonds & Mutual Funds - Listed (Schedule C) -

5. Stocks & Bonds - Unlisted (Schedule D) -

6. Real Estate & Buildings (Schedule E) -

7. Machinery & Equipment (Costs $ )

8. Furniture, Fixtures & Personal Property (Schedule F) -

9. Auto & Trucks (Schedule G) -

10. Cash Value of Life Insurance

11. IRA Funds (Schedule H) -

12. Qualified Retirement Plans (Schedule I) -

OTHER ASSETS (Describe)

TOTAL ASSETS $ -

LIABILITIES

16. Credit Cards & Installation Purchases (Schedule J) $ -

17. Notes & Contracts Payable (Schedule K) -

18. Mortgages & Contracts on Real Estate (Schedule E) -

19. Auto & Truck Loans (Schedule G) -

OTHER LIABILITIES (Describe)

TOTAL LIABILITIES -

NET WORTH $ -

Fill the attached schedules and

the line items on page 1 will

calculate.

SCHEDULE A

CASH IN BANK

Show all Checking, Savings, Certificates, Etc.

* Type (1) Checking, (2) Savings, (3) Time Certificate

BANK NAME/ BRANCH *TYPE INTEREST

RATE

MATURITY DATE AMOUNT

TOTAL TO LINE 2 $ -

SCHEDULE B

NOTES & CONTRACTS RECEIVABLE

DUE FROM (NAME) DATE OF BALANCE TERMS & DUE DESCRIPTION OF

OBLIGATION ORIGINAL PRESENT INT. RATE DATE COLLATERAL IF ANY

TOTAL TO LINE 3 $ -

SCHEDULE C

STOCKS, BONDS & MUTUAL FUNDS

NO. OF SHARES

DESCRIPTION - RATE - MATURITY,

IF PLEDGED TO WHOM ORIGINAL COST^ MARKET VALUE

TOTAL TO LINE 4 $ -

SCHEDULE D

STOCKS & BONDS - UNLISTED

NO. OF SHARES

DESCRIPTION - RATE - MATURITY,

IF PLEDGED TO WHOM ORIGINAL COST^ MARKET VALUE

TOTAL TO LINE 5 $ -

SCHEDULE H

IRA FUNDS (TRADITIONAL & ROTH)

OWNER DESCRIPTION - RATE - MATURITY MARKET VALUE

TOTAL TO LINE 11 $ -

SCHEDULE I

QUALIFIED RETIREMENT PLANS

OWNER DESCRIPTION - RATE - MATURITY ORIGINAL COST MARKET VALUE

TOTAL TO LINE 12 $ -

SCHEDULE J

CREDIT CARDS & INSTALLATION PURCHASES

DUE TO DATE BALANCE TERMS & DUE DESCRIPTION OF

(NAME) INCURRED ORIGINAL PRESENT INT. RATE DATE COLLATERAL IF ANY

TOTAL TO LINE 16 $ -

SCHEDULE K

NOTES & CONTRACTS PAYABLE

DUE TO DATE BALANCE TERMS & DUE DESCRIPTION OF

(NAME) INCURRED ORIGINAL PRESENT INT. RATE DATE COLLATERAL IF ANY

TOTAL TO LINE 17 $ -

TRADITIONAL OR

ROTH?

Do you have any current or pending judgments, suits or liabilities other

then those mentioned above? Yes No

If yes, give details and the amount or expected amount of liability.

GENERAL INFORMATION :

BIRTHDAY AGE SOCIAL SECURITY#

(H)

(W)

(CH)

EMPLOYMENT

HUSBAND

Employer

Position

Salary

Other Income: Source

Amount

WIFE

NAME

INSURANCE INFORMATION

Insurance Advisers

Name

Addresses

Life Insurance (include group)

LOANS

PERSON FACE TYPE OF ANNUAL CASH OUT- NET

INSURED INSURER AMOUNT POLICY PREMIUM VALUE STANDING AMOUNT

Disability Insurance (include group)

COVERAGE

PERSON INSURER/ ANNUAL 1ST MO. NEXT 4 MO. AFTER 5 MONTHS

INSURED SOURCE PREMIUM COVERAGE COVERAGE WITH DEPENDENTS

Total Estimated Monthly Income

From Disability Insurance: $ -

Health/Medical Insurance: Limits of Coverage (annual)

PERSON ANNUAL "BASIC" HOSPITAL MAJOR MEDI- OTHER

INSURED PREMIUM AND SURGICAL MEDICAL CARE COVERAGE

Comments:

MONTHLY INCOME & EXPENSE

GROSS INCOME PER MONTH 8. Entertainment & Recreation Salary Eating Out Interest Baby Sitters Dividend Activities / Trips Other Vacation

  • Other

LESS:

  1. Tax 9. Clothing (Est. - Incl. Fed., State, FICA)
  2. Savings
  3. Charitable Gifts
  4. Medical Expenses NET SPENDABLE INCOME - Doctor Dentist
  5. Housing Drugs Mortgage (rent) Other Insurance - Taxes Electricity (^) 12. Miscellaneous Gas Toiletry, cosmetics Water Beauty, barber Sanitation Laundry, cleaning Tele/Internet/Cell Allowance, lunches Maintenance Subscriptions Other Gifts (incl. Christmas)
  • Cash Other
  1. Food -
  2. Automobiles(s) 13. School / Child Care Payments Tuition Gas & Oil Materials Insurances Transportation License / Taxes Day Care Maint / Repair / Replace -
  1. Investments
  2. Insurance Life TOTAL EXPENSES - Medical Other INCOME VS EXPENSE
  • Net Spendable Income - Less Expenses -
  1. Debts Credit Card Loans & Notes Other (^) 15. Unallocated Surplus Income -

Modified From A Similar Spreadsheet Found In "The Family Budget Workbook" by Larry Burkett, Northfield Publishing, 1993.