Financial Analysis

Financial Analysis - Northwind Traders



Financial Analysis - Northwind Traders

Introduction

The prime purpose of this report is to identify and analyze the sales and revenue trends of Northwind Traders. The paper attempts to present the sales related data in various respects to enable managers to make decisions regarding strategic financial management. The data is presented by sorting it date wise and product wise to analyze price increases over time. It is also sorted to analyze the impact of discounts on sales of products. The sales trend is presented graphically with quarterly break- ups to enable accurate decision making. The paper is a complete and comprehensive financial report of Northwind Traders aimed at extracting relevant data and presenting it in the most efficient and clear manner for decision making.

Organizing of Data

The study is related to the sales data which is based on category name, last name, first name, country, order date, product, unit purchase price, quantity and the discount level. The data is based various categories and based on 2004 to 2006 and also pertains to various countries. Thus, for the analysis of the data, it is important that the data should be analysed so the data is organized in accordance with Quarter, Country and category.

Analysis of Data

For the analysis of the data of Northwind Traders, purchase amount before discount, discount and purchase amount after discount are obtained, in order to get the sales.

Sales by Quarter

Q 3 - 2004

$ 53468.77

Q 4 - 2004

$ 112956.53

Q 1 - 2005

$ 142100.375

Q 2 - 2005

$ 147605.8625

Q 3 - 2005

$ 134128.545

Q 4 - 2005

$ 174173.6625

Q 1 - 2006

$ 261126.3165

Q 2 - 2006

$ $240,233

If the sales data of Northwind Traders is organized on quarterly basis, the highest sale for the period is recorded in the first quarter of 2006 that is $ 261126.3165 and second quarter ...