Course Hero

Register now to access 7 million high quality study materials (What's Course Hero?) Course Hero is the premier provider of high quality online educational resources. With millions of study documents, online tutors, digital flashcards and free courseware, Course Hero is helping students learn more efficiently and effectively. Whether you're interested in exploring new subjects or mastering key topics for your next exam, Course Hero has the tools you need to achieve your goals.

9 Pages

wd 19-16

Course: FINANCE Excel, Spring 2010
School: City College of San...
Rating:
 
 
 
 
 

Word Count: 234

Document Preview

Summary Current Scenario Values: Current Prices Reduced Prices Increased Prices This scenario shows This scenario shows This scenario shows sales at current sales at reuced sales at higher prices prices prices Modified by Wilfredo De Leon on 5/13/2007 Changing Cells: Vanilla $12.95 $12.95 Chocolate $12.95 $12.95 Strawberry $13.50 $13.50 Chocolate_Chip $14.95 $14.95 Turtle $16.95 $16.95 Result Cells: $F$14...

Register Now
Search

Unformatted Document Excerpt

Coursehero >> California >> City College of San Francisco >> FINANCE Excel

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.
Summary Current Scenario Values: Current Prices Reduced Prices Increased Prices This scenario shows This scenario shows This scenario shows sales at current sales at reuced sales at higher prices prices prices Modified by Wilfredo De Leon on 5/13/2007 Changing Cells: Vanilla $12.95 $12.95 Chocolate $12.95 $12.95 Strawberry $13.50 $13.50 Chocolate_Chip $14.95 $14.95 Turtle $16.95 $16.95 Result Cells: $F$14 $705,775.00 $705,775.00 $F$15 764,050.00 764,050.00 $F$16 637,875.00 637,875.00 $F$17 911,950.00 911,950.00 $F$18 957,675.00 957,675.00 Notes: Current Values column represents values of changing cells at time Scenario Summary Report was created. Changing cells for each scenario are highlighted in gray. $10.95 $10.95 $12.50 $13.50 $15.00 $596,775.00 646,050.00 590,625.00 823,500.00 847,500.00 $13.95 $13.95 $14.50 $17.50 $18.00 $760,275.00 823,050.00 685,125.00 1,067,500.00 1,017,000.00 Wilfredo De Leon 112e97eb8eb505345e48406bb94457da9aa5244f.xls Scenario Summary 10/30/2010 Projected Sales of Chocolate Chip Pies 20,000 18,000 16,000 14,000 12,000 10,000 Row 9 Linear Regression for Row 9 8,000 6,000 4,000 2,000 - 1 2 3 4 Scenario Summary Solver 1 Solver 2 Changing Cells: $B$6 11,819 12,000 $C$6 16,319 16,638 $D$6 16,819 16,000 $E$6 16,819 17,138 Result Cells: $B$14 $153,056.25 $155,400.00 $C$14 $211,331.25 $215,462.50 $D$14 $217,806.25 $207,200.00 $E$14 $217,806.25 $221,937.50 $F$14 $800,000.00 $800,000.00 Notes: Current Values column represents of values changing cells at time Scenario Summary Report was created. Changing cells for each scenario are highlighted in gray. Wilfredo De Leon 112e97eb8eb505345e48406bb94457da9aa5244f.xls Scenario Summary 2 10/30/2010 Klassy Kow Ice Cream, Inc. Ice Cream Pie Sales Consolidated Report Product Sales Flavors Vanilla Chocolate Strawberry Chocolate Chip Turtle Total Dollar Sales Flavors Vanilla Chocolate Strawberry Chocolate Chip Turtle Total Vanilla Chocolate Strawberry Chocolate Chip Turtle Q1 $129,500.00 155,400.00 128,250.00 201,825.00 203,400.00 $818,375.00 Pie Prices $12.95 $12.95 $13.50 $14.95 $16.95 Q2 $187,775.00 168,350.00 199,125.00 179,400.00 194,925.00 $929,575.00 Q3 $194,250.00 207,200.00 168,750.00 149,500.00 305,100.00 $1,024,800.00 Q4 $194,250.00 233,100.00 141,750.00 269,100.00 254,250.00 $1,092,450.00 Total $705,775.00 764,050.00 637,875.00 799,825.00 957,675.00 $3,865,200.00 Q1 10,000 12,000 9,500 13,500 12,000 57,000 Q2 14,500 13,000 14,750 12,000 11,500 65,750 Q3 15,000 16,000 12,500 10,000 18,000 71,500 Q4 15,000 18,000 10,500 18,000 15,000 76,500 Total 54,500 59,000 47,250 53,500 56,500 270,750 Wilfredo De Leon 112e97eb8eb505345e48406bb94457da9aa5244f.xls PieSales 10/30/2010 Current Prices 12.95 12.95 13.5 14.95 16.95 Page 5 Reduced Prices 10.95 10.95 12.5 13.5 15 Page 6 Increased Prices 13.95 13.95 14.5 17.5 18 Page 7 Solver 1 11819.02 16319.02 16819.02 16819.02 Page 8 Solver 2 12000 16638.03 16000 17138.03 Page 9
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:

City College of San Francisco - FINANCE - Excel
Scenario SummaryCurrent Values: Modest SalesAssumes modest salesBest SalesAssumes high salesWorst SalesAssumes low salesChanging Cells: Oct 12,000 12,000 18,000 9,000 Nov 13,000 13,000 20,000 10,000 Dec 12,500 12,500 19,000 9,500 Result Cells: $B$5
City College of San Francisco - FINANCE - Excel
Scenario SummaryCurrent Values: Modest SalesAssumes average sales.Best SalesAssumes high sales.Worst SalesAssumes low sales.Changing Cells: Oct 23,000 10,500 23,000 Nov 24,000 10,000 24,000 Dec 25,000 9,000 25,000 Result Cells: $B$5 $50,370.00 $22,
City College of San Francisco - FINANCE - Excel
Klassy Kow Ice Cream, Inc. Employee Credit Union Christmas SpecialsCar Loan Number of payback years Total number of payments Loan amount Interest rate for loan Savings Plan 4 Number of savings years 48 Total number of deposits $(15,406) Deposit amount 4.
City College of San Francisco - FINANCE - Excel
Scenario SummaryCurrent Values: GrowthRateChanging Cells: $G$4 7.92% 1.50% Result Cells: $G$16 $4,000,000 $3,408,341 Notes: Current Values column represents values of changing cells at time Scenario Summary Report was created. Changing cells for each sc
City College of San Francisco - FINANCE - Excel
Scenario SummaryCurrent Values: 1%Multiplier 3%Ultiplier 2%MultiplierChanging Cells: ExtraCakes 25 50 17 Result Cells: $D$13 $720.38 $678.00 $715.67 Notes: Current Values column represents values of changing cells at time Scenario Summary Report was cre
City College of San Francisco - FINANCE - Excel
Soda Price AnalysisSelling Prices 0 0 0 $1.19 $238.00 $267.75 $357.00 $1.29 $258.00 $290.25 $387.00 $1.39 $278.00 $312.75 $417.00 $1.49 $298.00 $335.25 $447.00 $1.59 $318.00 $357.75 $477.00 $1.69 Number Sold $338.00 200 $380.25 225 $507.00 300Prices and
City College of San Francisco - FINANCE - Excel
Soda Count Flavor Size Chocolate Date Large Medium 11-Apr 1 1 10-Apr 2 9-Apr 8-Apr 1 6-Apr 5-Apr 4-Apr 1 2-Apr 1 1-Apr Grand Total 4 3Small 1 1 1Strawberry LargeVanilla Medium Small Large 1 1 1 1 1 1 Medium 1 1 SmallGrand Total 3 4 2 3 2 1 2 4 1 221
City College of San Francisco - FINANCE - Excel
Sales Rep Commission Comparison0 5.0% $1,000 5.50% $1,100 6.0% $1,200 6.50% $1,300 7.0% $1,400 7.50% Dollar Sales $1,500 $20,000Sales Versus Commission 0 5.0% 5.50% $20,000 $1,000 $1,100 $25,000 $1,250 $1,375 $30,000 $1,500 $1,650 $35,000 $1,750 $1,925
Capilano - PHYS - 214
4. (a) VB VA = U/q = W/(e) = (3.94 1019 J)/(1.60 1019 C) = 2.46 V. (b) VC VA = VB VA = 2.46 V. (c) VC VB = 0 (Since C and B are on the same equipotential line).
SFT - BUSINESS A - 45
One Member Limited Liability CompanyContributio n capital Assignment Profit distribution Membersh ip L iabilityWhen to contribute Proof of contributionFlowchartOrganizati onlegal representati ve D irector Who can be? Membershi p requiremen tBoard of
UWO - PHILOSOP - 2074
Syllabus:BusinessEthics(Philosophy2074)Whatisthenatureofmoralreasoning? 1.AmartyaSen,DoesBusinessEthicsMakeEconomicSense? HeatherSalazar,KantianBusinessEthics DavidMeeler,Utilitarianism Docorporationshavesocialresponsibilities? 2.MiltonFriedman,TheSocial
Universitas Padjadjaran - PHYSICS - 1820392838
III. Conclusion Through the use of Atwoods machine, we were able to test Newtons second law. By measuring the acceleration of the masses tested with Atwoods machine, we were able to calculate a value for the acceleration of gravity. While our data is not
Copiah-Lincoln - PHY - 225
6. (a) E = F e = ( 3.9 1015 N ) (1.60 1019 C ) = 2.4 104 N C = 2.4 104 V/m.(b) V = Es = 2.4 104 N C 012 m = 2.9 103 V. .chbg
Cogswell Poly - PHYS - 221
7. (a) The work done by the electric field isW = q0 E ds =i fq0 2 0d0dz =q0d (1.60 1019 C)(5.80 1012 C/m 2 )(0.0356 m) = 2 0 2(8.85 1012 C2 /N m 2 )= 1.87 1021 J. (b) Since V V0 = W/q0 = z/20, with V0 set to be zero on the sheet, the electric pote
Capitol College - PHY - 415
9. We connect A to the origin with a line along the y axis, along which there is no change of potential (Eq. 24-18: E ds = 0 ). Then, we connect the origin to B with a line along the x axis, along which the change in potential isV = zzx=40E ds = 4.0
Franklin IN - PHY - 520
10. In the inside region between the plates, the individual fields (given by Eq. 24-13) are in the same direction ( i ): 50 109 C/m 2 25 109 C/m 2 + Ein = i = (4.2 103 N/C)i . 12 2 2 12 2 2 2(8.85 10 C /N m ) 2(8.85 10 C /N m ) In the outside region whe
Mississippi Delta Community College - ASXX - 254
11. (a) The potential as a function of r is V ( r ) = V ( 0 ) E ( r )dr = 0 r r00qr 2 dr = 4 0 R 3 8 0 R 3 qr=(8.99 109 N m 2 C 2 )(3.50 1015 C)(0.0145 m) 2 = 2.68 104 V. 3 2(0.0231 m)(b) Since V = V(0) V(R) = q/80R, we have V ( R) = q 8 0 R = (8.9
Piedmont - CHEM - 125
12. (a) The potential difference is VA VB = q 4 0 rA 1 1 = (1.0 106 C ) ( 8.99 109 N m 2 C2 ) 4 0 rB 2.0 m 1.0 m q= 4.5 103 V. (b) Since V(r) depends only on the magnitude of r , the result is unchanged.
ITT Tech Pittsburgh - PHYS - 198
13. (a) The charge on the sphere isq = 4 0 VR =(200 V)(0.15 m) = 3.3 109 C. 9 2 2 8.99 10 N m C(b) The (uniform) surface charge density (charge divided by the area of the sphere) is=q 3.3 10 9 C = = 12 10 8 C / m 2 . . 2 2 4 R 4 015 m .bg
ITT Tech Pittsburgh - PHY - 248
14. The charge isq = 4 0 RV =(10m) (1.0V) 8.99 10 N m92/C2= 1.1109 C.
Hudson VCC - PHYS - 282
15. A charge 5q is a distance 2d from P, a charge 5q is a distance d from P, and two charges +5q are each a distance d from P, so the electric potential at P isq (8.99 109 N m 2 C2 )(5.00 1015 C) 1 1 1 1 V= + = = 4 0 2d d d d 8 0 d 2(4.00 102 m) q= 5.62
Hudson VCC - PHYS - 219
17. First, we observe that V (x) cannot be equal to zero for x > d. In fact V (x) is always negative for x > d. Now we consider the two remaining regions on the x axis: x < 0 and 0 < x < d. (a) For 0 < x < d we have d1 = x and d2 = d x. LetV ( x) = kFG
Duquesne - PHYS - 264
16. Since according to the problem statement there is a point in between the two charges on the x axis where the net electric field is zero, the fields at that point due to q1 and q2 must be directed opposite to each other. This means that q1 and q2 must
East MS CC - PHYS - 361
18. In applying Eq. 24-27, we are assuming V 0 as r . All corner particles are equidistant from the center, and since their total charge is 2q1 3q1+ 2 q1 q1 = 0, then their contribution to Eq. 24-27 vanishes. The net potential is due, then, to the two +4q
Cogswell Poly - PHY - 287
19. (a) The electric potential V at the surface of the drop, the charge q on the drop, and the radius R of the drop are related by V = q/40R. Thus8.99 10 9 N m 2 / C 2 30 10 12 C q R= = = 5.4 10 4 m. 4 0V 500 V (b) After the drops combine the total volum
Mississippi Gulf Coast Community College - PHY - 262
20. When the charge q2 is infinitely far away, the potential at the origin is due only to the charge q1 : q1 = 5.76 107 V. V1 = 4 0 d Thus, q1/d = 6.41 1017 C/m. Next, we note that when q2 is located at x = 0.080 m, the net potential vanishes (V1 + V2 = 0
Caldwell College - PHYS - 232
21. We use Eq. 24-20: V=9 2 2 30 p ( 8.99 10 N m C ) (1.47 3.34 10 C m ) = = 1.63 105 V. 2 2 9 4 0 r ( 52.0 10 m )1
Ludwig Maximilians Universität - PH - 282
22. From Eq. 24-30 and Eq. 24-14, we have (for i = 0) p cos p cos i Wa = qV = e 2 4 0 r 2 4 0 r ep cos cos 1) = 2( 4 0 rwith r = 20 109 m. For = 180 the graph indicates Wa = 4.0 1030 J, from which we can determine p. The magnitude of the dipole moment i
Daniel Webster - CHEM - 212
23. (a) All the charge is the same distance R from C, so the electric potential at C is 5Q1 1 Q1 6Q1 5(8.99 109 N m 2 C2 )(4.20 1012 C) = = 2.30 V, V= = 4 0 R R 4 0 R 8.20 102 m where the zero was taken to be at infinity. (b) All the charge is the same di
Carson-Newman - PHY - 315
24. The potential is VP = 1 4 0 dq 1 Q (8.99 109 N m 2 C2 )(25.6 1012 C) = dq = = rod R 4 0 R rod 4 0 R 3.71102 m= 6.20 V. We note that the result is exactly what one would expect for a point-charge Q at a distance R. This coincidence is due, in part, to
American Dubai - PHYS - 122
25. (a) From Eq. 24-35, we find the potential to be V =2 L / 2 + ( L2 / 4) + d 2 ln 4 0 d (0.06 m / 2) + (0.06 m) 2 / 4 + (0.08 m) 2 = 2(8.99 109 N m 2 C2 )(3.68 1012 C/m) ln 0.08 m = 2.43102 V. (b) The potential at P is V = 0 due to superposition.
The Petroleum Institute - PHYS - 241
26. Using Gauss law, q = = +495.8 nC. Consequently, q (8.99 109 N m 2 C2 )(4.958 107 C) V= = = 3.71104 V. 4 0 r 0.120 m
Claflin - PHY - 321
28. The dipole potential is given by Eq. 24-30 (with = 90 in this case) V= p cos p cos 90 = =0 4 0 r 2 4 0 r 2since cos(90) = 0 . The potential due to the short arc is q1 / 4 0 r1 and that caused by the long arc is q2 / 4 0 r2 . Since q1 = +2 C, r1 = 4.0
Andrew Jackson - PHY - 253
27. Since the charge distribution on the arc is equidistant from the point where V is evaluated, its contribution is identical to that of a point charge at that distance. We assume V 0 as r and apply Eq. 24-27:V= 1 +Q1 1 +4Q1 1 2Q1 1 Q1 + + = 4 0 R 4 2 R
Claflin - PHYS - 201
29. The disk is uniformly charged. This means that when the full disk is present each quadrant contributes equally to the electric potential at P, so the potential at P due to a single quadrant is one-fourth the potential due to the entire disk. First fin
Copiah-Lincoln - PHYS - 202
10. In the inside region between the plates, the individual fields (given by Eq. 24-13) are in the same direction ( i ): 50 109 C/m 2 25 109 C/m 2 + Ein = i = (4.2 103 N/C)i . 12 2 2 12 2 2 2(8.85 10 C /N m ) 2(8.85 10 C /N m ) In the outside region whe
Universitas Padjadjaran - PHYSICS - 1820392838
(Newton's Second Law and the Conservation of Energy)OBJECTIVE: To study the relation of masses and accelerations. METHOD: Consider the Atwood machine shown in Fig. 1. A pulley is mounted on a support a certain distance above the floor. A string with loop
Universitas Padjadjaran - PHYSICS - 1820392838
CalorimetryHeat Capacity of the CalorimeterConceptsIn calorimetry it is often desirable to know the heat capacity of the calorimeter itself rather than the heat capacity of the entire calorimeter system (calorimeter and water). The heat (q) released by
Sacred Heart - ACCT - 1001
Introduction and the IAS FrameworkWiecek and YoungIFRS PrimerChapter 1Chapter Overview Introductionand the Framework The U.S. experience to date Looking ahead Measurement model End-of-chapter practice2Introduction and the IAS FrameworkAcommon se
Sacred Heart - ACCT - 1001
Financial Statements IAS 1Wiecek and YoungIFRS PrimerChapter 2Related Standards FAS130 Reporting Comprehensive Income2Related Standards IFRS5 Non-current Assets Held for Sale and Discontinued Operations IFRS 7 Financial Instruments: Disclosures
Sacred Heart - ACCT - 1001
Statement of Cash Flows IAS 7Wiecek and YoungIFRS PrimerChapter 3Statement of Cash Flows Related IASstandards7 Current GAAP comparisons Looking ahead End-of-chapter practice2Related Standards FAS95 Statement of cash flows FAS 102 Statement of c
Sacred Heart - ACCT - 1001
Non-current Assets Held for Sale and Discontinued Operations: IFRS 5Wiecek and YoungIFRS PrimerChapter 4Non-current Assets Held for Sale and Discontinued Operations Related IFRSstandards5 Current GAAP comparisons IFRS financial statement disclosure
Sacred Heart - ACCT - 1001
Provisions, Contingent Liabilities and Contingent Assets: IAS 37Wiecek and YoungIFRS PrimerChapter 5Provisions, Contingent Liabilities and Contingent Assets Related IASstandards37 Current GAAP comparisons Looking ahead End-of-chapter practice2Rel
Sacred Heart - ACCT - 1001
Revenue: IAS 18Wiecek and YoungIFRS PrimerChapter 6Revenue Related IASstandards18 Current GAAP comparisons IFRS financial statement disclosures Looking ahead End-of-chapter practice2Related Standards SAB 104 Revenue Recognition SOP 81-1 Acc
Sacred Heart - ACCT - 1001
Inventories: IAS 2Wiecek and YoungIFRS PrimerChapter 7Inventories Related IASstandards2 Current GAAP comparisons IFRS financial statement disclosures Looking ahead End-of-chapter practice2Related Standards FAS151 Inventory costsan amendment of
Sacred Heart - ACCT - 1001
Construction Contracts: IAS 11Wiecek and YoungIFRS PrimerChapter 8Construction Contracts Related IASstandards11 Current GAAP comparisons IFRS financial statement disclosures Looking ahead End-of-chapter practice2Related Standards SAB104 Revenue
Sacred Heart - ACCT - 1001
Sacred Heart - ACCT - 1001
Property, Plant and Equipment: IAS 16Wiecek and YoungIFRS PrimerChapter 10Property, Plant and Equipment Related IASstandards16 Current GAAP comparisons IFRS financial statement examples Looking ahead End-of-chapter practice2Related StandardsFAS
Sacred Heart - ACCT - 1001
Investment Property: IAS 40Wiecek and YoungIFRS PrimerChapter 11Investment Property Related IASstandards40 Current GAAP comparisons IFRS financial statement examples Looking ahead End-of-chapter practice2Related Standards FAS153 Exchanges of no
Sacred Heart - ACCT - 1001
Exploration for and Evaluation of Mineral Resources: IFRS 6Wiecek and YoungIFRS PrimerChapter 12Exploration for and Evaluation of Mineral Resources Related IFRSstandards6 Current GAAP comparisons IFRS financial statement disclosures Looking ahead E
Sacred Heart - ACCT - 1001
Borrowing Costs: IAS 23Wiecek and YoungIFRS PrimerChapter 13Borrowing Costs Related IASstandards23 Current GAAP comparisons IFRS financial statement disclosures Looking ahead End-of-chapter practice2Related StandardsFAS 34 Capitalization of inte
WPI - MBA - FIN 500
Week1nIntroduction to Financeq q qWhat is Corporate Finance? The Corporate Firm Goals of the Corporate Firm Future Value (FV) and Compounding Present Value (PV) and Discounting The Net Present Value Rule PV with Repeated Payments: Some Simplifications
Ill. Chicago - MBA - Leadership
Different Types Karaoke in Asia and AmericaFeatures of Each KTV Type -Taiwan and Asia FeaturesType FeaturePlace Private Rooms Chain Store Coin Operated Karaoke Public/ open space Standalone coin karaoke machine So so Individual Owned VariesEquipmentH
Ill. Chicago - MBA - 520
University of Illinois At Chicago Microeconomics for Business Decisions (ECON520) Quiz #1 (Fall 2010) Answer Key 1. (4 pts.) In much of the U.S., homeowners choose to heat their houses with either natural gas or home heating oil. Which of the following co
Ill. Chicago - MBA - 520
University of Illinois At Chicago Microeconomics for Business Decisions (ECON520) Quiz #2 (Fall 2010) Answer Key 1. (4 pts.) The cross-price elasticity of demand between two products that are complements will be: A. PositiveB. NegativeC. Zero D. Positiv
Ill. Chicago - MBA - 520
University of Illinois At Chicago Microeconomics for Business Decisions (ECON520) Quiz #3 (Fall 2010) Answer Key 1. (5 pts.) Which of the following factor inputs are variable in the long run? A. Labor B. Plant size C. Capital and equipmentD. All of the a
Ill. Chicago - MBA - 520
University of Illinois At Chicago Microeconomics for Business Decisions (ECON520) Quiz #4 (Fall 2010) Answer Key 1. (8 pts.) If a perfectly competitive seller can increase its profits or minimize its losses by increasing output, then it must be the case t
Ill. Chicago - MBA - 520
Market Economy The interaction of individual choices subject to communitywide values enforced by decisions of governmental units Outcomes found in a market economy that result from the interaction of individual choices:Mutual exchange (or trade) leads to
Ill. Chicago - MBA - 520
Supply and Demand Model Defined a model of market behavior Market a collection of buyers and sellers of a product or service Geographic boundary Product or service boundary Who determines the price at which a product or service is bought and sold? Few sel
Ill. Chicago - MBA - 520
Relevant time frames: short-run and long-run Short-run: At least one input cannot be changed there is at least one fixed input factor of production As long as this is the case, as long as one input is not allowed to change, the relevant time frame is defi
Ill. Chicago - MBA - 520
Profit Maximizing Decision Guidelines How Much To Produce (Step 1): Suppose a seller increases the amount produced and that while doing so MR > MC, should the seller continue increase output? Why? Instead, suppose that the result from increasing the amoun