Premium Essay

Financial Modeling

In: Business and Management

Submitted By AyaanGul
Words 266
Pages 2
Week 5 Assignment
Question 1
In a poll of 600 voters in a campaign to eliminate non-returnable beverage containers, 210 of the voters were opposed. Develop a 92% confidence interval estimate for the proportion of all the voters who opposed the container control bill.

Question 2
A random sample of 87 airline pilots had an average yearly income of $99,400 with a standard deviation of $12,000. 1 If we want to determine a 95% confidence interval for the average yearly income, what is the value of t? 2 Develop a 95% confidence interval for the average yearly income of all pilots.

Question 3
In order to determine the average weight of carry-on luggage by passengers in airplanes, a sample of 25 pieces of carry-on luggage was collected and weighed. The average weight was 18 pounds. Assume that we know the standard deviation of the population to be 7.5 pounds. 1 Determine a 97% confidence interval estimate for the mean weight of the carry-on luggage. 2 Determine a 95% confidence interval estimate for the mean weight of the carry-on luggage.

Question 4
A statistician employed by a consumer testing organization reports that at 95% confidence he has determined that the true average content of the Uncola soft drinks is between 11.7 to 12.3 ounces. He further reports that his sample revealed an average content of 12 ounces, but he forgot to report the size of the sample he had selected. Assuming the standard deviation of the population is 1.28, determine the size of the…...

Similar Documents

Premium Essay

System Modeling

...System Modeling Margaret Francies Strayer University Term Paper System Modeling Theory– CIS 331 Richard Guirguis Due on 12/8/2010 System Modeling Systems modeling or systems modelling is the approach to the study of the use of models to imagine and construct systems in business and IT development. In business and IT development the term "systems modeling" has multiple meaning. System Modeling can refer to analysis and design efforts, simulation and or system dynamics, and a study of the many uses of these models. There are different approaches to modeling: Agent based data and mathematical modeling. Quality management adopts a number of management principles that can be used by top management to guide their organizations towards improved performance. Principles such as: customer focus, leadership, people’s involvement, the process, system approach to management, continual improvement, facts, and a mutual benefit. . Decision making is a reasoning or emotional process which can be rational or irrational. The cognitive perspective is that the decision making process must be regarded as a continuous process integrated in the interaction with the environment. From a normative perspective, the analysis of individual decisions is concerned with the logic of decision making and rationality and the invariant choice it leads to it can be based on explicit assumptions or tacit assumptions. In decision making, objectives must be established and placed in the order......

Words: 662 - Pages: 3

Premium Essay

Modeling

...EXCEL MODELING AND ESTIMATION IN CORPORATE FINANCE Third Edition CRAIG W. HOLDEN Max Barney Faculty Fellow and Associate Professor Kelley School of Business Indiana University Copyright © 2008 by Prentice Hall, Inc., Upper Saddle River, New Jersey 07458 To Kathryn, Diana, and Jimmy. Contents iii CONTENTS   Preface ..................................................................................... vii  Third Edition Changes .................................................................................... vii  What Is Unique About This Book ..................................................................... x  Conventions Used In This Book .......................................................................xi  Craig’s Challenge ........................................................................................... xiii  The Excel Modeling and Estimation Series .................................................. xiii  Suggestions for Faculty Members ..................................................................xiv  Acknowledgements ........................................................................................... xv  About The Author ................................................................. xvi  PART 1 TIME VALUE OF MONEY ..... 1  Chapter 1 Single Cash Flow ....................................................1  1.1 Present Value .......................................................................................

Words: 33587 - Pages: 135

Premium Essay

Database Modeling

