SEVERAL ACCOUNTING TOPICS, SPREADSHEET PROJECT.
INTRODUCTION Task 1: Yellow Leaf For this task, you will be analyzing various business transactions for a merchandising company called Yellow Leaf Fashion Inc. using the attached “Yellow Leaf Scenario.” You will prepare financial statements, including a balance sheet, income statement, and a statement of cash flows in accordance with GAAP. You will also assess the performance and financial position of the company. REQUIREMENTS Your submission must be your original work. No more than a combined total of 30% of the submission and no more than a 10% match to any one individual source can be directly quoted or closely paraphrased from sources, even if cited correctly. An originality report is provided when you submit your task that can be used as a guide. You must use the rubric to direct the creation of your submission because it provides detailed criteria that will be used to evaluate your work. Each requirement below may be evaluated by more than one rubric aspect. The rubric aspect titles may contain hyperlinks to relevant portions of the course. Use the attached “Yellow Leaf Scenario” and “Yellow Leaf Workbook” to complete this task for 2014 data in accordance with GAAP. A. Prepare the adjusted trial balance in the attached “Yellow Leaf Workbook,” including the workpapers and the general journal adjusting entries. B. Prepare the multistep income statement for Yellow Leaf Fashion Inc. in the attached “Yellow Leaf Workbook.” 1. Prepare the vertical analysis of the income statement with revenue as a base in the attached “Yellow Leaf Workbook.” C. Prepare the schedule for income taxes in the attached “Yellow Leaf Workbook.” D. Prepare the statement of retained earnings for Yellow Leaf Fashion Inc. in the attached “Yellow Leaf Workbook.” E. Prepare the classified balance sheet for Yellow Leaf Fashion Inc. in the attached “Yellow Leaf Workbook.” 1. Prepare the vertical analysis of the balance sheet with total assets as a base in the attached “Yellow Leaf Workbook.” F. Prepare the statement of cash flows for Yellow Leaf Fashion Inc. in the attached “Yellow Leaf Workbook.” G. Complete the following calculations in the “Ratios” tab of the attached “Yellow Leaf Workbook”: 1. Calculate two financial ratios to assess liquidity. 2. Calculate two financial ratios to assess activity. 3. Calculate two financial ratios to assess profitability. 4. Calculate two financial ratios to assess coverage. Note: You are only responsible for calculating two ratios within each category, even if a category contains more than two options. H. Prepare a report (suggested length of 6–8 pages) that analyzes the financial position and performance of Yellow Leaf Fashion Inc. by doing the following: 1. Explain what each of the two liquidity ratios calculated in part G1 indicates about the company’s financial position and performance. 2. Explain what each of the two activity ratios calculated in part G2 indicates about the company’s financial position and performance. 3. Explain what each of the two profitability ratios calculated in part G3 indicates about the company’s financial position and performance. 4. Explain what each of the two coverage ratios calculated in part G4 indicates about the company’s financial position and performance. 5. Evaluate the overall financial position and performance of the company by analyzing the combined effect of the calculated ratios from parts G1 through G4. 6. Describe two examples of financial areas specific to Yellow Leaf Fashion Inc. (e.g., particular accounts, individual accounting cycles, sections of the financial statement) that could be improved by the president and store managers to benefit the overall future financial position and performance of the company. a. Justify how improvement of each of the two example financial areas from part H6 will benefit the overall future financial position and performance of the company. I. Acknowledge sources, using APA-formatted in-text citations and references, for content that is quoted, paraphrased, or summarized. J. Demonstrate professional communication in the content and presentation of your submission. File Restrictions File name may contain only letters, numbers, spaces, and these symbols: ! – _ . * ′ ( ) File size limit: 200 MB File types allowed: doc, docx, rtf, xls, xlsx, ppt, pptx, odt, pdf, txt, qt, mov, mpg, avi, mp3, wav, mp4, wma, flv, asf, mpeg, wmv, m4v, svg, tif, tiff, jpeg, jpg, gif, png, zip, rar, tar, 7z