Want More Free Business Planning Templates? Visit us at http://www.thefinance
This Microsoft Excel Financial model has been created for you to use in conjunction wi preparation of financial statements.
A working knowledge of Excel and financial templates is not needed to use this applica each section has informative and instructional use blurbs to help you navigate the work
DISCLAIMER - TheFinanceResource.com, Its parent companies, subsidiaries, affiliate partners take no responsibility for the use or accuracy of the financial statements creat application. You are SOLELY responsible to ensure that any financial statements creat personal use or business use are correct and without error. TheFinanceResource.com parent companies, subsidiaries, affiliates, partners, or any other related TheFinanceRe party hereby disclaims itself from any liability resulting from the use of this financial mo
We STRONGLY RECOMMEND that you consult a certified public accountant or attorn within your juirisdiction/location before using any of these financial statements for busin purposes, submission to a third party, or reliance for financial decisision.
There - its been said. Enjoy the financial model!
es? Visit us at http://www.thefinanceresource.com
ated for you to use in conjunction with the
ates is not needed to use this application, and blurbs to help you navigate the workbook.
ent companies, subsidiaries, affiliates, and acy of the financial statements created in this e that any financial statements created for out error. TheFinanceResource.com.com, its , or any other related TheFinanceResource.com ting from the use of this financial model.
a certified public accountant or attorney licensed f these financial statements for business or financial decisision.
Want More Free Business Planning Templa
Capital Structure How much money are you looking to raise? Bank Loan or Equity Investment (Enter 1 for Loan 2 for Investment) If Bank Loan, how many years (term) will be the repayment period? What is the expected interest rate on the loan? How much money will you contribute to the business venture? What is the startup year of this business venture?
$150,000 1 10 9.00% $50,000 2009
Revenues How much revenue do you anticipate in your first year of operations? What is your expected yearly revenue growth rate? (in percentage) Name the first type of product or service you offer: What is the gross margin for this product/service? What percentage of revenues will this revenue center account for? Name the second type of product of service you offer: What is the gross margin for this product/service? What percentage of revenues will this revenue center account for? Name the third type of product or service you offer? What is the gorss margin for this product/service? What percentage of revneues will this revenue center account for? Costs - Enter the Names of Seven Categories of Costs You will Have: Rent Utilities Marketing General and Administrative Professional Fees Licensure Misc. Expenses Questions About Costs What percentage increase will Cost Category 1 have per year? What percentage increase will Cost Category 2 have per year? What percentage increase will Cost Category 3 have per year? What percentage increase will Cost Category 4 have per year? What percentage increase will Cost Category 5 have per year? What percentage increase will Cost Category 6 have per year? What percentage increase will Cost Category 7 have per year?
$750,000 7.00% Computer Sales 60.00% 50.00% Computer Repairs 90.00% 30.00% Software Sales 60.00% 20.00%
$25,000 $5,000 $10,000 $7,500 $3,500 $1,000 $200
3.00% 3.00% 5.00% 6.00% 3.00% 1.00% 2.00%
Employees How Many Employees will you have in Year 1 How Many Employees will you have in Year 2 How Many Employees will you have in Year 3 What percentage will wages increase every year? How much will you spend on Payroll in Year 1? What is the expected Payroll Taxes (in percent) you expect to face? Taxes What will be your federal income tax rate? What will be your state income tax rate? Asset Purchases - What will you be buying? - Enter 4 Categories FF&E Computers Vehicles Other Assets How long (on average) in years will these assets last? Reinvestment into the Company What percentage of your cash flow will you reinvest into your business? What percentage of your cash flow will you distribute as profits? What percentage of reinvestment will go into Asset Category 1 What percentage of reinvestment will go into Asset Category 2 What percentage of reinvestment will go into Asset Category 3 What percentage of reinvestment will go into Asset Category 4
3 4 5 3.00% $200,000 14.00%
33.00% 5.00%
$25,000 $30,000 $60,000 $35,000 7
25.00% 65.00% 15.00% 35.00% 40.00% 10.00%
Business Planning Templates? Visit us at http://www.thefinanceresource.com
Remember! Answer All of the Questions!
If seeking an investment, you do not need to modify loan terms!
Lines 26, 30, and 34 must equal 100%
Do Not Enter Payroll Costs Here
These four lines must equal 100%
Want More Free Business Planning Templates? Visit us a
Financing Equity Financing Owner Contribution Investor Contribution Total Equity Capital Debt Financing Bank Loan Total Debt Capital Total Capital
Asset Purchases FF&E Computers Vehicles Other Assets Total Asset Purchases
Loan Capital 150000
Business Planning Templates? Visit us at http://www.thefinanceresource.com
You do not need to input anything! It's already done!
$50,000 $0 $50,000 $150,000 $150,000 $200,000
$25,000 $30,000 $60,000 $35,000 $150,000
Loan Capital Investor 150000 0
Want More Free Business Planning Templates? Visit us at http://ww
Proforma Profit and Loss Statements Year Revenue Cost of Goods Sold Operating Income Operating Expenses Payrolls Rent Utilities Marketing General and Administrative Professional Fees Licensure Misc. Expenses Payroll Expenses Total Expenses EBITDA Federal Taxes State Taxes Interest Expenses Depreciation Net Income Profit Margin (%) $200,000 $25,000 $5,000 $10,000 $7,500 $3,500 $1,000 $200 $28,000 $280,200 $237,300 $78,309 $11,865 $13,107 $21,429 $112,591 15.01% 2009 $750,000 $232,500 $517,500
Templates? Visit us at http://www.thefinanceresource.com
2010 $802,500 $248,775 $553,725
2011 $858,675 $266,189 $592,486
Profit and Loss Statement
$900,000 $800,000 $700,000 $600,000 $500,000
$206,000 $25,750 $5,150 $10,500 $7,950 $3,605 $1,010 $204 $28,840 $289,009 $264,716 $87,356 $13,236 $12,197 $21,429 $130,498 16.26%
$212,180 $26,523 $5,305 $11,025 $8,427 $3,713 $1,020 $208 $29,705 $298,106 $294,380 $97,145 $14,719 $11,202 $21,429 $149,885 17.46%
$400,000
$300,000 $200,000 $100,000 $0 2009 2010 Years 2011
Nothing to Edit On This Page
Revenue
Total Expenses
Net Income
Want More Free Business Planning Templates? Visit us a
Proforma Cash Flow Analysis Year Cash Inflows Cash Inflow from Operations Depreciation Equity Investment Increased Borrowings Accounts Payable Decreased Accounts Receivables Total Cash Inflows Cash Out Flows Repayment of Principal Decreased Accounts Payable Increased Accounts Receivable Shareholder Payouts Asset Purchases Total Cash Out Flows Net Cash Flow Cash Balance
Cash Flow Analysis
$400,000 $350,000 $300,000 $250,000 $200,000 $150,000 $100,000 $50,000 $0 2009 2010 Years
ess Planning Templates? Visit us at http://www.thefinanceresource.com
2009 $134,019 21428.57143 $50,000 $150,000 $8,000 $0 $363,448
2010 $151,927 21428.57143 $0 $0 $10,000 $0 $183,355
2011 $171,313 21428.57143 $0 $0 $12,000 $0 $204,742
You can edit the AR and AP lines on this page….. Everything else has been automatically calculated.
$9,695 $6,000 $0 $101,041 $150,000 $266,736 $96,712 $96,712
$10,605 $8,000 $0 $112,681 $43,339 $174,624 $8,731 $105,443
$11,202 $10,000 $0 $125,282 $48,186 $194,670 $10,072 $115,515
Cash Flow Analysis
Total Cash Inflows Total Cash Out Flows Net Cash Flow
2010 Years
2011
ines on this
Want More Free Business Planning Templates? Visit us at http://www.the
Proforma Balance Sheet Year Assets Cash FF&E Computers Vehicles Other Assets Accumulated Depreciation Total Assets Liabilities Accounts Payable Long Term Liabilities Other Liabilities Total Liabilities Equity $2,000 $140,305 $0 $142,305 $82,978 $4,000 $129,700 $0 $133,700 $122,224 $96,712 $25,000 $30,000 $60,000 $35,000 ($21,429) $225,283 $105,443 $31,501 $45,169 $77,336 $39,334 ($42,857) $255,924 2009 2010
Balance Sheet
$300,000 $250,000 $200,000 $150,000 $100,000 $50,000 $0 2009 2010 Years 2011
ates? Visit us at http://www.thefinanceresource.com
2011
Nothing to Edit on this Page!
$115,515 $38,729 $62,034 $96,610 $44,152 ($64,286) $292,753
It's all done for you!
$6,000 $118,101 $0 $124,101 $168,652
Total Assets Total Liabilities Equity
Want More Free Business Planning Templates? Visit us at h
Inputs Loan Amount Interest Rate Loan Term (in Years) Number of Payments Per Year
$150,000 9.00% 10 12
Outputs Expected Payment Total Interest Paid
Payment Number 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32
Payment Amount $1,900 $1,900 $1,900 $1,900 $1,900 $1,900 $1,900 $1,900 $1,900 $1,900 $1,900 $1,900 $1,900 $1,900 $1,900 $1,900 $1,900 $1,900 $1,900 $1,900 $1,900 $1,900 $1,900 $1,900 $1,900 $1,900 $1,900 $1,900 $1,900 $1,900 $1,900 $1,900
Principal Payment $775 $781 $787 $793 $799 $805 $811 $817 $823 $829 $835 $842 $848 $854 $861 $867 $874 $880 $887 $893 $900 $907 $914 $920 $927 $934 $941 $948 $956 $963 $970 $977
Interest Payment $1,125 $1,119 $1,113 $1,107 $1,101 $1,095 $1,089 $1,083 $1,077 $1,071 $1,065 $1,059 $1,052 $1,046 $1,040 $1,033 $1,027 $1,020 $1,013 $1,007 $1,000 $993 $987 $980 $973 $966 $959 $952 $945 $937 $930 $923
33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84
$1,900 $1,900 $1,900 $1,900 $1,900 $1,900 $1,900 $1,900 $1,900 $1,900 $1,900 $1,900 $1,900 $1,900 $1,900 $1,900 $1,900 $1,900 $1,900 $1,900 $1,900 $1,900 $1,900 $1,900 $1,900 $1,900 $1,900 $1,900 $1,900 $1,900 $1,900 $1,900 $1,900 $1,900 $1,900 $1,900 $1,900 $1,900 $1,900 $1,900 $1,900 $1,900 $1,900 $1,900 $1,900 $1,900 $1,900 $1,900 $1,900 $1,900 $1,900 $1,900
$985 $992 $999 $1,007 $1,014 $1,022 $1,030 $1,037 $1,045 $1,053 $1,061 $1,069 $1,077 $1,085 $1,093 $1,101 $1,110 $1,118 $1,126 $1,135 $1,143 $1,152 $1,160 $1,169 $1,178 $1,187 $1,196 $1,205 $1,214 $1,223 $1,232 $1,241 $1,250 $1,260 $1,269 $1,279 $1,288 $1,298 $1,308 $1,318 $1,327 $1,337 $1,347 $1,358 $1,368 $1,378 $1,388 $1,399 $1,409 $1,420 $1,430 $1,441
$916 $908 $901 $893 $886 $878 $870 $863 $855 $847 $839 $831 $823 $815 $807 $799 $791 $782 $774 $765 $757 $748 $740 $731 $722 $713 $705 $696 $687 $677 $668 $659 $650 $640 $631 $621 $612 $602 $592 $583 $573 $563 $553 $543 $532 $522 $512 $501 $491 $480 $470 $459
85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120
$1,900 $1,900 $1,900 $1,900 $1,900 $1,900 $1,900 $1,900 $1,900 $1,900 $1,900 $1,900 $1,900 $1,900 $1,900 $1,900 $1,900 $1,900 $1,900 $1,900 $1,900 $1,900 $1,900 $1,900 $1,900 $1,900 $1,900 $1,900 $1,900 $1,900 $1,900 $1,900 $1,900 $1,900 $1,900 $1,900
$1,452 $1,463 $1,474 $1,485 $1,496 $1,507 $1,519 $1,530 $1,541 $1,553 $1,565 $1,576 $1,588 $1,600 $1,612 $1,624 $1,636 $1,649 $1,661 $1,673 $1,686 $1,699 $1,711 $1,724 $1,737 $1,750 $1,763 $1,777 $1,790 $1,803 $1,817 $1,830 $1,844 $1,858 $1,872 $1,886
$448 $437 $426 $415 $404 $393 $382 $370 $359 $347 $336 $324 $312 $300 $288 $276 $264 $251 $239 $227 $214 $201 $189 $176 $163 $150 $137 $124 $110 $97 $83 $70 $56 $42 $28 $14
ing Templates? Visit us at http://www.thefinanceresource.com
$1,900 $78,016
Do Not Edit Anything on this Page
Balance $149,225 $148,444 $147,657 $146,864 $146,066 $145,261 $144,450 $143,634 $142,811 $141,982 $141,146 $140,305 $139,457 $138,603 $137,742 $136,875 $136,002 $135,121 $134,235 $133,341 $132,441 $131,534 $130,621 $129,700 $128,773 $127,839 $126,897 $125,949 $124,993 $124,031 $123,061 $122,084
$121,099 $120,107 $119,108 $118,101 $117,087 $116,065 $115,035 $113,998 $112,952 $111,899 $110,839 $109,770 $108,693 $107,608 $106,515 $105,414 $104,304 $103,186 $102,060 $100,925 $99,782 $98,630 $97,470 $96,301 $95,123 $93,936 $92,741 $91,536 $90,322 $89,100 $87,868 $86,627 $85,376 $84,116 $82,847 $81,568 $80,280 $78,982 $77,674 $76,357 $75,029 $73,692 $72,344 $70,987 $69,619 $68,241 $66,853 $65,454 $64,045 $62,625 $61,194 $59,753
$58,301 $56,838 $55,365 $53,880 $52,384 $50,876 $49,358 $47,828 $46,286 $44,733 $43,169 $41,592 $40,004 $38,404 $36,792 $35,168 $33,531 $31,883 $30,222 $28,548 $26,862 $25,164 $23,452 $21,728 $19,991 $18,241 $16,477 $14,701 $12,911 $11,107 $9,291 $7,460 $5,616 $3,758 $1,886 $0
Loan Capital Investor Capital 150000 0