Purchase Solution

Vertical Analysis and Ratio Calculations

Not what you're looking for?

Ask Custom Question

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)