Question

In: Accounting

Based on the chart below, prepare the following: Prepare the following: -An income statement for 2015...

Based on the chart below, prepare the following:

Prepare the following:

-An income statement for 2015 and 2016

-A balance sheet for 2015 and 2016

-Operating cash flows for the two years

-Cash flows from assets in 2016

-Cash flows to creditors for 2016

-Cash flows to stockholders for 2016

2015 2016
Cost of Goods Sold    235,942 297,915
Cash      36,542 51,940
Depreciation      61,056 69,011
Interest Expense 13,877 15,905
Selling and Admin Exp 40,952 58,569
Accounts Payable 32,194 33,999
Net Fixed Assets 269,369 328,185
Sales 482,155 587,715
Accounts Receivable 24,120 24,089
Notes Payable 24,866 26,972
Long-Term Debt 142,148 161,000
Inventory 32,766 58,798
New Equity 0 16,000

Solutions

Expert Solution

1)

Income statement
2015 2016
Revenue 482155 587715
less:cost of goods sold (235942) (297915)
Gross margin 246213 289800
less:Operating expense
Depreciation expense (61056) (69011)
Selling and Admin Exp (40952) (58569)
Earning before Interest and tax 144205 162220
Less:Interest expense (13877) (15905)
Earning before tax 130328 146315

2)

Balance sheet
2015 2016
Asset
current asset
cash 36542 51940
Accounts receivable 24120 24089
Inventory 32766 58798
Total current asset 93428 134827
Net fixed asset 269369 328185
Total asset 362797 463012
Liabilities and stockholders equity
currentLiabilities
Accounts payable 32194 33999
Note payable 24866 26972
Long term debt 142148 161000
Total liabilities 199208 221971
Total equity [ 163589 [362797Total asset-199208] 241041     [463012-221971]
Total liabilities and equity 362797 463012

**Total equity =Total asset -total liabilities

3)Operating cash flow =EBIT +Depreciation -taxes

**since nO tax rate is given ,tax amount cannot be calculates

2015 :OCF = 144205+61056-0

       =205261

2016 :OCF = 162220+69011-0 =231231

4)**capital spending = ending fixed asset+ depreciation 2016 -beginning FA

         = 328185+69011-269369=127827

Working capital beginning = current asset -current liabilites

    = 93428-32194-24866

    = 36368

Ending working capital = 134827-33999-26972=73856

    Addition to NWC = 73856-36368 = 37488

Cash flows from assets in 2016 :operating cash Flow 2016 - Capital spending -addition to NWC

          = 231231 - 127827 - 37488

              = $ 65916

5)Cash flows to creditors for 2016 =Interest - [ending long term debt -beginning LTD]

      = 15905-[ 161000-142148]

      = 15905 -18852

     - 2947

6)Cash flows to stockholders for 2016 = cash flow from asset -cash flow to creditors

                  = 65916 - (-2947)

                  = 65916 +2947

                   = $ 68863

ekkarill92 answered 1 year ago
Next > < Previous

Related Solutions

