Embed
Email

Proposed Cash Flow - PNW Real Estate Blog

Document Sample

Shared by: linzhengnd
Categories
Tags
Stats
views:
2
posted:
11/14/2011
language:
English
pages:
3
Agent Name Date





Proposed Yearly Budget Sample 2011 2012 Federal Income Tax Rates 2012



Agent Gross Commission Income Goal $ 75,000.00 Tax Bracket Married Filing Jointly Single

15% Bracket $0 – $70,040 $0 – $35,020

Operational Expenses 28% Bracket $70,040 – $141,419 $35,020 – $84,872

Assistant Expense 31% Bracket $141,419 – $215,528 $84,872 – $177,006

Auto Expense 36% Bracket $215,528 – $384,860 $177,006 – $384,860

Gasoline $ 5,000.00 39.6% Bracket Over $384,860 Over $384,860

Insurance $ 400.00

Lease Payment $ 4,000.00 Oregon State Income Tax Rates 2012

Maintenance $ 1,000.00 Tax Bracket Married Filing Jointly and Single

Blog $ 100.00 9% Bracket $7,650 - $125,000

Brochures $ 200.00 10.8% Bracket $125,000 - $250,000

BrokerTec (Technology) $ 900.00 11% Bracket Over $250,000

Business Cards $ 340.00

Cell Phone $ 600.00 Notes

Client Gifts $ 250.00

Client Meals $ 250.00

Computer $ 300.00

Copy Expenses $ 500.00

Desk Fee

Education/Seminars/Convention $ 500.00

Forms $ 200.00

Insurance (Health) $ 6,000.00

Insurance (Business) $ 350.00

Lockboxes $ 500.00

Miscellaneous $ -

Non-Prudential Website $ -

Office Supplies $ 250.00

OREA $ 110.00

Photography $ 250.00

PMAR $ 400.00

Postage/Delivery $ 300.00

Print Advertising $ 500.00

Publications $ 500.00

RMLS $ 500.00

Signs

Post Instalation $ 500.00

Flyer Box $ 300.00

Post Removal $ 250.00

Sign Renewal (every 6 months) $ 150.00

Sign Riders $ 100.00

Transaction Coordination $ 500.00

Total Operating Expenses $ 26,000.00 $ - $ -

Expense Percentage of Income (Target 25-35%) 34.67% #DIV/0! #DIV/0!

Profit Before Taxes $ 49,000.00 $ - $ -

State Plus Federal Income Tax Rate 24% 24% 24%

Tax Savings $ 11,760.00 $ - $ -



Net Profit After Taxes $ 37,240.00 $ - $ -

Agent Name Date



Proposed Cash Flow Sample 2012 Federal Income Tax Rates 2012

Tax Bracket Married Filing Jointly Single

Estimated Number of Transaction Closed 12 24 15% Bracket $0 – $70,040 $0 – $35,020

% of business in Winter 10% 1 2 28% Bracket $70,040 – $141,419 $35,020 – $84,872

% of business in Spring 30% 4 7 31% Bracket $141,419 – $215,528 $84,872 – $177,006

36% Bracket $215,528 – $384,860 $177,006 – $384,860

% of business in Summer 40% 5 10

% of business in Fall 20% 2 5 39.6% Bracket Over $384,860 Over $384,860

******Must equal 100% 100% 12 24

Oregon State Income Tax Rates 2012

Tax Bracket Married Filing Jointly and Single

Average Agent Gross Commission Check $ 6,250.00 $ 6,250.00 9% Bracket $7,650 - $125,000

10.8% Bracket $125,000 - $250,000

Agent Gross Commission Income Goal $ 75,000.00 $ 150,000.00 11% Bracket Over $250,000



Estimated Operational Expenses 35% $ (26,000.00) $ (52,000.00) Notes



Estimated Income Before Taxes $ 49,000.00 $ 98,000.00



Average Agent Income Per Closing Before Taxes $ 4,083.33 $ 4,083.33



Average Tax Savings Per Closing 24% $ 980.00 $ 980.00



Average Agent Income After Taxes $ 3,103.33 $ 3,103.33



Approximate Monthly Cash Flow After Expenses

January $ 1,241.33 $ 2,482.67

February $ 1,241.33 $ 2,482.67

March $ 3,724.00 $ 7,448.00

April $ 3,724.00 $ 7,448.00

May $ 3,724.00 $ 7,448.00

June $ 4,965.33 $ 9,930.67

July $ 4,965.33 $ 9,930.67

August $ 4,965.33 $ 9,930.67

September $ 2,482.67 $ 4,965.33

October $ 2,482.67 $ 4,965.33

November $ 2,482.67 $ 4,965.33

December $ 1,241.33 $ 2,482.67

