Please fill in the missing blanks and include excel formulas Q93456 Sales78910 Merchandise123 Expenses4 Cost of Goods55 Payroll7 InternetdyComputerAEspressoDrip CoffeeFood/Beverage3 BuildingTotal Sales>Cost of MerchandiseAdvertisingCapital AssetsMiscellaneousTotal Exp74°FHaze⠀First QXԴ Դ Դ Դ Դes ist es it is essB$ 16,400 $7,400 $6,100 $1,300 $$ 750 $JAN$$ 9,980 $910 $DFirst Quarter Forecast$ 12,000 $$ 325 $$ 2,100 $$ 600 $$ 1,500 $$ 1,300 $First Q Goal SeekCFEB17,200 $ 16,500 $7,500 $7,800 $6,000 $5,800 $1,500 $700 $1,400 $650 $10,150 $980 $12,000 $325 $2,100 $600 $1,500 $1,300 $MARMinivan Loan9,945 $1,050 $12,000 $325 $2,100 $600 $1,500 $1,300 $ETOTAL1IF50,100 $16,70022,700 $ 7,56717,900 $ 5,9674,200 $1,4002,100 $ 700AVG Proportion30,075 $10,0252,940 $ 98036,000 $12,000975 $ 3256,300 $2,1001,800 $ 6004,500 $1,5003,900$1,300QHمنG

The question is reaped to forecast for coming period. It also required excel formulas.

5 Cost of Merchandise 5 Payroll 2 Internet 3 Building Advertising Capital Assets ady Miscellaneous Total Exp First Q $ $ $ $ $ $ 1,500 $ $ 1,300 $ 1,300 $ 910 $ $ 325 $ 12,000 2,100 $ 600 $ 1,500 $ First Q Goal Seek 980 $ 1,050 $ 12,000 $ 325 $ 2,100 $ 600 $ 1,500 $ 1,300 $ 12,000 $ 325 $ 2,100 $ 600 $ Minivan Loan 2,940 $ 980 36,000 $12,000 975 $ 325 6,300 $2,100 1,800 $ 600 4,500 $1,500 3,900 $1,300

5 Cost of Merchandise 5 Payroll 2 Internet 3 Building Advertising Capital Assets ady Miscellaneous Total Exp First Q $ $ $ $ $ $ 1,500 $ $ 1,300 $ 1,300 $ 910 $ $ 325 $ 12,000 2,100 $ 600 $ 1,500 $ First Q Goal Seek 980 $ 1,050 $ 12,000 $ 325 $ 2,100 $ 600 $ 1,500 $ 1,300 $ 12,000 $ 325 $ 2,100 $ 600 $ Minivan Loan 2,940 $ 980 36,000 $12,000 975 $ 325 6,300 $2,100 1,800 $ 600 4,500 $1,500 3,900 $1,300

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

