M1 Assignment Preparing a Horizontal and Vertical Analysis ANDREW NONES

School: Hamline University - Course: BUSINESS FINANCE - Subject: Accounting

Module1 Assignment Complete and Show all Calculations on this document and upload back on this document. All calculations must be shown to receive full credit. Problem 1:(20 total points -2 points each) Preparing a Horizontal Analysis The H Corporation, a merchandising business, has been in business for several years. Following are the H Corporation's comparative income statements for 20x4 and 20x3 and balance sheets for December 31, 20x4 and 20x3: Complete the Vertical AnalysisAmount and Percentage Columns and show all calculations below the chart. Based on info on above chart, calculate the following and show all calculations on the chart below: THE FIRST CALCULATION FOLLOWS AS SUCH: AMOUNT is (387,000-302,400)/302,400 = $75600 ((Comparison - Base) / Base)) PERCENTAGE IS (75600*100)/302,400 = 25% ((Amount*100)/Base) THE REST WILL USE THE SAME CALCULATIONS AmountPercentage Net Sales$7560025% Cost of Goods Sold$4350042.86%

Gross Profit$3210015.98% Depreciation$10006.67% Interest Expense($400)-4.76% Insurance Expense$30007.89% Salaries Expense$400013.33% Total Operating Expense$76008.32% Net Income$2450022.37% Problem # 2(20 total points - 2 points each) Preparing a Vertical Analysis (Common-Size Income Statements and Balance Sheets) The V Corporation, a merchandising business, has been in business for several years. Following are the V Corporation's comparative income statements for 2014 and 2013 and balance sheets for December 31, 20x4 and 20x3: Complete the Vertical AnalysisAmount and Percentage Columns and show all calculations below the chart. Based on info on above chart, calculate the following in the chart below for each year. Show all calculations within the chart.