Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Can someone help me figure out why i keep getting the yellow highlighted ratio (Days' sales uncollected) wrong? Also, could you help me make sure

Can someone help me figure out why i keep getting the yellow highlighted ratio (Days' sales uncollected) wrong? Also, could you help me make sure that the gray-highlighted ratios are correct? Thank you.

image text in transcribedimage text in transcribed

image text in transcribed

H 5 BUS- FP4061 DyalMichael Assessment10-2.xlsx Excel michael dy Insert Page Layout Formulas Data Review view Q Tell me what you want to do File Home dx cut 2 Autosu A Et Wrap Text General BE BE Co 3E Merge & Center og Conditional Format as Cell nsert Delete Format Paste Sort & Find B I U Format Painter Clear Filter Select Formatting Table Clipboard Fon Alignment Number Editing N53 C D E G H I BUS-FP4061 Managerial Accounting Principles Assessment 10: Ratio Analysis Worksheet Problem 1 Solve the given problem based on the following scenario Megacorp's balance sheet and income statement, including all credit sales, are given in the table below. As of December 31, 2012. Inventories were $46.500 Total assets were $178,500. Common stock was $90,000 Retained earnings were $20,600. Megacorp Income Statement (December 31, 2013) 349,500 Sales Cost of goods sold 238,250 111,250 Gross profit 51,250 Operating expenses Interest expenses 4,000 Income before taxes 56,000 22 16.800 Taxes (at 30%) 23 Sheet1 CEI Ready :42 PM CD Ask me anything share

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Edi Audit And Control

Authors: I. Walden, A. Braganza

3rd Edition

1855542080, 978-1855542082

More Books

Students also viewed these Accounting questions

Question

4. What is a POP?

Answered: 1 week ago