SANCHEZ COMPUTER CENTER

21 Oct SANCHEZ COMPUTER CENTER

SANCHEZ COMPUTER CENTER

The Sanchez Computer Center currently has an $10,900 balance in Accounts Receivable. Here is a current schedule of Accounts Receivable:

Sanchez Computer Center
Schedule of Account Receivable
March 31, 201X
Taylor Golf		$3,200
Vita Needle		6,800
Accu Pac		900
Total		$10,900

Figure 1

Tasks

Although Accu Pac’s account is not 90 days past due, Freedman has determined that it is necessary to write off the entire balance because the business has been foreclosed. Make the necessary journal entry using the direct write-off method.

1. The following accounts have been added to the chart of accounts: Bad Debt Expense #5140.

2. Open Kellogg’s Annual Reports See Supplemental Financial Data and find the balance in Allowance for Doubtful Accounts for the most recent year.

3. Sigmund Company completed the following transactions in 2012:

· Jan. 9     Sold merchandise on account to Roger’s Supply, $1,200.

· Jan. 15     Wrote off the account of Pete Ramirez as uncollectible because of his death, $500.

· Mar. 17     Received $450 from Roland Co., whose account had been written off in 2011. The account was reinstated and the collection recorded.

· Apr. 9     Received 18% of the $4,100 owed by Lane Danks. The remainder was written off as uncollectible.

· June 15     The account for Mae’s Garage was reinstated for $1,500. The account was written off three years ago and collected in full today.

· Oct. 18     Prepared a compound entry to write the following accounts off as uncollectible: Jim’s Diner, $220; Kross Auto, $460; Reece’s Hardware, $800.

· Nov. 12     Sold merchandise on account to J.B. Rug, $2,200.

· Dec. 31     Based on an aging of Accounts Receivable, it was estimated that $7,000 will be uncollectible out of a total of $165,000 in Accounts Receivable.

· Dec. 31     Closed Bad Debts Expense to Income Summary.

From these transactions as well as the following additional data, complete a–c:

	Acct. No.	Balance
Allowance for Doubtful Accounts	114	$4,200
Income Summary	312
Bad Debt Expense	612

Figure 2

a. Journalize the transactions.

b. Post to Allowance for Doubtful Accounts, Income Summary, and Bad Debts Expense accounts as needed.

c. Prepare a current assets section of the balance sheet. Ending balances needed are as follows: Cash, $13,500; Accounts Receivable, $165,000; Office Supplies, $2,100; Merchandise Inventory, $105,000; Prepaid Rent, $1,350

4. Given the following information and the information in Figure 2,complete a–c.

a. Prepare on December 31, 2012, the adjusting journal entry for Bad Debts Expense.

b. Prepare a partial balance sheet on December 31, 2012, showing how net realizable value is calculated.

c. If the balance in the Allowance for Doubtful Accounts were a $330 debit balance, journalize the adjusting entry for Bad Debts Expense on December 31, 2012.

Balances: Cash, $28,000; Accounts Receivable, $193,000; Allowance for Doubtful Accounts, $330; Merchandise Inventory, $16,000.

Lake Co.
December 31, 2012
			Estimated Percent	Estimated Amount Needed
			Considered to be Bad	in Allowance for
		Amount	Debts Expense	Doubtful Accounts
	Not yet due	$170,000	6%
	0 – 60	8,000	10%
	61 – 180	12,000	23%
	Over six months	3,000	32%
		$193,000

Figure 3

5. Journalize entries for the following situations (assume direct write-off method).

· Situation 1: Wrote off Kathy Mark as a bad debt two years after the sale of $80.

· Situation 2: Reinstated Kathy Mark, who sent in her past due amount two years after it had been written off.

· Situation 3: Wrote off Kathy Mark as a bad debt two years after the sale for $80. (assume allowance method)

· Situation 4: Reinstated Kathy Mark, who sent in her past due amount.

6. Roberts Company had credit sales of $180,000 during 2012. The balance in Allowance for Doubtful Accounts is a $970 debit balance. Journalize the Bad Debts Expense for December 31 using each of the following methods:

a. Bad Debts Expense is estimated at 1.0% of credit sales.

b. The aging of Accounts Receivable indicates that $2,300 will be required in the Allowance account to cover Bad Debts Expense.

WEEK 2

Assignment:

Exercise #1: Journalize the following entries for (1) the buyer and (2) the seller for 201X. Record all entries for the buyer first.

· June 11    LePorte Company sold $9,000 of merchandise on account to Ramsey Company.

· July 11     LePorte Company received a 90-day, $3,000, 16% note for a time extension of a past due account of Ramsey Company.

· Oct. 9       Collected the Ramsey Company note on the maturity date.

· Oct. 9       Assume Ramsey Company defaulted on its July 11 note and record the dishonored note.

