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:
Account
Description Account Type
Financial
Statement
Current,
Noncurrent,
N/A
Normal
Balance
Closed at End
of Period
Interest
Payable
Rent Expense
Etc., 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,
2112:
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
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 + "EXCELLENT REVIEWS" which are a guarantee for my best Quality. Please see my profile and portfolio to assess my quality.
I usually produce 10 pages of work every day with 100 percent accuracy. Open chat and send me a message so we can finalize this deal within your budget Thank you.
Please visit my profile: https: www.freelancer.com/u/topacademictutor
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 about this project having gone through the instructions. I have 520+ reviews on related projects and the responses are positively overwhelming.
I hold an MBA (Strategic Management), Bachelors of Commerce (Finance and Accounting) & C.P.A. (Certified Public Accountant.)
Regards, Charles.
"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 Chartered Accountant with more than 4 years of experience from the worlds leading Accountancy and auditing firm ""PWC"". I can handle this task very efficiently and you can expect 100% accuracy from me. I am Microsoft Excel, accounting, auditing, financial statements, Form Creation in Excel through VBA and in Google Sheet, QuickBooks, and Sage expert. I have been working here from the last 1.5 year and I have 224+ 5 stars reviews here. I am not new to work. I know how to meet strict deadlines without compromising the quality of the work. I will also be available for any query after the job is done as I am building my clients. please be my client and get any type of accountancy, Excel, QuickBooks, and auditing-related work with quality, efficiency, and at reduced rates.
Note. The price is negotiable.
I will be available for any query round the clock even if the project is completed.
Regards
Arman Kakar "
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 years of writing experience, I have served more than 4000 clients on other forums including; Upwork, Fiverr and Guru. I have full grip over; Reports , Essays, Case Studies, Summaries and Dissertation Writing.
Please give me a chance to show you my writing abilities. I am waiting for you. :)
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 Freelancer with high satisfaction of the client.
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, XERO, MYOB, and WAVE. You can see my profile. I do have the ability to complete the assigned task within an agreed period of time.
Thanks and Regards
Muhammad Ilyas Saeed
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 need.
I have command on multiple copywriting skills such as; Article Writing, Blog Writing, Content Writing, Book and/or eBook Writing, Ghost Writing, Speech Writing, Research Writing, Letters, Email and/or Application Writing, Grant Writing, Business Plan, LinkedIn Profiles, Resume/CV & Cover Letters, Biography, Rephrase/Re-Write/ Paraphrase, Personal Statements, Press Release, Product Descriptions, and Editing & Proofreading.
Please message me and I assure you that we will work as a team and will achieve the results that you are looking for!
Waiting for you :-)
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 successfully completed over 1000 projects which are published at my profile with good rating. I can comfortably handle up to 10 pages daily. I'm looking forward to hearing more about the project, and to start working on it immediately. I will be delivering high-quality, plagiarism-free work to you in the minimum amount of time. By awarding this project to me, I will be looking forward to get started for you as soon as possible. Thank You!
contact me through this link
https://www.freelancer.com/u/writingvector
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 years as an accomplished writer on different websites like; Upwork, Fiverr and Guru. I can manage bulk orders with A+ quality even with very short deadlines and within your budget. I always provide Top Class Work to my clients with very reasonable prices.
Hire me for ONCE and you will be my regular client. I am waiting for your message.
Thank You... !
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 excellent ratings and I guarantee you that once you will get my services "You will not go anywhere else". So, please hire me to get desired outcomes.
I am a specialist pro writer who knows every aspect of Professional writing because of a wide range of experience in the writing industry.
Please message me. Thank you
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 plagiarism work. Please message me for further details. Thank you
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, finance, accounting, financial reporting, management accounting, financial management, corporate finance, budgeting, financial planning and analysis, auditing and diverse other fields. I have extensive experience in doing feasibility study, preparing business plans, designing marketing plans and strategy. I have magnitude of experience in preparing financial statements, investment appraisal, financial modelling - making financial projections/planning, business plans and linking the models together, ensuring consistency, simplicity, understandability and ultimately achieving its objective. I am highly proficient in the use of excel for solving business problems.
I am happy to work on your accounting task.
I have strong flair for business analysis, finance and accounting and the use of excel in providing solutions. I look forward to your task as this would afford me the opportunity to diversify my experience and contribute to the success of your endeavour.
I am also open to other opportunities of work you may have. My ultimate objective is to keep my customers & clients satisfied and delight them beyond expectation.
I await your positive response & consideration. A trial will make the difference.
Thank you.
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 like Sociology, Psychology, Physics, Chemistry, Project Management, Information Technology etc.
I offer course work help on blackboard, pearsonlabs, safeassign, turnitin submissions to the students across United States and Australian Universities only.
I can also do Finite Element Analysis in ANSYS, circuit analysis in Multisim and other relevant software's.
Essays; Research Papers; Term Papers; Coursework Help on Blackboard; Literature Reviews; Numerical Problems in Science & Engineering etc.
Quality will be absolutely great and free from any plagiarism on Turnitin or safeassign.
Contact Me if you need Full Grade in your Course Work
Hi mate! I checked out the attached pdf File. The assessment seems very basic to me, therefore, I am offering you the lowest possible rate. I am an ACCA qualified and have been providing accounting and finance tutoring services since 2018 on different platforms including Coursera and Brainly. I've worked on the academics of Australia, USA, UK, Malaysia, and many more.
I will assist you with the following:
- Trial Balance
- Income Statement
- Statement of Retained Earnings
- Balance Sheet
- Closing Entries, and
- Post-Closing Trial Balance
You will be provided with the accurate answers to the attached PDF within one day. Since I've already worked on similar projects, therefore, the templates are ready with me and I just need to feed them with the new numbers. Besides, you will be provided with unlimited revisions.
Looking forward to hearing from you. Good Luck!
Kind Regards,
Anwar Iqbal
ACCA | BS A&F
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 requirement in a detailed way.
Regards
Hello,
I'm a former CP (competitive programming) competitor, I'm a master at algorithms and algorithms
and could help you solve your problem quickly with clean, optimized and well-commented code.
Acoounting -- 2
I am an academic expert who can help you with your solutions like; Case Studies, Summaries, Reports, Thesis & Dissertations, and Online Exams and Courses in almost every language. I am new to this website but I assure you that I will provide you with 100% quality work without plagiarism within your given deadline and budget.
I am new here but I am familiar with this industry as I am working here since 2013. Please give me a chance and feel free :)
Thank You
Hey There
I am a QBO certified Pro Advisor and MBA Finance having a diversified seven years experience in Logistics, Consultancy and Outsourcing Companies serving clients across the Globe.
My expertise includes Financial Management, banking and the development and implementation of Business Bookkeeping plans. I will provide following services for your business,
*Initial setup of your general ledger and recording of your start-up expenses and Invoices.
*Payroll processing for employees, including direct deposit of pay checks and manual checks when necessary.
*Monthly bank reconciliation for your two bank accounts and credit card. I will require you to allow direct bank feeds from your financial institutions and allow me to access your statements.
*Monthly / Quarterly financial statements and meetings to review variations from prior quarters
*Two hours of meetings or phone consultations.
While you are running your business, I will be setting up your books and ensuring your records are kept up to date. My goal is to manage your bookkeeping so you can free up your time to manage your business. I will be updating your books on a Daily basis, running your payroll, preparing Bank Reconciliation, and providing quarterly financial statements.
I want this process to be seamless and stress-free for you. We will use online access to your QuickBooks file and receive your bank statements directly from the bank.
Thank you for the opportunity to bid.
Sincerely,
Usman Asif
Hi there,
Your Accounting Specialist is here
Graduated from London; United Kingdom in Investment & Finance; Risk Management. I have done various VLOOKUPS, Macros, Data Analysis, Sorting of data, VBA, Hyperlinks and etc. I have handled various excel projects such as Financial Modeling, Risk Assessment, Balance sheet, Income Statements, Data Sorting and etc.
I will be able to complete your task as per your requirement and understandings
Feel free to inbox for more details and budget
Regards,
S.A
Greetings,
I just read your project.
I can do it and am ready to start work immediately.
The design provided will be creative and according to your requirements.
I have many years of experience in Photoshop, Illustration, Graphic Design, Logo Design and Illustrator.
Please have a look at my profile portfolio:https://www.freelancer.com/u/zaheromar
I assure you that you will like my work. I am quite interested in working with you.
Regards,Zaher