Logo
Home Study Material Contact Search
AI Chat FREE
  1. business
  2. accounting
  3. apply excel (part 2) revise your worksheet to refl

Apply Excel (Part 2) Revise your worksheet to reflect these updated assumptions and then answer...

70.2K

Verified Solution

Question

Accounting

image
image
Apply Excel (Part 2) Revise your worksheet to reflect these updated assumptions and then answer the questions that follow. Cash Accounts receivable Inventory Long-term assets Total assets Current Previous $ 70,000 $ 60,000 40,000 45,000 100,000 80,000 229,000 155,000 $439,000 $340,000 Current liabilities Long-term liabilities Total liabilities Stockholders' equity Total llabilities and stockholders' equity Current Previous $ 80,000 $ 70,888 120,000 110,000 200,000 180,000 239,000 160,000 $439,000 $340,000 Net sales Cost of goods sold Operating expenses Interest expense Income tax expense Net income Current $400,000 225,000 60,000 12,000 24,000 79,000 Required: Required: 1. Use your spreadsheet to recalculate the ratios and enter your results here: (Round your answers to 2 decimal places.) Ratio Receivables tumover ratio Average collection period Inventory turnover ratio Average days in inventory Current ratio Acid-test ratio Debt to equity ratio Timos interest earned ratio times days times days to 1 to 1 % times

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