Premium Essay

Financial Modeling

In:

Submitted By zhangxinlin
Words 5100
Pages 21
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 relevant facts and information. The approach I am suggesting is one way to ensure that you have all the information you need in one place.
We’ll work through the case over several days, developing an increasingly sophisticated understanding of the concepts and terminology of managerial accounting. At times, the CIC case will be very much in the foreground as we use David’s situation to illustrate

Similar Documents

Premium Essay

Financial Modeling

...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...

Words: 266 - Pages: 2

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

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

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

Keystone Brochure

...Keystone Business Support Company Ltd. ABOUT US Keystone is a professional services company with management and administrative staff headquartered in Dhaka, Bangladesh. The company provides comprehensive business solutions to private businesses, financial institutions, investors, bilateral and multilateral institutions. A special strength of Keystone lies in its ability to help prepare for and implement energy sector projects both with regards to conventional and nonconventional energy sources. Keystone is also particularly strong in the areas of financial modeling and conducting legal and technical due diligence. These strengths are applicable in a wide variety of fields and we are constantly branching out to new areas to expand our product offering. Keystone has a global network of expert consultants across major cities including Boston, Delhi, Dubai, Hong Kong, London, New York, San Francisco, Singapore, Sydney, and Washington DC. Keystone is continually expanding to other major cities as its business grows. OUR APPROACH Keystone’s Project Teams pair international experts with local talent to devise Global Best Practice Solutions tailored to the specific country context. This also allows us to offer a high international quality service locally. Our first and foremost goal is to craft concrete and actionable steps for our clients that deliver results. OUR STRENGTHS Expertise : Keystone draws its strength from its diverse team of international experts. The company...

Words: 1321 - Pages: 6

Free Essay

O You Want to Be a Model?

...You don’t have to be tall and super thin. No matter what you look like: You too can become a Model!  There are different types of models and you have to be realistic in your expectations! There are fashion models, teen models, plus size models, and commercial models. Whenever you look at any magazine, or newspaper ad that is not geared towards fashion you see commercial models. And commercial models look like normal everyday people. As a commercial model, you are not going to get rich. At least most people won’t. But it can be fun part-time work with benefits such as free clothes, great pictures, and usually local recognition. Last night, I participated in Aaron Marcus' Tele-seminar entitled "How to Get Acting and Modeling Jobs and Find Modeling Agencies".  The seminar lasted about an hour.  You could call in and watch it over the Internet. Aaron offers workshops that you can attend live, but of course he doesn’t come to Birmingham, AL Some of the things that Aaron covered in his seminar were: * How to be a model regardless to what you look like. * What it takes to be a working model. * What to focus on when starting out. You see commercial models in many types of ads. Everyday people are used all of the time posing as Doctors, Lawyers, Teachers, Athletes, etc. Figure out what look you fit and target your career at those types of roles. Once you figure out what type of model that you can be, practice, practice, practice. Gather pictures of looks...

Words: 432 - Pages: 2

Premium Essay

"Enterprise Level Data Work Flows and Data Warehouse

...gratitude to Professor.Rajni Palikhey who helped and supported us right throughout the semester. This paper would not have been possible without her cooperation and technical assistance. We would also thank our Institution and our faculty members without whom this project would have been a distant reality. We also extend our heartfelt thanks to our family and well wishers. I would like to take this occasion to specially thank University of Northern Virginia to provide us with excellent faculty and also in supporting us getting quality education remotely. Contents SL No Title Page no 1 Abstract 5 2 Introduction to Databases 6 3 OLTP and OLAP Systems 7 4 Difference between OLTP and OLAP 9 5 Data Modeling 13 6 Workflows in Enterprise level Data warehousing 18 7 Business Intelligence tools used in Data flow and Data Warehousing 21 8 Analysis in Data warehousing 24 9 Conclusion 28 10 Foot Note 30 11 References 31 ABSTRACT These days majority of the applications, may it be web applications or windows applications or mobile applications, are completely database dependent. Most of the application developments are becoming database driven environments, hence rendering databases as one of the most key elements in a software environment. This dependency on databases can attributed to the increasing number of data requirements from the...

