Question

The Cherry & White Bike Company is a small closely-held company with two owners. Its two...

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.

  1. CWB offers bike tune-ups for $80 each. CWB’s employee is an expert tune-ups, taking about one hour per bike for a tune-up. Below is the number of tune-ups performed in each month. All customers pay in cash. (For recording the transactions, you can assume all tune-ups are done the last day of the month).

Month

Number of

Tune-Ups

January

14

February

36

March

42

  1. CWB has the following purchases and sales of standard bikes during the quarter+:

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.

  1. CWB took out a five-year loan for $10,000 with an interest rate of 12% on January 1, 2018. The loan matures on January 1, 2022.
  2. CWB rents its premises for $900 per month, with rent due on the 15st of the prior month.
  3. CWB has a business insurance policy, which it purchased for $3,300 on July 1, 2018. The policy runs until June 30, 2019.
  4. CWB owns various tools and equipment which it pools for purpose of calculating depreciation. In the past it has used straight-line depreciation over a ten-year period with no scrap or salvage value for these assets. However, with technology changing rapidly, CWB questions whether it will have to replace the equipment earlier.
  5. On March 31, CWB had $154 of supplies left in the supply room.
  6. On April 7 received its utilities bill for the first quarter of 2019 - $800.
  7. The tax rate is 20%.

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

Homework Answers

Answer #1

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:

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
Hillyard Company, an office supplies specialty store, prepares its master budget on a quarterly basis. The...
Hillyard Company, an office supplies specialty store, prepares its master budget on a quarterly basis. The following data have been assembled to assist in preparing the master budget for the first quarter: As of December 31 (the end of the prior quarter), the company’s general ledger showed the following account balances: Debit Credit Cash $ 46,000 Accounts receivable 204,800 Inventory 58,650 Buildings and equipment (net) 356,000 Accounts payable $ 86,925 Common stock 500,000 Retained earnings 78,525 $ 665,450 $ 665,450...
Hillyard Company, an office supplies specialty store, prepares its master budget on a quarterly basis. The...
Hillyard Company, an office supplies specialty store, prepares its master budget on a quarterly basis. The following data have been assembled to assist in preparing the master budget for the first quarter: As of December 31 (the end of the prior quarter), the company’s general ledger showed the following account balances: Cash $ 47,000 Accounts receivable 205,600 Inventory 58,800 Buildings and equipment (net) 357,000 Accounts payable $ 87,225 Common stock 500,000 Retained earnings 81,175 $ 668,400 $ 668,400 Actual sales...
Merline Manufacturing makes its product for $65 per unit and sells it for $137 per unit....
Merline Manufacturing makes its product for $65 per unit and sells it for $137 per unit. The sales staff receives a 10% commission on the sale of each unit. Its December income statement follows. MERLINE MANUFACTURING Income Statement For Month Ended December 31, 2017 Sales $ 1,370,000 Cost of goods sold 650,000 Gross profit 720,000 Operating expenses Sales commissions (10%) 137,000 Advertising 214,000 Store rent 24,700 Administrative salaries 43,500 Depreciation—Office equipment 53,500 Other expenses 12,700 Total expenses 485,400 Net income...
Kline Sisters Company operates a gift shop where peak sales and activity occur in the months...
Kline Sisters Company operates a gift shop where peak sales and activity occur in the months of December and January. Data regarding the store's operations follow: Sales are budgeted at $360,000 for January, 320,000 for February, and $250,000 for March and $240,000 in April. Collections are expected to be 30% in the month of sale, 65% in the month following the sale, 3% in the second month following sale and 2% uncollectible. The cost of goods sold is 76% of...
Solomon Company is a retail company that specializes in selling outdoor camping equipment. The company is...
Solomon Company is a retail company that specializes in selling outdoor camping equipment. The company is considering opening a new store on October 1, 2019. The company president formed a planning committee to prepare a master budget for the first three months of operation. As budget coordinator, you have been assigned the following tasks: Required October sales are estimated to be $310,000, of which 45 percent will be cash and 55 percent will be credit. The company expects sales to...
Dalton Manufacturing is preparing its master budget for the first quarter of the upcoming year. The...
Dalton Manufacturing is preparing its master budget for the first quarter of the upcoming year. The following data pertain to Dalton ​Manufacturing's operations: Current Assets as of December 31 (prior year): Cash. . . . . . . . . . . . . . . . . . . . . . . . . . .$4,460 Accounts receivable, net. . . . . . . . . . . $48,000 Inventory. . . . . . . ....
REQUIREMENTS:   1)    Sales Budget   2)    Production Budget Budgets should be for the individual three (3) months of the...
REQUIREMENTS:   1)    Sales Budget   2)    Production Budget Budgets should be for the individual three (3) months of the first quarter of 2019. Include a quarterly total column on the right side. Each budget/requirement should be in a separate tab within one spreadsheet. All pages should be in portrait format using the same font. Use proper rounding and show two (2) decimal places of accuracy on dollar amounts. Round up and show whole amounts on all other figures. (Hint) Excel provides functions for...
The Jarrad Corporation's management team is getting ready to prepare its master budget for one its...
The Jarrad Corporation's management team is getting ready to prepare its master budget for one its product lines for the year 2019. The company produces caramel lollipops which are basically cooked down sugar on a stick, a diabetics nightmare along with many other sweet treats. Budgeted sales of the lollipops for each quarter of 2019 are as follows: 1st Quarter-12,500 cases , 2nd Quarter-14,000 cases , 3rd Quarter-25,500 cases , 4th Quarter-34,900 cases There are 100 lollipops in a case...
The Not-too-tough company started its operation in 2018. Its balance sheet for December 31, 2018, showed...
The Not-too-tough company started its operation in 2018. Its balance sheet for December 31, 2018, showed the following account balances (there were no other accounts listed, numbers are in thousands): Assets Assets 2019 Cash and cash equivalents 400 Inventory 59 Accounts receivable 90 Property, plants, and equipment 100 Less: accumulated depreciation (10) Property and equipment – net 90 Prepaid rent 0 Total Assets 639 Liabilities and Equity Liabilities and Equity 2019 Accounts payable 50 Advance from customers 40 Wages payables...
Assume ABC Company has asked you to not only prepare their 2017 year-end Balance Sheet but...
Assume ABC Company has asked you to not only prepare their 2017 year-end Balance Sheet but to also provide pro-forma financial statements for 2018. In addition, they have asked you to evaluate their company based on the pro-forma statements with regard to ratios. They also want you to evaluate 3 projects they are considering. Their information is as follows: End of the year information: Account 12/31/17 Ending Balance Cash 50,000 Accounts Receivable 175,000 Inventory 126,000 Equipment 480,000 Accumulated Depreciation 90,000...