Premium Essay

Acct 370 Excel Project

In: Business and Management

Submitted By Laynebaril
Words 280
Pages 2
Acct 370 Excel Project

Click Link Below To Buy: http://hwcampus.com/shop/acct-370-excel-project/ PART 1:
Excel Project: Part V Instructions
Common Sized Statements and Trend Analysis on WALMART Stores Inc.
The tenth tab in your Financial Statement Analysis Template must be labeled Common Sized Balance SheetsThe eleventh tab in your Financial Statement Analysis Template must be labeled Common Sized Income StatementsThe twelfth tab in your Financial Statement Analysis Template must be labeled Horizontal Analysis of Balance SheetsThe thirteenth tab in your Financial Statement Analysis Template must be labeled Horizontal Analysis of Income StatementsInclude the latest three years for the common sized (vertical analysis) and horizontal analysis in Tabs 10–13.
*PLEASE WORK OFF OF ATTACHED EXCEL SPREADSHEET. When you open the document, you will see that there are already 9 tabs. Follow the instructions above. You will need to add 4 more tabs labeled appropriately with the above titles (see instructions). Please save the work and send it back to me.

PART 2: - Use WORD to complete this part
COMPARITIVE ANALYSIS REPORT. - WALMART
Examine common sized financial statements and ratios for the company you selected for the Excel project and two of its competitors. Write a 1000-word report in current APA format. Include the following in your report:
Compare and contrast the selected company, its competitors, and industry averages
Identify the selected company’s strengths and weaknesses and examine the implications for financial statement analysis and future projections.
Compute ROA and ROCE and examine the selected company’s financial leverage in light of its competitors and the industry average.
*The two competitive companies are TARGET and COSTCO.
*Attached is an excel worksheet if you need…...

Similar Documents

Premium Essay

Excel Project

...where we have the highest market share. We identified the sales rep and have commended her for the job well done, promoting her to Regional Sales Manager. Graphic Recommendation The Regional Sales Manager will work closely with our Global HR Director, leveraging her extensive years of experience to identify training needs across our organization. The scope is to improve our sales tactics by implementing initiatives to increase customer satisfaction, for both existing customers and for new ones. One immediate decision is to incorporate account managers to assist in our customer support centers, due to both constant complaints from our customer and also feedback obtained by our top sales rep. SELF ASSESSMENT From completing the Excel project, I learned … * How to manipulate Pivot Tables to obtain a specific data set. * Incorporate a Chart, choosing the type of values to show (percentages, numbers) * Apply formatting to a table...

Words: 489 - Pages: 2

Premium Essay

Bis155 - Excel Project Memo

...Northwind Traders to focus and ramp up their sales efforts in other countries. Graphic Recommendation It is recommended that a greater effort be made to increase sales in other markets if the company wishes to see a substantial increase in total revenue. Much like increasing quarterly sales, more marketing and advertising dollars need to be focused towards the European markets where the company is experiencing the slowest growth. Also, the best way to increase sales in those markets is by increasing the productivity of the sales representatives in those areas. SELF ASSESSMENT From completing the Excel project, I learned that there are multitudes of ways to interrupt data to see similar yet slightly different results. I now have a firm grasp on how pivot tables, charts, and subtotaling data and how complex they can be as these were the methods I chose to use in my project. I also learned how to use the Top/Bottom 5 on products within my pivot table. That was a new skill I learned by exploring the functions during my analysis....

Words: 904 - Pages: 4

Premium Essay

Acct 504 Course Project

...Statements Certain statements in this report, other than purely historical information, including estimates, projections, statements relating to our business plans, objectives and expected operating results, and the assumptions upon which those statements are based, are “forward-looking statements” within the meaning of the Private Securities Litigation Reform Act of 1995, Section 27A of the Securities Act of 1933 and Section 21E of the Securities Exchange Act of 1934. Forward-looking statements may appear throughout this report, including without limitation, the following sections: “Business,” “Management’s Discussion and Analysis,” and “Risk Factors.” These forward-looking statements generally are identified by the words “believe,” “project,” “expect,” “anticipate,” “estimate,” “intend,” “strategy,” “future,” “opportunity,” “plan,” “may,” “should,” “will,” “would,” “will be,” “will continue,” “will likely result,” and similar expressions. Forward-looking statements are based on current expectations and assumptions that are subject to risks and uncertainties which may cause actual results to differ materially from the forward-looking statements. A detailed discussion of risks and uncertainties that could cause actual results and events to differ materially from such forward-looking statements is included in the section titled “Risk Factors” (Part I, Item 1A of this Form 10-K). We undertake no obligation to update or revise publicly any forward-looking statements, whether as...

