Jerome Company provided the following information for the month of December 2022: Balance per bank statement Balance per ledger Outstanding checks Deposit in transit Service Charge Proceeds of bank loan Customer's check charged back by the bank due to absence of signature Deposit of P100,000 incorrectly recorded by bank as NSF Check Note collected by the bank Erroneous debit memo of December 28, 4,000,000 2,700,000 600,000 475,000 10,000 940,000 Prepare bank reconciliation statement. 50,000 10,000 150,000 435,000 to charge company's account 200,000 Deposit from supplier made after bank's cutoff 300,000

Jerome Company provided the following information for the month of December 2022: Balance per bank statement Balance per ledger Outstanding checks Deposit in transit Service Charge Proceeds of bank loan Customer's check charged back by the bank due to absence of signature Deposit of P100,000 incorrectly recorded by bank as NSF Check Note collected by the bank Erroneous debit memo of December 28, 4,000,000 2,700,000 600,000 475,000 10,000 940,000 Prepare bank reconciliation statement. 50,000 10,000 150,000 435,000 to charge company's account 200,000 Deposit from supplier made after bank's cutoff 300,000

FINANCIAL ACCOUNTING

10th Edition

ISBN:9781259964947

Author:Libby

Publisher:Libby

Chapter1: Financial Statements And Business Decisions

Section: Chapter Questions

Problem 1Q

See similar textbooks

Similar questions

