Acct 502 

Horngren’s Financial and Managerial Accounting bookmark Acct 502 Horngren’s Accounting, The Financial ChaptersRead chapters 8 and 9. spreadsheet  grand canyon university  accounting for notes recievable

SModule 4 Assignment Details:

Complete the following exercises and problems in Excel:

P8-22A

P8-25A

P9-28A

P9-31A

Save the file using the filename “LastnameFirstinitial.ACC502.M#” where the # is the module number. For example, John Doe’s homework for module 1 would be saved as DoeJ.ACC502.M1.

Module 4 Assignment I LoudCloud Sy… Grand Canyon University – Digital Res… horngrens_accounting_the_financi…

P8-22a

iL Correcting internal control weakness

Each of the following situations has an internal control weakness.

a. Upside-Down Applications develops custom programs to customer’s specifica¬tions. Recently, development of a new program stopped while the programmers redesigned Upside-Down’s accounting system. Upside-Down’s accountants could have performed this task.

b. Norma Rottler has been your trusted employee for 24 years. She performs all cash-handling and accounting duties. Ms. Rottler just purchased a new Lexus and a new home in an expensive suburb. As owner of the company, you wonder how she can afford these luxuries because you pay her only $30,000 a year and she has no source of outside income.

c. Izzie Hardwoods, a private company, falsified sales and inventory figures in order to get an important loan. The loan went through, but Izzie later went bankrupt and could not repay the bank

d. The office supply company where Pet Grooming Goods purchases sales receipts recently notified Pet Grooming Goods that its documents were not pre-numbered. Howard Mustro, the owner, replied that he never uses receipt numbers.

e. Discount stores such as Cusco make most of their sales in cash, with the remainder in credit card sales. To reduce expenses, one store manager ceases purchasing fidelity bonds on the cashier.

f. Cornelius’ Corndogs keeps all cash receipts in an empty box for a week because he likes to go to the bank on Tuesdays when Joann is working.

Requirements

1. Identify the missing internal control characteristics in each situation.

2. Identify the possible problem caused by each control weakness.

         P8-22a

      Propose a solution to each internal control problem.

explanation.

113-25A  Preparing a bank reconciliation and journal entries 

The December cash records of Dunlap Insurance follow:

Cash Receipts Cash Payments

Date Cash Debit Check No. Cash Credit

Dec. 4 $ 4,170 1416 $ 860

9 510 1417 130

14 530 1418 650

17 2,180 1419 1,490

31 1,850 1420 1,440

1421 900

1422 630

Dunlap’s Cash account shows a balance of $16,240 at December 31. On 

December 31, Dunlap Insurance received the following bank statement:

Beginning Balance Deposits and other Credits: S 14E._ .

Dec. 1 EFT $ 300

Dec. 5 4,170

Dec. 10 510

Dec. 15 530

Dec. 18 2,180

Dec. 22 BC 14130 9.090

Checks and other Debits:

Dec. 8 NSF 1,0D0

Dec. 11 (check no 6) 860

Dec. 19 EFT 200

Dec. 22 (check no 7) 130

Dec. 29 (check no. 8) 650

Dec. 31 (check to 1419) 1940

Dec. 31 SC 60 (5.340)

Ending Balance 517,350

Explanations: BC-bank collection; EFT-electronic funds trauier, NSF-nonsufficient funds checks; SC-service charge

Additional data for the bank reconciliation follows:

a. The EFT credit was a receipt of rent. The EFT debit was an insurance payment.

b. The NSF check was received horn a customer.

c. The $1,400 bank collection was for a note receivable.

d. The correct amount of check 1419, for rent expense, is $1,940. Dunlap’s controller mistakenly recorded the check for $1,490.

Requirements

1. Prepare the bank reconciliation of Dunlap Insurance at December 31, 2015.

2. Journalize any required entries from the bank reconciliation.

P9-28A Accounting for mcollectible accounts using the allowance method (aging-of-receivables), and reporting receivables on the balance sheet At September 30, 2014, the accounts of Mountain Terrace Medical Center

(M MC) include the following:

Account Receivable 1 145,000

Allowance for Bad Debt (credit balance) 3,500

During the last quarter of 2014, MTMC completed the following selected transactions:

Dec. 28 Wrote off account receivable as uncollectible: Regan,

Co., 11,300; Owen Mac, $900, and Rain, Inc, $700

31 Reconled bad debts expense based on the aging 

of account receivable, as follows:

Age of Accounts

Account Receivable 1-30 Days 31-60 Days 61-90 Days Over 90 Days

1165,000

Estimated percent uncollectible $97,000

0.3% $37,000

3% $14,000

30% $17,000

35%

Requirements

1. Journalize the transactions.

2. Open the Allowance for Bad Deb. T-account, and post entries affecting that account. Keep a running balance.

3. Show how Mountain Terrace Medical Center should report net accounts receivable on its December 31, 2014, balance sheet.

