Accounting 220 Help Week 4- Chapter 6 & 7
B-6.01
| Review the following items and decide if each would be more appropriately classified as: | |
| Cash | |
| Cash equivalent | |
| Neither cash nor cash equivalent | |
| (a) Currency in the petty cash box | |
| (b) Postage stamps in a file cabinet | |
| (c) The balance on deposit in a regular checking account | |
| (d) An advance to an employee for travel costs to be incurred | |
| (e) A certificate of deposit maturing in 2 years | |
| (f) A 30-day certificate of deposit | |
| (g) An investment in a government treasury security maturing in 2 years | |
| (h) A 90-day government treasury security | |
| (i) A post-dated check accepted from a customer | |
| (j) Amounts due from customers | |
| (k) Amounts paid to suppliers by check, but the supplier has not yet cashed the check |
&R&"Myriad Web Pro,Bold"&20B-06.01
B-06.01
Worksheet-B-6.01
| (a) Currency in the petty cash box |
| Cash |
| (b) Postage stamps in a file cabinet |
| (c) The balance on deposit in a regular checking account |
| (d) An advance to an employee for travel costs to be incurred |
| (e) A certificate of deposit maturing in 2 years |
| (f) A 30-day certificate of deposit |
| (g) An investment in a government treasury security maturing in 2 years |
| (h) A 90-day government treasury security |
| (i) A post-dated check accepted from a customer |
| (j) Amounts due from customers |
| (k) Amounts paid to suppliers by check, but the supplier has not yet cashed the check |
&L&"Myriad Web Pro,Bold"&12Name:
Date: Section: &R&"Myriad Web Pro,Bold"&20B-06.01
B-06.01
B-6.02
| Arctic Blast has developed a cold treatment process for killing home-invading ants and termites. Its pesticide-free process provides a highly attractive alternative to sprays and poisons. The business is growing quite rapidly and it is investing heavily in new equipment. Frank Miller is Arctic's treasurer and he is preparing a cash budget. The budget reveals that the company can anticipate periods of cash flow difficulties as they attempt to finance ever increasing amounts of receivables, inventories, and equipment. Frank is evaluating the merits of eight alternative cash management strategies. Each has a potential downside that Frank must consider. Match each item in the "strategy" list with one of the "hazards." |
| Strategy |
| Borrowing money |
| Attempting to accelerate customer collections |
| Delaying payments |
| Writing checks against future receipts not yet deposited |
| Slowing expansion plans |
| Establishing bank overdraft protection or a line of credit |
| Issuing additional capital stock |
| Planning full utilization of cash flows, with no reserves |
| Hazard |
| May necessitate offering of a discount |
| May result in unnecessary financing costs |
| May dilute ownership of existing shareholders |
| May alienate key suppliers |
| May result in unexpected shortfall |
| May be an illegal strategy |
| May give competitors an advantage |
| May result in risk of financial failure |
B-06.02
Worksheet-B-6.02
| Instructions: Pick from the drop down |
| Borrowing money |
| May result in risk of financial failure |
| Attempting to accelerate customer collections |
| Delaying payments |
| Writing checks against future receipts not yet deposited |
| Slowing expansion plans |
| Establishing bank overdraft protection or a line of credit |
| Issuing additional capital stock |
| Planning full utilization of cash flows, with no reserves |
B-6.03
| Dine-Corp International publishes ratings and reviews of the world's finest restaurants. Following are facts you need to prepare Dine-Corp's March bank reconciliation: | |
| Balance per company records at end of month | 72644.12 |
| Bank service charge for the month | 44 |
| NSF check returned with bank statement | 1440.66 |
| Note collected by the bank during the month | 45000 |
| Outstanding checks at month end | 31553.57 |
| Interest on note collected during the month | 4500 |
| Balance per bank at end of month | 144223.99 |
| Deposit in transit at month end | 7989.04 |
Worksheet-B-6.03
| Ending balance per bank statement | $ 144,223.99 | |||
| Add: | ||||
| - 0 | ||||
| Deduct: | ||||
| - 0 | ||||
| Correct cash balance | $ - 0 | |||
| Ending balance per company records | $ 72,644.12 | |||
| Add: | ||||
| $ - 0 | ||||
| - 0 | - 0 | |||
| Deduct: | ||||
| - 0 | ||||
| - 0 | - 0 | |||
| Correct cash balance | $ - 0 |
B-06.03
B-6.04
| Daniel Scott is an audit manager with the accounting firm of Nelson & Riley, CPAs. As part of the routine audit procedures for one of the firm's clients, Daniel instructed Wanda Mullins, a newly hired staff auditor, to obtain a bank statement directly from the client's bank and prepare an independent reconciliation of the Cash account. Wanda did a great job and presented Daniel with the following reconciliation. Daniel has now forwarded this document directly to you, with a request that you prepare proposed adjusting entries that need to be recorded by the client. | |||
| Ending balance per bank statement | $ 67,700.98 | ||
| Add: Deposits in transit | 13,444.12 | ||
| Deduct: Outstanding checks | |||
| #12221 | $ 16,887.34 | ||
| #12327 | 8,550.50 | ||
| #12329 | 132.74 | (25,570.58) | |
| Correct cash balance | $ 55,574.52 | ||
| Ending balance per company records | $ 52,148.55 | ||
| Add: | |||
| Payment from customer via ETF* | $ 3,445.99 | ||
| Interest earnings | 566.88 | 4,012.87 | |
| Deduct: | |||
| Reject customer credit card/charge back | 466.90 | ||
| Service charges | 120.00 | (586.90) | |
| Correct cash balance | $ 55,574.52 | ||
| * | This payment has yet to be recorded as revenue by the company. |
B-06.04
Worksheet-B-6.04
| GENERAL JOURNAL | |||||
| Date | Accounts | Debit | Credit | ||
| To record adjustments necessitated by bank reconciliation |
B-6.05
| Biscay Bay Boats established a petty cash fund for minor day-to-day expenses. Following are activities related to this fund. Prepare the necessary journal entries for petty cash. | |
| (1) | Established a $500 petty cash fund by writing a check to "cash," cashing the check, and placing the proceeds in a petty cash box entrusted to Herman Jones as custodian. |
| (2) | At the end of the month, the petty cash fund contained remaining cash of $127, and receipts for $65 postage, $123 office supplies, and $180 gasoline for company vehicles. Herman is not sure why the fund is short $5. A check payable to cash in the amount of $373 was prepared, and the funds were placed into the box. |
| (3) | At the end of the next month, the petty cash fund contained remaining cash of $35, and receipts for $265 postage, $160 office supplies, and $40 gasoline for company vehicles. A check payable to cash in the amount of $715 was prepared, and the funds were placed into the box. This amount reimburses the fund and increases its balance to $750. |
B-06.05
Worksheet-B-6.05
| GENERAL JOURNAL | |||||
| Date | Accounts | Debit | Credit | ||
| #1 | |||||
| To establish a $500 petty cash fund | |||||
| #2 | |||||
| To record expenses and replenishment of petty cash | |||||
| #3 | |||||
| To record expenses and replenishment/increase to petty cash |
B-6.06
| Piven Mining Corporation holds significant limestone deposits. One of its key customers, Kuai Oil, produces crude oil from shale deposits. This production process requires limestone, and Piven is seeing a large increase in order flow from Kuai and other shale companies. Piven's management believes Kuai's stock is undervalued, and has decided to invest excess cash in the stock of Kuai Oil. The intent of this investment is for "trading" purposes only. Following are detailed facts about the Kuai investment. You should prepare journal entries to record the investment, and necessary end-of-month adjusting entries to reflect changes for each month. | |
| May 7 | Purchased 500,000 shares of Kuai Oil at $7 per share. |
| May 31 | The fair value of Kuai's stock was $9 per share. |
| June 30 | The fair value of Kuai's stock was $5 per share. |
| July 15 | Received a dividend from Kuai of $0.10 per share. |
| July 31 | The fair value of Kuai's stock was $8 per share. |
B-06.06
Worksheet-B-6.06
| GENERAL JOURNAL | |||||
| Date | Accounts | Debit | Credit | ||
| 7-May | |||||
| To record the purchase of 500,000 shares of Kuai stock at $7 per share | |||||
| 31-May | |||||
| To record a $_ per share increase in the value of 500,000 shares of Kuai stock | |||||
| 30-Jun | |||||
| To record a $_ per share decrease in the value of 500,000 shares of Kuai stock | |||||
| 15-Jul | |||||
| To record a $0.10 per share cash dividend on the investment in Kuai stock | |||||
| 31-Jul | |||||
| To record a $_ per share increase in the value of 500,000 shares of Kuai stock |
I-6.02
| Manahan Corporation received its August 31 bank statement showing total funds on deposit of $288,090.09. This amount was $149,158.22 in excess of the balance in the general ledger Cash account. Additional information consists of the following: | |
| The company has a 1-year, $100,000, certificate of deposit. This amount is included in the total funds listed on the bank statement. Manahan classifies this security in a separate investment account in its general ledger. | |
| Interest earned on the CD was $475 during the month. This interest is free for withdrawal and is automatically posted to the regular checking account. Manahan's first notification of the amount of interest for the month is via the bank statement, and the interest income has not yet been recorded in the general ledger Cash account. | |
| Manahan Corporation received a $50,000 draft for an oil and gas lease from XTX Exploration. This draft was presented to the bank in early July. Drafts are not cash until the maker (XTX) honors them (at their option), and this process can take as long as several weeks. The bank statement included notification that XTX had honored and funded the draft in mid August. This is the first notification to Manahan of actual funding, and Manahan has not previously recorded this transaction. | |
| Manahan made a deposit late in the afternoon of August 31. The amount of the deposit was $3,666.04, but this amount did not appear on the August 31 bank statement. The bank has a sign in its lobby that says "Deposits after 3 pm will be processed on the next following business day." | |
| Manahan has authorized automatic payments to its utility company for monthly charges. Withdrawals of $1,445.99 appear in the bank statement for such utilities. This is the first notification to Manahan, and Manahan has not previously recorded this transaction. | |
| Late in August, Manahan did an online authorization for a credit card company payment. Due to a timing issue, the bank statement does not yet reflect the payment for $4,446.09. Manahan has appropriately recorded the reduction in cash in the general ledger. | |
| Manahan prepared a $3,000 payment to Sims via check #12234. Due to a bookkeeping error, Sims reported that it had not received payment. Manahan issued a $3,000 replacement check #12257. Both checks cleared the bank in August, and Sims has admitted its error. Sims will be returning $3,000 to Manahan. | |
| The bank statement included monthly service charges of $125. Manahan has not previously recorded these charges. | |
| At the end of July, three checks were outstanding (#12170, $245.55; #12200, $1,889.66; and #12202, $75). At the end of August, three checks were outstanding (#12170, $245.55; #12290, $1,333.07, and #12291, $1,117.54). | |
| A review of deposits clearing the bank revealed that Manahan had recorded a $2,000.22 deposit as $2,222.22 in the general ledger Cash and Revenue accounts. | |
| (a) | Prepare Manahan's bank reconciliation as of August 31, 20X5. |
| (b) | What is the correct balance for Cash in the August 31 balance sheet? |
| (c) | Prepare the journal entry suggested by the reconciliation. |
I-06.02
Worksheet I-6.02
| (b) | The corect Cash balance is | |||||||||||
| (a) | Ending balance per bank statement | $288,090.09 | ||||||||||
| Add: | (c) | GENERAL JOURNAL | ||||||||||
| Date | Accounts | Debit | Credit | |||||||||
| Deduct: | ||||||||||||
| To record adjustments necessitated by bank reconciliation | ||||||||||||
| Correct cash balance | ||||||||||||
| Ending balance per company records | ||||||||||||
| Add: | ||||||||||||
| Deduct: | ||||||||||||
| Correct cash balance |
I-06.02(a)
I-06.02(b)(c)
I-6.03
| Following is the September 30, 20X4 bank reconciliation for the Quiet Moose Lodge. You are also provided with the October check register and bank statement. Utilize this information to prepare October's bank reconciliation and related adjusting entry. You may assume that any discrepancies between the check register and bank statement relate to recording errors in the accounts of the Quiet Moose, and not the bank. | ||||
| Ending balance per bank statement | $ 18,344.07 | |||
| Add: | ||||
| Deposits in transit | 2,505.55 | |||
| Deduct: | ||||
| Outstanding checks | ||||
| #3444 | $ 175.00 | |||
| #3446 | 1,908.09 | (2,083.09) | ||
| Correct cash balance | $ 18,766.53 | |||
| Ending balance per company records | $ 18,696.53 | |||
| Add: | ||||
| Interest earnings | 80.00 | |||
| Deduct: | ||||
| Service charges | (10.00) | |||
| Correct cash balance | $ 18,766.53 |
I-06.03
Worksheet I-6.03
| DATE | PARTY | REF # | CHECK | DEPOSIT | Balance | Mountain Home Bank | Statement date: | October 1, 20X4 through October 31, 20X4 | |||||||||||
| Statement for: | Quiet Moose Lodge | Ending balance per bank statement | |||||||||||||||||
| 1-Oct | Balance | $ 18,766.53 | 121 Main Street | 13 River Street | |||||||||||||||
| 2-Oct | Gomez | 3448 | $ 145.99 | - 0 | 18,620.54 | P.O. Box 5566 | Patawa Township | Add: | |||||||||||
| 5-Oct | Deposit | - 0 | $ 3,400.00 | 22,020.54 | Account # 474784 | ||||||||||||||
| 7-Oct | Bryers | 3449 | 387.97 | - 0 | 21,632.57 | ||||||||||||||
| 7-Oct | Morton | 3450 | 1,204.67 | - 0 | 20,427.90 | CHECKING SUMMARY | Deduct: | ||||||||||||
| 7-Oct | Lee | 3451 | 4,664.50 | - 0 | 15,763.40 | Previous statement balance on 9-30-X4 | 18,344.07 | ||||||||||||
| 10-Oct | Morici | 3452 | 43.23 | - 0 | 15,720.17 | Total of 5 deposits for | + | 19,339.09 | |||||||||||
| 10-Oct | LaCorx | 3453 | 2,990.44 | - 0 | 12,729.73 | Total of 14 withdrawals for | - | 14,887.45 | |||||||||||
| 11-Oct | Benson | 3454 | 1,100.31 | - 0 | 11,629.42 | Interest earnings for | + | 65.66 | |||||||||||
| 12-Oct | Void | 3455 | - 0 | - 0 | 11,629.42 | Service charges for | - | 35.00 | |||||||||||
| 13-Oct | Morgan | 3456 | 695.77 | - 0 | 10,933.65 | New balance | 22,826.37 | Correct cash balance | |||||||||||
| 13-Oct | Russell | 3457 | 788.87 | - 0 | 10,144.78 | ||||||||||||||
| 14-Oct | Deposit | - 0 | 3,476.88 | 13,621.66 | |||||||||||||||
| 17-Oct | Lowen | 3458 | 3,664.34 | - 0 | 9,957.32 | CHECKS AND OTHER DEBITS | Ending balance per company records | ||||||||||||
| 19-Oct | Post Office | 3459 | 45.45 | - 0 | 9,911.87 | ||||||||||||||
| 20-Oct | Nguen | 3460 | 677.21 | - 0 | 9,234.66 | Check | Date Paid | Amount | Check | Date Paid | Amount | Add: | |||||||
| 30-Oct | Behn | 3461 | 499.00 | - 0 | 8,735.66 | 3446 | 3-Oct | 1908.09 | 3454 | 12-Oct | 1100.31 | ||||||||
| 31-Oct | Deposit | - 0 | 8,131.21 | 16,866.87 | *3448* | 5-Oct | 145.99 | *3456* | 13-Oct | 695.77 | |||||||||
| $ 16,907.75 | $ 15,008.09 | 3449 | 7-Oct | 387.97 | 3457 | 14-Oct | 788.87 | ||||||||||||
| 3450 | 7-Oct | 1204.67 | 3458 | 18-Oct | 3664.34 | ||||||||||||||
| *3452* | 10-Oct | 43.23 | 3459 | 20-Oct | 54.45 | Deduct: | |||||||||||||
| 3453 | 11-Oct | 2990.44 | 3460 | 21-Oct | 677.21 | ||||||||||||||
| Electronic funds tranfer - Patawa Water Co-op | 25-Oct | 237.34 | |||||||||||||||||
| NSF returned check - maker Stacey | 28-Oct | 988.77 | |||||||||||||||||
| NSF fee | 28-Oct | 25.00 | |||||||||||||||||
| Monthly service fee | 31-Oct | 10.00 | Correct cash balance | ||||||||||||||||
| DEPOSITS AND OTHER CREDITS | |||||||||||||||||||
| Date Posted | Amount | ||||||||||||||||||
| Customer deposit | 1-Oct | 2505.55 | |||||||||||||||||
| Customer deposit | 5-Oct | 3400.00 | |||||||||||||||||
| Collection item -- note receivable ($6500 + interest) | 11-Oct | 6774.33 | |||||||||||||||||
| Customer deposit | 14-Oct | 3476.88 | |||||||||||||||||
| Credit card sales posting | 28-Oct | 3182.33 | |||||||||||||||||
| Interest earnings | 31-Oct | 65.66 |
I-06.03
I-06.03
I-06.03
Worksheet I-6.03 part 2
| GENERAL JOURNAL | |||||
| Date | Accounts | Debit | Credit | ||
| To record adjustments necessitated by bank reconciliation |
I-06.03