Excel File Edit View Insert Format Tools Data Window Help AutoSave or ACC 308 Final Proje he Insert Data Review View Tell me Draw Page Layout Formulas Calibri (Body) 11 B I U aA 2 Wrap Text Merge & Center ste EE Open recovered workbooks? Your recent changes were saved. Do you want to continue working where you left off? + x fx D E G H GENERAL ou 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. TRIAL BALANCE 2017 TAB Using the Peyton Approved financial data (see bottom of page Create the necessary adjusting journal entries. Use the REF column to reference the entry to each event Complete the adjusted trial balance REVISED FINANCIAL STATEMENTS Using the preliminary financial statements (yellow tabs) and the Trial Balance 2017, prepare the following statements: Balance Sheet 18 2017 Revised tab) Income Statement 05 2017 Revised tab) Retained Earning Statement.RE 2017 Revised tabl Statement of Cash Flows CE 2017 Revised tab) RATO ANALYSIS Using the revised 2017 financial statements, 2016 financial statements forange tabs), and 2015 financial statements forange tabsi prepare a ratio analysis wit following ratios Current Ratio (Working Capital Quick Ratio AVR Turnover Inventory Turnover Gross margin Return on Sales Return on Equity Return on Aves PEYTON APPROVED FINANCIAL DATA Instructions Instructions - Milestone 1 Trial Balance 2017 Balance Sheet 2017 BS 2017 Revised gal tv D E H M B Return on es Return on Equity Return on Assets 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. Asupplier shipped $3,000 of ingredients on 12/29/17. Peyton receives an invoice for $3,175 for the goods 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 a separate Word document Managint Analysis Brief "Rofar to Final Project Assignment Guidelines and Rubre document Home Insert Draw Page Layout Formulas Data Review View Tell me Arial 12 - A A 25 Wrap Text Accounting U a. Av Marge Center $ % ) Conditional Format Formatting as Table 140 K M N 0 15,506.70 4.413.07 2,114.55 2,114.55 170 49 12,000.00 2,000.00 406 44 3.175.00 Open recovered workbooks? Your recent changes were saved. Do you want to continue working where you left off? x fx 100 D E G H Other Receivable - Insurance 700.00 Baking Supplies 15,506.70 Merchandise Inventory 1,238.07 3,175.00 Consignment Inventory 200.00 Prepaid Rent 2.114.55 Prepaid Insurance 2,114.55 Misc. Supplies 170.49 Baking Equipment 14,000.00 Accumulated Depreciation 1,606.44 1,200.00 Customer Deposit Accounts Payable 20.262.11 Wages Payable 3.383.28 Interest Payable 21146 Notes Payable 5,000.00 Common Stock 20,000.00 Beginning Retained earnings 50,144.84 Dividends 105,000.00 Bakery Sales 327,322.55 Merchandise Sales 1,205,64 Cost of Goods Sold - Baked 105,834 29 Cost of Goods Sold - Merchandise 859.77 Rant Expense 24,549.19 Wages Expense 10,670.72 Misc. Supplies Expense 3,000.46 Business License Expense 2,045.77 Misc. Expense 1,363.84 Depreciation Expense 677.86 Insurance Expense 1.091.08 Advertising Expense 1,549.74 Interest Expense 818.31 Telephone Expense 490.98 Gain Loss on disposal of equipment 100.00 429,136.32 429.136.32 6.375.00 23,437.11 3,383 28 211.46 5,000.00 20,000.00 50,144 84 105,000.00 327,322,56 1,205,64 200.00 105,834.29 659.77 24,549.19 10,670.72 3,000.46 2,045.77 1,363.84 677.86 1,091.08 1,549.74 818.31 490.98 5,375.00 431,111,32 431,111.32 Instructions Instructions - Milestone 1 Til Rannan C D G 1 Preliminary 2 Peyton Approved Balance Sheet As of December 31, 2017 Assets 2 Current Assets: Cash Accounts Recelvable Baking Supplies Merchandise Inventory Prepaid Rent Prepaid Insurance Misc. Supplies Llabilities and Owners' Equity Current Liabilities: Accounts Payable 20 262.11 Wages Payable 3,383 28 Interest Payable 211.46 3 1 67,520.04 68,519.91 15,506.70 1238.07 2,114.55 2,114.55 170.49 2 3 Total Current Assets 157,184.31 Total Current Liabilities 23,856.85 Long Term/Fixed Assets: Baking Equipment Accumulated Depreciation Net Fixed assets Long Term Liabilities: Notes Payable Total Long Term Liabilities: 5,000.00 14,000.00 -1,606.44 5,000.00 12,393.56 Total Liabilities: 28,856.85 Common Stock Retained Earnings 20,000.00 120,721.02 Total Equity 140.721.02 Total Assets 169,577.87 Total Liabilities & Equity 169,577.87 Instructions Instructions - Milestone 1 Trial Balance 2017 Balance Sheet 2017 BS 2017 Revised Income Stateme Average: 45,45 li Merge Center $ % 98 99 Conditional Format Cal Formatting as Table Styles ? Your recent changes were saved. Do you want to continue working where you left off? D E H Peyton Approved Balance Sheet As of December 31, 2017 Assets Current Assets: Cash Accounts Receivable Baking Supplies Merchandise Inventory Prepaid Rent Prepaid Insurance Misc. Supplies Other Receivable-Insurance Consignment Inventory Liabilities and Owners' Equity Current Liabilities: Accounts Payable 23,437.11 Wages Payable 3,383.28 Interest Payable 21146 Sustomer Deposit 1000 68,520.04 68,519.91 18,681.70 1,038.07 2,114.55 2,114.55 170.49 700.00 200.00 Total Current Assets 162,059.31 Total Current Liabilities 28,031.85 Long Term/Fixed Assets: Baking Equipment Accumulated Depreciation Net Fixed assets Long Term Liabilities: Notes Payable Total Long Term Liabilities: 5,000.00 12,000.00 -406.44 5,000.00 11,593.56 Total Liabilities: 33,031.85 Common Stock Retained Earnings 20,000.00 120,621.02 Total Equity 140.621.02 Total Assets 173,652.87 Total Liabilities & Equity 173,652.87 A x V fx =E13-E29 B D E Preliminary Peyton Approved Income Statement For Year Ended 12/31/2017 327,322.55 1,205.64 328,528.19 Bakery Sales Merchandise Sales Total Revenues Cost of Goods Sold - Baked Cost of Goods Sold - Merchandise Total Cost of Goods Sold Gross Profit 105,834.29 859.77 106,694.06 221,834.13 Operating Expenses: Rent Expense Wages Expense Misc. Supplies Expense Business License Expense Misc. Expense Depreciation Expense Insurance Expense Advertising Expense Interest Expense Telephone Expense Total Operating Expenses: 24,549.19 10,670.72 3,000.46 2,045.77 1,363.84 677.86 1,091.08 1,549.74 818.31 490.98 46,257.95 Net Income 175,576.18 Instructions Instructions - Milestone 1 Trial Balance 2017 Balance She X x B D E Peyton Approved Income Statement For Year Ended 12/31/2017 $327,322.55 1,205.64 328,528.19 Bakery Sales Merchandise Sales Total Revenues Cost of Goods Sold - Baked Cost of Goods Sold - Merchandise Total Cost of Goods Sold Gross Profit 105,834.29 859.77 106,694.06 221,834.13 Operating Expenses: Rent Expense Wages Expense Misc. Supplies Expense Business License Expense Misc. Expense Depreciation Expense Insurance Expense Advertising Expense Interest Expense Telephone Expense Gain/Loss on disposal of equipment Total Operating Expenses: 24,549.19 10,670.72 3,000.46 2,045.77 1,363.84 677.86 1,091,08 1,549.74 818.31 490.98 100.00 46,357.95 Net Income 175,476.18 Instructions Instructions - Milestone 1 Trial Balance 2017 Balanc x fx Beginning Balance: B D E F Preliminary Peyton Approved Statement of Retained Earnings For Year Ended 12/31/2017 Beginning Balance: plus Net Income $ 50,144.84 175,576.18 less Dividends: Ending Balance 105,000.00 $ 120,721.02 books? Your recent changes were saved. Do you want to continue working where you left fx =+('Balance Sheet 2017'|c8) C D E F G H Net Income Depreciation Expense $ 175,576.18 67786 176,254.04 Increase in Accounts Receivable Increase in Baking Supplies Increase in Merchandise inventory Increase in Prepaid Rent Increase in Prepaid Insurance Increase in Misc. Supplies Increase in Accounts Payable Increase in Wages Payable Increase in Interest Payable (25,886.91) (8.187.84) (443.10) (449.55) (1,004.55) (114.99) 3,292.11 1,850.48 44.96 Operating Cash Flow 145,354.65 Cash Flow from Investments Equipment Purchases (6,000.00) Cash Flow from Investments (6.000.00) Cash Flow from Financing Repayment of Note Payable Dividends Paid (10,000.00) (105.000.00) Cash Flow from Financing (115,000.00) Net Cash Flow 24,354.65 Beginning Cash 43,165.39 Ending Cash 67,520.04 vised Retained Earnings 2017 RE 2017 Revised Cash Flow 2017 CF 2 ert Draw Page Layout Formulas Data Review View Tell me Calibri (Body) 11 55 > ' A de Wrap Text Merge & Centar BIU ered workbooks? Your recent changes were saved. Do you want to continue working where you left off? X fx B G H D Peyton Approved Balance Sheet As of December 31, 2015 Assets rrent Assets: sh counts Receivable king Supplies erchandise Inventory pald Rent paid Insurance sc. Supplies Liabilities and Owners' Equity Current Liabilities: Accounts Payable 15086.84 Wages Payable 111883 Interest Payable 121.53 31507.58 35118.97 8042.23 580.27 1215,32 810.21 40.51 tal Current Assets 77,315.09 Total Current Liabilities 16,32720 ng Term/Fixed Assets: aking Equipment Accumulated Deprecia et Fixed assets Long Term Liabilities: Notes Payable 10,000.00 Total Long Term Liabilities: 6000 -677.79 10,000.00 5,322.21 Total Liabilities: 26,327.20 Common Stock Retained Earings 20,000.00 36,310.10 Total Equity 56,310.10 tal Assets: 82,637.30 Total Liabilities & Equity 82,637.30 5 2017 Revised Retained Earnings 2017 RE 2017 Revised Cash Flow 2017 CF 2017 Revised tv s aste B 1 Uvo A E = = = Open recovered workbooks? Your recent changes were saved. Do you want to continue wor x v fc A B D F 2017 2016 Current Ratio (Working Capital) 5.78 5.18 Quick Ratio 4.89 4.60 A/R Turnover 5.91 5.53 Inventory Turnover 7.61 8.81 Gross margin 68% 66% Return on Sales 53% 52% Return on Equity 125% 161% Return on Assets 101% 109% Cash Flow 2017 CF 2017 6:54 App Store ilUE ACCOUNTING FINAL fx MUMS TO COMPLETE FOR HELGITORE Ime + Instructions Instructions - Milest... 6:55 App Store ilUE ACCOUNTING FINAL fx AIRLINE S: U Instructions - Milest... Trial Balance 2017 + fx Ansato Current Assets C Accounts Receivable Merchande inventory Prepud Reet Prepare Oher Receive Libes and wity Current Listes ACS Payal 2343711 Wes Petite 338325 in Payable 21146 Custom Depe 653004 6851991 1810 103807 211455 2.1145 1704 70000 200.00 162.050 31 Total Current Liabilities Long Term Liabilities Notes Payable 5.000 Total Long Term Libilities: Long Term Fed Assets Buning Equipment Accented Depre 12.000.00 11.03. Commentek 20,000.00 143.22 Totalt Total To se 173.652.87 K fx 6:57 App Store .I LTE ACCOUNTING FINAL fx Peyton Approved Income Statement For Year Ended 12/31/2017 $ 327,322 55 1.205.64 328,528.19 Bakery Sales Merchandise Sales Total Revenues Cost of Goods Sold - Baked 10 Cost of Goods Sold - Merchandise 11 Total Cost of Goods Sold 12 Gross Profit 105,834.29 859.77 106.694.06 221,834.13 15 16 Operating Expenses: 13 Rent Expense Wages Expense Misc. Supplies Expense Business License Expense Misc. Expense Depreciation Expense 24 Insurance Expense Advertising Expense Interest Expense Telephone Expense Gain Loss on disposal of equipment 29 Total Operating Expenses: 24,549.19 10,670.72 3,000.46 2,045.77 1,363.84 677 86 1,091.08 1.549.74 818 31 490.98 100.00 46,357.95 Net Income 175,476.18 FO OD 6:58 App Store .I LTE ACCOUNTING FINAL Peyton Approved Statement of Retained Earnings For Year Ended 12/31/2017 Beginning Balance: plus Net Income $ 50,144.84 175,476.18 10 11 less Dividends: Ending Balance 105,000.00 $ 120,621.02 12 13 14 15 16 17 18 19 20 21 22 24 29 tained Earnings 2... RE 2017 Revised 6:58 App Store .I LTE ACCOUNTING FINAL fx Peyton Approved Statement of cash flow For Year Ended 12/31/2017 $ 175.47618 67786 Net Income Depreciation Experise Loss on Disposa 175 25404 25.06.99) (11.3628 24310) (1.00455 154.99 15048 Increase in Accounts Receivable Increase in Baking Supplies Increase in Merchandise inventory Increase in Prepaid Rent Increase in Prepaid insurance Increase in Mac Supplies crease in Accounts Payable increase in Wages va Increase in interest Payable Operating Cash Flow Cash Flow from man Equipment Purchases Insurance Proceeds Cash Flow from investments Cash Flow from Financing Repayment of Note Payable Dividends Paid Cash Flow from Financing Net Cash Flow Beginning Cash Ending Cash 15.000.00 70000 53000 (10.000.00 (105.000.00 (115.000.000 585204 d Cash Flow 2017 CF 2017 Revised + 6:58 App Store .I LTE ACCOUNTING FINAL Sum: 55.66 Average: 3.48 Count: 16 Numeric 2017 2016 5.18 59: Current Rate Working Capital Que Rate AR Turnover Inventory Tume Gross margin Relum on Sales Return on Equity 50% Reum on Assets 501 Income Statement 2... Ratio Analysis + 6:59 1 .I LTE ACCOUNTING FINAL fx 49 In a separate Word document Reporting *Refer to Final Project Assignment Guidelines and Rubric document 55 56 57 Analyze Data 1. Briefly summarize each department's budget-its purpose, what the numbers represent, how they can be used. Also, discuss the month to month variances, what they mean, and why they are important 2. Explain two variances that might cause concern or prompt further analysis 67 In a separate Word document or PowerPoint Presentation Executive Brief Presentation 1. Create an executive briefing presentation in which you briefly summarize all budgets, include all supporting documentation as addendums to the brief 71 72 73 75 76 + Ratio Analysis Milestone 2 Instruct... Excel File Edit View Insert Format Tools Data Window Help AutoSave or ACC 308 Final Proje he Insert Data Review View Tell me Draw Page Layout Formulas Calibri (Body) 11 B I U aA 2 Wrap Text Merge & Center ste EE Open recovered workbooks? Your recent changes were saved. Do you want to continue working where you left off? + x fx D E G H GENERAL ou 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. TRIAL BALANCE 2017 TAB Using the Peyton Approved financial data (see bottom of page Create the necessary adjusting journal entries. Use the REF column to reference the entry to each event Complete the adjusted trial balance REVISED FINANCIAL STATEMENTS Using the preliminary financial statements (yellow tabs) and the Trial Balance 2017, prepare the following statements: Balance Sheet 18 2017 Revised tab) Income Statement 05 2017 Revised tab) Retained Earning Statement.RE 2017 Revised tabl Statement of Cash Flows CE 2017 Revised tab) RATO ANALYSIS Using the revised 2017 financial statements, 2016 financial statements forange tabs), and 2015 financial statements forange tabsi prepare a ratio analysis wit following ratios Current Ratio (Working Capital Quick Ratio AVR Turnover Inventory Turnover Gross margin Return on Sales Return on Equity Return on Aves PEYTON APPROVED FINANCIAL DATA Instructions Instructions - Milestone 1 Trial Balance 2017 Balance Sheet 2017 BS 2017 Revised gal tv D E H M B Return on es Return on Equity Return on Assets 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. Asupplier shipped $3,000 of ingredients on 12/29/17. Peyton receives an invoice for $3,175 for the goods 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 a separate Word document Managint Analysis Brief "Rofar to Final Project Assignment Guidelines and Rubre document Home Insert Draw Page Layout Formulas Data Review View Tell me Arial 12 - A A 25 Wrap Text Accounting U a. Av Marge Center $ % ) Conditional Format Formatting as Table 140 K M N 0 15,506.70 4.413.07 2,114.55 2,114.55 170 49 12,000.00 2,000.00 406 44 3.175.00 Open recovered workbooks? Your recent changes were saved. Do you want to continue working where you left off? x fx 100 D E G H Other Receivable - Insurance 700.00 Baking Supplies 15,506.70 Merchandise Inventory 1,238.07 3,175.00 Consignment Inventory 200.00 Prepaid Rent 2.114.55 Prepaid Insurance 2,114.55 Misc. Supplies 170.49 Baking Equipment 14,000.00 Accumulated Depreciation 1,606.44 1,200.00 Customer Deposit Accounts Payable 20.262.11 Wages Payable 3.383.28 Interest Payable 21146 Notes Payable 5,000.00 Common Stock 20,000.00 Beginning Retained earnings 50,144.84 Dividends 105,000.00 Bakery Sales 327,322.55 Merchandise Sales 1,205,64 Cost of Goods Sold - Baked 105,834 29 Cost of Goods Sold - Merchandise 859.77 Rant Expense 24,549.19 Wages Expense 10,670.72 Misc. Supplies Expense 3,000.46 Business License Expense 2,045.77 Misc. Expense 1,363.84 Depreciation Expense 677.86 Insurance Expense 1.091.08 Advertising Expense 1,549.74 Interest Expense 818.31 Telephone Expense 490.98 Gain Loss on disposal of equipment 100.00 429,136.32 429.136.32 6.375.00 23,437.11 3,383 28 211.46 5,000.00 20,000.00 50,144 84 105,000.00 327,322,56 1,205,64 200.00 105,834.29 659.77 24,549.19 10,670.72 3,000.46 2,045.77 1,363.84 677.86 1,091.08 1,549.74 818.31 490.98 5,375.00 431,111,32 431,111.32 Instructions Instructions - Milestone 1 Til Rannan C D G 1 Preliminary 2 Peyton Approved Balance Sheet As of December 31, 2017 Assets 2 Current Assets: Cash Accounts Recelvable Baking Supplies Merchandise Inventory Prepaid Rent Prepaid Insurance Misc. Supplies Llabilities and Owners' Equity Current Liabilities: Accounts Payable 20 262.11 Wages Payable 3,383 28 Interest Payable 211.46 3 1 67,520.04 68,519.91 15,506.70 1238.07 2,114.55 2,114.55 170.49 2 3 Total Current Assets 157,184.31 Total Current Liabilities 23,856.85 Long Term/Fixed Assets: Baking Equipment Accumulated Depreciation Net Fixed assets Long Term Liabilities: Notes Payable Total Long Term Liabilities: 5,000.00 14,000.00 -1,606.44 5,000.00 12,393.56 Total Liabilities: 28,856.85 Common Stock Retained Earnings 20,000.00 120,721.02 Total Equity 140.721.02 Total Assets 169,577.87 Total Liabilities & Equity 169,577.87 Instructions Instructions - Milestone 1 Trial Balance 2017 Balance Sheet 2017 BS 2017 Revised Income Stateme Average: 45,45 li Merge Center $ % 98 99 Conditional Format Cal Formatting as Table Styles ? Your recent changes were saved. Do you want to continue working where you left off? D E H Peyton Approved Balance Sheet As of December 31, 2017 Assets Current Assets: Cash Accounts Receivable Baking Supplies Merchandise Inventory Prepaid Rent Prepaid Insurance Misc. Supplies Other Receivable-Insurance Consignment Inventory Liabilities and Owners' Equity Current Liabilities: Accounts Payable 23,437.11 Wages Payable 3,383.28 Interest Payable 21146 Sustomer Deposit 1000 68,520.04 68,519.91 18,681.70 1,038.07 2,114.55 2,114.55 170.49 700.00 200.00 Total Current Assets 162,059.31 Total Current Liabilities 28,031.85 Long Term/Fixed Assets: Baking Equipment Accumulated Depreciation Net Fixed assets Long Term Liabilities: Notes Payable Total Long Term Liabilities: 5,000.00 12,000.00 -406.44 5,000.00 11,593.56 Total Liabilities: 33,031.85 Common Stock Retained Earnings 20,000.00 120,621.02 Total Equity 140.621.02 Total Assets 173,652.87 Total Liabilities & Equity 173,652.87 A x V fx =E13-E29 B D E Preliminary Peyton Approved Income Statement For Year Ended 12/31/2017 327,322.55 1,205.64 328,528.19 Bakery Sales Merchandise Sales Total Revenues Cost of Goods Sold - Baked Cost of Goods Sold - Merchandise Total Cost of Goods Sold Gross Profit 105,834.29 859.77 106,694.06 221,834.13 Operating Expenses: Rent Expense Wages Expense Misc. Supplies Expense Business License Expense Misc. Expense Depreciation Expense Insurance Expense Advertising Expense Interest Expense Telephone Expense Total Operating Expenses: 24,549.19 10,670.72 3,000.46 2,045.77 1,363.84 677.86 1,091.08 1,549.74 818.31 490.98 46,257.95 Net Income 175,576.18 Instructions Instructions - Milestone 1 Trial Balance 2017 Balance She X x B D E Peyton Approved Income Statement For Year Ended 12/31/2017 $327,322.55 1,205.64 328,528.19 Bakery Sales Merchandise Sales Total Revenues Cost of Goods Sold - Baked Cost of Goods Sold - Merchandise Total Cost of Goods Sold Gross Profit 105,834.29 859.77 106,694.06 221,834.13 Operating Expenses: Rent Expense Wages Expense Misc. Supplies Expense Business License Expense Misc. Expense Depreciation Expense Insurance Expense Advertising Expense Interest Expense Telephone Expense Gain/Loss on disposal of equipment Total Operating Expenses: 24,549.19 10,670.72 3,000.46 2,045.77 1,363.84 677.86 1,091,08 1,549.74 818.31 490.98 100.00 46,357.95 Net Income 175,476.18 Instructions Instructions - Milestone 1 Trial Balance 2017 Balanc x fx Beginning Balance: B D E F Preliminary Peyton Approved Statement of Retained Earnings For Year Ended 12/31/2017 Beginning Balance: plus Net Income $ 50,144.84 175,576.18 less Dividends: Ending Balance 105,000.00 $ 120,721.02 books? Your recent changes were saved. Do you want to continue working where you left fx =+('Balance Sheet 2017'|c8) C D E F G H Net Income Depreciation Expense $ 175,576.18 67786 176,254.04 Increase in Accounts Receivable Increase in Baking Supplies Increase in Merchandise inventory Increase in Prepaid Rent Increase in Prepaid Insurance Increase in Misc. Supplies Increase in Accounts Payable Increase in Wages Payable Increase in Interest Payable (25,886.91) (8.187.84) (443.10) (449.55) (1,004.55) (114.99) 3,292.11 1,850.48 44.96 Operating Cash Flow 145,354.65 Cash Flow from Investments Equipment Purchases (6,000.00) Cash Flow from Investments (6.000.00) Cash Flow from Financing Repayment of Note Payable Dividends Paid (10,000.00) (105.000.00) Cash Flow from Financing (115,000.00) Net Cash Flow 24,354.65 Beginning Cash 43,165.39 Ending Cash 67,520.04 vised Retained Earnings 2017 RE 2017 Revised Cash Flow 2017 CF 2 ert Draw Page Layout Formulas Data Review View Tell me Calibri (Body) 11 55 > ' A de Wrap Text Merge & Centar BIU ered workbooks? Your recent changes were saved. Do you want to continue working where you left off? X fx B G H D Peyton Approved Balance Sheet As of December 31, 2015 Assets rrent Assets: sh counts Receivable king Supplies erchandise Inventory pald Rent paid Insurance sc. Supplies Liabilities and Owners' Equity Current Liabilities: Accounts Payable 15086.84 Wages Payable 111883 Interest Payable 121.53 31507.58 35118.97 8042.23 580.27 1215,32 810.21 40.51 tal Current Assets 77,315.09 Total Current Liabilities 16,32720 ng Term/Fixed Assets: aking Equipment Accumulated Deprecia et Fixed assets Long Term Liabilities: Notes Payable 10,000.00 Total Long Term Liabilities: 6000 -677.79 10,000.00 5,322.21 Total Liabilities: 26,327.20 Common Stock Retained Earings 20,000.00 36,310.10 Total Equity 56,310.10 tal Assets: 82,637.30 Total Liabilities & Equity 82,637.30 5 2017 Revised Retained Earnings 2017 RE 2017 Revised Cash Flow 2017 CF 2017 Revised tv s aste B 1 Uvo A E = = = Open recovered workbooks? Your recent changes were saved. Do you want to continue wor x v fc A B D F 2017 2016 Current Ratio (Working Capital) 5.78 5.18 Quick Ratio 4.89 4.60 A/R Turnover 5.91 5.53 Inventory Turnover 7.61 8.81 Gross margin 68% 66% Return on Sales 53% 52% Return on Equity 125% 161% Return on Assets 101% 109% Cash Flow 2017 CF 2017 6:54 App Store ilUE ACCOUNTING FINAL fx MUMS TO COMPLETE FOR HELGITORE Ime + Instructions Instructions - Milest... 6:55 App Store ilUE ACCOUNTING FINAL fx AIRLINE S: U Instructions - Milest... Trial Balance 2017 + fx Ansato Current Assets C Accounts Receivable Merchande inventory Prepud Reet Prepare Oher Receive Libes and wity Current Listes ACS Payal 2343711 Wes Petite 338325 in Payable 21146 Custom Depe 653004 6851991 1810 103807 211455 2.1145 1704 70000 200.00 162.050 31 Total Current Liabilities Long Term Liabilities Notes Payable 5.000 Total Long Term Libilities: Long Term Fed Assets Buning Equipment Accented Depre 12.000.00 11.03. Commentek 20,000.00 143.22 Totalt Total To se 173.652.87 K fx 6:57 App Store .I LTE ACCOUNTING FINAL fx Peyton Approved Income Statement For Year Ended 12/31/2017 $ 327,322 55 1.205.64 328,528.19 Bakery Sales Merchandise Sales Total Revenues Cost of Goods Sold - Baked 10 Cost of Goods Sold - Merchandise 11 Total Cost of Goods Sold 12 Gross Profit 105,834.29 859.77 106.694.06 221,834.13 15 16 Operating Expenses: 13 Rent Expense Wages Expense Misc. Supplies Expense Business License Expense Misc. Expense Depreciation Expense 24 Insurance Expense Advertising Expense Interest Expense Telephone Expense Gain Loss on disposal of equipment 29 Total Operating Expenses: 24,549.19 10,670.72 3,000.46 2,045.77 1,363.84 677 86 1,091.08 1.549.74 818 31 490.98 100.00 46,357.95 Net Income 175,476.18 FO OD 6:58 App Store .I LTE ACCOUNTING FINAL Peyton Approved Statement of Retained Earnings For Year Ended 12/31/2017 Beginning Balance: plus Net Income $ 50,144.84 175,476.18 10 11 less Dividends: Ending Balance 105,000.00 $ 120,621.02 12 13 14 15 16 17 18 19 20 21 22 24 29 tained Earnings 2... RE 2017 Revised 6:58 App Store .I LTE ACCOUNTING FINAL fx Peyton Approved Statement of cash flow For Year Ended 12/31/2017 $ 175.47618 67786 Net Income Depreciation Experise Loss on Disposa 175 25404 25.06.99) (11.3628 24310) (1.00455 154.99 15048 Increase in Accounts Receivable Increase in Baking Supplies Increase in Merchandise inventory Increase in Prepaid Rent Increase in Prepaid insurance Increase in Mac Supplies crease in Accounts Payable increase in Wages va Increase in interest Payable Operating Cash Flow Cash Flow from man Equipment Purchases Insurance Proceeds Cash Flow from investments Cash Flow from Financing Repayment of Note Payable Dividends Paid Cash Flow from Financing Net Cash Flow Beginning Cash Ending Cash 15.000.00 70000 53000 (10.000.00 (105.000.00 (115.000.000 585204 d Cash Flow 2017 CF 2017 Revised + 6:58 App Store .I LTE ACCOUNTING FINAL Sum: 55.66 Average: 3.48 Count: 16 Numeric 2017 2016 5.18 59: Current Rate Working Capital Que Rate AR Turnover Inventory Tume Gross margin Relum on Sales Return on Equity 50% Reum on Assets 501 Income Statement 2... Ratio Analysis + 6:59 1 .I LTE ACCOUNTING FINAL fx 49 In a separate Word document Reporting *Refer to Final Project Assignment Guidelines and Rubric document 55 56 57 Analyze Data 1. Briefly summarize each department's budget-its purpose, what the numbers represent, how they can be used. Also, discuss the month to month variances, what they mean, and why they are important 2. Explain two variances that might cause concern or prompt further analysis 67 In a separate Word document or PowerPoint Presentation Executive Brief Presentation 1. Create an executive briefing presentation in which you briefly summarize all budgets, include all supporting documentation as addendums to the brief 71 72 73 75 76 + Ratio Analysis Milestone 2 Instruct