Contents:
CORPORATE FINANCE 19 21 NOVEMBER 2008 DAVE THERON S 3 000 BEFORE GST Corporate Financial Modelling with Excel Module 2 INTRODUCTION This application driven hands on practical 3 day programme leads delegates through various financial modeling techniques using Excel as the tool It focuses on the basic nuts bolts of financial model preparation and structure and provides the delegate with useful modeling techniques than can be immediately applied in the work place This is a very hands on non intimidating course delegates work through various practical exercises under the supervision and with the help of the instructor to get to grips with practical modeling techniques and as a valuable spin off advanced Excel functions useful and essential in the preparation of corporate financial models LEARNING OUTCOMES By the end of this 3 day course delegates will know how to structure models correctly and will appreciate the necessity for so doing They will understand the interaction between Income Statements Continue to download »
Sponsored Links
Passport Isuzu Rodeo Pilot Prelude 76 83 84 89 90 93 94 97 98 02 03 05 73 79 80 83 75 79 84 91 92 95 96 00 01 04 97 01 02 04 84 91 99 04 92 95 95 02 03 07 79 89 42010 42011 42012 42013 42014 42015 42020 42021 42022 42023 42024 42025 42026 42025 42026 42023 42035 42024 47017 42037 42040 Golden Eagle Grand Cherokee Grand Wagoneer Laredo Liberty Pick up J series Renegade Scrambler Wagoneer Wagoneer Wrangler 49 86 93 04 84 91 49 86 02 04 72 88 49 86 49 86 72 83 84 90 87 03 50020 50025 50029 50020 50035 50029 50020 50020 50029 50010 50030 KIA KIA Sephia 94 01 Spectra 00 04 54070 54070 Probe Mazda 626 Ranchero Ranger Pick up Ranger Pick up Super Duty Pick ups Shelby Mustang Taurus Taurus Tempo Thunderbird Thunderbird Thunderbird Torino Vans Full size Vans Full size Windstar 93 97 75 86 83 92 93 05 99 06 65 73 86 95 96 05 84 94 75 82 83 88 89 97 75 86 69 91 92 05 95 03 61042 36044 36070 36071 36060 36048 36074 36075 36078 36044 36082 36086 36044 36090 36094 36097 LEXUS 
CORPORATE FINANCE 17 18 NOVEMBER 2008 DAVE THERON S 2 000 BEFORE GST Financial Modelling Advanced Spreadsheet Techniques Module 1 INTRODUCTION This application driven 2 day programme leads delegates through advanced Excel functions explaining the function and its uses This is a very hands on non intimidating course delegates work through various exercises under the supervision and with the help of the facilitator to get to grips with the nuances of Excel s advanced functions LEARNING OUTCOMES By the end of the course delegates will recognize areas where they could improve their own spreadsheeting They will be in a position to immediately apply the lessons learnt to their own models in their own environment What the delegates will learn from an Excel viewpoint 1 Creating and using range names 2 Protecting unprotecting sheets 3 Formulas across sheets 4 Creating your own formats the reasons and uses thereof 5 Conditional formatting 6 Formulas across files how best to handle this and the pitfalls 7 
CHAPTER 1 Introduction to Financial Modeling W hat is a financial model What is the difference between a financial model and the spreadsheet solutions you create or VBA programs you write all the time to answer financial questions or solve financial problems A simple practical answer is that a financial model is designed to represent in mathematical terms the relationships among the variables of a financial problem so that it can be used to answer what if questions or make projections Some of the spreadsheet solutions that people create capture some of these relationships as well and therefore can answer what if questions to some extent But because they are not primarily designed with these objectives in mind they do not try to capture as many of these interdependencies as possible and their structures often make it cumbersome to answer what if questions or make projections with them This may sound a little abstract So let us look at a simple concrete example Suppose you are using a spreadsheet to calculate based on your taxable income what your after tax 
Pocket PC phone SGH i780 User s Guide Table of contents CHAPTER 1 Getting started What s in the box Getting to know your phone Installing the SIM card Installing the battery Charging your phone Switching the phone on or off Conserving battery power 8 10 14 16 17 18 19 CHAPTER 2 The basics Using the Today screen Customising your phone Searching for items Using an optional memory card Adding and removing programs Resetting your phone Managing memory Managing certificates Using online help 22 29 38 38 41 45 46 47 48 CHAPTER 3 Entering information Entering text using the input panel Writing on the screen Drawing on the screen Entering text using the keyboard Recording a message 50 57 58 60 60 1 Table of contents CHAPTER 4 Synchronising information Installing ActiveSync Customising connection settings Connecting your phone to a computer Synchronising information Customising synchronisation settings 63 64 64 66 66 CHAPTER 5 Call functions Entering your PIN Checking you are connected Turning the phone 
