If possible, I was hoping to have my work checked for this scenario. In addition, could you provide me some assistance with ratio analysis calculations, pro forma income statement, and pro forma balance sheet.

PEYTON APPROVED FINANCIAL DATA Preliminary Financial Statements have already been prepared 12017 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 End1 . USE the following to complete year - to- year documentation and notes for managing depreciation , inventory , and long-term debt . 1 . A Supplier shipped 53, and of ingredients on 12/ 25/ 17. Peyton RECEIVES an invoice for the goods, as well as a bill for freight for 5 175 . all dated 12/ 29/ 17 . Goods were shipped FOR SuppliEr's warehouse . 2. At 12/31/ 17, Peyton has 5 200 worth of merchandise on consignment at Bruno's House of Bacon . 3. On 12 / 23/ 17, PEYton received $ 5 1. 000 deposit from Pet Globe for product to be shipped by Peyton in the second WEEK of January . 4. On 12/03/ 2017, & mixer with cost of $ 2, 200, accumulated depreciation $ 1, 200, was destroyed by & forklift . As of 12/ 23/17. insurance company has BETEEd to pay $ 700 in January , 2018 , for accidental destruction . 5. Hate about later borrowing financials will show loan from parents repaid and use of bank financing .TRIAL BALANCE As of December 31, 2017 Unadjusted trial balance Adjusting entries Adjusted trial balance Dr Cr Cash 67 520 04 1,000.00 68 520 04 Accounts Receivable 68 519.91 68 519 91 Other Receivable . Insurance 700 Baking Supplies 15 508.70 3 000.00 18 508.70 Merchandise Inventory 1 238 07 200.00 1 038 07 Consignment Inventory 200.00 200 00 Prepaid Rent 2 114 55 2 114 55 Prepaid Insurance 2 114 55 194 83 1 619 72 Misc. Supplies 170 49 170 49 Baking Equipment 14 000.00 2 000 00 4 12 000 00 Accumulated Depreciation 1,608 44 1 200 00 406 44 Customer Deposit 00 000 1 000 00 Accounts Payable 20 262 11 3 175 00 23 437_11 Wages Payable 3 383 28 3 383 28 Interest Payable 211.46 211.46 Notes Payable 5 000 00 5.000.00 Common Stock 20 000 00 20 000 00 Beginning Retained camings 50 144 84 50 144 84 Dividends 105 000 00 105 000 00 Bakery Sales 327 322 55 327 322 56 Merchandise Sales 1 205 64 1 205 64 Cost of Goods Gold . Baked 105 834 29 105 834 29 Cost of Goods Sold . Merchandise 858 77 858.77 Rent Expense 24 519.19 24 519.19 Wages Expense 10 670.72 10 670 72 Misc. Supplies Expense 3 000 46 3 000 46 Business License Expense 2 045.77 2 045.77 Misc. Expense 1,363 84 175 00 1 538 84 Depreciation Expense 677 86 677.86 Insurance Expense 1 091 08 484 83 1 585 91 Advertising Expense 1,549.74 1 549.74 Interest Expense 818 31 818 31 Telephone Expense 180 98 490.98 Gain/Loss on disposal of equipment 100 00 100 00 129 136 32 429 136 32 6.869 83 6 859 83 432 111.32 492 111.32Peyton Approved Balance Sheet As of December 31, 2017 Assets Liabilities and Owners' Equity urrent Assets: Current Liabilities: Cash 68 520.04 Accounts Payable 23,437.11 ocounts Receivable 69 219.91 Wages Payable 3,383.28 Baking Suplies 18,506.70 Interest Payable 211.46 Merchandise Inventory 1,038.07 repaid Rent 2,114.55 'repaid Insurance 1,619.72 fisc Supplies 170.49 total Current Assets 161,189 48 Total Current Liabilities 27,031.85 Long Term Liabilities: ong Term/Fixed Assets: Notes Payable 5000.00 aking Equipment 12,000.00 Total Long Term Liabilities: 5000.00 ocum Depreciation [406 44] Jet Fixed Assets 11,593.56 Total Liabilities 32,031 .85 Common Stock 20,000.00 Retained Earnings 120,751.19 Total Equity 140,751.19 otal Assets: 172,783.04 Total Liabilities and Equity 172,783.04Payton Approved Income Statement For Year Ended 12/31/2017 Bakery Sales 5 327, 322.55 Merchandise Sales 1 , 205. 54 Total Revenues 328 , 528. 15 Cost of Goods Sold - Baked 105, 8:34. 20 Cost of Goods Sold . Merchandise* 8.50. TT Total Cost of Goods Sold TO5, 604. 05 Gross Profit 221, 8:34. 13 Operating EXPENSES : Rent EXPENSE 24, 540. 10 Wages EXPENSE 10 , ETO. TZ Misc . Supplies EXPENSE* 3, 000. 45 Business License Expense* 2, 045. 7 7 Misc . Expense* 1 , 538. 8^ Depreciation EXPENSE* BIT . BE Insurance EXPENSE* 1 , 58.5. 21 Advertising Expense 1. 540. 74\\ Interest EXPENSE* $ 18. 31 Telephone EXPENSE* 40 0. 9B Total Operating Expenses :` 46, 527. TO Not Income 17 4, 505. 35Peyton Approved Statement of Retained Earnings For Year Ended 12151/2017 Beginning Balance* 50, 144. 84 plus Net Income 174. 906. 35 less Dividends. 105, DOO. DO Ending Balance* $ 120, 051. 15Peyton Approved Statement of cash Flow For Year Ended 1231/2017 Net Income 5 174,908.35 Depreciation Expanse 877.88 175,504.21 Increase in Accounts Receivable 23,508.91) Increase in Baking Supplies (11, 187.84) Increase in Merchandise inventory (243.10) Increase in Prepaid Ren! [449.55) Increase in Prepaid Insurance [1 499.38) Increase in Mise. Supplies (2,114.99) IIncrease in Accounts Payable 8,407.11 Increase in Wages Payable 1,850.48 Increase in Interest Payable 44.98 Operating Cash Flow 141 834.99 Cash Flow from Investments Equipment Purchases 3,000.00 Cash Flow from Investments too ooo'El Cash Flow from Financing Repayment of Note Payable (10,000.00) Dividends Paid (105,000.00) Cash Flow from Financing (115,000.00) Net Cash Flow 20.834.99 Beginning Cash 43, 105.39 Ending Cash 83,520.04Balance Sheet AS Of December 31, 2016 AS50+.5 Liabilities and Owners' Equity Current Assets` Current Liabilities . Cash $3. 165. 30 Accounts Payable IB. STOOD Accounts Receivable 42, 632.00 Wages Payable* 1 , 532. B.D Baking Supplies Interest Payable Merchandise Inventory* TO 4. OF Prepaid Rent Frepaid Insurance* 1. 1 10.00 Misc . Supplies 5.5.50 Total Current Assets 56, 742.72 Total Current Liabilities Long Term Liabilities . Long TommiFixed Assets` Notes Payable* 15, 00 0. 00 Baking Equipment B.OOO . DO Total Long Term Liabilities : 15, 000. 00 Accumulated Depreciation B ZE. SB Not Fixed assets 7, 07 1 . 42 Total Liabilities .` 23, 56.9. 30 Common Stock ZO, OOO. OD Retained Earnings 50, 14 4. 84 Total Equity 70, 14 4. 84 Total ASSETS : 103, 8.14. 14 Total Liabilities & Equity 103, 8.14. 14Payton Approved Income Statement For Year Ended 12131/2016 Bakery Sales 21425 6. 14) Merchandise Sales TTO. TE Total REVENUES* 215. 0121. 24 Cost of Goods Sold - BakEd 12.150.50 Cost of Goods Sold - Merchandise 5-45. E` Total Cost of Goods Sold Gross Profit LA1, BIB. OIL Operating EXPENSES ! HEAT EXPENSE 15, 6^1. 23 WAVES EXPERTISE* CALL TE Misc. SuppliEs EXPIERCE L. FEB. 18 BUSINESS LICENSE EXPENSE Misc . EXPENSE LEFTECiation EXPERTISE INSURANCE EXPENSE $`7. 5 2 Advertising EXPIERCE Interest EXPENSE 521. 14 TELEphone EXPENSE* $11. 4` Total Operating EXPENSES ! 20.012.50 NET INCOME 1 12. 7.45. 15Current Ratio MWorking Capital ! Quick Ratio AIR Turnover Inventory Turnover Gross margin Return on Sales Return on Equity" Return on ASSETSPEYTON APPROVED PRO FORMA INFORMATION The company is planning to Open another location in 2018 . Prepare Pro forma financials for 201 8 for the new location using the following information :" 1 . Cost of leasing commercial Space : 5 1. 500 PER month . 12 . Cost of new Equipment : 515, OOO. USE Straight line depreciation assuming a SEVEN - Year life . USE full year's depreciation for the first \\Year . 3 . Cost of hiring and training new Employees : three at 5 25, 070 each for the first year . 4. EXCEPT as noted in S, assets, current liabilities, Sales, costs, and EXPENSES are EXPECTED to be GO` at the Existing store Ifrom preliminary statements / Except no stack. Retained Earnings = net income . 5. Cash: 57, 200. Accounts receivable amount to $. O turns laccounts receivable turnover will be $. OK; inventory amount to show 3. 0 turns (inventory turnover will be 3. 01. Ho stack will be issued . Retained earnings are to equal net income . Additional financing of \\5 5, 000 will be long-term . Add remaining amount needed to balance into accounts payable