Create vertical and horizontal analysis excel spreadsheets

Assignment Help Financial Accounting

Reference no: EM131750566

Assignment

Organize your company's and its closest competitor's financial information in an Excel Workbook

Create Vertical and Horizontal Analysis excel spreadsheets - Using your company's Income Statement reported in their Form 10-k, prepare a Vertical Analysis and a Horizontal Analysis of three years of your company's income statement data. Embed your excel charts within your word document.

Create a comparative Ratio Analysis chart - Include the following information in a management report that is easy to read and comprehend.

Company ratios - Show a 3 year trend of your company's key ratios (obtain ratios from Calcbench - do not calculate them), separated into the categories of profitability, liquidity, and solvency. You must choose at least 3 ratios that tell us something different about profitability, at least 3 ratios that tell us something different about liquidity, and at least 2 ratios that tell us something different about solvency. (For example, inventory turnover is a liquidity ratio but days sales in inventory, also a liquidity ratio, tells us the same thing in different ways....therefore, these are not considered 2 different liquidity ratios).

· Competitor ratios - Do the same for your company's closest competitor (obtain ratios from Calcbench - do not calculate them).

· Industry ratios - Show the industry average for each ratio you reported for your company and competitor.

Reference no: EM131750566

Questions Cloud

What is the after-tax cost implicit in leasing : A firm has decided to acquire a particular asset. Annual lease payments, to be made at the end of each year, amount to 20 percent of the assets original value.

Estimate the value of the inventory destroyed in the fire : Estimate the value of the inventory destroyed in the fire using the gross margin method

What values come into conflict in typical whistle-blowing : What values come into conflict in a typical "whistle-blowing" case?

What would the expected salvage value : A government agency that pays no taxes is evaluating whether to lease or to purchase an asset. In the latter case, financing could be obtained through a bank.

Create vertical and horizontal analysis excel spreadsheets : Create Vertical and Horizontal Analysis excel spreadsheets - Using your company's Income Statement reported in their Form 10-k.

Prepare the journal entry to establish the petty cash fund : On August 1, 2011, Stubble Station established a $200 petty cash fund. Prepare the journal entry to establish the petty cash fund on August 1, 2011

Determine that the remainder is lease financing : An asset worth $ 100,000 is leased by the XYZ Corporation for 5 years at $30,000 per year. Lease payments are due at the end of the year.

Which information is stored in the connection flow table : For a stateful packet-inspection firewall, which information is stored in the connection flow table - Select the term that refers to the data recipient's

Government-led anti corruption drive are putting the squeeze : China’s economic slowdown and the government-led anti corruption drive are putting the squeeze on Swiss luxury watch brands.

User Account

All Pages