Lighthouse Design Suite/LIGHTHOUSE.mdf/Quantrix_1.2/Application/Quantrix.app/English.lproj/Samples/Financials.quantrix/modelFile

Text File | 1995-03-27 | 13KB | 1 lines

tables=({name="Income Statement";categories=({name="Income Statement Items";nodes=({name="Income Statement";children=({name=Revenue;children=({name="Software Product";}, {name="Investment Income";}, {name="Consulting and Development Services";}, {name=Miscellaneous;}, {name=Total;});}, {name=COGS;children=({name=Inventory;children=({name=Beginning;}, {name=Additions;}, {name=Ending;}, {name=Cost;});}, {name="Plant and Labor";}, {name=Depreciation;}, {name=Total;});}, {name="Gross Margin";}, {name="Operating Expenses";children=({name="SG&A";}, {name="Investment Advisory";}, {name="Legal and Auditing";}, {name=Marketing;}, {name="Research and Development";}, {name="Custodial Fees and Expenses";}, {name=Total;});}, {name="Operating Income";}, {name="Interest Income";}, {name="Interest Expense";}, {name="Adjustment for Currency Flux";}, {name="Income Before Tax";}, {name="Provision for Tax";}, {name="Net Income";});});}, {globalCategoryNumber=1;name=Quarter;nodes=({name=Q1;}, {name=Q2;}, {name=Q3;}, {name=Q4;});}, {globalCategoryNumber=0;name=Year;nodes=({name=Year1;}, {name=Year2;});});dataspace=(0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"",0,1125000,100000,30000,12500,1267500,0,276000,27600,248400,192000,40000,480400,787100,250000,29000,113000,12500,850000,125000,1379500,"-592400",826,6000,23000,"-574574",2000,"-576574",2950000,125000,46000,35211,3156211,27600,331200,33120,325680,230400,40000,596080,2560131,586000,33800,134600,156000,950000,125000,1985400,574731,5989,22355,48000,606365,9500,596865,4680000,150000,352000,52416,5234416,33120,397440,39744,390816,276480,40000,707296,4527120,850000,39560,160520,186524,1150000,125000,2511604,2015516,15103,18924,56000,2067695,15000,2052695,6750000,175000,38000,52466,7015466,39744,500512,42800,497456,312000,40000,849456,6166010,950000,39560,160520,286000,1200000,125000,2761080,3404930,15103,18924,42000,3443109,16000,3427109,5780000,"-45000",45000,35800,5815800,42800,454215,45400,451615,302500,40000,794115,5021685,1168000,39560,160520,350000,1250000,125000,3093080,1928605,15103,18924,"-36210",1888574,18500,1870074,5625000,"-258000",52000,68500,5487500,45400,478000,47800,475600,310000,40000,825600,4661900,1530000,39560,160520,375000,1350000,125000,3580080,1081820,15103,18924,"-25000",1052999,28000,1024999,8542000,220000,55000,105000,8922000,47800,512000,51200,508600,310000,40000,858600,8063400,2150000,39560,160520,395000,1500000,125000,4370080,3693320,15103,18924,"-36000",3653499,38000,3615499);formulaspace={formulae=({formula="Net Income = Income Before Tax - Provision for Tax";}, {formula="Income Before Tax = Operating Income + Interest Income - Interest Expense+Adjustment for Currency Flux";}, {formula="Gross Margin = Revenue.Total - COGS.Total";}, {formula="Operating Income = Gross Margin - Operating Expenses.Total";}, {formula="Revenue.Total = sum(summary(Revenue)) ";}, {formula="Inventory.Beginning:Quarter[THIS] =  Inventory.Ending:Quarter[PREV]";}, {formula="Inventory.Beginning:Year[THIS]:Q1 = Inventory.Ending:Year[PREV]:Q4";}, {formula="COGS.Total = Inventory.Cost + Plant and Labor + Depreciation";}, {formula="Inventory.Cost =Inventory.Beginning+Inventory.Additions-Inventory.Ending";}, {formula="Operating Expenses.Total = sum(summary(Operating Expenses))";}, {formula="Depreciation:Quarter[THIS] = (Balance Sheet::Depreciation:Quarter[THIS] - Balance Sheet::Depreciation:Quarter[PREV] )*(-1)";}, {formula="Depreciation:Q1:Year[THIS] = (Balance Sheet::Depreciation:Q1:Year[THIS] - Balance Sheet::Depreciation:Q4:Year[PREV])*(-1)";});};}, {name="Balance Sheet";categories=({name="Balance Sheet Items";nodes=({name="Balance Sheet";children=({name=Assets;children=({name="Current Assets";children=({name=Cash;}, {name="Accounts Receivable";}, {name=Inventories;}, {name="Vendor Deposits";}, {name=Total;});}, {name="Other Assets";children=({name=Plant;}, {name=Property;}, {name=Equipment;}, {name=Depreciation;}, {name=Total;});}, {name=Total;});}, {name="Liabilities & Equity";children=({name=Liabilities;children=({name="Accounts Payable";}, {name=Deposits;}, {name="Amortized Debt";}, {name="Short Term Borrowings";}, {name=Total;});}, {name=Equity;children=({name="Capital Contribution";}, {name=Dividends;}, {name="Retained Earnings";}, {name=Net;});}, {name=Total;});});});}, {globalCategoryNumber=1;name=Quarter;nodes=({name=Q1;}, {name=Q2;}, {name=Q3;}, {name=Q4;});}, {globalCategoryNumber=0;name=Year;nodes=({name=Year1;}, {name=Year2;});});dataspace=(1000000,0,0,0,1000000,0,0,0,0,0,1000000,0,0,0,0,0,1000000,0,0,1000000,1000000,183326,60000,27600,10000,280926,250000,100000,75000,"-40000",385000,665926,50000,2500,150000,50000,252500,1000000,"-10000","-586574",413426,665926,739074,50000,33120,10000,832194,250000,100000,125000,"-80000",395000,1227194,55173,5000,141730,40000,241903,1000000,"-25000","-14709",985291,1227194,2725194,40000,39744,0,2804938,250000,100000,188500,"-120000",418500,3223438,65541,7500,132411,30000,235452,1000000,"-50000",1987986,2987986,3223438,6120050,45000,42800,0,6207850,250000,100000,195000,"-160000",385000,6592850,50000,9500,128255,25000,212755,1000000,"-35000",5380095,6380095,6592850,7894697,52000,45400,20000,8012097,250000,100000,285000,"-200000",435000,8447097,55173,11500,120255,25000,211928,1000000,"-15000",7235169,8235169,8447097,8703759,42000,47800,20000,8813559,250000,100000,550650,"-240000",660650,9474209,65541,13500,115000,25000,219041,1000000,"-5000",8255168,9255168,9474209,11923967,41000,51200,0,12016167,250000,100000,985000,"-280000",1055000,13071167,50000,15500,110000,25000,200500,1000000,0,11870667,12870667,13071167);formulaspace={formulae=({formula="Capital Contribution=1000000 // Seed round of venture financing, $1MM dollars completed Feb. 1";}, {formula="In Year1, Q1:Cash = Q1:Capital Contribution";}, {formula="Cash = Cash Flows::Ending Cash skip Year1:Q1";}, {formula="Inventories =Income Statement::COGS.Inventory.Ending";}, {formula="Current Assets.Total = sum(summary(Current Assets))";}, {formula="Other Assets.Total = sum(summary(Other Assets))";}, {formula="Assets.Total = sum(summary(Assets))";}, {formula="Liabilities.Total = sum(summary(Liabilities))";}, {formula="Retained Earnings:Quarter[THIS] = Retained Earnings:Quarter[PREV] + Income Statement::Net Income:Quarter[THIS]+ Equity.Dividends:Quarter[THIS]";}, {formula="Retained Earnings:Year[THIS]:Q1 = Retained Earnings:Year[PREV]:Q4 + Income Statement::Net Income:Year[THIS]:Q1+ Equity.Dividends:Year[THIS]:Q1";}, {formula="Equity.Net = Capital Contribution + Retained Earnings // Dividends terminated in Q4";}, {formula="'Liabilities & Equity'.Total = Liabilities.Total + Equity.Net";});};}, {name="Cash Flows";categories=({name="Cash Flow Items";nodes=({name="Cash Flow";children=({name="Beginning Cash";}, {name="Net Income";}, {name=Operations;children=({name=Depreciation;}, {name="Customer Deposits";}, {name="Vendor Deposits Made";}, {name="Change in Accounts Payable";}, {name="Change in Accounts Receivable";}, {name="Change in Inventories";}, {name=Net;});}, {name=Investing;children=({name="Acquisition of Plant";}, {name="Acquisition of Property";}, {name="Acquisiton of Equipment";}, {name=Net;});}, {name=Financing;children=({name="Principal on Amortized Debt";}, {name="Short Term Borrowings";}, {name="Common Stock Issued or Retired";}, {name="Dividends Paid";}, {name=Net;});}, {name="Net Change in Cash";}, {name="Ending Cash";});});}, {globalCategoryNumber=1;name=Quarter;nodes=({name=Q1;}, {name=Q2;}, {name=Q3;}, {name=Q4;});}, {globalCategoryNumber=0;name=Year;nodes=({name=Year1;}, {name=Year2;});});dataspace=(0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1000000,0,1000000,1000000,1000000,1000000,"-576574",40000,2500,10000,50000,60000,27600,"-5100",250000,100000,75000,425000,150000,50000,0,"-10000",190000,"-816674",183326,183326,596865,40000,2500,0,5173,"-10000",5520,52153,0,0,50000,50000,"-8270","-10000",0,"-25000","-43270",555748,739074,739074,2052695,40000,2500,"-10000",10368,"-10000",6624,66244,0,0,63500,63500,"-9319","-10000",0,"-50000","-69319",1986120,2725194,2725194,3427109,40000,2000,0,"-15541",5000,3056,18403,0,0,6500,6500,"-4156","-5000",0,"-35000","-44156",3394856,6120050,6120050,1870074,40000,2000,20000,5173,7000,2600,17573,0,0,90000,90000,"-8000",0,0,"-15000","-23000",1774647,7894697,7894697,1024999,40000,2000,0,10368,"-10000",2400,59968,0,0,265650,265650,"-5255",0,0,"-5000","-10255",809062,8703759,8703759,3615499,40000,2000,"-20000","-15541","-1000",3400,44059,0,0,434350,434350,"-5000",0,0,0,"-5000",3220208,11923967);formulaspace={formulae=({formula="Year1:Q1:Common Stock Issued or Retired = Balance Sheet::Year1:Q1:Capital Contribution";}, {formula="Beginning Cash:Q2 = Balance Sheet::Current Assets.Cash:Q1";}, {formula="Beginning Cash:Quarter[THIS] = Ending Cash:Quarter[PREV]  Skip Q2";}, {formula="Beginning Cash:Year[THIS]:Q1 = Ending Cash:Year[PREV]:Q4";}, {formula="Net Income=Income Statement::Net Income";}, {formula="Depreciation=Income Statement::Depreciation";}, {formula="Customer Deposits:Quarter[THIS] = Balance Sheet::Deposits:Quarter[THIS]-Balance Sheet::Deposits:Quarter[PREV]";}, {formula="Customer Deposits:Year[THIS]:Q1= Balance Sheet::Deposits:Year[THIS]:Q1 - Balance Sheet::Deposits:Year[PREV]:Q4";}, {formula="Vendor Deposits Made:Quarter[THIS] = Balance Sheet::Vendor Deposits:Quarter[THIS] - Balance Sheet::Vendor Deposits:Quarter[PREV]";}, {formula="Vendor Deposits Made:Year[THIS]:Q1 = Balance Sheet::Vendor Deposits:Year[THIS]:Q1 - Balance Sheet::Vendor Deposits:Year[PREV]:Q4";}, {formula="'Change in Accounts Payable':Quarter[THIS] = Balance Sheet::Accounts Payable:Quarter[THIS]-Balance Sheet::Accounts Payable:Quarter[PREV]";}, {formula="'Change in Accounts Payable':Year[THIS]:Q1 = Balance Sheet::Accounts Payable:Year[THIS]:Q1-Balance Sheet::Accounts Payable:Year[PREV]:Q4";}, {formula="'Change in Accounts Receivable':Quarter[THIS] = Balance Sheet::Accounts Receivable:Quarter[THIS]-Balance Sheet::Accounts Receivable:Quarter[PREV]";}, {formula="'Change in Accounts Receivable':Year[THIS]:Q1 = Balance Sheet::Accounts Receivable:Year[THIS]:Q1-Balance Sheet::Accounts Receivable:Year[PREV]:Q4";}, {formula="'Change in Inventories':Quarter[THIS] = Balance Sheet::Inventories:Quarter[THIS]  - Balance Sheet::Inventories:Quarter[PREV] ";}, {formula="'Change in Inventories':Year[THIS]:Q1 = Balance Sheet::Inventories:Year[THIS]:Q1  - Balance Sheet::Inventories:Year[PREV]:Q4";}, {formula="Operations.Net =Depreciation + Customer Deposits - Vendor Deposits Made+ 'Change in Accounts Payable'-'Change in Accounts Receivable'-'Change in Inventories'";}, {formula="Acquisition of Plant:Quarter[THIS] = Balance Sheet::Plant:Quarter[THIS] - Balance Sheet::Plant:Quarter[PREV]";}, {formula="Acquisition of Plant:Year[THIS]:Q1 = Balance Sheet::Plant:Year[THIS]:Q1 - Balance Sheet::Plant:Year[PREV]:Q4";}, {formula="Acquisition of Property:Quarter[THIS] = Balance Sheet::Property:Quarter[THIS] - Balance Sheet::Property:Quarter[PREV]";}, {formula="Acquisition of Property:Year[THIS]:Q1 = Balance Sheet::Property:Year[THIS]:Q1 - Balance Sheet::Property:Year[PREV]:Q4";}, {formula="Acquisiton of Equipment:Quarter[THIS]= Balance Sheet::Equipment:Quarter[THIS] - Balance Sheet::Equipment:Quarter[PREV]";}, {formula="Acquisiton of Equipment:Year[THIS]:Q1= Balance Sheet::Equipment:Year[THIS]:Q1 - Balance Sheet::Equipment:Year[PREV]:Q4";}, {formula="Investing.Net=sum(summary(Investing))";}, {formula="Principal on Amortized Debt:Quarter[THIS] = Balance Sheet::Amortized Debt:Quarter[THIS] - Balance Sheet::Amortized Debt:Quarter[PREV]";}, {formula="Principal on Amortized Debt:Year[THIS]:Q1 = Balance Sheet::Amortized Debt:Year[THIS]:Q1 - Balance Sheet::Amortized Debt:Year[PREV]:Q4";}, {formula="Short Term Borrowings:Quarter[THIS] =Balance Sheet::Short Term Borrowings:Quarter[THIS] - Balance Sheet::Short Term Borrowings:Quarter[PREV]";}, {formula="Short Term Borrowings:Year[THIS]:Q1 =Balance Sheet::Short Term Borrowings:Year[THIS]:Q1 - Balance Sheet::Short Term Borrowings:Year[PREV]:Q4";}, {formula="Common Stock Issued or Retired:Quarter[THIS] = Balance Sheet::Capital Contribution:Quarter[THIS] - Balance Sheet::Capital Contribution:Quarter[PREV]";}, {formula="Common Stock Issued or Retired:Year[THIS]:Q1 = Balance Sheet::Capital Contribution:Year[THIS]:Q1 - Balance Sheet::Capital Contribution:Year[PREV]:Q4";}, {formula="Dividends Paid = Balance Sheet::Dividends";}, {formula="Financing.Net= sum(summary(Financing))";}, {formula="'Net Change in Cash'=Net Income + Operations.Net  - Investing.Net  + Financing.Net";}, {formula="Ending Cash=Beginning Cash+'Net Change in Cash'";});};});