DataMuseum.dk

top - download

    Length: 2944 (0xb80)
    Types: TextFile
    Names: »CONSOL.MOD«

└─⟦6ae1c04a5⟧ Bits:30004364 SW1656 IFPS/Personal Version 2.10 release 1.1
    └─ ⟦this⟧ »CONSOL.MOD« 

TextFile

COLUMNS 1985..1989
ØØ
ØØ This model projects income over the next five years
ØØ for all existing and new products.          
ØØ
PRODUCT A REVENUES=PRODUCT A SALES * PRODUCT A SELLING PRICE
PRODUCT B REVENUES=PRODUCT B SALES * PRODUCT B SELLING PRICE
PRODUCT C REVENUES=PRODUCT C SALES * PRODUCT C SELLING PRICE
NEW PRODUCT REVENUES=NEW PRODUCT SALES * NEW PRODUCT SELLING PRICE
SALES=PRODUCT A SALES + PRODUCT B SALES + PRODUCT C SALES + '
      NEW PRODUCT SALES
REVENUES=SUM(PRODUCT A REVENUES THRU NEW PRODUCT REVENUES)
ØØ
PRODUCT A TOTAL EXPENSES=PRODUCT A SALES EXPENSES + PRODUCT A ADVERTISING
PRODUCT B TOTAL EXPENSES=PRODUCT B SALES EXPENSES + PRODUCT B ADVERTISING
PRODUCT C TOTAL EXPENSES=PRODUCT C SALES EXPENSES + PRODUCT C ADVERTISING
NEW PRODUCT TOTAL EXPENSES=NEW PRODUCT SALES EXPENSES + NEW PRODUCT ADVERTISING
TOTAL EXPENSES=SUM(PRODUCT A TOTAL EXPENSES THRU NEW PRODUCT TOTAL EXPENSES)
ØØ
PRODUCT A NET INCOME=PRODUCT A REVENUES - PRODUCT A TOTAL EXPENSES
PRODUCT B NET INCOME=PRODUCT B REVENUES - PRODUCT B TOTAL EXPENSES
PRODUCT C NET INCOME=PRODUCT C REVENUES - PRODUCT C TOTAL EXPENSES
NEW PRODUCT NET INCOME=NEW PRODUCT REVENUES - NEW PRODUCT TOTAL EXPENSES
NET INCOME=REVENUES - TOTAL EXPENSES
ØØ
PRODUCT A RET ON SALES=PRODUCT A NET INCOME / PRODUCT A SALES
PRODUCT B RET ON SALES=PRODUCT B NET INCOME / PRODUCT B SALES
PRODUCT C RET ON SALES=PRODUCT C NET INCOME / PRODUCT C SALES
NEW PRODUCT RET ON SALES=NEW PRODUCT NET INCOME / NEW PRODUCT SALES
RET ON SALES=NET INCOME / SALES
ØØ
PRODUCT A RET ON INVEST=PRODUCT A NET INCOME / PRODUCT A INVEST
PRODUCT B RET ON INVEST=PRODUCT B NET INCOME / PRODUCT B INVEST
PRODUCT C RET ON INVEST=PRODUCT C NET INCOME / PRODUCT C INVEST
NEW PRODUCT RET ON INVEST=NEW PRODUCT NET INCOME / NEW PRODUCT INVEST
INVEST=PRODUCT A INVEST + PRODUCT B INVEST + PRODUCT C INVEST + '
       NEW PRODUCT INVEST
RET ON INVEST=NET INCOME / INVEST
ØØ
ØØ   SAMPLE SPREADSHEET
ØØ
PRODUCT A=PRODUCT A REVENUESÆ1985Å,PRODUCT A TOTAL EXPENSESÆ1985Å,'
          PRODUCT A NET INCOMEÆ1985Å,PRODUCT A RET ON SALESÆ1985Å,'
          PRODUCT A RET ON INVESTÆ1985Å
PRODUCT B=PRODUCT B REVENUESÆ1985Å,PRODUCT B TOTAL EXPENSESÆ1985Å,'
          PRODUCT B NET INCOMEÆ1985Å,PRODUCT B RET ON SALESÆ1985Å,'
          PRODUCT B RET ON INVESTÆ1985Å
PRODUCT C=PRODUCT C REVENUESÆ1985Å,PRODUCT C TOTAL EXPENSESÆ1985Å,'
          PRODUCT C NET INCOMEÆ1985Å,PRODUCT C RET ON SALESÆ1985Å,'
          PRODUCT C RET ON INVESTÆ1985Å
NEW PRODUCT=NEW PRODUCT REVENUESÆ1985Å,NEW PRODUCT TOTAL EXPENSESÆ1985Å,'
          NEW PRODUCT NET INCOMEÆ1985Å,NEW PRODUCT RET ON SALESÆ1985Å,'
          NEW PRODUCT RET ON INVESTÆ1985Å
TOTAL=REVENUESÆ1985Å,TOTAL EXPENSESÆ1985Å,'
          NET INCOMEÆ1985Å,RET ON SALESÆ1985Å,'
          RET ON INVESTÆ1985Å
ØØ
INCLUDE CONSOL.DAT
«eof»