...Database Modeling Tool INF322 Instructor June 27, 2011 Database Modeling Tool The company has grown exponentially over the past 6 months and needs to develop a new database to house its financial, inventory, and client data. It has been decided to build this new database in house rather than purchase a system from a third party vendor. As part of the development of this database it is in the company’s best interest to utilize a database modeling tool to help the design effort. Utilizing a database modeling tool will offer the following benefits: 1. Simple graphic representation of the data structure. 2. Visual work flow of how data will be entered, modified, and reported. 3. Bulk editor capabilities. 4. Database design generator. 5. Database reverse engineering. 6. Logical and physical data model reporting. The tool that looks to be the best fit for the company is CA Erwin Data Modeler r8. CA Erwin Data Modeler r8 was developed by Logic Works Inc. Logic Works Inc. has been in business as a database modeling solution since 1988 (Carreon, 1996) and continues to be one of the top data modeling providers. CA Erwin Data Modeler r8 is the most balanced data modeler tool when comparing functionality, simplicity, and cost when to its competitors. CA Erwin has very user friendly graphical representation of both the logical and physical data models. No other competing modeler has both of these capabilities within the same function. It has all......

Words: 477 - Pages: 2

Free Essay

Business Modeling

...pAssignment: Business Modeling Business Modeling Group 1: Thomas Westelaken, Sebastiaan de Monte, Chris Hoedemakers, Daniëlle Peverelli, Teije Oudshoorn Assignment: Business Modeling Group 1: Thomas Westelaken, Sebastiaan de Monte, Chris Hoedemakers, Daniëlle Peverelli, Teije Oudshoorn Assignment: Business Modeling Table of Contents 1. 2. Introduction .......................................................................................................................................... 4 Story ...................................................................................................................................................... 5 2.1. 2.2. The case (spotify) .......................................................................................................................... 5 The business model canvas........................................................................................................... 6 Customer segments (CS) ....................................................................................................... 7 Value Propositions (VP)......................................................................................................... 9 Channels (S)......................................................................................................................... 10 Customer Relationships (CR)............................................................................................... 11 Revenue......

Words: 4324 - Pages: 18

Premium Essay

Database Modeling

...Database Modeling Kelli Clipp Business Systems Analysis INF322 Arman Kanooni February 10, 2013 This paper discusses database modeling and one tool that can be used for the process. The tool I’ve chosen is based on the material in our textbook and article ‘Modeling for the future’. Database modeling is the process of software engineering which allows for the creation of an information system. In the article ‘Modeling for the future’, they compare database modeling to constructing a house (Carreon, Wang, & Watt, 1996). This comparison is based on the fact that one would use a blueprint when building a house and database modeling can be considered as the same concept. A data model is in essence a blueprint or a plan for the database and without it the database may not be very well built, as with any program, house or building you need a plan. There are several tools available for database designers to utilize and the key is choosing the tool which is right to be used that will meet all the requirements of the database to be created. In the article ‘Modeling for the future’ they discussed and compared products from 1996, and although this article appeared to cover the four key products for database modeling at that time, the market has......

Words: 690 - Pages: 3

Premium Essay

Cost Modeling

...Determining Project Coast, Budgeting, and Earned Value Cost Modeling For Professor Douglass Smith By Integrated Project Process Management (MSPM - 6120 - 2) Week 2 Application Spring Session Section B March 12, 2012 Abstract Theoretically, cost modeling is a set of assumptions about future project conditions that guide the projects for organizations of cash flows (Sanghera, 2010). Financial models that are utilized in project finance oft-times are troubled with diverse array problems. The reason for failure in projects is mainly due to not clearly defining and segregating various elements of the model; as well as the failure to include crucial information pertaining to the project. It is good practice to have the person who will be responsible for performing a specific activity to estimate the costs associated with the activity (Gido and Clements, 2010). In this paper we were asked to utilize quantitative analysis to perform 5 year and 10 year cash flow calculations utilizing internal rate of return IRR and Net present value to strategically determine which analysis yields the best fit for the project at hand. Keywords: cost modeling, cash flows, projects, quantitative, analysis, IRR, Internal rate of return, NPV, Net Present Value Developing a baseline schedule for a project is important; in addition the aforementioned it’s also necessary to develop a baseline budget. Baseline cost components of a project depend on the nature, size and location of the...

