Vincent Fabron Automobiles distributes automobile parts to service stations and repair shops. The business is owned...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
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]. 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].
Expert Answer:
Answer rating: 100% (QA)
1 2 3 Ten Column Worksheet Notes 1 The items given in the adjustments will be considered as unrecord... View the full answer
Related Book For
College Accounting A Contemporary Approach
ISBN: 978-0077639730
4th edition
Authors: David Haddock, John Price, Michael Farina
Posted Date:
Students also viewed these accounting questions
-
The Futcher horse breeding business is owned and managed by Bob and Helen who are members of the Futcher SMSF, so they are related parties. The property has 10 hectares and on half a hectare of the...
-
On December 31, 2014, the following unadjusted trial balance was prepared, and the following data were accumulated to assist the accountant in preparing the adjusting entries and adjusted trial...
-
On December 31, 2014, the following unadjusted trial balance was prepared, and the following data were accumulated to assist the accountant in preparing the adjusting entries and adjusted trial...
-
Refer to the RMO CSMS Order Fulfillment subsystem shown in Figure. Draw a use case diagram that shows all actors and all use cases. Use a drawing tool such as Microsoft Visio if it is available.
-
Why did they need drawings of every site, building, and room?
-
Natalia, a resident of Canada, owns 100% of the shares of New Age Limited (NAL). NAL carries on scientific research and experimental development (SR&ED) activities with respect to finding the...
-
Question: The Hoffmans owned and operated a successful small bakery and grocery store. They spoke with Lukowitz, an agent of Red Owl Stores, who told them that for $18,000, Red Owl would build a...
-
Chelseas Chocolate Pies collected the following production information relating to Novembers baking operations: Requirements Complete the first two steps in the process costing procedure: 1....
-
Tom purchased 100 shares of Dalia Co. stock at a price of $123.88 four months ago. He sold all stocks today for $127.61. During the year the stock paid dividends of $5.84 per share. What is Tom's...
-
You are trying to prepare nancial statements for Bartlett Pickle Company, but seem to be missing its balance sheet. You have Bartletts income statement, which shows sales last year were $310 million...
-
PREPARE #3 ONLY PLEASE Animal Gear Company makes two pet carriers, the Cat-allac and the Dog-eriffic. They are both made of plastic with metal doors, but the Cat allac is smaller. Information for the...
-
Question 5 > The Doane Math Department held its annual Awesome Math Turtle awards yesterday. The the number of photos the paparazzi snapped at time t in minutes is given by the function p(t). Suppose...
-
Tinashe is an antique dealer and one Saturday in June 2020 he put a Picasso drawing in the window of his shop with a sign which stated: "Exceptional piece of 19th century - on offer for K50,000. If...
-
CFO wants to go to the bond market to issue debt instead of borrowing from a bank at lower interest rate. Why will the CFO go to the bond market?
-
Investing all your wealth in the portfolio with the highest Sharpe Ratio is the strategy that will give you the best chance of meeting your goals. I. Yes II. No Why?
-
American Factory" is an Oscar winning film that chronicles how a Chinese billionaire opens a new factory in Ohio, and some of the issues faced by both the American workers and the Chinese managers....
-
content area top Part 1 Which type of pie chart emphasizes one slice of the pie by representing the slice as another pie chart showing how the data in the slice are further divided? Question content...
-
Use integration by parts to evaluate the following. Check your answer by taking the derivative. x2e-xdx
-
What is the fundamental accounting equation?
-
On April 1, Moloney Meat Distributors sold merchandise on account to Fronke's Franks for $3,500 on Invoice 1001, terms 2/10, n/30. Payment was received in full from Fronke's Franks, less discount, on...
-
1. Carolina Company recently discovered that a payroll clerk had issued checks to nonexistent employees for several years and cashed the checks himself. The firm does not have any internal control...
-
1. Peter Oiler was a truck driver at the grocery chain Winn-Dixie. He was also a transvestite he liked to dress as a woman. When his supervisor at Winn-Dixie found out about his cross-dressing, Oiler...
-
3. When Walton Weiner interviewed for a job with McGraw-Hill, Inc., he was assured that the company would not terminate an employee without "just cause." Weiner also signed a contract specifying that...
-
4. ETHICS John Mundorf hired three women to work for Gus Construction Co. as traffic controllers at road construction sites in Iowa. Male members of the construction crew incessantly referred to the...
Study smarter with the SolutionInn App