BIA 0075 Formative Assessment for Spreadsheet Exercise Instructions Time allowed - 45 minutes Produce a spreadsheet that will deal with the following situation The Garden Gnome company is undertaking its five year forecast process and is in the process of constructing its profit and loss account. The following information is available a) In 2012 Sales are expected to be 50‚000 gnomes at £20 each but volumes and prices are expected to increase by 2% and 3% per annum respectively on a cumulative
Free Assessment Evaluation Income statement
balance sheet‚ like a photo‚ provides a financial picture of a company on a given day and time. It categorizes all of a company’s resources as assets‚ all of its debts as liabilities‚ and all of the owner’s investments as equity. A company uses its assets‚ such as accounts receivable‚ inventory‚ and equipment‚ for manufacturing or purchasing products for sale or to provide a service. A company’s assets are financed by its liabilities (debt) and the owner’s equity (net worth). On a balance sheet‚ the
Premium Balance sheet Generally Accepted Accounting Principles Asset
During the second half of 1997‚ and beginning in Thailand‚ currencies and stock markets plunged across East Asia‚ while hundreds of banks‚ builders‚ and manufacturers went bankrupt. The Thai baht‚ Indonesian rupiah‚ Malaysian ringgit‚ Philippine peso‚ and nouth Korean won depreciated by 40% to 80% apiece. All this happened despite the fact that Asia’s fundamentals looked good: low inflation‚ balanced budgets‚ well-run central banks‚ high domestic savings‚ strong export industries‚ a large and growing
Premium Currency United States dollar Exchange rate
U.S. Stock Market A stock market is defined as a public entity for the trading of company stock at an agreed price. When you buy stock‚ you become a shareholder‚ which means you now own a part of the company. If the company ’s profits rise‚ you will share in those increased profits. If the company ’s profits fall‚ so does the price of your stock. If you sold your stock on a day when the price of that stock falls below the price you paid for it‚ you would lose money. In the stock market‚ prices
Premium Stock market Stock Stock exchange
Risk is part of life : I face countless danger everyday driving to work. sure I can try minimize many of them through my own driving behavior . but I can’t prevent motorist behind me who is talking on his mobile from rear-ending me while I’m waiting at a stoplight. As much as we would have it otherwise‚ risk is part of life. Some risks can be averted by steering clear of them. Many are‚ however‚ unavoidable. False sense of security Sometimes you can insure yourself against the consequences of risks
Free Insurance Risk Bank
EXC3613 Risk Management with derivatives Geir Høidal Bjønnes geir.bjonnes@bi.no 1 Introduction • Learning objectives: 1. 2. 3. 4. What is a derivative? What is the role of Derivatives and Derivatives Markets Firms’ risk exposures Hedging price risk with derivatives • McDonald: Chapter 1 2 Example • Consider a farmer that grows wheat and is expecting to yield 10‚000 bushels of crop in 3 months. He is afraid that the price of wheat might drop at the period
Premium Futures contract Derivative Option
University of the Philippines Diliman Extension Program in Pampanga Claro M. Recto Highway‚ CSEZ‚ Pampanga A.Y 2013-2014 LABORATORY WORK # 2 THE BINOMIAL DISTRIBUTION Submitted by: Briones‚ Kristelle R. Mangrobang‚ Jonathane Submitted to: Prof. Ernesto Adorio January 2014 Description: Our instructor instructed to put tabulate the Binomial Distribution for various n given the values of p which are (0.1‚ 0.2‚ 0.3‚ 0.4‚ 0.5‚ 0.6‚ 0.7‚ 0.8 and 0
Premium Probability theory Random variable Binomial distribution
Microsoft Word and Excel Does Microsoft word and Excel have the most features for students? Some people feel word is better than excel. Word is a basic program that allows‚ students the ability to type letters or essays and in excel you have to input data into spreadsheets‚ which can be more complicated to do than just typing an essay. Word is the word processing application that is used to compose documents like letter or essays where text formatting is very essential to provide a printable
Premium Spreadsheet Microsoft Office Word processor
Excel Problems 1. The following time series represent the total population of the United States‚ in thousands‚ over the last 12 years. |Year |Population (in 000‚s) | |1991 |253‚493 | |1992 |256‚894 | |1993 |260‚255 | |1994 |263‚436 | |1995 |266‚557 | |1996 |269‚667 | |1997 |272‚912
Premium Time series analysis Moving average Forecasting
Types of Risk Stand-Alone Risk This risk assumes the project a company intends to pursue is a single asset that is separate from the company’s other assets. It is measured by the variability of the single project alone. Stand-alone risk does not take into account how the risk of a single asset will affect the overall corporate risk. Corporate Risk This risk assumes the project a company intends to pursue is not a single asset but incorporated with a company’s other assets. As such‚ the
Premium Balance sheet Generally Accepted Accounting Principles Asset