Balance Sheet: Name: Mary Sky

Download as xlsx, pdf, or txt
Download as xlsx, pdf, or txt
You are on page 1of 15

BALANCE SHEET

Name: Mary Sky

ASSET
Liquid Assets
Cash on hand $70
In checking 180
Saving accounts
650
Money market deposits with SW Savings
Certificates of deposit
Total Liquid Assets 900

Investments
Stocks 3,000
Bonds 500
Certificates of deposit
Mutual funds
Real estate
Retirement funds, IRA
Other
Total Investments 3,500

Real Property
Primary residence 68,000
Second home
Other
Total Real Property 68,000

Personal Property
Auto(s) 10,000
Auto(s)
Recreational vehicles
Houshold furnishings 1,050
Jewelry and artwork
Clothing 900
Other
Total Personal Property 11,950
(I) Total Assets 84,350
BALANCE SHEET
Date: 30-Jun-10

LIABILITIES
Current Liabilities
Utilities (Phones & Electricity) $90
Rent
Insurance premiums 220
Taxes 400
Medical/dental bills Scenario 1:
Repair bills

Bank credit card balances (Visa & 400


Mastercard)
Dept.store credit card balances 190 Scenario 2:

Travel and entertainment card balances

Gas and other credit card balances

Bank line of credit balances


Other current liabilities
Total Current Liabilities 1,300

Long-Term Liabilities
Primary residence mortgage 52,000
Second home mortgage

Real estate investment mortgage


Auto loans 3,000
Appliance/furniture loans 500
Home improvement loans
Single-payment loans
Education loans
Margin loans

Other long-term loans (from parents)


Total Long-Term Liabilities 55,500
(II) Total Liabilities 56,800
Net Worth (I) - (II) 27,550
Total liabilities and Net Worth 84,350
Ratio Analysis

Total net worth 27,550


Total assets 84,350
Solvency ratio 32.66%

Liquidy assets 900


Total current debts 1,300
Liquidity ratio 69.23%

Auto loans 3000


Furniture loans 500
Total installment loan payments 3500
Liquidity ratio 18.75%

Primary residence 68,000


Primary residence mortgage 52,000
Equity in dominant asset ($) 16,000
Equity in dominant asset (%) 23.53%
INCOME AND EXPENSE STATEMENT
Name: Jim & Beth Butler
For the year Ended:

INCOME
Wages and salaries Name: Beth
Name
Name
Self-employment income
Bonuses and commissions
Investment income Interest received
Dividends received
Rents received
Sales of securities
Other
Pensions and annuities
Other income Reimbursement for travel expenses
(I) Total Income
EXPENSES
Housing Rent/mortgage payment
(include insurance and taxes, if applicable)
Repairs, maintenance, improvments
Utilities Gas, electric, water
Phone
Cable TV and other
Food Groceries
Dining out
Transportation Autoloan payments
License plates, frees, etc.
Gas, oil, repairs, tires, maintenance
Medical Health, major medical, disability insurance
(payroll deduction or not provided by employer)
Clothing Clothes, shoes, and accessories
Insurance Homeowner's (if not covered by mortgage payment)
Life (not provided by employers)
Auto
Taxes Income and social security
Property (if not included in mortgage)
Applicances, furniture, and other Loan payments
major purhcases Purchase and repairs
Personal care Laundry, cosmetics, hair care
Recreation and entertainment Vacations
Other recreation and entertainment
Other items Jim's tuition, books, and supplies
Beth's travel expenses
Bonds in Beta Corporation
(II) Total Expenses
CASH SURPLUS (OR DEFICIT) [(I - II)]
ENT

31-Dec-10

$47,000

180

1,950
49,130

9,600

960

4,150 Used car's purchase cost 9,750


Oustanding loan bal. on car 7,300
2,450 Autooan payments 2,450

650

2,700

Cost of photographic equipment purchased 2,200


600 Amount paid to date on photographic equipment 1,600
Loan payments 600

280
3,300
1,950
4,900
31,540
17,590
Monthly Cash Budget Control
Name: Rodney Rain For the month: April

Monthly Cumulative
Amount Beginning
Item Amount Spent Surplus Surplus
Budgeted Balance
(Deficit) (Deficit)

Rent $550 $575 $50 ($25) $25


Untilities 150 145 15 5 20
Food 510 475 (45) 35 (10)
Auto 75 95 (25) (20) (45)
Recreation and entertainment 100 110 (50) (10) (60)
ANNUAL CASH BUDGET BY MONTH
Name(s)
For the

INCOME Jan. Feb. Mar Apr May Jun


Take-home pay 30,000,000
Bonuses and commission
Pensions and annuities
Investment income
Other income 8,000,000
(I) Total Income 38,000,000 0 0 0 0 0
EXPENSES
Housing (rent/mtge., repairs)
Utilities (phone, elec., gas, water) 1,000,000
Food (home and away) 10,000,000
Transportation (auto, public) 3,000,000
Medical/detal, incl. insurance
Clothing
Insurance (life, auto, home) 150,000,000
Taxes (property)
Appliances, furniture, and other
(purchases/loans)
Personal care
Recreation and entertainment
Savings and investments
Other expenses
Fun money
(II) Total Expenses 164,000,000 0 0 0 0 0

CASH SURPLUS (OR DEFICIT) (I)-(II) -126,000,000 0 0 0 0 0

CUMULATIVE CASH SURPLUS (OR D -126,000,000 ### 0 0 0 0


DGET BY MONTH

Ended

Total for
Jul Aug Sep Oct Nov Dec the Year

0 0 0 0 0 0 38,000,000

0 0 0 0 0 0 164,000,000

0 0 0 0 0 0 ###

0 0 0 0 0 0 0
BUDGET CONTROL SCHEDULE
Name(s)
For the 3

Month JANUARY

Budgeted Monthly Year-to-Date


Actual
Amount Variance Variance
(2)
(1) (3) (4)

INCOME
Take-home pay 48,000,000 20,000,000
Bonuses and commission
Pensions and annuities
Investment income 30,000,000 0
Other income 20,000,000 0
(I) Total Income 98,000,000 20,000,000 0 0
EXPENSES
Housing (rent/mtge., repairs)
Utilities (phone, elec., gas, water)
Food (home and away)
Transportation (auto, public)
Medical/detal, incl. insurance
Clothing
Insurance (life, auto, home)
Taxes (property)
Appliances, furniture, and other
(purchases/loans)
Personal care
Recreation and entertainment
Savings and investments
Other expenses
Fun money
(II) Total Expenses

CASH SURPLUS (OR DEFICIT) (I)-(II)

CUMULATIVE CASH SURPLUS (OR DEFICIT)


TROL SCHEDULE

Months Ended Mar-20

Month FEBRUARY Month MARCH

Year-to-
Budgeted Monthly Year-to-Date Budgeted Monthly
Actual Actual Date
Amount Variance Variance Amount Variance
(2) (2) Variance
(1) (3) (4) (1) (3)
(4)

48,000,000 48,000,000

30,000,000 30,000,000
20,000,000 20,000,000
98,000,000 0 0 0 98,000,000 0 0 0

You might also like