财务模型XLS格式
Property of VenturePresentation.comVenturePresentation.comThis model is representative of our fictional company: MobileCord Inc.You may use this model as the basis for your own, or just use it as apoint of reference.Our Model is made up of the following worksheets:EmployeesEquipment ExpenseCap LeaseService ExpensePipeline assumptionsPipeline Closed SalesQuotaRevenueMonthly P&LAnnual P&LQuarterly P&LBalance SheetStmt of CFCap TableWorksheets from Employees to Service Expenses define theexpense side of the business.Worksheets From Pipeline Assumptions to Revenue define theRevenue side of the businessWorksheets Monthly P&L to Cap Table are the financial statementsthat VCs and investors will want to see.Investors will probably also want to see the pipeline. Worksheets Bal Sheet for Offer Memo through P&L summ for OfferMemo are copies of the Balance Sheet and Quarterly P&L sheets inorder to format these statements for the presentation in the offeringmemorandum. Employee ExpensesNote: Employee Expenses feed into the Monthly P&Lall costs on a per month basisPre-Capital Raise Post-Capital RaiseIncremental HiresGeneral Assumptions:Insurance & Tax true up 30%Bonus Payment per month (Non sales team) $350Bonus (Non sales team) YesBonuses are divided by 12 months since they are annual paymentsMonthly Expense Monthly ExpenseGeneral & AdministrativeCEO $6,700 CFO $6,000Bonus $350 Bonus $350Controller $4,250Bonus $350LAN Help Desk $3,300Bonus $350Administrative Assistant $2,100Bonus $350Subtotal $17,750 Incremental Subtotal $6,350Insurance & Payroll Tax $5,325 Insurance & Payroll Tax $1,905G&A Total $23,075 G&A Incremental Total $8,255Total G&A Post Capital Raise $31,330Sales & Marketing*Note: Sale Commisions paid on a quarterly basis, see Quota worksheetVP of Sales and Marketing $5,500 Head of Business Development $5,200Sales Associate $4,500Sales Associate $4,600Sales Associate $4,500Inside Sales Associate $4,000 Sales Associate $4,350Sales Engineer $4,300Sales Engineer $4,000Sales Engineer $4,000Director of Marketing $5,000Marketing Associate $4,000Subtotal $23,150Insurance & Payroll Tax $6,945Subtotal $30,800 Sales & Mkting Incremental Total $30,095Insurance & Payroll Tax $9,240Sales and Marketing Total $40,040 Total Sales & Mkting Post Raise $70,135Research & DevelopmentCTO $6,800Bonus $350Senior Developer $6,000Bonus $350Senior Developer $6,000Bonus $350 Developer $5,000Bonus $350Developer $5,000Bonus $350 Developer $4,750Bonus $350Developer $4,750Bonus $350Developer $4,100Bonus $350Senior Q&A Analyst $5,250Bonus $350Q&A Analyst $4,000Bonus $350 Q&A Analyst/ Documentation $3,700Bonus $350Q&A Analyst/ Documentation $3,550Bonus $350 Subtotal $14,500Insurance & Payroll Tax $4,350Subtotal $48,600 Total Incremental R&D $18,850Insurance & Payroll Tax $14,580Total R&D $63,180 Total R&D Post Raise $82,030Director of Professional Services $6,300Bonus $350Consultant $5,000Consultant $5,100 Bonus $350Bonus $350Customer Support Specialist $3,800Consultant $4,000 Bonus $350Bonus $350Subtotal $9,500Subtotal $16,450 Insurance & Payroll Tax $2,850Insurance & Payroll Tax $4,935 Total Incremental Prof Services $12,350Total Professional Services (COGS) $21,385 Total Prof Services (post raise) $33,735Total Employee Costs $126,295 Total Employee Costs Post Raise $195,845Total Employees 23 Total Employees Post Raise 34Equipment & Software Expenses New Equipment Post-RaiseNote: Equipment Expenses feed into the Monthly P&LPre-Capital RaiseAssumptions:Operating LeasesLife of Assets (in months) 45Term of Operating Lease 30Interest Rate (monthly) 1.00%Quantity Cost per unit Quantity Cost per unitCisco Router 1 $15,000 $15,000Workstations 25 $3,000 $75,000 Workstations 7 $3,000 $21,000Laptops 5 $3,200 $16,000 Laptops 5 $3,200 $16,000PDAs 20 $300 $6,000 PDAs 12 $270 $3,240Printers 3 $4,000 $12,000Copier/Scanners 2 $5,000 $10,000Desk Chairs 30 $250 $7,500 Desk Chairs 10 $250 $2,500Total $141,500 $42,740Incremental Monthly Payment $1,184Monthly Payment $5,483 Total Monthly Payment $6,667Total obligation over term $164,486Percent Allocation to Sales Percent Allocation to Sales15% $822 15% $1,000Percent Allocation to R&D Percent Allocation to R&D60% $3,290 60% $4,000Percent Allocation to G&A Percent Allocation to G&A25% $1,371 25% $1,667Capital LeasesTerm of Capital Lease 36Interest Rate (monthly) 1.00%Quantity Cost per UnitSun Servers 7 $25,000 $175,000 Sun Servers 2 $25,000 $50,000Monthly Payment $5,813 $1,661Total obligation over term $209,2501st Set of Servers 2nd Set of Servers Combined Schedule for ServersPresent Value $175,000 Depreciation Present Value $50,000 DepreciationTerm (months) 36 Term (months) 36 Term (months) 36 Term (months) 36Rate (month) 1.00% Depreciation $4,861 Rate (month) 1.00% Depreciation $1,389Payment $5,813 Payment $1,661Amortization Schedule Amortization Schedule Combined Amortization ScheduleMonth Beginning Balance Interest Principal Ending Balance Month Beginning Bal Interest Principal Ending Balance Total Principal1 $175,000 $1,750 $4,063 $170,937 $4,0632 $170,937 $1,709 $4,103 $166,834 $4,1033 $166,834 $1,668 $4,144 $162,690 $4,1444 $162,690 $1,627 $4,186 $158,505 $4,1865 $158,505 $1,585 $4,227 $154,277 $4,2276 $154,277 $1,543 $4,270 $150,007 $4,2707 $150,007 $1,500 $4,312 $145,695 $4,3128 $145,695 $1,457 $4,356 $141,339 $4,3569 $141,339 $1,413 $4,399 $136,940 $4,39910 $136,940 $1,369 $4,443 $132,497 $4,44311 $132,497 $1,325 $4,488 $128,010 $4,48812 $128,010 $1,280 $4,532 $123,477 $4,53213 $123,477 $1,235 $4,578 $118,900 1 $50,000 $500 $1,161 $48,839 $5,73814 $118,900 $1,189 $4,624 $114,276 2 $48,839 $488 $1,172 $47,667 $5,79615 $114,276 $1,143 $4,670 $109,606 3 $47,667 $477 $1,184 $46,483 $5,85416 $109,606 $1,096 $4,716 $104,890 4 $46,483 $465 $1,196 $45,287 $5,91217 $104,890 $1,049 $4,764 $100,126 5 $45,287 $453 $1,208 $44,079 $5,97118 $100,126 $1,001 $4,811 $95,315 6 $44,079 $441 $1,220 $42,859 $6,03119 $95,315 $953 $4,859 $90,456 7 $42,859 $429 $1,232 $41,627 $6,09120 $90,456 $905 $4,908 $85,548 8 $41,627 $416 $1,244 $40,383 $6,15221 $85,548 $855 $4,957 $80,591 9 $40,383 $404 $1,257 $39,126 $6,21422 $80,591 $806 $5,007 $75,584 10 $39,126 $391 $1,269 $37,856 $6,27623 $75,584 $756 $5,057 $70,527 11 $37,856 $379 $1,282 $36,574 $6,33924 $70,527 $705 $5,107 $65,420 12 $36,574 $366 $1,295 $35,279 $6,40225 $65,420 $654 $5,158 $60,262 13 $35,279 $353 $1,308 $33,971 $6,46626 $60,262 $603 $5,210 $55,052 14 $33,971 $340 $1,321 $32,650 $6,53127 $55,052 $551 $5,262 $49,790 15 $32,650 $327 $1,334 $31,316 $6,59628 $49,790 $498 $5,315 $44,475 16 $31,316 $313 $1,348 $29,969 $6,66229 $44,475 $445 $5,368 $39,108 17 $29,969 $300 $1,361 $28,607 $6,72930 $39,108 $391 $5,421 $33,686 18 $28,607 $286 $1,375 $27,233 $6,79631 $33,686 $337 $5,476 $28,211 19 $27,233 $272 $1,388 $25,844 $6,86432 $28,211 $282 $5,530 $22,680 20 $25,844 $258 $1,402 $24,442 $6,93333 $22,680 $227 $5,586 $17,094 21 $24,442 $244 $1,416 $23,026 $7,00234 $17,094 $171 $5,642 $11,453 22 $23,026 $230 $1,430 $21,595 $7,07235 $11,453 $115 $5,698 $5,755 23 $21,595 $216 $1,445 $20,151 $7,14336 $5,755 $58 $5,755 $0 24 $20,151 $202 $1,459 $18,691 $7,21425 $18,691 $187 $1,474 $17,218 $1,47426 $17,218 $172 $1,489 $15,729 $1,48927 $15,729 $157 $1,503 $14,226 $1,50328 $14,226 $142 $1,518 $12,707 $1,51829 $12,707 $127 $1,534 $11,174 $1,53430 $11,174 $112 $1,549 $9,625 $1,54931 $9,625 $96 $1,564 $8,060 $1,56432 $8,060 $81 $1,580 $6,480 $1,58033 $6,480 $65 $1,596 $4,884 $1,59634 $4,884 $49 $1,612 $3,272 $1,61235 $3,272 $33 $1,628 $1,644 $1,62836 $1,644 $16 $1,644 $0 $1,644Total Interest Ending Bal Total Depreciation$1,750 $170,937 $4,861$1,709 $166,834 $4,861$1,668 $162,690 $4,861$1,627 $158,505 $4,861$1,585 $154,277 $4,861$1,543 $150,007 $4,861$1,500 $145,695 $4,861$1,457 $141,339 $4,861$1,413 $136,940 $4,861$1,369 $132,497 $4,861$1,325 $128,010 $4,861$1,280 $123,477 $4,861$1,735 $167,739 $6,250$1,677 $161,943 $6,250$1,619 $156,089 $6,250$1,561 $150,177 $6,250$1,502 $144,205 $6,250$1,442 $138,174 $6,250$1,382 $132,083 $6,250$1,321 $125,930 $6,250$1,259 $119,716 $6,250$1,197 $113,440 $6,250$1,134 $107,102 $6,250$1,071 $100,699 $6,250$1,007 $94,233 $6,250$942 $87,702 $6,250$877 $81,106 $6,250$811 $74,444 $6,250$744 $67,715 $6,250$677 $60,919 $6,250$609 $54,055 $6,250$541 $47,122 $6,250$471 $40,120 $6,250$401 $33,048 $6,250$330 $25,906 $6,250$259 $18,691 $6,250$187 $17,218 $1,389$172 $15,729 $1,389$157 $14,226 $1,389$142 $12,707 $1,389$127 $11,174 $1,389$112 $9,625 $1,389$96 $8,060 $1,389$81 $6,480 $1,389$65 $4,884 $1,389$49 $3,272 $1,389$33 $1,644 $1,389$16 $0 $1,389Combined Schedule for ServersCombined Amortization ScheduleService Expenses per Month Pre-Raise Service Expenses per month Post-RaiseNote: Service Expenses feed into the Monthly P&LMonthly Expense Monthly ExpenseOffice Space $20,000 Office Space $25,000Utilities $4,000 Utilities $4,400Insurance $12,000 Insurance $14,000Telecom & Internet Expenses $5,000 Telecom & Internet Expenses $6,000Office Supplies $450 Office Supplies $500Overhead Total $41,450 Overhead Total $49,900Group Specific Expenses Group Specific ExpensesSales & Marketing Expenses Sales & Marketing ExpensesPercent of Overhead Above Percent of Overhead Above30% $12,435 30% $14,970Travel $25,000 Travel $40,000Mail & email campaigns $5,000 Mail & email campaigns $10,000Conference Expenses $5,000 Conference Expenses $10,000Web Marketing and Advertising $2,000 Web Marketing and Advertising $3,500Print Advertising - Print Advertising $3,000RIMM Pager Services $750 RIMM Pager Services $850Wireless Charges $600 Wireless Charges $750Group Total $50,785 Group Total $83,070Research & Development Expenses Research & Development ExpensesPercent of Overhead Above Percent of Overhead Above40% $16,580 40% $19,960Travel $3,000 Travel $5,000OEM Software Licenses $20,000 OEM Software Licenses $25,000Training $4,000 Training $6,000Group Total $43,580 Group Total $55,960General & Administrative General & AdministrativePercent of Overhead Above Percent of Overhead Above30% $12,435 30% $14,970Installation and Maintenance $15,000 Installation and Maintenance $15,000Travel $4,000 Travel $5,000Legal Expenses $3,000 Legal $3,500Accounting $2,500 Accounting $3,000Recruiting $1,500 Recruiting $1,500Mail $400 Mail $500Group Total $38,835 Group Total $43,470Total $133,200 Total $182,500Enterprise Pipeline AssumptionsStatus DescriptionLiklihood deal closes thisQuarterLiklihood deal closesnext QuarterClosed Deal signed 100% 0%Contract Contract Negotiation 70% 80%Eval Evaluating and piloting software 30% 65%Proposal Reviewing responses to RFPs 20% 40%Require Establishing requirements 5% 25%Response Response to email or sales call 2% 5%License Fee Description$40,000 Up front License$50 Up front charge per user$10 Monthly Recurring Charge per userEnterprise PipelineQ1 2002As of: 1/31/2003Prospect StatusPotentialUsers Sales ContactPotentialContract SizeDiscount(needs CEOapproval)Recurring Revper monthPotential Revthis QuarterPotential RevNext Quarter Description Lead GenerationSE Financial Institution Closed 400 VP Sales $60,000 10% $4,000 $54,000 $12,000 Sales cycle 5 months CEO contactRetail firm Contract 100 Sales Assoc2 $45,000 - $31,500 $10,800 Finalizing details emailSoftware sales force Contract 200 Sales Assoc1 $50,000 - $35,000 $12,000 Need C-level approval Sales callManufact firm sales force Contract 400 VP Sales $60,000 - $42,000 $14,400 Working out logistics Conference contactLaw enforcement group Contract 500 Sales Assoc1 $65,000 - $45,500 $15,600 Fast tracking though approval Sales contactConglomerate Mgmt team Eval 200 VP Sales $50,000 - $15,000 $22,750 Pilot in place Sales contactPharma Sales Eval 400 VP Sales $60,000 - $18,000 $27,300 Testing integration Cold callSouthern Fin Institution Proposal 500 Sales Assoc2 $65,000 - $13,000 $20,800 In bake off w/ wireless asp mailingHardware install team Proposal 200 Sales Assoc2 $50,000 - $10,000 $16,000 Looking at ROI sales callLogistics & Moving Proposal 350 Sales Assoc1 $57,500 - $11,500 $18,400 Going in with integration partner Conference contactLaw firm Proposal 200 Sales Assoc2 $50,000 - $10,000 $16,000 Need solution to help IT group ReferralWireless Provider Require 10000 VP Sales $540,000 - $27,000 $128,250 Value add service for consumers Sales callInsurance firm Require 500 Sales Assoc1 $65,000 - $3,250 $15,438 Looking at solution Cold callWestern Fin Institution Require 400 VP Sales $60,000 - $3,000 $14,250 In talks with R&D team Sales contactHealthcare provider Response 200 VP Sales $50,000 - $1,000 $2,450 Partner bringing us in PartnerNews Media Response 300 VP Sales $55,000 - $1,100 $2,695 Looking for solution Sales callAppliance Field Service Response 400 Inside Sales $60,000 - $1,200 $2,940 Looking at multiple solutions Cold callGov inspection Response 350 Sales Assoc2 $57,500 - $1,150 $2,818 Talking with IT manager Conference contactInsurance firm Response 600 Inside Sales $70,000 - $1,400 $3,430 Going in with integration partner PartnerRegional Airline Response 500 Inside Sales $65,000 - $1,300 $3,185 In early stages of looking Cold callTech Software Response 120 Inside Sales $46,000 - $920 $2,254 Looking for short impl time emailManufacturer sales force Response 200 Sales Assoc2 $50,000 - $1,000 $2,450 Educating them on solutions Sales callNew Eng Fin Institution Response 200 Inside Sales $50,000 - $1,000 $2,450 Beginning talks ReferralEnergy Services Response 125 Inside Sales $46,250 - $925 $2,266 Going through organization Sales CallUtility field service Response 200 Inside Sales $50,000 - $1,000 $2,450 Unhappy with current solution emailTotal Total$330,745 $373,375Enterprise Sales*closed sales feed into revenue, closed sales are in 2002, 2003 revs based on pipeline projections.Sales Status Users Sales ContactPotentialContract SizeDiscount(needs CEOapproval)Recurring Revper month RevenueRecurring RevNext Quarter Description Lead Generation Sales Assoc12002Q1 SalesTech Hardware Sales Closed 120 VP Sales $46,000 10% $1,200 $41,400 $3,600 Sales Cycle 3 months CEO contact -Mgmt team of Tech firm Closed 20 Sales Assoc1 $41,000 35% $200 $26,650 $600 Sales Cycle 2 months CEO contact 41000Q1 Total $68,050 $41,000Q2 Sales -New Eng Fin Instit Closed 350 VP Sales $57,500 20% $3,500 $46,000 $10,500 Sales Cycle 5 months Sales Contact -Equipment Sales Closed 75 Sales Assoc2 $43,750 10% $750 $39,375 $2,250 Sales Cycle 4 months Sales Contact -Insurance Firm Closed 350 Sales Assoc1 $57,500 10% $3,500 $51,750 $10,500 Sales Cycle 5 months Sales Call 57500Q2 Total $137,125 $57,500-Q3 Sales -IT Services firm Closed 1000 VP Sales $90,000 15% $10,000 $76,500 $30,000 Sales cycle 4 months Sales contact -Manufacturer sales force Closed 130 VP Sales $46,500 20% $1,300 $37,200 $3,900 Sales cycle 3 months Sales contact -Q3 Total $113,700-Q4 Sales -NY Financial Institution Closed 600 VP Sales $70,000 10% $6,000 $63,000 $18,000 Sales cycle 5 months CEO contact -Software firm