P9-28A Accounting for uncollectible accounts using the allowance method

(aging-of-receivables), and reporting receivables on the balance sheet At September 30, 2014, the accounts of Mountain Terrace Medical Center (MTMC) include the following:

Account Receivable 1 145,000

Allowance for Bad Debt (credit balance) 3,500

During the last quarter of 2014, MTMC completed the following selected transactions:

Dec. 28 Wrote off account receivable as uncollectible: Regan,

Co., $1,300, Owen Mac, $900; and Rain, Inc., $700

31 Recorded bad debts expense based on the aging

of accounts receivable, as follows:

Age of Accounts

Account Receivable 1-30 Days 31-60 Days 61-90 Days Over 90 Days

1165,000

Estimated percent uncollectible $97,000

0.3% $37,000

3% $14,000

30% $17,000

35%

Requirements

1. Journalize the transactions.

2. Open the Allowance for Bad Deb. T-account, and post entries affecting that account. Keep a running balance.

3. Show how Mountain Terrace Medical Center should repon net accounts receivable on its December 31, 2014, balance sheet

P8-22a

iL Correcting internal control weakness

Each of the following situations has an internal control weakness.

a. Upside-Down Applications develops custom programs to customer’s specifica¬tions. Recently, development of a new program stopped while the programmers redesigned Upside-Down’s accounting system. Upside-Down’s accountants could have performed this task.

b. Norma Rottler has been your trusted employee for 24 years. She performs all cash-handling and accounting duties. Ms. Rottler just purchased a new Lexus and a new home in an expensive suburb. As owner of the company, you wonder how she can afford these luxuries because you pay her only $30,000 a year and she has no source of outside income.

c. Izzie Hardwoods, a private company, falsified sales and inventory figures in order to get an important loan. The loan went through, but Izzie later went bankrupt and could not repay the bank

d. The office supply company where Pet Grooming Goods purchases sales receipts recently notified Pet Grooming Goods that its documents were not pre-numbered. Howard Mustro, the owner, replied that he never uses receipt numbers.

e. Discount stores such as Cusco make most of their sales in cash, with the remainder in credit card sales. To reduce expenses, one store manager ceases purchasing fidelity bonds on the cashier.

f. Cornelius’ Corndogs keeps all cash receipts in an empty box for a week because he likes to go to the bank on Tuesdays when Joann is working.

Requirements

1. Identify the missing internal control characteristics in each situation.

2. Identify the possible problem caused by each control weakness.

Propose a solution to each internal control problem

Dunlap’s Cash account shows a balance of $16,240 at December 31. On 

December 31, Dunlap Insurance received the following bank statement:

Beginning Balance Deposits and other Credits: S 14E._ .

Dec. 1 EFT $ 300

Dec. 5 4,170

Dec. 10 510

Dec. 15 530

Dec. 18 2,180

Dec. 22 BC 14130 9.090

Checks and other Debits:

Dec. 8 NSF 1,0D0

Dec. 11 (check no 6) 860

Dec. 19 EFT 200

Dec. 22 (check no 7) 130

Dec. 29 (check no. 8) 650

Dec. 31 (check to 1419) 1940

Dec. 31 SC 60 (5.340)

Ending Balance 517,350

Additional data for the bank reconciliation follows:

a. The EFT credit was a receipt of rent. The EFT debit was an insurance payment.

b. The NSF check was received horn a customer.

c. The $1,400 bank collection was for a note receivable.

d. The correct amount of check 1419, for rent expense, is $1,940. Dunlap’s controller mistakenly recorded the check for $1,490.

Requirements

1. Prepare the bank reconciliation of Dunlap Insurance at December 31, 2015.

2. Journalize any required entries from the bank reconciliation.

P9-31a

Dec. 5 Collected in full on account from Ambiance, Corp.

31 Accrued the interest on the Creed, Inc. note. P9-31a

Record the transactions in the journal of Relaxing Recliner Chairs. Explanations

are not required. (For notes stated in days, use a 360-day year. Round to the nearest dollar.)

Accounting for notes receivable and accruing interest Learning Objective 4

Kelly Realty loaned money and received the following notes during 2014.

1. Note 3—Jan. 18, 2015

Note Date Principal Amount Interest Rate Term

(1) Aug.1 $ 24,000 17% 1 year

(2) Nov. 30 18,000 6% 6 months

(3) Dec. 19 12,000 12% 30 days

Requirements

1. Determine the maturity date and maturity value of each note.

2. Journalize the entry to record the inception of each of the three notes and also journalize a single adjusting entry at December 31, 2014, the fiscal year-end, to record accrued interest revenue on all three notes. Explanations are not required.

3. Journalize the collection of principal and interest at maturity of all three notes. Explanations are not required.

Homgren’s Accounting, The Financial Chapters, Tenth Edition, by Tracie Nobles, Brenda Mattison, and Ella Mae Matsumura. Published by Prentice Hall.