Words: 993 - Pages: 4

Free Essay

Applied Modeling

...Applied Modeling with Military Operations (non-war) Modeling or model is a simplified representation of a situation or problem and modeling is the process of building, refining, and analyzing that representation for greater insight and improved decision making. Modeling is also a mathematical or logical depiction of a system’s behavior. Simulation, is otherwise the device that implements the model. In many military operations, simulation is distinguished among three classes (rough). Live simulations, this involves real people using real equipment in the physical world (real world), like large field exercises. Virtual simulation, involves real people using simulators, flight simulators and/or actual information systems, this often provides realistic acts. Lastly, constructive simulations, this involves simulated people and systems operating in the simulated world, as in things like simulated combat, here users set the initial conditions and run the simulation to see what happens. Simulations are developed from the thoughts of human designers. All simulations are tested to assure accuracy and effectiveness, to illuminate specific issues or problems. The process that covers these mistakes and issues is associated with verification, validation and accreditation. These three sources are applied to a simulation development cycle that operated by the real world system, and is replicated and identified and the conceptual model of it is then identified. This conceptual model......

Words: 926 - Pages: 4

Premium Essay

Spreadsheet Modeling

... SPREADSHEET MODELING IN CORPORATE FINANCE To accompany Principles of Corporate Finance by Brealey and Myers CRAIG W. HOLDEN Richard G. Brinkman Faculty Fellow and Associate Professor Kelley School of Business Indiana University Prentice Hall, Upper Saddle River, New Jersey 07458 To Kathryn, you’re the inspiration, and to Diana and Jimmy, with joy and pride. Craig CONTENTS Preface PART 1 TIME VALUE OF MONEY Chapter 1 Single Cash Flow 1.1 Present Value 1.2 Future Value Problems Chapter 2 Annuity 2.1 Present Value 2.2 Future Value 2.3 System of Four Annuity Variables Problems Chapter 3 Net Present Value 3.1 Constant Discount Rate 3.2 General Discount Rate Problems Chapter 4 Real and Inflation 4.1 Constant Discount Rate 4.2 General Discount Rate Problems Chapter 5 Loan Amortization 5.1 Basics 5.2 Sensitivity Analysis Problems PART 2 VALUATION Chapter 6 Bond Valuation 6.1 Basics 6.2 By Yield To Maturity 6.3 System Of Five Bond Variables 6.4 Dynamic Chart Problems Chapter 7 Stock Valuation 7.1 Two Stage 7.2 Dynamic Chart Problems Chapter 8 The Yield Curve 8.1 Obtaining It From Bond Listings 8.2 Using It To Price A Coupon Bond 8.3 Using It To Determine Forward Rates Problems Chapter 9 U.S. Yield Curve Dynamics 9.1 Dynamic Chart Problems PART 3 CAPITAL BUDGETING Chapter 10 Project NPV 10.1 Basics 10.2 Forecasting Cash Flows 10.3 Working Capital 10.4 Sensitivity Analysis Problems Chapter 11 Cost-Reducing......

Words: 49278 - Pages: 198

Premium Essay

Financial Modeling

...Com3FD3 - Assignment 1 Due 11:00 p.m. Thursday October 2, 2014 Quick Buck Financial is launching a new product. The product is a two-year, partial amortization, new car loan, intended to help restore the customer's credit rating. The amortization period is between six and ten years depending on customer preference and previous credit history. To make things easy for their intended customers, they will have twice monthly payments (on the 15th and last day of the month), to better align with their pay checks. Interest will be charged on the basis of an APR with monthly compounding (mentioned in the fine print). The amount of the loan will be between $15,000 and $40,000 based on the expected professional clientele. If they want to borrow more or less, they will have to use a different product. Required: Build an amortization table model that handles the above constraints and offers an interest rate between 9% and 11.5% APR* in increments of 25 basis points (¼ of 1%). Required outputs of; required semi-monthly payment, balance owing at the end of the term, and total interest paid must be shown to the client. The model should not accept any input that does not conform to the loan details. Assume that the users are experienced with Excel and that they will be showing the model to potential clients. *Annual percentage rate with monthly compounding. A basis point is one percent of one percent or 0.0001. Semi-monthly means twice a month, 24 payments per year. ...

