Spreadsheet: 858374d1707092282-creating-a-formula-that-matches-and-multiplies-example-doc
Sheet: Model Calculations

 | © Profit Vision Financial Services. All rights reserved.
 | Model Calculations
 |  |  | Project Phase
 |  |  | Start of Period
 |  |  | End of Period
 |  |  | Month
 |  |  | Year
 | Acquistion
 | Acquisition Costs
 | Purchase Price
 | Acquisition Fees
 | Other Acquisition Costs
 | Renovation Costs
 | Total Acquisition & Renovations Cost
 | Revenue
 | Berth Analysis
 | Occupancy Analysis
 | Slips Rented |  | 560 |  | 280 | 280 | 280 | 280 | 280 | 280 | 280 | 280 | 280 | 280 | 280 | 280 | 280 | 280 | 280 | 280 | 280 | 280 | 280 | 280 | 280 | 280 | 280 | 280 | 280 | 280 | 280 | 280 | 280 | 280 | 280 | 280 | 280 | 280 | 280 | 280 | 280 | 280 | 280 | 280 | 280 | 280 | 280 | 280 | 280 | 280 | 280 | 280 | 280 | 280 | 280 | 280 | 280 | 280 | 280 | 280 | 280 | 280 | 280 | 280 | 280 | 280 | 280 | 280 | 280 | 280 | 280 | 280 | 280 | 280 | 280 | 280 | 280 | 280 | 280 | 280 | 280 | 280 | 280 | 280 | 280 | 280 | 280 | 280 | 280 | 280 | 280 | 280 | 280 | 280 | 280 | 280 | 280 | 280 | 280 | 280 | 280 | 280 | 280 | 280 | 280 | 280 | 280 | 280 | 280 | 280 | 280 | 280 | 280 | 280 | 280 | 280 | 280 | 280 | 280 | 280 | 280 | 280 | 280 | 280
 | Capacity |  |  |  | 560 | 560 | 560 | 560 | 560 | 560 | 560 | 560 | 560 | 560 | 560 | 560 | 560 | 560 | 560 | 560 | 560 | 560 | 560 | 560 | 560 | 560 | 560 | 560 | 560 | 560 | 560 | 560 | 560 | 560 | 560 | 560 | 560 | 560 | 560 | 560 | 560 | 560 | 560 | 560 | 560 | 560 | 560 | 560 | 560 | 560 | 560 | 560 | 560 | 560 | 560 | 560 | 560 | 560 | 560 | 560 | 560 | 560 | 560 | 560 | 560 | 560 | 560 | 560 | 560 | 560 | 560 | 560 | 560 | 560 | 560 | 560 | 560 | 560 | 560 | 560 | 560 | 560 | 560 | 560 | 560 | 560 | 560 | 560 | 560 | 560 | 560 | 560 | 560 | 560 | 560 | 560 | 560 | 560 | 560 | 560 | 560 | 560 | 560 | 560 | 560 | 560 | 560 | 560 | 560 | 560 | 560 | 560 | 560 | 560 | 560 | 560 | 560 | 560 | 560 | 560 | 560 | 560 | 560 | 560
 | Percent (%)
 | Operations Start Month
 | Operations Start Year
 | REVPAS
 | Revenues
 | Gross Rent
 | Vacancy Loss
1 | Berthing/Mooring Revenue |  |  |  | 219142.1991666667 | 219142.1991666667 | 219142.1991666667 | 219142.1991666667 | 219142.1991666667 | 219142.1991666667 | 219142.1991666667 | 219142.1991666667 | 219142.1991666667 | 219142.1991666667 | 219142.1991666667 | 219142.199166667
2 | Dry Storage Revenue |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
3 | Commercial Real Estate Revenue |  |  |  | 1084.2 | 1084.2 | 1084.2 | 1084.2 | 1084.2 | 1084.2 | 1084.2 | 1084.2 | 1084.2 | 1084.2 | 1084.2 | 1084.2
4 | Service Revenue |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
5 | Fuel Revenue |  |  |  | 197342.730625 | 197342.730625 | 197342.730625 | 197342.730625 | 197342.730625 | 197342.730625 | 197342.730625 | 197342.730625 | 197342.730625 | 197342.730625 | 197342.730625 | 197342.730625
6 | Retail Revenue |  |  |  | 4266.08375 | 4266.08375 | 4266.08375 | 4266.08375 | 4266.08375 | 4266.08375 | 4266.08375 | 4266.08375 | 4266.08375 | 4266.08375 | 4266.08375 | 4266.08375
7 | F&B Revenue |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
8 | Brokerage Revenue |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
9 | Accommodation Revenue |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
10 | Utilities Revenue |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
11 | Other Revenue |  |  |  | 33621.49375 | 33621.49375 | 33621.49375 | 33621.49375 | 33621.49375 | 33621.49375 | 33621.49375 | 33621.49375 | 33621.49375 | 33621.49375 | 33621.49375 | 33621.49375
 | Total Revenue
 | COGS, OpEx & CapEx
 | [NAME]
 | Berthing/Mooring |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Dry Storage |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Commercial Real Estate |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Service |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Fuel |  |  |  | -173947.988125 | -173947.988125 | -173947.988125 | -173947.988125 | -173947.988125 | -173947.988125 | -173947.988125 | -173947.988125 | -173947.988125 | -173947.988125 | -173947.988125 | -173947.988125 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Retail |  |  |  | -1978.578125 | -1978.578125 | -1978.578125 | -1978.578125 | -1978.578125 | -1978.578125 | -1978.578125 | -1978.578125 | -1978.578125 | -1978.578125 | -1978.578125 | -1978.578125 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | F&B |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Brokerage |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Accommodation |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Utilities |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Other |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Total [NAME]
 | [NAME]
 | Payroll |  |  |  | -56924.3225 | -56924.3225 | -56924.3225 | -56924.3225 | -56924.3225 | -56924.3225 | -56924.3225 | -56924.3225 | -56924.3225 | -56924.3225 | -56924.3225 | -56924.3225
 | Repairs & Maintenance |  |  |  | -9109.134145833334 | -9109.134145833334 | -9109.134145833334 | -9109.134145833334 | -9109.134145833334 | -9109.134145833334 | -9109.134145833334 | -9109.134145833334 | -9109.134145833334 | -9109.134145833334 | -9109.134145833334 | -9109.134145833334
 | Advertising & Marketing |  |  |  | -1138.641768229167 | -1138.641768229167 | -1138.641768229167 | -1138.641768229167 | -1138.641768229167 | -1138.641768229167 | -1138.641768229167 | -1138.641768229167 | -1138.641768229167 | -1138.641768229167 | -1138.641768229167 | -1138.641768229167
 | General & Administrative |  |  |  | -16054.586875 | -16054.586875 | -16054.586875 | -16054.586875 | -16054.586875 | -16054.586875 | -16054.586875 | -16054.586875 | -16054.586875 | -16054.586875 | -16054.586875 | -16054.586875
 | [NAME] |  |  |  | -33342.190625 | -33342.190625 | -33342.190625 | -33342.190625 | -33342.190625 | -33342.190625 | -33342.190625 | -33342.190625 | -33342.190625 | -33342.190625 | -33342.190625 | -33342.190625
 | Utilities |  |  |  | -22181.09875 | -22181.09875 | -22181.09875 | -22181.09875 | -22181.09875 | -22181.09875 | -22181.09875 | -22181.09875 | -22181.09875 | -22181.09875 | -22181.09875 | -22181.09875
 | Insurance |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Ad Valorem Taxes
 | Total [NAME]
 | CapEx
 | Annual CapEx during Operations