Accounting

OptionTradingWorkbook[3]

Version 2 Introduction This spreadsheet is provided free of charge for you to use to further your education in options trading. The formulas used were taken from two great books on option trading Option Volatility and Pricing by Sheldon Natenberg Financial Models using Excel by Simon Benninga You can read more about these books from the www.OptionT ... more>>

Operational and financial Data

There are three steps to using this spreadsheet: (1) Make assumptions about operations in the Operations worksheet. (2) Make assumptions about financing in the Financing worksheet. (3) Use the Solver in the Financing worksheet to minimize bank notes payable subject to maintaining the minimum cash balance required. This step is explained in the Fina ... more>>

NPV and IRR

Incremental Exclusive Multiple-chart Multiple IRR Rule NPV Rule 4NPV AND IRR RULES Page PROJECTS CAN BE VALUED ON AN INCREMENTAL BASIS Cost of capital 0.10 Year 0.00 1.00 Project A Cash flow -10000.00 20000.00 PV factor 1.00 0.91 1.00 PV of cash flow -10000.00 18181.82 NPV 8181.82 Project B-A Cash flow -10000.00 1500 ... more>>

Leveraged Buy Out Model

Returns_Calculation WACC_Page DCF_Analysis Free_Cash_Flow_Summary Income_Tax_Calc Capital_Structure Asset_Sales Performance_Assumptions Inc_Stmt_Assumptions WC_BS_Assumptions Ratio_Analysis Tax_Depreciation Book_Depreciation Debt_Repayment Cash_Flow Income_Statement Balance_Sheet Sources_Uses Case EXIT_YEAR Project XXX Transact ... more>>

Lease or Buy a Car

Sheet1 Page This spreadsheet analyzes the lease/purchase decision. In the case of a purchase, it is assumed sales tax is paid on the negotiated price at the time of purchase, and property taxes are paid annually. In the case of a lease, it is assumed sales tax is paid on the difference between the list price and the payoff at the time o ... more>>

LBO Valuation[2]

44 MERGER LBO VALUATION WORKSHEET 44 INPUT SHEET: MERGER & LBO VALUATION STEP 1: Estimate the total cost of the deal Price per share= 201 Debt outstanding currently (mil)= 1800 # shares outstanding (mil)= 21.9 Other costs (Investment banker etc.)= 0 Total cost of the deal= 6201.9 STEP 2: Define how the deal will be financed Repayment schedule ( as ... more>>

IT RISK ASSESMENT TEMPLATE

RISK FACTORS RISK MEASUREMENT PROCESS (Worksheet 7b) PREPARED BY: DATE: INSTRUCTIONS: 1. Enter Year, Prepared By, and Date in appropriate Cells. 2. List Risk Factors in use F1..F10 by descriptions in Cells P2..P11. 3. Alter the weights in Cells C15..L15 to suit your risk model. The weights should sum to 1.00 (shown in Cell M15). 4. Enter the audita ... more>>

IPO Timeline

IPO Timeline Reverse IPO Timeline Introduction chronological chronoprint home reverse reverseprint Initial organization meeting and due dilligence Review Timetable Review letter of intent and discuss underwriting issues. Discuss Underwriters fees and compensation Assign registration statement preparation responsibilities Identify a ... more>>

Inventory_Simulation

Sheet: Introduction File: $ASQInventory_Simulation.xls Page 1 of 58 sS.xls Version 1.4 03/22/02 John.O.McClain@cornell.edu Johnson Graduate School of Management Cornell University Ithaca NY 14853 This workbook is intended for teaching or research. You are welcome to use it in any manner, and change it as you see fit. It comes without any guarantee ... more>>

internal_review

Architected Solutions Business Architectures BUSINESS LANDSCAPE ANALYSIS QUESTIONNAIRE DRAFT 2/4/2008 $ASQinternal_review.xlsFilter1Architected Solutions Business Architectures BUSINESS LANDSCAPE ANALYSIS QUESTIONNAIRE DRAFT 2/4/2008 ANSWERED Section Title Key Questions Responses BACKGROUND Structure Analyst Reports Trends Economics Existing Compet ... more>>

Historical Financial Analysis

Instructions Instructions for Using HISTORY "Word has come down from the dean That with the aid of a teaching machine Ole' Oedipus Rex could have learned about sex Without ever disturbing the Queen." Lewis Spitz HISTORY is intended as a companion to ANALYSIS FOR FINANCIAL MANAGEMENT, 6th edition, by Robert C. Higgins. Some basic familiarity with Mi ... more>>

Full Break Even Analysis

BEP CHART PROFIT SENSITIVITY BEP SENSITIVITY BREAK EVEN FAST FLEX VARIABLE COSTS OVERHEADS PRICE MASTER XYZ Co Ltd BACK TO MASTER Per Year Per Month Insurance FIXED COSTS or OVERHEADS Cost Area COST / UNIT Production Components Packaging Offices & Rates Salaries & Employer NI Utilities Telephones Stationery & Post Office ... more>>

Free Cash Flow to Firm Part 2

NewFCFF2Stage Present Value of FCFF in high growth phase = Present Value of Terminal Value of Firm = Value of the firm = Market Value of outstanding debt = Market Value of Equity = Market Value of Equity/share = Two-Stage FCFF Discount Model This model is designed to value a firm, with two stages of growth, an initial period of higher grow ... more>>

Free Cash Flow to Firm Part 1

NewFCFFStableGrowth Sheet1 FCFF STABLE GROWTH MODEL This model is designed to value a stable firm on the basis of free cashflows to firm. Assumptions in the model: 1. The firm is in steady state and will grow at a stable rate forever. 2. The firms leverage is known and constant. User defined inputs The user has to define the following inp ... more>>

Free Cash Flow to Equity Part 3

NewFCFE3Stage Do you want to change any of these inputs for the stable growth period? If yes, specify the values for these inputs Specify weights to be assigned to each of these growth rates: Historical Growth Rate = Outside Prediction of Growth = Fundamental Estimate of Growth = Growth Rate during the transition period Enter length of th ... more>>