In: Accounting
Natalie Lawson spent much of her youth playing sports. She passed many hours on the soccer field and in the dance studio. As Natalie grew older, her passion for healthy living continued as she started practising yoga. Now, at the start of her second year in college, Natalie is investigating various possibilities for starting her own business as part of the requirements of the Entrepreneurship program she is taking. A long-time friend insists that Natalie has to somehow include healthy living in her business plan and, after a series of brainstorming sessions, Natalie settles on the idea of operating a smoothie business. She will start on a part-time basis. She will make the product at home, bottle it, and take it to the yoga studio where she exercises because they have agreed to purchase it on a regular basis. Now that she has started thinking about it, the possibilities seem endless. During the summer, she will concentrate on fresh fruit and vegetable smoothies. The first difficult decision is coming up with the perfect name for her business. In the end, she settles on “Healthy Smoothies” and then moves on to more important issues.
During the month of April 2017, the following activities take place:
Apr. |
12 |
Natalie cashes her Canada Savings Bonds and receives $980, which she deposits in her personal bank account. |
13 |
She opens a bank account under the name “Healthy Smoothies” and transfers $900 from her personal account to the new account. |
|
15 |
Natalie realizes that her initial cash investment is not enough. Her mother lends her $3,000 cash, for which Natalie signs a one-year, 3% note payable in the name of the business. Natalie deposits the money in the business bank account. |
|
18 |
Natalie pays $325 to advertise in the April 20 issue of her community newspaper. Natalie hopes that this ad will generate revenue during the months of May and June. |
|
20 |
She buys supplies, such as protein powder, cups, straws, and fresh fruit and vegetables, for $198 cash. |
|
22 |
Natalie starts to investigate juicing machines for her business. She selects an excellent top-of-the-line juicer that costs $825. She pays for it using her own personal account. |
|
23 |
Natalie prepares her first batch of smoothies to bring to the yoga studio. At the end of the first day, Natalie leaves an invoice for $300 with the studio owner. The owner says the invoice will be paid sometime in May. |
|
24 |
A $98 invoice is received for the use of Natalie's cell phone. The cell phone is used exclusively for the Santé Smoothies business. The invoice is for services provided in April and is due on April 30. |
|
28 |
The yoga studio where Natalie sold her first smoothies orders smoothies for the next month. Natalie is thrilled! She receives $125 in advance as a down payment. |
PART 1: APRIL MONTH (33 marks available)
Requirement 1: Natalie has hired you to be her bookkeeper. Prepare the required journal entries for the above events. Explanations are not required and round to the nearest dollar.
Requirement 2: Post the entries to the general ledger using the t-account format.
Requirement 3: Prepare the unadjusted trial balance as of July 31, 2013.
PART 2: APRIL MONTH END
It is the end of April and Natalie has been in touch with her mother. Her mother is curious to know if Natalie has been profitable and if Natalie requires another loan to help finance her business. Natalie too would like to know if she has been profitable during her first month of operation. Natalie realizes that, in order to determine Santé Smoothies' income, she must first make adjustments. Natalie puts together the following additional information:
1. A count reveals that $105 of supplies remain at the end of April.
2. Natalie was invited to deliver smoothies to a summer barbecue at her local community centre. At the end of the day, she left an invoice for $175 with the facility manager. Natalie had not had time to record this invoice in her accounting records.
3. Because there were so many guests expected to attend the barbecue in item 2, she asked a friend to help with making the smoothies and promised to pay her $12 an hour. The payment to her friend was made on May 4, 2017, for four hours of work.
4. Natalie estimates that all of her equipment will have a useful life of three years or 36 months. (Assume Natalie decides to record a full month's worth of depreciation, regardless of when the equipment was acquired by the business.)
5. Recall that Natalie's mother is charging 3% interest on the note payable extended on April 15. The loan plus interest is to be repaid in 12 months. (Calculate interest to the nearest month.)
Requirement 4: Prepare the necessary adjusting journal entries.
Requirement 5: Post the adjusting journal entries. (15.5 marks)
Requirement 6: Prepare the adjusted trial balance. (10.5 marks)
PART 3: FINANCIAL STATEMENTS
Natalie had a very busy May. At the end of the month, Natalie journalized and posted her adjusting entries, and prepared the following adjusted trial balance at May 31, 2017:
HEALTHY SMOOTHIES Adjusted Trial Balance May 31, 2017 |
||
---|---|---|
Debit |
Credit |
|
Cash |
$3,060 |
|
Accounts receivable |
675 |
|
Supplies |
95 |
|
Equipment |
1,550 |
|
Accumulated depreciation—equipment |
$66 |
|
Accounts payable |
88 |
|
Unearned revenue |
100 |
|
Interest payable |
11 |
|
Notes payable, 3%, principal and interest due April 15, 2018 |
3,000 |
|
N. Koebel, capital |
1,725 |
|
Revenue |
1,225 |
|
Advertising expense |
325 |
|
Salaries expense |
48 |
|
Telephone expense |
174 |
|
Supplies expense |
211 |
|
Depreciation expense |
66 |
|
Interest expense |
11 |
|
$6,215 |
$6,215 |
Using the information in the adjusted trial balance, do the following:
Requirement 7: Prepare an income statement for the two months ending May 31, 2017.
Requirement 8: Prepare the Statement of Owner’s Equity for the two months ended May 31, 2017,
Requirement 9: Prepare a Classified Balance Sheet at May 31, 2017.
Requirement 10:Calculate Healthy Smoothies'
current ratio and acid-test ratio.
Comment on Healthy Smoothies’ liquidity.
PART 4: CLOSING
Requirement 11: Natalie has decided that her year-end will be May 31, 2017. Prepare closing entries. (5.5 marks)
Requirement 12: Prepare a post-closing trial balance. (6.5 marks)
Requirement 1:
In the books of Healthy Smoothies:
Date | Account Titles | Debit | Credit |
April 2017 | $ | $ | |
12 | No journal entry required | ||
13 | Cash | 900 | |
N. Koebel, Capital | 900 | ||
15 | Cash | 3,000 | |
Note Payable | 3,000 | ||
18 | Advertising Expense | 325 | |
Cash | 325 | ||
20 | Supplies | 198 | |
Cash | 198 | ||
22 | Equipment | 825 | |
N.Koebel, Capital | 825 | ||
23 | Accounts Receivable | 300 | |
Revenue | 300 | ||
24 | Telephone Expense | 98 | |
Accounts Payable | 98 | ||
25 | Cash | 125 | |
Unearned Revenue | 125 |
Requirement 3:
Healthy Smoothies | ||
Unadjusted Trial Balance | ||
April, 30, 2017 | ||
Account Titles | Debit | Credit |
$ | $ | |
Cash | 3,502 | |
Accounts Receivable | 300 | |
Supplies | 198 | |
Equipment | 825 | |
Accumulated Depreciation : Equipment | 0 | |
Accounts Payable | 98 | |
Unearned Revenue | 125 | |
Interest Payable | 0 | |
Notes Payable | 3,000 | |
N. Koebel, Capital | 1,725 | |
Revenue | 300 | |
Advertising Expense | 325 | |
Salaries Expense | 0 | |
Telephone Expense | 98 | |
Supplies Expense | 0 | |
Depreciation Expense | 0 | |
Interest Expense | 0 | |
Totals | $ 5,248 | $ 5,248 |
Requirement 4:
Transaction/ Event | Account Titles | Debit | Credit |
$ | $ | ||
1. | Supplies Expense | 93 | |
Supplies | 93 | ||
2. | Accounts Receivable | 175 | |
Revenue | 175 | ||
3. | Salaries Expense | 48 | |
Accounts Payable | 48 | ||
4. | Depreciation Expense ( $ 825 / 36) | 23 | |
Accumulated Depreciation : Equipment | 23 | ||
5. | Interest Expense | 3.75 | |
Interest Payable | 3.75 |
Requirement 6:
Healthy Smoothies | ||
Adjusted Trial Balance | ||
April 30,2017 | ||
Account Titles | Debit | Credit |
$ | $ | |
Cash | 3,502 | |
Accounts Receivable | 475 | |
Supplies | 105 | |
Equipment | 825 | |
Accumulated Depreciation: Equipment | 23 | |
Accounts Payable | 146 | |
Unearned Revenue | 125 | |
Interest Payable | 3.75 | |
Notes Payable | 3,000 | |
N.Koebel, Capital | 1,725 | |
Revenue | 475 | |
Advertising Expense | 325 | |
Salaries Expense | 48 | |
Telephone Expense | 98 | |
Supplies Expense | 93 | |
Depreciation Expense | 23 | |
Interest Expense | 3.75 | |
Totals | $ 5,497.75 | $ 5,497.75 |
Requirement 7 :
Healthy Smoothies | ||
Income Statement | ||
For the two months ended May 31 2017 | ||
Revenue | 1,225 | |
Less: Operating Expenses | ||
Salaries Expense | 48 | |
Advertising Expense | 325 | |
Supplies Expense | 211 | |
Telephone Expense | 174 | |
Depreciation Expense | 66 | |
Interest Expense | 11 | |
Total Operating Expenses | 835 | |
Net Operating Income | 390 |
Requirement 8:
Healthy Smoothies | |
Statement of Owner's Equity | |
For the two months ended May 31, 2017 | |
N. Koebal, Capital | $ 1,725 |
Add: Net income for the period | 390 |
Total | 2,115 |
Less: N. Koebel, Withdrawals | 0 |
Statement of Owner's Equity, May 31 | 2,115 |
Requirement 9:
Assets | $ | $ |
Cash | 3,060 | |
Accounts Receivable | 675 | |
Supplies | 95 | |
Total Current Assets | 3,830 | |
Property, Plant and Equipment | 1,550 | |
Less: Accumulated Depreciation | (66) | |
Property, Plant and Equipment, net | 1,484 | |
Total Assets | 5,314 | |
Liabilities and Owner's Equity | ||
Accounts Payable | 88 | |
Unearned Revenue | 100 | |
Interest Payable | 11 | |
Total Current Liabilities | 199 | |
Long Term Liabilities | ||
Notes Payable | 3,000 | |
Total Liabilities | 3,199 | |
Owner's Equity | 2,115 | |
Total Liabilities and Owner's Equity | 5,314 |
Part 4:
Requirement 11:
Closing entries:
Account Titles | Debit | Credit | |
$ | $ | ||
a. | Revenue | 1,225 | |
Income Summary | 1,225 | ||
To close the revenue accounts | |||
b. | Income Summary | 835 | |
Salaries Expense | 48 | ||
Advertising Expense | 325 | ||
Supplies Expense | 211 | ||
Telephone Expense | 174 | ||
Depreciation Expense | 66 | ||
Interest Expense | 11 | ||
To close the expense accounts | |||
c. | Income Summary | 390 | |
N. Koeble, Capital | 390 | ||
To close Income Summary to Retained Earnings |
Requirement 12:
Healthy Smoothies | ||
Post Closing Trial Balance | ||
May 31, 2017 | ||
Account Titles | Debit | Credit |
$ | $ | |
Cash | 3,060 | |
Accounts Receivable | 675 | |
Supplies | 95 | |
Equipment | 1.550 | |
Accumulated Depreciation | 66 | |
Accounts Payable | 88 | |
Unearned Revenue | 100 | |
Interest Payable | 11 | |
Note Payable | 3,000 | |
N. Koeble, Capital | 2,115 | |
Totals | $ 5,380 | $ 5,380 |