Question
Hello, I realize this is a long problem(s), however I have a family issue in which I will not be able to complete this in
Hello, I realize this is a long problem(s), however I have a family issue in which I will not be able to complete this in the given time period it is due, which is tomorrow at noon. I am happy to compensate extra for the amount of work, just let me know what is reasonable! Helping me with this would be a life saver! I know how to do everything for the most part, besides a couple of things, but I figured if I looked at the equations after the fact I would be more than capable of understanding the material. Thanks!
June Corporation has been operating for two years. The December 31, 2015 account balances are:
Cash | $82,800 |
| Accounts Payable | $80,000 |
Accounts Receivable | 49,550 |
| Salaries Payable | 26,300 |
Inventory | 16,600 |
| Notes Payable long term | 126,500 |
Short-term Investments | 8,700 |
| Contributed Capital | 100,250 |
Equipment | 106,350 |
| Retained Earnings | 67,950 |
Land | 137,000 |
|
|
|
During the year 2016, the company had the below activities. Note that none of these activities should impact the income statement, only the balance sheet; we are assuming for simplicity that the company did not have any revenues or expenses during 2016.
Purchased additional equipment costing $41,400; paying $16,400 in cash and signing a promissory note to pay the balance in three years.
Issued 7,000 shares of stock, receiving $30,000 in cash and land valued at $18,000 from investors.
Collected $43,000 cash on open accounts receivable from customers.
Paid off $26,300 of salaries owed from the prior year.
Received a $38,850 loan from the bank, payable in four years.
Ordered supplies worth $3,000 from Concord Supplies to be delivered next month.
Bought additional inventory for $10,250 on account.
Returned some defective inventory to a supplier for a full cash refund of $3,000.
Paid off $20,000 of notes payable a year early. Ignore interest.
Purchased additional short-term investments for $3,800 cash.
To be done on Excel
Copy and paste the above table with the account balances into an Excel spreadsheet. This will be your first worksheet titled Question #1.
On a new worksheet titled Question #2, prepare journal entries for each event that is an accounting transaction. For example, for the following event, the journal entry will be as follows:
I.Purchased additional buildings for $123,000 by signing a long term note
Event | Accounts | Debit | Credit |
I. | Building (+A) | $123,000 |
|
| Notes Payable long term (+L) |
| $123,000 |
Note: Do not include this example in your solution. This is just for illustrative purposes.
When you are done recording your journal entries sum your columns of debits and credits to make sure they are equal.
On a new worksheet titled Questions #3 and #4, create T-accounts for each account, bringing in the beginning balances from the table you copied and pasted into Excel for #1 above. Be sure you have the balances on the correct side (i.e., debit versus credit) of the account.
Post the effects of the transactions for 2016 to the T-accounts created in #3
On a new worksheet titled Question #5, prepare a trial balance. By referring to cells in your T-accounts bring over the balances from your T-accounts to the trial balance. Use the Sum function to add up your debit and credit columns to ensure they are equal.
On a new worksheet titled Question #6, prepare a classified balance sheet for the 2016 year-end balances (see page 67 in the textbook). By referring to cells in your trial balance, bring over the appropriate amounts from the trial balance to your balance sheet. Use the Sum function to calculate your totals. Your balance sheet should balance!!!!
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started