Subscribe

How to run my state-of-the-art personal financial planner (also business model planner)

September 15th, 2011 Posted in personal financial planning

How to run my state-of-the-art personal financial planner (also business model planner)

Yes again, your energy technology and financial planning expert has done it again.

I am launching my top-of-the-line financial planner. It is used in creating your beginning balance sheet, then as you operate your company, forecast the income streams as well as expense streams to arrive at the ending balance sheet.

If there is a need to re-structure short-term and credit-card debt of high interest with longer-term debt of lower interest rate and longer repayment period, this financial model will help you decide the level of borrowing, or given your proposed longer-term borrowing, the model will provide the ending cash position (which is a balancing number and could be solved easily using the excel function “goal seek” which adjusts the cash position so that the variance between assets vs liabilities and equity is zero).

Here is a snap shot of my model.

Happy reading. And don’t fail to order now. Costs only US$999.

Please email me at this address to confirm your order.

Then use the DONATE button of my blog to pay the above amount:

www.energytechnologyexpert.com

Once PayPal confirms receipt of payment, I will then email you the excel model together with a word file containing simple instructions.

Alternatively, you may order via email, then pay to my bank account which I will email to you once I receive your confirmation / order. Upon receipt of payment by my bank, I will then email to you the excel model together with the instructions in a word file.

Hurry up.

Order now and learn to re-finance your expensive debt and GET OUT OF DEBT as QUICKLY as YOU CAN.

Or use this model to expand your expertise in personal financial planning.

Since we started using this model of mine, our sales in personal financial planning services zoomed to greater heights.

Email me now at:

mars_ocampo@yahoo.com

—– SUMMARY REPORTS: INCOME STATEMENT & BALANCE SHEET

 

INCOME STATEMENT (Jan – Dec 2010) – OMT Energy Enterprises
LOCAL CONSULTANCY 701,000
INTERNATIONAL CONSULTANCY 1,659,985
SOFTWARE SALES (LOANS & ACCOUNTING) 0
FINANCIAL MODEL SALES (WEBSITE) 0
 TOTAL GROSS INCOME 2,360,985
 TOTAL EXPENSES 942,510
 INCOME BEFORE TAX 1,418,475
LESS: PROVISION FOR INCOME TAX 418,912
 INCOME AFTER TAX 999,563
ADD: OTHER INCOME/(EXPENSES) W/ FINAL TAX 16,702
 PROFIT/(LOSS) 1,016,265
BALANCE SHEET (Dec 31, 2010) – OMT Energy Enterprises
ASSETS
Current Assets
  Cash 3,694,820
  Receivables, net 76,658
  Pre-paid Expenses 63,400
  Pre-operating Expenses 96,075
  Inventories 4,186
  Total Current Assets 3,935,138
Non-Current Assets
  Property & Equipment – net 570,639
  Total Non-Current Assets 570,639
TOTAL ASSETS 4,505,778
LIABILITIES & EQUITY
Current Liabilities
  Loans Payable – Rural Bank 0
  Loans Payable – Banks 1,042,105
  Notes Payable – Various 144,737
  Credit Cards Payable – Various 781,579
  Mitsubishi Adventure Car Loan Payable 0
  Other Payables - 668,921
  Advances from Shareholders 0
  Total Liabilities 2,637,342
EQUITY
  Proprietor’s Equity 970,000
  Paid-Up Capital 0
  Retained Earnings 0
  Current Income/(Loss) 898,436
  Total Equity 1,868,436
TOTAL LIABILITIES & EQUITY 4,505,778
VARIANCE 0

 

—– month-to-month calculations of debits and credits

 

INCOME STATEMENT (2010) Ave 2009 JAN Y-T-D FEB Y-T-D
LOCAL CONSULTANCY 0 0 26,000 26,000
INTERNATIONAL CONSULTANCY 0 0 125,000 125,000
SOFTWARE SALES (LOANS & ACCOUNTING) 0 0 0 0
FINANCIAL MODEL SALES (WEBSITE) 0 0 0 0
 TOTAL GROSS INCOME 0 0 151,000 151,000
