Forestry Commission
PC-Fiap Version 2.00
For Excel
USER MANUAL
1.3.1 Moving with the mouse and keyboard
1.3.3 Spreadsheet rows, columns and cells
1.3.4 Overwriting and restoring default entries
1.3.6 Automatic and manual recalculation
3.3.1 Standard Year 1: Price Base year (PrBYr)
3.3.2 Standard Year 2: Base year for Discounting (BYFD)
3.3.3 Standard Year 3: Year Now
3.3.4 Standard Year 4: Year Fell
3.5 Price-size curves (PSC) and price/productivity adjustment
4.7 Erasing or adding a crop component
4.7.3 Protecting and unprotecting crop component data
4.8.1 Areas in hectares or percentages
4.8.2 Making percentages add to 100%
4.8.3 What happens when you choose
4.9 Crop component planting years
4.10 Price-size curve (PSC) selection
4.10.1 Standard Forestry Commission price-size curves
4.11 Adjusting prices and productivity during analysis
4.11.2 Percentage and per-cubic-metre adjustments
4.11.3 Productivity adjustments
5. THE REVENUE-EXPENDITURE MODEL
5.1 Entering revenue-expenditure model name and details
5.1.1 Name and descriptive information
5.1.2 The Date saved and the Year Now
5.1.3 The land cost and purchase date
5.2 Entering notes on costs, income or grants
5.3 Single or grouped crop components
5.3.1 Each crop component separately
5.3.2 Components grouped by crop type or species
5.3.3 Sub-dividing groups by planting year
5.3.4 Restoring the P.Yr formula
5.4.6 Real time Cash Flow years
5.5 Adding, deleting and saving
5.5.4 Saving and retrieving sections of the Revenue-Expenditure Model
5.5.4.1 Saving Revenue-Expenditure data
5.5.4.2 Retrieving Revenue-Expenditure data
5.5.4.3 Safeguards while retrieving Revenue-Expenditure data
5.5.4.4 Updating retrieved Revenue-Expenditure data for inflation
6.1 The standard Forestry Commission PSCs
6.2.3 Checking a new PSC with a graph
6.3.1 Amending an existing PSC
8.1.1 Automatic or manual recalculation
8.1.2 Recalculation and convenience during data entry
8.1.3 Forcing manual recalculation
8.2.2 Results ... from Now to Year
8.2.3 Discounted Expenditure and Revenue (DE and DR)
8.2.4 Net Present Value and Annual Equivalent Value (NPV and AEV)
8.2.5 Land Expectation Value (LEV)
8.2.6 Internal Rate of Return (IRR)
8.2.7 The possibility of no IRR, or multiple IRRs
8.2.9 Undiscounted cash figures
8.3 Annual cash flow results per hectare (undiscounted)
8.3.1 Costs, miscellaneous income and grants
8.3.3 Net and cumulative cash flows
8.4 Year of Maximum Discounted Revenue
8.5.1 Splitting the screen for analysis
8.5.2 Removing the screen split
8.6.2 Price-size curve defaults
8.6.3 General Price/Prod Adjustments
8.7.3 Cumulative Annual Cash Flow
8.7.4 Maximum DR (optimum felling year)
8.7.5 IRR Test (NPV for var. rates %)
8.9 Differences and aggregation
8.9.1 Measuring differences between options
8.9.2 Aggregating results for several coupes