{ Fundamentals of Financial Modeling
   Revenue SubModel
   Version 3.0 - mixture of Historical and Projected data
                 Using "Column Control" to define what is history and what is projection  }

'Column Control' = 'Last History Column' For c1
'Column Control' = 'Last History Column' COL 1 + 1.0 for c2  { This is the first projected column }
'Column Control' = LastColumn() for c3  { Last column in the matrix }

!Define For_History_Columns For c1 - Ind1
!Define For_Projected_Columns For Ind2 - Ind3

'Last History Column'

'Sales - Cars'
'Sales - Trucks'
'Sales - Airplanes'
'Total Sales' = 'Sales - Cars' SUM 'Sales - Airplanes'

{ Calculate cost of sales as a percentage of sales for historical time periods: }
'COS % - Cars' = 'COS - Cars' % 'Sales - Cars' For_History_Columns
'COS % - Trucks' = 'COS - Trucks' % 'Sales - Trucks' For_History_Columns
'COS % - Airplanes' = 'COS - Airplanes' % 'Sales - Airplanes' For_History_Columns

{ Calculate cost of sales for the projected years only: }
'COS - Cars' = 'Sales - Cars' * 'COS % - Cars' / 100.0  For_Projected_Columns
'COS - Trucks' = 'Sales - Trucks' * 'COS % - Trucks' / 100.0 For_Projected_Columns
'COS - Airplanes' = 'Sales - Airplanes' * 'COS % - Airplanes' / 100.0 For_Projected_Columns

'Total Cost of Sales' = 'COS - Cars' SUM 'COS - Airplanes'
'Gross Profit' = 'Total Sales' - 'Total Cost of Sales'

'Overall COS %' = 'Total Cost of Sales' % 'Total Sales'
'Gross Margin %' = 'Gross Profit' % 'Total Sales'