VALUE ADDED TAX (LOCAL, SOFTWARE, MODEL) 0 0 3,900 3,900
TAXES, LICENSES & REGISTRATION 0 0 720 720
SALARIES & ALLOWANCES 0 0 15,350 15,350
13TH MONTH PAY & INCENTIVES 0 0 0
MANAGEMENT FEE – ACCOUNTANT 0 0 500 500
PROFESSIONAL FEE – LEGAL & AUDIT 0 0 500 500
ORGANIZATIONAL EXPENSES 0 0 0
SECURITY SERVICES 0 0 985 985
PAG-IBIG – ER 0 0 200 200
SSS – ER 0 0 1,080 1,080
PHIL-HEALTH – ER 0 0 175 175
TRANSPORTATION EXPENSE 0 0 470 470
REPRESENTATION EXPENSE 0 0 415 415
OFFICE SUPPLIES & STATIONARIES 0 0 390 390
OFFICE RENTAL 0 0 6,000 6,000
POSTAGE, TELEPHONE & TELEGRAM 0 0 1,000 1,000
ELECTRICITY, POWER & LIGHT 0 0 318 318
WATER, SEWERAGE & GARBAGE 0 0 174 174
GASOLINE & DIESEL 0 0 3,550 3,550
VEHICLE REPAIR & MAINTENANCE 0 0 0
OFFICE REPAIR & MAINTENANCE 0 0 0
INSURANCE EXPENSES (LIFE, NON-LIFE) 0 0 0
ACCOUNTING SYSTEM MAINTENANCE 0 0 500 500
BANK CHARGES 0 0 1,320 1,320
DONATIONS & CONTRIBUTIONS 0 0 400 400
MISCELLANEOUS, ADVERTISING & MEDICAL 0 0 0
AMORTIZATION – ORGANIZATIONAL EXPENSE 0 0 767 767
AMORTIZATION – PRE-OPERATING EXPENSE 0 0 6,646 6,646
DEPRECIATION EXPENSE 0 0 11,324 11,324
INTEREST EXPENSE – RURAL BANK 0 0 0
INTEREST EXPENSE – BANKS 0 0 0 0
INTEREST EXPENSE – NOTES 0 0 0 0
INTEREST EXPENSE – CREDIT 0 0 0 0
INTEREST EXPENSE – MITSUBISHI CAR LOAN 0 0 0 0
 TOTAL EXPENSES 0 0 56,682 56,682
 INCOME BEFORE TAX 0 0 94,318 94,318
LESS: PROVISION FOR INCOME TAX 0 0 13,364 13,364
 INCOME AFTER TAX 0 0 80,954 80,954
ADD: OTHER INCOME/(EXPENSES) W/ FINAL TAX 0 0 0 0
 PROFIT/(LOSS) 0 0 80,954 80,954
OK OK
BALANCE SHEET (2010) JAN Y-T-D FEB Y-T-D
PETTY CASH FUND 0 0 1,000 1,000
CASH IN BANK – CURRENT (> 50,000) 0 0 193,428 193,428
CASH IN BANK – SAVINGS 0 0 35,000 35,000
CASH ON HAND 32,809 32,809 2,191 35,000
INVESTMENTS 0 0 20,000 20,000
 TOTAL CASH 32,809 32,809 251,619 284,428
LOCAL CONSULTANCY RECEIVABLE 0 0 6,500 6,500
INTERNATIONAL CONSULTANCY RECEIVABLE 0 0 31,250 31,250
OTHER RECEIVABLES (SOFTWARE & MODELS) 0 0 0 0
TOTAL RECEIVABLE 0 0 37,750 37,750
RENT 46,000 46,000 46,000
SOFTWARE 30,000 30,000 -500 29,500
INSURANCES 0 0 0
OFFICE REPAIR & MAINTENANCE 0 0 0
 TOTAL PRE-PAID EXPENSES 76,000 76,000 -500 75,500
ORGANIZATIONAL EXPENSES 18,116 18,116 18,116
PRE-OPERATING EXPENSES 159,494 159,494 159,494
LESS AMORT – ORGANIZATIONAL EXPENSES 0 0 -767 -767
LESS AMORT – PRE-OPERATING EXPENSES 0 0 -6,646 -6,646
 TOTAL PRE-OPERATING EXPENSES 177,610 177,610 -7,412 170,197
 INVENTORY – OFFICE SUPPLIES 4,164 4,164 390 4,553
  TOTAL CURRENT ASSETS 290,583 290,583 281,846 572,429
FURNITURE & FIXTURES 15,087 15,087 15,087
OFFICE EQUIPMENT 107,000 107,000 107,000
VEHICLES 540,000 540,000 540,000
LEASEHOLD IMPROVEMENTS 17,330 17,330 17,330
 TOTAL FIXED ASSETS 679,418 679,418 0 679,418
