Question

In: Accounting

BA 211 Fundamentals of Financial Accounting Project #1 – Financial Statements make this into excel spread...

BA 211 Fundamentals of Financial Accounting

Project #1 – Financial Statements make this into excel spread sheets

Requirements

Use the following transaction descriptions to compose the following items:

●Journal entries for all transactions through the end of year (Dec. 31)

●End of year unadjusted trial balance

●Adjusting journal entries for end of year adjusting transactions

●End of year adjusted trial balance

●Income Statement

●Statement of Retained Earnings

●Balance Sheet

Transactions:

1.Dec. 1

– a new company is formed called “Lawn Darter, Inc.” $10,000 cash is contributed to the

start-up in exchange for common stock.

2.Dec. 1

– $1,500 was paid for 3 months’ rent in advance.

3.Dec. 1

– a $2,400 riding lawn mower was purchased in cash. This piece of equipment was

determined to have a 2 year (24 month) usable lifespan.

4.Dec. 8

– $400 of supplies were purchased on account and paid in cash 30 days later.

5.Dec. 10

– lawn service job was performed and payment was $1,250 in cash

6.Dec. 12

– a customer paid $1,400 in cash for lawn service to be performed Jan. 10

7.Dec. 15

– lawn service job was performed and payment was $1,100 in cash

8.Dec. 17

– lawn service job was performed and payment was $750 on account, paid in cash 30 days

later.

9.Dec. 20

– lawn service job was performed and payment was $1,800 in cash

10.Jan. 1

– an inventory was done and it was determined $150 of supplies were used in Dec.

11.Jan. 5

– a $200 dividend for the prior year was paid in cash

12.Jan. 5

– $1,700 in employee wages for Dec. were paid in cash

13.Jan. 10

– lawn service job was performed per previous agreement

14.Mar. 1

– $450 of income taxes were due for the prior yea

Solutions

Expert Solution


Related Solutions

Fundamentals of Government/Fund Accounting: 1. What are the major sources of funds for capital project and...
Fundamentals of Government/Fund Accounting: 1. What are the major sources of funds for capital project and debt service funds, and how are the sources classified in the Statement of Revenues, Expenditures, and Changes in Fund Balance?
Lab Assignment 1 2020 – 2021 Fall, CMPE 211 Fundamentals of Programming II STUDENT AFFAIRS DUE...
Lab Assignment 1 2020 – 2021 Fall, CMPE 211 Fundamentals of Programming II STUDENT AFFAIRS DUE DATE: 14.10.2020 – 23:59 In this lab, we will create a model course registration application. Please check out the example run of the program first. You are asked to implement the classes; Student. Course. Grade. StudentAffairs. It will contain the main method. The commands and their arguments for this week are: createCourse <courseCode> <capacity> <day> <studentCount> <averageGrade> createStudent <studentName> <studentID> addGradeStudent <studentID> <letterGrade> addGradeCourse...
Deliberate on why it is crucial to understand accounting and financial management fundamentals? Discuss how accounting...
Deliberate on why it is crucial to understand accounting and financial management fundamentals? Discuss how accounting information and financial analysis facilitate decision making. Give examples. What advice would you give to your team regarding utilizing financial information more effectively?
Use Excel for Problem 1-33 Interrelationships among financial statements Crawford Enterprises started the 2014 accounting period...
Use Excel for Problem 1-33 Interrelationships among financial statements Crawford Enterprises started the 2014 accounting period with $75,000 of assets (all cash), $15,000 of liabilities, and $25,000 of common stock. During the year, Crawford earned cash revenues of $46,000, paid cash expenses of $26,000, and paid a cash dividend to stockholders of $5,000. Crawford also acquired $15,000 of additional cash from the sale of common stock and paid $10,000 cash to reduce the liability owed to a bank. Required a.Prepare...
collect or make financial statements of volkswagen company by estimating or assuming the numbers, project pro...
collect or make financial statements of volkswagen company by estimating or assuming the numbers, project pro forma statements and derive Free cash flow
How to make a PERT Chart on Excel with example project?
How to make a PERT Chart on Excel with example project?
1. Financial statements are regulated by? a. Accounting standards and audit b. The accounting profession c....
1. Financial statements are regulated by? a. Accounting standards and audit b. The accounting profession c. Legislation and accounting standards d. Legislation, accounting standards and audit 2.Accounting standards reflect? a. The basic principles generally accepted by the accounting profession b. How a particular company standardises its financial statements from year to year c. A consensus between international and USA standard-setting agencies d. Laws that govern how financial statements are presented 3. Compared with the production of financial statements for shareholders,...
Accounting Project (Excel) Students are required to prepare Excel Spreadsheets with tabs for Journal Entries, T...
Accounting Project (Excel) Students are required to prepare Excel Spreadsheets with tabs for Journal Entries, T Accounts, Trial Balances, and Financial Statements. Record all transactions and prepare financial statements within the Excel Spreadsheet Requirements: 1) Using the Balance Sheet information, enter the beginning balances in the T-Accounts. 2) On the following sheet, use the Transaction Information to journalize entries, 1 – 10. 3) Post each entry into the T-Accounts. When finished journalizing, calculate the account balance for each T-Account. 4)...
Project 1 Calculations must be done in Excel As the financial advisor to Upmarket Car Rentals...
Project 1 Calculations must be done in Excel As the financial advisor to Upmarket Car Rentals you are evaluating the following types of cars to add to the fleet: - 1. Speedster: - A sporty convertible with a cost of $120,000 and a useful life of 4 years. It will produce rental income of $80,000 per year and operating costs of $15,000 per year. A major service is required after 2 years costing $20,000. A salvage value of $30,000 is...
1. Discuss the financial statements that are prepared in government accounting. 2. In what way are...
1. Discuss the financial statements that are prepared in government accounting. 2. In what way are they different from those prepared in business accounting?
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT