In: Accounting
The general ledger of Jay Consulting shows the following balances at July 31
Cash $4,440
Accounts Receivable 5,780
Prepaid Rent 1,200
Accounts Payable 2,850
Salaries Payable 475
Jay Blue, Capital 7,486
Jay Blue, Drawing 2,000
Consulting Fees 6,920
Rent Expense 600
Salary Expense 2,600
Supplies Expense 755
Utilities Expense 196
Miscellaneous Expense 160
The general ledger of Jay Consulting shows the following balances at August 31
Cash $7,527
Accounts Receivable 4,287
Prepaid Rent 600
Accounts Payable 1,495
Salaries Payable 400
Jay Blue, Capital 8,095
Jay Blue, Drawing 1,800
Consulting Fees 8,820
Rent Expense 600
Salary Expense 2,800
Supplies Expense 950
Utilities Expense 221
Miscellaneous Expense 25
Make a template start with a Trial Balance
The template should be connected to the financial statements: Income Statement, Statement of Owner's Equity, Balance Sheet
Requirements: Two sets of Financial July 31 and Aug 31
1) Answer question: How is the Company doing? (size of company, possible industry)
2) Complete a Comparative analysis for July and August
3) Create two chart
a) Pie chart showing the percentage of each assets to total assets
b) Second chart may not be a Pie chart. The chart can be of your choosing but the chart must support question "How is the company doing?"
Thank you a lot in advance. Hope you guys can help me. Wish you guys all the best
Trial Balance | as on August, 31 | as on July, 31 |
Particulars | Debit (in $) | Credit (in $) | Debit (in $) | Credit (in $) |
Cash | 7,527 | - | 4,440 | - |
Accounts Receivable | 4,287 | - | 5,780 | - |
Prepaid Rent | 600 | - | 1,200 | - |
Accounts Payable | - | 1,495 | - | 2,850 |
Salaries Payable | - | 400 | - | 475 |
Jay Blue Capital | - | 8,095 | - | 7,486 |
Jay Blue Drawings | 1,800 | - | 2,000 | - |
Consulting Fees | - | 8,820 | - | 6,920 |
Rent Expense | 600 | - | 600 | - |
Salary Expense | 2,800 | - | 2,600 | - |
Supplies Expense | 950 | - | 755 | - |
Utilities Expense | 221 | - | 196 | - |
Miscellaneous Expense | 25 | - | 160 | - |
Total | 18,810 | 18,810 | 17,731 | 17,731 |
Financial Statements | ||||
Income Statement | For period ending 31 August | For period ending 31 July | Absolute Change | Change in % |
INCOME | ||||
Revenue | ||||
Consulting Revenue | 8,820 | 6,920 | 1,900 | 27% |
Other Income | - | - | - | |
- | ||||
Total Revenue | 8,820 | 6,920 | 1,900 | 27% |
- | ||||
EXPENSES | - | |||
Rent Expense | 600 | 600 | - | 0% |
Salary Expense | 2,800 | 2,600 | 200 | 8% |
Supplies Expense | 950 | 755 | 195 | 26% |
Utilities Expense | 221 | 196 | 25 | 13% |
Miscellaneous Expense | 25 | 160 | (135) | -84% |
- | ||||
Total Expenses | 4,596 | 4,311 | 285 | 7% |
- | ||||
Profit ( Excess of Revenue over Expenses) | 4,224 | 2,609 | 1,615 | 62% |
Statement of Owners Equity | For period ending 31 August | For period ending 31 July |
Opening Capital | 8,095 | 7,486 |
Add - | ||
Profit credited during period ( as per Income statement) | 4,224 | 2,609 |
Less - | ||
Drawings during period | 1,800 | 2,000 |
Closing Capital | 10,519 | 8,095 |
Balance Sheet | As on August, 31 | As on July 31 |
ASSETS | ||
Current Assets | ||
Accounts Receivable | 4,287 | 5,780 |
Prepaid Expenses | 600 | 1,200 |
Cash | 7,527 | 4,440 |
Total | 12,414 | 11,420 |
EQUITY AND LIABILITIES | ||
Owners Capital | 10,519 | 8,095 |
Current Liabilities | ||
Accounts Payable | 1,495 | 2,850 |
Related SolutionsQ3 / On July 31, 2018, the general ledger of Sandhill Inc. showed these balances: Cash...Q3 / On July 31, 2018, the general ledger of Sandhill
Inc. showed these balances: Cash $3,980; Accounts Receivable
$1,490; Supplies $550; Equipment $4,970; Accounts Payable $4,090;
Common Shares $3,500; and Retained Earnings $3,400. During August,
the following transactions occurred:
Aug.
2
Collected $1,190 of accounts receivable due from
customers.
3
Received $1,300 for issuing common shares to new
investors.
6
Paid $2,680 on accounts payable owing.
7
Earned fees of $6,500, of which $3,000 was collected in
cash and...
On July 31, 20Y7, the balances of the accounts appearing in the ledger of Yang Interiors...On July 31, 20Y7, the balances of the accounts appearing in the
ledger of Yang Interiors Company, a furniture wholesaler, are as
follows:
Accumulated Depreciation-Building
$443,000
Administrative Expenses
534,000
Building
984,000
Cash
95,000
Cost of Merchandise Sold
941,000
Interest Expense
7,000
Merchandise Inventory
140,000
Notes Payable
121,000
Peter Bronsky, Capital
644,000
Peter Bronsky, Drawing
18,000
Sales
1,745,000
Sales Tax Payable
4,500
Selling Expenses
194,000
Store Supplies
19,000
Store Supplies Expense
25,500
Required:
Prepare the July 31, 20Y7, closing entries for...
1) Donaldson Company has the following accounts in its general ledger at July 31: Accounts Receivable...1) Donaldson Company has the following accounts in its general
ledger at July 31: Accounts Receivable $40,000 and Allowance for
Doubtful Accounts $2,500. During August, the following transactions
occurred.
Oct. 15 Sold
$30,000 of accounts receivable to Fast Factors, Inc. who assesses a
3% finance charge.
25 Made
sales of $900 on Visa credit cards. The credit card service charge
is 2%.
Instructions
Journalize the transactions.
2)
Indicate whether each of the following expenditures should be
classified as land (L), land improvements (LI),...
On July 31, 2022, the general ledger of Sunland Legal Services Inc. showed the following balances:...On July 31, 2022, the general ledger of Sunland Legal Services
Inc. showed the following balances: Cash $3,520, Accounts
Receivable $1,320, Supplies $440, Equipment $4,400, Accounts
Payable $3,610, Common Stock $3,080, and Retained Earnings $2,990.
During August, the following transactions occurred.
Aug. 3
Collected $1,060 of accounts
receivable due from customers.
5
Received $1,140 cash for issuing
common stock to new investors.
6
Paid $2,380 cash on accounts
payable.
7
Performed legal services of $5,720,
of which $2,640 was collected...
On July 31, 2022, the general ledger of Sunland Legal Services Inc. showed the following balances:...On July 31, 2022, the general ledger of Sunland Legal Services
Inc. showed the following balances: Cash $3,520, Accounts
Receivable $1,320, Supplies $440, Equipment $4,400, Accounts
Payable $3,610, Common Stock $3,080, and Retained Earnings $2,990.
During August, the following transactions occurred.
Aug. 3
Collected $1,060 of accounts
receivable due from customers.
5
Received $1,140 cash for issuing
common stock to new investors.
6
Paid $2,380 cash on accounts
payable.
7
Performed legal services of $5,720,
of which $2,640 was collected...
On January 31, 2019, the general ledger of Palmer Company showed the following account balances. ACCOUNTS...On January 31, 2019, the general ledger of Palmer Company showed
the following account balances.
ACCOUNTS
Cash
61,400
Accounts Receivable
20,900
Supplies
7,400
Prepaid Insurance
6,600
Equipment
89,900
Accum. Depr.—Equip.
0
Accounts Payable
15,100
Sadie Palmer, Capital
80,350
Fees Income
109,000
Depreciation Exp.—Equip.
0
Insurance Expense
0
Rent Expense
9,000
Salaries Expense
9,250
Supplies Expense
0
Additional information:
Supplies used during January totaled
$4,900.
Expired insurance totaled $1,650.
Depreciation expense for the month was $1,425.
Complete the worksheet through the...
Spielberg Company's general ledger shows a checking account balance of $22,910 on July 31, 2021Exercise 4-9A Calculate the balance of cash using a bank reconciliation (LO4-5) Spielberg Company's general ledger shows a checking account balance of $22,910 on July 31, 2021. The July cash receipts of $1,825, included in the general ledger balance, are placed in the night depository at the bank on July 31 and processed by the bank on August 1. The bank statement dated July 31 shows bank service fees of $49. The bank processes all checks written by the company by...
Spielberg Company's general ledger shows a checking account balance of $22,880 on July 31, 2021. The...Spielberg Company's general ledger shows a checking account
balance of $22,880 on July 31, 2021. The July cash receipts of
$1,795, included in the general ledger balance, are placed in the
night depository at the bank on July 31 and processed by the bank
on August 1. The bank statement dated July 31 shows bank service
fees of $46. The bank processes all checks written by the company
by July 31 and lists them on the bank statement, except for...
The following selected list of accounts with their normal balances was taken from the general ledger...The following selected list of accounts with their normal
balances was taken from the general ledger of Windsor Company as of
December 31, 2013: Common stock, $1 par Winsor $ 190,000 Retained
earnings 131,000 Paid-in capital in excess of par - preferred
35,000 Treasury Stock 165,000 Preferred stock, $100 par 300,000
Paid-in capital in excess of par -common 380,000 Given above
information, at the end of 2013:
Select one:
A. Total Paid in Capital is $1,070,000, and Total Stockholders'
equity...
General Corporation's ledger includes the following account balances at December 31, 2005: Stockholder's Equity General Corporation's ledger includes the following account balances at December 31, 2005: Common Stock, S1 par value, 100,000 shares issued 100,000 Add"l Paid-in Capital in Excess of Par Value, Common 800,000 Preferred Stock, 10%, S60 par value, 10,000 shares issued 600,000 Add'l Paid-in Capital in Excess of Par Value, Preferred 300,000 Retained Earnings 500,000 Treasury Stock, Common, 1,000 shares 100,000 1. The balance sheet prepared at December 31, 2005, would report total legal capital of: 2. The balance sheet prepared at December 31, 2005, would report total...
ADVERTISEMENT
ADVERTISEMENT
Latest Questions
ADVERTISEMENT
|