Financial Markets

Topics: Profit, Apartment, Discount rate Pages: 7 (1904 words) Published: September 16, 2013
Lim Jun Xian Clarence
Ph: 81118338
Business Computing 1
ISYS 2059

Lim Jun Xian Clarence s9104475G Presents:


Workshop Lecturer: Dr Lawrence Sim

Workshop Timing:12-3pm
(Note: Windows 7)


1Executive Summary3
2.1Why create the spreadsheet?3
2.2What the spreadsheet says.4
2.3The What If Analysis6

Executive Summary

The function of this business report is to analyse the data given and give suggested approaches to further improve the business. It includes the analysis of the given data and the recommendations that will aid with the business success. Information from the spreadsheet was analysed and solutions to problems were given. Key findings such as the revenue and profits were reviewed. Mistakes were also made on the spreadsheets given that have already been remedied. In conclusion, this business report analyses all the data given and there was an attempt to solve the problems identified.


Why create the spreadsheet?

The purpose of creating the spreadsheet is to allow users to analyse raw data more efficiently. It allows the performance of analytical decisions, understand problems, make decisions and implement solutions. The spreadsheet can be used to analyse all the information and construct a profit analysis table to analyse how healthy the business is. It also allows the user to view the information in a more organized, formatted and structured way. The spreadsheet allows us to give more informed and accurate information, and from there we can better guide the owners of “Montego Bay Apartments”.

The creation of the spreadsheet allowed the owner, Miranda Ho, to process data easily compared to her previous system of manually recording bookings based on when they were received. The recording of details manually compared to a spreadsheet is far less efficient as higher chances of human error occurring is much higher. Processing of data would be very difficult and time consuming compared to analysing data on a spreadsheet. Isolated data such as viewing bookings based on dates can also be viewed more accurately and easily due to the functions that excel offers. In comparison, more information can be accessed using a spreadsheet compared to a manual system of recording information.

What the spreadsheet says.

The information provided in the given excel had errors in the discount given to customers, the total revenue and the profits collected per apartments. After analysing and remedying the errors, conclusions were made regarding the business forecast for “Montego Bay Apartments”. The spreadsheet helps us to compress all the raw data provided by the manually recorded bookings which we can use to analyse and then use the information obtained to implement solutions to help improve the business. From the spreadsheet, it tells us that the least profitable apartment is the One Bedroom apartment which had a total profit of $1,727. It only brought in 6.84% of the total profits for the year 2011. The most profitable apartment is the One Bedroom Deluxe apartment which brought in a total profit of $10,452. It brought in 41.39% of the total profits from the year 2011; a significant amount compared to the lowest amount brought in.

The profit level for “Montego Bay Apartments” is low for the year 2011 due to a few factors that have negative impacts on the profit. Factors that affected the low profit are the high overhead, high charges of cleaning, low nightly charges on each apartment and the high discounts that were offered to customers. The charges for each apartment can be argued to be significantly low but this could be because charging too high of a price cause customers to find cheaper alternatives and cause even lower profits. The profits of One Bedroom apartments of $4.73 per day already show the decline of business....
Continue Reading

Please join StudyMode to read the full document

You May Also Find These Documents Helpful

  • Global Rice Market Industry Size Development Top 10 Countries And Forecasts 2019 Research Paper
  • Global Financial Analytics Market 2014-2018 Essay
  • Essay about Financial Markets and Market Risk Calculations
  • Essay on Financial Markets Approached by Game Theory
  • Financial Crisis Essay
  • Furniture Market in India to 2018
  • Security Market Line Essay
  • Essay on Market Terms

Become a StudyMode Member

Sign Up - It's Free