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.
-
What is UML? Discuss.
-
What is meant by the term calculated consumption?
-
Let us consider three consecutive flips of a fair and memoryless coin. There are two outcomes H and T for each flip, and eight possible scenarios: we deal with an algebra including events W = (H, H,...
-
Cartwell Products has compiled the data shown in the following table for the current costs of its three basic sources of capitallong-term debt, preferred stock, and common stock equityfor various...
-
How did the introduction of the assembly line affect Ford's factory workers?
-
Campbell Manufacturing Company (CMC) was started when it acquired $80,000 by issuing common stock. During the first year of operations, the company incurred specifically identifiable product costs...
-
You are looking to lease a car and the dealer offers you: Car price = $30,000 Monthly payments = $499 Down payment = $2,000 Lease term = 48 months Purchase price at end of lease = $12,000 What is the...
-
Belgium has two official languages: French and Dutch. Assume that about 60% of the people speak Dutch and 40% of the people speak French. Define the event A as the event that two randomly selected...
-
U.S. Treasury issues three types of Treasury securities: Treasury bills (T-bills), Treasury notes (T-notes), and Treasury bonds (T-bonds). The time to maturity (TTM) of T-bills is 12-month or less...
-
Discuss if the goal of Government Linked Corporations (GLC) is similar to those of corporations at large.
-
2 . What is the common boundary condition that is used for thermal symmetry and insulation? What are the reasons to use this boundary condition in each case? Briefly explain its mathematical basis.
-
A compost pile is 2 yards high, 2 yards long, and 2 yards wide.Does this mean that the compost pile has a volume of 2 cubic yards?Explain. Determine the volume in cubic feet of the compost pile...
-
Let f: M Y be a Lipschitz map. Let a, e Y, r > 0, T2 > 0. Let A = B(a, r), B = {x EY: d(e, x) r}. Let K = f-(AUB). Give f(K), assuming that M = R and J(K) = {Q.N.Z. 10 , N, Z, {0, 2} , [2, 3] U (4,...
-
Federated Shipping, a competing overnight delivery service, informs the customer in Problem 65 that they would ship the 5-pound package for $29.95 and the 20-pound package for $59.20. (A) If...
-
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...
-
Parents with a child in subsidized childcare in the province of Qubec, Canada, pay a basic amount and, depending on family income, may pay an additional amount. As of January 1, 2017, families with a...
-
A firm in the state of Karnataka in India can source one of its factors of production either within the state, \(F_{K}\), or from the neighboring state of Maharashtra, \(F_{M}\). Assume the quality...
-
In the Application A Beer Manufacturer's ShortRun Cost Curves," the short-run variable cost function for Japanese beer is \(V C=0.55 q^{1.67}\). If the fixed cost is 600 and the firm produces 550...
Study smarter with the SolutionInn App