Question 1
I need help with an accounting course project that is due on Sunday, October 16, 2011.,The attached document lists all that is needed to complete the required project. Thank you soooooo much!!!!!!,I just want to make sure that you receive the attached document I sent outlining the project requirements.,Just in case you have not received the attached document or is unable to open it for whatever reason, I have pasted it below. Course Project Financial Statement Analysis Project -- A Comparative Analysis of Oracle Corporation and Microsoft Corporation Here is the link for the financial statements for Oracle Corporation for the fiscal year ending 2007. First, select 2007 using the drop-down arrow labeled for Year on the right-hand side of the page, and then select Annual Reports using the drop-down arrow labeled Filing Type on the left-hand side of the page. You should select the 10k dated 6/29/2007 and choose to download in PDF, Word, or Excel format. Here is the link for the financial statements for Microsoft Corporation for the fiscal year ending 2007. You should select the Annual report dated 8/3/2007 and choose to download in Word or Excel format. A sample Project template is available for download in Doc Sharing. The sample project compares the ratio performance of Tootsie Roll and Hershey using the 2007 financial statements of Tootsie Roll and Hershey provided in Appendix A and Appendix B of your textbook. Description | Overall Requirements | Grade Information Description This course contains a course project where you will be required to submit one draft of the project at the end of Week 5 and the final completed project at the end of Week 7. Using the financial statements for Oracle Corporation and Microsoft Corporation, respectively, you will calculate and compare the financial ratios listed further down this document for the fiscal year ending 2007 and prepare your comments about the liquidity, solvency and profitability of the two companies based on your ratio calculations. The entire project will be graded by the instructor at the end of the final submission in week 7 and one grade will be assigned for the entire project. Overall Requirements For the Final Submission: Your final Excel workbook submission should contain the following. You cannot use any other software but Excel to complete this Project. 1. A completed worksheet title page tab which is really a cover sheet with your name, my name, the class name, and the date. 2. A completed worksheet profiles tab which contains a one paragraph description regarding each company with information about their history, what products they sell, where they are located etc. 3. All 18 ratios for each company with the supporting calculations and commentary on your worksheet ratio tab. Supporting calculations must be shown either as a formula or as text typed into a different cell. The ratios are listed further down this document. Your comments for each ratio should include more than just a definition of the ratio. You should focus on interpreting each ratio number for each company and support your comments with the numbers found in the ratios. 4. The Summary and Conclusions worksheet tab which is an overall comparison of how each company compares in terms of the major category of ratios (Liquidity, Profitability, and Solvency). 5. The Bibliography worksheet tab must contain at least your textbook as a reference. Any other information you use to profile the companies should also be cited as a reference. Required Ratios for Final Project Submission: 1. Earnings per Share 2. Current Ratio 3. Gross Profit Rate 4. Profit Margin Ratio 5. Inventory Turnover Ratio 6. Days in Inventory 7. Receivables Turnover Ratio 8. Average Collection Period 9. Asset Turnover Ratio 10. Return on Assets Ratio 11. Debt to Total Assets Ratio 12. Times Interest Earned Ratio 13. Payout ratio 14. Return on Common Stockholders' Equity Ratio 15. Free Cash Flow 16. Current Cash Debt Coverage Ratio 17. Cash Debt Coverage Ratio 18. Price/Earnings Ratio [For the purpose of this ratio, use the market price per share on June 1, 2007 for each company] The Excel files uploaded to the Dropbox should not include any unnecessary numbers or information (such as previous years' ratios, ratios that were not specifically asked for in the project, etc.). Please upload your final submission to the Dropbox by the end of Week 7. See Syllabus/"Due Dates for Assignments & Exams" for due date information. For the Draft: Create an Excel spreadsheet or use the Project template to show your computations for the first 12 ratios listed above. The more you can complete regarding the other requirements the closer you will be to completion when Week 7 arrives. Supporting calculations must be shown either as a formula or as text typed into a different cell. If you plan on creating your own spreadsheet, please follow the format provided in the Tootsie Roll and Hershey template file. Please upload your draft submission to the Dropbox by the end of Week 5. See Syllabus/"Due Dates for Assignments & Exams" for due date information. Other Helpful Information: If you feel uncomfortable with Excel, you can find many helpful references on Excel by performing a Google search. The Appendix to Chapter 13 contains ratio calculations and comparison comments related to Kellogg and General Mills so you will likely find this information helpful. Either APA or MLA style can be used to complete the references on your Bibliography tab. There are tutorials for APA and MLA style within the syllabus. Grade Information The entire project will be graded by the instructor at the end of the final submission in week 7 and one grade will be assigned for the entire project. The project will count for 18% of your overall course grade. Category Points % Description Documentation & Formatting 9 5% The report will be submitted in the form of an Excel Workbook, with each page (worksheet) of the workbook named appropriately. Please do not use any other software (such as MS Works or Lotus) to complete the project. A quality report will include a title worksheet tab, a worksheet tab for the profile of the two companies, a worksheet tab for the ratio calculations and comments, a worksheet tab for the Summary and Conclusion, proper citations if applicable, and a bibliography worksheet tab for the references. Organization & Cohesiveness 9 5% A quality report will include the content described above in the documentation and formatting section. The ratios should be listed in the same order in which they appear in the project information above. Editing 18 10% A quality report will be free of any spelling, punctuation, or grammatical errors. Sentences and paragraphs will be clear, concise, and factually correct. Ratios will be expressed as numbers or percentages, depending on what is appropriate, as is shown in the textbook. Note that not all ratios are shown as percentages. Two decimal places is sufficient for each of the ratios. Content 144 80% A quality report will have correct ratio calculations and accurate supporting commentary. Any assumptions, if made, should be spelled out clearly. Supporting calculations must be shown either as a formula or as text typed into a different cell. Total 180 100% A quality report will meet or exceed all of the above requirements. *****Also, I have re-attched the same file that states what is listed above for you to be able to legibly understand what is required. Sorry to be redundant but I want to make sure that you have and understand all that is required for a quality project to be completed.,Also, I have attached the Microsoft check figures to be able to check the work when computing the ratios. All three parts are listed, per the Professor.,Finally, I have atatched a project temmplate (sameple project) comparing two separate companies, Tootsie and Hershey. I hope ALL of the information that I have provided is beneficial.
Question 2
I need to make recommendations as to the type of sample to be used, the method of selecting the sample, and the sample size of the following 3 situations - can you please help me? 1. The manager of the appliance department of a local full-line department store chain is planning a major one-day nonprice promotion of food processors, supported by heavy advertising in the two local newspapers. The manager asks you to recommend a method of sampling customers coming into the department. The purpose is to assess the extent to which customers were drawn by the special advertisement, and the extent to which the advertisement in?uenced their intentions to buy. A pretest of the questionnaire indicates that it will take about 3 minutes to administer. The manager is especially interested in learning whether there are signi?cant differences in the response to the questionnaire among (a) males versus females, (b) gift buyers versus other buyers, and (c) age groups. 2. A major airline wants to run a preliminary study on the attitudes of university students toward air travel. The company?s research director already has submitted an interview plan and has estimated that, on average, each interview will require between an hour and an hour-and-a-half to administer. It is estimated that the cost of interviewing and interpreting the interview will be roughly $75.00 per respondent. 3. A small Caribbean island relies heavily on tourist income. There is a need to develop a study so that an estimate can be provided each month as to: a. The number of tourists b. The length of stay c. Their activities d. Their attitudes toward some programs and activities The plan is to conduct a short interview with each respondent and to leave with them a short questionnaire to be completed and mailed after returning home. Several sampling plans are being considered. One is to generate a random sample of hotel rooms and to interview each occupant. Another involves sampling every nth person that passes a predetermined point in the city. Still another is to sample departing planes and ships. About six planes and three ships depart each day. Design a sampling plan so that each month 500 tourists are obtained in the sample.
Question 3
Provide full documentation of the process used to reach the solution. Complete the Unit 3 problem spreadsheet template provided below and submit in the assignment area. (9.2). LL Incorporated?s currently outstanding 11% coupon bonds have a yield to maturity of 8%. LL believes it could issue new bonds at par that would provide a similar yield to maturity. I its marginal tax rate is 35%, what is LL?s after-tax cost of debt? Explain how cost of capital financing techniques affects the organization. (10.1). A project has an initial cost of $52,125, expected net cash inflows of $12,000 per year for 8 years, and cost of capital of 12%. What is the project?s NPV? (Hint, begin by constructing a time line). Explain how to use capital budgeting and relevant cash flow to compare investment alternatives. (15.3). Ethier Enterprises has an unlevered beta of 1.0. Ethier id financed with 50% debt and has a levered beta of 1.6. If the risk free rate is 5.5% and the market risk premium is 6%, how much is the additional premium that Ethier?s shareholders require to be compensated for financial risk? Explain how varying degrees of financial risk may command variations in shareholder return expectations. Please insert the correct formulas in order to reach the correct answers into the gray cells in the template.,A) After calculating the NPV and IRR for Machine A and Machine B, choose which one you would choose based on being the most profitable. B) Would an investor choose an investment with the highest NPV or IRR? Justify which one and why. C) Discuss capital rationing limits firms have and what, if anything they can do. D) Discuss the MIRR and its advantages/disadvantages. E) Discuss the WACC. Can you Please fill this out!
Question 4
PROCESS COSTING (QUICK EASY QUESTION) (TOOK ME ONLY 20 MINUTES TO DO) Albutte, Inc., which uses the weighted average method of process costing, has two departments: Production and Finishing. In the Finishing department, direct materials are added at the beginning of the process, and conversion costs are incurred evenly throughout the process. The Finishing department began December with 2,000 units in work-in-process inventory that were 40% complete and were valued at $10,000 ($8,000 in transferred-in costs, $500 in direct materials, and $1,500 in conversion costs). During December, the Finishing Department incurred $5,500 in direct materials costs and $12,500 in conversion costs. 18,000 units costing $72,000 in the Production department were transferred into Finishing during the month. 15,000 units were finished during December, 500 of which were spoiled (spoilage is normally 3% of good units). All unfinished units were 50% complete. Find the value of units completed and transferred out, ending work-in-process inventory, and the loss due to abnormal spoilage for the Finishing department. USE EXCEL TO ANSWER THIS. SHOW YOUR WORK BY INSERTING THE FORMULAS IN THE EXCEL WORKSHEET TO PRODUCE THE ANSWER. IF POSSIBLE I WOULD PREFER IF USER: dkhetan or USER: Asmalhotra or USER: Mmahajan or USER: rcbriones answered this question.
Question 5
Cynthia Brown 1/10/2011 10:51 am Unit 4 review due in 45 min. (I need by 11:45 am today) 1. Which of the following organizations would be most likely to use a job order costing system? (Points: 1) the loan department of a bank the check clearing department of a bank a manufacturer of processed cheese food a manufacturer of video cassette tapes 2. When job order costing is used, the primary focal point of cost accumulation is the ________. (Points: 1) department supervisor item job 3. Which of the following are drawbacks to applying actual overhead to production? (Points: 1) A delay occurs in assigning costs to jobs or products. Fluctuations in quantities produced during a period could cause varying per-unit charges for fixed overhead. Seasonality of overhead costs may cause distortions in job or product costs. all answers are correct 4. In a job order costing system, the dollar amount of the entry that debits Finished Goods Inventory and credits Work in Process Inventory is the sum of the costs charged to all jobs _______. (Points: 1) started in process during the period in process during the period completed and sold during the period completed during the period 5. Which of the following statements about job order cost sheets is true? (Points: 1) All job order cost sheets serve as the general ledger control account for Work in Process Inventory. Job order cost sheets can serve as subsidiary ledger information for both Work in Process Inventory and Finished Goods Inventory. If material requisition forms are used, job order cost sheets do not need to be maintained. Job order cost sheets show costs for direct material and direct labor, but not for manufacturing overhead since it is an applied amount. 6. The cost sheets for incomplete jobs at the end of the period comprise the subsidiary ledger for _______. (Points: 1) Finished Goods Inventory Raw Material Inventory Work in Process Inventory Supplies Inventory 7. The source document that records the amount of time an employee worked on a job and his/her pay rate is the _______. (Points: 1) job order cost sheet employee time sheet interoffice memo labor requisition form 8. Overhead is applied to jobs in a job order costing system _______. (Points: 1) at the end of a period as jobs are completed at the end of a period or as jobs are completed, whichever is earlier at the end of a period or as jobs are completed, whichever is later 9. Underapplied overhead resulting from unanticipated and immaterial price increases for overhead items should be written off by _______. (Points: 1) decreasing Cost of Goods Sold increasing Cost of Goods Sold decreasing Cost of Goods Sold, Work in Process Inventory, and Finished Goods Inventory increasing Cost of Goods Sold, Work in Process Inventory, and Finished Goods Inventory 10. Which of the following statements is false? (Points: 1) While the use of standard costing is acceptable for job order costing systems, actual cost records should still be maintained. It is normally more time-consuming for a company to use standard costs in a job order costing system. Standards can be used in a job order costing system, if the company usually produces items that are similar in nature. Standard costs may be used for material, labor, or both material and labor in a job order costing environment. 11. The trend in job order costing is to ________. (Points: 1) eliminate the data entry function for the accounting system automate the data collection and data entry functions use accounting software to change the focal point of the job order system create an Intranet to share information between competitors 12. The use of standard material or labor costs in job order costing _______. (Points: 1) is similar to the use of predetermined overhead rates in a normal costing system will keep actual costs of jobs from fluctuating due to changes in component costs is appropriate for any company making a units to customer specification all answers are correct 13. Knowing specific job costs enables managers to effectively perform which of the following tasks? (Points: 1) estimate costs of future jobs establish realistic job selling prices evaluate job performance all answers are correct 14. A unit that is rejected at a quality control inspection point, but that can be reworked and sold, is referred to as a _______. (Points: 1) spoiled unit scrap unit abnormal unit defective unit 15. In a job order costing system, the net cost of normal spoilage is equal to _______. (Points: 1) estimated disposal value plus the cost of spoiled work the cost of spoiled work minus estimated spoilage cost the units of spoiled work times the predetermined overhead rate the cost of spoiled work minus the estimated disposal value 16. The net cost of normal spoilage in a job order costing system in which spoilage is common to all jobs should be _______. (Points: 1) assigned directly to the jobs that caused the spoilage charged to manufacturing overhead during the period of the spoilage charged to a loss account during the period of the spoilage allocated only to jobs that are completed during the period 17. Quest Co. is a print shop that produces jobs to customer specifications. During January 20X6, Job #3051 was worked on and the following information is available: Direct material used $2,500 Direct labor hours worked 15 Machine time used 6 Direct labor rate per hour $7 Overhead application rate per hour of machine time $18 What was the total cost of Job #3051 for January? (Points: 1) $2,713 $2,770 $2,812 $3,052 18. Brown Corporation manufactures products on a job order basis. The job cost sheet for Job #656 shows the following for March: Direct material $5,000 Direct labor (100 hours @ $7.25) $725 Machine hours incurred 40 Predetermined overhead rate per machine hour $26 At the end of March, what total cost appears on the job cost sheet for Job #656? (Points: 1) $5,725 $5,765 $6,765 $8,325 19. At the end of the last fiscal year, Roberts Company had the following account balances: Overapplied overhead $ 6,000 Cost of Goods Sold $980,000 Work in Process Inventory $ 38,000 Finished Goods Inventory $ 82,000 If the most common treatment of assigning overapplied overhead were used, the final balance in Cost of Goods Sold is: (Points: 1) $974,000 $974,660 $985,340 $986,000 20. Strong Products has no Work in Process or Finished Goods inventories at the close of business on December 31, 20X4. The balances of Strong Products? accounts as of December 31, 20X4, are as follows: Cost of goods sold--unadjusted $2,040,000 Selling & administrative expenses 900,000 Sales 3,600,000 Manufacturing overhead control 700,000 Manufacturing overhead applied 648,000 Pretax income for 20X4 is: (Points: 1) $608,000 $660,000 $712,000 undeterminable from the information given
