home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
Shareware Overload
/
ShartewareOverload.cdr
/
finance
/
solvedoc.zip
/
BUDGET.RPT
< prev
next >
Wrap
Text File
|
1991-02-10
|
9KB
|
187 lines
==================================================
BUDGET
For: Robert Smith, Jr.
Initial Cash Balance: 2,000.00
As of: 2/10/91
==================================================
(** This is a sample with just the month of February **)
(** We put these comments here with an editor **)
(** Remember, YOU can change the description of any category **)
(** When printed within SOLVEIT!, budget fits on ONE PAGE per MONTH **)
Prepared By : I.M. Smart
BUDGET FOR THE MONTH OF FEB
INCOME/RECEIPTS BUDGETED % INC ACTUAL % BUD
_______________ ________ _____ ______ _____
Salaries: 4,500.00 89.1 5,000.00 111.1
Pensions, Allowances: 0.00 0.0 0.00 0.0
Interest Income: 300.00 5.9 300.00 100.0
Real Estate Income: 250.00 5.0 200.00 80.0
Other Income: 0.00 0.0 0.00 0.0
Loan Advances: 0.00 0.0 0.00 0.0
MONTHLY INCOME: 5,050.00 100.0 5,500.00 108.9
======================================================================
EXPENSES/PAYMENTS BUDGETED % INC ACTUAL % BUD
_________________ ________ _____ ______ _____
Mortgage/Rent Payment: 750.00 14.9 750.00 100.0
House Taxes: 0.00 0.0 0.00 0.0
House Insurance: 345.00 6.8 345.00 100.0
Electric, Gas & Water: 115.00 2.3 145.00 126.1
Telephone: 65.00 1.3 75.00 115.4
Home Maintenance: 300.00 5.9 225.00 75.0
Furniture, Appliances: 0.00 0.0 135.00 ***.*
Shelter: 1,575.00 31.2 1,675.00 106.3
Car Payments: 350.00 6.9 350.00 100.0
Gas & Oil: 75.00 1.5 65.00 86.7
Car Ins., Lic., Etc.: 85.00 1.7 0.00 0.0
Repairs & Maintenance: 75.00 1.5 0.00 0.0
Bus, Taxi, Park, Etc.: 0.00 0.0 0.00 0.0
Transportation: 585.00 11.6 415.00 70.9
Health Insurance: 0.00 0.0 0.00 0.0
Medicine, Glasses Etc: 50.00 1.0 65.00 130.0
Doctor, Dentist Fees: 50.00 1.0 45.00 90.0
Personal Grooming: 35.00 0.7 40.00 114.3
Health/Personal Care: 135.00 2.7 150.00 111.1
Groceries: 350.00 6.9 375.00 107.1
Restaurant Meals: 75.00 1.5 70.00 93.3
Clothing/Laundry: 50.00 1.0 50.00 100.0
Food & Clothing: 475.00 9.4 495.00 104.2
Vacation & Travel: 125.00 2.5 125.00 100.0
Club Membership Fees: 20.00 0.4 0.00 0.0
Movie/Show/Sport Etc.: 30.00 0.6 27.00 90.0
Entertaining: 40.00 0.8 50.00 125.0
Education, Books: 25.00 0.5 30.00 120.0
Babysitting & Care: 30.00 0.6 25.00 83.3
Recreation/Education: 270.00 5.3 257.00 95.2
Life Insurance: 30.00 0.6 0.00 0.0
Loan Payments: 300.00 5.9 275.00 91.7
Charitable Gifts: 35.00 0.7 35.00 100.0
Liquor & Cigarettes: 0.00 0.0 0.00 0.0
Miscellaneous: 50.00 1.0 50.00 100.0
Savings, I.R.A.'s Etc: 150.00 3.0 150.00 100.0
Other Expenses: 565.00 11.2 510.00 90.3
MONTHLY EXPENSES: 3,605.00 71.4 3,502.00 97.1
======================================================================
SURPLUS/DEFICIT (-) 1,445.00 1,998.00
======================================================================
B U D G E T S U M M A R Y
INCOME AND EXPENSE ANALYSIS
Actual vs
INCOME (excluding loan advances) Projected Actual Projected
Salaries: 4,500.00 5,000.00 111%
Pensions, Allowances: 0.00 0.00 0
Interest Income: 300.00 300.00 100
Real Estate Income: 250.00 200.00 80
Other Income: 0.00 0.00 0
TOTAL INCOME: 5,050.00 5,500.00 109
Actual vs
EXPENSES (excluding savings) Projected Actual Projected
Shelter: 1,575.00 1,675.00 106
Transportation: 585.00 415.00 104
Health/Personal Care: 135.00 150.00 111
Food & Clothing: 475.00 495.00 71
Recreation/Education: 270.00 257.00 95
Other Expenses: 415.00 360.00 87
TOTAL EXPENSES: 3,455.00 3,352.00 97
PROJECTED CASH FLOW ANALYSIS
Cash Cash Monthly
Month Inflows Outflows Difference Balance
Initial Balance: 2,000.00
FEB 5,050.00 3,605.00 1,445.00 3,445.00
MAR 0.00 0.00 0.00 3,445.00
APR 0.00 0.00 0.00 3,445.00
MAY 0.00 0.00 0.00 3,445.00
JUNE 0.00 0.00 0.00 3,445.00
JULY 0.00 0.00 0.00 3,445.00
AUG 0.00 0.00 0.00 3,445.00
SEP 0.00 0.00 0.00 3,445.00
OCT 0.00 0.00 0.00 3,445.00
NOV 0.00 0.00 0.00 3,445.00
DEC 0.00 0.00 0.00 3,445.00
JAN 0.00 0.00 0.00 3,445.00
ACTUAL CASH FLOW ANALYSIS
Cash Cash Monthly
Month Inflows Outflows Difference Balance
Initial Balance: 2,000.00
FEB 5,500.00 3,502.00 1,998.00 3,998.00
MAR 0.00 0.00 0.00 3,998.00
APR 0.00 0.00 0.00 3,998.00
MAY 0.00 0.00 0.00 3,998.00
JUNE 0.00 0.00 0.00 3,998.00
JULY 0.00 0.00 0.00 3,998.00
AUG 0.00 0.00 0.00 3,998.00
SEP 0.00 0.00 0.00 3,998.00
OCT 0.00 0.00 0.00 3,998.00
NOV 0.00 0.00 0.00 3,998.00
DEC 0.00 0.00 0.00 3,998.00
JAN 0.00 0.00 0.00 3,998.00
SAVINGS AND LOAN SUMMARY
Actual Regular Savings: 150.00
Actual Loan Advances: 0.00
Projected Regular Savings: 300.00
Projected Loan Advances: 0.00