Для тех кому интересна автоматизированная программка на базе Excel для бизнес планирования, создана "Leeds School of Business University of Colorado", готов отдать ее всего за 5$, не знаю правда сколько она там стоит, мне самому привезли из штатов (действительно очень ценная вещь, сам с успехом внедрил и использую на работе) - расчеты можно осущ. через WebMoney на мой кошелек, но сначала пишите на ящик rcb_ars@mail.ru, вышлю картинки посмотреть ) Вся инфа ниже:

Financial Projections Model v6.8.3

This financial model is designed to enable entrepreneurs and students project the financial results of their ventures for a five-year period. As with all models there are certain simplifying assumptions that have been made. Each of the assumption spreadsheets has an accompanying Comments box (denoted by a cell with small red triangle in the upper right corner) that provides suggestions on how to complete the spreadsheet and the underlying assumptions to the model.

There are 7 principal spreadsheet outputs of this model:
INCOME: Income Statement
BALANCE: Balance Sheet
CASHFLOW: Cash Flow Statement
BREAKEVEN: Break-even analysis
SUMMARY: Analysis of key measures
INCOME-MOS: Income Statements by months for Years 1 to 5
CASHFLOW-MOS: Cash flow Statements by months for Years 1 and 2, and by quarters for Years 3 to 5
VAL-1 & VAL-2: Venture capital method for valuing companies

All other spreadsheets are to be used for calculating the underlying assumptions of the 7 principal spreadsheets:

COMPS: Comparison of financial measures to peer companies
REVENUE: Revenue Projections
COST OF REV: Cost of Goods Sold
OPER EXPEN: Operating Expenses
PROP & EQUIP: Capital Expenditures, Depreciation, and Net Fixed Assets
SALARIES: Salary Personnel
EXTRA: Extraordinary Income and Expense
TAXES: Tax calculation
WORKCAP: Working Capital
FUNDING: Equity, Debt, Interest Expense, Interest Income, Dividends and Retained Earnings

This original version of the model has been used since the mid-1980’s. It has undergone numerous revisions over that period. Since 1998, students in the Business Plan Preparation course at the University of Colorado have used it to prepare their business plans. We have appreciated their suggestions for improvements and would encourage all users to send us comments and suggestions.

Created by Frank Moyes and Stephen Lawrence
Deming Center for Entrepreneurship
Leeds School of Business
University of Colorado
Boulder, Colorado

Отредактировано Арсений (2006-11-10 12:49:42)