You just began a position as a financial accountant at Peyton Approved. In this role, your first
Fantastic news! We've Found the answer you've been seeking!
Question:
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. | |||||||||||
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 (BS 2017 Revised tab) | |||||||||||
Income Statement (IS 2017 Revised tab) | |||||||||||
Retained Earnings Statement (RE 2017 Revised tab) | |||||||||||
Statement of Cash Flows (CF 2017 Revised tab) | |||||||||||
The company is planning to open another location in 2018. Using the Preliminary Statements as a base, prepare pro forma (budgeted) financials for 2018 for the new location using the following information.
Transcribed Image Text:
Peyton Approved Statement of cash Flow For Year Ended 12/31/2017 Net Income Depreciation Expense Gain/Loss on Disposal of Equipment Increase in Accounts Receivable Increase in Other Receivables-Insurance Increase in Baking Supplies Increase in Merchandise inventory Increase in Consignment Inventory Increase in Prepaid Rent Increase in Prepaid Insurance Increase in Miso. Supplies Increase in Accounts Payable Increase in Wages Payable Increase in Interest Payable Increase in Customer Deposit Operating Cash Flow Cash Flow from Investments Equipment Purchases 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 $ $ 43,165.39 68,520.04 $ $ $ $ $ (25,866.91) (700.00) (11,362.84) (243.10) (200.001 (449.55) (1,004.55) (114.99) 6.467.11 1,850.48 44.96 $ 1,000.00 $ (30,579.39) 175,476.18 677.86 100.00 $ $ $ $ $ $ $ $ $ $ (6,000.00) $(10,000.00) $ (105,000.00) $ 176,254.04 $ 145,519.37 $ (6,000.00) $(115,000.00) $ 24,519.37 Current Assets: Cash Accounts Receivable Baking Supplies Merchandise Inventory Prepaid Rent Prepaid Insurance Misc. Supplies Total Current Assets Long Tem/Fixed Assets Baking Equipment Assets Accumulated Depreciation Net Fixed assets Total Assets Current Assets Cash Assets Account Receivable Other Receivable Insurance Baking Supplies Merchadise Inventory Consignment Inventory Prepaid Rent Prepaid Insurance Msc Supplies Total Current Assets Long Tem/Fixed Assets laking Equipmert Total Assets Accumulated Depreciation Net Fixed assets 43,105.39 42,633.00 7,318 90 794.97 1,005.00 1,110.00 55.50 8,000.00 -908.58 68,520.04 68,519.91 700.00 18,061.70 1,038.07 200 00 2,114.56 2,114.55 170.49 12,000.00 (400.44) Peyton Approved Balance Sheet As of December 31, 2016 96,742.72 7,07142 103,81414 Peyton Approved Balance Sheet As of December 31, 2017 162,059.31 11.593.50 $ 173.66287 Liabilities and Owners Equity Current Liabilities: Accounts Payable Wages Payable Interest Payable Total Current Liabilities Long Term Liabilities: Notes Payable Total Long Term Liabilities: Total Liabilities: Common Stock Retained Earnings Total Equity Total Liabilities & Equity Current Liabilities Accounts Payable Wages Payable Interest Payable Customer Deposit Liabilities Total Current Liabilities Long Term Liabilities: Notes Payable Total Long Term Liabilities: Total Liabilities Common Stock Retained Earnings Total Equity Total Liabilities & Equity 16,970.00 1,532.80 106.50 15,000.00 20,000.00 50,144.84 23,437,11 3,383.28 211.40 1,000.00 5,000.00 20.000.00 120,621.02 18,669.30 15,000.00 33,669.30 70,14484 103,81414 28,03185 5,000.00 33,031.85 140.621.02 173,65287 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 O 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 Misc Supplies Expense Business License Expense Misc. Expense Depreciation Expense Insurance Expense Advertising Expense Interest Expense Telephone Expense Gain/Loss on disposal of equipment Unadjusted trial balance Dr Cr 67,520.04 68,519.91 15,506.70 1,238.07 2,114.55 2,114 55 170.49 14,000.00 105,000.00 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 818.31 490.98 PEYTON APPROVED TRIAL BALANCE As of December 31, 2017 429,136.32 1,606.44 20,262.11 3.383.28 211.46 5,000.00 20,000.00 50,144.84 327,322.55 1,205.64 429,136.32 ref Adjusting entries Cr Dr 1,000.00 700.00 3,175.00 200.00 1,200.00 100.00 6,375.00 200.00 2.000.00 1.000.00 3.175.00 6,375.00 ref Cr Adjusted trial balance Dr 68.520.04 68,519.91 700.00 18.681.70 1.038.07 200.00 2,114.55 2,114.55 170.49 12,000.00 105,000.00 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 818 31 490.98 100.00 432.111.32 406 44 1,000.00 23.437.11 3.383 28 211.46 5.000.00 20,000.00 50,144.84 327,322.55 1205.64 432,111.32 Peyton Approved Statement of cash Flow For Year Ended 12/31/2017 Net Income Depreciation Expense Gain/Loss on Disposal of Equipment Increase in Accounts Receivable Increase in Other Receivables-Insurance Increase in Baking Supplies Increase in Merchandise inventory Increase in Consignment Inventory Increase in Prepaid Rent Increase in Prepaid Insurance Increase in Miso. Supplies Increase in Accounts Payable Increase in Wages Payable Increase in Interest Payable Increase in Customer Deposit Operating Cash Flow Cash Flow from Investments Equipment Purchases 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 $ $ 43,165.39 68,520.04 $ $ $ $ $ (25,866.91) (700.00) (11,362.84) (243.10) (200.001 (449.55) (1,004.55) (114.99) 6.467.11 1,850.48 44.96 $ 1,000.00 $ (30,579.39) 175,476.18 677.86 100.00 $ $ $ $ $ $ $ $ $ $ (6,000.00) $(10,000.00) $ (105,000.00) $ 176,254.04 $ 145,519.37 $ (6,000.00) $(115,000.00) $ 24,519.37 Current Assets: Cash Accounts Receivable Baking Supplies Merchandise Inventory Prepaid Rent Prepaid Insurance Misc. Supplies Total Current Assets Long Tem/Fixed Assets Baking Equipment Assets Accumulated Depreciation Net Fixed assets Total Assets Current Assets Cash Assets Account Receivable Other Receivable Insurance Baking Supplies Merchadise Inventory Consignment Inventory Prepaid Rent Prepaid Insurance Msc Supplies Total Current Assets Long Tem/Fixed Assets laking Equipmert Total Assets Accumulated Depreciation Net Fixed assets 43,105.39 42,633.00 7,318 90 794.97 1,005.00 1,110.00 55.50 8,000.00 -908.58 68,520.04 68,519.91 700.00 18,061.70 1,038.07 200 00 2,114.56 2,114.55 170.49 12,000.00 (400.44) Peyton Approved Balance Sheet As of December 31, 2016 96,742.72 7,07142 103,81414 Peyton Approved Balance Sheet As of December 31, 2017 162,059.31 11.593.50 $ 173.66287 Liabilities and Owners Equity Current Liabilities: Accounts Payable Wages Payable Interest Payable Total Current Liabilities Long Term Liabilities: Notes Payable Total Long Term Liabilities: Total Liabilities: Common Stock Retained Earnings Total Equity Total Liabilities & Equity Current Liabilities Accounts Payable Wages Payable Interest Payable Customer Deposit Liabilities Total Current Liabilities Long Term Liabilities: Notes Payable Total Long Term Liabilities: Total Liabilities Common Stock Retained Earnings Total Equity Total Liabilities & Equity 16,970.00 1,532.80 106.50 15,000.00 20,000.00 50,144.84 23,437,11 3,383.28 211.40 1,000.00 5,000.00 20.000.00 120,621.02 18,669.30 15,000.00 33,669.30 70,14484 103,81414 28,03185 5,000.00 33,031.85 140.621.02 173,65287 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 O 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 Misc Supplies Expense Business License Expense Misc. Expense Depreciation Expense Insurance Expense Advertising Expense Interest Expense Telephone Expense Gain/Loss on disposal of equipment Unadjusted trial balance Dr Cr 67,520.04 68,519.91 15,506.70 1,238.07 2,114.55 2,114 55 170.49 14,000.00 105,000.00 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 818.31 490.98 PEYTON APPROVED TRIAL BALANCE As of December 31, 2017 429,136.32 1,606.44 20,262.11 3.383.28 211.46 5,000.00 20,000.00 50,144.84 327,322.55 1,205.64 429,136.32 ref Adjusting entries Cr Dr 1,000.00 700.00 3,175.00 200.00 1,200.00 100.00 6,375.00 200.00 2.000.00 1.000.00 3.175.00 6,375.00 ref Cr Adjusted trial balance Dr 68.520.04 68,519.91 700.00 18.681.70 1.038.07 200.00 2,114.55 2,114.55 170.49 12,000.00 105,000.00 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 818 31 490.98 100.00 432.111.32 406 44 1,000.00 23.437.11 3.383 28 211.46 5.000.00 20,000.00 50,144.84 327,322.55 1205.64 432,111.32
Expert Answer:
Answer rating: 100% (QA)
Required solution is given below ANSWER Calculations for 2016 Current RatioWorking Capital Values ta... View the full answer
Related Book For
Posted Date:
Students also viewed these accounting questions
-
Complete the Adjusted Trial Balance as of December 31, 2016 using the given information. Enter accounts in order of assets, liabilities, common stock, dividends, revenues, and expenses. Assume all...
-
Using the data set CarPrice, carry out the following question: a. Construct a table that show the sample mean, standard deviation, and minimum and maximum values for each variable. b. Construct a...
-
9. Calculating an installment loan payment using the add-on method Calculating the Loan Payment on an Add-On Interest Installment Loan Installment loans allow borrowers to repay the loan with...
-
How would you apply this concepts to call center statistics? There are two numerical ways of describing quantitative variables, namely measures of location, and measures of dispersion. Measures of...
-
Consider the time-varying process behavior shown below. Match each of these several patterns of process performance to the corresponding and R charts shown in Figures (a) to (e) below. Control Chart...
-
A smoothly contoured nozzle, with outlet diameter \(d=20 \mathrm{~mm}\), is coupled to a straight pipe by means of flanges. Water flows in the pipe, of diameter \(D=50 \mathrm{~mm}\), and the nozzle...
-
Scientific uncertainty about emissions data can be large. The precautionary principle suggests that decision-makers err on the side of caution when there is scientific uncertainty. Examine the data...
-
(a) Your roommate says, Sales taxes are reported as an expense in the income statement. Do you agree? Explain. (b) Pearls Cafe has cash proceeds from sales of $8,550. This amount includes $550 of...
-
a. Prepare a differential analysis dated September 14 to determine if Socks should be continued (Alternative 1) or discontinued (Alternative 2). If an amount is zero, enter "0". If required, use a...
-
Suppose that you are a retailer, and you would like to design your own Supply Chain to launch a new products in a competitive environment. You will procure such a product from a wholesaler who will...
-
Choose a real or fictional company or other organization of interest to you. In our scenario, the organization is conducting a search for a new chief executive officer (CEO). As a board member of...
-
Maximum Revenue A small theater has a seating capacity of 2.000. When the ticket price is $10, attendance is 1,500. After a price decrease of $2, however, the attendance increased to 1,700. Assuming...
-
Whether the 4P framework a brand marketing strategy or a tactic? If 4P is the brand marketing strategy, could u based on this framework , talk about how Victoria secret to grow Australia lingerie...
-
Consider the following binary relation 5, defined over the set of all NFAs by setting, for any NFAs M1, M2: M M iff L(M) C L(M2) That is, M M2 iff the language recognised by M is a subset of the...
-
Consider the role of narrative closure in shaping reader satisfaction and thematic resonance. How do authors like Gabriel Garca Mrquez or Haruki Murakami subvert traditional notions of closure to...
-
What is the difference between brand marketing and direct marketing? When do you use brand marketing? When do you use direct marketing? Which can be measured and how? Name a company that makes...
-
You buy a computer game for $ 5 0 using your credit card, receive $ 9 0 in wages from your casual job and you receive $ 2 0 in interest on a savings account. Calculate the overall effect of these...
-
Cleaning Service Company's Trial Balance on December 31, 2020 is as follows: Account name Debit Credit Cash 700 Supplies Pre-paid insurance Pre-paid office rent Equipment Accumulated depreciation -...
-
The notes to a recent annual report from Weebok Corporation included the following: Business Acquisitions During the current year, the Company acquired the assets of Sport Shoes, Inc. . . . Assume...
-
Sterling Steel Inc. purchased a new stamping machine at the beginning of the year at a cost of $580,000. The estimated residual value was $60,000. Assume that the estimated useful life was five...
-
GameStop issued the following press release when the companys stock was selling for $27 per share: GRAPEVINE, Texas(BUSINESS WIRE)Feb. 12, 2007GameStop Corp. (NYSE: GME), the worlds largest video...
-
Part of the water supply for the South Rim of Grand Canyon National Park is taken from the Colorado River [54]. A flow rate of \(600 \mathrm{gpm}\) taken from the river at elevation \(3734...
-
Consider the pump and piping system of Problem 10.51. Estimate the percentage reductions in volume flow rate that occur after (a) 20 years (b) 40 years of use, if the pump characteristics remain...
-
Consider the pump and piping system of Problem 10.50. Determine the volume flow rate and gate valve loss coefficient for the case of two identical pumps installed in parallel. Data From Problem 10.50...
Study smarter with the SolutionInn App