Q1: Adjusted cash receipts for the month of March?Q2: Adjusted cash disbursements for the mont of March? The following information relates to the cash in bank of HALLOWED Company. Their actountatit has just resigned a month ago and was not able to complete the bank reconciliation for the previous andcurrent month.January 31P1.600,000Cash balance, per bookBook debits for the monthBook credits for the monthDeposits in transitOutstanding checksFebruary 28P1, 475,500P500 500P625,00020 77013.030March 30P1,713,000753 500516,000-0-7.81015 0001,500Cash balance., per bankBank creditsBank debitsMonthly service chargesInterest earned on depositP1.588.500P1424,06019:430613 8 70PI.744,460797220476,8201,5002750S009005002,200Additional information:a. The only debit memos were the monthly bank charges, and the only credit memos were the nonthly nterest earned.b. For the month of February a check pavable to HALLOWED in the amount of P16.000 was tecorded in the baoks as P61.000 The eror was discovered on March 2, and a correcting entry wasmade. The bank accounted for this check correctlyc. For the month of March, a check payment to HALLWAY was credited by the bank to HALLOWED The check was for P22400. and no correction has been made vet.Prepare a proof of cash schedule to determine the following amounts:

Bank reconciliation-The balance is of bank in cash and the bank book doesn't match sometimes. This…

15,000 1,500 P1.588,500 following information relates to the cash in bank of HALLOWED Company. Their accountant has just resigned a month ago and was not able to complete the bank reconciliation for the previous and current month. Cash balance, per book Book debits for the month Book credits for the month Deposits in transit Outstanding checks Cash balance, per bank Bank credits Bank debits January 31 P1.600,000 March 30 P1,713,000 753.500 516,000 -0- 7.810 PI 744 460 797-220 476,820 February 28 P1 475,500 P500 500 P625,000 20.770 13.030 P1424,060 Monthly service charges Interest earned on deposit 500 2/500 149,430 619.870 900 2,200 1,500 2,750 Additional information: a. The only debit memos were the monthly bank charges, and the only credit memos were the monthly interest earned. b. For the month of February, a check payable to HALLOWED in the amount of P16.000 was recorded in the books as P61,000 The error was discovered on March 2, and a correcting entry was made. The bank accounted for this check correctly c. For the month of March, a check payment to HALLWAY was credited by the bank to HALLOWED The check was for P22,400 and no correction has been made yet.

15,000 1,500 P1.588,500 following information relates to the cash in bank of HALLOWED Company. Their accountant has just resigned a month ago and was not able to complete the bank reconciliation for the previous and current month. Cash balance, per book Book debits for the month Book credits for the month Deposits in transit Outstanding checks Cash balance, per bank Bank credits Bank debits January 31 P1.600,000 March 30 P1,713,000 753.500 516,000 -0- 7.810 PI 744 460 797-220 476,820 February 28 P1 475,500 P500 500 P625,000 20.770 13.030 P1424,060 Monthly service charges Interest earned on deposit 500 2/500 149,430 619.870 900 2,200 1,500 2,750 Additional information: a. The only debit memos were the monthly bank charges, and the only credit memos were the monthly interest earned. b. For the month of February, a check payable to HALLOWED in the amount of P16.000 was recorded in the books as P61,000 The error was discovered on March 2, and a correcting entry was made. The bank accounted for this check correctly c. For the month of March, a check payment to HALLWAY was credited by the bank to HALLOWED The check was for P22,400 and no correction has been made yet.

FINANCIAL ACCOUNTING

10th Edition

ISBN:9781259964947

Author:Libby

Publisher:Libby

Chapter1: Financial Statements And Business Decisions

Section: Chapter Questions

Problem 1Q

See similar textbooks

Related questions

Q: The following information as to earnings and deductions for the weekly pay period ended March 9 was…

A: Payroll Expenses: The amount paid to the human resources of any business organization is termed…

Q: 28. The average length of time between the purchase of raw material and labor and the payment of…

A: For a company to generate cash, the process begins with purchasing raw materials which are then…

Q: Item Prior year Current year Accounts payable 8,198.00 7,775.00 Accounts receivable 6,030.00…

A: In the Given question we require to calculate the firm's total changes in cash from the prior year…

