Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Vincent Fabron Automobiles distributes automobile parts to service stations and repair shops. The business is owned and managed by Vincent Fabron who started the
Vincent Fabron Automobiles distributes automobile parts to service stations and repair shops. The business is owned and managed by Vincent Fabron who started the business on April 1, 2021. Vincent Fabron Automobiles has a monthly accounting period. The Unadjusted Trial Balance was prepared on September 30, 2021, which is shown below. Account Name Dr Cr 4,950,000 30,000 750,000 7,010,000 Cash Petty Cash Fund Notes Receivable, due March 31 2022 Accounts Receivable Allowance for Doubtful Accounts Interest Receivable Merchandise Inventory Warehouse Supplies Office Supplies Prepaid Insurance Warehouse Equipment Accumulated Depreciation - Warehouse Equipment Office Equipment Accumulated Depreciation - Office Equipment Notes Payable, due June 30 2022 Accounts Payable Interest Payable Notes Payable, Long term Vincent Fabron, Capital Vincent Fabron, Drawing Income Summary Sales Sales Returns and Allowances Interest Income Purchases 7,500 6,425,000 165,000 35,000 232,000 990,000 470,000 1,532,500 420,000 23,150,000 190,000 15,000 25,000 750,000 2,845,000 20,000 850,000 14,838,500 50,515,000 29,000 Freight In Purchase Returns and Allowances Purchase Discounts Delivery Expense Depreciation Expense - Office Equipment Depreciation Expense - Warehouse Equipment Doubtful Accounts Expense Insurance Expense Interest Expense Office Supplies Expense Rent Expense Repairs Expense Salaries Expense - Warehouse Salaries Expense - Office Salaries Expense - Sales SSS, Philhealth, Pagibig Expenses Supplies Expense - Warehouse Telephone Expense Travel Expense - Sales Utilities Expense . . 490,000 Rent Expense, Repairs Expense, and Utilities Expense are shared as follows: 10% for the office, 30% for the store, and 60% for the warehouse. An Excel spreadsheet is provided for you with the following tabs: WS (for 10-column worksheet) SPL (for Statement of Profit or Loss) SOE (for Statement of Owner's Equity) SFP (for Statement of Financial Position) NOTES (for Notes to Financial Statements) PCTB (for Post-Closing Trial Balance) . 1,871,250 81,000 170,000 179,000 . 493,750 200,000 61,000 280,000 185,000 5,430,000 4,250,000 7,585,000 1,580,000 290,000 164,000 1,200,000 400,000 71,077,000 537,500 462,000 71,077,000 INSTRUCTIONS: (1) Complete the adjustments section of the worksheet [WS]. Use the following information regarding unadjusted items. (a) On September 30, the firm received its utilities bill for the month of September amounting to P14,300. This remains to be unpaid at month-end. Record an adjustment for the utilities for the month of September. (b) On September 21, the firm received a 6% 90-day note for money lent to Ling Ying Wei amounting to P400,000. Record an adjustment for the accrued interest from the note for the month of September. (c) On September 30, an inventory of Warehouse Supplies and Office Supplies showed that items costing P127,000 and P12,000 were on hand respectively. Record an adjustment for the supplies used in September. (d) On July 1, 2021, the firm purchased a six-month insurance policy for P464,000. Record an adjustment for the expired insurance in September. Round-off answer to the nearest peso. (e) On April 1, 2021, the firm purchased an equipment to be used in the warehouse for P200,000. The equipment was estimated to have a useful life of five years and a salvage value of 10% of cost. Record an adjustment for depreciation on the equipment for September. (f) On April 1, 2021, the firm purchased equipment to be used in the office for P300,000. The furniture was estimated to have a useful life of five years with no salvage value. Record an adjustment for depreciation on the furniture for September. (g) The allowance for doubtful accounts is to be increased by 1% of accounts receivable. Record an adjustment for the expected loss from uncollectible accounts for the month of September. (h) On September 26, 2021, Tayane Alves contracted the firm to deliver specialized automobile part. The firm received P81,240 in advance from the customer. These parts have not been delivered by month-end and this transaction was recorded as a normal sale on the same date. Record an adjustment for the unearned revenue. (i) Based on a physical count, ending inventory was determined to be P6,48 1,600. Record an adjustment for the ending inventory. (2) Determine the net income or net loss for September and complete the worksheet [WS]. (3) Prepare a functional form Statement of Profit or Loss for the month ended September 30, 2021 [SPL]. Include any supporting notes to financial statements [NOTES]. (4) Prepare a Statement of Owner's Equity for the month ended September 30, 2021 [SOE]. (5) Prepare a report form Statement of Financial Position as of September 30, 2021 [SFP]. Include any supporting notes to financial statements [NOTES]. (6) Prepare a post-closing Trial Balance as of September 30, 2021 [PCTB].
Step by Step Solution
★★★★★
3.49 Rating (149 Votes )
There are 3 Steps involved in it
Step: 1
1 2 3 Ten Column Worksheet Notes 1 The items given in the adjustments will be considered as unrecord...Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started