The Cherry & White Bike Company is a small closely-held company with two owners. Its two owners, Charlotte and George, have decided to expand the business. You are CWB’s accountant. Your responsibilities include maintaining all accounting records and preparing annual financial statements.
CWB wants to take out a loan to expand its business in the coming year. The banks and lending institutions require a set of financial statements prepared under U.S. GAAP to evaluate CWB’s credit worthiness.
You must prepare a complete set of financial statements including the notes to the financial statements for the quarter ending March 31, 2019. You need to choose CWB’s accounting policies and methods for areas including inventory cost flow, revenue recognition, and depreciation. You will need to consider the proper classification of assets and liabilities as current and non-current on the balance sheet.
To obtain a loan with the lowest interest rate available, CWB needs to show high profitability, and strong liquidity and solvency. You realize the common financial statement analysis ratios for profitability, solvency and liquidity will depend on the accounting methods you choose. So, you carefully analyze the accounting choices in light of common financial statement ratios.
The owners also have expressed to you that they need to know their inventory and cost of goods sold to manage purchases and pricing. So, you are highly considering using a perpetual inventory system.
You are presented with a trial balance as of the end of 2018 and must add the transactions and activities that occurred in the first quarter of 2019 as listed below. You can add accounts to the trial balance, as needed. In the first quarter of 2019 Cherry & White Bikes had the following transactions
January 1: The owners hire Nina Marton to manage the store, paying her a salary of $2,600 a month. Lisa is paid on the 1st of every month, starting on February 1 (which would represent her January pay). They have one other employee who they pay $1,600 a month, also on the 1st of the following month. Employees work 40 hours a week.
January 14: Paid utilities for 4th quarter of 2018, $775.
February 1: Installed new light fixtures and display cases in the leased store. CWB paid $1,900 for the fixtures, $150 for shipping to the store, and $400 to an electrician to install. CWB paid 6% sales tax on the fixtures and shipping in addition to the cost of the fixtures and equipment. It did not pay a sales tax to the electrician.
The landlord gave CWB permission to remove and dispose of the old fixtures. CWB sold the old fixtures for $200. CWB anticipates being in the store for at least 5 years. CWB cannot take the light fixtures with them if they relocate as they will revert to the lessor.
CWB can take the display cases if they move. The display cases cost $2,800. CWB also incurred 6% sales tax on the display cases on addition to their cost.
Both the display cases and light-fixtures have a seven-year useful life.
February 10: CWB made a payment of $5,500 on its accounts payable.
March 1: CWB invests in a $4,000 3-month treasury bill paying interest of 3.0%.
March 12: One of the standard bikes sold on February 21 was returned by the customer. The bike sold for $400. CWB provided a full refund. CWB’s policy is to provide a customer with a full refund within 30 day of purchase as long as the bike is returned in good condition. While the bike is in good working condition, CWB does not anticipate being able to sell the bike as new – rather it anticipates marking it down and selling it for $190.
March 24: A customer puts down a deposit of $500 on a high-end racing bike that sells for $2,900. CWB ordered the bike from the manufacturer. The manufacturer promises CWB will have the bike at the store on April 3.
Here is other information on other activity and recurring transactions that occurred during the period.
Month |
Number of Tune-Ups |
January |
14 |
February |
36 |
March |
42 |
Date |
Transaction |
Quantity |
Cost per Bike |
Beginning Inventory |
25 |
$110 |
|
January 25 |
Sale |
15 |
|
February 8 |
Purchase |
30 |
$115 |
February 14 |
Sale |
16 |
|
February 27 |
Sale |
15 |
|
March 2 |
Purchase |
28 |
$120 |
March 17 |
Sale |
20 |
+All purchasers of standard bikes are given the option of buying a bike for $400, or a bike with two years of tune-ups for $500. Four of the bikes sold on February 21st were sold with the tune-up option.
**All purchases were made using cash except the March 2nd purchase for which CWB obtained two-months credit from the bike supplier.
Cherry & White Bike Company
Post-Closing Trial Balance
12/31/2018
Account Title |
Debit |
Credit |
Cash |
$30,100 |
|
Store supplies |
460 |
|
Prepaid rent |
900 |
|
Prepaid insurance |
1,650 |
|
Inventory – standard bikes (25 bikes) |
2,750 |
|
Equipment |
15,500 |
|
Accumulated depreciation - equipment |
$4,350 |
|
Accounts payable |
8,724 |
|
Utilities payable |
775 |
|
Salaries payable |
1,600 |
|
Interest payable |
1,200 |
|
Loans payable |
10,000 |
|
Capital stock |
20,000 |
|
Retained Earnings |
4,711 |
|
Totals |
$51,360 |
$51,360 |
NEED Journal Entries, Income Statement, Statement of retained earnings, and Balance Sheet
We will have to first record the journal entries that shall amend the year end trial balance so that we can we can arrive at the trial balance of march ending. In the particular case of the light fixtures the company cannot take away the fixtures after they have vacated the premises and hence the said fixtures shall not be capitalized but debited as cost to the profit and loss account however the display cases that can be taken by the company shall be allowed to be depreciated and capitalized as well.
JOURNAL ENTRIES IN BOOKS OF CHERRY & WHITE BIKE COMPANY | ||||||||
SR NO | PARTICULARS | LF | DEBIT | CREDIT | ||||
Jan-01 | Employee Salary account | 1600 | ||||||
To Cash Account | 1600 | |||||||
( Being salary paid to another employees ) | ||||||||
Jan-14 | Utilities Expense A/c | 775 | ||||||
To Cash A/c | 775 | |||||||
( Being utilities of 4th quarter paid ) | ||||||||
Feb-01 | Employee Salary A/c | 4200 | ||||||
To Cash A/c | 4200 | |||||||
( Being salary paid to all the employees ) | ||||||||
Feb-01 | Fixtures expense A/c | 2050 | ||||||
Electrician Charges A/c | 400 | |||||||
Sales tax A/c | 114 | |||||||
To Cash A/c | 2564 | |||||||
( Being the purchase of the fixtures and the tax paid) | ||||||||
Feb-01 | Display Cases Asset A/c | 2968 | ||||||
To Cash A/c | 2968 | |||||||
( Being the display cases purchased and Capitalized ) | ||||||||
Feb-01 | Cash A/c | 200 | ||||||
To Fixtures A/c | 200 | |||||||
( being the old fixtures sold ) | ||||||||
Feb-10 | Accounts Payable A/c | 5500 | ||||||
To Cash a/c | 5500 | |||||||
( Being cash paid on accounts payable ) | ||||||||
Mar-01 | Treasury bill A/c | 4000 | ||||||
To Cash A/c | 4000 | |||||||
( Being cash paid for invst in treasury bill ) | ||||||||
Mar-12 | Sales return A/c | 400 | ||||||
To Cash a/C | 400 | |||||||
( Being full refund made to the customer ) | ||||||||
Mar-24 | Cash A/c | 500 | ||||||
To Customer A/c | 500 | |||||||
( being advance received from the customer ) | ||||||||
Mar-31 | Income from Bike Tune Ups | 7360 | ||||||
To Cash A/c | 7360 | |||||||
( Being the income from the bike tune ups recognised ) | ||||||||
Jan-25 | Cash A/c | 6000 | ||||||
To Sales A/c | 6000 | |||||||
( being sale of the vehicles made ) | ||||||||
Feb-08 | Purchase of the bikes A/c | 3450 | ||||||
To Cash A/c | 3450 | |||||||
( being bikes purchased ) | ||||||||
Feb-14 | Cash A/c | 6400 | ||||||
To Sales A/c | 6400 | |||||||
( being sales made ) | ||||||||
Feb-21 | Cash A/c | 2000 | ||||||
To sales A/c | 2000 | |||||||
( Being Sales Made ) | ||||||||
Feb-27 | Cash A/c | 6000 | ||||||
To Sales A/c | 6000 | |||||||
( Being sales made ) | ||||||||
Mar-02 | Purchase of Bikes A/c | 3360 | ||||||
To Cash A/c | 3360 | |||||||
( bieng Purchse Made ) | ||||||||
Mar-17 | Cash A/c | 8000 | ||||||
To Sales a/c | 8000 | |||||||
( Being sales made ) | ||||||||
Mar-31 | Interst income from Treasury Bill receivable | 120 | ||||||
to Interest Income | 120 | |||||||
( being interest Accrued on treasury bills ) | ||||||||
Mar-31 | Interest accrued on Loan | 300 | ||||||
To Interest Payable | 300 | |||||||
( Interest Accrued ) | ||||||||
Jan-15 | Cash A/c | 900 | ||||||
to Rent Income | 900 | |||||||
Feb-15 | Cash A/c | 900 | ||||||
to Rent Income | 900 | |||||||
Mar-15 | Cash A/c | 900 | ||||||
to Rent Income | 900 | |||||||
After the journal entries have been done we shall now amend the previous year ending trial balance and arrive at the figures of the balance sheet. There are some accounts in the balance sheet that are payable and it has been assumed that the entries have been passed. The effect of the entries has been directly put in the trial balance.
Amended Trial Balance is as follows:
Get Answers For Free
Most questions answered within 1 hours.