LESS DEPN – FURNITURE & FIXTURES 0 0 -251 -251
LESS DEPN – OFFICE EQUIPMENT 0 0 -1,783 -1,783
LESS DEPN – VEHICLES 0 0 -9,000 -9,000
LESS DEPN – LEASEHOLD IMPROVEMENTS 0 0 -289 -289
 TOTAL DEPN – FIXED ASSETS 0 0 -11,324 -11,324
  TOTAL NON-CURRENT ASSETS (FIXED NET) 679,418 679,418 -11,324 668,094
   TOTAL ASSETS 970,000 970,000 270,522 1,240,522
LOANS PAYABLE – RURAL BANK (20%, 36 MO) 0 0 0
LOANS PAYABLE – BANKS (16%, 48 MO) 0 0 94,737 94,737
NOTES PAYABLE – VARIOUS (2.5% PER MONTH) 0 0 13,158 13,158
CREDIT CARD PAYABLE (3.5% PER MONTH) 0 0 71,053 71,053
MITSUBISHI ADVENTURE CAR LOAN 0 0 0
 INTEREST PAYABLE – RURAL BANK 0 0 0 0
 INTEREST PAYABLE – BANKS 0 0 0 0
 INTEREST PAYABLE – NOTES 0 0 0 0
 INTEREST PAYABLE – CREDIT 0 0 0 0
 INTEREST PAYABLE – ADVENTURE CAR LOAN 0 0 0
 INCOME TAX PAYABLE 0 0 13,364 13,364
 WITHHOLDING TAX PAYABLE – COMPENSATION 0 0 1,535 1,535
 WITHHOLDING TAX PAYABLE – EXPANDED 0 0 100 100
 WITHHOLDING TAX PAYABLE – FINAL 0 0 0
 VALUE ADDED TAX PAYABLE 0 0 3,900 3,900
 ACCRUED EXPENSES 0 0 0
 PROVISION FOR 13TH MO. PAY & INCENTIVES 0 0 1,395 1,395
 OTHER ACCOUNTS PAYABLE 0 0 0
 HDMF PAG-IBIG – ER & EE 0 0 400 400
 SSS CONTRIBUTION – ER & EE 0 0 2,160 2,160
 PHIL-HEALTH – ER & EE 0 0 350 350
 TOTAL OTHER PAYABLES 0 0 23,204 23,204
  TOTAL CURRENT LIABILITIES 0 0 202,151 202,151
ADVANCES FROM CLIENTS 0 0 0
ADVANCES FROM MTO 0 0 0
 TOTAL DEFERRED CHARGES 0 0 0 0
  TOTAL LIABILITIES 0 0 202,151 202,151
MTO CAPITAL 970,000 970,000 970,000
DEPOSITS FOR SUBSCRIPTION 0 0 0
PAID-UP CAPITAL 0 0 0
RETAINED EARNINGS 0 0 0
CURRENT EARNINGS 0 0 80,954 80,954
  TOTAL EQUITY 970,000 970,000 80,954 1,050,954
   TOTAL LIABILITIES & EQUITY 970,000 970,000 283,106 1,253,106
VARIANCE 0 0 (12,583) (12,583)
OK OK ERROR ERROR
100%
 Local project 1 26,000 26,000
 Local project 2 75,000
 Local project 3 150,000
 Local project 4 450,000
LOCAL CONSULTANCY 701,000 26,000
50%
  Foreign project 1 250,000 125,000
  Foreign project 2 796,725
  Foreign project 3 613,260
INTERNATIONAL CONSULTANCY 1,659,985 125,000
GRAND TOTAL 2010 = P 2,360,985 2,360,985 151,000
SOFTWARE SALES (LOANS & ACCOUNTING)
FINANCIAL MODEL SALES (WEBSITE)
Total Taxable Income 0.00 94,317.96
Tax Due 0.00 13,363.59
Income Tax Payable 13,363.59
Basic Tax 0.00 8,500.00
Over 0.00 70,000.00
Excess 0.00 24,317.96
Plus Tax Rate 0% 20%
Plus Tax 0.00 4,863.59

 

—– INITIAL DATA AND INCOME TAX RATE TABLE

 