Words: 55776 - Pages: 224

Premium Essay

Course Project Acct 312

... Pg. 3 Financial Statement Breakdown Pg. 4 Conclusion Pg. 11 Financial Statements Pg. 12 Work Cited Pg. 16 INTRODUCTION Today this Financial Analysis will serve its purpose as a company which is one of the top leading in making computer manufacturing parts. I chose Apple for my course project mainly based on the fact that they release all their records to the public and they have excellent accounting practices. Apple Inc. is the popular name on almost 1 out of 5 people in the world, whom speak of it. It is by far one of the greatest company of our time and is a 500 Fortune Company and it currently holds little less than 10% of market share and leads in the market for manufacturing innovative technology. In this report you will find that Apple Inc’s Financial Reports are analyzed along with report on how computer manufacturing industry’s: trends, changes and innovations are affecting Apple Inc. Their paper work is easy to read and follow and based on their records they have an endless amount of revenue in the billions. Also,...

Words: 4067 - Pages: 17

Premium Essay

Acct 504 Course Project

...organization. It helps in comparing the performance, predicting the future, giving information to various stakeholders for decision making purposes. For example Profitability ratios like ROE and ROA helps in assessing the overall efficiency of the organization. Liquidity ratios like Current ratios help in knowing the short term solvency of the organization. Debt equity ratio help in finding the solvency of the business. These are: 1) Liquidity of the company 2) Profitability 3) Financial Risk and Solvency Microsoft's performance is better in most of the parameters such as profitability, Solvency & Current ratio. Oracle's performance is better in Inventory management, Receivabe Management and in Price to earning ratio. ( See excel file for details) Limitations of our analysis Financial measures will tell mainly the quantum of variation. Moreover financial measure is narrow in nature and may ignore the reasons behind the variation. Non financial measures will help managers in controlling, evaluating the management action more effectively. Non financial measures help in knowing the causes of the variations of the performance, unlike financial measures. References: | http://www.investopedia.com/articles/04/022504.asp http://www.investopedia.com/articles/04/031004.asp http://www.chartfilter.com/Efficiency-Ratios/asset-turnover.html Kimmel, P., Weygandt , J., & Kieso, D. (2011). Financial accounting. (6th ed.). Hoboken, NJ: John Wiley &......

Words: 719 - Pages: 3

Premium Essay

Acct 504 Final Project

...Financial Accounting 504 23-Jun-13 Professor Chung Oracle v Microsoft Final Course Project As noted in Wikipedia Oracle is headquartered in Redwood, California. It was founded in 1977 and is the world's third largest soft wear developer in sales. According to Yahoo Finance Oracle is a multi-faceted operation. Oracle provides a vast amount of services for the internet and computer. It provides cloud applications, IT consulting services, licenses middleware software which includes database and database management. It has 115,000 full time employees and is run by co-founder, CEO Larry Ellison who has been the only CEO of the company since it's inception. Also noted in Wikipedia he is the top paid CEO in the world. In 2013 Oracle currently has an operating cash flow of 13.72B with revenues of 37.15B which can be found in Yahoo Finance. Microsoft is a leading software company started by Bill Gates and Paul Allen in 1975. The company's headquarters is located in Redmond, Washington where like Oracle it develops, licenses, manufactures and support a wide range of computing sources, as documented in Wikipedia. Yahoo finance reports that in addition to licensing and manufacturing software over the globe it also designs hardware and has recently entered into the hardware industry with it's new tablet. It also has a entertainment division which is responsible for the manufacturing of Xbox360 gaming and consoles, Kinect for Xbox and video games among other products. It has a......

Words: 1504 - Pages: 7

Premium Essay

Acct 306 Project

