Build an excel Financial Model for a hotel / motel business

Completed Posted 1 year ago Paid on delivery
Completed Paid on delivery

I need a fairly simple financial model built in excel, which allows a user to provide inputs into defined 'Input cells' on the input sheet, and deliver a cashflow model by activity for the financial outcome over a 5 year period (by month).

Off the back of the cashflow output sheet, a standard profit/loss and balance sheet by month (as output sheets),

Key Activities and Assumption areas:

a) sales revenue streams - accommodation (number of nights; rates - indoor; camping; other); convention room hire; restaurant and bar; fuel sales

b) costs - typical costs for hotel business - staffing (admin; chefs; cleaners); cleaning; food and beverage; repairs and maintenance; utilities and internet; garden maintenance; swimming pool maintenance; capital equipment purchase (eg forklift for loading supplies etc), facilities upgrades.

c) Financing - amount borrowed; timing of borrow and return, interest rate

Please note that the capital costs to build the hotel / motel are not required, they will form part of the opening balance sheet. (depreciation = input assumption).

Excel Financial Analysis Financial Modeling

Project ID: #33976233

About the project

20 proposals Remote project Active 1 year ago

Awarded to:

(190 Reviews)
6.8

20 freelancers are bidding on average $156 for this job

topacademics

Hi, I will give you professional business plan writing. I am a PhD writer with 10 years of experience. I have worked on several similar projects of business plan writing, and can deliver professional business plan More

$110 AUD in 1 day
(22 Reviews)
5.8
moizdzo3l

Hello, Being an MBA finance graduate from I assure you that I will handle this task and assist you with Build an excel Financial Model for a hotel/motel business, I am a professional at finance and accounting with tha More

$500 AUD in 12 days
(7 Reviews)
4.5
Ajazfreelancer2

Good Day, I have been working on venture capital projects along with full exposure to the financial market and ethics. My core expertise is in financial analysis & valuation, I have built various types of dynamic and More

$400 AUD in 7 days
(4 Reviews)
3.7
maaria1991

Hello I have experience to make a good business plan. I have seen your project description too which is quite comfortable for me to work with you as I have already completed many business plan, marketing plan and bu More

$30 AUD in 1 day
(1 Review)
2.9
writingvector

YES, I CAN DO IT BEFORE YOUR DEADLINE.............. I am a PhD writer with 10 years of experience. I have worked on several similar projects of academic writing, and can deliver professional academic writing. I have s More

$140 AUD in 1 day
(2 Reviews)
1.2
CRBW

Hello I am an expert and professional business planner. I just read your posting. It sounds like you need an expert business plan writer to complete your writing. I have a background in business and marketing plan w More

$30 AUD in 1 day
(0 Reviews)
0.0
HelpingLab

Build an excel Financial Model for a hotel / motel business I am an academic expert who can help you with your solutions like; Case Studies, Summaries, Reports, Thesis & Dissertations, and Online Exams and Courses in More

$30 AUD in 1 day
(0 Reviews)
0.0
jepita200

Hi, I have an M.B.A in Business and Finance form Harvard University, and more than 10 years of experience as a business consultant, I have helped clients take off their business and reach new heights by optimizing the More

$30 AUD in 1 day
(0 Reviews)
0.0
chaithanyapk99

Hello Hope everything is well with you. I read your job description and I've a solution to do it easily and with good quality of work. Let's discuss more details.

$140 AUD in 7 days
(0 Reviews)
0.0
sikandarasif

Hi Your Finance Analysis Specialist here. Graduated recently from London, United Kingdom; I have been doing numerous marketing and research projects. I feel I will be comfortable to work with you and perform tasks as More

$200 AUD in 3 days
(0 Reviews)
0.0
Akhinur20

Hi there, I am a native English speaker from US with immaculate grammar. I am a professional MBA writer with more than 9 years of experience in every field of writing. I will help you with a high-quality write up for t More

$30 AUD in 1 day
(0 Reviews)
0.0
jaswantsingh2839

Iam data entry operator strong experience data entry and your time safe for work pdf file ward and your time safe

$110 AUD in 2 days
(0 Reviews)
0.0
shivkumar399233

Certified from THE INSTITUTE OF COST ACCOUNTANTS OF INDIA, CMA  Operating system : windows 10/7/2000, vista.  Microsoft Office 2007 professional, 1) MICROSOFT EXCEL (Advance excel) • Income Tax Calculation. • Kn More

$140 AUD in 7 days
(0 Reviews)
0.0