Answered step by step
Verified Expert Solution
Question
1 Approved Answer
cost accounting. help with #3 please Input the attached comparative Balance Sheets and income Statements in an Excel worksheet. Write excel formulas to complete the
cost accounting.
Input the attached comparative Balance Sheets and income Statements in an Excel worksheet. Write excel formulas to complete the following Requirements: 1. Horizontal Analysis (in dollars and percentages) 2. Vertical Analysis (in dollars and percentages) 3. Compute the following ratios: C. (Write the name of the ratio and the ratio formula along with your excel calculated answer for each ratio on the worksheet. Do NOT calculate the ratio by hand and type in the answer) a. Equity (SE) b. Stockholders' equity to debt Return on sales d. Return on stockholders' equity e, Current ratio f. Acid-test ratio 8. Accounts receivable turnover h. Number of days' sales ia accounts receivable 1. Inventory turnover 1 Total assets turnover 4. Attach a printout of all of the above. Attach a printout of all excel formulas. 5. Write a summary of all of your results (horizontal, vertical, ratios). Discuss changes from 2013 to 2014. Address each account and each rato. For each item, indicate if the change indicates an improvement or decline in financial performance or financial position. Discuss. FASHION DRESS SHOPS, INC Balance Sheets December 31 2013 2014 2012 $ 5 $ ASSETS Current Assets Cash Accounts receivable.net Merchandise inventory Prepaid costs Total current assets Long-term investments Land, buildings, and fixtures Less: Accumulated depreciation 200,000 580,000 420.000 50,000 1.250,000 300,000 840,000 560.000 100.000 1.900.000 80,000 1,130,000 110.000 1,020,000 3.000.000 150,000 440,000 380,000 20,00 590,000 0 500,000 40.000 460,000 1.450.000 0 600,000 50.000 550.000 Total assets 5 $ 1.000.000 s Equities $ 5 Current liabilities Accounts payable Accrued liabilities Dividends payable Total current abilities Note payable due 2018 440,000 130,000 230,000 220,000 530,000 140,000 170.000 340.000 500,000 0 S70.000 350.000 0 0 Stockholders' equity Common stock Retained earnings 1.200.000 SGO000 1.760.000 30912.000 900,000 330,000 1.230,000 1.000.000 R00,000 31000 1.100.000 1.450.000 Total liabilities and stockholders equity S $ DEBBIE DRESS SHOPS, INC. Income Statements Ended $ Year December 2014 5,400,000 5.000.000 1,400,000 1,000,000 Ner credit sales Cost of goods sold Gross profit Other costs including income $ 31 2013 4,000,000 3,200,000 800,000 520,000 280.00 2012 3,500,000 3.100.000 400,000 200,000 100.000 Net Income 400 000 help with #3 please
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started