List of Functions used in Web Site Sample Models

Below is a list of some of the sample models that are posted at the Quantrix web site (http://www.quantrix.com/Sample_Models.htm).  Beneath each model is a list of the functions used in the model.

Search this topic and the List of Functions in Sample Models Included with Quantrix for the function you want to see exemplified (for example, countif, or range, and note which web site sample model it is. If you do not find a model with the function you searched for, please send an email using the 'Send Feedback' link in the help, making sure to tell us which function(s) you want to see exemplified.  

Provided you find a sample model using the function, you can open or save the web site sample model with its example of the functions' formula to see how it is used in the context of the model, you can select the function in the functions pane and see where the function result is located in the matrix, and you can experiment.

 

Completed Flash Tour Cars Model - quantrix_-_flash_tour_cars_model.model

1. Variance = Actual - Budget

2. Net = Revenue - Total Expenses skip Variance

3. Budget:Revenue = 'Sales Projection (000)'::Channel.Total:Product.Total

4. Budget:Expenses:Year[THIS] = Budget:Expenses:Year[PREV] * 1.045

5. Total Expenses = sum(summary(Expenses))

1. Year[THIS] = Year[PREV] * 1.05

2. Channel.Total = sum(summary(Channel))

3. Product.Total = sum(summary(Product))

-----------------------------

Flash Tour Cars Model - quantrix_-_completed_flash_tutorial_model.model

1. YTD = sum(Q1 .. Q4)

2. Total = sum(Sedan .. SUV) skip YTD

3. Quarter[THIS] = Quarter[PREV] * Unit Sales Growth::Growth skip YTD, Total

4. Q1:Year[THIS] = Q4:Year[PREV] * Unit Sales Growth::Growth skip Total, YTD

5. Revenue = Units * 'Price/Cost per unit'::Price skip Total, YTD

6. COGS = Units * 'Price/Cost per unit'::'Cost/Unit' skip YTD, Total

7. Gross Profit = Revenue - COGS skip YTD, Total

8. All Regions = sum(summary(NY .. CT)) skip YTD, Total

All Regions = average(summary(Region))

1. Revenue = Sales Forecast::Revenue:Total skip YTD

2. COGS = Sales Forecast::COGS:Total skip YTD

3. Gross Profit = Sales Forecast::Gross Profit:Total skip YTD

4. Marketing = Sales Forecast::All Regions:Units:Total * General Assumptions::'Marketing/unit' skip YTD

5. Q1:Year1:Personnel = General Assumptions::Starting Personnel

6. Personnel:Quarter[THIS] = Personnel:Quarter[PREV] * 1.01 skip YTD

7. Q1:Personnel:Year[THIS] = Q4:Personnel:Year[PREV] * 1.01

8. YTD = sum(Q1 .. Q4)

9. Q1:Year1:Other = General Assumptions::Starting Other

10. Other:Quarter[THIS] = Other:Quarter[PREV] * 1.01 skip YTD

11. Q1:Other:Year[THIS] = Q4:Other:Year[PREV] * 1.01 skip YTD

12. Total = sum(Marketing .. Other) skip YTD

13. Net Profit before Tax = Gross Profit - Total skip YTD

-------------------------------------------

Comparison of Population Growth in the US and China - quantrix_-_comparison_of_population_growth_in_the_us_and_china_model.model

1. Both = sum(summary(Sex)) skip Percent Change

2. Total = sum(summary(Age)) skip Sex.Both, Percent Change

3. Percent Change = if('2025' = 0, 0, ('2025'/'2000') -1)

---------------------------------------------

Financial Planning Model - quantrix_-_financial_planning_model.model

1. Total Sales = sum(summary(Sales))

2. Total Cost of Performance = sum(summary(Cost of Goods Sold))

3. 'Total Development & Engineering' = sum(summary('Development & Engineering'))

4. Operating Costs.'Development & Engineering as % of sales' = clearerror('Total Development & Engineering' / Total Sales, 0)

5. Operating Costs.'Marketing & Sales as % of sales' = clearerror('Total Marketing & Sales' / Total Sales, 0)

6. Operating Costs.'Public Relations as % of sales' = clearerror(Total Publicity / Total Sales, 0)

7. Operating Costs.'Administration as % of sales' = clearerror(Total Administration / Total Sales, 0)

8. 'Total Marketing & Sales' = sum(summary('Marketing & Sales'))

9. Total Publicity = sum(summary(Public Relations))

10. Total Administration = sum(summary(Administration))

11. Total Operating Costs = sum(summary(Operating Costs))

12. Item.'Operating Costs as % of sales' = clearerror(Total Operating Costs / Total Sales, 0)

13. Gross Profit = Total Sales - Total Cost of Performance

14. Operating Profit = Gross Profit - Total Operating Costs

15. Item.Operating profit in % of sales = clearerror(Operating Profit / Total Sales, 0)

16. Profit before tax = Operating Profit - Financing expenditure - Financing income

17. Net Profit = Profit before tax - Income Tax

18. 'Net profit as % of sales' = clearerror(Net Profit / Total Sales, 0)

19. In Year[FIRST]:Month[FIRST], Accumulated Loss = min(Profit before tax, 0)

20. Accumulated Loss = min(Accumulated Loss:Month[PREV] + Profit before tax, 0)

21. In Jan, Accumulated Loss = min(Accumulated Loss:Dec:Year[PREV] + Profit before tax, 0)

22. In Year[FIRST]:Month[FIRST], Taxable Income = max(Profit before tax, 0)

23. Taxable Income = max(Profit before tax + Accumulated Loss:Month[PREV], 0)

24. In Jan, Taxable Income = max(Profit before tax + Accumulated Loss:Dec:Year[PREV], 0)

25. 'Product/service 1' = 'Sales & Gross Margin'::'1':Total Sales

26. 'Product/service 2' = 'Sales & Gross Margin'::'2':Total Sales

27. 'Product/service 3' = 'Sales & Gross Margin'::'3':Total Sales

28. 'Product/service 4' = 'Sales & Gross Margin'::'4':Total Sales

29. 'Direct production costs (wages)' = 'Sales & Gross Margin'::Total Product or Service:Direct Labor

30. Material costs = 'Sales & Gross Margin'::Total Product or Service:Material

31. Returns = 'Sales & Gross Margin'::Total Product or Service:Returns

32. 'Indirect production costs (overhead)' = 'Sales & Gross Margin'::Total Product or Service:Indirect Labor

33. 'Development & Engineering'.Wages = Personnel::Salaries:'Total Development & Engineering'

34. 'Development & Engineering'.Social and other personnel costs = Personnel::'Social & other costs':'Total Development & Engineering'

35. 'Development & Engineering'.Office material = Operating Cost Assumptions::'Development & Engineering'.Office material * Personnel::People:'Total Development & Engineering'

36. 'Development & Engineering'.Travel and meals = Operating Cost Assumptions::'Development & Engineering'.Travel and meals * Personnel::People:'Total Development & Engineering'

37. 'Development & Engineering'.Communication = Operating Cost Assumptions::'Development & Engineering'.Communication * Personnel::People:'Total Development & Engineering'

38. 'Marketing & Sales'.Office material = Operating Cost Assumptions::'Marketing & Sales'.Office material * Personnel::People:'Total Marketing & Sales'

39. 'Marketing & Sales'.Travel and meals = Operating Cost Assumptions::'Marketing & Sales'.Travel and meals * Personnel::People:'Total Marketing & Sales'

40. 'Marketing & Sales'.Communication = Operating Cost Assumptions::'Marketing & Sales'.Communication * Personnel::People:'Total Marketing & Sales'

41. Administration.Office material = Operating Cost Assumptions::Admin.Office material * Personnel::People:Total Administration

42. Administration.Travel and meals = Operating Cost Assumptions::Admin.Travel and meals * Personnel::People:Total Administration

43. Administration.Communication = Operating Cost Assumptions::Admin.Communication * Personnel::People:Total Administration

44. Public Relations.Publicity = Operating Cost Assumptions::Public Relations.Publicity * Total Sales

45. Exhibitions = Operating Cost Assumptions::Exhibitions * Total Sales

46. Other = Operating Cost Assumptions::Other * Total Sales

47. Insurance = Operating Cost Assumptions::Insurance * Total Sales

48. Provisions for unpaid invoices = Operating Cost Assumptions::Provisions for unpaid invoices * Total Sales

49. 'Water, electricity' = Operating Cost Assumptions::'Water, electricity' * Rent::Total office space

50. 'Maintenance, repairs' = Operating Cost Assumptions::'Maintenance, repairs' * Rent::Total office space

51. 'Development & Engineering'.Depreciation = 'Investments & Depreciation'::'Development/Engineering':Total:Depreciation

52. 'Marketing & Sales'.Depreciation = 'Investments & Depreciation'::Marketing:Total:Depreciation

53. Administration.Depreciation = 'Investments & Depreciation'::Administration:Total:Depreciation

54. 'Marketing & Sales'.Wages = Personnel::Salaries:'Total Marketing & Sales'

55. 'Commissions, bonuses' = Operating Cost Assumptions::'Commissions, bonuses' * Total Sales

56. 'Marketing & Sales'.Social and other personnel costs = Personnel::'Social & other costs':'Total Marketing & Sales'

57. Administration.Wages = Personnel::Salaries:Total Administration

58. Administration.Social and other personnel costs = Personnel::'Social & other costs':Total Administration

59. Office rent = Rent::Total cost of office rental

60. Income Tax = Taxable Income * General Assumptions::Tax Rate

1. Cash = Cash Flow Statement::CASH AT END OF PERIOD

2. Total liquid assets = sum(summary(Liquid Assets)) - Net receivables from customers

3. Total fixed assets = sum(summary(Fixed Assets.Fixed Assets))

4. Total cumulated depreciation = sum(summary(Cumulated Depreciation))

5. Net fixed assets = Total fixed assets - Total cumulated depreciation

6. Total Assets = Total liquid assets + Net fixed assets

7. 'Total Short-term debt' = sum(summary('Short-term debt'))

8. Total Equity = sum(summary(Equity))

9. Total Liabilities = Total Debt + Total Equity

10. 'Gross receivables from customers (30, 60 or 90 days)' = sum(selectbetween('Profit & Loss Statement'::Total Sales:Year:Month, Time Utility::Month

Number:Year:Month, Time Utility::Month Number - (General Assumptions::Receivables in days / 30) + 1, Time Utility::Month Number, 1))

11. Provisions for bad debts = General Assumptions::Provisions for bad debts * 'Gross receivables from customers (30, 60 or 90 days)'

12. Net receivables from customers = 'Gross receivables from customers (30, 60 or 90 days)' - Provisions for bad debts

13. 'Stock/inventory (30, 60 or 90 days)' = Inventory::Balance:Total Product or Service

14. In Year[FIRST]:Month[FIRST], Fixed Assets.Computer hardware and software = 'Investments & Depreciation'::Total Company:Computer hardware and software:Investment

15. Fixed Assets.Computer hardware and software = 'Investments & Depreciation'::Total Company:Computer hardware and software:Investment + Fixed Assets.Computer hardware and software:Month[PREV]

16. In Jan, Fixed Assets.Computer hardware and software = 'Investments & Depreciation'::Total Company:Computer hardware and software:Investment + Fixed Assets.Computer hardware and software:Dec:Year[PREV]

17. In Year[FIRST]:Month[FIRST], Fixed Assets.Furniture and other equipment = 'Investments & Depreciation'::Total Company:Furniture and other

equipment:Investment

18. Fixed Assets.Furniture and other equipment = 'Investments & Depreciation'::Total Company:Furniture and other equipment:Investment + Fixed

Assets.Furniture and other equipment:Month[PREV]

19. In Jan, Fixed Assets.Furniture and other equipment = 'Investments & Depreciation'::Total Company:Furniture and other equipment:Investment + Fixed

Assets.Furniture and other equipment:Dec:Year[PREV]

20. In Year[FIRST]:Month[FIRST], Fixed Assets.'Property, buildings and plant' = 'Investments & Depreciation'::Total Company:'Property, buildings and plant':Investment

21. Fixed Assets.'Property, buildings and plant' = 'Investments & Depreciation'::Total Company:'Property, buildings and plant':Investment + Fixed

Assets.'Property, buildings and plant':Month[PREV]

22. In Jan, Fixed Assets.'Property, buildings and plant' = 'Investments & Depreciation'::Total Company:'Property, buildings and plant':Investment + Fixed Assets.'Property, buildings and plant':Dec:Year[PREV]

23. Cumulated Depreciation.Computer hardware and software = 'Investments & Depreciation'::Total Company:Computer hardware and software:Cumulated Depreciation

24. Cumulated Depreciation.Furniture and other equipment = 'Investments & Depreciation'::Total Company:Furniture and other equipment:Cumulated Depreciation

25. Cumulated Depreciation.'Property, buildings and plant' = 'Investments & Depreciation'::Total Company:'Property, buildings and plant':Cumulated Depreciation

26. 'Open third-party invoices (creditors - assumes 30 days)' = Inventory::Purchases:Total Product or Service + 'Profit & Loss Statement'::Consultancy + 'Profit & Loss Statement'::'Development & Engineering'.Office material + 'Profit & Loss Statement'::'Development & Engineering'.Travel and meals + 'Profit & Loss Statement'::'Development & Engineering'.Communication + 'Profit & Loss Statement'::'Marketing & Sales'.Office material + 'Profit & Loss Statement'::'Marketing & Sales'.Travel and meals + 'Profit & Loss Statement'::'Marketing & Sales'.Communication + 'Profit & Loss Statement'::Public Relations.Publicity + 'Profit & Loss Statement'::Other + 'Profit & Loss Statement'::Administration.Office material + 'Profit & Loss Statement'::Administration.Travel and meals + 'Profit & Loss Statement'::Administration.Communication + 'Profit & Loss Statement'::'Prof. services (legal, accounting, etc.)' + 'Profit & Loss Statement'::'Water, electricity' + 'Profit & Loss Statement'::'Maintenance, repairs' + Production Labor Costs::Office material + Production Labor Costs::Travel and meals + Production Labor Costs::Communication

27. Provisions for wages = Personnel::Salaries:Total * (General Assumptions::Provisions for wages in days / 30)

28. In Jan, Provisions for taxes = 'Profit & Loss Statement'::Income Tax

29. Provisions for taxes = if(#Month = 4 #OR# #Month = 7 #OR# #Month = 9, 'Profit & Loss Statement'::Income Tax, Provisions for taxes:Month[PREV] + 'Profit & Loss Statement'::Income Tax)

30. 'Total long-term debt' = sum(summary('Long-term debt'))

31. Total Debt = 'Total Short-term debt' + 'Total long-term debt'

32. In Year[FIRST]:Month[FIRST], 'Profit/loss carried forward' = 'Profit & Loss Statement'::Net Profit

33. 'Profit/loss carried forward' = 'Profit/loss carried forward':Month[PREV] + 'Profit & Loss Statement'::Net Profit

34. In Jan, 'Profit/loss carried forward' = 'Profit/loss carried forward':Dec:Year[PREV] + 'Profit & Loss Statement'::Net Profit

35. In Year[FIRST]:Month[FIRST], Share capital = Cash Flow Statement::EQUITY FINANCING

36. Share capital = Share capital:Month[PREV] + Cash Flow Statement::EQUITY FINANCING

1. CASH AT START OF PERIOD = CASH AT END OF PERIOD:Month[PREV]

2. In Jan, CASH AT START OF PERIOD = CASH AT END OF PERIOD:Dec:Year[PREV]

3. Net profit = 'Profit & Loss Statement'::Net Profit

4. 'Plus depreciation/amortization' = 'Investments & Depreciation'::Total Company:Total:Depreciation

5. In Year[FIRST]:Month[FIRST], Liabilities from performance = Balance Sheet::'Open third-party invoices (creditors - assumes 30 days)'

6. Liabilities from performance = Balance Sheet::'Open third-party invoices (creditors - assumes 30 days)' - Balance Sheet::'Open third-party invoices (creditors - assumes 30 days)':Month[PREV]

7. In Jan, Liabilities from performance = Balance Sheet::'Open third-party invoices (creditors - assumes 30 days)' - Balance Sheet::'Open third-party invoices (creditors - assumes 30 days)':Dec:Year[PREV]

8. In Year[FIRST]:Month[FIRST], Wage provisions = Balance Sheet::Provisions for wages

9. Wage provisions = Balance Sheet::Provisions for wages - Balance Sheet::Provisions for wages:Month[PREV]

10. In Jan, Wage provisions = Balance Sheet::Provisions for wages - Balance Sheet::Provisions for wages:Dec:Year[PREV]

11. In Year[FIRST]:Month[FIRST], Tax provisions = Balance Sheet::Provisions for taxes

12. Tax provisions = Balance Sheet::Provisions for taxes - Balance Sheet::Provisions for taxes:Month[PREV]

13. In Jan, Tax provisions = Balance Sheet::Provisions for taxes - Balance Sheet::Provisions for taxes:Dec:Year[PREV]

14. In Year[FIRST]:Month[FIRST], 'Long-term debt/loans' = Balance Sheet::'Total long-term debt'

15. 'Long-term debt/loans' = Balance Sheet::'Total long-term debt' - Balance Sheet::'Total long-term debt':Month[PREV]

16. Total Cash Inflow = sum(summary(Cash Inflow))

17. In Year[FIRST]:Month[FIRST], Net receivables from performance = Balance Sheet::Net receivables from customers

18. Net receivables from performance = Balance Sheet::Net receivables from customers - Balance Sheet::Net receivables from customers:Month[PREV]

19. In Jan, Net receivables from performance = Balance Sheet::Net receivables from customers - Balance Sheet::Net receivables from customers:Dec:Year[PREV]

20. In Year[FIRST]:Month[FIRST], Stock = Balance Sheet::'Stock/inventory (30, 60 or 90 days)'

21. Stock = Balance Sheet::'Stock/inventory (30, 60 or 90 days)' - Balance Sheet::'Stock/inventory (30, 60 or 90 days)':Month[PREV]

22. In Jan, Stock = Balance Sheet::'Stock/inventory (30, 60 or 90 days)' - Balance Sheet::'Stock/inventory (30, 60 or 90 days)':Dec:Year[PREV]

23. In Year[FIRST]:Month[FIRST], Gross fixed assets = Balance Sheet::Total fixed assets

24. Gross fixed assets = Balance Sheet::Total fixed assets - Balance Sheet::Total fixed assets:Month[PREV]

25. In Jan, Gross fixed assets = Balance Sheet::Total fixed assets - Balance Sheet::Total fixed assets:Dec:Year[PREV]

26. Total Cash Deployed = sum(summary(Minus changes in))

27. 'INCREASE / (DECREASE) IN CASH' = Total Cash Inflow - Total Cash Deployed

28. CASH AT END OF PERIOD = CASH AT START OF PERIOD + 'INCREASE / (DECREASE) IN CASH' + EQUITY FINANCING

1. Sales = 'Profit & Loss Statement'::Total Sales - (Balance Sheet::Net receivables from customers:Month[THIS] - Balance Sheet::Net receivables from customers:Month[PREV]) - 'Profit & Loss Statement'::Provisions for unpaid invoices

2. In Jan, Sales = 'Profit & Loss Statement'::Total Sales - (Balance Sheet::Net receivables from customers:Year[THIS] - Balance Sheet::Net receivables from customers:Dec:Year[PREV]) - 'Profit & Loss Statement'::Provisions for unpaid invoices

3. Interest income = 'Profit & Loss Statement'::Financing income

4. Total income = sum(summary(Income))

5. Salaries = Personnel::Salaries:Total + Balance Sheet::Provisions for wages:Month[PREV] - Balance Sheet::Provisions for wages

6. In Jan, Salaries = Personnel::Salaries:Total + Balance Sheet::Provisions for wages:Dec:Year[PREV] - Balance Sheet::Provisions for wages

7. Social and other personnel costs = Personnel::'Social & other costs':Total

8. 'Commissions, bonuses' = 'Profit & Loss Statement'::'Development & Engineering'.Bonuses + 'Profit & Loss Statement'::'Commissions, bonuses' + 'Profit & Loss Statement'::Administration.Bonuses + Production Labor Costs::Bonuses

9. 'Material purchases (assumes 30 days)' = Inventory::Total Product or Service:Month[PREV]

10. In Jan, 'Material purchases (assumes 30 days)' = Inventory::Total Product or Service:Dec:Year[PREV]

11. Returns = 'Profit & Loss Statement'::Returns

12. In Jan, Advertising = 'Profit & Loss Statement'::Publicity:Dec:Year[PREV]

13. Advertising = 'Profit & Loss Statement'::Publicity:Month[PREV]

14. In Jan, Publicity material = 'Profit & Loss Statement'::Other:Dec:Year[PREV]

15. Publicity material = 'Profit & Loss Statement'::Other:Month[PREV]

16. Exhibitions = 'Profit & Loss Statement'::Exhibitions

17. Office material = 'Profit & Loss Statement'::'Development & Engineering'.Office material:Month[PREV] + 'Profit & Loss Statement'::'Marketing &

Sales'.Office material:Month[PREV] + 'Profit & Loss Statement'::Administration.Office material:Month[PREV] + Production Labor Costs::Office material:Month [PREV]

18. In Jan, Office material = 'Profit & Loss Statement'::'Development & Engineering'.Office material:Dec:Year[PREV] + 'Profit & Loss Statement'::'Marketing & Sales'.Office material:Dec:Year[PREV] + 'Profit & Loss Statement'::Administration.Office material:Dec:Year[PREV] + Production Labor Costs::Office material:Dec:Year[PREV]

19. Travel and meals = 'Profit & Loss Statement'::'Development & Engineering'.Travel and meals:Month[PREV] + 'Profit & Loss Statement'::'Marketing & Sales'.Travel and meals:Month[PREV] + 'Profit & Loss Statement'::Administration.Travel and meals:Month[PREV] + Production Labor Costs::Travel and meals:Month[PREV]

20. In Jan, Travel and meals = 'Profit & Loss Statement'::'Development & Engineering'.Travel and meals:Dec:Year[PREV] + 'Profit & Loss Statement'::'Marketing & Sales'.Travel and meals:Dec:Year[PREV] + 'Profit & Loss Statement'::Administration.Travel and meals:Dec:Year[PREV] + Production Labor Costs::Travel and meals:Dec:Year[PREV]

21. Communication = 'Profit & Loss Statement'::'Development & Engineering'.Communication:Month[PREV] + 'Profit & Loss Statement'::'Marketing & Sales'.Communication:Month[PREV]+ 'Profit & Loss Statement'::Administration.Communication:Month[PREV] + Production Labor Costs::Communication:Month[PREV]

22. In Jan, Communication = 'Profit & Loss Statement'::'Development & Engineering'.Communication:Dec:Year[PREV] + 'Profit & Loss Statement'::'Marketing & Sales'.Communication:Dec:Year[PREV]+ 'Profit & Loss Statement'::Administration.Communication:Dec:Year[PREV] + Production Labor Costs::Communication:Dec:Year [PREV]

23. 'Maintenance/repairs' = 'Profit & Loss Statement'::'Maintenance, repairs':Month[PREV]

24. In Jan, 'Maintenance/repairs' = 'Profit & Loss Statement'::'Maintenance, repairs':Dec:Year[PREV]

25. Rent = Rent::Total cost of office rental + Rent::Total cost of production area

26. Water and electricity = 'Profit & Loss Statement'::'Water, electricity':Month[PREV]

27. In Jan, Water and electricity = 'Profit & Loss Statement'::'Water, electricity':Dec:Year[PREV]

28. Insurance = 'Profit & Loss Statement'::Insurance

29. External consultants = 'Profit & Loss Statement'::Consultancy:Month[PREV]

30. In Jan, External consultants = 'Profit & Loss Statement'::Consultancy:Dec:Year[PREV]

31. 'Prof. services (legal, accounting, etc.)' = 'Profit & Loss Statement'::'Prof. services (legal, accounting, etc.)':Month[PREV]

32. In Jan, 'Prof. services (legal, accounting, etc.)' = 'Profit & Loss Statement'::'Prof. services (legal, accounting, etc.)':Dec:Year[PREV]

33. Tax = Balance Sheet::Provisions for taxes:Month[PREV] - Balance Sheet::Provisions for taxes + 'Profit & Loss Statement'::Income Tax

34. In Jan, Tax = Balance Sheet::Provisions for taxes:Dec:Year[PREV] - Balance Sheet::Provisions for taxes + 'Profit & Loss Statement'::Income Tax

35. Capital expenditure = 'Investments & Depreciation'::Total Company:Total:Investment

36. Interest payments = 'Profit & Loss Statement'::Financing expenditure

37. Total expenditure = sum(summary(Expenditures))

38. 'Increase/decrease in operating cash' = Total income - Total expenditure

39. Funds received from financing = Cash Flow Statement::EQUITY FINANCING

40. Funds received from credits = Balance Sheet::'Total long-term debt' - Balance Sheet::'Total long-term debt':Month[PREV]

41. In Jan, Funds received from credits = Balance Sheet::'Total long-term debt' - Balance Sheet::'Total long-term debt':Dec:Year[PREV]

42. CASH AT START OF PERIOD = CASH AT END OF PERIOD:Month[PREV]

43. In Jan, CASH AT START OF PERIOD = CASH AT END OF PERIOD:Dec:Year[PREV]

44. CASH AT END OF PERIOD = CASH AT START OF PERIOD + 'Increase/decrease in operating cash' + Funds received from financing + Funds received from credits Item = Balance Sheet::Month[LAST]

1. Item = sum(summary(Cash Flow Statement::Month)) Skip CASH AT START OF PERIOD, CASH AT END OF PERIOD

2. CASH AT START OF PERIOD = Cash Flow Statement::CASH AT START OF PERIOD:Month[FIRST]

3. CASH AT END OF PERIOD = Cash Flow Statement::CASH AT END OF PERIOD:Month[LAST]

1. Item = sum(summary('Income & Expenditures'::Month)) skip CASH AT START OF PERIOD, CASH AT END OF PERIOD

2. CASH AT START OF PERIOD = 'Income & Expenditures'::CASH AT START OF PERIOD:Month[FIRST]

3. CASH AT END OF PERIOD = 'Income & Expenditures'::CASH AT END OF PERIOD:Month[LAST]

1. Total Sales = No of Units * Average Selling Price skip Total Product or Service

2. % Share of Total Sales = clearerror(Total Sales / Total Product or Service:Total Sales, 0)

3. Material = Material Costs per Unit * No of Units skip Total Product or Service

4. Direct Labor = Production Labor Costs::Total Direct Labor * % Share of Total Sales Skip Total Product or Service

5. Indirect Labor = Production Labor Costs::Total Indirect Labor * % Share of Total Sales Skip Total Product or Service

6. Returns = General Assumptions::'Returns as % of sales' * Total Sales skip Total Product or Service

7. Total Direct Costs = sum(summary(Direct Costs)) skip Total Product or Service

8. Gross Margin = Total Sales - Total Direct Costs skip Total Product or Service

9. 'Gross Profit as %  of sales' = clearerror(Gross Margin / Total Sales, 0)

10. Total Product or Service = sum(summary(Product or Service)) Skip Average Selling Price, % Share of Total Sales, Material Costs per Unit, 'Gross Profit as %  of sales'

1. In Year[FIRST], Monthly Wage = Monthly Wage Assumptions::Starting Monthly Wage skip Total,Total Production,'Total Development & Engineering','Total Marketing & Sales',Total Administration

2. Monthly Wage = Monthly Wage:Year[PREV] * (1 + General Assumptions::Salary Inflation) skip Total,Total Production,'Total Development & Engineering','Total Marketing & Sales',Total Administration

3. Salaries = People * Monthly Wage skip Total,Total Production,'Total Development & Engineering','Total Marketing & Sales',Total Administration

4. 'Social & other costs' = Salaries * General Assumptions::'Social & Other Personnel Costs as % of Salary' skip Total Production,'Total Development & Engineering','Total Marketing & Sales',Total Administration,Total

5. Total = sum(summary(Role))

6. Total Production = sum(summary(Production))

7. 'Total Development & Engineering' = sum(summary('Development & Engineering'))

8. 'Total Marketing & Sales' = sum(summary('Marketing & Sales'))

9. Total Administration = sum(summary(Administration))

1. 'No. of personnel' = sum(summary(Personnel::People:Production))

2. Salaries = sum(summary(Personnel::Salaries:Production))

3. Social costs = sum(summary(Personnel::'Social & other costs':Production))

4. Total Direct Labor = Salaries + Bonuses + Social costs

5. Office material = 'No. of personnel' * Production Cost Assumptions::Office material per person

6. Travel and meals = 'No. of personnel' * Production Cost Assumptions::Travel and meals per person

7. Communication = 'No. of personnel' * Production Cost Assumptions::Communication per person

8. Rent = Rent::Total cost of production area

9. Depreciation = 'Investments & Depreciation'::Production:Total:Depreciation

10. Total Indirect Labor = sum(summary(Indirect Labor Costs))

1. In Year[FIRST]:Month[FIRST], Purchases = Balance + 'Sales & Gross Margin'::Material skip Total Product or Service

2. Purchases = select('Sales & Gross Margin'::Material:Year:Month, Time Utility::Month Number:Year:Month, Time Utility::Month Number + General

Assumptions::'Stock/inventory in days' / 30) skip Total Product or Service, Month[FIRST]:Year[FIRST]

3. In Balance, Product or Service = sum(selectbetween('Sales & Gross Margin'::Material:Year:Month, Time Utility::Month Number:Year:Month, Time Utility::Month

Number, Time Utility::Month Number + (General Assumptions::'Stock/inventory in days' / 30) + 1)) skip Total Product or Service

4. Total Product or Service = sum(summary(Product or Service))

1. Office.Cost per m2 = Operating Cost Assumptions::Office Space cost per m2

2. Plant.Cost per m2 = Production Cost Assumptions::Plant Space cost per m2

3. Total cost of office rental = Total office space * Office.Cost per m2

4. Total cost of production area = Total production area * Plant.Cost per m2

5. Office.'Area (m2) per person' = clearerror(Total office space / (Personnel::People:'Total Development & Engineering' + Personnel::People:'Total Marketing

& Sales' + Personnel::People:Total Administration), 0)

6. Plant.'Area (m2) per person' = clearerror(Total production area / Personnel::People:Total Production, 0)

1. Total = sum(summary(Asset)) skip Total Company, Depreciation Months

2. Total Company = sum(summary(Area)) Skip Depreciation Months

3. In Total Company, Depreciation Months = clearerror(average(summary(Area:Depreciation Months))) Skip Total

1. In Month[FIRST]:Year[FIRST], Production:Investment = Investment Assumptions::Production * Personnel::Total Production:People skip Total

2. In Investment, Production:Investment = Investment Assumptions::Production * max((Personnel::Total Production:People:Month[THIS] - Personnel::Total Production:People:Month[PREV]), 0) skip Total

3. In Jan, Production:Investment = Investment Assumptions::Production * max((Personnel::Total Production:People:Month[THIS] - Personnel::Total Production:People:Dec:Year[PREV]), 0) skip Total

4. In Year[FIRST]:Month[FIRST], 'Development/Engineering':Investment = Investment Assumptions::'Development/Engineering' * Personnel::'Total Development & Engineering':People skip Total

5. In Investment, 'Development/Engineering' = Investment Assumptions::'Development/Engineering' * max((Personnel::'Total Development &

Engineering':People:Month[THIS] - Personnel::'Total Development & Engineering':People:Month[PREV]), 0) skip Total

6. In Jan, 'Development/Engineering':Investment = Investment Assumptions::'Development/Engineering' * max((Personnel::'Total Development &

Engineering':People:Month[THIS] - Personnel::'Total Development & Engineering':People:Dec:Year[PREV]), 0) skip Total

7. In Month[FIRST]:Year[FIRST], Marketing:Investment = Investment Assumptions::Marketing * Personnel::'Total Marketing & Sales':People skip Total

8. In Investment, Marketing = Investment Assumptions::Marketing * max((Personnel::'Total Marketing & Sales':People:Month[THIS] - Personnel::'Total Marketing

& Sales':People:Month[PREV]), 0) skip Total

9. In Jan, Marketing:Investment = Investment Assumptions::Marketing * max((Personnel::'Total Marketing & Sales':People:Month[THIS] - Personnel::'Total

Marketing & Sales':People:Dec:Year[PREV]), 0) skip Total

10. In Month[FIRST]:Year[FIRST], Administration:Investment = Investment Assumptions::Administration * Personnel::Total Administration:People skip Total

11. In Investment, Administration = Investment Assumptions::Administration * max((Personnel::Total Administration:People:Month[THIS] - Personnel::Total Administration:People:Month[PREV]), 0) skip Total

12. In Jan, Administration:Investment = Investment Assumptions::Administration * max((Personnel::Total Administration:People:Month[THIS] - Personnel::Total Administration:People:Dec:Year[PREV]), 0) skip Total

13. In Year[FIRST]:Month[FIRST], Depreciable Balance = Investment skip Total,Total Company

14. Depreciable Balance = Depreciable Balance:Month[PREV] + Investment:Month[THIS] - select(Investment:Year:Month, Time Utility::Month Number:Year:Month, #Month + 12 * (#Year - 1) - Investment Assumptions::Depreciation Months) skip Total,Total Company

15. In Jan, Depreciable Balance = Depreciable Balance:Dec:Year[PREV] + Investment - select(Investment:Year:Month, Time Utility::Month Number:Year:Month, #Month + 12 * (#Year - 1) - Investment Assumptions::Depreciation Months) skip Total,Total Company

16. Depreciation = clearerror(Depreciable Balance / Investment Assumptions::Depreciation Months, 0) skip Total,Total Company

17. In Year[FIRST]:Month[FIRST], Cumulated Depreciation = Depreciation skip Total,Total Company

18. Cumulated Depreciation = Cumulated Depreciation:Month[PREV] + Depreciation skip Total,Total Company

19. In Jan, Cumulated Depreciation = Cumulated Depreciation:Dec:Year[PREV] + Depreciation skip Total,Total Company

20. Total Company = sum(summary(Area))

21. Total = sum(summary(Asset)) skip Total Company

Month Number = #Month + 12 * (#Year - 1)

-------------------------------------------

Capital Investment Payback Model - quantrix_-_capital_investment_payback_model.model

1. Total Costs = sum(Relevant Controllable Costs)

2. EBITDA = Incremental Value of New Business-Total Costs

3. Income before taxes = EBITDA-'Less: Depreciation'

4. Taxes = Income before taxes*Assumptions::Tax Rate

5. 'Less: Depreciation' = sln('1':'Minus: Initial Investment',0,10)

6. Net Income = Income before taxes-Taxes

7. 'Plus: Depreciation' = sln('1':'Minus: Initial Investment',0,10)

8. Net Cash Flow = Net Income+'Plus: Depreciation'-'Minus: Initial Investment'

9. Cumulative Net Cash Flow:Year[THIS] = sum(Net Cash Flow:Year[FIRST] .. Net Cash Flow:Year[THIS])

10. Discounted Cash Flow = Net Cash Flow/(1+Assumptions::Discount Rate)^#Year

11. Cumulative Discounted Cash Flow:Year[THIS] = NPV(Assumptions::Discount Rate,Net Cash Flow:Year[FIRST] .. Net Cash Flow:Year[THIS])

12. Undiscounted Payback Period = if(Cumulative Net Cash Flow:Year[PREV]>0,"",if(Cumulative Net Cash Flow<0,"",#Year-(Cumulative Net Cash Flow/Net Cash Flow))) 13. Discounted Payback Period = if(Cumulative Discounted Cash Flow:Year[PREV]>0,"",if(Cumulative Discounted Cash Flow<0,"",#Year-(Cumulative Discounted Cash Flow/Discounted Cash Flow)))

14. '1':'Minus: Initial Investment' = Assumptions::Initial Investment

1. IRR of Cash Flows = irr(Investment Payback Analysis::Net Cash Flow:Year[FIRST] .. Net Cash Flow:Year[LAST])

2. NPV of Cash Flow less Investment =  npv(Assumptions::Discount Rate,Investment Payback Analysis::Cumulative Net Cash Flow:Year[LAST]) -

Assumptions::Initial Investment

3. Profitability Index = NPV of Cash Flow less Investment/Assumptions::Initial Investment

--------------------------------------------------

Accounts Receivable Payment Planning Model - quantrix_-_accounts_receivable_payment_planning_model.model

1. In Jan, AR Balance = Sales * if(Days Sales Assumptions::Payment Terms >= 0, 1, 0) Skip Total

2. AR Balance = AR Balance:Month[PREV] + Sales:Month[THIS] - Payments Skip Total

// This formula is calculating a current AR balance for individual large accounts and for all other revenue based on the expected timing of sales and payments.

3. Payments = indirect("Sales:Month[THIS-"&roundup(Days Sales Assumptions::Payment Terms / 30, 0)&"]") Skip Total

// This formula is calculating expected payments based on the timing of sales and expected payment behavior.

4. Total = sum(summary(Source))

-------------------------------------------------

Balance Sheet Model - quantrix_-_balance_sheet_model.model

1. Total Current Assets = sum(summary(Current Assets))

2. Total Other Assets = sum(summary(Assets.Other Assets))

3. Total Assets = sum(summary(Assets))

4. Total Current Liabilities = sum(summary(Current Liabilities))

5. Total Other Liabilities = sum(summary(Other Liabilities))

6. Total Liabilities = sum(summary(Liabilities))

7. Total Equity = sum(summary(Owners Equity))

8. Total Liabilities and Owners Equity = sum(summary(Liabilities and Owners Equity))

1. Current Ratio = Balance Sheet::Total Current Assets/Balance Sheet::Total Current Liabilities

2. Quick Ratio = (Balance Sheet::Total Current Assets-Balance Sheet::Inventories)/Balance Sheet::Total Current Liabilities

3. Cash Ratio = Balance Sheet::Cash/Balance Sheet::Total Current Liabilities

4. Working Captial = Balance Sheet::Total Current Assets-Balance Sheet::Total Current Liabilities

-------------------------------------------------

Investment Banking Model - quantrix_-_investment_banking_model.model

1. Closing Price:Dates=Stock Data Matrix::Dates

2. Key = @Stock skip Average

3. In 'Problem 1 & 4', Average = average(summary(Dates)) skip Key

4. Date[THIS]:Daily Return = (Date[THIS]:Closing Price-Date[PREV]:Closing Price)/Date[PREV]:Closing Price skip Average

5. Investment Value:'3-Jan-00' = 200

6. In 'Problem 1 & 4', Investment Value:Date[THIS] = Investment Value:Date[PREV]*(1+Daily Return:Date[THIS]) skip '3-Jul-00', Average

7. In 'Problem 1 & 4', Investment Value:'3-Jul-00' = Investment Allocation::Day 126 Allocation * (1+Daily Return:'3-Jul-00')

8. In Problem 5, Investment Value:Date[THIS] = Investment Value:Date[PREV]*(1+Daily Return:Date[THIS]) skip Average

1. Init Investment = Investment Schedule::Investment Value:'3-Jan-00'

2. In 'Problem 1 & 4', 'Value @ 125 days' = Investment Schedule::Investment Value:'30-Jun-00'

3. In 'Problem 1 & 4', Net Change = 'Value @ 125 days'-Init Investment

4. In 'Problem 1 & 4', Sum of Portfolio = Investment Summary::Value of Portfolio at 125 days

5. In 'Problem 1 & 4', Day 126 Allocation = Sum of Portfolio*Reallocation Percent

6. EOY Value = Investment Schedule::Investment Value:'29-Dec-00'

7. EOY Return = EOY Value-Init Investment

1. Value of Portfolio at 125 days = sum(Investment Allocation::'Value @ 125 days')

2. Value of Portofolio at End of Year = sum(Investment Schedule::Investment Value:'29-Dec-00')

3. Init Value = sum(Investment Allocation::Init Investment)

4. EOY Return = Value of Portofolio at End of Year-Init Value

1. In Covar,XTicker = covar(select(Investment Schedule::'Problem 1 & 4':Daily Return:Dates,Investment Schedule::'Problem 1 & 4':Key:Dates,@XTicker),select (Investment Schedule::'Problem 1 & 4':Daily Return:Dates,Investment Schedule::'Problem 1 & 4':Key:Dates,@YTicker))

2. In Correl, XTicker = correl(select(Investment Schedule::'Problem 1 & 4':Daily Return:Dates,Investment Schedule::'Problem 1 & 4':Key:Dates,@XTicker),select(Investment Schedule::'Problem 1 & 4':Daily Return:Dates,Investment Schedule::'Problem 1 & 4':Key:Dates,@YTicker))

1. Intercept = intercept(Linear Regression Table::Investment Value,Linear Regression Table::Day Key)

2. Slope = slope(Linear Regression Table::Investment Value,Linear Regression Table::Day Key)

3. RValue = correl(Linear Regression Table::Investment Value,Linear Regression Table::Linear Regression)

4. Standard Deviation = stdev(Investment Schedule::Problem 5:Daily Return)

-------------------------------------------

Black Sholes Option Pricing Model - quantrix_-_black_scholes_option_pricing_model.model

1. Variance = Standard Deviation^2

2. d1 = (LN(Stk Price/Exercise Price)+('Risk-free Rate (Annual)'-Dividend Yield+(0.5*Standard Deviation^2))*Maturity in Years)/(Standard Deviation*(Maturity in Years^0.5))

3. d2 = d1-(Standard Deviation*(Maturity in Years^0.5))

4. 'N(d1)' = normsdist(d1)

5. 'N(d2)' = normsdist(d2)

6. 'Black-Scholes Call Value'=Stk Price*EXP(-Dividend Yield*Maturity in Years)*'N(d1)'-Exercise Price*EXP(-'Risk-free Rate (Annual)'*Maturity in Years)*'N (d2)'

7. 'Black-Scholes Put Value'=((Exercise Price*EXP(-'Risk-free Rate (Annual)'*Maturity in Years))*(1-'N(d2)'))-((Stk Price*EXP(-Dividend Yield*Maturity in Years))*(1-'N(d1)'))

8. Intrinsic Value of Call = if(Stk Price-Exercise Price>0,Stk Price-Exercise Price,0)

9. Time Value of Call = 'Black-Scholes Call Value'-Intrinsic Value of Call

10. Intrinsic Value of Put = if(Exercise Price-Stk Price>0,Exercise Price-Stk Price,0)

11. Time Value of Put = 'Black-Scholes Put Value'-Intrinsic Value of Put

12. Exercise Price = 105

13. Dividend Yield = 0

14. Standard Deviation = 0.2783 skip SD

15. Inputs.Stk Price = 100 skip Factors.Stock Price

16. Maturity in Years = 0.5 skip Maturity Yrs

17. 'Risk-free Rate (Annual)' = .06 skip Risk Free Rate

---------------------------------------

Bond Pricing Model - quantrix_-_bond_pricing_model.model

1. STLMNT = NOW()

2. MATURITY = DATE(Year(STLMNT)+Value(@YEAR),Month(STLMNT),Day(STLMNT))

3. COUPON = Bond Assumptions::COUPON

4. FREQUENCY = Bond Assumptions::FREQUENCY

5. PRICE = -(pv((General Assumptions::TO YIELD/FREQUENCY), value(@YEAR)*FREQUENCY, General Assumptions::BOND PRICE*COUPON)/FREQUENCY, General Assumptions::BOND PRICE))

6. PAR AMOUNT OWNED = General Assumptions::INVESTED/(PRICE/General Assumptions::BOND PRICE)

----------------------------------------------

Commercial Real Estate Valuation and Feasibility Model - quantrix_-_commercial_real_estate_valuation_and_feasibility_model.model

1. 'Property Valuation:' = (Proforma Financial Statements::Year1:Income Statement.Net Operating Income / (Assumptions::Cap Rate at Purchase * 100)) * 100

2. Loan Amount = 'Property Valuation:' * Assumptions::Loan to Value ratio

3. Equity Required = 'Property Valuation:' - Loan Amount

4. Mortgage Loan Constant = (Assumptions::Stated Annual Interest rate / (1 - (1 / (1 + Assumptions::Stated Annual Interest rate)^Assumptions::'Loan Term (years)')))

5. 'NPV of Real Cash Flow:' = sum(Proforma Financial Statements::Present Value of Real Cash Flow)

6. 'After Tax Real Internal Rate of Return:' = irr(Proforma Financial Statements::Real Cash Flow to Owner, Assumptions::Stated Annual Interest rate)

1. In Year1, Annual Gross Rental Income = Assumptions::'Annual Gross Rent, first year'

2. Annual Gross Rental Income = Annual Gross Rental Income:Year[PREV] * (1 + Assumptions::Annual % change in rent) Skip Year1

3. Vacancy and Collection Losses = Annual Gross Rental Income * -Assumptions::Vacancy and Collection factor

4. Effective Rental = Annual Gross Rental Income + Vacancy and Collection Losses

5. In Year1, Operating Expenses = Assumptions::'Operating Expenses, first year'

6. Operating Expenses = Operating Expenses:Year[PREV] * (1 + Assumptions::Annual % change in expenses) Skip Year1

7. Income Statement.Net Operating Income = Effective Rental - Operating Expenses

8. Interest Expense = Mortgage Loan Amortization::Interest Portion of Payment

9. 'Depreciation (cost recovery)' = ('Defined Input & Outputs'::'Property Valuation:' * Assumptions::Percent of price in improvements) / -'Defined Input &

Outputs'::'Recovery period (years)' Skip Year0

10. Taxable Income = Income Statement.Net Operating Income + Interest Expense + 'Depreciation (cost recovery)'

11. Income Statement.Income Tax Liability = -Taxable Income * 'Defined Input & Outputs'::'Income tax rate (Corporate)'

12. Net Income After Tax = Taxable Income + Income Statement.Income Tax Liability

13. Cash Flow.Net Operating Income = Income Statement.Net Operating Income

14. Debt Service = -Mortgage Loan Amortization::Annual Mortgage Payment

15. Cash Flow.Income Tax Liability = Income Statement.Income Tax Liability Skip Year11

16. 'Equity Dividend (cash to owner)' = Cash Flow.Net Operating Income + Debt Service + Cash Flow.Income Tax Liability Skip Year11

17. In Year0, 'Down Payment/Reversion' = -'Defined Input & Outputs'::Equity Required

18. Total Cash Flow to Owner = 'Equity Dividend (cash to owner)' + 'Down Payment/Reversion'

19. Purchasing Power Adjustment = Purchasing Power Adjustment:Year[PREV] * (1 + Assumptions::CPI Annual Increase) Skip Year11

20. Real Cash Flow to Owner = Total Cash Flow to Owner / Purchasing Power Adjustment Skip Year11

21. In Year10, 'Down Payment/Reversion' = Analysis of Reversion on Sale::Reversion in nominal dollars to owner at sales date

22. Present Value of Real Cash Flow = Real Cash Flow to Owner / (1 + Assumptions::'After tax, Real Discount rate')^(#Year-1) Skip Year11

23. In Year0, Purchasing Power Adjustment = 1

1. 'Net Operating Income Projected, Year After Sale (Year 11)' = Proforma Financial Statements::Year11:Income Statement.Net Operating Income

2. Cap Rate At Sale Date = Assumptions::Cap Rate assumed at date of sale

3. 'Capitalized Value (Sale Price)' = 'Net Operating Income Projected, Year After Sale (Year 11)' / Cap Rate At Sale Date

4. Transaction Cost = 'Capitalized Value (Sale Price)' * -Assumptions::'Transaction costs as % of sales price'

5. Net Sales Price = 'Capitalized Value (Sale Price)' + Transaction Cost

6. 'Book Value At Sales Date (cost-dep)' = -('Defined Input & Outputs'::'Property Valuation:' + sum(Proforma Financial Statements::Year1:'Depreciation (cost recovery)' .. Year10:'Depreciation (cost recovery)'))

7. 'Capital Gain ( Net Price - BV)' = Net Sales Price + 'Book Value At Sales Date (cost-dep)'

8. Capital Gains Tax = 'Capital Gain ( Net Price - BV)' * 'Defined Input & Outputs'::Capital Gains tax rate

9. Mortgage Balance Owed = Mortgage Loan Amortization::Year10:'Balance Owed, end of year'

10. Reversion in nominal dollars to owner at sales date = Net Sales Price - Capital Gains Tax - Mortgage Balance Owed

1. In Year1, 'Balance Owed, beginning of year' = 'Defined Input & Outputs'::Loan Amount

2. 'Balance Owed, beginning of year' = 'Balance Owed, end of year':Year[PREV] Skip Year0 .. Year1

3. Annual Mortgage Payment = 'Defined Input & Outputs'::Mortgage Loan Constant * 'Defined Input & Outputs'::Loan Amount Skip Year0

4. Interest Portion of Payment = -'Balance Owed, beginning of year' * Assumptions::Stated Annual Interest rate

5. Amortization of principal = Annual Mortgage Payment + Interest Portion of Payment

6. 'Balance Owed, end of year' = 'Balance Owed, beginning of year' - Amortization of principal

-------------------------------------------------

Discounted Cash Flow - quantrix_-_discounted_cash_flow_for_business_model.model

1. Gross profit = Total revenue-Cost of Goods Sold

2. 'Earnings before Interest, Tax, Depr. & Amort (EBITDA)' = Gross profit-'S, G & A Expense'

3. 'Earnings before Interest & Tax (EBIT)' = 'Earnings before Interest, Tax, Depr. & Amort (EBITDA)'-Depreciation and amortization

4. 'Tax-loss carryforwards' = if('Earnings before Interest & Tax (EBIT)':Year[PREV]+'Tax-loss carryforwards':Year[PREV]<0,'Earnings before Interest & Tax

(EBIT)':Year[PREV]+'Tax-loss carryforwards':Year[PREV],0)

5. Net taxable earnings = if('Earnings before Interest & Tax (EBIT)'+'Tax-loss carryforwards'>0,'Earnings before Interest & Tax (EBIT)'+'Tax-loss

carryforwards',0)

6. Federal and State Income Taxes = Net taxable earnings*Assumptions::Income Tax Rate

7. 'Net Operation Profit After Tax (NOPAT)' = 'Earnings before Interest & Tax (EBIT)'-Federal and State Income Taxes

8. Add back depreciation and amortization = Depreciation and amortization

9. Subtract Capital Expenditures:Year[THIS] = Subtract Capital Expenditures:Year[PREV]*(1+Growth Factors::Capital expenditure growth factor:Year[THIS]) skip

'2010'

10. Subtract New Net Working Capital = (Total revenue-Total revenue:Year[PREV])*(Growth Factors::Net working capital to sales ratio)

11. Total revenue = Total revenue:Year[PREV]*(1+Growth Factors::Revenue growth factor)

12. Cost of Goods Sold = Total revenue*(1-Growth Factors::Expected gross profit margin) skip '2010'

13. 'S, G & A Expense' = Total revenue*Growth Factors::'S, G, & A expense % of revenue' skip '2010'

14. Depreciation and amortization = Total revenue*(Growth Factors::'Depr. & Amort. % of revenue') skip '2010'

15. Free Cash Flow = 'Net Operation Profit After Tax (NOPAT)'+Add back depreciation and amortization+Subtract Capital Expenditures+Subtract New Net Working Capital

16. IN '2020', Terminal Value Cash Flow Year 2011= (('2020':Free Cash Flow*(1+Assumptions::'Growth Rate > 2011'))/(Assumptions::Discount Rate - Assumptions::'Growth Rate > 2011'))

17. PV of Forecast Cash Flows = ((Total Cash Flow)/((1+Assumptions::Discount Rate)^(#Year-1))) skip '2010'

18. '2010':PV of Forecast Operations = SUM('2010':PV of Forecast Cash Flows .. '2020':PV of Forecast Cash Flows)

19. Total Market Value of Assets:'2010' = PV of Forecast Operations:'2010'+Plus Current Assets:'2010'

20. Total Cash Flow = Free Cash Flow+Terminal Value Cash Flow Year 2011

----------------------------------------------

Integrated Financial Statements Model - quantrix_-_integrated_financial_statements.model

1. Current Assets.Total Current Assets = sum(summary(Assets.Current Assets))

2. Total Assets = sum(sum(summary(Assets)))

3. Current Liabilities.Total Current Liabilities = sum(summary(Liabilities and Shareholders'' Equity.Current Liabilities))

4. Total Shareholders'' Equity = sum(summary(Shareholders'' Equity))

5. Total Liabilities and SH Equity = sum(summary(Liabilities and Shareholders'' Equity))

6. Accounts Receivable = Income Statement::Revenue * (Balance Sheet Assumptions::Days Sales Outstanding / 365) Skip Actuals

7. Inventory = Income Statement::COGS * (Balance Sheet Assumptions::Days in Inventory / 365) Skip Actuals

8. 'Net PP&E':Year[THIS] = 'Net PP&E':Year[PREV] + Cash Flow::'Investment PP&E':Year[THIS] - Income Statement::Depreciation:Year[THIS]

9. Account Payable = Income Statement::COGS * (Balance Sheet Assumptions::Days Payables Outstanding / 365) Skip Actuals

10. 'Short-term Debt':Year[THIS] = 'Short-term Debt':Year[PREV]

11. 'Long-term Debt':Year[THIS] = 'Long-term Debt':Year[PREV] + Cash Flow::Debt Financing:Year[THIS] Skip Actuals

12. 'Paid-in Capital':Year[THIS] = 'Paid-in Capital':Year[PREV] + Cash Flow::Equity Financing:Year[THIS]

13. Retained Earnings:Year[THIS] = Retained Earnings:Year[PREV] + Income Statement::Net Income:Year[THIS] Skip Actuals

14. In Actuals, Scenario[THIS] = Scenario[PREV] skip Current Assets.Total Current Assets,Total Assets,Current Liabilities.Total Current Liabilities,Total Shareholders'' Equity,Total Liabilities and SH Equity

15. Cash:Year[THIS] = Cash Flow::Ending Cash Balance:Year[THIS] Skip Actuals

1. Total Oper Exp = sum(summary(Operating Expenses))

2. Gross Profit = Revenue - COGS

3. EBITDA = Gross Profit - Total Oper Exp

4. EBIT = EBITDA - 'D&A'

5. EBT = EBIT - Interest

6. Net Income = EBT - Tax

7. 'D&A' = Depreciation

8. IS Items = Revenue * Income Statements Assumptions::IS Items Skip Actuals, Revenue,Total Oper Exp,Gross Profit,EBITDA,EBIT,EBT,Net Income,'D&A',Tax

9. Revenue:Year[THIS] = Revenue:Year[PREV] * (1 + Income Statements Assumptions::Revenue:Year[THIS])

10. In Actuals, Scenario[THIS] = Scenario[PREV] skip Total Oper Exp,Gross Profit,EBITDA,EBIT,EBT,Net Income,'D&A',Tax

11. Tax = EBT*Income Statements Assumptions::Tax Skip Actuals

12. In Actuals,Tax=EBT*.15

1. Cash Flow From Investment Activities.Total Investing = sum(summary(Cash Flow From Investment Activities))

2. Cash Flow from Financing Activities.Total Financing = sum(summary(Cash Flow from Financing Activities))

3. Free Cash Flow = sum(summary(Net Income .. Cash Flow from Financing Activities))

4. Starting Cash Balance:Year[THIS] = Ending Cash Balance:Year[PREV]

5. Ending Cash Balance = Starting Cash Balance + Free Cash Flow Skip Actuals

6. Ending Cash Balance:Year[FIRST] = Balance Sheet::Cash:Year[FIRST]

7. Net Income = Income Statement::Net Income

8. 'D&A' = Income Statement::Depreciation

9. Change In AR:Year[THIS] = Balance Sheet::Accounts Receivable:Year[PREV] - Balance Sheet::Accounts Receivable:Year[THIS]

10. Change in Inventory:Year[THIS] = Balance Sheet::Inventory:Year[PREV] - Balance Sheet::Inventory:Year[THIS]

11. Change in AP:Year[THIS] = Balance Sheet::Account Payable:Year[THIS] - Balance Sheet::Account Payable:Year[PREV]

12. Operating Cash Flow = sum(summary(Net Income .. Working Capital Movements))

-------------------------------------------------

Loan Amortization with Scenarios Model - quantrix_-_loan_amortization_with_scenarios_model.model

Interest Paid = sum(summary(Amort Schedule::Interest))

1. Loan=Price*(1-Down)

2. Monthly Payment=PMT(Interest/12,Years*12,Loan)

1. Principal:Payment1 = Loans by year::Loan

2. Monthly Payment=if(Principal:Payment>0,(Loans by year::Monthly Payment),0)

3. Interest:Payment=(Loans by year::Interest/12)*Principal:Payment

4. Balance:Payment = round(if(Principal:Payment>0,(Principal:Payment*(1+(Loans by year::Interest/12))+Monthly Payment:Payment),0),1)

5. Principal Paid=if(Principal:Payment>0,(Monthly Payment+Interest),0)

6. Principal:Payment[THIS]=Balance:Payment[PREV]

-------------------------------------------------

Multi-Company & Multi-Crrency model - quantrix_-_multi-company_and_multi-currency_model.model

1. Gross Profit = Sales - COGS

2. Operating Profit = Gross Profit - Operating Expenses

3. USD = Local / FX Rates::USD using Accounting Treatment::FX Rate as FX Rates::Rate, Local Currency::Currency as FX Rates::Local Currency

skip Gross Profit,Operating Profit

-------------------------------------------------

Payroll Quarterly Tax Reporting Model - quantrix_-_payroll_quarterly_tax_reporting_model.model

1. Week.Total = sum(summary(Week))

2. NET = sum(Wages) - sum(Deductions) + OTHER ADDITIONS

3. Employee.Total = sum(summary(Employee))

1. YTD Wages = sum(Qtly Wages:Quarter[FIRST] .. Qtly Wages:Quarter[THIS]) skip Total

2. Qtly Wages = sum(select(Payroll Detail::GROSS,Master Date Keys::Quarter,@Quarter)) skip Total

3. Excess = if(YTD Wages<Unemployment Assumptions::Excess,0,   if(YTD Wages-Qtly Wages <Unemployment Assumptions::Excess,     Qtly Wages + (YTD Wages-Qtly Wages)-Unemployment Assumptions::Excess, Qtly Wages)) skip Employee.Total

4. Taxable = Qtly Wages-Excess skip Employee.Total

5. Total = sum(summary(Employee))

6. Tax = Taxable*Unemployment Assumptions::Rate skip Total

1. MCR = sum(select(Payroll Detail::MEDI,Master Date Keys::Quarter,@Quarter))

2. SS = sum(select(Payroll Detail::SS,Master Date Keys::Quarter,@Quarter))

3. FED = sum(select(Payroll Detail::FEDERAL,Master Date Keys::Quarter,@Quarter))

4. ST = sum(select(Payroll Detail::STATE,Master Date Keys::Quarter,@Quarter))

5. Employee.Total = sum(summary(Employee))

6. Sum of Federal = sum(summary(Federal))

7. ER MCR = MCR

8. ER SS = SS

----------------------------------------------

Financial Ratio Analysis Model - quantrix_-_financial_ratio_analysis_model.model

1. Gross Margin.Sales = Income Statement::Sales.Sales

2. Cost of Sales = Income Statement::Sales.Cost of Sales

3. GM = (Gross Margin.Sales - Cost of Sales)/Gross Margin.Sales

4. Earnings Per Share.Net Income = Income Statement::Net Income

5. Shares Outstanding = Balance Sheet::Shares Outstanding

6. EPS = Earnings Per Share.Net Income/Shares Outstanding

7. Profit Margin.Net Income = Income Statement::Net Income

8. Profit Margin.Sales = Income Statement::Sales.Sales

9. PM = Profit Margin.Net Income/Profit Margin.Sales

10. EBITDA = Income Statement::Gross Profit-Income Statement::Operating Expenses skip Forecasted

11. Return on Assets.Total Assets:YTD= average(Balance Sheet::Forecasted:Total Assets)

12. Return on Assets.ROA = clearerror(EBITDA/Return on Assets.Total Assets)

13. Earnings after Taxes = Income Statement::Net Income skip YTD

14. Stockholders equity = Balance Sheet::Total Equity skip YTD

15. Return on Equity.ROA = clearerror(Earnings after Taxes/Stockholders equity)

16. Current Assets = Balance Sheet::Total Current Assets skip YTD

17. Inventory = Balance Sheet::Inventory skip YTD

18. Current Liabilities = Balance Sheet::Total Current Liabilities skip YTD

19. Current Ratio = clearerror(Current Assets/Current Liabilities)

20. Quick Ratio = clearerror((Current Assets-Inventory)/Current Liabilities)

21. Accounts Receivable = Balance Sheet::Accounts receivable skip YTD

22. Credit sales per day = Income Statement::Sales.Sales/90 skip YTD

23. Average Collection Period = clearerror(Accounts Receivable/Credit sales per day)

24. Cost of Goods Sold = Income Statement::Sales.Cost of Sales skip YTD

25. Average Inventory = Balance Sheet::Inventory skip YTD

26. Inventory Turnover = clearerror(Cost of Goods Sold/Average Inventory)

27. Total Liabilities = Balance Sheet::Total Liabilities skip YTD

28. Total Equity = Balance Sheet::Total Equity skip YTD

29. Leverage Ratios.Total Assets = Balance Sheet::Total Assets skip YTD

30. EBIT = Income Statement::Net Income+Income Statement::Interest+Income Statement::Taxes

31. Interest Charges = Income Statement::Interest

32. Debt Ratio = clearerror(Total Liabilities/Leverage Ratios.Total Assets)

33. Equity Ratio = clearerror(Total Equity/Leverage Ratios.Total Assets)

1. YTD = sum(summary(Forecasted))

2. In Forecasted, Gross Profit = Sales.Sales-Sales.Cost of Sales

3. In Forecasted, Total Expenses = sum(summary(Expenses))

4. In Forecasted, Operating Income = Gross Profit-Total Expenses

5. In Forecasted, Total Other Income and Expenses = sum(summary(Gain on income and expenses))

6. In Forecasted, Income before tax = Operating Income+Total Other Income and Expenses

7. In Forecasted, Taxes = Income before tax*Assumptions::Tax Rate

8. In Forecasted, Net Income = Income before tax-Taxes

9. In Forecasted, Sales.Cost of Sales = sum(summary(Detailed Supporting Information.Cost of Sales))

1. Total Current Assets = sum(summary(Current Assets))

2. Fixed Subtotal = sum(summary(Fixed))

3. Total Fixed Assets = sum(summary(Fixed Assets))

4. Total Assets = sum(summary(Assets))

5. Total Intangible Assets = sum(summary(Intangible Assets))

6. Total Current Liabilities = sum(summary(Current Liabilities))

7. 'Total Non-current Liabilities' = sum(summary('Non-Current Liabilities'))

8. Total Liabilities = sum(summary(Liabilities))

9. Total Equity = sum(summary(Equity))

10. Total Liabilities and Equity = Total Liabilities+Total Equity

11. Proof = IF(Total Liabilities and Equity-Total Assets = 0, "Balanced",Total Liabilities and Equity-Total Assets)

-------------------------------------------------------

Sales Analysis with Dashboard and Direct Connection to Database model - quantrix_-_sales_analysis_with_dashboard_and_direct_connection_to_database_model.model

(no formulas)

-------------------------------------------------------

Investment Capital Budgeting Model - quantrix_-_investment_capital_budgeting_model.model

1. Income from sales to the network = Tarrif * Electricity Volume sales Skip Year0

2. Tarrif:Year[THIS] = Tarrif:Year[PREV] * (1 + Annual Increase Assumptions::Tarrif)

3. Electricity Volume sales:Year[THIS] = Electricity Volume sales:Year[PREV] * (1 + Annual Increase Assumptions::Electricity Volume sales)

4. Operating Expenses:Year[THIS] = Operating Expenses:Year[PREV] * (1 + Annual Increase Assumptions::Annual Increase of these expenses) Skip Annual Increase of these expenses

5. Annual Increase of these expenses = Annual Increase Assumptions::Annual Increase of these expenses Skip Year0

6. Gross Operating Margin = Total Operating Income - Total Operating Expenses

7. Total Operating Income = Tarrif * Electricity Volume sales Skip Year0

8. Annual Increase of the tarrif = Annual Increase Assumptions::Tarrif Skip Year0

9. Annual Increase of the volume = Annual Increase Assumptions::Electricity Volume sales Skip Year0

10. In Year0, Scenario[THIS] = Scenario[PREV] Skip Total Operating Expenses, Gross Operating Margin

11. Total Operating Expenses = sum(summary(Operating Expenses))

1. Depreciation of fixed assets = Year0:Initial investment in fixed assets / Year0:'Depreciation term (years)' Skip Year0

2. Amortization of capitalized expenses = Year0:Initial investment in capitalized expenses / Year0:'Amortization term (years)' Skip Year6 .. Year10, Year0

3. Total Amortization = sum(Depreciation of fixed assets .. Amortization of capitalized expenses) skip Year0

4. Gross fixed assets = Year0:Initial investment in fixed assets

5. Accumulated depreciation:Year[THIS] = Depreciation of fixed assets:Year[THIS] + Accumulated depreciation:Year[PREV]

6. Net fixed assets = Gross fixed assets - Accumulated depreciation

7. Gross capitalized expenses = Year0:Initial investment in capitalized expenses

8. Accumulated amortization:Year[THIS] = Amortization of capitalized expenses:Year[THIS] + Accumulated amortization:Year[PREV]

9. Net capitalized expenses = Gross capitalized expenses-Accumulated amortization

1. In Year0, Initial investment in fixed assets and capitalized expenses = Depreciation::Year0:Initial investment in fixed assets +

Depreciation::Year0:Initial investment in capitalized expenses

2. Year0:Initial amount of debt = Year0:Percentage to be financed by debt * Year0:Initial investment in fixed assets and capitalized expenses

3. Annual repayment = Year0:Initial amount of debt / Year0:'Repayment term (years)' Skip Year0

4. Amount of debt at year end:Year[THIS] = Amount of debt at year end:Year[PREV] - Annual repayment:Year[THIS]

5. In Year0, Amount of debt at year end = Year0:Initial amount of debt

6. Average amount of debt:Year[THIS] = (Amount of debt at year end:Year[THIS] + Amount of debt at year end:Year[PREV]) / 2

7. Interest rate of debt = 'Reference interest rate (Euribor or other)' + Spread

8. Annual amount of interest = Average amount of debt * Interest rate of debt Skip Year0

9. Annual debt service = Annual amount of interest + Annual repayment Skip Year0

10. 'Reference interest rate (Euribor or other)' = General Assumptions::'Reference interest rate (Euribor or other)'

11. Spread = General Assumptions::Spread

1. Operating income = Gross Margin::Total Operating Income

2. Operating expense = Gross Margin::Total Operating Expenses skip Year0

3. 'Profit & Loss Statement'.Operating gross margin = Gross Margin::Gross Operating Margin Skip Year0

4. Depreciation = Depreciation::Total Amortization

5. Interest = Debt::Annual amount of interest

6. Profit before tax = 'Profit & Loss Statement'.Operating gross margin - Depreciation - Interest Skip Year0

7. '(Tax rate)' = General Assumptions::Tax Rate Skip Year0

8. 'Profit & Loss Statement'.Income tax = Profit before tax * '(Tax rate)' Skip Year0

9. NET PROFIT = Profit before tax - 'Profit & Loss Statement'.Income tax Skip Year0

10. Percentage of increase:Year[THIS] = NET PROFIT:Year[THIS] / NET PROFIT:Year[PREV] - 1 Skip Year0 .. Year1

11. Cash flow for debt service.Operating gross margin = 'Profit & Loss Statement'.Operating gross margin

12. Cash flow for debt service.Income tax = 'Profit & Loss Statement'.Income tax

13. Receivables = Operating income * General Assumptions::'Receivables as a % of Operating Income' Skip Year0

14. 'Receivables as a % of operating income' = General Assumptions::'Receivables as a % of Operating Income' Skip Year0

15. Suppliers = Operating income * General Assumptions::'Suppliers as a % of operating income' Skip Year0

16. 'Suppliers as a % of operating income' = General Assumptions::'Suppliers as a % of operating income' Skip Year0

17. Cash needed for operations = General Assumptions::'Cash needed for operations as % of Operating Income' * Operating income Skip Year0

18. 'Cash needed for operations as a % of operating income' = General Assumptions::'Cash needed for operations as % of Operating Income' Skip Year0

19. '(WCN as a  % of operating income)' = 'Cash needed for operations as a % of operating income' + 'Receivables as a % of operating income' - 'Suppliers as

a % of operating income' Skip Year0

20. WCN = Operating income * '(WCN as a  % of operating income)' Skip Year0

21. 'Increase in working capital needs (WCN)':Year[THIS] = WCN:Year[THIS] - WCN:Year[PREV]

22. 'Cash flow available for debt service (CFD)' = Cash flow for debt service.Operating gross margin - Cash flow for debt service.Income tax - 'Increase in

working capital needs (WCN)' Skip Year0

23. Annual Debt Service = Debt::Annual debt service

24. 'DEBT SERVICE COVERAGE RATIO (DSCR)' = 'Cash flow available for debt service (CFD)' / Annual Debt Service Skip Year0

25. In Year0, Present value of future CFD for each year = npv(5%, 'Cash flow available for debt service (CFD)':Year1 .. 'Cash flow available for debt service

(CFD)':Year10)

26. In Year1, Present value of future CFD for each year = npv(5%, 'Cash flow available for debt service (CFD)':Year2 .. 'Cash flow available for debt service

(CFD)':Year10)

27. In Year2, Present value of future CFD for each year = npv(5%, 'Cash flow available for debt service (CFD)':Year3 .. 'Cash flow available for debt service

(CFD)':Year10)

28. In Year3, Present value of future CFD for each year = npv(5%, 'Cash flow available for debt service (CFD)':Year4 .. 'Cash flow available for debt service

(CFD)':Year10)

29. In Year4, Present value of future CFD for each year = npv(5%, 'Cash flow available for debt service (CFD)':Year5 .. 'Cash flow available for debt service

(CFD)':Year10)

30. In Year5, Present value of future CFD for each year = npv(5%, 'Cash flow available for debt service (CFD)':Year6 .. 'Cash flow available for debt service

(CFD)':Year10)

31. In Year6, Present value of future CFD for each year = npv(5%, 'Cash flow available for debt service (CFD)':Year7 .. 'Cash flow available for debt service

(CFD)':Year10)

32. In Year7, Present value of future CFD for each year = npv(5%, 'Cash flow available for debt service (CFD)':Year8 .. 'Cash flow available for debt service

(CFD)':Year10)

33. In Year8, Present value of future CFD for each year = npv(5%, 'Cash flow available for debt service (CFD)':Year9 .. 'Cash flow available for debt service

(CFD)':Year10)

34. In Year9, Present value of future CFD for each year = npv(5%, 'Cash flow available for debt service (CFD)':Year10 .. 'Cash flow available for debt

service (CFD)':Year10)

35. 'Outstanding debt as of year end' = Debt::Amount of debt at year end Skip Year10

1. 'Fixed assets (net)' = Depreciation::Net fixed assets

2. 'Capitalized expenses (net)' = Depreciation::Net capitalized expenses

3. Receivables = 'P&L and Cash Flow'::Receivables

4. Cash needed for operations = 'P&L and Cash Flow'::Cash needed for operations

5. 'Additional cash (if negative, it would represent additional debt)' = Total Assets - 'Capitalized expenses (net)' - 'Fixed assets (net)' - Receivables -

Cash needed for operations

6. Suppliers = 'P&L and Cash Flow'::Suppliers

7. Debt = Debt::Amount of debt at year end

8. 'Liabilities & net worth'.Current year profit = 'P&L and Cash Flow'::NET PROFIT

9. In Balance sheet without dividends, 'Accumulated reserves/(Dividend)':Year[THIS] = 'Accumulated reserves/(Dividend)':Year[PREV] + 'Liabilities & net

worth'.Current year profit:Year[PREV]

10. In Balance sheet with dividends, 'Accumulated reserves/(Dividend)':Year[THIS] = 'Accumulated reserves/(Dividend)':Year[PREV] + 'Liabilities & net

worth'.Current year profit:Year[PREV] - 'Dividends & Return Analysis'::Annual dividend payable:Year[THIS]

11. Capital = Debt::Year0:Initial investment in fixed assets and capitalized expenses * Debt::Year0:Percentage to be financed by capital

12. Total Assets = 'Total Liabilities & net worth'

13. 'Total Liabilities & net worth' = sum(summary('Liabilities & net worth'))

1. 'Cash flow available for debt service (CFD)' = 'P&L and Cash Flow'::'Cash flow available for debt service (CFD)'

2. 'Annual debt service (DS)' = Debt::Annual debt service

3. 'CF available for dividends (CFDiv = CFD-DS)' = 'Cash flow available for debt service (CFD)' - 'Annual debt service (DS)' Skip Year0

4. Accumulated CFDiv:Year[THIS] = Accumulated CFDiv:Year[PREV] + 'CF available for dividends (CFDiv = CFD-DS)':Year[THIS]

5. Item.Current year profit = 'P&L and Cash Flow'::NET PROFIT

6. Accumulated profit limit for dividend payable:Year[THIS] = Accumulated profit limit for dividend payable:Year[PREV] + Item.Current year profit:Year[THIS]

7. Accumulated dividend payable = min(Accumulated CFDiv, Accumulated profit limit for dividend payable) Skip Year0

8. Annual dividend payable:Year[THIS] = Accumulated dividend payable:Year[THIS] - Accumulated dividend payable:Year[PREV]

9. Invested capital = Debt::Initial investment in fixed assets and capitalized expenses * Debt::Percentage to be financed by capital

10. Annual dividends payable = Annual dividend payable

11. Discount rate to be applied for NPV calculation = General Assumptions::Discount Rate

12. Discount factor for this rate = (1 + Discount rate to be applied for NPV calculation)^(#Year-1)

13. Discounted dividends = Annual dividend payable / Discount factor for this rate skip Year0

14. In Year0, Present value of dividends = sum(Year0:Discounted dividends .. Year10:Discounted dividends)

15. In Year0, NPV of the investment = Present value of dividends - Invested capital

16. Investment schedule = Annual dividends payable - Invested capital

17. In Year0, IRR OF THE INVESTMENT = irr(Year0:Investment schedule .. Year10:Investment schedule, .5)

18. Dividends payable = Annual dividend payable

19. Accumulated dividends payable = Accumulated dividend payable Skip Year0

20. Invested capital schedule = Debt::Year0:Initial investment in fixed assets and capitalized expenses * Debt::Year0:Percentage to be financed by capital

1. Total investment = Debt::Initial investment in fixed assets and capitalized expenses

2. To be financed by capital = Debt::Percentage to be financed by capital

3. To be financed by debt = Debt::Percentage to be financed by debt

4. Term of the loan = Debt::'Repayment term (years)'

5. In Year0, Interest rate of the loan = Debt::Interest rate of debt

6. In Year0, Discount rate applied for NPV calculation = General Assumptions::Discount Rate

7. In Year0, 'Working capital needs as a  % of operating income' = 'P&L and Cash Flow'::'(WCN as a  % of operating income)':Year1

8. Total operating income = 'P&L and Cash Flow'::Operating income

9. Gross operating margin = 'P&L and Cash Flow'::'Profit & Loss Statement'.Operating gross margin

10. Net profit = 'P&L and Cash Flow'::NET PROFIT

11. 'Cash flow available for debt service (CFD)' = 'P&L and Cash Flow'::'Cash flow available for debt service (CFD)'

12. 'Annual debt service (DS)' = 'P&L and Cash Flow'::Annual Debt Service

13. 'Debt service coverage ratio (DSCR)' = 'P&L and Cash Flow'::'DEBT SERVICE COVERAGE RATIO (DSCR)'

14. 'Loan life coverage ratio (LLCR)' = 'P&L and Cash Flow'::'LOAN LIFE COVERAGE RATIO (LLCR)'

15. Annual dividends payable ='Dividends & Return Analysis'::Annual dividend payable

16. NPV of  invested capital = 'Dividends & Return Analysis'::NPV of the investment

17. IRR of invested capital = 'Dividends & Return Analysis'::IRR OF THE INVESTMENT

18. 'Pay-back term of invested capital' = 'Dividends & Return Analysis'::'Investment pay-back terms'

Total Operating Expenses = sum(summary(Operating Expenses))

-------------------------------------------------------------------

World Cup Model - quantrix_-_world_cup_model.model

1. Team1 Status = switch(

ISBLANK(Team1 Score)=1,"",

Team1 Score>Team2 Score,"WIN",

Team2 Score>Team1 Score,"LOSS",

Team1 Score=Team2 Score,"DRAW")

2. Team2 Status = SWITCH(

Team1 Status="WIN","LOSS",

Team1 Status="LOSS","WIN",

Team1 Status="DRAW","DRAW")

1. In WIN .. LOSS, Factor = sum(counta(select(Group Stage::Team1&Group Stage::Team1 Status,Group Stage::Team1&Group Stage::Team1 Status,@Team Group&@Factor)) , counta(  select(Group Stage::Team2&Group Stage::Team2 Status,Group Stage::Team2&Group Stage::Team2 Status,@Team Group&@Factor)))

2. GF = sum(sum(select(Group Stage::Team1 Score,Group Stage::Team1,@Team Group)), sum(select(Group Stage::Team2 Score,Group Stage::Team2,@Team Group)))

3. GA = sum(select(Group Stage::Team2 Score,Group Stage::Team1,@Team Group),select(Group Stage::Team1 Score,Group Stage::Team2,@Team Group))

4. GD = GF-GA

5. Pts = (WIN*3) + DRAW

6. Tie Breaker = Pts + (GD/100) + (GF/100)

7. A[THIS]:Rank= rank(Tie Breaker:A,Tie Breaker:A,0) + countif(Tie Breaker:A[FIRST] .. Tie Breaker:A[THIS],Tie Breaker:A[THIS])-1

8. B[THIS]:Rank= rank(Tie Breaker:B,Tie Breaker:B,0) + countif(Tie Breaker:B[FIRST] .. Tie Breaker:B[THIS],Tie Breaker:B[THIS])-1

9. C[THIS]:Rank= rank(Tie Breaker:C,Tie Breaker:C,0) + countif(Tie Breaker:C[FIRST] .. Tie Breaker:C[THIS],Tie Breaker:C[THIS])-1

10. D[THIS]:Rank= rank(Tie Breaker:D,Tie Breaker:D,0) + countif(Tie Breaker:D[FIRST] .. Tie Breaker:D[THIS],Tie Breaker:D[THIS])-1

11. E[THIS]:Rank= rank(Tie Breaker:E,Tie Breaker:E,0) + countif(Tie Breaker:E[FIRST] .. Tie Breaker:E[THIS],Tie Breaker:E[THIS])-1

12. F[THIS]:Rank= rank(Tie Breaker:F,Tie Breaker:F,0) + countif(Tie Breaker:F[FIRST] .. Tie Breaker:F[THIS],Tie Breaker:F[THIS])-1

13. G[THIS]:Rank= rank(Tie Breaker:G,Tie Breaker:G,0) + countif(Tie Breaker:G[FIRST] .. Tie Breaker:G[THIS],Tie Breaker:G[THIS])-1

14. H[THIS]:Rank= rank(Tie Breaker:H,Tie Breaker:H,0) + countif(Tie Breaker:H[FIRST] .. Tie Breaker:H[THIS],Tie Breaker:H[THIS])-1

15. Seed = if(Tie Breaker=0,"",Rank&@level(Team Group, 1))

1. In Round of 16, Team1=select(@Standings::Team Group,Standings::Seed,I5)

2. In Round of 16, Team2 = select(@Standings::Team Group,Standings::Seed,I8)

3. In Quarter Finals, Team1 = select(Winner:Round of 16,GameKey:Round of 16,I5)

4. In Quarter Finals, Team2 = select(Winner:Round of 16,GameKey:Round of 16,I8)

5. In Semi Finals, Team1 = select(Winner:Quarter Finals,GameKey:Quarter Finals,I5)

6. In Semi Finals, Team2 = select(Winner:Quarter Finals,GameKey:Quarter Finals,I8)

7. Consolation:Team1=switch(

Winner:'61'=Team2:'61',Team1:'61',Team2:'61')

8. Consolation:Team2=switch(

Winner:'62'=Team2:'62',Team1:'62',Team2:'62')

9. In Final, Team1 = select(Winner:Semi Finals,GameKey:Semi Finals,I5)

10. In Final, Team2 = select(Winner:Semi Finals,GameKey:Semi Finals,I8)

11. //Team1 Score = round(rand()*10,0)

12. //Team2 Score = round(rand()*10,0)

13. Winner = switch(

isblank(Team2 Score),"",

Team1 Score>Team2 Score,Team1,Team2)

14. GameKey = "W"&@Level

-------------------------------------------------

Analysis of Diprotic Acids for Fixed pH model - quantrix_-_analysis_of_diprotic_acids_for_fixed_ph_model.model

1. '[H30]+' = 10^-value(@pH)

2. D = '[H30]+' ^ 2 + Inputs::Ka1 * '[H30]+' + Inputs::Ka1 * Inputs::Ka2

3. 'a(H2A)' = '[H30]+' ^ 2/D

4. 'a(HA-)' = Inputs::Ka1 * '[H30]+' / D

5. 'a(A2-)' = Inputs::Ka1 * Inputs::Ka2 / D

-------------------------------------------------

Converting a Uniform Distribution into a Normal Distribution model - quantrix_-_converting_a_uniform_distribution_into_a_normal_distribution_model.model

1. Cummulative Occurences Below X = count(selectlessthan(Random Numbers Normalized::Normal Distribution of Random Numbers, Random Numbers Normalized::Normal

Distribution of Random Numbers, Value(@X)))

2. Incremental Occurences:X[THIS] = Cummulative Occurences Below X:X[THIS] - Cummulative Occurences Below X:X[PREV]

1. Random Number = rand()

2. Normal Distribution of Random Numbers = norminv(Random Number, Dist Parameters::Mean, Dist Parameters::Standard Deviation)

-------------------------------------------------

Recursion Relations in a Population Genetics model - quantrix_-_recursion_relations_in_population_genetics_model.model

1. Generation.'1'=Starting proportion::A

2. Generation[THIS] = Generation[PREV]*  (1 - Generation[PREV] * value(@K)) /  (1 - value(@K) * Generation[PREV] * Generation[PREV] - value(@L) *  (1 -

Generation[PREV]) ^ 2)

------------------------------------------------

Rolling Average model - quantrix_-_rolling_average_model.model

1. Rolling Average:Period[THIS] = average(Rate Value:Period[PREV-2] .. Rate Value:Period[PREV])  //Takes average of prior three periods.  Change the variable

to increase / decrease time.

Net Income = Revenue - Expenses

1. Average Net Income:Generic Month[THIS] = average(Net Income:Generic Month[~THIS-5] .. Net Income:Generic Month[~THIS])

2. Net Income = Income Statement::Net Income using Date Manager::Generic Month as Generic Month

Generic Month = "Month "&#Year:Month

----------------------------------------------

Major League Baseball Statistics - quantrix_-_major_league_baseball_statistics_model.model

1. Stat = sum(select('2004 Player Stats'::Player,Players::Team,@Team)) skip ave

2. Rank:Team[THIS] = rank(Team:Stat,Team:Stat) + countif(Team[FIRST]:Stat .. Team[THIS]:Stat,Team[THIS]:Stat) - 1

3. In Stat, ave = H/AB

1. Stat = select(Team Summaries::Stat,Team Summaries::Rank,value(@Position))

2. Team = select(@Team Summaries::Team,Team Summaries::Rank,value(@Position))

---------------------------------------------

Cumulative Total model - quantrix_-_cumulative_total_model.model

1. Cumulative Total:Month[THIS] = Cumulative Total:Month[PREV] + Data:Month[THIS]

// This formula takes the PREVious months Cumulative Total and adds it to THIS months Data to calculate THIS months Cumulative Total

2. Cumulative Total:Month[FIRST] = Data:Month[FIRST]

// This formula takes the FIRST months Data and uses it for the FIRST months Cumulative Total.

1. Previous = Data:Month[PREV]

// Puts the Previous month data value in this months 'Previous' item cell.

2. Next = Data:Month[NEXT]

// Puts the Next months data value in the this months 'Next' item cell.

3. Previous 3 = sum(Data:Month[PREV-2] .. Data:Month[PREV])

// Sums the Previous 3 months data

4. Next 3 = sum(Data:Month[NEXT] .. Data:Month[NEXT+2])

// Sums the next 3 months data

5. First 3 = sum(Data:Month[FIRST] .. Data:Month[FIRST+2])

// Sums the first 3 months data for all cells

6. Last 3 = sum(Data:Month[LAST-2] .. Data:Month[LAST])

// Sums the last 3 months data for all cells

------------------------------------------------

Student Grading model - quantrix_-_student_grading_model.model

1. Average = average(Exam 1 .. Exam 5)

2. Rank = rank(Student:Average,Student:Average,Sort Trigger::Choose Sort Order)

3. Name = @Student

4. Exam Results:Final Grade = (Exam Results:Session 1+Exam Results:Session 2)/2

1. Grade = select(Grades::Average,Grades::Rank,value(@Rank))

2. Name = select(Grades::Name,Grades::Rank,value(@Rank))

-----------------------------------------------

Inter-model Forumulas model - quantrix_-_inter_model_formulas_example.zip

1. Gross Profit = Product Revenue-COGS

2. Net Income = Gross Profit-Expenses

3. Line Item = Division A::Line Item+Division B::Line Item+Division C::Line Item skip Gross Profit,Net Income

// Adds all the line items together from the A, B and C division matrices into this matrix.

1. Gross Profit = Product Revenue-COGS

2. Net Income = Gross Profit-Expenses

3. Forecast= !Division-AFinancials.model!Financials::Forecast skip Gross Profit,Net Income

// Pulls the forecast data from the Division A model

1. Gross Profit = Product Revenue-COGS

2. Net Income = Gross Profit-Expenses

3. Forecast = !Division-BFinancials.model!Financials::Forecast skip Gross Profit,Net Income

// Pulls the forecast data from the Division B model

1. Gross Profit = Product Revenue-COGS

2. Net Income = Gross Profit-Expenses

3. Forecast = !Division-CFinancials.model!Financials::forecast skip Gross Profit,Net Income

// Pulls the forecast data from the Division C Model

------------------------------------------------

Management Summary model - quantrix_-_management_summary_model.model

1. Class = sum(select(Sales Data Matrix::Item Number,Key Matrix::Class,value(@Class))) skip Total Class

2. Total Class = sum(summary(Class))

1. Group = sum(select(Sales Data Matrix::Item Number,Key Matrix::Group,@Group)) skip Total Group

2. Total Group = sum(summary(Group))

1. Category = sum(select(Sales Data Matrix::Item Number,Key Matrix::Category,@Category)) skip Total

2. Total = sum(summary(Category)) Quarter ="Q"& int((#Period -1)/3)+1

------------------------------------------------

Range Data Categories model - quantrix_-_range_data_categories_model.model

1. Range = selectgreaterthan(Range Definitions::Label,Range Definitions::Top,Data Value,1) Label = concatenate(Bottom, " - ", Top)

-----------------------------------------------

Automatic vs. Manual Summary Items model - quantrix_-_automatic_vs_manual_summary_items_model.model

Total = sum(summary(B))

1. Total = sum(summary(D)) skip C2

2. Total = count(summary(D)) skip C1

------------------------------------------------

Circular Reference model - quantrix_-_circular_reference_model.model

1. Taxable Income after State Tax = Taxable Income-Federal Calculation.State Tax

2. Federal Tax = Taxable Income after State Tax*Tax Rate

3. State Taxable Income = Taxable Income after State Tax

4. State Calculation.State tax = State Taxable Income*State Tax Rate

5. Federal Calculation.State Tax = State Calculation.State tax

6. Total Tax = Federal Tax+State Calculation.State tax

------------------------------------------------

Time Rollup model - quantrix_-_time_roll_up_model.model

1. Month[THIS] = Month[PREV] * (1 + Assumptions::Monthly Growth Rate) skip Net Income

2. Year[THIS]:Jan = Year[PREV]:Dec *  (1 + Assumptions::Monthly Growth Rate) skip Net Income

3. Net Income = Income-Expenses

1. Accounts = sum(Income Statement::Month)

using Date Keys::Quarter Key as Quarter

skip YTD

2. YTD = sum(summary(Quarter))

-----------------------------------------------

Unique Rank model - quantrix_-_unique_rank_model.model

1. Rank:Items[THIS] =rank(ItemsSold:Items,ItemsSold:Items)+countif(ItemsSold:Items[FIRST] .. ItemsSold:Items[THIS],ItemsSold:Items[THIS])-1

2. Key = @Items

1. Item Name=select(Unique Rank::Key,Unique Rank::Rank,value(@Top3))

2. '# Sold' = select(Unique Rank::ItemsSold,Unique Rank::Rank,value(@Top3))

-----------------------------------------------

New Web sample models whose functions are not listed here:

Adjustable Rate Mortgage (ARM) model - quantrix_-_adjustable_rate_mortgage__arm_.model

LBO Feasibility model - quantrix_-_lbo_feasibility_model.model

Merger model - quantrix_-_merger_model.model

Retail Sales model - quantrix_-_retail_sales_model.model

Balanced Scorecard model - quantrix_-_balanced_scorecard_model.model

Statistical Defect Analysis model - quantrix_-_statistical_defect_analysis.model

UK Taxation model - ukpaye_2014-2015.model

 

See Also