Acoounting -- 2

General assignment instructions:

1) Prepare your assignment in Microsoft Excel.

2) Name your file as follows: SU22_ACC510_HW1_Lastname

3) Use only Arial 10 font. Use only black font; do not use any font colors other than black anywhere

in your assignment.

4) Prepare Part A on one worksheet and Part B on a second worksheet. Name the worksheet tabs

Part A and Part B.

5) If you are not sure about a requirement or detail for the assignment, ask your professor for

clarification! Failure to follow instructions may result in a loss of points.

6) Neatness, formatting, and presentation of your work will be considered in determining your final

grade for the assignment.

7) This assignment is to be prepared and submitted by each individual student; group efforts are not

permitted. Do not copy, share, or duplicate any part of the assignment. Violations of this direction

may be submitted to the Academic Conduct Committee for review.

Part A – Do You Know Your Accounts?

Consider the following list of accounts for Farragut, LLC:

1) Interest Payable

2) Rent Expense

3) Interest Revenue

4) Accounts Receivable

5) Computer Equipment

6) Prepaid Property Tax Expense

7) Unearned Rent Revenue

8) Retained Earnings

9) Common Stock

10) Copyrights

For the accounts shown above, identify the following for each:

• Account type (i.e., asset, liability, owners' equity, revenue, expense, or dividends)

• Financial statement on which the account appears

• Whether the account is current, noncurrent, or neither (i.e., does not apply)

• Normal balance (i.e., debit or credit)

• Whether or not the account is closed at the end of an accounting period (i.e., Yes or No)

Present your work in a table as follows:


Description Account Type








Closed at End

of Period



Rent Expense

Etc., etc., etc.,


(See Part B on next page)

Part B – Trial Balance and Financial Statements

Consider the following list of accounts and their normal balances for Fitzgerald, Inc. as of December 31,


Account Description Balance

A/D - Equipment 10,000

Accounts Payable 44,500

Accounts Receivable 54,100

Cash 129,700

Common Stock 100,000

Depreciation Expense 12,000

Dividends 7,500

Dividends Payable 5,000

Equipment 28,200

Income Tax Expense 9,120

Insurance Expense 6,000

Inventory 41,280

Miscellaneous Expense 2,500

Miscellaneous Revenue 5,000

Mortgage Payable 29,400

Note Payable 13,800

Payroll Tax Expense 7,500

Prepaid Insurance 29,900

Rent Expense 12,000

Retained Earnings 28,200

Salaries Expense 78,000

Salaries Payable 28,900

Service Revenue 157,500

Utilities Expense 4,500

Instructions for Fitzgerald, Inc.:

1) Prepare the following items in good form:

a. Trial balance

b. Income statement

c. Statement of retained earnings. (Note: Do not prepare a statement of stockholders’ equity

for the statement of retained earnings.)

d. Balance sheet

e. Closing journal entries

f. Post-closing trial balance

2) Show only whole dollars in all six items. Do not show cents.

3) Do not use dollar signs.

4) Use only the Accounting number format in Excel.

5) Use single-underline prior to subtotaling a column of numbers, and use double-underlining to

indicate the final total in a column o

6) “In good form” for items 2 through 5 means the statements should be presented in a neat and

proper fashion. Use examples shown in the textbook but do not use any shading or colors of any kind

Færdigheder: Excel, Research Writing, Word, Powerpoint, Regnskab

Om klienten:
( 7 bedømmelser ) Sterling Heights, United States

Projekt ID: #34321580

Tildelt til:

(4 bedømmelser)

62 freelancere byder i gennemsnit $20 timen for dette job


Acoounting -- 2 I have 13 years of experience in the Writing Industry and I can provide you with “SUPREME QUALITY WORK” within your “GIVEN DEADLINE” with “PERFECT GRAMMAR” and “ZERO PLAGIARISM”. I have 1600 + "EXCELLE Flere

$10 USD på 1 dag
(1357 bedømmelser)

Hello I am a proficient chartered accountant (C.A.) in business and finance analysis. I have 18 years’ experience as a practicing CPA and 20 years’ experience as an academic researcher and analyst. I am passionate abou Flere

$20 USD in 7 dage
(486 bedømmelser)
(228 bedømmelser)

"Sir, I am Accounting, Finance, Bookkeeping, Financial statements, Annual Reports, Ratio analysis Advanced Level Expert. This is basic work for me. I can complete this project with added quality. About me I am a Cha Flere

$30 USD på 1 dag
(221 bedømmelser)
(57 bedømmelser)

Dear sir/madam I have more than 15 years of an academic experience in accounting and finance. I am expert Accountant, writer, researcher, and bookkeeper. I am ACCA (Chartered Accountant). I am expert in EXCEL, QB, XE Flere

$20 USD in 7 dage
(147 bedømmelser)

Acoounting -- 2 This project is my strength and I can fulfill your requirements properly within your given deadline. I always give plagiarism-free work to my clients at very competitive prices. I have more than 10 Flere

$10 USD på 1 dag
(227 bedømmelser)

Acoounting -- 2 I am damn sure that I can complete this project beyond your expectations within your given time and budget. I do not believe in charging high rates because I just love to write and fulfill my client’s Flere

$10 USD på 1 dag
(208 bedømmelser)

Hi, I am an Excel Expert with Professional experience working with Excel. I believe I can do great work for you and ensure your quality. I have more than 5 years of experience with excel. Complete a lot of jobs on Free Flere

$20 USD på 1 dag
(88 bedømmelser)

Hello. My name is Alejandra Baptista I am an accountant, administrator and financial graduated. I have a lot experience with Excel, Power Point, Word, accounting and payroll software like: Quickbook Online, Accounting Flere

$50 USD in 3 dage
(54 bedømmelser)

YES, I CAN DO IT BEFORE YOUR DEADLINE.............. I am a PhD writer with 10 years of experience. I have worked on several similar projects of academic writing, and can deliver professional academic writing. I have s Flere

$20 USD på 1 dag
(77 bedømmelser)
(33 bedømmelser)
(60 bedømmelser)
(45 bedømmelser)

Greetings! This is Salman, I can do your ACCOUNTING ASSIGNMENT within a day. I am a Top level Academic writer have 5 years experience. I have satisfied clients all over the world. I will provide 100% satisfaction and p Flere

$30 USD på 1 dag
(50 bedømmelser)

Acoounting -- 2 According to your given instructions I am the BEST CANDIDATE to complete this project. I have read all details in depth, please message me so we can finalize the deal. I am working from last 6 year Flere

$10 USD på 1 dag
(109 bedømmelser)

Hello, Top of the day. Trust you are doing great. I will like to work with you on your project. I am a Professional Accountant, Researcher and Writer with wealth of experience in report writing, academic writing, fi Flere

$50 USD in 3 dage
(46 bedømmelser)

Acoounting -- 2 Hello, I am a supreme quality writer who can complete this project easily. You are at the right place, this work is a "Cup of Tea" for me. Look at my reviews page I have more than 100 reviews with ex Flere

$10 USD på 1 dag
(82 bedømmelser)

Hey can let me know more about it. Just initiate chat Hi, I am Jyoti a Professional in Academic Support and Gaurantees you Grade A. My team and me can offer academic help in Engineering, Computer Science, Humanities l Flere

$30 USD in 2 dage
(49 bedømmelser)

Hi, We went through your project description and it seems like our team is a great fit for this job. We are an expert team which have many years of experience on Excel Please come over chat and discuss your requirem Flere

$20 USD in 7 dage
(16 bedømmelser)