Financial Analysis and Expansion Plan for Complete Fitness Centre

This report provides a comprehensive overview of a business plan for the expansion of a fitness center named "Complete Fitness Centre". It begins with an introduction to the retail sector in the United Kingdom and the financial needs of businesses, highlighting the company's goal to expand by opening a fitness studio. Task 1.1(A) provides a business overview of the company, while Task 1.1(B) details the sales and expenditure over a 12-month period, including the use of Excel functions such as auto sum, auto format, average formula, and percentage calculations. The report also includes charts illustrating expenditure and discusses income sources and investment distribution. Task 2 focuses on different approaches to designing spreadsheets for financial data analysis. The conclusion summarizes the importance of finance for business expansion and the role of financial institutions. The report references several books and journals related to Excel and business management.

A4

Table of Contents
INTRODUCTION...........................................................................................................................1
TASK 1............................................................................................................................................1
(A) Overview of business............................................................................................................1
(B) Sales and expenditure of 12 months from January to December..........................................1
TASK 2............................................................................................................................................5
Different approaches to design the spreadsheet...........................................................................5
CONCLUSION................................................................................................................................5
REFERENCES................................................................................................................................6

INTRODUCTION
The retail sector of the United Kingdom is a wide, it includes various kind of business
that deals in different areas. Eventually, these retail sectors are started at lower capital and need
some fund from the financial institutions. Herein, the project report a company from the health
and fitness sector is selected that needs fund for expand their business widely.
TASK 1.
(A) Overview of business.
The company is “complete fitness centre” that deals in offering different health and
fitness equipments like exercise mat, ankle weights etc. The profitability of company is quite
good, they are getting good revenue every month from selling of equipments. Now company is
planning to expand their business and wants to open their own fitness studio that will give
guidance for better health of people. As well as people can exercise their so overall they want to
open their own GYM which will provide fitness guidance. For this purpose they will need fund
and they can get it from the local banks or financial institution.
(B) Sales and expenditure of 12 months from January to December.
1

(a) Auto sum- This is a kind of function of the excel that is useful in making sum easily
with higher accuracy(Smart, 2011). Like in the spreadsheet of profit and loss forecasting, the
auto sum is used to make addition of income and expenditures. It can make the sum of all data of
columns as well as raw. In this feature of excel user will need to select all the numerical data and
put the formula. Like user wants to add all the digits from B6 to B6 then formula would be as :
=SUM(B6: B10).
(b) Auto format- Auto format is a type of function of the excel in which users can change the
formatting of the entered data in the excel. Eventually, this feature change the appearance of
entered information. For example user entered 4 th, then with the use of auto format it will be
changed as 4th . So overall it is beneficial in the changing the formatting style of the texts..
(c) Average formula- The average formula is being used by the users for computing the average
of numerical data. This function of excel removes the complexity in the calculation of the
average of different numbers. As well as it helps in saving time with accuracy in result. Like in
the above spreadsheet average formula is used to compute the average of different numbers. For
2

this purpose user will need the formula of AVERAGE(A1:A20), if user wants to calculate the
average of series from A1 to A20.
(d) Percentage- This feature of the excel is useful for calculating the percentage of numerical
digits, as well as it is also used for reducing the % of discounting. For example in the spreadsheet
of profit and loss forecasting, this tool is used for computing the percentage of different
numerical digits. Like if user wants to compute the 40% of 60 then formula will be =40%*60.
(e) Password protect your spreadsheet- Every user wants to protect their files from the
unwanted users and this can be possible by applying the application of password protection(Jelen
and Syrstad, 2010). Due to this users can ensure about their privacy and no one can open the file
without permission of the user. Herein, the spreadsheet of profit and loss forecasting, their
statement can be protected by this feature of the excel.
(f) Chart showing overall expenditure of Complete fitness studio
January
February
March
April
May
June
July
August
September
October
November
December
0
200
400
600
800
1000
1200
1400
1600
1800
955 1003 1053 1106 1161 1219 1280 1344 1411 1482 1556 1633
Expenditure graph
Column B
Years
Expenses (£)
(g) Business should focus on the different sources of income to proper management. Herein, the
aspect of the Complete fitness studio, they are required to highlight on their sources of income
like debentures, bank loan, share capital etc.
3

share capital Bank loans Bonds and Debentures
0
2
4
6
8
10
12
14
16
18 16
12 11
Source of income
Amount(£)
Name of sources
Amount(£)
(h) Distribution of investment between capital, stock and operation money.
4
Capital Stock Operation money
0
10000
20000
30000
40000
50000
60000
14000
50000
27000
Investment chart
Amount(£)
Options to invest
Amount(£)

TASK 2
Different approaches to design the spreadsheet.
In the context of business, they are required to record all the related informations to take
futuristic decisions on the basis of those data. Eventually, the size of these informations can be
large and due to this, it may become difficult to find a conclusion to take right decision. For this
purpose, organisations use the spreadsheet (Ray, 2003). Herein, the aspect of the Complete
fitness studio they use the spreadsheet for estimating about the income and expenditure. They
use different kind of function of the excel like auto sum, auto formatting, percentage, average
etc.
CONCLUSION
From above project report it has been concluded that businesses need the finance to
expand their venture. This is provided by the banks or other financial institution and they provide
the loan on the basis of the sales, income etc. Additionally, it is concluded that size of loan
depends on the income level of the companies.
5

REFERENCES
Books and journals:
Smart, M., 2011.Learn Excel 2007 Expert Skills with The Smart Method: Courseware Tutorial
teaching Advanced Techniques. The Smart Method Ltd.
Jelen, B. and Syrstad, T., 2010.VBA and Macros: microsoft excel 2010. Pearson Education.
Ray, J. and Ray, R., 2003.Microsoft Excel for Terrified Teachers. Teacher Created Resources.
6