3 Pages

# ExcelTutorial09

Course: DSC 240, Fall 2010

School: Oregon

Word Count: 23630

Rating:

###### Document Preview

Tu T orial 9 O b j ectives Session 9.1 Work with financial functions to analyze loans and investments Create an amortization schedule Calculate a conditional sum Cengage Learning. All rights reserved. No distribution allowed without express authorization. Working with Financial Tools and Functions Developing a Financial Analysis Case|Bent Cycling Diane Cross is the owner of Bent Cycling, a small company in...

##### Unformatted Document Excerpt
Coursehero >> Oregon >> Oregon >> DSC 240

Course Hero has millions of student submitted documents similar to the one
below including study guides, practice problems, reference materials, practice exams, textbook help and tutor support.

Course Hero has millions of student submitted documents similar to the one below including study guides, practice problems, reference materials, practice exams, textbook help and tutor support.

Find millions of documents on Course Hero - Study Guides, Lecture Notes, Reference Materials, Practice Exams and more. Course Hero has millions of course specific materials providing students with the best way to expand their education.

Below is a small sample set of documents:

Oregon - DSC - 240
Tu T orial10O b j ectivesSession 10.1 Exploretheprinciplesofcostvolume-profit relationships Performabasicwhat-if analysis UseGoalSeektocalculatea solution Createaone-variabledatatable Createatwo-variabledatatable Session 10.2
Concordia Canada - ENGR - 235
SAMPLE EXAMINATION QUESTIONS Chapter 1 The mid-term (final exam) will have up to 8 (25) questions for 1 (3) hours. Adjacent students will have different exams. Special instructions: Closed book. No calculators. A non-electronic dictionary is permitted. I
Concordia Canada - ENGR - 235
Sample Multiple Choice Questions Chapter 2In Part 1: Consider carefully each question, and select the best answer In Part 2: Write the answer number and its reason or justification.Part 1 The situation1. The following code segment has a syntax error:I
Concordia Canada - ENGR - 235
Sample Multiple Choice Questions Chapter 3In Part 1: Consider carefully each question, and select the best answer In Part 2: Write the answer number and its reason or justification.Part 1. Note: Line numbers are added for reference onlyThe situation In
Central New Mexico Community College - ENGLISH - 102
Gina Pazzi English 1102-204 Essay Three Dr. Rose DayViews of DeathWhen Death Comes, by Mary Oliver, is the best poem I read in our class. The poem was clear and easy to comprehend; it had similes and good comparisons; it spoke about living life to the f
Daemen - PT - PT101
The Knee Joint11/22/10Cadetto edit Master subtitle style Click Aaricka ReamerAnatomy4 Ligamentsl l l lAnterior Cruciate Ligament (ACL) Posterior Cruciate Ligament (PCL) Lateral Collateral Ligament (LCL) Medial Collateral Ligament (MCL) Meniscus Pa
N.C. State - ACC - 200
Acc 200PName: _KEY_ Chapters 1 and 2 Take-home QuizProblem I: (9 pts) Managers are involved in three primary activities. Describe and given one example of each activity.Type of Activity: 1. Planning Activities Description: Involve the development of bo
N.C. State - ACC - 200
Acc 200PName: _KEY_ Chapters 1 and 2 Take-home QuizProblem II: Indicate whether each of the following statements is true (T) or false (F). (3 pts each) a. b. c. d. e. f. g. h. i. j. _T_ _F_ _F_ _T_ _T_ _F_ _F_ _F_ _T_ _T_ Managerial accounting is less f
N.C. State - ACC - 200
Acc 200PName: _ Lab Section #_ Section 2 Cash Basis of Accounting SOLUTIONTony S., a student at NCSU, decided to start his own computer repair business. Tony set up his business as a C-Corporation. Tony services his customers by going directly to their
N.C. State - ACC - 200
Acc 200PName: _ Lab Section #_ Section 3 Accrual Basis of Accounting SOLUTIONAssuming a company uses the accrual basis of accounting, (1) Indicate the financial statement in which each of the following account balances would be found, and (2) Calculate
N.C. State - ACC - 200
Acc 200PName: _ Lab Section #: _ Lab Instructors Name: _ Date: _ TAKE-HOME QUIZ Forms of Business Ownership and the Role of Accounting in BusinessPlease read these instructions before starting the quiz. These instructions apply to all take-home quizzes
N.C. State - ACC - 200
Acc 200PName: _ Lab Section #: _ Lab Instructors Name: _ Date: _ TAKE-HOME QUIZ Chapter 3Reminder - for all problems requiring calculations, you must show your work in the spaceprovided.PROBLEM I: (15 pts) Richardson Corporation plans to increase its
N.C. State - ACC - 200
Acc 200PName: _ Lab Section #: _ Lab Instructors Name: _ Date: _ TAKE-HOME QUIZ Chapter 4 (Job Order Costing)Students: Remember to show your calculations. Partial credit cannot be received without your work shown. PROBLEM I: (50 pts) ABC Inc. is a manuf
N.C. State - ACC - 200
Acc 200PName: _ Lab Section #: _ Lab Instructors Name: _ Date: _TAKE-HOME QUIZ Chapter 5Multiple Choice: (10 pts each) 1. Which of the following is a key feature of activity-based costing? A. B. C. D. Overhead costs are assigned on the basis of volume.
N.C. State - ACC - 200
Acc 200PName: _KEY_ Chapter 6 Take-home QuizProblem I: (20 pts) A. Prepare a traditional format income statement. Ignore taxes. (Check figure: Net income = \$232,000) Sales (25,000 units x \$20 per unit) Less: CGS [(25,000 units x \$8 per unit) + \$10,000)
N.C. State - ACC - 200
NC State Accounting ClinicThe accounting clinic is designed to enable students to check solutions to end of chapter materials and to get answers to simple questions regarding the textbook material. Clinic workers are not tutors, and any broad fundamental
N.C. State - ACC - 200
Acc 200PName: _ Lab Section #_Chapter 2 SOLUTIONProblem I: Indicate by circling either yes or no which costs would be classified as Manufacturing Overhead in a traditional manufacturing environment? a. b. c. d. e. Direct materials used Indirect materia
N.C. State - ACC - 200
Acc 200PName: _ Lab Section #_ Chapter 3 SOLUTIONTrusty Delivery Inc. would like to estimate the cost of operating its delivery trucks and has decided to use the high/low method. The high and low activity level months have been identified and the follow
N.C. State - ACC - 200
Ch 4 Job Costing, Process Costing, and Operations Costing1. Identify (with a ) each of the following costs as being either a product or period cost. If it is a product cost, further identify is as being either Direct Materials (DM), Direct Labor (DL), or
N.C. State - ACC - 200
Ch 5 Activity-Based Costing SOLUTION 1. Indicate whether the following statements are True or False: _T_ Traditional overhead allocation methods typically use one or two volume-based cost drivers to assign overhead costs to products. Traditional overhead
N.C. State - ACC - 200
N.C. State - ACC - 200
Ch 6 Cost-Volume-Profit Analysis and Variable Costing SOLUTION 1. Indicate whether the following statements are True (T) or False (F): _F_ _F_ Sales revenue minus fixed costs is known as the contribution margin. Sales Var. Costs Cost of goods sold will be
N.C. State - ACC - 200
Acc 200PName: _ Lab Section #_Chapter 7 SOLUTION Problem I: Heavenly Desserts makes special order cakes. Normally, each cake sells for \$70 each. Variable costs per cake are \$15 and fixed costs per cake are \$10 when 100 cakes are sold each month. The com
N.C. State - ACC - 200
Ch 7 Relevant Costs and Produce Planning Decisions SOLUTION 1 Indicate whether the following statements are True (T) or False (F): _F_ _F_ Special-order decisions are long-run decisions. If extra-capacity exists, a company should always agree to accept a
N.C. State - ACC - 200
Acc 200PName: _ Lab Section #_ Chapter 8 SOLUTION Present Value of an Annuity (n) period 6 8% 4.6229Present Value of a Lump Sum (n) period 6 8% 0.6302A. Needham Inc. is evaluating the purchase of a new machine with a cost of \$20,000. The estimated annu
N.C. State - ACC - 200
Ch 8 Long-Term (Capital Investment) Decisions SOLUTION 1. Indicate whether the following statements are True (T) or False (F): _T_ Long-term decisions involving either the purchase, lease, or expansion of long-term assets used in a business are called cap
N.C. State - ACC - 200
Ch 1 Introduction to Managerial Accounting SOLUTION 1. Indicate whether each of the following statements is more a characteristic of financial accounting or managerial accounting. Use the following key: F = financial, M = managerial _M_ _F_ _M_ _F_ _F_ _M
N.C. State - ACC - 200
Ch 2 Product Costing: Manufacturing Processes, Cost Terminology, and Cost Flows SOLUTION 1. Identify (with a ) each of the following costs as being either a product or period cost. If it is a product cost, further identify is as being either Direct Materi
N.C. State - ACC - 200
ACC 200 Problem Session (Managerial Accounting) Fall, 2010Teaching Assistant: Various Coordinator: Robin Thomas (robin_thomas@ncsu.edu) Problem Session Web Page: http:/moodle.wolfware.ncsu.edu/ (unity login required) Problem Session Objectives: The Acc 2
N.C. State - ACC - 200
MONDAYLABSCHEDULE FALL2010 Thefollowingsessionscheduleshowswhatisscheduledtooccurduringeachproblemsessionaswellastheassigned homeworkforthatday.Theassignedhomeworkforaparticularday(ex.8/23)shouldbedonepriortothenext mandatorysessionmeeting.Labexercisesare
N.C. State - ACC - 200
Request for Excused Absence ( ONLY)*The following form will be forwarded to your regular Acc 200 instructor at the end of the semester* Please note that the request does not automatically guarantee the excused absence. In addition, as the syllabus states
N.C. State - ACC - 200
Section 2 The Cash Basis of Accounting SOLUTION 1. Assuming the cash basis of accounting, put the following steps in the correct order beginning with what should be done first in the accounting cycle. Prepare a balance sheet. _5_ _2_ Compute account balan
N.C. State - ACC - 200
N.C. State - ACC - 200
Acc 200PName: _ Lab Section #_ Section 4 Introduction to Taxation SOLUTIONShauna is a single adult with no children. During 2009, she had the following information available: Her gross income was \$60,000. Deductions for adjusted gross income amounted to
N.C. State - ACC - 200
Section 4 Introduction to Taxation SOLUTION 1. Indicate (with a ) whether the following taxes are most likely to be progressive, proportional, or regressive. Progressive General sales tax FICA tax (after annual maximum has been met) Federal income tax Pro
N.C. State - ACC - 200
Chapter 9The Use of Budgets in Planning and Decision MakingConcept Questions(On Review Cards at end of book)1. (LO 1Concepts and purposes of budgets) Budgets by their nature are future oriented and involve the use of estimates. In business organization
N.C. State - ACC - 200
Chapter 10Variance AnalysisA Tool for Cost Control and Performance EvaluationConcept Questions(On Review Cards at end of book)1. (LO 1Ideal vs. practical standards) Ideal standards assume that every area of the production process is at peak efficiency.
N.C. State - ACC - 200
Acc 200Chapter 10 HandoutQuestion: What is a static budget? Is it fair to compare a static budget to actual results? See the following comparison. (Static Budget) @ 2,000 units \$200,000 18,400 60,000 12,000 30,000 \$79,600 vs. (Actual Results) @ 2,800 un
N.C. State - ACC - 200
Chapter 11Decentralization, Performance Evaluation, and the Balanced ScorecardConcept Questions(On Review Cards at end of book)1. (LO 1Advantages and disadvantages of decentralization) Benefits of decentralization include higher job satisfaction and on
N.C. State - ACC - 200
ACC 200-002 - MANAGERIAL ACCOUNTING Fall 2010Instructor: Class Schedule: Dr. Roby Sawyers TTH 4:30 5:45, Nelson 3400Class Moodle Page: http:/moodle.wolfware.ncsu.edu Cengage Now URL: http:/www.cengagebrain.com Class TAs: Ashley Waid aewaid@ncsu.edu Mich
N.C. State - BUS - 360
North Carolina State University College of Management Department of Business ManagementCOURSE SYLLABUSCourse Bus 360-001 Marketing Methods Term Fall 2010 NOTICE Read this syllabus carefully and follow all instructions fully Failure to do so may result i
N.C. State - BUS - 360
North Carolina State University College of Management BUS 360 Marketing Methods Lecture Summary Chapter 01 Overview of Marketing What Marketing Is Marketing is an organizational function and a set of processes for creating, capturing, communicating and de
N.C. State - BUS - 360
North Carolina State University College of Management BUS 360 Marketing Methods Lecture Summary Chapter 2 Developing Marketing Strategies Marketing Planning Process Divided into three phases: 1. Planning Phase 2. Implementation Phase 3. Control Phase Plan
N.C. State - BUS - 360
N.C. State - BUS - 360
North Carolina State University College of Management BUS 360 Marketing Methods Lecture Summary Chapter 6 Global Marketing Global Marketing Globalization - The process by which goods, services, capital, people, information and ideas flow across national b
McGill - ENG - MIME 310
McGillFaculty of EngineeringMIME 310 Engineering EconomyChapter 2 Principles of Accounting Accounting, the source of all financial information to the business world OutlineSection 1: How businesses keep financial records Basic Principles in Accounting
McGill - ENG - MIME 310
UChicago - FINANCE - 300
FIN300 Introduction to Managerial FinanceProfessor H. WangProblem Set #3Due: Monday, February 22, 2010Please make sure to write clearly the name of each member in the group. Please turn in your solutions at the beginning of the lecture on the due date
UChicago - FINANCE - 300
FIN300 Managerial Finance Spring 2010Professor H. WangProblem Set #5Due: Wednesday, March 17, 2010Please make sure to write clearly the name and ID# of each member in the group. Please turn in your solutions at the beginning of the lecture on the due
UChicago - FINANCE - 300
FIN300 Introduction to Managerial FinanceProfessor H. WangProblem Set #6Due: Friday, April 9, 2010Please make sure to write clearly the name AND ID # of each member in the group. Please turn in your solutions at the beginning of the lecture on the due
UChicago - FINANCE - 300
FIN300 Managerial FinanceProfessor H. WangProblem Set #7Due: Friday, 4/23, 2010Please make sure to write clearly the name of each member in the group. Please turn in your solutions at the beginning of the lecture on the due date. Late submissions or s
UChicago - FINANCE - 300
UChicago - FINANCE - 300
NAME (PRINT IN FULL ON LINES BELOW) (First Name)(Last Name)FIN 300Professor WangMidterm Quiz 2 Spring, 2010THERE ARE 10 PAGES IN THIS EXAM. PLEASE CHECK TO MAKE SURE THAT YOU HAVE ALL PAGES.You have 45 minutes to complete this examination. All answe
UChicago - FINANCE - 300
FIN300 Introduction to Corporate FinanceProfessor H. WangSolutions to Problem Set #21. a. b. c. \$1,000 / 1.17 = \$513.16 \$2,000 / 1.1 = \$1,818.18 \$500 / 1.18 = \$233.252.Amount (1.08 ) Amount = \$1,500,000 =27= \$1,500,000(1.08 )27\$1 ,500,000 = \$187
UChicago - FINANCE - 300
FIN300 Managerial FinanceProfessor H. WangSolutions to Problem Set #51.a. The prices of long-term bonds should fall. The price of any bond is the PV of the cash flows associated with the bond. As the interest rate increases, the PV of those cash flows
UChicago - FINANCE - 300
FIN300 Managerial FinanceProfessor H. WangSolutions to Problem Set #61 According to the Capital Asset Pricing Model: E(r) = rf + (EMRP) where E(r) rf EMRP = the expected return on the stock = the risk-free rate = the stocks beta = the expected market r
UChicago - FINANCE - 300
FIN300 Introduction to Managerial FinanceProfessor WangSolutions to Problem Set #81 a. Apply the CAPM to calculate the cost of equity.rS = RF + S ( R M RF) = 0.06 + 1.15 (0.1) = 0.175The cost of equity is 17.5%. b. To calculate the weighted average c
Georgia State - CHEM - 5656
General Lab Policies:1) Clothing: No contacts, No loose clothing, No shorts or short skirts, No open-toe shoes. 2) You must have safety glasses or safety goggles to enter lab. 3) You must have a bound lab notebook to enter lab. 4) All Data must be record
Hebrew University of Jerusalem - NN - nnn
A B C D E F G H YELLOW Name: AfifAqrabawi 1 RED 12 19 StudentNumber: 998039661 2 16 15 DataSet: 7 3 13 20 Question: Dobeesprefertovisityellowflowersorredflowers? 4 15 23 Therewillbeagreaternumberofvisitstotheyellowflowersthanthered 5 9 24 AlternativeHypot
Berkeley - D - 23213
10/26/2010Todays lecture Threats to biodiversityAre we in a sixth mass extinction crisis? ESPM 2 Oct 26 2010 1. Extinction rates: past, present and future 2. What are the main causes of species endangerment? 3. What are the consequences of species th lo
Berkeley - D - 23213
2299PiedmontAvenue Berkeley,CA94720http:/InternationalOffice.berkeley.eduExternal Scholarships for International StudentsThefollowinglistofscholarshipinformationiscurrentasofMarch2009.PleasecontactBerkeley InternationalOfficeatInternationalOffice@berke