Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Overview: In your final project, you will assume the role of an accountant and complete the year-end adjustment process for your company using a provided

image text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribed

Overview: In your final project, you will assume the role of an accountant and complete the year-end adjustment process for your company using a provided workbook. This workbook is the first deliverable (Part I) of your final project. In Part Il, you will analyze the provided financials of the same company and create a report documenting your findings. For your third milestone, you will complete a draft of your ratio analysis report so that you can gain feedback and improve your work prior to the final submission in Module Eight. Note that you do not need feedback from Milestone Two to successfully complete this assignment. You should use the provided final Project Part I template to structure your submission.

Prompt: Specifically, the following critical elements must be addressed:

Abstract:

Summarize the story of profitability and liquidity for your company. In other words, highlight the most important aspects of your report, including your major conclusions.

Computations: Identify and describe your computations from the Financial Analysis tab of your workbook. Be sure to format your key results in a table or graphical format, as appropriate. Explain why each cited figure was included in your report in terms of its importance for the organization.

Comparison: Evaluate the financials of the company by comparing current ratios to both historical and industry-average ratios. Clearly identify all unexpected or aberrant figures.

Conclusion: Draw informed conclusions based on your computations and comparisons in the previous paragraphs. Be sure to justify your claims with specific evidence and examples.

image text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribed
Peyton Approved Adjusting Journal Entries 2017 Date Accounts Debit Credit 31-Dec Depreciation Expense 2,642.86 Accumulated depreciation 2,642.86 31-Dec Amortization Expense 2,000.00 Accumulated Amortization 2,000.00 31-Dec Interest Expense 1,468.75 Interest Payable 1,468.75 31-Dec Insurance Expense 2,000.00 Prepaid Insurance 2,000.00 31-Dec Baking Cost of Goods Sold 137.400.00 Baking Supplies 137.400.00 31-Dec Office Supplies Expense 1,350.00 Office Supplies 1,350.00 31-Dec Wages Expense 22.800.00 Wages Payable 22,800.00 169,661.61 169,661.61 Adjusting Entries Income Statement Closing Entries Statement of RePeyton Approved Statement of Retained Earnings For Year Ending 12/31/2017 Beginning Balance: plus Net Income 83,642.39 less Dividends: 20,000.00 Ending Balance: 63,642.39As of December 31, 2017 Assets Liabilities and Owners' Equity Current Assets: Current Liabilities: Cash 55,428.00 Accounts Payable 27,325.00 Baking Supplies 27,850.00 Wages Payable 22,800.00 Merchandise Inventory (FIFO) 25,750 00 Interest Payable 1,468 75 Prepaid Rent 7,500.00 Total Current Liabilities 51,693.75 Prepaid Insurance 400 00 Office Supplies 250.00 Long Term Liabilities: Accounts Receivable 30 401 00 Notes Payable 10,000 00 Total Current Assets 147,579.00 Loans Payable 21 000.00 Total Long Term Liabilities: 31,000.00 Total Liabilities: 82.593.75 Long Term/Fixed Assets: Baking Equipment 26,000,00 Common Stock 30,000 00 Accumulated Depreciation 5.842 86 Retained Earnings 63,642.39 20.367.14 Leasehold Improvements 10,000 00 Total Equity 93,642.39 Accumulated Amortization 4.000 00 6,000.00 Trademark 2,300.00 Total Assets. 176,236.14 Total Liabilities & Equity 176 236.14 Clouing Entries Statement of Retained Earnings Balance Sheet Financial AnalysisIncome Statement For Year Ending 12/31/2017 Bakery Sales $ 335,675.00 Merchandise Sales $ 35,200.00 Total Revenues 370,875.00 Cost of Goods Sold (FIFO) 15,760.00 Baking Cost of Goods Sold 137,400.00 Gross Profit (FIFO) 217,715.00 Operating Expenses: Rent Expense 90,000.00 Interest Expense 1,468.75 Insurance Expense 2,000.00 Depreciation Expense 2,642.86 Amortization Expense 2,000.00 Misc. Expense 2,780.00 Office Supplies Expense 1,35020 Business License Expense 375.00 Advertising Expense 5,200.00 Wages Expense 22,800.00 Telephone Expense 3,456.00 Total Operating Expenses: 134,072.61 Net Income (FIFO) 83,642.39 Income Statement Closing Entries Statement of Retained Earnings Balance SheetPeyton Approved Trial Balance 2017 Unadjusted trial balance Adjusting entries Adjusted trial balance Account Debit Credit Debit Credit Debit Credit Cash 55,428.00 55,428.00 Baking Supplies 165,250.00 137.400.00 27,850.00 Merchandise Inventory (FIFO) 25,750,00 25,750.00 Prepaid Rent 7,500.00 7,500.00 Prepaid Insurance 2,400.00 2.000.00 400.00 Baking Equipment 26,000.00 26,000.00 Accumulated Depreciation 3,000.00 2,642.86 5,642.86 Leasehold Improvements 10,000.00 10.000.00 Accumulated Amortization 2,000.00 2,000.00 4.000.00 Trademark 2,300.00 2,300.00 Office Supplies 1,600.00 1,350.00 250 00 Accounts Receivable 30.401.00 30,401.00 Notes Payable 10,000.00 10,000.00 Interest Payable 1,468.75 1,468.75 Accounts Payable 27,325.00 27,325.00 Wages Payable 22,800.00 22,800.00 Loans Payable 21,000.00 21,000.00 Common Stock 30,000.00 30,000 00 Dividends 20,000:00 20,000.00 Bakery Sales 335,675.00 335.675.00 Merchandise Sales 35,200.00 35,200.002017 2016 2015 Industry Standard Quick Ratio 1.66 2.2 2.8 1.75 Gross Margin 0.59 0.55 0.7 0.7 Net Margin 0.23 0.22 0.32 0.24 Return on Sales 0.23 0.24 0.26 0.23 Return on Equity 0.89 0.9 0.78 0.8

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Financial Accounting

Authors: Robert Libby, Patricia Libby, Frank Hodge

10th edition

1259964949, 1259964947, 978-1259964947

More Books

Students also viewed these Accounting questions

Question

a) f'(x) 0 when xx 2 d) f" (A) Answered: 1 week ago

Answered: 1 week ago

Question

Peoples understanding of what is being said

Answered: 1 week ago