Computer Simulation in Financial Risk Management: A Guide for Business Planners and Strategists

By Roy L. Nersesian | Go to book overview

The ranking of projects is usually in terms of reward with little regard to risk. The use of simulation and the adjustment of the escrow account permit projects to be ranked by reward for a given level of risk. This should place managers in a better position to select those projects that should be funded and those that should be shelved. A general purpose simulation program could be written containing the principles described here. Management would enter assessments of the most likely values, and the limits on the range of values, for the key variables along with a maximum negative balance in the escrow account to separate insolvency from bankruptcy. The program would determine an initially funded escrow account that satisfies the corporate objective on risk. The funding of the escrow account becomes part of the capital commitment of the project. Projects can then be ranked by reward for the given specification of risk.

Is management better off having this additional information when making decisions on which projects to fund? Only management can answer this.


APPENDIX

The program in this appendix was used to derive the financial risk profile for the proposed plastics goods factory. It is a special purpose program designed for this application. A general purpose program would contain the essential elements of this program.

SIMONE was run to generate the cost overrun distribution and was renamed OVER. SIMONE was then run six times to generate the various distributions associated with good and bad times in the plastics business as described in the chapter. These simulators are fed into the program in statements 40 to 170. The arrays for weeks of fad plastic production and weekly gross income for fad and nonfad plastic production are two row arrays, where the first row is applicable to the good times and the second row is applicable to the bad times. Statements 180 to 200 provide a 50-50 opportunity for the plastics plant to start off with good times or bad. This is indicated by assigning a value of I or 2 to the Z variable. This determines which row of the aforementioned arrays is to be referenced. Statement 210 assigns a value between 2 and 5 to the variable H that determines how long the good or bad times will last. Variable H1 is the counter keeping track of the length of good and bad times during the simulation run.

The two thousand simulations start in statement 220 with the selection in statement 230 of the cost overrun, the determination of annual depreciation, and the capitalized cost for each individual simulation. The variable U in statement 240 is the maximum balance in the escrow account. The twenty-year cash flow projection for each simulation starts in statement 250, with the duration of the successive good and bad times being determined in statements 260 to 300. Annual gross margin is determined in statements 310 to 320 by multiplying the weeks of fad and nonfad plastic production by the respective weekly gross margins and summing the two. Fixed operating costs are established in statements 330 to 350. Before tax income is calculated in statement 360, and statements 370 to 430 handle whether taxes are payable or not and the accruing of tax losses.

The net cash flow is calculated in statement 440 with provision for adjustment during the twentieth year for the project's residual value (statement 450) and the liquidation of the escrow account (statements 520-540). The interplay between the escrow account and the payout to equity investors is performed in statements 460 to 540. Statements 470 and 480

-81-

Notes for this page

Add a new note
If you are trying to select text to create highlights or citations, remember that you must now click or tap on the first word, and then click or tap on the last word.
One moment ...
Default project is now your active project.
Project items

Items saved from this book

This book has been saved
Highlights (0)
Some of your highlights are legacy items.

Highlights saved before July 30, 2012 will not be displayed on their respective source pages.

You can easily re-create the highlights by opening the book page or article, selecting the text, and clicking “Highlight.”

Citations (0)
Some of your citations are legacy items.

Any citation created before July 30, 2012 will labeled as a “Cited page.” New citations will be saved as cited passages, pages or articles.

We also added the ability to view new citations from your projects or the book or article where you created them.

Notes (0)
Bookmarks (0)

You have no saved items from this book

Project items include:
  • Saved book/article
  • Highlights
  • Quotes/citations
  • Notes
  • Bookmarks
Notes
Cite this page

Cited page

Style
Citations are available only to our active members.
Buy instant access to cite pages or passages in MLA, APA and Chicago citation styles.

(Einhorn, 1992, p. 25)

(Einhorn 25)

1. Lois J. Einhorn, Abraham Lincoln, the Orator: Penetrating the Lincoln Legend (Westport, CT: Greenwood Press, 1992), 25, http://www.questia.com/read/27419298.

Cited page

Bookmark this page
Computer Simulation in Financial Risk Management: A Guide for Business Planners and Strategists
Table of contents

Table of contents

  • Title Page iii
  • Contents vii
  • Introduction ix
  • 1 - Bridging the Cultural Gap 1
  • 2 - A Businessman's Assessments 17
  • Appendix 47
  • 3 55
  • Appendix 81
  • 4 - The Loan Decision 85
  • Appendix 117
  • 5 - Self-Insuring a Loan Portfolio 123
  • Appendix 149
  • 6 - Determining the Safe Load of Debt 155
  • Appendix 193
  • 7 - Hedging and the Futures Market 199
  • Appendix 220
  • Index 223
  • About the Author 225
Settings

Settings

Typeface
Text size Smaller Larger Reset View mode
Search within

Search within this book

Look up

Look up a word

  • Dictionary
  • Thesaurus
Please submit a word or phrase above.
Print this page

Print this page

Why can't I print more than one page at a time?

Help
Full screen
/ 228

matching results for page

    Questia reader help

    How to highlight and cite specific passages

    1. Click or tap the first word you want to select.
    2. Click or tap the last word you want to select, and you’ll see everything in between get selected.
    3. You’ll then get a menu of options like creating a highlight or a citation from that passage of text.

    OK, got it!

    Cited passage

    Style
    Citations are available only to our active members.
    Buy instant access to cite pages or passages in MLA, APA and Chicago citation styles.

    "Portraying himself as an honest, ordinary person helped Lincoln identify with his audiences." (Einhorn, 1992, p. 25).

    "Portraying himself as an honest, ordinary person helped Lincoln identify with his audiences." (Einhorn 25)

    "Portraying himself as an honest, ordinary person helped Lincoln identify with his audiences."1

    1. Lois J. Einhorn, Abraham Lincoln, the Orator: Penetrating the Lincoln Legend (Westport, CT: Greenwood Press, 1992), 25, http://www.questia.com/read/27419298.

    Cited passage

    Thanks for trying Questia!

    Please continue trying out our research tools, but please note, full functionality is available only to our active members.

    Your work will be lost once you leave this Web page.

    Buy instant access to save your work.

    Already a member? Log in now.

    Oops!

    An unknown error has occurred. Please click the button below to reload the page. If the problem persists, please try again in a little while.