...Acct 306 Case Project Summer 2014 On January 1, 2014, NeedMoreRoom, Inc. (NMR) entered into a lease agreement with WeRentSpace, Inc. (WRS) to rent space for its corporate offices. Based on the lease agreement, the lease is properly classified as an operating lease. The lease has a 10-year lease term (expires on December 31, 2023), and there is no option to renew nor is the ability to negotiate for renewal provided in the lease agreement. In addition, the lease agreement contains two provisions that require NMR to incur certain one-time costs at the end of the lease term. The provisions include the following: 1. “Lessor requires the lessee to perform general repairs and maintenance on the leased premises.” 2. “Lessor requires the lessee to remove all leasehold improvements such that the premises are reinstated to original condition.” At the beginning of the lease, NMR placed into service various leasehold improvements (e.g., temporary walls, HVAC, carpeting) that have useful lives of 10 years and no residual value. Required: a. How should NMR account for the first obligation noted above? b. How should NMR account for the second obligation noted above? Hint: The proper accounting treatment for each obligation is one of the following: -account for it as a minimum lease payment -account for it as an asset retirement obligation -account for it as an expense when it is incurred For each obligation, explain which of the three options is the proper accounting treatment. Also,......

Words: 932 - Pages: 4

Premium Essay

Acct-504 Final Project

...Financial Analysis of Hershey and Tootsie Roll Keller University ACCT-504 Instructor: Financial Analysis of Hershey and Tootsie Roll Introduction Tootsie Roll and Hershey are two similar companies with a similar product offering, but they operate on entirely different scales. In an effort to determine the better investment of the two companies we will utilize multiple financial analysis ratios to gauge the health of the respective companies in terms of liquidity (the ability to pay short-term liabilities and respond to opportunities), solvency (the long-term viability of the company) and profitability (the efficiency at which the can turn it’s resources into profits). However, the snapshot picture of health that a single years worth of financial statements provide is not enough. Below we have offered a horizontal analysis of the respective companies to show the change in their health from 2012 to 2013 and analyzed the two companies against each other to show why we recommend Hershey as the better investment. Liquidity and Solvency Current Ratio The current ratio is defined as the current assets divided by the current liabilities for a given period. This ratio is important because it helps measure a company’s ability to pay their current liabilities with their current assets. This shows helps determine the liquidity of the companies and their ability to respond to market......

Words: 1270 - Pages: 6

Premium Essay

Portfolio Project Acct 350

...Portfolio Project Portfolio Project **** Numbers in Millions throughout project **** a. Coca-Cola – “The Coca-Cola Company is the largest manufacturer, distributor and marketer of nonalcoholic beverage concentrates and syrups in the world “(Coca-Cola Company pg. 3). PepsiCO inc. – “We are the leading global snack and beverage company. We manufacture, market and sell a variety of salty, convenient, sweet and grain-based snacks, carbonated and non-carbonated beverages and foods” (PepsiCo inc. pg 32). b. In terms of beverage sales, The Coca-Cola Company has the dominant position. (Coca-Cola Company pg. 3) c. Coca-Cola Company – Total Assets 2006 = $29,963, Total Assets 2007 $43,269 (Coca-Cola Company pg. 69). 43,269 – 29,963 = $13,306 / 29,963 = 44.4% increase PepsiCo inc. – Total Assets 2006 - $29,930, Total Assets 2007 $34,628 (PepsiCo inc. pg 62). 34,628 -29,930 = 4,698 / 29,930 = 15.7% increase d. Pepsi Co. depreciation and amortization - $1,426 (PepsiCo inc. pg 57). Coca-Cola Company depreciation and amortization - $1,163 (Coca-Cola Company pg. 68). I believe that Pepsi Co. has a higher depreciation and amortization expense is due to the higher amount of plant, property and equipment. Pepsi Co. has $11,228 (PepsiCo inc. pg 58) while Coca-Cola has $8,493 (Coca-Cola Company pg. 67). e. Both companies use consolidated statements of income, which is a condensed version of a multi-step format. There area subtle differences in them,......

Words: 1295 - Pages: 6

Premium Essay

Acct 550 Project 1

