Solution
Ayushi answered on
May 20 2022
ACC 308 Final Project Workbook
HOME
Southern New Hampshire University
ACC 308 - Intermediate Accounting II
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 ru
ic 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 TWO
(Due in Module Five) FINAL PROJECT
(Due in Module Seven)
Milestone One
Workbook Instructions Milestone Two
Workbook Instructions Note: The final project consists of co
ected work from Milestone One and Milestone Two. Incorporate the feedback you received from your instructor.
1. Trial Balance 1. Pro Forma Financial Statements
Using the Peyton Approved financial data, create: Using the given pro forma information, create:
Adjusting Entries Pro Forma Income Statement
Adjusted Trial Balance Pro Forma Balance Sheet
2. Revised Financial Statements 2. Notes to the Financial Statements
Note: This part of the project is submitted as a separate Word document. Refer to the Milestone Two Guidelines and Ru
ic document for submission guidelines.
Using the trial balance and preliminary financial statements, prepare: Your notes must contain the following:
Revised Balance Sheet A. Create appropriate notes as year-to-year documentation for managing depreciation, supplies, and inventory.
Revised Income Statement B. Create appropriate notes for long-term debt.
Revised Retained Earnings Statement
Revised Statement of Cash Flows
3. Ratio Analysis 3. Management Analysis Brief
Note: Refer to the Final Project Scenario for Peyton's ratio formulas. Note: This part of the project is submitted as a separate Word document. Refer to the Milestone Two Guidelines and Ru
ic document for submission guidelines.
Using the financial statements from 2015, 2016, and revised 2017, calculate the following ratios: Your management analysis
ief should explain financial information to management. Provide evidence from your accounting workbook to support your ideas where applicable.
Cu
ent Ratio (Working Capital) A. Discuss the impact of the pro forma financial statements for predicting ability to meet future expansion goals.
Quick Ratio B. Describe the implications of inventory costing, contingent liabilities, and revenue recognition.
A/R Turnover C. Identify potential issues in interpretation of financial information, providing examples to support your ideas.
Inventory Turnove
Gross Margin
Return on Sales
Return on Equity
Return on Assets
4. Management Analysis Brief
Note: This part of the project is submitted as a separate Word document. Refer to the Milestone One Guidelines and Ru
ic document for submission guidelines.
Your management analysis
ief 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.
Milestone One Instructions
Return
HOME
INSTRUCTIONS FOR MILESTONE ONE
(Due in Module Three)
Note: Make sure to completely review the Milestone One Guidelines and Ru
ic document.
Use the data from this milestone and begin working on your final project, due in Module Seven.
ITEMS TO COMPLETE FOR MILESTONE ONE:
The tabs to complete are linked below and colored blue for convenience.
GENERAL
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.
1. TRIAL BALANCE
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
2. REVISED FINANCIAL STATEMENTS
Peyton Approved's preliminary financial statements are provided in the yellow tabs.
Balance Sheet 2017
Income Statement 2017
Retained Earnings 2017
Cash Flow 2017
Using the preliminary financial statements and the Trial Balance 2017, prepare the following statements:
Balance Sheet
2017 Revised
Income Statement
2017 Revised
Retained Earnings Statement
2017 Revised
Statement of Cash Flows
2017 Revised
Note: Refer to Module Three resources for a refresher on statement of cash flows.
Peyton Approved's previous years' financial statements are provided in the orange tabs.
Balance Sheet 2015
Balance Sheet 2016
Income Statement 2016
3. RATIO ANALYSIS
Using the revised 2017 financial statements, 2016 financial statements, and 2015 financial statements, prepare a ratio analysis for Peyton Approved.
Note: Refer to the Final Project Scenario for Peyton's ratio formulas.
Ratio Analysis
PEYTON APPROVED FINANCIAL DATA
Preliminary financial statements have already been prepared (2017 statements in the Final Project Workbook). Final adjusting entries have not yet been made. See table for possible adjustments that indicate what will be recorded at 12/31/17 (fiscal year end). Use the following to complete year-to-year documentation and notes for managing depreciation, inventory, and long-term debt.
1. A supplier shipped $3,000 of ingredients on 12/29/17. Peyton receives an invoice for $3,175—goods of $3,000 and freight of $175—all dated 12/29/17. Goods were shipped FOB supplier’s warehouse.
2. At 12/31/17, Peyton has $200 worth of merchandise on consignment at Bruno’s House of Bacon.
3. On 12/23/17, Peyton received a $1,000 deposit from Pet Globe for product to be shipped by Peyton in the second week of January.
4. On 12/03/2017, a mixer with cost of $2,000, accumulated depreciation $1,200, was destroyed by a forklift. As of 12/23/17, insurance company has agreed to pay $700 in January 2018, for accidental destruction.
4. MANAGEMENT ANALYSIS BRIEF
Note: This part of the project is submitted as a separate Word document. Refer to the Milestone One Guidelines and Ru
ic document for submission guidelines.
Your management analysis
ief 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.
Trial Balance 2017
Milestone...