Q: You purchase goods on an invoice dated February 5 of a leap year, with terms of 5/10-90X. Calculate…

A: Discount: Price reductions or the sale of anything at a lower price than the item's regular retail…

Q: Find cash conversion cycle. Inventory conversion period = 50 days Average collection period =…

A: Cash conversion cycle is a measure which was used to find the required time to needed to convert the…

Q: rmining federal income withholding found?

A: Employers are required to withhold the pay of the employees to extent of the tax liability of the…

Q: Month evious Month's Balance Finance Charge (in 5) (in 5) Purchases and Cash Advances Payments and…

A: Credit card are now popular now days and provide short term money to buy anything without paying…

Q: a payment such as an utility bill (like electricity) for the month would include?

A: In this transaction, cash is paid for monthly utility bill. Utility bill is an expense,…

Q: Required information [The following information applies to the questions displayed below] Cash…

A: Horizontal analysis of financial statement means where the amount of two different period is…

Q: If a business collects cash when the gift card is sold, how can gift card sales in December result…

A: Gift cards are mostly sold by a retailer to a buyer for cash. The buyer can then redeem the gift…

Q: The payroll register for Schmidt Company for the week ended April 29 indicated the following:…

A: Note:- Dear student Accounting equations are not done because we didn't find any instructions in…

Q: How much is the company's expected cash disbursement for merchandise in the month of April? Multiple…

A: Cash Disbursement for Merchandise in the month of April = 40% of Merchandise April's purchase plus…

Q: At December 1, 2021, Concord Company's accounts receivable balance was $1740. During December,…

A: Ending accounts receivable balance = Beginning accounts receivable balance + Credit sales during the…

Q: Calculate the Accounts Receivable Turnover for 2021 using the following information: Net Sales…

A: The ratio analysis helps to analyze the financial statements of the business on the basis of…

Q: Which of the following would NOT be considered a cash equivalent? OA. Foreign currency B. Money…

A: Step 1 Cash Equivalent Cash equivalents are assets-based short-term investment securities with a…

Q: a. The cash balance on December 1 is $44,400. b. Actual sales for October and November and expected…

A: Expected cash collection for the month = Cash sales + Collection of credit sales in the month…

Q: es a. Fill in the following table from Appendix B. Note: Round your answers to 3 decimal places.…

A: The Present Value factor or simply PV factor is the present value of $1 in certain future year using…

Q: a. From the following list of balances, prepare the Accounts Receivable Control Account for the…

A: Accounts Receivable: Accounts receivable indicates the amounts which company has not received from…

Q: Need Help

A: Step 1:The ending cash balance for a period should be equal to the sum of the beginning cash balance…

Q: Cash received in January for a credit sale made in December will: A.Increase cash and sales revenue…

A: As per accrual basis accounting, the revenue and expenses should be recorded in the month they are…

Q: b. Prepare a schedule of monthly cash payments for June through September. Note: Input all amounts…

A: A cash budget is prepared by the companies where they estimate the cash inflows and cash outflows…

Q: 10. You purchase goods on an invoice dated July 27 with terms of 3/10 EOM. Determine (a) the last…

A: Since you have posted a question with multiple questions, we will solve the first one for you. If…

Q: Finish the Income Statement and Balance Sheet using the data provided, and calculate the final total

A: An income statement is a financial report that indicates the revenue and expenses of a business. It…

Q: Schedule of cash payments for a service company Horizon Financial Inc. was organized on February 28.…

A: Budgeting is a significant piece of the business procedure. In absence of budgeting, a business…

Q: Widmer Company had gross wages of $370,000 during the week ended June 17. The amount of wages…

A: In the accounting books of the business organizations the journal entry served as a record of its…

Concept explainers

Bank Reconciliation Statement

As a commerce student, we all know that every business has to maintain a cash book to maintain all his cash and bank transactions. A cash book is a book which has two columns, one cash column and one bank column.

Question

Q1: Adjusted cash receipts for the month of March? Q2: Adjusted cash disbursements for the mont of March?

