Question: Complete this partial comparative balance sheet by vertical analysis. Round percents to the nearest hundredth. (using excel) Column1 Column2 Column3 Column4 Column5 2017 2016 Assets

Complete this partial comparative balance sheet by vertical analysis. Round percents to the nearest hundredth. (using excel)

Column1 Column2 Column3 Column4 Column5
2017 2016

Assets

 amount percent amount percent
Current assets:
a. Cash $38,000 $35,000
b. Accounts receivable $19,000 $18,000
c.merchandise inventory $16,000 $11,000
d. prepaid exoenses $20,000 $16,000
. . .
. . .
. . .
total current assets $180,000 $140,000

What is the amount of change in merchandise inventory and the percent increase?

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!

Q:

Given the following, calculate the estimated cost of ending inventory using the gross profit method: Gross profit on sales 30% Beginning inventory, January 1, 2017 $30,000.00 Net purchases $8,000.00...

Q:

U 16-la EXTRA PRACTICE QUIZ WITH WORKED-OUT SOLUTIONS 1. Complete this partial comparative balance sheet by vertical analysis. Round percents to the nearest hundredth. 2017 2016 Amount Percent Amount...

Q:

1. Complete this partial comparative balance sheet by vertical analysis. Round percents to the nearest hundredth. 2017 2016 Amount Percent Amount Percent Assets Current assets a. Cash b. Accounts...

Q:

8 Angel Company produces car radios. Given the following, calculate (1) the contribution margin (CM) and (2) the breakeven point (BE) for Angel Company. Fixed cost (FC) Variable cost (VC) per radio...

Q:

CTICE QUIZ WITH WORKED-OUT SOLUTIONS 1. Complete this partial comparative balance sheet by vertical analysis. Round percents to the nearest hundredth. 12012 2016 Amount Persen Amount Percent Assets...

Q:

ALL ANSWERS MUST BE IN A FORMULA A E F . This Year ces Cash 54980,000 2.988000 1992.000 10 Inventory 1 Recent financial statements for Zimmer, Inc. are as follows: 2 Zimmer Company Zimmer Company 3...

Q:

I NEED ALL OF THESE QUESTION DONE ON A EXCEL SHEET! Thank You! Classwork Questions 3/12/2020 1) Complete a horizontal analysis for Brown Company, rounding percents to the nearest hundredth. BROWN...

Q:

Prepare a make or buy analysis. 3 Prepare a make or buy analysis - Excel HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW vIEw Calibri ' 9r, 4:1 g _ I '3 :_ H .- F's - g - Alignment Number Conditional...

Q:

1. Compute and interpret financial ratios that managers use to assess liquidity. 2. Compute and interpret financial ratios that managers use for asset management purposes 3. Compute and interpret...

Q:

Financial Statement Analysis Part 1 As described in the project overview, Appendix A of your textbook describes several ratios, as well as vertical analysis and horizontal analysis of financial...

Q:

The following information is related to Alpha Company: Estimated manufacturing overhead costs for the year $247,000 Actual manufacturing overhead costs for the year $205,000 Estimated direct labor...

Q:

1. List and explain the roles of teams in the above case. 2. Identify and explain the four specific areas that Mr. Ahmed identified and how this cost plays essential roles in reducing the expenses...

Q:

You have shorted one futures contract on the Mexican peso at a price of 0 . 0 5 2 6 3 . The notional amount is MXN 5 0 0 , 0 0 0 per contract. Your performance bond ( initial margin ) is $ 5 0 0 0...

Q:

At higher tax rates, depreciation is: (Points : 10) more beneficial. less beneficial. unaffected. none of these