ACC 308 Final Project Workbook (1) (3)

.xlsx

School

Southern New Hampshire University *

*We aren’t endorsed by this school

Course

308

Subject

Accounting

Date

Apr 3, 2024

Type

xlsx

Pages

40

Uploaded by ChiefBarracudaPerson994 on coursehero.com

Southern New Hampshire University ACC 308 - Intermediate Accounting II Using the Peyton Approved financial data, create: Adjusting Entries Adjusted Trial Balance Revised Balance Sheet Revised Income Statement Note: This workbook contains instructions and financial information you will need to complete the Workbook portions of Milestones One and Two. For full instructions for the milestone and final project assignments, refer to the guidelines and rubric documents. You can use the links below to navigate from this HOME tab to additional instructions and the worksheets for each milestone. MILESTONE ONE (Due in Module Three) Milestone OneWorkbook Instructions 1. Trial Balance 2. Revised Financial Statements Using the trial balance and preliminary financial statements, prepare:
Revised Retained Earnings Statement Revised Statement of Cash Flows Current Ratio (Working Capital) Quick Ratio A/R Turnover Inventory Turnover Gross Margin Return on Sales Return on Equity Return on Assets 4. Management Analysis Brief 3. Ratio Analysis Note: Refer to the Final Project Scenario for Peyton's ratio formulas. Using the financial statements from 2015, 2016, and revised 2017, calculate the following ratios: Note: This part of the project is submitted as a separate Word document. Refer to the Milestone One Guidelines and Rubric document for submission guidelines. Your management analysis brief should explain financial information to management. Provide evidence from your accounting workbook to support your ideas where applicable. A. Assess the company’s financial health based on ratio analyses presented in the accounting workbook. B. Compare ratio analysis to trends in financial ratios over time for illustrating their impact, providing examples to support your claims. C. Summarize the effects of different compounding periods and interest rates on future value of money. D. Explain how alignment to relevant regulations and ethical reporting influenced your accounting practices and notes, providing examples to support your claims.
Using the given pro forma information, create: Pro Forma Income Statement Pro Forma Balance Sheet 2. Notes to the Financial Statements Your notes must contain the following: MILESTONE TWO (Due in Module Five) Milestone TwoWorkbook Instructions 1. Pro Forma Financial Statements Note: This part of the project is submitted as a separate Word document. Refer to the Milestone Two Guidelines and Rubric document for submission guidelines. A. Create appropriate notes as year-to-year documentation for managing depreciation, supplies, and inventory. B. Create appropriate notes for long-term debt.
3. Management Analysis Brief Note: This part of the project is submitted as a separate Word document. Refer to the Milestone Two Guidelines and Rubric document for submission guidelines. Your management analysis brief should explain financial information to management. Provide evidence from your accounting workbook to support your ideas where applicable. A. Discuss the impact of the pro forma financial statements for predicting ability to meet future expansion goals. B. Describe the implications of inventory costing, contingent liabilities, and revenue recognition. C. Identify potential issues in interpretation of financial information, providing examples to support your ideas.
FINAL PROJECT (Due in Module Seven) Note: The final project consists of corrected work from Milestone One and Milestone Two. Incorporate the feedback you received from your instructor.
ITEMS TO COMPLETE FOR MILESTONE ONE: GENERAL 1. TRIAL BALANCE 2. REVISED FINANCIAL STATEMENTS ReturnHOME INSTRUCTIONS FOR MILESTONE ONE (Due in Module Three) Note: Make sure to completely review the Milestone One Guidelines and Rubric document. Use the data from this milestone and begin working on your final project, due in Module Seven. The tabs to complete are linked below and colored blue for convenience. You just began a position as a financial accountant at Peyton Approved. In this role, your first task is to prepare the company’s financials for the year-end audit. Additionally, the company is interested in expanding its business within the next year. They would like your support in assessing their ability to meet their goals. Using the Peyton Approved financial data provided below: A. Create the necessary adjusting journal entries. Use the REF column to reference the entry to each event. B. Complete the adjusted trial balance. Trial Balance 2017 Peyton Approved's preliminary financial statements are provided in the yellow tabs. Balance Sheet 2017 Income Statement 2017 Retained Earnings 2017 Cash Flow 2017
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help