Words: 6349 - Pages: 26

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 of...

Words: 477 - Pages: 2

Free Essay

Benefits of 3 D Modelling

...The Transition from 2D Drafting to 3D Modeling Benchmark Report Improving Engineering Efficiency September 2006 — Underwritten, in Part, by — The Transition from 2D Drafting to 3D Modeling Benchmark Report Executive Summary D o more with less. The mandate hasn’t changed for manufacturers. They must develop more products with increasing complexity to address customer and competitive pressures. Yet, there’s no “give” in project timelines to adopt new technologies like 3D modeling to help them win. However, some manufacturers are not only adopting 3D modeling technology, but excelling at hitting their product development targets at the same time. How is it possible? Interestingly enough, it’s actually quite simple. Key Business Value Findings • Best in class manufacturers their hit revenue, cost, launch date, and quality targets for 84% or more of their products. • Best in class performers typically produce 1.4 fewer prototypes than average performers. • Best in class performers average 6.1 fewer change orders than laggard performers. • In total, best in class manufacturers of the most complex products get to market 99 days earlier with $50, 637 lower product development costs. Implications & Analysis How do they do it? • Best in class performers are 40% more likely to have engineers use CAD directly to ensure they stay close to the design. • Best in class performers are 24% more likely to take advantage of extended 3D modeling design capabilities. They are 55% more...

Words: 8589 - Pages: 35

Free Essay

Anitia Norris Model Management

...Richard Ivey School of Business Foundation, The University of Western Ontario, London, Ontario, Canada, N6A 3K7; phone (519) 661-3208; fax (519) 661-3882; e-mail cases@ivey.uwo.ca. Copyright © 2010, Richard Ivey School of Business Foundation Version: (A) 2010-09-10 On March 17, 2010, Anita Norris, owner of Anita Norris Model Management (ANMM) of London, Ontario was contemplating the future of her business. In the two years since Norris started ANMM, the business had grown quickly through her efforts to pursue any revenue stream that presented itself. Although Norris welcomed ANMM’s success, she believed that continuing to operate in this manner would stretch her business model too thinly. ANMM’s current revenues came from four sources: modeling workshops, signing and booking models, model development, and speaking fees. Norris now wanted to develop a strategy that would focus her business and allow her to spend most of her time...

Words: 7564 - Pages: 31

Free Essay

Hostel Management System

...Define user documentation Written or other visual information about an application system, how it works, and how to use it. (17) . User documentation refers to the documentation for a product or service provided to the end users. The user documentation is designed to assist end users to use the product or service. This is often referred to as user assistance. The user documentation is a part of the overall product delivered to the customer. The sections of a user manual often include: * A cover page * A title page and copyright page * A preface, containing details of related documents and information on how to navigate the user guide * A contents page * A guide on how to use at least the main functions of the system * A troubleshooting section detailing possible errors or problems that may occur, along with how to fix them * A FAQ (Frequently Asked Questions) * Where to find further help, and contact details * A glossary and, for larger documents, an index realized the importance of documentation many years ago when I joined an organization to head its IT function. The previous IT head had left the organization a couple of months ago. The managing director called me over and voiced his expectation. He told me that all ground work had been done for ordering new set of servers and application packages and that I should act upon it soon. I promised to take a look at the situation and revert with plans. However, when I sat in my department...

Words: 2026 - Pages: 9

Free Essay

Anita Norris Model Management

...and perfection. Another social force for clients is they face uncertainty of changing consumer desires as they are highlighting the importance of healthy lifestyles and body types. Demographics For fashion models age is a very strong factor in the selection process. Models are usually discovered between the ages of 12 to 20 by agents or scouts. High fashion modeling agencies often demand height and body shape requirements and have strong preferences for standards. With cultural diversification of the Western world, ethnic diversity is becoming an important factor for all people in the modeling industry. Moreover, various races and backgrounds are becoming progressively noticeable. Anita Norris needs to be aware of the changing demographic trends in the modeling industry Technological Factors With the internet and digital technology, global networks of scouts and agencies have unlimited access to clients and models around the world. Agents are able to snap pictures and videos on digital cameras, and they can email these as virtual casting packages to clients anywhere around the globe. The modeling industry has benefited considerably from the start of the internet. Many of...