Based on the trial balance below, prepare the Income Statement and the Balance Sheet for the...
Based on the trial balance below, prepare the Income Statement and the Balance Sheet for the year 2012. Please show your workings for the related questions below (yes, all together!). If your final answers (below) are incorrect, I'll review your workings to grant partial credit. Trial Balance as at 31st December 2012 Trial Balance Dr Cr Sales 240,000 Purchases 150,000 Returns inwards 5,000 Returns outwards 6,000 Carriage Inwards 3,000 Inventory 1.1.2012 80,000 Salaries 25,000 Electricity and telephone 4,000 Rent 5,000...
Question: Based on the information below info, prepare an income statement for 2018, statement of retained...
Question: Based on the information below info, prepare an income statement for 2018, statement of retained earnings for 2018, and a balance sheet on 12/31/2018 that makes sense based on the provided info. (Note: you can add additional info if desired. The below info is just the minimum required.) Background: Last year, you set up your own business in the merchandising sector. You lease a space of 6,000 square feet to open a luxury watch shop. The following is the...
Suppose you are given the following financial statement information.  Prepare an income statement for 2014 and 2015,...
Suppose you are given the following financial statement information.  Prepare an income statement for 2014 and 2015, and a Balance Sheet for 2014 and 2015.  Next, calculate the value of operating income (EBIT) in 2015.  (Round to 2 decimal places) 2014 2015 Cost of goods sold $3,753 4,591 Cash 1,200 1,608 Depreciation 684 877 Interest 53 133 Accounts payable 2,154 2,663 Total Equity 1,334 1,858 Sales 5,505 6,780 Accounts receivable 357 415 Long-term debt 1,636 2,078 Inventory 1,858 2,332 Tax rate 30% 30%...
Prepare a Horizontal Financial Statement for Albertsons in the chart below. Compare the Condensed statement to...
Prepare a Horizontal Financial Statement for Albertsons in the chart below. Compare the Condensed statement to Kroger (already listed). Financial Statement Analysis Project Alberstons Alberstons Condensed Financial Statements Kroger 2019 FY Kroger 2018 FY 2019 2018 Consolidated Balance Sheets Cash 1,610 1,508 Merchandise Inventory 6,846 6,533 Receivables 1,589 1,637 Other Current Assets 758 1,439 Total Current Assets 10,803 11,117 Property and Equipment, net 21,635 21,071 Other Assets 5,680 5,009 Total Assets 38,118 37,197 Total Current Liabilities 14,274 14,197 Total Long-Term...
- Based on the statement below, prepare a personal development plan based on this person's goals,...
- Based on the statement below, prepare a personal development plan based on this person's goals, please answer in paragraphs (maximum 1000 words) My goal is to become a leader in the construction industry. The construction industry is my passion, I have had 3 years of experience in fields such as formwork, aluminium window and door installation, general labouring on site and traffic control.
Use the balance sheet and income statement below to prepare a statement of cash flows for...
Use the balance sheet and income statement below to prepare a statement of cash flows for Valium’s Medical Supply Corporation. (Enter your answers in thousands. Amounts to be deducted should be indicated with a minus sign.) VALIUM’S MEDICAL SUPPLY CORPORATION Balance Sheet as of December 31, 2018 and 2017 (in thousands of dollars) Assets 2018 2017 Liabilities and Equity 2018 2017 Current assets: Current liabilities: Cash and marketable securities $ 79 $ 78 Accrued wages and taxes $ 60 $...
Use the information in the table below to construct an income statement for 2015 and balance...
Use the information in the table below to construct an income statement for 2015 and balance sheets for 2014 and 2015.  Then, find Operating Cash Flow, change in Net Working Capital, Net Capital Spending, Cash Flow to Creditors, Cash Flow to Shareholders, and Free Cash Flow.  The tax rate is 34% and the plowback ratio is 60%. 2014 2015 Sales 1700 Costs of Goods Sold 650 Depreciation Expense 200 Interest Expense 75 Total Fixed Assets 2200 3300 Accumulated Depreciation 400 Can be...
Use the information in the table below to construct an income statement for 2015 and balance...
Use the information in the table below to construct an income statement for 2015 and balance sheets for 2014 and 2015.  Then, find Operating Cash Flow, change in Net Working Capital, Net Capital Spending, Cash Flow to Creditors, Cash Flow to Shareholders, and Free Cash Flow.  The tax rate is 34% and the plowback ratio is 60%. 2014 2015 Sales 1700 Costs of Goods Sold 650 Depreciation Expense 200 Interest Expense 75 Total Fixed Assets 2200 3300 Accumulated Depreciation 400 Can be...
18. Based on the following account information, prepare a multi step statement of income. Cash: $50,000...
18. Based on the following account information, prepare a multi step statement of income. Cash: $50,000 Accrued expenses: $5,000 Accounts receivable: $70,000 Bad debt expense: $1,000 General and administrative expenses: $100,000 Net Sales: $900,000 Costs of goods sold: $200,000 Selling expenses: $90,000 Income tax expense: $3,000 Interest expense: $5,000 Interest receivable: $5,000 Retained earnings: $80,000 Accumulated depreciation: $5,000 Depreciation expense: $1,000 Earnings per share: $100 Common stock: $50,000
Using the adjusted trial balance below, prepare an income statement, statement of retained earnings, and a...
Using the adjusted trial balance below, prepare an income statement, statement of retained earnings, and a balance sheet as of December 31. Download the Excel spreadsheet located in the instructions and use it as a template for your financial statements. Once you have completed the statements, save the file and upload the completed spreadsheet for grading. Parties Plus, Inc. Adjusted Trial Balance December 31 Debit Credit Cash $1,600 Accounts receivable 4,000 Office equipment 16,800 Accumulated depreciation $1,600 Income tax payable...
ADVERTISEMENT
Subjects
ADVERTISEMENT
Latest Questions
ADVERTISEMENT