Exam‚ F65 April 2009 Exam F65: Financial Models in Excel Copenhagen Business School 1. April 2009 Open book exam‚ 4 hours Own computers allowed General information You must hand in your solution in Excel spreadsheet format. You must hand in 2 copies at floppy disks or CD-ROMs. Each of the exercises has been given an individual weight. These indicate to the student how much time should be used on each exercise. However‚ the final grade will not rely on these weights only‚ but might be
Premium Option Call option Put option
Excel Tips and Tricks CRI CPE Week May 2011 Presented by: Francois Houde‚ CA‚ CISA Schedule of the Session Transitioning from Excel 2003 to Excel 2010: What happened to my Excel? Managing versions Searches with wildcard characters Multiple windows of the same workbook Creating three dimensional formulas Feel like discovering new functions? Using the scenario manager What happened to my Excel? Q: My Pfx Engagement menus are gone and/or I’ve lost my tickmarks
Premium Spreadsheet
amounts of money to the colonies. The Sugar Act was supposed to cut down the temptation for smuggled good and this was supposed to help pay for the soldiers staying in America to protect the colonist. The next act was known as the Currency Act. The Currency
Premium American Revolution Boston Tea Party Thirteen Colonies
Carry Trades and Currency Crashes Markus K. Brunnermeier‚ Princeton University‚ NBER‚ and CEPR Stefan Nagel‚ Stanford University and NBER Lasse H. Pedersen‚ New York University‚ NBER‚ and CEPR I. Introduction This paper studies crash risk of currencies for funding‐constrained speculators in an attempt to shed new light on the major currency puzzles. Our starting point is the currency carry trade‚ which consists of selling low interest rate currencies—“funding currencies”—and investing in
Premium Foreign exchange market Exchange rate United States dollar
Student ID: 21709822 Exam: 038229RR - Microsoft Excel When you have completed your exam and reviewed your answers‚ click Submit Exam. Answers will not be recorded until you hit Submit Exam. If you need to exit before completing the exam‚ click Cancel Exam. Questions 1 to 20: Select the best answer to each question. Note that a question and its answers may be split across a page break‚ so be sure that you have seen the entire question and all the answers before choosing an answer. 1. The order of
Premium Spreadsheet Microsoft Excel
BANC ONE CORPORATION An Analysis of their Hedging Strategy By Mark Glitto‚ Gajendra Tulsian‚ Robert Young University of Florida Summer 1997 INTRODUCTION In 1993 the stock price of Banc One Corporation had dropped from about $45 at the beginning of the year to approximately $35 at the end of the year: roughly a 20% fall. This sharp decline in stock price greatly bothered John B. McCoy‚ chairman and CEO of Banc One Corporation. A high stock price was essential for Bank One’s strategic goal
Premium
http://www.papercamp.com/essay/11828/Tree-Values-Case Section 1 – Executive Summary This report analyzes the case “Tree Values” to find an optimal way for Mr. Smith to manage his forestland and harvest the crop trees. The fundamental idea in this report is based on the concept of present value. A number of options are analyzed and the one with highest present value of pay off is considered. Questions 9‚ 10‚ and 11 give Mr. Smith 3 options: * Option 1: Harvest all crop trees now and receive $8
Premium Educational years
Strategic Management Financial & Political Risk David Warnock-Smith Strategic Management Programme • • • • Introduction to “risk” and “risk management” Sources of risk Risk classification Overview and management of: – Financial risk – Political risk – (Business / operational risk) Strategic Management Risk - Definition “The fact that the results of any action are not certain‚ but may take more than one value. Risk is usually used to describe the form of uncertainty where‚ while
Premium Risk Risk management
Overview of formulas Formulas are equations that perform calculations on values in your worksheet. A formula starts with an equal sign (=). For example‚ the following formula multiplies 2 by 3 and then adds 5 to the result. =5+2*3 A formula can also contain any or all of the following: functions‚ references‚ operators‚ and constants. Parts of a formula Functions: The PI() function returns the value of pi: 3.142... References: A2 returns the value in cell A2. Constants: Numbers or text
Premium Algebra Mathematics Function
My Household Budget ITEM MONTHLY BUDGET JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC Item Total Housing $1‚000.00 $1‚000.00 $1‚000.00 $1‚000.00 $1‚000.00 $1‚000.00 $1‚000.00 $1‚000.00 $1‚000.00 $1‚000.00 $1‚000.00 $1‚000.00 $1‚000.00 $12‚000.00 Utilities $250.00 $136.00 $146.00 $150.00 $142.00 $155.00 $270.00 $290.00 $267.00 $260.00 $210.00 $200.00 $200.00 $2‚426.00 Car Payment $300.00 $300.00 $300.00 $300.00 $300.00 $300.00 $300.00 $300.00 $300.00 $300.00 $300.00 $300.00 $300.00 $3‚600.00 Insurance
Premium Personal finance Budgets Money