Build an excel Financial Model for a hotel / motel business
Budget: $30 – $250 AUD
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).
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).