On July 1, 2020, Matthew Victor opened a retail postal store. During July, the follo transactions were completed:

FINANCIAL ACCOUNTING
10th Edition
ISBN:9781259964947
Author:Libby
Publisher:Libby
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
icon
Related questions
Question
Please do the required and bonus either way and please all the tables to be copy and pasted to a word document so I can edit
EB Multiple Pages
Zoom Zoom
to 100%
New Arrange Split
Window
Switch
Windows
Macros
Pane
Page Width
All
On July 1, 2020, Matthew Victor opened a retail postal store. During July, the following
transactions were completed:
July 2020
Matthew invested $30,000 cash in his business, The Mail Shop. In return,
he received capital stock.
Paid $700 for copy supplies
Purchased office equipment for $1,000 cash.
Paid $900 for July rent.
Paid a premium for $360 for an insurance policy for 24 months on the
office equipment, beginning July 1.
Purchased $500 of copy supplies on account.
Received $4,500 cash from a customer for postal fees for mailings.
Completed mailings and sent out bills totaling $2,000 for postal fees.
Wages earned by employees for the pay period July 5 through July 19 was
$250. On this date, the wages were recorded for the July 5-19 pay period,
but will not be paid to the employees until July 31.
Paid creditors on account, $200
Received cash from customers on account, $800
Declared and paid cash dividends of $200.
1
3
4
8.
14
18
22
23
26
31
Additional information as of July 31, 2020:
a) A physical count shows copy supplies on hand total $300.
b) The depreciation on office equipment for the month of July is $25.
Hint: There are three adjusting entries for the month of July.
Required: Prepare the transaction and adjusting entries for the month of July using one
of the following methods; traditional journal entry (debit/credit) method or columnar
(spreadsheet) accounting equation method. Prepare an income statement and balance
sheet, in proper form, for the month of July 2020.
Bonus: Prepare an income statement and balance sheet for the month of July on EXCEL,
You must begin by listing all accounts and their balances (or prepare an adjusted trial
balance) in EXCEL.
E Focus
Transcribed Image Text:EB Multiple Pages Zoom Zoom to 100% New Arrange Split Window Switch Windows Macros Pane Page Width All On July 1, 2020, Matthew Victor opened a retail postal store. During July, the following transactions were completed: July 2020 Matthew invested $30,000 cash in his business, The Mail Shop. In return, he received capital stock. Paid $700 for copy supplies Purchased office equipment for $1,000 cash. Paid $900 for July rent. Paid a premium for $360 for an insurance policy for 24 months on the office equipment, beginning July 1. Purchased $500 of copy supplies on account. Received $4,500 cash from a customer for postal fees for mailings. Completed mailings and sent out bills totaling $2,000 for postal fees. Wages earned by employees for the pay period July 5 through July 19 was $250. On this date, the wages were recorded for the July 5-19 pay period, but will not be paid to the employees until July 31. Paid creditors on account, $200 Received cash from customers on account, $800 Declared and paid cash dividends of $200. 1 3 4 8. 14 18 22 23 26 31 Additional information as of July 31, 2020: a) A physical count shows copy supplies on hand total $300. b) The depreciation on office equipment for the month of July is $25. Hint: There are three adjusting entries for the month of July. Required: Prepare the transaction and adjusting entries for the month of July using one of the following methods; traditional journal entry (debit/credit) method or columnar (spreadsheet) accounting equation method. Prepare an income statement and balance sheet, in proper form, for the month of July 2020. Bonus: Prepare an income statement and balance sheet for the month of July on EXCEL, You must begin by listing all accounts and their balances (or prepare an adjusted trial balance) in EXCEL. E Focus
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps

Blurred answer
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
FINANCIAL ACCOUNTING
FINANCIAL ACCOUNTING
Accounting
ISBN:
9781259964947
Author:
Libby
Publisher:
MCG
Accounting
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
Accounting Information Systems
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis…
Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON
Intermediate Accounting
Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education
Financial and Managerial Accounting
Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education