Intermediate acct cycle project

Accounting Cycle Project

Cherry & White Bike Company

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. Cherry & White Bikes’ started on January 2, 2017. CWB’s year end is December 31st.

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 period ending December 31, 2017. 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 company 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 have a trial balance and must add the additional transactions and activities identified below. You can add accounts to the trial balance, as needed. Cherry & White Bikes had the following additional transactions

June 1: The owners hire Lisa Marton to manage the store, paying her a salary of $3,000 a month. Lisa is paid on the 1st of every month, starting on July 1.

July 1: Installed new light fixtures and display cases in the leased store. CWB paid $1,800 for the fixtures, $230 for shipping to the store, and $800 to an electrician to install. The landlord gave CWB permission to remove and dispose of the old fixtures. CWB sold the old fixtures for $110. CWB anticipates being in the store for at least 3 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, which cost $6,400, if they move.

Both the display cases and light-fixtures have a six-year useful life.

August 1: CWB invests $2,000 in an 18-month certificate of deposit paying interest of 1.5%.

November 1: CWB invests in a $1,000 3-month treasury bill paying interest of 1.0%

December 12: One of the standard bikes sold was returned by the customer. The bike sold for $250. CWB paid $80 for it. 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.

December 24: A customer puts down a deposit of $400 on a high-end racing bike that sells for $2,800. CWB ordered the bike from the manufacturer. The manufacturer promises CWB will have the bike at the store on January 3.

December 30: Declared and paid dividends of $500.

Here is other information on activity that occurred during the period.

CWB offers bike tune-ups for $80 each. CWB’s employees are experts in adjusting brakes. Below is the number of tune-ups performed in each month. All customers pay in cash. (For recording the transacaitons, you can assume all tune-ups are done the last day of the month).

CWB has the following purchases and sales of racing bikes:

All purchases were made using cash except the October 21st purchase for which CWB obtained three-months credit from the bike supplier.

The tax rate is 30%.

Cherry & White Bike COmpany

Trial Balance