Words: 258 - Pages: 2

Premium Essay

Data Modeling

...Vilnius Gediminas Technical University Jelena Mamčenko Lecture Notes on INFORMATION RESOURCES Part I Introduction to Dta Modeling and MSAccess Code FMITB02004 Course title Information Resourses Course volume 3,0 cr. (4,50 ECTS cr.) Teaching methods (Full-time, daytime studies): Lectures - 16 h per semestre Laboratory works - 32 h per semestre Individual work - 72 h per semester Course aim Understandig of models and system of information resourses. Jelena Mamčenko Introduction to Data Modeling and MSAccess CONTENT 1 Introduction to Data Modeling ............................................................................................................... 5 1.1 Data Modeling Overview ............................................................................................................... 5 1.1.1 Methodology .......................................................................................................................... 6 1.1.2 Data Modeling In the Context of Database Design................................................................ 6 1.1.3 Components of A Data Model................................................................................................ 6 1.1.4 Why is Data Modeling Important? ......................................................................................... 6 1.1.5 Summary ................................................................................................................................ 7 1.2......

Words: 16719 - Pages: 67

Premium Essay

Finance Modeling

...-4-color process CMYK THE FINANCIAL CRISIS INQUIRY REPORT OFFICIAL GOVERNMENT EDITION I S B N 978-0-16-087727-8 90000 9 FC_cover.indd 1 780160 877278 -gritty matte UV THE FINANCIAL CRISIS INQUIRY REPORT Final Report of the National Commission on the Causes of the Financial and Economic Crisis in the United States • OFFICIAL GOVERNMENT EDITION • 1/20/11 2:07 PM THE FINANCIAL CRISIS INQUIRY REPORT This printing includes all corrections contained in the errata sheet issued by the Commission as found on the FCIC website as of February 25, 2011. THE FINANCIAL CRISIS INQUIRY REPORT ∞ FINAL REPORT OF THE NATIONAL COMMISSION ON THE CAUSES OF THE FINANCIAL AND ECONOMIC CRISIS IN THE UNITED STATES Submitted by THE FINANCIAL CRISIS INQUIRY COMMISSION Pursuant to Public Law 111-21 January 2011 OFFICIAL GOVERNMENT EDITION For sale by the Superintendent of Documents, U.S. Government Printing Office Internet: bookstore.gpo.gov Phone: toll free (866) 512-1800; DC area (202) 512-1800 Fax: (202) 512-2104 Mail: Stop IDCC, Washington, DC 20402-0001 I S B N 978-0-16-087983-8 CONTENTS Commissioners ...................................................................................................vii Commissioner Votes...........................................................................................viii Commission Staff List .................................................................

Words: 298639 - Pages: 1195

Free Essay

Jp Financial Modeling

...Effect of Industry Characteristics on Financial Statement Relationships. There are various strategies for approaching this problem. One strategy begins with a particular company, identifies unique financial characteristics (for example, electric utilities have a high proportion of property, plant and equipment among their assets), and then searches the common-size data to identify the company with that unique characteristic. Another approach begins with the common-size data, identifies unusual financial statement relationships (for example, Firm (10) has a high proportion of receivables), and then looks over the list of companies to identify the one most likely to have substantial receivables among its assets. We follow both strategies here. Firm (10) has a high proportion of receivables among its assets and substantial borrowing in its capital structure. This balance sheet structure is typical of the finance company, HSBC Finance. Why do the capital markets allow a finance company to have such a high proportion of borrowing in its capital structure? The answer is threefold: (1) finance companies have contractual rights to receive cash flows in the future from borrowers; the cash flow tends to be highly predictable, (2) finance companies lend to many different individuals, which diversifies their risk, and (3) borrowers often pledge collateral to back up the loan, which provides the finance companies with an alternative for collecting cash if borrowers default on their loans...