...Company Name Balance Sheet As of DEC 31, 2012 Assets Current Assets Cash 42,485 Trading Securities FMV 28,250 Acct Receivable 165,824 Allowance for Doubtful Accounts (1,850) Net Realizable Value 163,974 Merchandise Inventory 499,493 Notes Receivable 23,000 Prepaid Expenses 16,252 Total Current Assets 773,454 Long Term Investments Investments in Warren Co. 87,500 Total Long Term Investment 87,500 Property, Plant and Equipment Land 125,000 Building 975,800 Accumulated Depreciation 341,200 Book Value 634,600 Total Property, Plant and Equipment 759,600 Intangible Assets Copyrights 105,000 Goodwill 100,000 Patents 125,000 Trademarks 80,000 Total Intangible Assets 410,000 Other Assets Deposits with Vendors 50,000 Total in Other Assets 50,000 Total Assets 2,080,554 Liabilities and Stockholders’ Equity Liabilities Current Liabilities Accounts Payable 197,532 Notes Payable to Banks 50,000 Salaries Payable 52,000 Income Tax Payable 62,520 Accrued Liabilities 9,500 Accrued Interest on Notes Payable 500 Rent......

Words: 345 - Pages: 2

Premium Essay

Acct 504 Course Project

...An Examination of LBJ Distribution Company Internal Controls Infrastructure Pre IPO ACCT 504: Financial Accounting Keller Graduate School of Management Professor Ganesh Pandit Date: February 9, 2014 Pre IPO Examination of LBJ Distribution Company Internal Controls Infrastructure Prepared for: President, LBJ Distribution Company Prepared By: Véron S.A. Lake Company: LLMCO Date: 9 February 2014 Table of Contents Introduction 3 Purpose 4 Legal Requirement of Internal Controls 5 IPO Readiness: Financial Internal Controls 5 IPO Readiness: Recommendations 6 Reliable Monthly Reports 6 Adequate Staffing of Financial Departments 6 Implementation of Audit Infrastructure 6 IPO Readiness: LBJ Internal Control Strengths 7 Pre-numbered Invoices 7 Recommendations: Indelible Ink Machine 7 IPO Readiness: LBJ Internal Control Weaknesses 7 Staffing: Accounting Department 7 Staffing: Human Resource Department 8 Recommendations: Handling Petty Cash 8 Recommendations: IT Department Physical Controls 9 Conclusion 9 Works Cited 10 Introduction A company going public today is different than what it was in the dot com era; this is because the IPO landscape has changed significantly in the last decade (KPMG, 2013). Recently experts has seen compression in the markets, decreasing or shifting mergers and acquisition activity, faltering businesses and more scrutiny on balance sheets and company cash as well as access to capital (KPMG, 2013;......

Words: 1816 - Pages: 8

Premium Essay

Acct 504 Course Project

...An Examination of LBJ Distribution Company Internal Controls Infrastructure Pre IPO ACCT 504: Financial Accounting Keller Graduate School of Management Professor Ganesh Pandit Date: February 9, 2014 Pre IPO Examination of LBJ Distribution Company Internal Controls Infrastructure Prepared for: President, LBJ Distribution Company Prepared By: Véron S.A. Lake Company: LLMCO Date: 9 February 2014 Table of Contents Introduction 3 Purpose 4 Legal Requirement of Internal Controls 5 IPO Readiness: Financial Internal Controls 5 IPO Readiness: Recommendations 6 Reliable Monthly Reports 6 Adequate Staffing of Financial Departments 6 Implementation of Audit Infrastructure 6 IPO Readiness: LBJ Internal Control Strengths 7 Pre-numbered Invoices 7 Recommendations: Indelible Ink Machine 7 IPO Readiness: LBJ Internal Control Weaknesses 7 Staffing: Accounting Department 7 Staffing: Human Resource Department 8 Recommendations: Handling Petty Cash 8 Recommendations: IT Department Physical Controls 9 Conclusion 9 Works Cited 10 Introduction A company going public today is different than what it was in the dot com era; this is because the IPO landscape has changed significantly in the last decade (KPMG, 2013). Recently experts has seen compression in the markets, decreasing or shifting mergers and acquisition activity, faltering businesses and more scrutiny on balance sheets and company cash as well as access to capital (KPMG, 2013;......

Words: 1816 - Pages: 8

Premium Essay

Ifsm 370 Project 2: White Paper Instructions

...IFSM 370 Project 2: White Paper Instructions Follow Below Link to Download Tutorial http://homeworklance.com/downloads/ifsm-370-project-2-white-paper-instructions/ For More Information Visit Our Website ( http://homeworklance.com/ ) Email us At: Support@homeworklance.com or lancehomework@gmail.com Introduction This is an individual project. Each student must complete a White Paper that proposes a telecommunications solution to address a communications problem for a business organization. The target audience will be the organization’s Chief Information Officer (CIO). The White Paper deliverable is an MS Word document. If you have never written a white paper, you should conduct some research and review sample white papers to understand the content and format associated with these professional documents. The completed White Paper deliverable is due by 11:59 PM Eastern Time on the due date shown in the Course Schedule. See the Additional Information section of the syllabus for the penalty for late or missed assignments and projects. The White Paper is valued at 12% of the course grade. Scenario Ullman, Manly, & Ulysses Corporation With 75,000 customers worldwide, 250 employees working in four locations in the United States and three European offices, and a catalog of more than 100,000 parts, Ullman, Manly & Ulysses Corporation (UMUC) relies on its network for its survival. In the past decade, UMUC has seen its business grow from just one......

Words: 1357 - Pages: 6

Premium Essay

Ifsm 370 Project 2: White Paper Instructions

...IFSM 370 Project 2: White Paper Instructions Follow Below Link to Download Tutorial http://homeworklance.com/downloads/ifsm-370-project-2-white-paper-instructions/ For More Information Visit Our Website ( http://homeworklance.com/ ) Email us At: Support@homeworklance.com or lancehomework@gmail.com Introduction This is an individual project. Each student must complete a White Paper that proposes a telecommunications solution to address a communications problem for a business organization. The target audience will be the organization’s Chief Information Officer (CIO). The White Paper deliverable is an MS Word document. If you have never written a white paper, you should conduct some research and review sample white papers to understand the content and format associated with these professional documents. The completed White Paper deliverable is due by 11:59 PM Eastern Time on the due date shown in the Course Schedule. See the Additional Information section of the syllabus for the penalty for late or missed assignments and projects. The White Paper is valued at 12% of the course grade. Scenario Ullman, Manly, & Ulysses Corporation With 75,000 customers worldwide, 250 employees working in four locations in the United States and three European offices, and a catalog of more than 100,000 parts, Ullman, Manly & Ulysses Corporation (UMUC) relies on its network for its survival. In the past decade, UMUC has seen its business grow from just one......

Words: 1357 - Pages: 6

Premium Essay

Acct 370 Excel Project

...Acct 370 Excel Project Click Link Below To Buy: http://hwcampus.com/shop/acct-370-excel-project/ PART 1: Excel Project: Part V Instructions Common Sized Statements and Trend Analysis on WALMART Stores Inc. The tenth tab in your Financial Statement Analysis Template must be labeled Common Sized Balance SheetsThe eleventh tab in your Financial Statement Analysis Template must be labeled Common Sized Income StatementsThe twelfth tab in your Financial Statement Analysis Template must be labeled Horizontal Analysis of Balance SheetsThe thirteenth tab in your Financial Statement Analysis Template must be labeled Horizontal Analysis of Income StatementsInclude the latest three years for the common sized (vertical analysis) and horizontal analysis in Tabs 10–13. *PLEASE WORK OFF OF ATTACHED EXCEL SPREADSHEET. When you open the document, you will see that there are already 9 tabs. Follow the instructions above. You will need to add 4 more tabs labeled appropriately with the above titles (see instructions). Please save the work and send it back to me. PART 2: - Use WORD to complete this part COMPARITIVE ANALYSIS REPORT. - WALMART Examine common sized financial statements and ratios for the company you selected for the Excel project and two of its competitors. Write a 1000-word report in current APA format. Include the following in your report: Compare and contrast the selected company, its competitors, and industry averages Identify the selected company’s......

Words: 280 - Pages: 2