23 Jun Identify and record the most current t
Identify and record the most current three years? sales (in dollars) for both companies using their financial statements. Be sure the financial statements come from the companys annual report. Do not use statements provided by third parties, like Yahoo Finance or others.
Using the data in question 1, predict both companies? sales activity for the next two to three years. Hint: use trend analysis (Chapter 13). If possible, compare your predictions to actual sales figures for those years.
Use Excel to compute profit margin for both companies for the two most recent years. Comment on your findings.
Requirements:
Divide the parts of this assignment equitably among your team members. Always make sure that at least two people compute any calculations and check each other?s work to make sure there are no errors. If your numbers are incorrect, your comments are going to be moot.
Include student names on the first page of the assignment for those who contributed. If a group member did not participate in the completion of the assignment, do not include his/her name.
Type the assignment question number, then the question, and then your response. Be sure all teammates read the documents and review that all components are included before submitting the assignment.
Make sure there are zero spelling/grammar errors.
Include the income statements (from the companies? websites) for the three years so I can check your answers. Copy/paste them in your Word document. Do not submit them separately. NO links!
Use a plagiarism checker (find a free one using Google) before you submit the assignment to ensure that no written work has been copied. Plagiarism will result in zero points for all teammates in the group.
Submit the assignment in Blackboard by clicking on the underlined Project 1 – Sales (right next to the paper/pencil/ruler icon) in this folder.
You will be attaching two documents for this assignment: a Word document and an Excel document. Do not combine them; in other words, dont write the answers to the questions in Excel and dont copy/paste your Excel results in the Word document. Keep them separate!
Late assignments are accepted no later than the day following the deadline and carry an automatic 20% penalty.
Project 2 – COGS
Use Excel to compute the ratios of cost of goods sold to total expenses (see formulas below) for both companies for their two most recent fiscal years.
COGS + Operating Expenses = Total Expenses
COGS/Total Expenses
Record answers as percentages, rounded to one decimal place. Remember to have at least two people compute these ratios and check each other?s work for accuracy.
Comment on the similarities and/or differences in the ratio results across both years between the two companies.
Which company has a higher ratio of costs, defined as COGS plus total operating expenses, to revenues?
{ (COGS + Operating Expenses)/Revenue}
Use the two most recent years? income statements. Use Excel to show your analysis computations (use formulas; don?t just type them in). Again, have at least two people work on this and check each other?s work.
How might the use of activity-based costing help the less competitive company become more competitive?
Requirements:
Divide the assignment equitably among your team members making sure that at least two members complete each section and then compare answers for possible errors and corrections.
Include student names on the first page of the assignment for those who contributed. If a group member did not participate in the completion of the assignment, do not include his/her name.
Type the assignment question number, then the question, and then your response. Be sure all teammates read the documents and review that all components are included before submitting the assignment.
Make sure there are zero spelling/grammar errors.
Submit the income statements for both companies (from their websites) for the two years so I can check your answers. Copy/paste them in your Word document. Do not submit them separately. NO links!
Use a plagiarism checker (find a free one using Google) before you submit the assignment to ensure that no written work has been copied. Plagiarism will result in zero points for all teammates in the group.
Submit the assignment in Blackboard by clicking on the underlined Project 2 – COGS (right next to the paper/pencil/ruler icon). You will be attaching two documents for this assignment: a Word document and an Excel document. Do not combine them; in other words, dont write the answers to the questions in Excel and dont copy/paste your Excel results in the Word document. Keep them separate!
Late assignments are accepted no later than the day following the deadline and carry an automatic 20% penalty.
Project 3 – Inventory
Identify the impact on operating cash flows (increase or decrease) for changes in inventory levels (increase or decrease) for both companies for each of the three most recent years. Use Excel for your analysis.
What impact would a JIT inventory system have on each company?s operating income? Link this answer to your response in question 1 above.
Our website has a team of professional writers who can help you write any of your homework. They will write your papers from scratch. We also have a team of editors just to make sure all papers are of HIGH QUALITY & PLAGIARISM FREE. To make an Order you only need to click Ask A Question and we will direct you to our Order Page at WriteDemy. Then fill Our Order Form with all your assignment instructions. Select your deadline and pay for your paper. You will get it few hours before your set deadline.
Fill in all the assignment paper details that are required in the order form with the standard information being the page count, deadline, academic level and type of paper. It is advisable to have this information at hand so that you can quickly fill in the necessary information needed in the form for the essay writer to be immediately assigned to your writing project. Make payment for the custom essay order to enable us to assign a suitable writer to your order. Payments are made through Paypal on a secured billing page. Finally, sit back and relax.
About Writedemy
We are a professional paper writing website. If you have searched a question and bumped into our website just know you are in the right place to get help in your coursework. We offer HIGH QUALITY & PLAGIARISM FREE Papers.
How It Works
To make an Order you only need to click on “Order Now” and we will direct you to our Order Page. Fill Our Order Form with all your assignment instructions. Select your deadline and pay for your paper. You will get it few hours before your set deadline.
Are there Discounts?
All new clients are eligible for 20% off in their first Order. Our payment method is safe and secure.