Vertical Analysis and Ratio Calculations
Not what you're looking for?
Please see attached file.
Use Excel format.
Mickey Company and Minnie Company: prepare a vertical analysis
Art Mart Company: compute financial ratios
Purchase this Solution
Solution Summary
The solution has two problems - Vertical analysis for Mickey and Minnie Company and calculation of various ratios for Art Mart Company
Solution Preview
Please see the attached file. 2 questions are in two sheets
In vertical analysis all elements are expressed as a percentage of some base.
For Income Statement the base in net sales and for Balance Sheet the base is total assets
Vertical Analysis 2007
Mickey Company % of Sales Minnie Company % of Sales
Net Sales 490,000 100.00% 620,000 100.00%
Cost of Goods Sold 231,000 47.14% 274,000 44.19%
Gross Profit 259,000 52.86% 346,000 55.81%
Operating Expenses 29,000 5.92% 97,000 15.65%
Operating Profit 230,000 46.94% 249,000 40.16%
Interest Expense 5,000 1.02% 3,000 0.48%
Earnings Before Tax 225,000 45.92% 246,000 39.68%
Income Tax Expense 68,000 13.88% 75,000 12.10%
Net Income 157,000 32.04% ...
Purchase this Solution
Free BrainMass Quizzes
MS Word 2010-Tricky Features
These questions are based on features of the previous word versions that were easy to figure out, but now seem more hidden to me.
Managing the Older Worker
This quiz will let you know some of the basics of dealing with older workers. This is increasingly important for managers and human resource workers as many countries are facing an increase in older people in the workforce
Basic Social Media Concepts
The quiz will test your knowledge on basic social media concepts.
Social Media: Pinterest
This quiz introduces basic concepts of Pinterest social media
IPOs
This Quiz is compiled of questions that pertain to IPOs (Initial Public Offerings)