YE3tcuBfirwShOSzu2prZ7nd44k0L-w/formResponse?pli=1 e following to answer the five questions below: owing accounts are extracted from the worksheet of X Company on ber 31, 2020 Sales Retums and Allowances S 410,000 Sales Discount 140,000 Sales 1,500,000 Salaries Expenses - Sales 52,000 Rent Revenue 22,000 Purchases Retums and Allowances 120,000 Purchases 600,000 Loss from write down of Inventory 17,000 Inventory, January 1, 2020 460,000 Interest Expense A 55,000 Gain from Sale of Building 23,000 Freight-out 14,000 Freight-in 30,000 Depreciation Expense - Sales 22,000 Cost of Goods Sold 600,000 n the data above, the inventory account sho ed a holon
PROBLEM 2Determine the missing elements of the Income Statement. Replace the letters with your answers.The partial income statements of five different companies are as follows: 12345 Net SalesAD250,000290,000400,000 Merchandise Inventory, 1/1/2020B50,00070,000J120,000 Net Cost of Purchases80,000EG160,000390,000 Goods Available for Sale110,000160,000HKM Merchandise Inventory, 1/1/202040,000F30,00070,000N Cost of Goods SoldC140,000230,000L380,000 Gross Profit50,00040,000I160,000O
Sales Sales Returns & Allowances Sales Discount Purchases Freight in Purchase Renurns & Allowances Purchase Discount Beginning Inventory Ending Inventory Operating expenses Other Income Otber Expenses P 780,000 15,000 19,000 420,000 12,000 8,000 2,000 50,000 80,000 120,000 16,000 3,000 How much is the cost of goods available for sale? P 4E0.000 P 472,000 P448,000 P 470,000
What is the cost of goods sold? O A. $751,700 OB. $364,500 O C. $455,400 O D. $520,600
Net sales OR 165000 Cost of the goods sold OR 109000 Details Debit Credit General expenses 11700 Rent 5100 Salaries Payable 9300 Depreciation 1560 Account Payable 3575 Other income 2500 Calculate net profit Select one: O a. RO 31140 O b. RO 34715 O c. RO 40140 O d. RO 27265
2:31 G ileo The following are taken from the records of Debit Credit Sales P764985 Purchase Discount 8200 Purchase returns and allowances 5465 Purchases 159990 Freight-in 9180 Sales Discount 13300 Sales returns and allowances 5455 Depreciation expense Amortization expense 25000 10000 Salarics cxpcnsc Utilities expense Advertising cxpensc Rent expense 80000 55000 35000 60000 Interest incomc 5440 Interest expense 5677 Gain on salc of PPE 5465 Bad debts expense ? Humility Company for the year ended December 31, 2019: Based on actual physical count, inventory balance are as follows: January 1, 2019 December31, 2019 P25455 P20765 Bad debts expense is 4% of net sales. Classify the bad debt expense as a general and administrative expense. 1. Determine the following: а. Net sales b. Net purchases I U A II B
Calculate net profit Details Debit(OMR) Credit(OMR) General expenses 11700 Prepaid Rent 5100 Cost of goods sold 99700 Salaries 9300 Depreciation 1560 Account Payable 3575 Net Sales 150000 Other income 2500 Select one: a. OMR 34715 b. OMR 30240 c. OMR 39815 d. OMR 31140
Net sales OR 156000 Cost of the goods sold OR 99700 Details Debit Credit General expenses 11700 Furniture 5100 Salaries 9300 Depreciation 2000 Account Payable 3575 Dividend Revenue 2500 Calculate net profit Select one: O a. RO 36240 O b. RO 31140 O c. RO 35800 O d. RO 34715
Financial information is presented below: Operating Expenses $91400 Sales Returns and Allowances 25900 Sales Discounts 12400 Sales Revenue 295000 Cost of Goods Sold 157200 Gross profit would be ○ $99500. O $111900. O $125400.
P 750,000 19. Sales revenue Freight in Beginning inventory Purchases discounts Sales returns and allowances Operating expenses Ending inventory Purchases 44,000 75,000 20,000 44,000 99,000 72,000 415,000 Sales discounts 25,000 William Browning, withdrawals Purchase returns and allowances 61,000 36,000 A. The total cost of goods available for sale is: a. P388,000 b. P478,000 C. P470,000 d. P394,000 B.The cost of goods sold is: a. P470,000 b. P478,000 C. P406,000 d. P351,000
v2.cengagenow.com C 64% A CO Sales Transactions Journalize the following merchandise transactions: a. Sold merchandise on account, $19,800 with terms 1/10, n/30. The cost of the merchandise sold was $11,880. Sale Accounts Receivable Sales 19,602 19,602 V Cost Cost of Merchandise Sold Merchandise Inventory < Feedback 11,880 11,880 ▼ Check My Work (a) When the perpetual inventory system is used, two entries are recorded each time a sale is made. In the first entry, revenue on account is recorded by debiting Accounts Receivable and crediting Sales. A second entry records the cost of the merchandise sold with a debit and merchandise inventory is credited. b. Received payment less the discount. Cash Check My Work 19,602 Previous Next All work saved. Save and Exit Submit Assignment for Grading
Qe/ from the following tralasaction, prepar income Statement Sales reven ue tinished Goods V 50006 Net purchoses loo00 rent expenses 250 000 returns sales lo o00 So00 rent revenue 30oo administrutive Expensese 2e00 Sales salaries looo Depreriation other expensese tax income tooo +5006 finished goads 344 7o00 . tooo