Categories: Uncategorized

Finance Project Assignment | Online Assignment

Please check uploaded files 1.Please see file Project A first to know what to do 2. The excel sheet has to look like the file ACG 2021

Project A

Don't use plagiarized sources. Get Your Custom Essay on
Finance Project Assignment | Online Assignment
Get an essay WRITTEN FOR YOU, Plagiarism free, and by an EXPERT!
Order Essay

 

Using the excel spreadsheet also attached to this Canvas page, complete the accounting cycle. Answer all the questions in this problem.

 

The trial balance columns of the worksheet for Bramble at March 31, 2019, are as follows.

Bramble
Worksheet
For the Month Ended March 31, 2019
Trial Balance
Account Titles Dr. Cr.
Cash 4,000
Accounts Receivable 3,200
Supplies 1,970
Equipment 10,648
Accumulated Depreciation—Equipment 1,210.0
Accounts Payable 2,080
Unearned Service Revenue 470
Common Stock 10,125
Retained Earnings 1,523
Dividends 1,020
Service Revenue 7,000
Salaries and Wages Expense 1,100
Miscellaneous Expense 470
22,408 22,408

 

Other data:

1. A physical count reveals only $600 of roofing supplies on hand.
2. Depreciation for March is $242.
3. Unearned service revenue amounted to $160 at March 31.
4. Accrued salaries are $700.

 

Requirements:

  1. Journalize the adjusting entries from the adjustments columns of the worksheet
  2. Enter the trial balance on a worksheet and complete the worksheet.
  3. Journalize the closing entries from the financial statement columns of the worksheet.
  4. Prepare an income statement for the month of March
  5. Prepare a retained earnings statement for the month of March
  6. Prepare a classified balance sheet at March 31.

 

Suzie Mercy

Recent Posts

What is the easy difination of science | Quick Solution

Science is the pursuit and application of knowledge and understanding of the natural and social…

4 years ago

definition, values, meaning of such values and type of goods with such elasticity value …….. | Quick Solution

Clearly stating the definition, the values, the meaning of such values and the type of…

4 years ago

Acct 422 – Nora D | Quick Solution

All answered must be typed using Times New Roman (size 12, double-spaced) font. No pictures…

4 years ago

Acct 322 – Nora D | Quick Solution

All answered must be typed using Times New Roman (size 12, double-spaced) font. No pictures…

4 years ago

Macro Economics Question | Quick Solution

https://www.npr.org/sections/ed/2018/04/25/605092520/high-paying-trade-jobs-sit-empty-while-high-school-grads-line-up-for-university Click on the link above. Read the entire link and answer the questions below…

4 years ago

MGT 322 – Nora D | Quick Solution

All answered must be typed using Times New Roman (size 12, double-spaced) font. No pictures…

4 years ago