Question: Could you please present the FDN Trading information in a good, clear and organized accounting format? (In a Good accounting format) The following must be
Could you please present the FDN Trading information in a good, clear and organized accounting format?
(In a Good accounting format)
The following must be answered:
2. GL (General Ledger
7. NOTES (for Notes to Financial Statements) To know more information, Please use this form:
FDN Trading FDN Trading is a retail merchandising business that sells preschool learning toys. The business is owned and managed by Faith D. Nakpil who started the business on February 1, 2024. FDN Trading has a monthly accounting period. The Chart of Accounts is shown below. FDN Trading Chart of Accounts Assets Revenues 101 Cash 401 | Sales 102 Accounts Receivable 402 | Sales Returns and Allowances 103 Allowance for Doubtful Accounts 403 | Sales Discount 104 Commissions Receivable 404 | Commissions Income 105 Merchandise Invento 405 | Rent Income 106 Prepaid Advertising Expense 107 Prepaid Insurance Expense Cost of Sales 108 Store Supplies 501 | Purchases 151 Equipment 502 | Freight-In 152 Accumulated Depreciation Equipment 503 | Purchase Returns and Allowances 153 Furniture 504 | Purchase Discounts 154 Accumulated Depreciation Furniture Expenses Liabilities 601 | Advertising Expense 201 Accounts Payable 602 | Depreciation Expense Equipment 202 Interest Payable 603 | Depreciation Expense Furniture 203 Salaries Payable 604 | Doubtful Accounts Expense 211 Unearned Rent Income 605 | Insurance Expense 221 Notes Payable 606 | Interest Expense 607 | Miscellaneous Administrative Expense Owner's Equity 608 | Miscellaneous Distribution Costs 301 Nakpil, Capital 609 | Office Salaries Expense 302 Nakpil, Drawing 610 | Rent Expense 303 Income Summary 611 | Sales Salaries Expense 612 | Store Supplies Expense 613 | Taxes and Licenses Expense 614 | Utilities Expense An Excel spreadsheet is provided for you with the following tabs: WS (for 10-column worksheet) GIJ (for General Journal) GL (for General Ledger) 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) INSTRUCTIONS: (1) Complete the adjustments section of the worksheet [WS]. Use the following information as basis for adjustments for the month ended April 30, 2024. (a) FDN Trading sells products on consignment basis from Aim High Trading. Commissions earned but uncollected at month-end from Aim High Trading amounted to $37,000. (b) One sales staff is paid on a weekly basis for a daily rate of P600, while the other one office staff is paid on a weekly basis for a daily rate of P500. The work week covers Monday to Saturday and salaries are paid every Saturday. The last payment was made on April 27. April 30 falls on a Tuesday. (c) The 300,000 90-day 8% note payable was issued on April 12, 2024, for money borrowed. (d) Of the reported Prepaid Insurance Expense, one-third has expried as of April 30, 2024. (e) Store Supplies on hand at month-end amounted to 3,900. (f) Prepaid Advertising Expense was paid to Facebook Ads for P8,000 on April 1, 2024, for boosting a social media advertising post. By month-end, 40% of the ads have been released. (g) The Unearned Rent Income account represents the remaining rent of Honesty Company, a small business selling prepaid phone load. The advance rental of 30,000 was received on February 1,2024, covering six months. (h) Doubtful account is estimated at 10% of outstanding accounts receivable. (i) Equipment has an estimated salvage value equal to 10% of cost and useful life of 5 years. (j) Furniture has an estimated useful life of 4 years, with no salvage value. (k) Merchandise inventory based on physical count as of April 30, 2024, is 265,000. (2) The following expenses are allocated as follows: 40% as selling and distribution expenses, 60% as general and administrative expenses o Depreciation Expense Equipment Depreciation Expense Furniture Insurance Expense Rent Expense Utilities Expense Determine the net income or net loss for April and complete the worksheet [WS]. (3) Journalize and post the adjusting entries on April 30, 2024 using the general journal and the general ledger [GJ and GLJ]. (4) Prepare a functional form Statement of Profit or Loss for the month ended April 30, 2024 [SPL]. Include any supporting notes to financial statements [NOTES]. FDN Trading Worksheet For the month ended April 30, 2024 UNADJUSTED ADJUSTED STATEMENT OF STATEMENT OF TRIAL BALANCE ADJUSTMENTS TRIAL BALANCE PROFIT & LOSS FINANCIAL POSITION ACCOUNT NAME DR CR DR CR DR CR DR CR DR CR Cash 443,100 443,100 443,100 Accounts Receivable 53,900 53,900 53,900 Allowance for Doubtful Accounts 4,200 1,190 5,390 5,390 Commissions Receivable 37,000 37,000 37,000 Merchandise Inventory 302,400 37,400 265,000 302,400 302400 Prepaid Advertising Expense 18,000 3,200 14,800 14,800 Prepaid Insurance Expense 150,000 50,000 100,000 100,000 Store Supplies 11,400 7,500 3,900 3,900 Equipment 200,000 200,000 200,000 Accumulated Depreciation Equipment 6,000 3,000 9,000 9,000 Furniture 90,000 90,000 90,000 Accumulated Depreciation Furniture 3,750 1,875 5,625 5,625 Accounts Payable 96,600 96,600 96,600 Interest Payable 1,200 1,200 1,200 Salaries Payable 2,200 2,200 2,200 Unearned Rent Income 20,000 15,000 5,000 5,000 Notes Payable 300,000 300,000 300,000 Nakpil, Capital 244,675 244,675 244,675 Nakpil, Drawing 35,000 35,000 35,000 Income Summary 37,400 37,400 37,400 Sales 1,184,275 1,184,275 1,184,275 Sales Returns and Allowances 32,700 32,700 32,700 Sales Discounts 19,500 19,500 19,500 Commissions Income 37,000 37,000 37,000 Rent Income 15,000 15,000 15,000 Purchases 363,000 363,000 363,000 Freight In 10,000 10,000 10,000 Purchase Returns and Allowances 14,500 14,500 14,500 Purchase Discounts 25,500 25,500 25,500 Advertising Expense 31,000 3,200 34,200 34,200 Depreciation Expense - Equipment 3,000 3,000 3,000 Depreciation Expense - Furniture 1,875 1,875 1,875 Doubtful Accounts Expense 1,190 1,190 1,190 Insurance Expense 50,000 50,000 50,000 Interest Expense 1,200 1,200 1,200 Miscellaneous Administrative Expenses 7,800 7,800 7,800 Miscellanecus Distribution Costs 12,600 12,600 12,600 Office Salaries Expense 27,100 1,000 28,100 28,100 Rent Expense 25,000 25,000 25,000 Sales Salaries Expense 34,800 1,200 36,000 36,000 Store Supplies Expense 7,500 7,500 7,500 Taxes and Licenses Expense 7,200 7,200 7,200 Utilities Expense 25,000 25,000 25,000 Merchandise Inventory, End 265,000 1,899,500 1,899,500 159,565 159,565 1,945,965 1,945,965 703,265 1,276,275 1,545,100 972,090 % i % 573,010 573,010 % 1,276,275 1,276,275 1,545,100 1,545,100
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
Students Have Also Explored These Related Accounting Questions!