· Oct. 15     Ramsey Company paid the note receivable that was dishonored on October 9 (no additional interest is charged).

Exercise #2: Journalize the following transactions for Alden Company for 201X:

· Apr. 18     Received a $14,000, 90-day, 9% note from Becky Falcon in payment of account past due.

· May  9      Wrote off the Francis Cleary account as uncollectible for $620. (Alden uses the Allowance method to record bad debts.)

· July 17     Becky Falcon paid Alden the note in full.

· Nov. 11    Gave Daisy Company an $8,700, 40-day, 12% note as a time extension of account now past due.

· Nov. 15    Francis Cleary paid Alden amount previously written off on May 9.

· Dec. 3      Discounted its own $5,000, 140-day note at Charleston Bank at 9%.

· Dec. 5      Received a $15,000, 90-day, 10% note dated December 5 from Susan Quarter in payment of account past due.

· Dec. 11    Paid principal and interest due on note issued to Daisy Company from November 11 note.

· Dec. 16    Received a $21,000, 70-day, 12% note from Window Company in payment of account past due.

· Dec. 23    Discounted the Susan Quarter note to Pike Bank at 12%.

· Dec. 31    Recorded adjusting entries as appropriate.

Exercise #3: Open Kellogg’s Annual Reports and find the Consolidated Statement of Earnings. What was interest expense in the last two years?

 

Exercise #4: SANCHEZ COMPUTER CENTER

Several banks have offered loans to the Sanchez Computer Center for its expansion. However, Freedman wants to weigh each option to determine the best financial situation for the company. Currently, the Sanchez Computer Center is trying to collect from its customers to strengthen the cash flow of the business.

Tasks

1. Using the information provided by each bank, determine the due date and interest amount for each.

2. Bank of America  A 90-day note dated April 15 for $20,000 at a 6% interest rate

3. Bank One  A 120-day note dated April 10 for $40,000 at a 5% interest rate

4. Capital One Bank  A 75-day note dated April 5 for $30,000 at a 4% interest rate

Exercise #5: Signs of the Times

“Perfecto!” Stan shouted up to his friends Javier and Miguel. The two men had just launched their own handyman service, and Stan had given them their first job: installing his new Subway “face” sign—the sign with the Subway logo that goes on the front of the restaurant.

Six months ago, Subway had notified all franchisees that they would be required to install signs with the new logo. “To tell you the truth, Stan,” said Rashid, “I can’t see that there’s much difference between the old sign and the new one.”

“Well, it’s a rather subtle change—the Subway lettering is closer together, less curvy, and slants to the right rather than sitting straight up and down,” said Stan.

“But there’s nothing subtle about the cost,” he laughed. “Five grand!”

“Whew.” Rashid’s jaw dropped. “All that for a new slant?”

“As it happens,” said Stan, “Subway did mounds of marketing research and found that customers perceive the slanting letters to mean speedier service. Anyway, now that there’s a new logo, any stores that have the old one immediately look out-of-date.”

The $5,000, Stan mused later, was nothing compared to what he would have to spend to remodel his entire restaurant in the next year or two. Subway Restaurants had recently announced the first complete interior and exterior revamp in the company’s history. Called “Tuscany Décor,” the new design included earth tones, wood finishing, brass rails, tiled flooring, and brick textured walls. Stan was impressed when it was unveiled at the last franchisee convention; not only would the new décor be a better match for the chain’s commitment to healthy, fresh food, but it would also attract the more upscale customers moving into the area. Still, how to pay for it?

Stan was in a position not uncommon for businesses of all sizes: the need to spend money to make more money. After spending $3,000 on his new bake oven, Stan didn’t have the capital to spend $5,000 on a new sign—not to mention the thousands that he would have to spend to redo the interior with the new Tuscany décor. He checked the interest rates at his bank and calculated what it would cost him to repay a note with a principal of $5,000, an interest rate of 9%, and a time of 120 days.

“150 bucks,” thought Stan. “That’s steep. I wonder if I could do better at another bank?” Stan then checked with Country Bank. It offered him $5,000, an interest rate of 8¾%, and a time of 90 days.

“Just a little over $100 is more like it,” thought Stan, “but how can I pay it back in only three months? That really puts the pressure on. Is it worth the $41 difference to pay back the loan so fast? It’s 30 days less or $41 less. In either case I can deduct the interest from my taxes as a business expense. But, what about when I take out a loan for the remodel? The difference will be in hundreds of dollars. Hmmm. Time to call Lila!”

Tasks

1. Which loan would you take if you were in Stan’s place? Why?

2. Assume Stan wanted the loan on October 1. What is the maturity date for the 90-day loan? The 120-day loan?

3. Why do some loans use 360 days and other loans 365? Which would be better for Stan?