Spreadsheet: vkaminski__40690__Amod2
Sheet: CFMACROS

Set Calc (s) | Optimize | PP Yield |  |  | Version 4 Macros still used:
 |  |  |  |  |  | set calc
 |  |  |  |  |  | optimize
 |  |  |  |  |  | general box
 |  |  |  |  |  | all the sensitivities
 |  |  |  | opto
Quick.Move
 |  |  |  | teras
Quick.Move.[NAME]
 | 160 | 25 | 300 | 260 | Go To ...
3 | 50 | 5 | 200 |  | Overview
3 | 50 | 30 | 200 |  | Income Statement
3 | 50 | 55 | 200 |  | [NAME]
3 | 50 | 80 | 200 |  | Sources/Uses
3 | 50 | 105 | 200 |  | Balance Sheet
3 | 50 | 130 | 200 |  | Opening Balance Sheet
3 | 50 | 155 | 200 |  | Capitalization 1
3 | 50 | 180 | 200 |  | Capitalization 2
3 | 50 | 205 | 200 |  | Income Tax
3 | 100 | 230 | 100
[NAME]
1 |  |  | 3
2 |  |  | 3
3 |  |  | 3
4 |  |  | 3
5 |  |  | 3
6 |  |  | 3
7 |  |  | 3
8 |  |  | 3
9 |  |  | 3
10 | Cancel | 0 | 0
&CF Input
&General Information | General |  | Input Company Name, Scenario, FYE & Units
&Transaction | Transaction |  | Input Transaction Funds Flow, Fees and Date
&Cash Flow Items | Cash.Flow |  | Input Operating Cash Items, Tax Items, ESOP Items & Asset Sales
&Balance Sheet Items | Bal.Sheet |  | Input Opening Balance Sheet & Working Capital
&Debt Items | Debt |  | Input Repayment Schedules & Interest Rates
&Oil and Gas Reserve Items | Oil.Gas |  | Input Specific Oil & Gas Reserves Information
&Analyses | Analyses.Input |  | Input Information for Analyses
Iterations:
General
General.Box
 |  |  | 416 | 184 | GENERAL INFORMATION
1 | 296 | 103 | 88 |  | Up&date
2 | 296 | 126 | 88 |  | C&ancel
5 | 24 | 15 |  |  | Company &Name:
6 | 167 | 16 | 218 |  |  | Clampett Oil Company
5 | 25 | 41 |  |  | &Scenario:
6 | 166 | 41 | 219 |  |  | Texas Tea
5 | 254 | 65 |  |  | &Fiscal Year End:
8 | 254 | 81 | 132 |  |  | 1996-12-31 00:00:00
14 | 26 | 76 | 200 | 72 | &Units ($ in .....)
11 |  |  |  |  |  | 1
12 |  |  |  |  | Thousands
12 |  |  |  |  | Millions
12 |  |  |  |  | Actual
Transaction
 |  |  | l | r
 |  |  | Proj | Hist
Transaction.Box
 |  |  | 320 | 112 | TRANSACTION ITEMS
5 | 65 | 5
5 | 12 | 58 |  |  | Transaction &Date:
8 | 13 | 74 | 160 |  |  | 1995-09-30 00:00:00
1 | 225 | 56 | 88 |  | Up&date
2 | 226 | 80 | 88 |  | C&ancel
3 | 12 | 30 | 200 |  | Transaction &Fees
3 | 12 | 5 | 300 |  | &Transaction Funds Flow
Cash.Flow
Cash.Flow.Box
 |  |  | 320 | 100 | CASH FLOW ITEMS
3 | 14 | 10 | 136 |  | &Operating Data
3 | 14 | 40 | 136 |  | &Tax Items
1 | 170 | 10 | 136 |  | Asset &Sales
3 | 170 | 40 | 136 |  | &ESOP Items
2 | 120 | 70 | 88 |  | C&ancel
5 | 85 | 14
Bal.Sheet
Bal.Sheet.Box
 |  |  | 320 | 100 | BALANCE SHEET ITEMS
