...ENTREPRENEUR WORKBOOKS Business Planning and Financing Management Series Building Block 2 The Business Plan and Executive Summary MaRS is a member of MaRS Discovery District, © December 2009 See Terms and Conditions MaRS – Business Planning and Financing Management Series THE BUSINESS PLANNING AND FINANCING MANAGEMENT WORKBOOK Introduction: What to expect In his book Outliers, Canadian author Malcolm Gladwell looks at the relationship between statistical probabilities and the chance of success in your chosen field of work or sports. His essential claim is that you need around 10,000 hours of practice to become really good in a particular field. This workbook guide will not take 10,000 hours to complete, so you should not expect that you will become an expert in business planning and financing management by going through the activities outlined within. Rather, the purpose of the workbook guide is to help you understand and focus on the key issues in the field of business planning and financing management, and to introduce you to frameworks within which to think and discuss essential areas of your business. The process offered will provide sufficient grounding in the topic so that you will know what questions to ask advisors and consultants, and, in the case of consultants, how to evaluate their work. Additionally, this workbook guide provides a launch point for a number of vital business decisions you will have to make to develop your start-up. As a best practice, it...
Words: 5454 - Pages: 22
...Spreadsheet Modeling Assignment 1. Objectives The purpose of this assignment is to use some of the more advanced tools that Excel provides to develop a model of a complex business problem. In particular, you will use the following Excel features: 1. Importing data from text files 2. Sorting data 3. Database functions 4. Pivot Tables 5. Data Tables 6. Goal Seeking 2. What You Will Need 1. Access to a computer with a printer and Excel 2007. 2. Note that the instructions in this handout are written for Excel 2007. There are significant differences in user interface between Excel 2007 and 2003. 3. Download the following three files: Mymodel.xls, labor.txt, and demand.txt. 3. What You Will Hand In 1. a CD containing the model your group develops - on the outer label, write the course number, group number, the name of each group member 2. two full-page charts (with your course number and group number as a footer) 3. four worksheet printouts (with your course number and group number as a footer) 4. Make sure your CD is free of any computer virus. A contaminated CD will result in a 50% penalty in grade! 4. Due Date Check the course syllabus for assignment due date. A penalty will be assessed against assignments handed in late (including during class). 5. Background You work for the NOVA Corporation, a mid-tier supplier of hoses and hose assemblies...
Words: 4251 - Pages: 18
...MS-EXCEL FOR CHARTERED ACCOUNTANTS SUNIL B GABHAWALLA CHARTERED ACCOUNTANT WESTERN INDIA REGIONAL COUNCIL OF THE INSTITUTE OF CHARTERED ACCOUNTANTS OF INDIA TABLE OF CONTENTS 1 2 Basics & Beyond......................................................................................................... 4 1.1 Introduction......................................................................................................... 4 1.2 The EXCEL Screen............................................................................................. 4 1.3 Moving Around................................................................................................... 5 Data Entry ................................................................................................................... 8 2.1 Text ..................................................................................................................... 8 2.2 Number (including date, time, percent) .............................................................. 8 2.3 Formulae ............................................................................................................. 8 2.4 Functions............................................................................................................. 9 2.5 AutoComplete ..................................................................................................... 9 2.6 AutoCorrect........................................................................................
Words: 16077 - Pages: 65
...Allocate+. If you have not enrolled for a tutorial class yet, please do so as soon as possible. Perdisco e-workbook TUTORIALS Your tutorial classes will be starting in this week. Please make sure to meet your tutor and take down his details (his name and consultation hours) in the first meeting. An online study resource (eworkbook) is available from a commercial firm for this unit to help you learn further. Please note that this is optional It’s designed to give you the chance to practice, revise and focus on each topic until you completely understand it E-workbook feedback provides step-by-step solutions to help you find out where you went wrong Contains interesting (and often humorous) practice questions to help you learn difficult concepts You also receive an academic discussion explaining how to get the answer correct next time 1 I really appreciated the prompt feedback. It’s like having a tutor there to explain things to you, whereas you can’t always make use of consultation hours. Angela, University of Sydney How to register Go to www.perdisco.com/students Click ‘Create a new account’ Follow the instructions on screen 1. The e-workbook has brought up my grades from a Pass to a Distinction… with this e-workbook I have a greater ability to excel in my studies. Adam, ACU 2. What do other students think of their e-workbook? 3. From Last Week Lecture (we discussed): What is a financial system and role of money? What are financial...
Words: 779 - Pages: 4
...Costing Method: The excel document title, “JET2 Task 1-4 Workbook” and tabs ‘Task 4 Cost-Volume-Profit’, and “Task 4 Activity Based Costing” is where the information is derived from and recommendations will be made based off of the information in these tabs. The excel document title, “JET2 Task 1-4 Workbook” and tab ‘Task 4 Cost-Volume-Profit’ highlights two unit costs methods: traditional and activity based. Each unit cost method will be analyzed and a recommendation will be made regarding which costing method should be used by Competition Bikes. Traditional method to figure out costs- this method computes the overhead cost of titanium bikes at $239,020 and the overhead costs of carbonlite bikes at $232,380 for a total overhead cost of $471,400 ($239,020 + $232,380= $471,400). Again this information was derived from the excel document titled, “JET2 Task 1-4 Workbook” and by clicking on tab ‘Task 4 Cost-Volume-Profit’ and by viewing the second half of the page, looking at the summary of traditional and carbonlite overhead costs. Once the overhead costs are known the direct costs for each bike will be added to that number. So for titanium bikes the direct cost is $402,300 plus the overhead cost $239,020= $ 641,320 for titanium bikes. For carbonlite bikes the direct cost is $447,000 + $232,380= $679,380. The $641,320 for the titanium bikes is considered the total cost and the $679,380 is considered the total cost for the carbonlite bikes. Take the total cost for each bike...
Words: 1954 - Pages: 8
...WORKBOOK B: CONDUCTING SECONDARY RESEARCH TABLE OF CONTENTS OVERVIEW OF SECONDARY RESEARCH .......................................................................... 3 Steps Involved in Secondary Research........................................................................................ 3 Advantages and Disadvantages of Secondary Research ............................................................. 4 Deciding Whether or Not to Outsource Secondary Research ..................................................... 5 OUTSOURCING SECONDARY RESEARCH: ........................................................................ 6 CONDUCTING SECONDARY RESEARCH USING INTERNAL RESOURCES:.............. 7 1. Identifying Sources of Information ........................................................................................ 7 2. Gathering Existing Data ....................................................................................................... 10 3. Normalizing Data ................................................................................................................. 12 4. Analyzing Data..................................................................................................................... 13 Demographic Analysis ..................................................................................................... 14 Workbook B -2- Conducting Secondary Research OVERVIEW OF SECONDARY RESEARCH Sometimes secondary research...
Words: 3511 - Pages: 15
...understand and apply mathematical ideas in a variety of contexts. With the increased use of advanced software in all fields, it is also important for the student to effectively interact with the new technology. Our goal is to integrate these two objectives in a supplement for the text Finite Mathematics and Its Applications, by Goldstein, Schneider, and Siegel. The package consists of interactive tutorials and projects in an Excel workbook format. The software platform used is the Microsoft Excel 5.0 spreadsheet. It was chosen for the following reasons: • • • suited to applications encountered in a finite math course widespread use outside of academia ease of creating reports with a professional look Use of Excel 5.0 was put into effect in the author's sections of the Finite Mathematics II course in the Spring 1996 semester. It was expanded to cover the Finite Mathematics I course for the Fall semester of 1996. Using a combination of specially designed projects and tutorials, students are able to analyze data, draw conclusions, and present their analysis in a professional format. The mathematical and computer skills learned with such an approach is an asset that they can carry with them to other courses as well as to their future places of employment. 2 Scope of supplement The package is divided into three portions - introduction to the software platform, interactive tutorials to reinforce ideas, and projects of more complexity. Introduction to the software Worksheets...
Words: 3176 - Pages: 13
...Assignment – Manage workforce planning Assessment due date: Click here to enter a date. Instructions You can use Fynntown scenario, or develop a workforce plan of approximately 4 x A4 pages based on your own organisation. Alternatively, you can use the template provided or develop your own Workforce Plan. Fynntown Scenario: You are an ambitious Customer Service Team Leader at Fynntown City Council Customer Service Centre (FCC CSC). FCC CSC does not currently have a good reputation for customer service with either the business or general community. You have a lot of ideas on how to improve this situation, but as a Team Leader, you do not have the authority to implement any of these ideas. Also, you have recently undertaken a risk assessment that identified workforce planning, in particular a skills gap within the CSC, as a significant risk to the organisation. There is a genuine risk that FCC will lose its State and Federal Government funding, which accounts for 40% of all Council funds, if customer service isn’t dramatically improved within 18 months. Consequently, the Council members are desperate to see improvements, without cutting into current spending or increasing rates. Fynntown documents available for research. • Fynntown Council’s Draft Community Strategic Plan 2012 – 2013 (to be found in Additional Resources) • Fynntown Council’s 2012-2013 Operational Plan (to be found in Additional Resources) • Fynntown Customer Service Centre...
Words: 1838 - Pages: 8
...Sample content/Comments: Field Packaging Example from Intranet: This report outlines medium term (3 – 5 years) strategic recommendations for the business strategy for Field Packaging East Kilbride (FPEK). These recommendations are based upon a comprehensive strategic analysis of FPEK’s current and likely future situation. The recommendations aim to enhance FPEK’s existing competencies. This will add value to the both the company and its customers. Thus enabling FPEK to develop and sustain competitive advantage in the highly competitive branded products market segment of the packaging industry, in which it operates. 2 Environmental Analysis (700 words) 2.1 Transactional Environment Social Despite a projected decline in population of 10 million by 2010 [01.], Russia is seeing a rise of the middle class, which has now reached 4 million adults and children [02.]. This segment has a taste for westernised affluence, so is demanding higher quality, premium, healthy products and increased convenience from the retail sector. There is a strong need for organisations to address this demand by supplying more innovative products of higher quality to the market (such as premium-range yogurts and healthy snacks). Market It is estimated that the grocery market in Russia will reach $186 Billion USD by 2010 which will be good for WBD’s future in the dairy market [02.]. In urban centres especially, there is a shift towards food being sold in supermarkets so that by...
Words: 1988 - Pages: 8
...opportunity cost and choice. Be able to work opportunity cost problems similar to cost of college and the alternative ways of travel problems that we did in class and on homework. Know the difference between normative and positive. Know the difference between positive sum games, zero sum games and negative sum games as discussed in the lecture. Economists use incentives to set up positive win-win games as in my classroom examples of Australia & golden content in trash. What is meant by the moral hazard problem? Understand the Eight Guideposts of economic thinking as discussed in your text. Go over the pitfalls of economic reasoning: Review the blackboard problems that you were assigned (especially the two on marginal analysis), but also the others. These are samples of the kinds of questions that you may expect. Review the Green Study Guide Problems and Projects on pages 2 & 3 for practice....
Words: 1815 - Pages: 8
...ABAP (Advanced Business Application Programming) ABAP Workbench The ABAP Workbench component is a fully-fledged development environment for applications in the ABAP language. With it, you can create, edit, test, and organize application developments. It is fully integrated in the R/3 Basis system and, like other R/3 applications, is itself written in ABAP. Application Servers R/3 programs run on application servers. They are an important component of the R/3 System. The following sections describe application servers in more detail. Structure of an Application Server The application layer of an R/3 System is made up of the application servers and the message server. Application programs in an R/3 System are run on application servers. The application servers communicate with the presentation components, the database, and also with each other, using the message server. The following diagram shows the structure of an application server: [pic] The individual components are: Work Processes An application server contains work processes, which are components that can run an application. Each work process is linked to a memory area containing the context of the application being run. The context contains the current data for the application program. This needs to be available in each dialog step. Dispatcher Each application server contains a dispatcher. The dispatcher is the link between the work processes and the users logged onto the application server. Its...
Words: 2346 - Pages: 10
...difficult seem easy in this book that can be used as a reference or read cover to cover. You won’t find a more comprehensive book on Excel 2010 than this!” —Dick Kusleika, Microsoft MVP, DailyDoseOfExcel.com • Searchable PDF of the book • Understand functions, charts, worksheets, and workbooks System Requirements: See the CD Appendix in the book for details and complete system requirements. • Master “what-if” analysis, Goal Seeking, external database files, and pivot tables • Develop custom functions, program with VBA, and create UserForms • Try new slice-and-dice tools to dynamically filter your data Preview how your copied text will look www.wiley.com/compbooks Spot trends in your data with Sparklines John Walkenbach aka “Mr. Spreadsheet” is the principal of J-Walk and Associates, Inc. and a Microsoft Excel MVP. He is a leading authority on spreadsheet software and the creator of the award-winning Power Utility Pak. John has written more than 50 books, as well as articles and reviews for publications including PC World, InfoWorld, and Windows. He also maintains the popular Spreadsheet Page at spreadsheetpage.com. ® • All the examples and workbook files used in the book Microsoft® Follow the examples in the book, chapter by chapter, using the bonus materials on the CD-ROM: Excel 2010 What’s on the CD-ROM? • Get up to speed on everything new in Excel 2010 • Perform magic with array formulas—and even more with Sparklines ...
Words: 167105 - Pages: 669
...MULTIMEDIA LEARNING MATERIALS FROM THE EXPERTS PRODUCT CATALOGUE JANUARY 2012–JUNE 2012 BPP Learning Media has been producing high quality study materials for more than 30 years. We are the publisher of choice for students, tuition providers, companies and professional bodies in more than 150 countries worldwide. Using the expertise of our specialist authors and tutors, we have developed a range of innovative study aids in a variety of formats including web delivery, audio-visual products, CD-ROMs and books. Our products are designed to support a variety of different learning styles, ensuring all students make the most of their study time and successfully achieve their learning outcomes. This catalogue is your comprehensive guide to the qualifications we publish for and the learning materials we offer in support of those qualifications, together with our UK and overseas stockists directory. CONNECT WITH US bpp.com/learningmedia twitter.com/bpplm LinkedIn: BPP Learning Media Clients contents 04 ABoUt Us WhaT’s neW aT 12 BPP LeaRning MeDia 14 insTiTUTe OF LeaDeRshiP anD ManageMenT (iLM) 15 MeDiCaL seRies assOCiaTiOn OF BUsiness exeCUTives (aBe) 16 a BRanD neW 17 aPPROaCh a neW iDenTiTY 17 a neW PROPOsiTiOn 18 inFORMaTiOn FOR BOOKseLLeRs 20 WhOLesaLe ORDeRs 23 BeCOMe a sTOCKisT TUiTiOn PROviDeRs 24 TeRMs anD COnDiTiOns OF saLe RegiOnaL saLes ManageRs 24 CUsTOMeR seRviCes PRinTeD 25 PRODUCTs 26 sTUDY TexTs PRaCTiCe & RevisiOn KiTs 27 PassCaRDs 28 eLeCTROniC PRODUCTs...
Words: 28023 - Pages: 113
...Memo OCEAN CARRIERS Date: January 2, 2001 To: Mary Linn, Vice President of Finance From: Thomas Harper Subject: Investment in New Capesize Bulk Ship After analyzing the commissioning of a new capsize ship for a three-year lease, my team has come to the conclusion that Ocean Carriers should move forward with the investment only if it is built and registered in our Hong Kong office. There were key assumption my team and I made in our analysis and they are as follows: 1. We assumed a discount rate of 9% throughout the life of the new capsize. 2. Secondly, we assumed a tax rate of 35% in the United States and a 0% tax rate in Hong Kong. 3. The company policy of only 15 years of service would be upheld with the new capsize. 4. The given spot rates are reasonably accurate throughout the life of the capesize. 5. The charterer offered rate and annual escalation for years 1 through 3 are set in stone. After considering our assumptions we analyzed the data to calculate the free cash flows of the project and were able to come up with the Net Present Value, Profitability Index, and the Internal Rate of Return for the new project. Our calculations are in the attached Excel Workbook under the Investment tab. As you will see in the Excel tab the NWC gained from building the capesize in Hong Kong was $7,149,883, while the NWC from building the capesize in United States created a loss of $1,207,088 for the company. Exhibit 2 it shows the...
Words: 628 - Pages: 3
...not important for the business operations, however, it does not come to their mind that there are several production costs which do have vital environmental component. For example the purchase cost of raw materials or the unused portion which is emitted as waste is not considered to be environmentally related cost. By identifying as well as controlling these environmental costs, using Environmental Management Accounting (EMA) Systems, it can help environmental managers justify the cleaner production and along with this justify totally new methods of saving money as well as improving their environmental performance also at the same time (Magarinos, 2005) . Thus EMA can be defined as: “ EMA serves business managers in making capital investment decisions, costing determinations, process/ product design decisions, performance evaluation and a host of other forwards looking business decisions” (UNDSD, 2000; p 39) . 1.1 Environmental Accounting The understanding as well as recognition along with incorporation of impacts of issues related to environment on the firms traditional accounting sub-systems is called as...
Words: 2932 - Pages: 12