The following information relates to the cash in bank of HALLOWED Company. Their actountatit has just resigned a month ago and was not able to complete the bank reconciliation for the previous and
current month.
January 31
P1.600,000
Cash balance, per book
Book debits for the month
Book credits for the month
Deposits in transit
Outstanding checks
February 28
P1, 475,500
P500 500
P625,000
20 770
13.030
March 30
P1,713,000
753 500
516,000
-0-
7.810
15 000
1,500
Cash balance., per bank
Bank credits
Bank debits
Monthly service charges
Interest earned on deposit
P1.588.500
P1424,060
19:430
613 8 70
PI.744,460
797220
476,820
1,500
2750
S00
900
500
2,200
Additional information:
a. The only debit memos were the monthly bank charges, and the only credit memos were the nonthly nterest earned.
b. For the month of February a check pavable to HALLOWED in the amount of P16.000 was tecorded in the baoks as P61.000 The eror was discovered on March 2, and a correcting entry was
made. The bank accounted for this check correctly
c. For the month of March, a check payment to HALLWAY was credited by the bank to HALLOWED The check was for P22400. and no correction has been made vet.
Prepare a proof of cash schedule to determine the following amounts:

Expert Solution

This question has been solved!

Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.

SEE SOLUTION Check out a sample Q&A here

Step 1: Define the concept of bank reconciliation.

VIEW

Step 2: Determine the Adjusted cash balance, March 31

VIEW

Step 3: Determine adjusted balance on March 31

VIEW

Solution

VIEW

Step by step

Solved in 4 steps

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.

Similar questions