Approved CAE_BSA BSMA BSAIS BSIA_ACC 124_Sombilon.Aguilar (1).pdf - Foxit Reader File Home Comment Fil & Sign View Form Protect Share Connect Help Tell me what you want to do... Find O SnapShot B Clipboard O Fit Page TI T 110.51% A Link File Attachment D Fit Width D Fit Visible Rotate Left Bookmark Le Image Annotation Hand Select Actual Reflow Typewriter Highlight Rotate Right | Audio & Video Size Tools View Comment Links Insert PDF 4 Word Convert Start Approved CAE_BSA BS... PDF 2 Word DAIF checks of customers returned by bank Error in recording a check in the book. The correct amount as paid by the bank is P100,000 instead of P200,000 as recorded in the book The correct cash balance under current assets on December 31, 2019 is 500,000 100,000 Problem 11 The accounts of DMCI Holdings, Inc. revealed the following facts on August 31,2019. Balance of bank statement 1,200,000 Outstanding checks, August 31: Number 555 10,000 55,000 40,000 25,000 65,000 70,000 275,000 761 UM 762 763 764 765…
Ch1 Question 2: A long-text entry will be truncated if the cell to the right is in use. Answer: A. True B. False Question 1: Which of these is true about using Undo? Answer: A. It can only be used in certain circumstances. B. Previous actions can be undone in any order. C. The Redo command must be used before the Undo command is available. D. The user must be aware of those commands that cannot be undone, as Excel will not provide any indication of these.
Access the Recurring Transactions List from the: Multiple Choice Navigation Bar Gear icon (+) New icon None of the choices is correct.
Can someone check and tell me if my answer is correct?
QUESTION 2 Suppose you are working in Excel and you notice that the A column header and the 1 row label are both highlighted in yellow as shown: What can you conclude from this state of the workbook? Tables IustialioNIS 1 2 3 O A1 A B C D cell A1 is the active cell there is an error in your worksheet the worksheet is locked to keep users from changing it
AutoSave Off File Home Insert Page Layout ch04_p24_build_a_model v Search Data Review View Automate Formulas 10 AA =1 Arial Paste BIU v Clipboard Z BA Font v General $%90-00 2 Alignment E Number [ M64 fx A B C D E F G H 79 80 Help H Insert く Delete Formatting Conditional Format as Cell Table Styles Format Styles Cells 81 f. Now assume the date is 10/25/2021. Assume further that a 12%, 10-year bond was issued on 7/1/2021, pays 82 interest semiannually (January 1 and July 1), and sells for $1,100. Use your spreadsheet to find the bond's 83 84 Refer to this chapter's Tool Kit for information about how to use Excel's bond valuation functions. The model finds the 85 price of a bond, but the procedures for finding the yield are similar. Begin by setting up the input data as shown below: 86 87 Basic info: J K Σ WE◊ David N M << Z ANSE So Filt Ed 88 Settlement (today) 89 Maturity 90 Coupon rate 91 Current price (% of par) 92 Redemption (% of par value) 93 Frequency (for semiannual) 94 Basis…
AutoSave On Exam 2 ch 14-16.xlsx - Saved - O Search Rolando Borjas Jr. 困 File Home Insert Page Layout Formulas Data Review View Help A Share P Comments E A I AutoSum - Fill v X Cut - A A° 22 Wrap Text Calibri 11 General B Copy Paste BIU v A v EEE E E E Merge & Center $ • % 9 8 -98 Conditional Format as Cell Insert Delete Format Sort & Find & Ideas Sensitivity S Format Painter Formatting v Table v Styles v O Clear v Filter v Select v Clipboard Font Alignment Number Styles Cells Editing Ideas Sensitivity AG28 fe P R S V Y AA АВ AC AD AE AF AG АН Al AJ AK AL AM AN AO AP AQ AR AS 16 The Annapolis Corporation's stockholders' equity accounts have the following balances as of January 1, 2016: 12% preferred stock, cumulative, $50 par, 10,000 shares issued and outstanding $ 500,000 5 Common stock, $10 par (100,000 shares issued and outstanding) 1,000,000 Additional paid-in capital: common 1,000,000 6 1,000,000 7 Retained earnings 3,750,000 8 Total stockholders' equity 6,250,000 9 10 Annapolis…
Question 7 Answer saved Points out of 1.0 P Flag question The MID function in Excel requires how many arguments? Select one: O a. 5 O b. 4 O c. 2 d. 3 Clear my choice
AutoSave Normal 因 Document1 - Word Search badiya aldujaili ff BА EN File Home Insert Draw Design Layout References Mailings Review View Help A Share O Comments X Cut Calibri (Body) v 11 - A^ A Aav A E E O Find - AaBbCcDc AaBbCcDc AABBCC AABBCCC AaB AABBCCC AaBbCcDa 自Copy Paste S Replace В IUvab х, х* А 1 Normal 1 No Spac. Heading 1 Heading 2 Title Subtitle Subtle Em.. A Select v Dictate Editor Format Painter Clipboard Font Paragraph Styles Editing Voice Editor 2 3 4 Winter Company reported the following for the most recent month: Physical Units 700 Beginning work in process (60% complete) Units transferred in (started) during month Ending work in process 4,800 950 Materials are added at the end of the process and conversion costs are added evenly throughout the process. If equivalent whole units of production for conversion using the weighted average were 4,816, what percent complete was ending work in process at the end of the month? (Round to the nearest whole percent.) а. 20% b. 16%…
AutoSave Off File Home Module ThreeProblem Set Question3 ⚫ Saved to this PC Search Insert Page Layout Formulas Data Review View Automate Help ✗Cut Calibri 12 Α' Α' ab Wrap Text Text Copy ▾ Paste B I U ~A~ Merge & Center $ % 9 +0.00 Format Painter Clipboard √☑ Font Б Alignment √☑ Number Г A1 A B C D E F G H Accent3 Accent4 Accent5 Conditional Format as Formatting Accent6 Comma Comma [0] Table ▾ Styles Katherine Apuzzo KA Comments Share ☐☐ > AutoSum ✓ ĄT பப Fill Insert Delete Format Sort & Find & Add-ins > Clear Filter Select Cells Editing Analyze Data Add-ins J K L M N о P Q R S T U V W X Y ✓ ✓ ✓ fx Function: MAX; Formulas: Subtract; Divide; Cell Referencing 1 Function: MAX; Formulas: Subtract; Divide; Cell Referencing 2 3 BE5.7 - Using Excel to Determine Profitability Given a Constrained Reso 4 PROBLEM 5 Rachel wants to use her knitting skills to make a little extra money so she 6 can enjoy a theatre weekend with her besties. She's got the pattern down 7 for a hat, scarf, and mittens,…
AutoSave C. Home Insert Draw Page Layout Formulas Data Review X Times New Roman v 10 A A == Paste B I U v V A > Chapter 15 Build A Model.xlsx Automate General $%9 Read-Only Tell me Conditional Formatting Insert v Format as Table Delete v 00 20 .00 <-→0 Editing Cell Styles v Format View B C D E F G H I 0% 10% 20% 30% 40% 50% 60% 70% 80% 175 65 Xvfx A 66 67 68 69 Additional: using the (hypothetical) free cash flow stream below, calcuate and graph the NPVs (y-axis) against the various 70 Debt/Value Ratios (x-axis) in the space below (similar to Figure 15-8): 71 72 Time 73 FCF 74 0 1 2 3 4 5 -1200500 200000 350000 425000 350000 265000 Debt/Value WACC (from NPV (aka 75 Ratio above table) Firm Value) 76 0% 8.900% 77 10% 8.640% 78 20% 8.488% 79 30% 8.462% 80 40% 8.796% 81 50% 9.520% 82 60% 10.724% 83 70% 12.078% 84 85 86 $1.20 Build a Model + Ready Accessibility: Investigate MAY 6 44 W
LutoSave 日 Off UnitlILabAssignment_Question1 O Search (Alt-Q) Protected View Home Insert Draw Page Layout Formulas Data Review View Help PROTECTED VIEW Be careful-files from the Internet can contain viruses. Unless you need to edit, it's safer to stay in Protected View. Enable Editing fx Formula: Multiply, Subtract; Cell Referencing A D E F G H. K Formula: Multiply, Subtract; Cell Referencing Using Excel to Record Stock Entries Student Work Area PROBLEM Required: Provide input into cells shaded in yellow in this template. Select account names from the drop-down lists. Use cell references to the data area. Use mathematical formulas to calculate any amounts not given. On May 10, Jack Corporation issues common stock for cash. Shares of stock issued Par value per share 2,000 24 %24 10.00 Amount at which stock issued 18.00 Journalize the issuance of the stock. 10 11 Date Debit Credit 12 May 10 13 14 15 16 17 18 19 20 21 22 23 25 26 27 28 29 30 31 32 33 Enter Answer Ready 24