Financial Management Excel

fa2012ristemplate.xls

Base Case

BASE CASE SCENARIO - OUR "MOST LIKELY" PROJECTIONS
Trend Assumptions (% change per year)
Unit Price
Unit Sales
Variable Cost
Fixed Costs
	Year 0	Year 1	Year 2	Year 3	Year 4	Year 5	Year 6	Year 7	Year 8
Unit Price
Unit Sales
Variable Cost
Fixed Costs
INCOME STATEMENT
Sales Reveune
Fixed Cost
Variable Cost
Op profits
Depreciation
EBIT
TAX
Net Income
STATEMENT OF CASH FLOWS
OCF		- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0
CAPITAL
NWC
Total Cash Flows
Tax Rate			Sensitivity Analysis		Margin of Error
Ks (Req. Return)			Unit Price
IRR			Unit Sales
NPV(Ks)			Variable Cost
MIRR			Fixed Costs
DEPRECIATION & BOOK VALUE DATA
									ATSV
CAP1
CAP2
CAP3
5 Year MACRS
7 Year MACRS
10 Year MACRS
DEPR 1
DEPR 2
DEPR 3
Book Value 1										BV1
Book Value 2										BV2
Book Value 3										BV3
Salvage Value 1
Salvage Value 2
Salvage Value 3

&Z&F

Initial Assumption is that NWC changes in year 0 and is recouped in terminal year. Some projects require additional infusions of working capital.

WORST CASE SCENARIO - PESSIMISTIC PROJECTIONS
	Year 0	Year 1	Year 2	Year 3	Year 4	Year 5	Year 6	Year 7	Year 8
Unit Price
Unit Sales
Variable Cost
Fixed Costs
INCOME STATEMENT
Sales Reveune
Fixed Cost
Variable Cost
Op profits
Depreciation
EBIT
TAX
Net Income
STATEMENT OF CASH FLOWS
OCF
CAPITAL
NWC
Total Cash Flows
Tax Rate
Ks
IRR
NPV(Ks)
MIRR
DEPRECIATION & BOOK VALUE DATA
									ATSV
CAP1
CAP2
CAP3
5 Year MACRS
7 Year MACRS
10 Year MACRS
DEPR 1
DEPR 2
DEPR 3
Book Value 1
Book Value 2
Book Value 3
Salvage Value 1
Salvage Value 2
Salvage Value 3

&Z&F

Initial Assumption is that NWC changes in year 0 and is recouped in terminal year. Some projects require additional infusions of working capital.

NOTICE THAT IF PROJECTIONS ARE JUST A LITTLE BIT WRONG, THE PROJECT IS REJECTED. THIS PROJECT IS VERY SENSITVE TO PROJECTION ERRORS.

BEST CASE SCENARIO - OPTIMISTIC PROJECTIONS
	Year 0	Year 1	Year 2	Year 3	Year 4	Year 5	Year 6	Year 7	Year 8
Unit Price
Unit Sales
Variable Cost
Fixed Costs
INCOME STATEMENT
Sales Reveune
Fixed Cost
Variable Cost
Op profits
Depreciation
EBIT
TAX
Net Income
STATEMENT OF CASH FLOWS
OCF
CAPITAL
NWC
Total Cash Flows
Tax Rate
Ks
IRR
NPV(Ks)
MIRR
DEPRECIATION & BOOK VALUE DATA
									ATSV
CAP1
CAP2
CAP3
5 Year MACRS
7 Year MACRS
10 Year MACRS
DEPR 1
DEPR 2
DEPR 3
Book Value 1
Book Value 2
Book Value 3
Salvage Value 1
Salvage Value 2
Salvage Value 3

&Z&F

Initial Assumption is that NWC changes in year 0 and is recouped in terminal year. Some projects require additional infusions of working capital.