3 | 14 | 10 | 136 |  | &Opening B/S
3 | 14 | 40 | 136 |  | &Working Capital
3 | 170 | 10 | 136 |  | &Borrowing Base
3 | 170 | 40 | 136 |  | &Unused
2 | 120 | 70 | 88 |  | C&ancel
5 | 85 | 14
Debt
Debt.Box
 |  |  | 320 | 100 | DEBT ITEMS
3 | 10 | 10 | 140 |  | &Debt Repayment
3 | 10 | 40 | 140 |  | &Interest Rates
3 | 170 | 10 | 140 |  | &Unused
3 | 170 | 40 | 140 |  | &Unused
2 | 120 | 70 | 88 |  | C&ancel
5 | 85 | 14
Print |  | Statements |  | Analyses |  | Input.Statements |  | Everything
Print.Box
 | 160 | 25 | 280 | 250 | PRINT ....
4 | 86 | 220 | 88 |  | Cancel | 1
3 | 17.5 | 10 | 235 |  | Print Financial Statements | 2
3 | 17.5 | 40 | 235 |  | Print Oil and Gas Reserves | 3
3 | 17.5 | 70 | 235 |  | Print Individual Statements .... | 4
3 | 40 | 130 | 180 |  | Print Tax Calculation | 5
3 | 65 | 100 | 140 |  | Print Analyses .... | 6
3 | 65 | 160 | 140 |  | Print Everything | 7
3 | 17.5 | 190 | 235 |  | Print Input Assumptions .... | 8
Statement.Box
 | 160 | 25 | 260 | 250 | PRINT STATEMENTS ....
3 | 17.5 | 10 | 225 |  | Print Overview
3 | 17.5 | 40 | 225 |  | Print Income Statement
3 | 17.5 | 70 | 225 |  | Print Cash Flow Statement
3 | 17.5 | 100 | 225 |  | Print Balance Sheet
3 | 17.5 | 130 | 225 |  | Print Opening Bal Sheet
3 | 17.5 | 160 | 225 |  | Print Capitalization 1
3 | 17.5 | 190 | 225 |  | Print Capitalization 2
4 | 86 | 220 | 88 |  | Cancel
Analyses.[NAME]
 | 160 | 25 | 260 | 250 | PRINT ANALYSES ....
3 | 17.5 | 10 | 225 |  | Print Returns Analysis
3 | 17.5 | 40 | 225 |  | Print DCF Valuation
3 | 17.5 | 70 | 225 |  | [NAME]. in W/C Analysis
3 | 17.5 | 100 | 225 |  | Print Overview
3 | 17.5 | 130 | 225 |  | Print FASB Cash Flow
3 | 17.5 | 160 | 225 |  | Unused
3 | 17.5 | 190 | 225 |  | Unused
4 | 86 | 220 | 88 |  | Cancel
Input.Statements.Box
 | 160 | 25 | 300 | 310 | PRINT INPUT ....
3 | 30 | 10 | 240 |  | Operating Assumptions
3 | 30 | 40 | 240 |  | Transaction Funds Flow
3 | 30 | 70 | 240 |  | Debt Repayment Assumptions
3 | 30 | 100 | 240 |  | Interest Rate Assumptions
3 | 30 | 130 | 240 |  | Working Capital Assumptions
3 | 30 | 160 | 240 |  | Borrowing Base Assumptions
3 | 40 | 190 | 220 |  | Tax Assumptions
3 | 20 | 220 | 260 |  | Oil/Gas Reserves Assumptions
3 | 20 | 250 | 260 |  | Unused
4 | 106 | 280 | 88 |  | Cancel
Oil.Gas |  | PP | Non.PPPC | Deplete | Hedge | Reserves | Tail
Oil.Gas.Box |  | y | w | h
 | 49 | 25 | 613 | 252 | OIL & GAS RESERVES....
