Use the scenario infromation provided and the information in the tables here to complete the rest of the tables and pro forma.

Overview: You just began a position as a financial accountant at Peyton Approved. In this role, your first task is to prepare the companys 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.

Refer to the data below and use the Final Project Workbook that includes the income statement, balance sheet, retained earnings statement and cash flow statement to complete the final project and associated milestones.

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.

A supplier shipped $3,000 of ingredients on 12/29/17. Peyton receives an invoice for the goods, as well as a bill for freight for $175, all dated 12/29/17. Goods were shipped FOB suppliers warehouse.

At 12/31/17, Peyton has $200 worth of merchandise on consignment at Brunos House of Bacon.

On 12/23/17, Peyton received $1,000 deposit from Pet Globe for product to be shipped by Peyton in the second week of January.

On 12/03/2017, a mixer with a 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.

Note about later borrowing - financials will show loan from parents repaid and use of bank financing.

For notes to the financial statements and Management Analysis Memo, consider the following:

Peyton Approved uses the following accounting practices:

Inventory: Periodic, LIFO for both baking and merchandise

Baking supplies: $27,850 ending inventory

Equipment: Straight line method used for equipment

Business Financing Information: Use this information to calculate interest rates and insurance information, and to assess their impact on the companys financial obligations:

6% interest note payable was made on Jan 31, 2017, and is due Feb 1, 2019.

5-year loan was made on June 1, 2016. Terms are 7.5% annual rate, interest only until due date.

Insurance: Annual policy covers 12 months, purchased in February, covering March 2017 to February 2018. No monthly adjustments have been made.

Statement of cash Flow
For Year Ended 12/31/2017
Net Income				$175,576.18
Depreciation Expense				677.86
					176,254.04
Increase in Accounts Receivable					(25,886.91)
Increase in Baking Supplies					(8,187.84)
Increase in Merchandise inventory					(443.10)
Increase in Prepaid Rent					(449.55)
Increase in Prepaid Insurance					(1,004.55)
Increase in Misc. Supplies					(114.99)
Increase in Accounts Payable					3,292.11
Increase in Wages Payable					1,850.48
Increase in Interest Payable					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					(10,000.00)
Dividends Paid					(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

Please fill in the blank for me in this format, and please make it legible if done on paper. Thank you!

I mainly need help with the revised cash flow statement.

Peyton Approved
Statement of cash Flow
For Year Ended 12/31/2017

1. Prepare the adjusted trial balance in the following manner: Adjusted Trial Balance Unadjusted Trial Balance | Dr. $67,520.04 $68,519.91 Adjustments Dr. Cr $1,000.00 Dr. $700.00 $3,000.00 $15,506.70 $1,238.07 $200.000 $68,520.04 $68,519.91 $700.00 $18,506.70 $1,038.07 $200.00 $2,114.55 $2,114.55 $170.49 $12,000.00 $200.00 $2,114.55 $2,114.55 $170.49 $14,000.00 $2,000.00|| $1,606.44 $1,200.00 $1,000.00 $3,175.000 Account Title Cash Accounts Receivable Other Receivable - Insurance Baking Supplies Merchandise Inventory Consignment Inventory Prepaid Rent Prepaid Insurance Misc. Supplies Baking Equipment Accumulated Depreciation Customer Deposit Accounts Payable Wages Payable Interest Payable Notes Payable Common Stock Beginning Retained earnings Dividends Bakery Sales Merchandise Sales Cost of Goods Sold - Baked Cost of Goods Sold - Merchandise Rent Expense Wages Expense Miscellaneous Supplies Expense Business License Expense Misc. Expense Depreciation Expense Insurance Expense Advertising Expense Interest Expense Telephone Expense Gain/Loss on disposal of equipment TOTAL $20.262.111 $3,383.28 $211.46 $5,000.00 $20,000.00 $50,144.84 $406.44 $1,000.00 $23,437.11 $3,383.28 $211.46 $5,000.00 $20,000.00 $50,144.84 $105,000.00 S105,000.00 $327,322.551 $1,205.641 $327,322.55 $1,205.64 $105,834.29 $859.77 $24,549.19 $10,670.72 $3,000.46 $2,045.77 $1,363.84 $677.86 $1,091.08 $1,549.74 S818.31 $490.98 $175.00 $105.834.29 $859.77 $24,549.19 $10,670.72 $3.000.46 $2,045.77 $1,538.84 $677.86 $1,091.08 $1,549.74 $818.31 $490.98 $100.00 $6,375.000 $432,111.32 $100.00 $6,375.00 429,136.32 $429,136.32|| $432,111.32 1. Prepare the adjusted trial balance in the following manner: Adjusted Trial Balance Unadjusted Trial Balance | Dr. $67,520.04 $68,519.91 Adjustments Dr. Cr $1,000.00 Dr. $700.00 $3,000.00 $15,506.70 $1,238.07 $200.000 $68,520.04 $68,519.91 $700.00 $18,506.70 $1,038.07 $200.00 $2,114.55 $2,114.55 $170.49 $12,000.00 $200.00 $2,114.55 $2,114.55 $170.49 $14,000.00 $2,000.00|| $1,606.44 $1,200.00 $1,000.00 $3,175.000 Account Title Cash Accounts Receivable Other Receivable - Insurance Baking Supplies Merchandise Inventory Consignment Inventory Prepaid Rent Prepaid Insurance Misc. Supplies Baking Equipment Accumulated Depreciation Customer Deposit Accounts Payable Wages Payable Interest Payable Notes Payable Common Stock Beginning Retained earnings Dividends Bakery Sales Merchandise Sales Cost of Goods Sold - Baked Cost of Goods Sold - Merchandise Rent Expense Wages Expense Miscellaneous Supplies Expense Business License Expense Misc. Expense Depreciation Expense Insurance Expense Advertising Expense Interest Expense Telephone Expense Gain/Loss on disposal of equipment TOTAL $20.262.111 $3,383.28 $211.46 $5,000.00 $20,000.00 $50,144.84 $406.44 $1,000.00 $23,437.11 $3,383.28 $211.46 $5,000.00 $20,000.00 $50,144.84 $105,000.00 S105,000.00 $327,322.551 $1,205.641 $327,322.55 $1,205.64 $105,834.29 $859.77 $24,549.19 $10,670.72 $3,000.46 $2,045.77 $1,363.84 $677.86 $1,091.08 $1,549.74 S818.31 $490.98 $175.00 $105.834.29 $859.77 $24,549.19 $10,670.72 $3.000.46 $2,045.77 $1,538.84 $677.86 $1,091.08 $1,549.74 $818.31 $490.98 $100.00 $6,375.000 $432,111.32 $100.00 $6,375.00 429,136.32 $429,136.32|| $432,111.32