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

90.2K

Verified Solution

Question

Finance

please fill in all the green, light green, and yellow highlighted boxes based on the given information *in excel formula please and thank you*
image
image
96 $ 88,000.00 $ 88,000.00 $ 106,000.00 2 3 Current Assets 4 Cash 5 A.R. 6 Inventroy 7 Total C.A. 8 Non-C.A. 9 Land 10 Bidg 11 Equip 12 Total Non-C.A. 13 Total Assets $ 64,000.00 $ 147,600.00 $ 31,400.00 $ S 84,000.00 14,800.00 15 Current Liab 16 A.P. 17 Notes Payable 18 Total C.L. 19 Non-C.L. 20 Mortgage 21 Bonds Payable 22 Total Non-C.L. 23 Total Liab 24 25 Equity 26 Totall Liab+ Equity $ 128,500.00 $ 167,700.00 Increase(Decrease) % Amount 96 2009 96 2008 2009 2008 S S $ 10,000.00 $ 12,000.00 5,000.00 $ 3,000.00 82,000.00 $ 26,000.00 18,000.00 $ 22,000.00 $ s $ S 28,000.00 $ 38,000.00 26,000.00 $ 16,000.00 21,000.00 $ 18,000.00 29 30 31 Current Assets 32 Cash 33 Securites 34. A.R. 35 Inventory 36 Total C.A. 37 Non-C.A. 38 Land 39 Bldg 40 Equip 141 Total Non-C.A. 42 Total Assets 43 44 Current liab 45 A.P. 46 Notes Payable 47 TotalCL 48 Non-C.I. 49 Mortgage 50 Bonds Payable 51 Total Non-C.L. 52 Total Liab 53 54 Equity 55 56 Total Lab Equity S s 22,000.00 $ 20,000.00 10,000.00 $ 12,000.00 S. S 56,500.00 $ 57,000.00 24,000.00 S 26,000.00 57

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