Bill Travis owns two Just 4 Kids stores in Florence, SouthCarolina. He believes that the stores have been successfuland he wants to open a new store in Sumter about 30 miles west ofFlorence. Bill has been in the retail line for over 20 years,and he worked at his uncle’s hobby shop while in high school andcollege before starting his own store at the age of 25.

Two big secrets to a successful toy store operation are goodlocation and product selection. Bill’s first store is locatedin downtown Florence. Since Bill had been born and raised inFlorence, he attracted a good customer base that remained loyal tohis store after some of the giant chain related toy stores began tomove into the area. About 10 years ago, Bill saw the changein customer shopping habits and purchased a second store near aninterchange to Interstate 95 in a rapidly growing retailarea. Lots of new families had moved into the area, and Billcould not totally rely on the “good old boy” market alone tosustain his market share. This second store catered to theyounger more mobile generation that shopped at or near malls.

Bill now was looking into other markets. Sumter was notlocated on the interstate, but the area was growing because of itsproximity to the state capital of Columbia, which was just 30 milesto its west. Bill believed that the people of Sumter whocommuted to work in Columbia would prefer to limit their drivingfor shopping activities to the immediate Sumter area. Also,since Bill was a respected citizen of Florence, his reputation asan honest businessman had spread to Sumter. He believed hecould quickly build up a new customer base in that location. The big chain type stores also did not seem as interested in theSumter area, preferring instead to locate in the largermetropolitan areas of Columbia and Florence.

The appropriate toy items to feature in his stores were veryimportant. Bill felt that his area of influence was strictlyregional, and he did not have to carry much of the standardinventory of the national chain type of toy stores. His toylines were more a reflection of local interest; thus NASCAR relateditems were hot sellers. Bill’s clientele also seemedinterested in computer action games and a new line of Ya’ll talkingdolls.

Bill went to the Florence National Bank to inquire about fundingfor the new store location. He had found an abandonedfurniture store in downtown Sumter along Main Street that was upfor sale for $280,000. The store seemed to be the right sizeand at a good location. A grocery store was in the same blockwith ample off street parking. Bill brought his balance sheetfor the last two years and an income statement for the lastoperating year to the bank to support his request for a retail loanof $250,000. (Copies of the financial statements are listedat the end of the case.)

Nick Tightwad, the local bank loan vice president had been afriend of Bill’s for many years. He was a customer at Bill’stoy store on close out sales, and his bank had underwritten thefunding for the second store. Nick was excited about Bill’sexpansion goals and the prospect of another business loan with hisfriend. At the same time, Nick had to live up to hisreputation. He was not about to approve a loan unless he wasalmost 100 percent sure that the borrower would not default. Bill’s past success had alleviated much of Nick’s concern, but hestill wanted to complete a detailed analysis of the financialperformance of Just 4 Kids during the last calendar year. Upon reviewing the balance sheet, Nick noticed a drop in cashduring the last year even though Bill showed a strong profitableperformance. The current financial statements did not seem togive enough information to answer Nick’s questions and he askedBill to prepare a statement of cash flows for the year endingDecember 31, 20x7.

Just 4 Kids

Balance Sheet

December 31, 20x6

ASSETS
Cash		$ 38,500
Accounts Receivable		43,000
Inventory		126,000
Other Current Assets		17,500
Total Current Assets			$225,000
Land		$100,000
Furnishings, Fixtures & Vehicles	$150,000
Less Accumulated Depreciation	-30,000
Furnishings, Fixtures & Vehicles (net)		120,000
Building	400,000
Less Accumulated Depreciation	175,000
Building (net)		225,000
Total Long-Term Assets			445,000
Total Assets			$670,000
LIABILITIES
Accounts Payable		$ 57,500
Short-Term Notes Payable		20,000
Other Current Liabilities		13,000
Total Current Liabilities			$ 90,500
Long-Term Notes Payable			400,000
Total Liabilities			$490,500
EQUITIES
Capital		$100,000
Retained Earnings		79,500
Total Equities			$179,500
Total Liabilities and Equity			$670,000

Just 4 Kids

Income Statement

For the Year Ended December 31, 20x7

Sales Revenue		$600,000
Less Cost of Goods Sold		310,000
Gross Margin		290,000
Less Operating Expenses
Selling and Administrative	$106,200
Depreciation	20,000
Total Operating Expenses		126,200
Operating Income		163,800
Interest Expense	$50,000
Loss on Vehicle Sale	2,500
Total Other Expenses		52,500
Net Income Before Taxes		111,300
Less Income Taxes		39,300
Net Income		$72,000

Just 4 Kids

Balance Sheet

December 31, 20x7

ASSETS
Cash		$2,600
Accounts Receivable		71,000
Inventory		193,000
Other Current Assets		18,900
Total Current Assets			$285,500
Land		$100,000
Furnishings, Fixtures & Vehicles	$166,000
Less Accumulated Depreciation	-28,500
Furnishings, Fixtures & Vehicles (net)		137,500
Building	400,000
Less Accumulated Depreciation	190,000
Building (net)		210,000
Total Long-Term Assets			447,500
Total Assets			$733,000
LIABILITIES
Accounts Payable		$ 91,500
Short-Term Notes Payable		35,000
Other Current Liabilities		7,000
Total Current Liabilities			$133,500
Long-Term Notes Payable			388,000
Total Liabilities			$521,500
EQUITIES
Capital		$100,000
Retained Earnings		111,500
Total Equities			$211,500
Total Liabilities and Equity			$733,000

Required (please show your detailed work):

1. Develop a Statement of Cash Flowsfor Just 4 Kids for the year ending December 31, 20x7.

2. Analyze the performance of Just 4Kids based on the financial statements.