Words: 1900 - Pages: 8

Premium Essay

Advanced Financial Modeling

...Problem Set 1: Options 1. The strike price of a call option on GM common stock is $50. a) What is the payoff at expiration of this call if, on the expiration date, GM stock sells for $45? b) What is the payoff at expiration of this call if, on the expiration date, GM stock sells for $55? c) Draw the payoff diagram for this option. 2. Use the Black-Scholes model to price a call with the following characteristics: Stock price = $65 Strike price = $70 Time to expiration = 120 days Stock price variance = 0.35 Risk-free interest rate = 0.05 3. Suppose there is a call option on Go-East Airlines with a strike price of $22. Today’s date is May 3, 2015 and the call expires on May 18, 2015. The current risk free rate on a T-bill that matures the on the option’s expiration day is 1.8%, annualized. Go-East Airlines’ stock is currently trading $23 per share. The historical standard deviation for the stock is 22%. Assume that the option is European and that Go-East does not pay dividends. a) Use the Black-Scholes option pricing formula to determine the value of the call option. b) What is the value of a put option on Go-East Airlines that matches in maturity and strike price? 4. On August 7 2015, the Nokia Corporation’s stock traded at $15.36. At the time the stock price was quoted, the most actively traded option for this stock was a call option with September 2015 maturity and a strike price of $17.50. Assume that the option matures in...

Words: 384 - Pages: 2

Premium Essay

Financial Modeling

...A tutorial in managerial accounting concepts and financial modeling using Excel Assignment 1: Introduction We will begin our work this semester with a case called Caribbean Internet Café [hereafter, CIC]. In the CIC case, David Grant wants to open an Internet Café in Kingston, Jamaica. This simple business setting is familiar; how many coffee shops, drive-up or otherwise, can you think of that are within walking distance of campus? Even if you are not a coffee-holic, the operation of one of these places should be fairly self-evident. This assignment will help to fulfill a number of major objectives of the course: 1. The CIC case makes use of a relatively familiar context in which to introduce many of the managerial accounting concepts we will deal with this semester. The familiarity of the context should enable you to associate managerial accounting terminology with real world phenomena. 2. The structure of this series of exercises also provides an opportunity to develop your skills in using Excel to do financial modeling. Irrespective of your preferences for a career choice, financial modeling will be a critical skill in your professional life. Marketers and HR specialists take note: there is no avoiding the numbers. 3. The majority of you are still relatively early in your path through the School of Business program. Case analyses will be an important element in several of your subsequent courses. One key to successful case analysis is meticulous organization of......

Words: 5100 - Pages: 21

Premium Essay

Art of Modeling

...Source: S. G. Powell and K. R. Baker, 2004. The Art of Modeling with Spreadsheets. New York: Wiley & Sons. Copyright © 2004 by John Wiley & Sons, Inc CHAPTER 1 INTRODUCTION MODELS AND MODELING Modeling is the process of creating a simplified representation of reality and working with this representation in order to understand or control some aspect of the world. While this book is devoted to mathematical models, modeling itself is a ubiquitous human activity. In fact, it seems to be one of just a few fundamental ways in which humans understand the world. As an example, a map is one of the most common models we encounter. Maps are models because they simplify reality by leaving out most geographic details in order to highlight the important features we need. A state road map, for example, shows major roads but not minor ones, gives rough locations of cities but not individual addresses, and so on. The map we choose must be appropriate for the need we have: a long trip home across several states requires a regional map, while a trip across town to find a new doctor’s office requires a detailed street map. In the same way, a good model must be appropriate for the specific uses intended for it. A complex model of the economy is probably not appropriate for pricing an individual product. Likewise, a back-of-the-envelope calculation may be inappropriate for acquiring a multibillion-dollar company. Models take many different forms: mental, visual, physical, mathematical...

Words: 4929 - Pages: 20