...to QuickBooks 3. Assign classes to employee’s time that was transmitted from Journyx to QuickBooks 4. Enter Time & Billable expenses into VIP system (for Lockheed Martin) 5. Every Monday following the week time was entered in VIP, go into VIP check to if time & expenses have been approved & print out invoice report for previous week, and then put this invoice into QuickBooks. 6. After collecting Time create invoices for projects Unisys & Lockheed Martin (Cloc, I2SSC). These are the only weekly billed Projects. Biweekly Tasks 1. Transmit payroll by 5pm on the Tuesday that is payroll week. 2. Enter Time bank taken into Time bank spreadsheet after payroll is done. 3. Transmit 401k through CMC Interactive website on the Friday of the payroll. 4. Transmit 401K Through Charles Schwab (after transmitting through CMC interactive). 5. Update 401k spreadsheets for FY Financials. 6. Enter payroll journal entries into QuickBooks – Payroll J/E Vacation J/E Class Allocation 401k 7. Enter Invoices into Burn Rates spreadsheets. 8. Check Burn Rate spreadsheets to make sure there is enough funding 9. Update FY Time bank spreadsheet for FY Financial Reports. Accounting Principles Indirect Cost – Any cost that cannot be directly identified with a single final cost objective but can be identified with two or more final...
Words: 2910 - Pages: 12
...companies such as Tasty Baking Company's Tastykakes. With 40 distribution facilities all over the United States and Europe, over 4,500 products, and over 150 product lines, the home office in Hanover, Pennsylvania, has a considerable amount of data to manage. If there was one last vestige of old-fashioned business left at Snyder's, it was the company's method of managing and analyzing data. Although Snyder's sells more than 78 million bags of pretzels, chips, and organic snack items each year, some of its core systems were still heavily manual and paper-based. Snyder's financial department was using electronic spreadsheets for much of its data-gathering and reporting. Lois Stambaugh, Hanover's financial analyst, would spend the entire final week of each month collecting Excel spreadsheets from the heads of more than 50 departments worldwide. Then she would consolidate and reenter all the data into another Excel spreadsheet, which would...
Words: 1592 - Pages: 7
...companies such as Tasty Baking Company's Tastykakes. With 40 distribution facilities all over the United States and Europe, over 4,500 products, and over 150 product lines, the home office in Hanover, Pennsylvania, has a considerable amount of data to manage. If there was one last vestige of old-fashioned business left at Snyder's, it was the company's method of managing and analyzing data. Although Snyder's sells more than 78 million bags of pretzels, chips, and organic snack items each year, some of its core systems were still heavily manual and paper-based. Snyder's financial department was using electronic spreadsheets for much of its data-gathering and reporting. Lois Stambaugh, Hanover's financial analyst, would spend the entire final week of each month collecting Excel spreadsheets from the heads of more than 50 departments worldwide. Then she would consolidate and reenter all the data into another Excel spreadsheet, which would...
Words: 1536 - Pages: 7
...ii Enable Project Expenditure Types for Expense Report Entry 1 AP: Define Expense Report Templates 2 AP: Define Financials Options 3 AP: Set Expense Check Reimbursement Address 3 AP: Define Expenses Clearing Account 3 AP: Define Payables Options 4 AP: Establish Multiple Currencies Setup 4 AP: Defining Expense Report Options 4 Assign Signing Limits 6 Define iExpense Policies 7 Set Up Required Expense Fields 7 Enable Expense Allocations 8 Define Receipt Notification Rule Set 9 Assign Receipt Notification Rule Set 10 Define Mileage Rate Schedule 11 Complete Mileage Expense Type Definition in Payables 12 SA: Define Profile Options 13 System Administration Integration 18 Customize the Internet Expenses Workflow 19 Define a new OIEADMIN Role 19 Define Workflow Notification Performers 20 Change the Find Approver Method 21 Personalize Expense Report Submission Instructions 22 Integrating with Oracle Projects Summary 23 7. Enable the Display of Project and Task. Use the Region Items window to enable the display of project and task information. You need to perform this step in order to view projects and tasks in View Expense Report History. 24 Set Up Offline Expense Spreadsheet Template 25 Configure the Expense Report Sheet 25 Testing a New Custom Microsoft Excel Template 28 Save the spreadsheet to the database 29 Other Configuration Considerations 30 Open and Closed Issues 31 Enable Project Expenditure Types for Expense Report Entry Project...
Words: 6272 - Pages: 26
...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
...demand to price 352–356 Pricing problems 352–366, 422–427 Estimating cost of power 363–366 47–56, Assessing a utility function 554–556 Estimating demand for products 632–638, 649–650, 764–771, 965 Subway token hoarding 792 FINANCE AND ACCOUNTING Collecting on delinquent credit accounts 14–16 Cost projections 29–33 Finding a breakeven point 33–41 Calculating NPV 57–62 Calculating NPV for production capacity decision 58–62 Portfolio management 173–178, 345–346, 387–394, 442–444, 689–691 Pension fund management 178–182 Financial planning 210–214, 676–681, 734–735 Arbitrage opportunities in oil pricing 215–219 Currency trading 220 Capital budgeting 290–295 Estimating stock betas 396–401 Hedging risk with put options 407–408 Stock hedging 407–408 Asset management 409–410 New product development 503–504, 574, 673–676, 715–722 Bidding for a government contract 513–518, 523–533, 653–657 Investing with risk aversion 557–560 Land purchasing decision 575 Risk analysis 582–583 Liquidity risk management 651–653 Estimating warranty costs 657–661 Retirement planning 681–685 Modeling stock prices 685–686 Pricing options 686–689, 691–693 Investing for college 732 Bond investment 733 HUMAN RESOURCES AND HEALTH CARE Fighting HIV/AIDS 23–24 DEA in the hospital industry 184–189 Salesforce allocation problems 454–456 Assigning MBA students to teams 462 Selecting a job 484–492 Selecting a health care plan 519–521 Drug testing for athletes 535–538...
Words: 68271 - Pages: 274
...CHAPTER 1 What Is Financial Modelling? here are all sorts of complicated definitions of financial modelling, and in my experience there is quite a bit of confusion around what a financial model is exactly. A few years ago, we put together a Plum Solutions survey about the attitudes, trends, and uses of financial modelling, asked respondents “What do you think a financial model is?” Participants were asked to put down the first thing that came to mind, without any research or too much thinking about it. I found the responses interesting, amusing, and sometimes rather disturbing. Some answers were overly complicated and highly technical: n T n n n n “Representation of behaviour/real-world observations through mathematical approach designed to anticipate range of outcomes.” “A set of structured calculations, written in a spreadsheet, used to analyse the operational and financial characteristics of a business and/or its activities.” “Tool(s) used to set and manage a suite of variable assumptions in order to predict the financial outcomes of an opportunity.” “A construct that encodes business rules, assumptions, and calculations enabling information, analysis, and insight to be drawn out and supported by quantitative facts.” “A system of spreadsheets and formulas to achieve the level of record keeping and reporting required to be informed, up-to-date, and able to track finances accurately and plan for the future.” Some philosophical: n “A numerical...
Words: 17366 - Pages: 70
...Overview and examples from Finite Mathematics Using Microsoft Excel® Revathi Narasimhan Saint Peter's College An electronic supplement to Finite Mathematics and Its Applications, 6th Ed. , by Goldstein, Schneider, and Siegel, Prentice Hall, 1997 Introduction In any introductory mathematics course designed for non-mathematics majors, it is important for the student to 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...
Words: 3176 - Pages: 13
...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 Project 11...
Words: 49278 - Pages: 198
...Environment……………………………………………………………...2 2.5 Intended Users and Uses…………………………………………………………….2 2.6 Assumptions and Limitations……………………………………………………….3 2.7 Expected End Product and Other Deliverables………………………………….…..3 3 Approach & Results……………………………………………………………………..4 3.1 Functional Requirements……………………………………………………………4 3.2 Design Constraints…………………………………………………………………..4 3.3 Approaches………………………………………………………………………….5 3.4 Detailed...
Words: 9087 - Pages: 37
...Title: Unit-6: Business Decision Making Submitted To Submitted By Name: Id: Date of Submission: Table of Contents Introduction 4 Assignment One 4 Q1. A plan for the collection of primary and secondary data for the above scenario 4 Q2. Present the survey methodology and sampling frame used 5 Q3. Design a questionnaire to know the opinion of students and staff on the matter 5 Q4. Create information for decision making by summarizing data using representative values 7 Q5. Analyze the results to draw valid conclusions in the above scenario 9 Q6. Produce graphs using spreadsheets and draw valid conclusions based on the information derived from the survey 10 Q7. Create trend lines in spreadsheet graphs to assist in forecasting so that the college management can forecast what they need to spend in the future 12 Q8. Prepare a business presentation using Microsoft PowerPoint and give a presentation to disseminate information effectively on your findings 12 Q9. Produce a formal business report 12 Assignment Two 13 Q1.a) A frequency table with a class interval of 5 13 Q1.b) Calculation of mean, variance and standard deviation 14 Q1.c) Score corresponds to 50% percentile 17 Q1.d) Calculation of the location of third quartile 17 Q2. Calculation of the Karl Pearson’s co-efficient of correlation between monthly income (in hundreds of pounds) and monthly telephone bills (in pounds) 18 Assignment Three 19 Q1. Preparation of a project plan for...
Words: 3515 - Pages: 15
...Room 525 john.andrew@queensu.ca 613-533-6000 ext. 75756 Session Time: Mondays, 11:30 am - 2:20 pm Session Room: Robert Sutherland Hall, Room 554 Overview of the Course The course is an introduction to the concepts, principles and analytical methods involved in making the broad variety of key investment decisions regarding commercial real estate. It is designed to supplement, rather than replace SURP 844: Real Estate Project Planning. Therefore, the emphasis of this course is on commercial real estate investment rather than development. However, some elements of the latter will inevitably be addressed. The focus will be on fullyoperational income-generating properties, primarily large in scale. The main asset types of office, industrial, retail and multi-unit residential will be discussed (and possibly a few more specialized types). Another emphasis of the course will be on the micro level – the evaluation of the investment merits of individual properties (or at least individual transactions). Less attention will be paid to the macro level i.e. portfolio management. To the extent possible, the course content (including readings, cases and assignments) will be Canadian (although it is recognized that real estate investment is increasingly a global endeavor). This is primarily a combination seminar and case study course. It is designed around a cornerstone of five carefully chosen guest speakers, who will each address their specific area of expertise within commercial real estate...
Words: 2545 - Pages: 11
...DSS Assignment (Assignment 1) GROUP DUE DATE: March 13, 2015 Peer Evaluation: Each group member will be grading other team members. A student’s score will be an average of the group member’s rating times the overall assignment score. For example if you get an average of 80/100 in peer evaluation from your group and 90 in the assignment, your INDIVIDUAL score would be 90*.8 = 72/100. If there is a problem with your group members, please e-mail me right away!!! PEER Evaluations are posted in the ASSIGNMENT section under PEER_EVAL_assignment1 Once the project is submitted, fill it out and post it in SAKAI under peereval1 Peer Evaluation has TWO parts * Rubric part (one for each group member) * Text Part (only once) If your team has three/four members, you will be submitting two/three rubric parts by copying and pasting rubric parts as needed (one for each group member; do not evaluate yourself) and ONE text part COMBINE all in ONE file. Do not submit separate files for each group member. SUBMIT only one rubric file with all evaluation!!!!! Budget Planning and DSS System for Pierogi_rus.com COMPANY HISTORY Pierogi, Inc. was started by Mr. Polanki, Sr. in 1962 in the basement of his home in Warsaw, Poland. He and his wife worked endless hours experimenting and promoting their product. Eventually, their product became known as the specialty Pierogi in supermarkets, restaurants and food circles. The sales increased almost 10 percent...
Words: 2405 - Pages: 10
...the written permission of the publisher. ISBN: 978-0-7356-6703-7 1 2 3 4 5 6 7 8 9 LSI 8 7 6 5 4 3 Printed and bound in the United States of America. Microsoft Press books are available through booksellers and distributors worldwide. If you need support related to this book, email Microsoft Press Book Support at mspinput@microsoft.com. Please tell us what you think of this book at http://www.microsoft.com/learning/booksurvey. Microsoft and the trademarks listed at http://www.microsoft.com/about/legal/en/us/IntellectualProperty/ Trademarks/EN-US.aspx are trademarks of the Microsoft group of companies. All other marks are property of their respective owners. The example companies, organizations, products, domain names, email addresses, logos, people, places, and events depicted herein are fictitious. No association with any real company, organization, product, domain name, email address, logo, person, place, or event is intended or should be inferred. This book expresses the author’s views and opinions. The information contained in this book is provided without any express, statutory, or implied warranties. Neither the authors, Microsoft Corporation, nor its resellers, or distributors will be held liable for any damages caused or alleged to be caused either directly or indirectly by this book. Acquisitions and Developmental Editor: Kenyon Brown Production Editor: Kristen Borg Editorial Production: Zyg Group, LLC Technical Reviewer: Chris Casingena Copyeditor: Kim Burton-Weisman Indexer:...
Words: 26180 - Pages: 105
...goals for managers and employees and, if properly implemented, can motivate them toward achievements of the goals. Promote coordination and communication within the organization. Budgets compel managers to think of interdependencies and interrelationships among subunits of the organization. A budget is also a communication device that helps all employees and managers understand and accept the organization’s objectives and expected roles and contributions over the coming period. Authorization to act. The approved budget, particularly in a not-for-profit setting, gives the manager authorization to act (make decisions, etc.). Other benefits can include serving as a basis for resource allocation, aiding cash-flow management, and...
Words: 23702 - Pages: 95
