Accounting

cash_flow_model

Actual Cash Flow Projection Explanation Guidelines Projection Projection Pre-Startup Month 1 Month 2 Month 3 Month 4 Month 5 Month 6 Month 7 Month 8 Month 9 Month 10 Month 11 Month 12 Monthly Cash Flow Projection (A) Suggest even dollars be used rather than showing cents. CHECKING GENERAL GUIDELINES In order to insure that ... more>>

tags:financial, excel, business

capbudg[3]

CapBudgWS Equity Analysis of a Project INPUT SHEET: USER ENTERS ALL BOLD NUMBERS INITIAL INVESTMENT CASHFLOW DETAILS DISCOUNT RATE Initial Investment= Revenues in year 1= Approach(1:Direct;2:CAPM)= Opportunity cost (if any)= Var. Expenses as % of Rev= 1. Discount rate = Lifetime of the investment Fixed expenses in year 1= 2a. Beta S ... more>>

tags:financial, excel, business

Bankruptcy proceedings representation

Bankruptcy proceedings representation. ... more>>

tags:

Amortization

Instructions Calculator New_Balance Total_Payment Pay # Interest Month Balance After Payment New Total Interest Paid: Total Balance Owed: Annual Periodic Rate (APR): Monthly Periodic Rate: Current Month (e.g., Aug-02): Total Paid (incl Int.): Payoff Month: Step 1 Step 2 Step 3 Step 4 Enter the current month, using the following ... more>>

tags:Amortion

Allocator

Chart (Blank) Calculator (Blank) Calculator (Example) Total value of portfolio / investable capital: INVESTMENT CATEGORY DESIRED % of PORTFOLIO DOLLAR ALLOCATION American stocks European stocks Bonds Cash Real estate Commodities Portfolio Allocations 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.0 ... more>>

tags:Allocation

What-If Analysis Template

What-If Model - Users Guide Input Template: Project Costs Segregate Capitalized and Expensed Project Costs based on the expenditure characteristics. Include project fees Historical Financial Information Income Statement -Based on audited financial report data, categorize revenues and expenses into the broad categories Balance Sheet -Further, catego ... more>>

What If Analysis

Welcome chart dialog box Dialog3 Sheet1 Code Charts Income Statements avgshares chart cost96 cost97 ganda96 ganda97 incb4tx intinc97 othexp97 projection projections rand96 rand97 rev96 rev97 sandm96 sandm97 tax userchart (In millions, except earnings per share) Year Ended Projected Growth June 30 Change Revenue Oper ... more>>

Weighted Average Cost of capital

Sheet1 4ESTIMATING THE WEIGHTED AVERAGE COST OF CAPITAL Input cells are in yellow. Comparable Companies Firm 1 Firm 2 Firm 3 Average DATA Amount of equity 200.00 200.00 300.00 Amount of debt 100.00 200.00 200.00 Tax rate 0.40 0.35 0.38 Equity beta $1.10 $1.25 $0.90 RESULT 1+ (1-T)D/E $1.30 1.00 1.00 $1.65 1.00 1.00 ... more>>

Valuation Models

model.xls CHOOSING THE RIGHT VALUATION MODEL This program is designed to help in choosing the right model to use for any occassion. Inputs to the model Level of Earnings (in currency) Are your earnings positive ? Yes (Yes or No) If the earnings are positive and normal, please enter the following: What is the expected inflation rate in t ... more>>

Time Value

TIME VALUE OF MONEY 123456789 10 11 12 13 14 15 16 17 18 19 A B C D E F G FUTURE AND PRESENT VALUE FACTORS Interest rate 10% Present value 1,000 First of End of % of Year Year Initial Year Balance Interest Balance Investment 1 1,000 100 1,100 110% 2 1,100 110 1,210 121% 3 1,210 121 1,331 133% 4 1,331 133 1,464 146% % of Initial Investment ( Future ... more>>

Synergy[1]

synergy.xls 2VALUING SYNERGY: WORKSHEET SYNERGY VALUATION WORKSHEET Enter the following information on the bidding firm Current Financial Information Revenues in current year = $1,000.00 COGS as % of Revenues = 0.70 Tax Rate on income = 0.35 Interest Expenses = $100.00 Current Depreciation = $50.00 Current Capital Spending = $75.0 ... more>>

Rule Maker Ranker

Scoring Criteria RM Ranker Ranking Rule Makers -- Scoring Criteria 1) Brand Familiarity Is it everywhere? 1 point: passable to excellent 0 points: failure Openness Does it welcome everyone? 1 point: passable to excellent 0 points: failure Optimism Can it promise a slightly better world? 1 point: passable to excellent 0 p ... more>>

Rule Make Essentials

Results RM Essentials Results as of Most Recent SEC Filings on 4/3/00 KO MSFT GPS INTC CSCO SGP PFE YHOO TROW JDSU NOK Business Basics 1) Dominant Brand 1.00 1.00 1.00 1.00 1.00 0.00 1.00 1.00 1.00 1.00 1.00 2) Repeat Purchases 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 3) Convenience 1.00 1.00 ... more>>

EPCB - Risk Management Consulting Services

Content BCP Structure 1.1 Risk = Likelihood x Consequence 1.2 BIA Worksheet 1.3 BCP Worksheet 2 Translate to Action 3 Risk Register Ref 1. RA Checklist Ref 2. BIA Checklist Ref 3. Glossary NB: The material in this workbook is provided for general information only and should not be relied upon for the purpose of a particular matter.Description Recom ... more>>