Words: 2018 - Pages: 9

Premium Essay

Healthcare Data Warehousing

...Healthcare Data Warehousing Doug Kelley Health Informatics I Professor Lu December 7, 2012 Abstract ` Dimensional modeling lays the groundwork for data warehouses. Dimensional modeling is a similar process to traditional Entity/Relationship modeling in regards to tables (entities) having joins (relationships) with other tables via primary keys. Dimensional modeling has been used as a standard in industry for decision support systems in other areas such as transportation, production, sales and marketing. (Parmanto, 1) Because healthcare has many complex events, it has lagged behind other industries in terms of data warehousing. This paper will discuss several techniques that can help overcome these complexities. Introduction A data warehouse has been defined as a database optimized for long-term storage, retrieval, and analysis of records aggregated across patient populations, often serving the longer-term business and clinical analysis needs of an organization (Shortliffe, 932). For a data warehouse to perform these roles, it must be architected or modeled appropriately. There are a couple of different approaches to modeling data warehouses. Dimensional modeling is becoming standard approach. Background Review Designing a data warehouse for healthcare presents many unique challenges for designing a database. These include such complexities as multiple diagnoses, multiple payers, multiple physicians; primary and secondary, and late arriving data, such...

Words: 1887 - Pages: 8

Premium Essay

The Rea Accounting Model: Intellectual Heritage and Prospects for Progress

...The REA Accounting Model: Intellectual Heritage and Prospects for Progress Cheryl L. Dunn Florida State University William E. McCarthy Michigan State University Send page proofs to: William E. McCarthy Department of Accounting N270 North Business Complex Michigan State University East Lansing, MI 48824 Acknowledgments: The authors would like to acknowledge the helpful comments of three anonymous referees and the editor on two earlier versions of this paper. Helpful pointers into the literature were provided by William Schrader and Stephen Zeff. We would also like to acknowledge comments received at the Michigan State University 1995 Summer AIS Colloquium and at the 1995 Workshop on Semantic Modeling of Accounting Phenomena. Financial support was received from Arthur Andersen LLP and from the Departments of Accounting at Grand Valley State University and Michigan State University. The REA Accounting Model: Intellectual Heritage and Prospects for Progress ABSTRACT: Researchers often equate database accounting models in general and the Resources-Events-Agents (REA) accounting model in particular with events accounting as proposed by Sorter (1969). In fact, REA accounting, database accounting, and events accounting are very different. Because REA accounting has become a popular topic in AIS research, it is important to agree on exactly what is meant by certain ideas, both in concept and in historical origin. This article clarifies the intellectual...

Words: 10700 - Pages: 43

Premium Essay

Data Management

...(online analytical processing) is computer processing that enables a Big data analytics Data modeling Ad hoc analysis user to easily and selectively extract and view data from different points of view. For example, a user can request that data be analyzed to display a spreadsheet showing all of a company's beach ball products sold in Florida in the month of July, compare revenue figures with those for the same products in September, and then see a comparison of other product sales in Data visualization Extract, transform, load (ETL) Florida in the same time period. To facilitate this kind of analysis, OLAP data is stored in a multidimensional database. Whereas a relational database can be thought of as two-dimensional, a multidimensional database considers each data attribute (such as product, geographic sales region, and time Association rules (in data mining) Relational database period) as a separate "dimension." OLAP software can locate the intersection of dimensions (all products sold in the Eastern region above a certain price during a certain time period) and display them. Attributes such as time periods can be broken down into subattributes. Denormalization OLAP can be used for data mining or the discovery of previously Master data management (MDM) undiscerned relationships between data items. An OLAP database does not Predictive modeling needed for trend...

Words: 4616 - Pages: 19