14 | 36 | 145 | 550 | 56 | Production Payment Assumptions |  |  | 1
3 | 65 | 166 | 236 |  | PP Prices and [NAME] |  |  | 2
3 | 321 | 166 | 236 |  | VPP Market Price Curves |  |  | 3
14 | 35 | 10 | 340 | 118 | Reserves Assumptions |  |  | 4
3 | 95 | 100 | 225 |  | Depletion Analysis |  |  | 5
3 | 95 | 75 | 225 |  | Hedging Profit/(Losses) |  |  | 6
3 | 95 | 25 | 225 |  | Oil/Gas Income Projections |  |  | 7
3 | 95 | 50 | 225 |  | Tail Assumptions |  |  | 8
4 | 320 | 210 | 88 |  | Cancel |  |  | 9
3 | 200 | 210 | 88 |  | Up&date |  |  | 10
14 | 390 | 59 | 200 | 67 | Gas/Oil |  |  | 11
11 |  |  |  |  |  | 2 |  | 12
12 |  |  |  |  | Mmbtu/Bbl |  |  | 13
12 |  |  |  |  | Bbtu/Mbbl |  |  | 14
12 |  |  |  |  | Tbtu/MMbbl |  |  | 15
5 | 390 | 33 |  |  |  |  |  | 16
5 | 390 | 10 |  |  | Select Units: |  |  | 18
 |  |  |  |  |  |  |  | 19
 |  |  |  |  |  |  |  | 20
Analyses.Input |  |  |  |  |  |  |  | 21
 |  |  |  |  |  |  |  | 22
 |  |  |  |  |  |  |  | 23
Analyses.Input.[NAME]
 |  |  | 320 | 100 | ANALYSES ....
3 | 10 | 10 | 140 |  | &Returns Analysis
3 | 10 | 40 | 140 |  | DCF &Valuation
3 | 170 | 10 | 140 |  | &FASB Analysis
3 | 170 | 40 | 140 |  | &Overview
2 | 120 | 70 | 88 |  | C&ancel
5 | 85 | 14
Sensitivity3.Select |  | Term.Loan3 | Sr.Sub3 | Jr.Sub3 | Preferred3 | Common3
 |  |  |  |  |  |  | copies name of debt category chosen to cell g889 (title)
 |  |  |  |  |  |  | copies the allocation % to cell e892 (left column title)
 |  |  |  |  |  |  | range value it
 |  |  |  |  |  |  | "   "
 |  |  |  |  |  |  | "   "
 |  |  |  |  |  |  | copies the base multiple to the row header
 |  |  |  |  |  |  | calc
 |  |  |  |  |  |  | copies the irr formula in the equity allocation section to cell e891
 |  |  |  |  |  |  | makes a table using the formula
 |  |  |  |  |  |  | copies it
Sensitivity3.Select.Box
 |  |  | 320 | 100 | SENSITIVITIES
3 | 10 | 10 | 140 |  | &Term Loan
3 | 10 | 40 | 140 |  | &Sr Sub Notes
3 | 170 | 10 | 140 |  | &Jr Sub Notes
3 | 170 | 40 | 140 |  | &Preferred Stock
3 | 10 | 70 | 140 |  | &Common Stock
2 | 170 | 70 | 140 |  | C&ancel
5 | 85 | 14
Sensitivity5.Select |  | Term.Loan5 | Sr.Sub5 | Jr.Sub5 | Preferred5 | Common5
Sensitivity5.Select.Box
 |  |  | 320 | 100 | SENSITIVITIES
3 | 10 | 10 | 140 |  | &Term Loan
3 | 10 | 40 | 140 |  | &Sr Sub Notes
3 | 170 | 10 | 140 |  | &Jr Sub Notes
3 | 170 | 40 | 140 |  | &Preferred Stock
3 | 10 | 70 | 140 |  | &Common Stock
2 | 170 | 70 | 140 |  | C&ancel
5 | 85 | 14
Go.By for RUN TABLE