Logo
Home Study Material Contact Search
AI Chat FREE
  1. business
  2. finance
  3. please fill in all the yellow, green and light gre

please fill in all the yellow, green and light green highlighted boxes based on the...

70.2K

Verified Solution

Question

Finance

please fill in all the yellow, green and light green highlighted boxes based on the information provided *in excel forumla such as =SUM()
thank you
image
image
i would attach the file if i could
1 #4.a Income Statement %6 AGA $ $ 1,030,000.00 (30,000.00) A A A $ $ 92,000.00 665,000.00 (23,500.00) $ $ 83,500.00 2 3 Cross Rev 4 Returns & Allowances 5. Net Rev 6 7 Beg Inventory 8 Purchase 9 Returns & Allowances 10 GAS 11 End Inventory 12 Total CGS 13 14 Gross Profit 15 16 Salaries 17 Rent 18 Utilities 19 Admin 20 Depreciation 21 Total Oper Expenses 22 23 Operating Income 24 25 Taxes $ A A A 90,000.00 18,000.00 8,000.00 23,500.00 20,500.00 S S S 90,000.00 26 27 Net Profit B. D w GA (72,400.00) 100.00% $ $ 123,200.00 ca (25,000.00) GO $ S 137,800.00 949,000.00 30 31 Gross Sales 32 Returns & allow 33 Net Rev 134 35 CGS 36 Beg Inv 37 Purchase 38 Returns & allow 39 GAS 40 End Iny 41 TTL CGS 42 43 Gross Profit 44 45 Salaries 46 Depr 47 Rent 48 Admin 49 Advert 50 Operating Exp 51 52 Opera Income 53 54 Taxes 55 56 Net Income $ 511,000.00 $ 73,400.00 $ $ S 25,800.00 24,100.00 46,800.00 15.00% 73,000.00

Answer & Explanation Solved by verified expert
Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students