Travel

TRAVEL
Name:
Course
Professor’s name
University name
City, State
Date of submission
Introduction
I am doing this research in order to identify my investment choice, view its benefits and disadvantages, its future potential and estimated trend, as well as the reasons for my decision.
There are six businesses in the town: a travel agent, a newsagent, a wine bar, a nail bar, a food store and a sports shop. The wine bar makes the highest profits in all the years combined, with 494,000 pounds while the nail bar makes the least profits overall, with 242,000 pounds.
Method
I used Microsoft Excel to calculate the percentage change (e.g. (100-125)/125*100), percentage share (e.g. C2/I2*100), annual total profit (e.g. =SUM(C2..H2)) and the rate of change of profits.
Results
After a lot of research and analysis, I identified my investment choice as the Nail Bar. I selected for three reasons that I will elaborate below.
First, it is the cheapest business to invest in as it makes the least total profits every year—except perhaps for the year 2010, where it made slightly higher total profits than the Travel Agent—and therefore has the smallest market share. In 2006 it made a profit of 30,000 pounds while its closest competitor, the Newsagent, made 70,000 pounds. In 2007 it made a profit of 35,000 pounds while its closest competitor was the Food Store, which made a total profit of 56,000 pounds. In 2008 it made a total profit of 40,000 pounds, while its nearest competitor was the Food Store again, which made an overall profit of 62,000 pounds. In 2009 it made a total profit of 65,000 pounds, while its closest competitor was, for a third successive year, the Food Store, which made an overall profit of 68,000 pounds. In 2010 the Nail Store made a total profit of 72,000 pounds, while its closest competitor was the Travel Agent, which garnered a total profit of 60,000 pounds. The total profit of every year of all the six businesses was 2,785,000 pounds. The Nail Store made a total of 242,...