On the Profit and Loss Report Combine all of the Cost of Goods information u

| March 31, 2017

Question
On the Profit and Loss Report

Combine all of the Cost of Goods information under the title ‘Cost of Goods Sold’ and delete the detail

Create a Pie Chart from the Expenses Section

Include the titles for the different expenses in the Legend

Insert the title ‘Expenses’

Save the Pie Chart as part of the ‘Profit and Loss’ Spreadsheet

On the Balance Sheet

Combine all the payroll tax obligations under ‘Payroll Liabilities’ and delete the detail.

On the Cash Flow Statement

Combine all the payroll tax obligations under ‘Payroll Liabilities’ and delete the detail.

Marlon’s Retail
Trial Balance
As of January 31, 2016

Cash-OCU Bank Account
Accounts Receivable
Prepaid Expenses
Prepaid Insurance
Inventory Asset
Equipment
Accumulated Depreciation
Accounts Payable
Accrued Wages Payable
Sales tax
Opening Balance Equity
Sales
Supplies & Materials COGS
Freight & delivery – COS
Purchases-COGS
Subcontractors-COGS
Advertising
Bank Charges
Commissions & fees
Insurance
Rent or Lease
Meals and Entertainment
Office Expenses
Utilities
TOTAL

Debit
###
###

Credit

###
###
###
###
125.00
###
###
###
125.00
###
###
150.00
###
500.00
600.00
25.00
250.00
###
###
750.00
###
425.00
###

###

esday, Feb 17, 2016 05:38:58 PM PST GMT-8 – Accrual Basis

Marlon’s Retail
Statement of Activity
January 2016
Total
Revenue
Sales
Total Revenue
Cost of Goods Sold
Supplies & Materials COGS
Freight & delivery – COS
Purchases-COGS
Subcontractors-COGS
Total Cost of Goods Sold
Gross Profit
Expenditures
Advertising
Bank Charges
Commissions & fees
Insurance
Rent or Lease
Meals and
Entertainment
Office Expenses
Utilities
Total Expenditures
Net Operating Revenue
Net Revenue

$
$

25,249.30
25,249.30
11,178.25
2,250.00
150.00
8,278.25
500.00
11,178.25
14,071.05

$
$
$

600.00
25.00
250.00
2,300.00
3,360.00
750.00
3,000.00
425.00
10,710.00
3,361.05
3,361.05

$

nesday, Feb 17, 2016 05:33:35 PM PST GMT-8 – Accrual Basis

Marlon’s Retail
Statement of Cash Flows
January 2016
Total
OPERATING ACTIVITIES
Net Revenue
Adjustments to reconcile Net Revenue to Net Cash
provided by operations:
Accounts Receivable
Prepaid Expenses
Prepaid Insurance
Inventory Asset
Equipment
Accumulated Depreciation
Accounts Payable
Accrued Wages Payable
Sales tax
Net cash provided by operating activities
$
FINANCING ACTIVITIES
Opening Balance Equity
Net cash provided by financing activities
-$
Net cash increase for period
$
Cash at end of period
$

Wednesday, Feb 17, 2016 05:40:21 PM PST GMT-8

3,361.05

-14,593.61
1,360.00
1,100.00
-19,142.50
-15,000.00
125.00
50,470.75
3,400.00
1,283.06
12,363.75
-125.00
125.00
12,238.75
12,238.75

Get a 30 % discount on an order above $ 50
Use the following coupon code:
COCONUT
Order your essay today and save 30% with the discount code: COCONUTOrder Now
Positive SSL