Get in touch with us
Send us an e-mail
Question
XYZ, Inc. – Review of the Basics
Three financial statements: the balance sheet, income statement, and statement of retained earnings for XYZ, Inc., an accounting and consulting firm, are included below.


During January 2016, XYZ engaged in the following transactions:
1) Paid in full with cash the December 31 balance of accounts payable
2) Furnished professional services and billed $25,000. It collected $13,000 of the December 31 balance of accounts receivables and none of the January billings.
3) Paid all marketing expenses with cash as they arose, $4,500.
4) Incurred supplies expenses of $5,100. The unused supplies (i.e. Supplies inventory) balance on January 31 was $4,000. All of the January inventory purchases were on credit.
5) Paid the bank $5,000 to reduce the principal of the long-term note payable ($5,000 payment due each January), and additionally paid one month’s interest in cash at a 12% per year rate on the month’s beginning balance. You need to record a principal reduction of $5,000 as well as the appropriate amount of cash paid for interest as a separate item or amount from the $5,000 principal reduction.
6) Sold the land for $25,000
7) Paid utilities payable outstanding as of December 31, 2015. The $1,200 bill for January’s utility consumption will be paid in February.
8) On January 31, purchased computer equipment for $1,000 cash and a $5,000 installment note payable at 10% interest due in six months (i.e. no cash was exchanged for the note). Use an “equipment” account for this transaction.
9) Declared (obligated itself to pay) a dividend of $3,000. It will be paid in February.
10) Additional information: Equipment originally cost $40,000 has an estimated salvage value of $4,000 and is being depreciated straight-line over six years. Please record the adjustment for accumulated depreciation in the “Equipment (net)” account.
11) Paid salaries payable outstanding as of December 31, 2015. Incurred and paid with cash salaries expense of $7,500 in January (none outstanding at the end of January).
Required:
Note: work should be done in excel
Summary
The question belongs to Accounting and it discusses about preparation and analysis of financial statements of a company.
Download Full Solution
My main concern was the relevant local Wellington research and reference work that was required for the final Statistics Assignment for my post graduate program at the Victoria University of Wellington. My professor was very particular about his requirement of relevant local data and samples from Wellington. With the stats assignment expert at TheReliableTutor I did not have to worry about that since the expert provided the most excellent and relevant local data and references helping me to top the class.
The course structure in the US is totally different from what I was used to. I was feeling totally bogged down with all the course load and numerous assignments of the different subjects. Thank god for TheReliableTutor and their brilliant Labor Economics Assignment experts I did not need to worry about the assignment once I submitted it to them.
The standard of education varies tremendously with nature of university and it is difficult for people to find city specific assignment help. It was a delight to find out that in HwA they provide you with city and university specific assignment help.
The accounting assignment due for my term end evaluation had to include data and examples from Wellington businesses. So when I mentioned this special requirement of mine to the customer care executives at TheReliableTutor they immediately paired me with an accounting assignment expert who is from Wellington and has himself studied from the Victoria University of Wellington. Needless to say I topped the class and the professor was very impressed by the quality of the assignment.
I was stuck with my fault detection in logic circuit assignment when I looked up in the net for help. Luckily I came across HwA and it was all so quick. Within 5 minutes of me enquiring for help, they mailed me back letting me know about the process. The assignment went well and since then I always consult HwA for any of my assignments.
Comments
this is a very good website
I have 50 questions for the same test your page is showing only 28
hi can you please help or guide me to answer my assignments. thanks
hi can anyone help or guide me to my assignments. thanks
This solution is perfect ...thanks
Hello Allison,I love the 2nd image that you did! I also, had never heard of SumoPaint, is something that I will have to exolpre a bit! I understand completely the 52 (or so) youtube videos that you probably watched. Sometimes they have what you want, sometimes they don't! However, it is always satisfying when you are able to produce something that you have taught yourself. Great job!Debra 0 likes
Perfect bank of solution.
great !
thanks for the quick response. the solution looks good. :)
thnx for the answer. it was perfect. just the way i wanted it.
works fine.