Determine the ending balance of each of the following T-accounts. Cash 290 490 210 500 Supplies 11,900 3,000 Wages Payable 890 240 250 5,700 890 Accounts Payable 3,900 6,300 Cash 13,700 Accounts Receivable 1,550 16,700 990 290 6,300 340 340 340 290 6,400 7,900 3,200
Stark company has the following adjusted accounts and normal balances at its December 31 year-end. $ 15,000 Accumulated depreciation-Buildings 2,900 Accounts receivable 580 Utilities expense 3,500 Interest payable 800 Unearned revenue 18,000 Supplies expense 7,900 Buildings 2,200 Stark, Withdrawals 48,800 Depreciation expense-Buildings 40,000 Supplies Notes payable Prepaid insurance Interest expense Accounts payable Wages payable Cash Wages expense Insurance expense Stark, Capital Services revenue $ 19,000 4,800 1,700 260 1,000 280 80,000 5,000 4,000 1,000
Jayden's Carryout Stores has eight locations. The firm wishes to expand by two more stores and needs a bank loan to do this. Mrs. Wilson, the banker, will finance construction if the firm can present an acceptable three-month financial plan for January through March. The following are actual and forecast sales figures: November December Actual $ 240,000 January 260,000 February March Forecast Additional Information $ 320,000 April forecast $360,000 360,000 370,000 Of the firm's sales, 60 percent are for cash and the remaining 40 percent are on credit. Of credit sales, 30 percent are paid in the month after sale and 70 percent are paid in the second month after the sale. Materials cost 30 percent of sales and are purchased and received each month in an amount sufficient to cover the following month's expected sales. Materials are paid for in the month after they are received. Labor expense is 40 percent of sales and is paid for in the month of sales. Selling and administrative expense…
Item Prior year Current year Accounts payable 8,112.00 7,889.00 Accounts receivable 6,029.00 6,526.00 Accruals 981.00 1,445.00 Cash ??? ??? Common Stock 10,050.00 11,831.00 COGS 12,659.00 18,136.00 Current portion long-term 5,054.00 5,053.00 debt Depreciation expense 2,500 2,814.00 Interest expense 733 417 Inventories 4,101.00 4,816.00 Long-term debt 14,355.00 13,032.00 Net fixed assets 51,776.00 54,131.00 Notes payable 4,395.00 9,850.00 Operating expenses (excl. 13,977 depr.) 18,172 Retained earnings 28,273.00 29,816.00 Sales 47,524 Taxes 2,084 2,775 What is the firm's cash flow from operations? Submit Answer format: Number: Round to: 0 decimal places.
6.Determine the number of days of the loan. Loan Date Due Date Number of Days June 24 October 12
Given: Cash Receipts for September =PHP 305,450; October = PHP 85,405; and November =PHP 375,195. Cash Disbursements for September =PHP 215,485; October = PHP 250,265; and November = PHP 310,525. Beginning Cash Balance (September) = PHP 35,975. Minimum Monthly Cash Balance Needed = PHP 34,425. The ending cash for September is PHP O 160,365 O 125,940 O 89,965 O 91,515
Find the new balances and adjusted balanced in the table below Check Service Statement Register Charge Balance Balance 1 $275.14 2 378.95 3 1,591.40 4 1,202.91 5 1,861.20 $4.81 4.35 6.20 0.00 0.00 New Balance $549.95 231.36 1,027.33 2,174.00 2,361.40 Outstanding Checks, Payments/Debits $529.63 190.00 0.00 1,046.20 812.14 Outstanding Deposits $250.01 333.24 557.87 75.11 311.94 5b) What do you notice about all of the new balances and adjusted balances in the above table? Adjusted Balance
Cashbalance,beginning.....................P9 P ? P ? P? P?Add collectionsfromcustomers..... ? ? 125 ? 391Totalcash available................... 85 ? ? ? ?Less disbursements:Purchaseofinventory..................... 40 58 ? 32 ?Operatingexpenses............... ? 42 54 ? 180Equipmentpurchases................... 10 8 8 ? 36Dividends.......................... 2 2 2 2 ?Totaldisbursement.................... ? 110 ? ? ?Excess (deficiency) of cash availableOrdisbursements... ...................... (3) ? 30 ? ? Financing:Borrowings......................... ? 20 - - ?Repayments (including interest)*.. - - (?) (7) (?)Total financing......................... ? ? (?) (?) ?Cash balance, ending................... P ? P ? P ? P ? P ? *Interest will total P4, 000 for the year.
Bramble Company's budgeted sales and direct materials purchases are as follows. January February 268,400 March Budgeted Sales $244.000 (a) 305,000 Bramble's sales are 30% cash and 70% credit. Credit sales are collected 10% in the month of sale, 50% in the month following sale, and 36% in the second month following sale; 4% are uncollectible. Bramble's purchases are 50% cash and 50% on account. Purchases on account are paid 40% in the month of purchase, and 60% in the month following purchase. (b) Budgeted D.M. Purchases Prepare a schedule of expected collections from customers for March. Total collections $36,600 43.920 46,360 BRAMBLE COMPANY Schedule of Expected Collections from Customers Total payments $ March Prepare a schedule of expected payments for direct materials for March. BRAMBLE COMPANY Schedule of Expected Payments for Direct Materials March
Example Cash and cash equivalents Blank 1 Step 1: Blank 1; - Blank 2; = Blank 3; Step 2: Blank 4; ÷ Blank 5; = Blank 6 % Blank 2 Blank 3 Blank 4 Blank 5 Blank 6 Add your answer Add your answer Add your answer Add your answer Calculate the 2022 Horizontal Analysis variance of "Sales Revenue" in %. Fill in the equations using the financial statements provided (no symbols or commas) and the % should be in a XX.XX format: Add your answer 2022 Add your answer $330 Last saved 3:49:34 PM 2021 $360 2022 2021 # -$30 13 OF Answer / 2021 -0.083333333 JESTIONS REMAINING Update to % -8.30%
An invoice dated April 22 shows a net price of $175.00 with the terms 3/10, n/30. What is the latest date the cash discount is allowed?
Dilly Farm Supply is located in a small town in the rural west. Data regarding the store's operations follow: • Sales are budgeted at $305,000 for November, $325,000 for December, and $225,000 for January. • Collections are expected to be 65% in the month of sale and 35% in the month following the sale. The cost of goods sold is 80% of sales. • The company desires to have an ending merchandise inventory at the end of each month equal to 70% of the next month's cost of goods sold. Payment for merchandise is made in the month following the purchase. • Other monthly expenses to be paid in cash are $22,600. Monthly depreciation is $28,500. . Ignore taxes. Assets Cash: Balance Sheet October 31 Accounts receivable Merchandise inventory Property, plant and equipment, net of $624,000 accumulated depreciation Total assets Liabilities and Stockholders' Equity Accounts payable Common stock Retained earnings Total liabilities and stockholders' equity The difference between cash receipts and cash…