Annual Cash Flow After Expenses $ 37,240.00 $ 74,480.00

ACTIVE LISTING



GROSS AGENT COMPANY TRANSACTION TRANSITIONAL COORDINATOR AGENT NET SAVINGS OR TAKE HOME

FILE # LIST DATE CLIENT ADDRESS LIST PRICE SALES PRICE COMM. % GROSS PAY REF. % REFERRAL FEE PREA FEES TAX

COMMISSION SPLIT DOLLAR FEE YOUTH FEES COMMISSION GIFT PAY

$ - $ - $ - $ - $ - $ - $ - $ - $ -

$ - $ - $ - $ - $ - $ - $ - $ - $ -

$ - $ - $ - $ - $ - $ - $ - $ - $ -

$ - $ - $ - $ - $ - $ - $ - $ - $ -

$ - $ - $ - $ - $ - $ - $ - $ - $ -

$ - $ - $ - $ - $ - $ - $ - $ - $ -

$ - $ - $ - $ - $ - $ - $ - $ - $ -

$ - $ - $ - $ - $ - $ - $ - $ - $ -

Total $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ -





PENDING SALES



REF. REFERRAL GROSS AGENT COMPANY TRANSACTION TRANSITIONAL COORDINATOR AGENT NET SAVINGS OR TAKE HOME

FILE # EST. COE CLIENT ADDRESS LIST PRICE SALES PRICE COMM. % GROSS PAY PREA FEES TAX

% FEE COMMISSION SPLIT DOLLAR FEE YOUTH FEES COMMISSION GIFT PAY

$ - $ - $ - $ - $ - $ - $ - $ - $ -

$ - $ - $ - $ - $ - $ - $ - $ - $ -

$ - $ - $ - $ - $ - $ - $ - $ - $ -

$ - $ - $ - $ - $ - $ - $ - $ - $ -

$ - $ - $ - $ - $ - $ - $ - $ - $ -

Total $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ -





CLOSED TRANSACTIONS



CLOSED REF. REFERRAL GROSS AGENT COMPANY TRANSACTION TRANSITIONAL COORDINATOR AGENT NET SAVINGS OR TAKE HOME

FILE # CLIENT ADDRESS LIST PRICE SALES PRICE COMM. % GROSS PAY PREA FEES TAX

DATE % FEE COMMISSION SPLIT DOLLAR FEE YOUTH FEES COMMISSION GIFT PAY

$ - $ - $ - $ - $ - $ - $ - $ - $ -

$ - $ - $ - $ - $ - $ - $ - $ - $ -

$ - $ - $ - $ - $ - $ - $ - $ - $ -

$ - $ - $ - $ - $ - $ - $ - $ - $ -

$ - $ - $ - $ - $ - $ - $ - $ - $ -

$ - $ - $ - $ - $ - $ - $ - $ - $ -

$ - $ - $ - $ - $ - $ - $ - $ - $ -

$ - $ - $ - $ - $ - $ - $ - $ - $ -

$ - $ - $ - $ - $ - $ - $ - $ - $ -

$ - $ - $ - $ - $ - $ - $ - $ - $ -

$ - $ - $ - $ - $ - $ - $ - $ - $ -

$ - $ - $ - $ - $ - $ - $ - $ - $ -

$ - $ - $ - $ - $ - $ - $ - $ - $ -

$ - $ - $ - $ - $ - $ - $ - $ - $ -

$ - $ - $ - $ - $ - $ - $ - $ - $ -

$ - $ - $ - $ - $ - $ - $ - $ - $ -

$ - $ - $ - $ - $ - $ - $ - $ - $ -

$ - $ - $ - $ - $ - $ - $ - $ - $ -

$ - $ - $ - $ - $ - $ - $ - $ - $ -

$ -

Total $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ -

Average $ - $ - 0.00% $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ -



TAXE RATE 24.00%

SAVINGS/GIFT 10.00%

# OF CLOSED SALES 1



ONLY ENTER INFORMATION INTO A GREEN HI-LIGHTED



Related docs
Other docs by linzhengnd
i-Health
Views: 0  |  Downloads: 0
State employees recall events of September 11
Views: 7  |  Downloads: 0
0804050421330_2110
Views: 4  |  Downloads: 0
Listino2009 - Meetup
Views: 0  |  Downloads: 0
TwoSurveyCalculator
Views: 0  |  Downloads: 0
Guidelines.xlsx
Views: 0  |  Downloads: 0
APPALACHIA AND THE OZARKS
Views: 2  |  Downloads: 0
Proliferation Studies
Views: 0  |  Downloads: 0
By registering with docstoc.com you agree to our
privacy policy

You are almost ready to download!

You are almost ready to download!