Advanced Rental & Deposit per month
2 months deposit rental, Dona Enriqueta 14,000.00 233.33
1 month advance rental, Dona Enriqueta 7,000.00 116.67
Light deposit, Dona Enriqueta 2,000.00 33.33
Water deposit, Dona Enriqueta 1,000.00 16.67
Light deposit, Dona Enriqueta (refunded) -2,000.00 -33.33
2 months deposit rental – Verde Oro 12,000.00 200.00
2 month advance rental – Verde Oro 12,000.00 200.00
46,000.00 ok 766.67
Office Furniture, Equipment, Improvements
Furniture & Fixture (Chairs & Tables) 15,087.25 ok 251.45
Office Equipment (Safe, A/C, Ref, Computer, Printer, Fax, Tel, Stapler) 107,000.00 ok 1,783.33
Leasehold Improvements (office repairs) 17,330.25 ok 288.84
Initial Inventory – Office Supplies 4,163.50 ok
143,581.00 2,323.62
Organizational & Registration Expenses
  DTI Business Name 370.00 6.17
  SEC Registration 0.00 0.00
  BIR Registration 2,825.50 47.09
  Mayor Business Permit 13,520.00 225.33
  Barangay Clearance 1,400.00 23.33
18,115.50 ok 301.93
Donated Capital
Honda Civic (2001, 10 yrs life) 360,000.00 ok 6,000.00
L-300 Van (1994, 15 yrs life) 180,000.00 ok 3,000.00
540,000.00 9,000.00
General Ledger Accounting Software (2 yrs) 30,000.00 ok 500.00
570,000.00
Other Pre-Operating Expenses
  Salaries & Wages 25,500.00
  Professional Fees (management, accountant, legal, audit) 0.00
  Office Rent (Dona Enriqueta, Verde Oro) 69,440.00
  HR, Admin, Janitorial 0.00
  Company Share (HDMF, SSS, PH) 0.00
  Transportation Expense 680.50
  Representation & Entertainment (Meals, Lunch, Gifts) 12,940.97
  Taxes & Licenses 0.00
  Telephone (PLDT Dona Enriqueta, PLDT Verde Oro, Celfone) 10,778.49
  Electricity (Meralco) 945.45
  Water 1,107.56
  Security 1,969.42
  Gasoline, Diesel & Lubes 19,120.00
  Vehicle Repair & Maintenance 13,494.59
  Bank Charges 1,320.00
  Miscellaneous Expenses 2,197.25
159,494.23 ok 6,645.59
Cash on Hand 32,809.27
TOTAL Pre-Operating Capital 970,000.00
Actual Cash 400,000.00
BIR Income Tax Table Basic Tax Plus Tax Over
not over P10,000 0.00 5% 0.00
Over P10,000 but not over P30,000 500.00 10% 10,000.00
Over 30,000 but not over P70,000 2,500.00 15% 30,000.00
Over P70,000 but not over P140,000 8,500.00 20% 70,000.00
Over P140,000 but not over P250,000 22,500.00 25% 140,000.00
Over P250,00 but not over P500,000 50,000.00 30% 250,000.00
Over P500,000 125,000.00 32% 500,000.00

 

—–

 

6 Responses to “How to run my state-of-the-art personal financial planner (also business model planner)”

  1. Lee Says:

    Hello! I simply wish to give a huge thumbs up for the nice information you’ve gotten here on this post. I will be coming again to your blog for extra soon.



  2. http://localbramptonaccountant.com Says:

    I have read so many posts on the topic of the blogger lovers however
    this paragraph is truly a nice article, keep it up.



  3. http://www.dailymotion.com/video/x17722n_buy-youtube-views-cheaply-with-like-and-comments_webcam Says:

    Have you ever thought about creating an e-book or guest authoring on other blogs?
    I have a blog based upon on the same subjects you discuss and would
    really like to have you share some stories/information.
    I know my readers would enjoy your work. If you are even remotely interested, feel free to send
    me an e mail.



  4. dailymotion.com Says:

    I blog quite often and I genuinely thank you for your content.
    This great article has really peaked my interest.
    I am going to bookmark your website and keep checking for new details about once a week.

    I opted in for your RSS feed too.



  5. Http://Www.Dailymotion.Com/Video/X17722N_Buy-Youtube-Views-Cheaply-With-Like-And-Comments_Webcam Says:

    Incredible! This blog looks exactly like my old one! It’s on a totally different subject but it has pretty much the same page layout and design.
    Wonderful choice of colors!



  6. www.dailymotion.com Says:

    This paragraph will assist the internet
    people for building up new web site or even a weblog from start to end.



Leave a Reply

XHTML: You can use these tags: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>