Financial Modeling Template

Tags

Financial, excel, template, worksheet, calculator

You must be logged in to download this document

be first to review

LisaB1982

MASTER NAVIGATION -innovateur.co.uk financial modelling freeware Copyright: www.innovateur.co.uk 2003 Company /Project Name Details Inputs Outputs Used do not copy -more copies available free to download directly from innovateur.co.uk Insert Company Name: XYZ Company Limited XYZ Company Limited Insert Sub Title: Business Plan Business Plan Version.0.3.4 Inputs Outputs Used INPUT FINANCIAL INFORMATION (click): Insert Months (three characters) if Wanted -Or Leave Month 1 (e.g Mar) 1 1 Month A STARTING POSITION 1. INSERT Company Name Month 2 2 2 Month 2. Insert Months -or LEAVE Month 3 3 3 Month B SALES /COST OF SALES /DISTRIBUTION 3. Insert Years -or LEAVE Month 4 4 4 Month Month 5 5 5 Month C OPERATING EXPENSES 4. INSERT DATA in A, B, C, D Month 6 6 6 Month Month 7 7 7 Month D FINANCE /LOANS /INVESTMENTS GLOSSARY OF TERMS Month 8 8 8 Month Month 9 9 9 Month VIEW ACCOUNTS /PRINT (click): VIEW GRAPHS /PRINT (click): Month 10 10 10 Month Month 11 11 11 Month CASH FLOW SALES & PROFIT Month 12 12 12 Month PROFIT & LOSS ACCOUNT CASH BALANCE Year 1 (e.g 2003) Year 1 Year 1 Year Year 2 Year 2 Year 2 Year BALANCE SHEET KEY RATIOS Year 3 Year 3 Year 3 Year For support e-mail us : freeware@innovateur.co.uk This Freeware is provided in goodfaith -innovateur accepts no liability whatever and by downloading it and using it you agree to this.(YOU ONY NEED TO FILL WHITE BOXES) SUMMARY & CHECK NET ASSESTS NET ASSETS -SUMMARY & CHECK -must balance SHAREHOLDERS FUNDS -BALANCE SHOULD BE NIL= -You can adjust the profit to ensure above figures match 1. INSERT DATA for 1. through 4. 2. THE BALANCE IN THE SUMMARY TABLE MUST BE ZERO -IF YOUR ENTRIES DO NOT BALANCE TO ZERO AFTER COMPLETING ALL ENTRIES WE SUGGEST YOU ADJUST THE PROFIT FROM ACTIVITIES SO FAR TO BALANCE THE FIGURES 1. CURRENT ASSETS Bank Cash Balance 0 -Opening Stocks [exc VAT] 0 -Trade Debtors [Inc VAT] 0 --2. FIXED ASSETS All Excluding VAT FIXED ASSET COST ANY DEPRECIATION FIXED ASSET VALUE IT /Office Equipment 0 --Plant & Machines 0 --Intangible Assets [Development] 0 --Other Fixed Assets 0 --0 --3. CURRENT LIABILITIES Creditors & Accruals [Inc VAT] 0 -VAT Creditor (-Debtor) 0 --4. FINANCED BY SAHREHOLDERS FUNDS AND LOANS: SHAREHOLDER INVESTMENT 0 -LOANS FROM DIRECTORS 0 -LONG TERM LOANS 0 -PROFIT /(-LOSS RESERVE) [form activities so far] 0 -<< Back to Master INPUT SHEET FOR :: SALES /COST OF SALES /S & DISTRIBUTION <> SUMMARY Year 1 Year 2 Year 3 INSERT SALES DATA SALES (exc VAT) ---X VAT SUMMARY/MONTH Year 1 Year 2 Year 3 INSERT COST OF SALES Net SALES RECEIPTS ---X VAT Monthly Sales ---Exc VAT INSERT DISTRIBUTION COST DEBTORS (inc VAT) ---Inc VAT M.Net Sales Receipts ---Exc VAT (YOU ONY NEED TO FILL WHITE BOXES) TO INSERT THE SALES DATA: OPTION: ANNUAL INCREASE Year 1 Year 2 Year 3 1. Insert Sales for first year one month at a time in " Sales /Month " rows (EXCLUDING VAT) Input Annual Sales Increase as % 10% 25% 2(A). -EITHER : Insert a PERCENTAGE Increase in Annual Sales for Year 2 and Year 3 in the corresponding % white boxes 2(B). -OR : Insert Total Annual Sales for Year 2 and Year 3 in the corresponding white boxes SALES (Excluding VAT) Year 1 -Year 2 0 Year 3 0 SALES (Excluding VAT) Increase by % 10% Increase by % 25% Year 1 Year 2 Year 3 SALES (Excluding VAT) Year 1 -Year 2 -Year 3 ----SALES (Excluding VAT) 1 2 3 4 5 6 7 8 9 10 11 12 SALES (Excluding VAT) -NET Sales /Month 0 0 0 0 0 0 0 0 0 0 0 0 ---SALES (Excluding VAT) Opening Debtors Net of VAT -this is the ammount you enetered in the opening position Payment RECEIVED (ExVAT) -NET Sales Receipts ---------------Payment RECEIVED (ExVAT) SALES DEBTORS (inc VAT) -Debtors (inc VAT) ---------------SALES DEBTORS (inc VAT) COST OF SALES & STOCK Year 1 Year 2 Year 3 SUMMARY Year 1 Year 2 Year 3 DATA ASSUMPTIONS INSERT COST OF SALES % 40% 40% 40% COST OF SALES ---OPENING STOCK ---1. Insert COST OF SALES % to be used for the plan (i.e. direct cost of production as a % of Sales net of VAT) PURCHASES ---2. If you had OPENING CREDITORS insert manually when these will be paid (See Note). CLOSING STOCK ---COST OF SALES Year 1 40% Year 2 40% Year 3 40% COST OF SALES Year 1 Year 2 Year 3 COST OF SALES Year 1 -Year 2 -Year 3 ----COST OF SALES 1 2 3 4 5 6 7 8 9 10 11 12 COST OF SALES % ---------------COST OF SALES OPENING STOCK POSITION ---------------OPENING STOCK POSITION STOCK PURCHASES (INSERT VALUES) ---------------STOCK PURCHASES (INSERT VALUES) NET PAYMENTS (Also for any OPENING CREDITORS) ---------------NET PAYMENTS (Also for any OPENING CREDITORS) INCREASE/(DECREASE) TO NET CREDITORS ---------------INCREASE/(DECREASE) TO NET CREDITORS CLOSING STOCK ---------------CLOSING STOCK SALES & DISTRIBUTION Year 1 Year 2 Year 3 SUMMARY Year 1 Year 2 Year 3 COSTS SALES & DISTRIBUTION % 6% 6% 6% SALES & DISTRIBUTION ---PAYMENT OF CHARGES ---1. Insert SALES & DISTRIBUTION Cost PERCENTAGE (as a % of Sales net of VAT) BALANCING CREDITOR ---SALES & DISTRIBUTION Year 1 6% Year 2 6% Year 3 6% SALES & DISTRIBUTION Year 1 Year 2 Year 3 SALES & DISTRIBUTION Year 1 -Year 2 -Year 3 ----SALES & DISTRIBUTION 1 2 3 4 5 6 7 8 9 10 11 12 SALES & DISTRIBUTION % ---------------SALES & DISTRIBUTION SALES & DISTRIBUTION PAYMENT (Exc VAT) ---------------SALES & DISTRIBUTION PAYMENT (Exc VAT) INCREASE /(DECREASE) IN NET CREDITORS ---------------INCREASE /(DECREASE) IN NET CREDITORS END/\ /\ BACK TO TOP /\ /\<< Back to Master INPUT SHEET FOR :: OPERATING EXPENSES <> SUMMARY Year 1 Year 2 Year 3 SUMMARY/MONTH Year 1 Year 2 Year 3 ADMINISTRATIVE Net Expenses ---Monthly Expenses ---EXPENSES Net Payments ---Monthly Payments ---YearEnd Net Creditor ---TO INSERT THE EXPENSES DATA (YOU ONY NEED TO FILL WHITE BOXES) SUMMARY/MONTH Year 1 Year 2 Year 3 1. Insert 1st year Total Expense data in the "Year 1" box -OR Individually month by month Input Annual Cost Increase as % 0% 0% 2(A). -EITHER : Insert a PERCENTAGE Increase in Annual Sales for Year 2 and Year 3 in the corresponding % white boxes 2(B). -OR : Insert Total Annual EXPENSES for Year 2 and Year 3 in the corresponding white boxes 3. Insert VAT (Or GST in USA) Rate -This is currently set at UK level (GST in US) VAT Rate on COSTS 17.50% MASTER ENTRY VAT RATE ON SALES 17.50% Change if Different -or leave the same Offices & Rates Year 1 0 Year 2 -Year 3 -Offices & Rates Offices & Rates Increase by % 0% Increase by % 0% Year 1 Year 2 Year 3 Offices & Rates Year 1 -OR Year 2 -Year 3 ----1 2 3 4 5 6 7 8 9 10 11 12 Offices & Rates -Expenses /Month ---------------Expenses Offices & Rates -Payments (Exc VAT) --------------Payments Offices & Rates -Creditors (Exc VAT) ---------------NET Creditors Salaries & Employer NI Year 1 0 Year 2 -Year 3 -Salaries & Employer NI Salaries & Employer NI Increase by % 0% Increase by % 0% Year 1 Year 2 Year 3 Salaries & Employer NI /Year Year 1 -Year 2 -Year 3 ----1 2 3 4 5 6 7 8 9 10 11 12 Salaries & Employer NI -Expenses /Month ---------------Expenses Salaries & Employer NI -Payments ---------------Payments Salaries & Employer NI -Creditors ---------------Creditors Utilities Year 1 0 Year 2 -Year 3 -Utilities Utilities Increase by % 0% Increase by % 0% Year 1 Year 2 Year 3 Utilities /Year Year 1 -Year 2 -Year 3 ----1 2 3 4 5 6 7 8 9 10 11 12 Utilities -Expenses /Month ---------------Expenses Utilities -Payments (Exc VAT) --------------Payments Utilities -Creditors ---------------Creditors Telephones Year 1 0 Year 2 -Year 3 -Telephones Telephones Increase by % 0% Increase by % 0% Year 1 Year 2 Year 3 Telephones /Year Year 1 -Year 2 -Year 3 ----1 2 3 4 5 6 7 8 9 10 11 12 Telephones -Expenses /Month ---------------Expenses Telephones -Payments (Exc VAT) --------------Payments Telephones -Creditors ---------------Creditors Insurance Year 1 0 Year 2 -Year 3 -Insurance Insurance Increase by % 0% Increase by % 0% Year 1 Year 2 Year 3 Insurance /Year Year 1 -Year 2 -Year 3 ----1 2 3 4 5 6 7 8 9 10 11 12 Insurance -Expenses /Month ---------------Expenses Insurance -Payments (Exc VAT) --------------Payments Insurance -Creditors ---------------Creditors Stationery & Post Year 1 0 Year 2 -Year 3 -Stationery & Post Stationery & Post Increase by % 0% Increase by % 0% Year 1 Year 2 Year 3 Stationery & Post /Year Year 1 -Year 2 -Year 3 ----1 2 3 4 5 6 7 8 9 10 11 12 Stationery & Post -Expenses /Month ---------------Expenses Stationery & Post -Payments (Exc VAT) --------------Payments Stationery & Post -Creditors ---------------CreditorsOffice Equipment Rental Year 1 0 Year 2 -Year 3 -Office Equipment Rental Office Equipment Rental Increase by % 0% Increase by % 0% Year 1 Year 2 Year 3 Office Equipment Rental /Year Year 1 -Year 2 -Year 3 ----1 2 3 4 5 6 7 8 9 10 11 12 Office Equipment Rental -Expenses /Month ---------------Expenses Office Equipment Rental -Payments (Exc VAT) --------------Payments Office Equipment Rental -Creditors ---------------Creditors Website Costs Year 1 0 Year 2 -Year 3 -Website Costs Website Costs Increase by % 0% Increase by % 0% Year 1 Year 2 Year 3 Website Costs /Year Year 1 -Year 2 -Year 3 ----1 2 3 4 5 6 7 8 9 10 11 12 Website Costs -Expenses /Month ---------------Expenses Website Costs -Payments (Exc VAT) --------------Payments Website Costs -Creditors ---------------Creditors Accountancy Costs Year 1 0 Year 2 -Year 3 -Accountancy Costs Accountancy Costs Increase by % 0% Increase by % 0% Year 1 Year 2 Year 3 Accountancy Costs /Year Year 1 -Year 2 -Year 3 ----1 2 3 4 5 6 7 8 9 10 11 12 Accountancy Costs -Expenses /Month ---------------Expenses Accountancy Costs -Payments (Exc VAT) --------------Payments Accountancy Costs -Creditors ---------------Creditors Legal & Professional Fees Year 1 0 Year 2 -Year 3 -Legal & Professional Fees Legal & Professional Fees Increase by % 0% Increase by % 0% Year 1 Year 2 Year 3 Legal & Professional Fees /Year Year 1 -Year 2 -Year 3 ----1 2 3 4 5 6 7 8 9 10 11 12 Legal & Professional Fees -Expenses /Month ---------------Expenses Legal & Professional Fees -Payments (Exc VAT) --------------Payments Legal & Professional Fees -Creditors ---------------Creditors Travel & Subsistence Year 1 0 Year 2 -Year 3 -Travel & Subsistence Travel & Subsistence Increase by % 0% Increase by % 0% Year 1 Year 2 Year 3 Travel & Subsistence /Year Year 1 -Year 2 -Year 3 ----1 2 3 4 5 6 7 8 9 10 11 12 Travel & Subsistence -Expenses /Month ---------------Expenses Travel & Subsistence -Payments (Exc VAT) --------------Payments Travel & Subsistence -Creditors ---------------Creditors Motor Expenses Year 1 0 Year 2 -Year 3 -Motor Expenses Motor Expenses Increase by % 0% Increase by % 0% Year 1 Year 2 Year 3 Motor Expenses /Year Year 1 -Year 2 -Year 3 ----1 2 3 4 5 6 7 8 9 10 11 12 Motor Expenses -Expenses /Month ---------------Expenses Motor Expenses -Payments (Exc VAT) --------------Payments Motor Expenses -Creditors ---------------Creditors Sundry Expenses Year 1 0 Year 2 -Year 3 -Sundry Expenses Sundry Expenses Increase by % 0% Increase by % 0% Year 1 Year 2 Year 3 Sundry Expenses /Year Year 1 -Year 2 -Year 3 ----1 2 3 4 5 6 7 8 9 10 11 12 Sundry Expenses -Expenses /Month ---------------Expenses Sundry Expenses -Payments (Exc VAT) --------------Payments Sundry Expenses -Creditors ---------------Creditors Bank Charges Year 1 0 Year 2 -Year 3 -Bank Charges Bank Charges Increase by % 0% Increase by % 0% Year 1 Year 2 Year 3Bank Charges /Year Year 1 -Year 2 -Year 3 ----1 2 3 4 5 6 7 8 9 10 11 12 Bank Charges -Expenses /Month ---------------Expenses Bank Charges -Payments (Exc VAT) --------------Payments Bank Charges -Creditors ---------------Creditors Other Services Year 1 0 Year 2 -Year 3 -Other Services Other Services Increase by % 0% Increase by % 0% Year 1 Year 2 Year 3 Other Services /Year Year 1 -Year 2 -Year 3 ----1 2 3 4 5 6 7 8 9 10 11 12 Other Services -Expenses /Month ---------------Expenses Other Services -Payments (Exc VAT) --------------Payments Other Services -Creditors ---------------Creditors Marketing Costs Year 1 0 Year 2 -Year 3 -Marketing Costs Marketing Costs Increase by % 0% Increase by % 0% Year 1 Year 2 Year 3 Marketing Costs /Year Year 1 -Year 2 -Year 3 ----1 2 3 4 5 6 7 8 9 10 11 12 Marketing Costs -Expenses /Month ---------------Expenses Marketing Costs -Payments (Exc VAT) --------------Payments Marketing Costs -Creditors ---------------Creditors Research Costs Year 1 0 Year 2 -Year 3 -Research Costs Research Costs Increase by % 0% Increase by % 0% Year 1 Year 2 Year 3 Research Costs /Year Year 1 -Year 2 -Year 3 ----1 2 3 4 5 6 7 8 9 10 11 12 Research Costs -Expenses /Month ---------------Expenses Research Costs -Payments (Exc VAT) --------------Payments Research Costs -Creditors ---------------Creditors Year 1 0 Year 2 -Year 3 ---Increase by % 0% Increase by % 0% Year 1 Year 2 Year 3 -/Year Year 1 -Year 2 -Year 3 ----1 2 3 4 5 6 7 8 9 10 11 12 --Expenses /Month ---------------Expenses --Payments (Exc VAT) --------------Payments --Creditors ---------------Creditors Provision for Bad Debts Year 1 0.0% Year 2 0.0% Year 3 0.0% Provision for Bad Debts Provision for Bad Debts INSERT A PERCENTAGE OF SALES PERCENTAGE OF SALES PERCENTAGE OF SALES Year 1 Year 2 Year 3 Provision for Bad Debts /Year Year 1 -Year 2 -Year 3 ----1 2 3 4 5 6 7 8 9 10 11 12 Provision for Bad Debts -Expense /Month ---------------Expenses Provision for Bad Debts -'Payments' (Exc VAT) --------------Payments Provision for Bad Debts -Creditors ---------------Creditors END /\ /\ BACK TO TOP /\ /\<< Back to Master INPUT SHEET FOR :: FINANCE /LOANS /FIXED ASSETS <> EQUITY RECEIVED LOAN INTEREST RATE: 8% LOANS OVERDRAFT INTEREST RATE: 10% FIXED ASSET DEPRECIATION RATE 25% DIRECTOR LOANS INTEREST RATE ON CASH SURPLUS: 2% FIXED ASSETS (YOU ONY NEED TO FILL WHITE BOXES) EQUITY INVESTMENT OPENING BALANCE -LONG TERM LOANS OPENING BALANCE -NEW EQUITY ADDITIONAL CAPITAL LONG TERM INTEREST RECEIVED LOANS REPAYMENTS LOAN BALANCE DUE Month 1 0 -Month 1 0 --Month 2 0 -Month 2 0 --Month 3 0 -Month 3 0 --Month 4 0 -Month 4 0 --Month 5 0 -Month 5 0 --Month 6 0 -Month 6 0 --Month 7 0 -Month 7 0 --Month 8 0 -Month 8 0 --Month 9 0 -Month 9 0 --Month 10 0 -Month 10 0 --Month 11 0 -Month 11 0 --Month 12 0 -Month 12 0 --Year Year 1 --Year Year 1 ----Year Year 2 0 -Year Year 2 0 --Year Year 3 0 -Year Year 3 0 --LOANS FROM DIRECTORS DIRECTOR LOANS OPENING BALANCE -MORE DIRECTOR REPAYMENT DIRECTOR LOANS TO DIRECTORS LOAN BALANCE Month 1 0 -Month 2 0 -Month 3 0 -Month 4 0 -Month 5 0 -Month 6 0 -Month 7 0 -Month 8 0 -Month 9 0 -Month 10 0 -Month 11 0 -Month 12 0 -Year Year 1 ---Year Year 2 0 -Year Year 3 0 -PURCHASE OF FIXED ASSESTS IT /Office Equipment OPENING BALANCE -Navigation around Fixed Assets DEPRECIATION 25% Reducing Balance 1 OFFICE /IT FIXED ASSETS 1. 2 PLANT & MACHINE OPENING PLUS NEW LESS CLOSING VAT 3 INTANGIBLES FIXED ASSET SUMMARY IT /Office Equipment BALANCE PURCHASES DEPRECIATION BALANCE PURCHASES 4 OTHER FIXED Month 1 -0 ---DEPRECIATION RATE 25% Month 2 -0 ---Month 3 -0 ---CASH EXPENDED IN FIXED ASSETS Month 4 -0 ---Year Year 1 -Month 5 -0 ---Year Year 2 -Month 6 -0 ---Year Year 3 -Month 7 -0 ---Month 8 -0 ---CLOSING FIXED ASSETS Month 9 -0 ---Year Year 1 -Month 10 -0 ---Year Year 2 -Month 11 -0 ---Year Year 3 -Month 12 -0 ---DEPRECIATION Year Year 1 -----Year Year 1 -Year Year 2 -0 ---Year Year 2 -Year Year 3 -0 ---Year Year 3 -Plant & Machines OPENING BALANCE -Navigation around Fixed Assets DEPRECIATION 25% Reducing Balance 1 OFFICE /IT FIXED ASSETS 2. 2 PLANT & MACHINE OPENING PLUS NEW LESS CLOSING VAT 3 INTANGIBLES Plant & Machines BALANCE PURCHASES DEPRECIATION BALANCE PURCHASES 4 OTHER FIXED Month 1 -0 ---Month 2 -0 ---Month 3 -0 ---Month 4 -0 ---Month 5 -0 ---Month 6 -0 ---Month 7 -0 ---Month 8 -0 ---Month 9 -0 ---Month 10 -0 ---Month 11 -0 ---Month 12 -0 ---Year Year 1 -----Year Year 2 -0 ---Year Year 3 -0 ---Intangible Assets [Development] OPENING BALANCE -Navigation around Fixed Assets DEPRECIATION 25% Reducing Balance 1 OFFICE /IT FIXED ASSETS 3. 2 PLANT & MACHINE OPENING PLUS NEW LESS CLOSING VAT 3 INTANGIBLES Intangible Assets [Development] BALANCE PURCHASES DEPRECIATION BALANCE PURCHASES 4 OTHER FIXED Month 1 -0 ---Month 2 -0 ---Month 3 -0 ---Month 4 -0 ---Month 5 -0 ---Month 6 -0 ---Month 7 -0 ---Month 8 -0 ---Month 9 -0 ---Month 10 -0 ---Month 11 -0 ---Month 12 -0 ---Year Year 1 -----Year Year 2 -0 ---Year Year 3 -0 ---Other Fixed Assets OPENING BALANCE -Navigation around Fixed Assets DEPRECIATION 25% Reducing Balance 1 OFFICE /IT FIXED ASSETS 4. 2 PLANT & MACHINE OPENING PLUS NEW LESS CLOSING VAT 3 INTANGIBLES Other Fixed Assets BALANCE PURCHASES DEPRECIATION BALANCE PURCHASES 4 OTHER FIXED Month 1 -0 ---Month 2 -0 ---Month 3 -0 ---Month 4 -0 ---Month 5 -0 ---Month 6 -0 ---Month 7 -0 ---Month 8 -0 ---Month 9 -0 ---Month 10 -0 ---Month 11 -0 ---Month 12 -0 ---Year Year 1 -----Year Year 2 -0 ---Year Year 3 -0 ---END /\ /\ BACK TO TOP /\ /\ FIXED ASSET PURCHASES & VAT SUMMARY VAT NET GROSS TOTAL DEPRECIATION -BREAKDOWN BY MONTH & YEAR TOTAL DEPRECIATION SUMMARY Totals PURCHASES PURCHASES Month 1 -Month 1 ---Month 2 -Month 2 ---Month 3 -Month 3 ---Month 4 -Month 4 ---Month 5 -Month 5 ---Month 6 -Month 6 ---Month 7 -Month 7 ---Month 8 -Month 8 ---Month 9 -Month 9 ---Month 10 -Month 10 ---Month 11 -Month 11 ---Month 12 --Month 12 ---Year Year 1 -Year Year 1 ---Year Year 2 -Year Year 2 ---Year Year 3 -Year Year 3 ---XYZ Company Limited PROFIT & LOSS ACCOUNT Business Plan Month Month Month Month Month Month Month Month Month Month Month Month Year Year Year 1 2 3 4 5 6 7 8 9 10 11 12 Year 1 Year 2 Year 3 Sales ---------------Cost of Sales ---------------Gross Profit ---------------Administrative Expenses Offices & Rates ---------------Salaries & Employer NI ---------------Utilities ---------------Telephones ---------------Insurance ---------------Stationery & Post ---------------Office Equipment Rental ---------------Website Costs ---------------Accountancy Costs ---------------Legal & Professional Fees ---------------Travel & Subsistence ---------------Motor Expenses ---------------Sundry Expenses ---------------Bank Charges ---------------Other Services ---------------Marketing Costs ---------------Research Costs ---------------0 ---------------Provision for Bad Debts ------------------------------Sales & Distribution Costs ---------------Depreciation ---------------Operating Profit (EBIT) ---------------Interest Payable Overdraft Interest (Interest Received) ---------------Loan Interest Payable ---------------Profit Before Corporation Tax ---------------Corporation Tax Net Profit /(Loss) ---------------Dividens Payable Profit to Reserves ---------------modelling softwarecopyright innovateur.co.uk 2003XYZ Company Limited BALANCE SHEET Business Plan Opening Month Month Month Month Month Month Month Month Month Month Month Month Year Year Year Balance 1 2 3 4 5 6 7 8 9 10 11 12 Year 1 Year 2 Year 3 Fixed Assets IT /Office Equipment ----------------Plant & Machines ----------------Intangible Assets [Development] ----------------Other Fixed Assets --------------------------------Current Assets Cash ----------------Trade Debtors ----------------Stock --------------------------------Current Liabilities Trade Creditors & Accruals ----------------VAT Creditor (Debtor) ----------------Other Creditors ----------------Net Current Assets ----------------Total Assets less Current Liabilities ----------------Long Term Creditors Long Term Loans ----------------Loans from Directors ----------------Other Creditors due after 1 year ----------------NET ASSETS --------------------------------SHAREHOLDERS FUNDS ----------------Share Capital & Premium ----------------Profit & Loss Account ----------------modelling softwarecopyright innovateur.co.uk 2003XYZ Company Limited CASH FLOW FORECAST Business Plan Month Month Month Month Month Month Month Month Month Month Month Month Year Year Year 1 2 3 4 5 6 7 8 9 10 11 12 Year 1 Year 2 Year 3 CASH INFLOWS Cash from Sales ---------------VAT (or GST USA) from Sales ---------------Loans from Directors ---------------Long Term Loans ---------------Share Capital Investment ---------------CASH INFLOW IN PERIOD ---------------CASH OUTFLOWS Financing & Investment IT /Office Equipment ---------------Plant & Machines ---------------Intangible Assets [Development] ---------------Other Fixed Assets ---------------Purchases for Stock ----------------Bank Interest Paid /(Received) --------------Loan Interest Paid ---------------Loan Capital Repayments ---------------Director Loan Repayments ---------------Administrative Expenses Offices & Rates ---------------Salaries & Employer NI ---------------Utilities ---------------Telephones ---------------Insurance ---------------Stationery & Post ---------------Office Equipment Rental ---------------Website Costs ---------------Accountancy Costs ---------------Legal & Professional Fees ---------------Travel & Subsistence ---------------Motor Expenses ---------------Sundry Expenses ---------------Bank Charges ---------------Other Services ---------------Marketing Costs ---------------Research Costs ---------------0 ---------------Provision for Bad Debts ---------------Sales & Distribution Costs ---------------VAT (or GST USA) VAT in Purchases & Expense Payment 17.50% ---------------VAT to Customs & Excise -Payment (Refund) -------CASH OUTFLOWS IN PERIOD ---------------NET CASH FLOWS ---------------OPENING CASH ---------------CASH BALANCE ---------------modelling softwarecopyright innovateur.co.uk 2003XYZ Company Limited Business Plan modelling softwarecopyright innovateur.co.uk 2003 CASH BALANCE -0000111111 1 2 3 4 5 6 7 8 9 10 11 12 Year 1 Year 2 Year 3 First 12 Months -Then First 3 YearsXYZ Company Limited Business Plan modelling softwarecopyright innovateur.co.uk 2003 SALES & PROFIT -0000111111 1 2 3 4 5 6 7 8 9 10 11 12 Year 1 Year 2 Year 3 First 12 Months -Then First 3 YearsXYZ Company Limited KEY RATIOS Business Plan Month Month Month Month Month Month Month Month Month Month Month Month Year Year Year 1 2 3 4 5 6 7 8 9 10 11 12 Year 1 Year 2 Year 3 OPERATING PERFORMANCE RATIOS GROSS PROFIT MARGIN % 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% COST OF SALES % 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% SALES & DISTRIBUTION % 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% PROFIT BIT ON SALES % 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% RETURN ON ASSETS RATIOS RETURN ON NET ASSESTS 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% RETURN ON EQUITY 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% ---------------BREAK EVEN & CASH CONSUMPTION LEVELS SALES BREAK EVEN -Exc VAT(exc.capex) ------------# ---(Assuming COS + Distribution as % of Sales) CASH BURN RATE -BEFORE SALES 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 (Excluding Capital) CASH BURN RATE -BEFORE SALES 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 (Including Capital) CASH BURN RATE -INCLUDING SALES 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 (Including Capital) SOLVENCY RATIOS NET CURRENT ASSETS ---------------CURRENT RATIO ---------------NET LIQUID ASSETS ---------------ACID TEST (Liquidity) ---------------#DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! ---------------DEPRECIATION POLICY Fixed Assets are Depreciated at 25% per annum, on a reducing balance basis. modelling softwarecopyright innovateur.co.uk 2003<< Back to Master GLOSSARY OUTPUTS: << P&L << BS <>Statement of trading performance (excludes assets and liabilities) Balance Sheet >>Statement of Assets & Liabilities at a particular point in time Cash Flow Statement >>Statement of cash position and the sources and uses of cash during the period Creditors >>Money owed by the company to suppliers and others who they have bought goods from (including VAT or GST) Debtors >>Money owed TO the company by suppliers and others (includes VAT) Assets >>Those things owned by the business >>such as cash, or furniture, or computers or trademarks Fixed Assets >>Those assets that are reasonably fixed >>not stock or cash which are consumed regularly Current Assets >>Those assets that are reasonably quickly able to be converted into cash (or are cash) stock, debtors,etc. Liabilities >>That which is owed by the company to others >>such as overdraft or other debts /commitments Depreciation >>Fixed Assets have a finite life >>as they get older they need to be depreciated (as their asset value reduces) >>This depreciation is charged to the Profit & Loss account and reduced the value of the asset >>For example, a Computer might have a 3 year life expectancy >>so it is depreciated (reduced in value) over three years to zero Interest >>Interest charged on loans and overdrafts, or paid on cash deposits Equity >>Investment made into the company in exchange for shares (part ownership). This carries no interest >>owners benefit by sharing Debt >>Loans from the bank and others made to the company Director Loans >>Loans made by directors to the company, or vice-versa NI >>National Insurance or Employment Tax >>paid by companies on top of employee salaries VAT /GST/\ /\ BACK TO TOP /\ /\ For support e-mail us : freeware@innovateur.co.uk >>Value Added Tax or General Sales Tax >>A tax the company adds to Sales and which it is charge on Supplies. >>The difference between the tax it charges and the tax it is charged by others is then paid to the Tax Office.CHARTS: CASH>> PROFIT>> including VAT or GST) asset value reduces) reduced in value) over three years to zero no interest >>owners benefit by sharing profitscharge on Supplies. the Tax Office.

Public Domain

downloads:85

rating:not rated

reviews:0

posted:2/5/2008

language:English

search termpage on Googletimes searched

financial modeling template21

financial modelling template21

financial modelling and reducing balance loans11

"financial modeling" template11

financial modeling templates11

financial modeling cash burn to break even11

Financial Modeling Template

Excel Mortgage Affordability Calculator

Mileage Calculator for Excel

Excel Mortgage Comparison Calculator

ARM Loan Calculator Template

Loan Calculator Template

Marketing Calculator Template

Wealth Calculator Template

Financial Comparison Analysis Template

Financial Statement Ratios Template

Financial Projection Model Template

Company Financial Projection Template

Financial Statement Template

Excel Stock Quotes Template

Excel Timesheet Template

Home Budget Excel Template

UNIVERSIDAD DE LOS ANDES

UNIDAD SEGUNDA

Tocar hoy vive para la eternidad

Timbres Fiscales

TÉRMINOS DE REFERENCIA

Taller de Escalada

SUB-DIRECCION DE DEFENSA DEL TRABAJADOR

SOLICITUD Y FORMULARIO DE VERIFICACIÓN

SOLICITUD VISA L

SOLICITUD PARA COMIDAS ESCOLARES GRATIS O A PRECIO REDUCIDO