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...
-
n = 1000, p = 0.103 Describe the sampling distribution of . Assume that the size of the population is 25,000 for each problem.
-
Consider the following items of income and expense and state: whether they bear a relationship to each other or not; if they are related in any way, in what way they should move in relation to each...
-
The proper sequence of activities in the systems development life cycle is a. Design, analysis, implementation, and operation. b. Design, implementation, analysis, and operation. c. Analysis, design,...
-
In well-governed companies, a sense of accountability and ethical leadership create a culture that places organizational ethics above all else. What role does organizational culture play in...
-
Prepare a flexible budget for JKL Inc. based on the following data for the month of March 2024: Particulars Actual ($) Flexible ($) Sales Revenue $100,000 - Variable Costs $40,000 $35,000 Fixed Costs...
-
The following transactions occurred for Ward Technology Solutions: May 1 The business received cash of $ 75,000 and issued common stock to Zoe Ward. 2 Purchased office supplies on account, $ 500. 4...
-
Consultex, Incorporated, was founded in 2 0 1 8 as a small financial consulting business. The company had done reasonably well from 2 0 1 8 through 2 0 2 0 but started noticing its cash dwindle early...
-
Discuss the mechanisms of genetic recombination during meiosis, emphasizing the role of crossover events in generating genetic diversity among gametes .
-
The Tasha Corporation needs a new pipe-boring machine that can be purchased for $10,000.The machine will be depreciated using MACRS with a 5-year class.Tasha will use the machine for 5 years and then...
-
How does epistasis influence the phenotypic expression of genes, and what are the implications of gene interactions on genetic inheritance patterns and trait variability ?
-
Houston Health insurance company currently adopts a zero-debt financing. Its operating income (EBIT) is $2 million, and its tax bracket is at the 40 percent rate. It has 6 million in assets and...
-
Sandhill Pharma just received revenues of $3,164,900 in Australian dollars (A$). Management has the following exchange rates: A$2.8100/ and $2.2458/. What is the U.S. dollar value of the company's...
-
Topic 6 Assignment 10 0.6 points Skipped Saved Julio and Milania are owners of Falcons Corporation, an S corporation. Each owns 50 percent of Falcons Corporation. In year 2, Julio and Milania each...
-
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...
-
Explain how corporate performance is affected by employee motivation and goal congruence.
-
Understand a management control system and how it relates to organizational goals.
-
Form groups of two to six persons each. The groups should each select a simple product or service. Be creative, but do not pick a product or service that is too complex. For those having difficulty...
Study smarter with the SolutionInn App