Spreadsheet: 858374d1707092282-creating-a-formula-that-matches-and-multiplies-example-doc
Sheet: Acquisition Inputs

 | © Profit Vision Financial Services. All rights reserved.
 | Acquisition Inputs
 | General Data
 | Business General Info & Timing |  |  |  |  | Revenue Assumptions |  |  |  |  |  |  | Operating Metrics
 | Project Name |  |  |  |  | Timing |  |  |  |  |  |  | Management Fee |  | % of revenue | 0.05
 | Business Sector |  |  |  |  | Ops Starting Month |  |  |  |  | 1
 | City |  |  | Enter City |  | Ops Starting Date |  |  |  |  |  |  | Payroll |  |  | 600
 | Country |  | select | Select Country |  |  |  |  |  |  |  |  | Marketing |  |  | 80
 |  |  |  |  |  |  |  |  |  |  |  |  | Utilities |  |  | 300
 | Reporting Metrics |  |  |  |  |  |  |  |  |  |  |  | Repairs & Maintenance (R&M) |  |  | 150
 | Timing |  |  |  |  |  |  |  |  |  |  |  | Information Technology (IT) |  |  | 100
 | Total Investment Period |  | select | 10 |  |  |  |  |  |  |  |  | Insurance |  |  | 120
 | Reporting Start Date |  |  | 2024-01-01 00:00:00 |  |  |  |  |  |  |  |  | 3rd Party Fees & Other |  |  | 400
 | Reproting Start Year
 |  |  |  |  |  |  |  |  |  |  |  |  | Property Taxes
 | Reporting Currency |  | select | USD |  |  |  |  |  |  |  |  | Acquisition Price
 |  |  |  |  |  |  |  |  |  |  |  |  | Renovation Costs (include?) | Yes
 | Income Tax Rate |  | % | 0.2 |  |  |  |  |  |  |  |  | Assessment Percentage |  | % | 1
 |  |  |  |  |  |  |  |  |  |  |  |  | Assessed Value
 | Project Assumptions
 | Acquisition Assumptions |  |  |  |  |  |  |  |  |  |  |  | Property Tax Rate (Mill Rate) |  | % | 0.025
 | Timing |  |  |  |  |  |  |  |  |  |  |  | Taxes
 | Acquisition Month |  |  | 1
 | Acquisition Date |  |  |  |  |  |  |  |  |  |  |  | [NAME] Annual Inflation |  | % | 0.045
 | Acquisition Year
 |  |  |  |  |  |  |  |  |  |  |  |  | CapEx & Depreciation Assumptions
 | Price Assumptions |  |  |  |  |  |  |  |  |  |  |  | Annual CapEx (TIs & Reserves) |  | % of Revenue | 0.015
 | Purchase Price to [NAME] |  |  | 8500000
 | Acquisition Yield |  | % |  |  |  |  |  |  |  |  |  | Straight Line Depreciation Rate |  | % | 0.1
 | Acquisition Fees Rate |  | % | 0.03 |  |  |  |  |  |  |  |  | Financing
 | Acquisition Fees |  |  |  |  |  |  |  |  |  |  |  | Capital Structure
 |  |  |  |  |  |  |  |  |  |  |  |  | External Loan |  | % | 0.5
 | Other Acquisition Costs |  |  | 100000 |  |  |  |  |  |  |  |  | Shareholders Loan |  | % | 0
 |  |  |  |  |  |  |  |  |  |  |  |  | Equity (%) |  | %
 | [NAME] |  | include? | No |  |  |  |  |  |  |  |  | Total |  | %
 | Timing
 | Capex Period |  | months | 10
 | Capex Start Date |  |  | 2024-07-01 00:00:00 |  |  |  |  |  |  |  |  | Interest Rate (Annual) |  | % | 0.05
 | Capex Start Month |  |  |  |  |  |  |  |  |  |  |  | Term (Years) |  | years | 15
 | [NAME] |  |  |  |  |  |  |  |  |  |  |  | I/O Period |  | years | 1
 | Capex End Date
 | [NAME]
 | Project 1 |  | $ | 500000 |  |  |  |  |  |  |  |  | Interest Rate (Annual) |  | % | 0.01
 | Project 2 |  | $ | 500000 |  |  |  |  |  |  |  |  | Term (Years) |  | years | 5
 | Project 3 |  | $ | 500000 |  |  |  |  |  |  |  |  | I/O Period |  | years | 0
 | Project 4 |  | $ | 30000
 | Project 5 |  | $ | 100000
 | Total Capex Costs |  |  |  |  |  |  |  |  |  |  |  | Uses & Sources of Cash
 |  |  |  |  |  | Escalation Rates |  |  |  |  |  |  | Uses of Cash
 | Exit Assumptions |  |  |  |  |  | Berthing/Mooring Revenue | Dry Storage Revenue | Service Revenue | Inflation + Others |  |  | Purchase Price
 | Hold Period |  |  |  |  | 1 | 0.03 | 0.03 | 0.03 | 0.0425 |  |  | Acquisition Costs
 | Sale Month |  |  |  |  | 2 | 0.07 | 0.05 | 0.04 | 0.03 |  |  | Renovation Costs
 | Sale Date |  |  |  |  | 3 | 0.07 | 0.05 | 0.04 | 0.03 |  |  | Debt Service Reserves
 | Sale Year |  |  |  |  | 4 | 0.07 | 0.05 | 0.04 | 0.03 |  |  | Total Uses of Cash
 |  |  |  |  |  | 5 | 0.07 | 0.05 | 0.04 | 0.03
 | NOI at Exit |  |  |  |  | 6 | 0.05 | 0.03 | 0.025 | 0.03 |  |  | Sources of Cash
 | Exit Cap Rate |  | % | 0.08 |  | 7 | 0.05 | 0.03 | 0.025 | 0.03 |  |  | External Loan
 | Sale Price |  |  |  |  | 8 | 0.03 | 0.03 | 0.025 | 0.03 |  |  | Shareholders Loan
 |  |  |  |  |  | 9 | 0.03 | 0.03 | 0.025 | 0.03 |  |  | Equity
 | Sale Fees Rate |  | % | 0.02 |  | 10 | 0.03 | 0.03 | 0.025 | 0.03 |  |  | Total Sources of Cash
 | Sale Fees
 | Country |  | Currencies | Repoting Curr. Symbol |  |  |  |  |  | Years
 | Select Country
 | Afghanistan |  |  |  |  |  |  |  |  | 1
 | Albania |  | AED | د.إ |  |  |  |  |  | 2
 | Algeria |  | AFN | ؋ |  |  |  |  |  | 3
 | American Samoa |  | ALL | L |  |  |  |  |  | 4
 | Andorra |  | ANG | ƒ |  |  |  |  |  | 5
 | Angola |  | AOA | Kz |  |  |  |  |  | 6
 | Anguilla |  | ARS | $ |  |  |  |  |  | 7
 | Antarctica |  | AUD | $ |  |  |  |  |  | 8
 | [NAME] and [NAME] |  | [NAME] | ƒ |  |  |  |  |  | 9
 | Argentina |  | BAM | KM |  |  |  |  |  | 10
 | Armenia |  | BBD | $
 | Aruba |  | BDT | ৳ |  |  |  |  |  | Months
 | Australia |  | BGN | лв |  |  |  |  |  | 1
 | Austria |  | BHD | .د.ب
 | Azerbaijan |  | BIF | Fr
 | Bahamas |  | BMD | $
 | Bahrain |  | BND | $
 | Bangladesh |  | BOB | Bs.
 | Barbados |  | BRL | R$
 | Belarus |  | BSD | $
 | Belgium |  | BTN | Nu.
 | Belize |  | BWP | P
 | Benin |  | BYR | Br
 | Bermuda |  | BZD | $
 | Bhutan |  | CAD | $
 | Bolivia, Plurinational State of |  | CDF | Fr
 | Bolivia |  | CHF | Fr
 | Bosnia and Herzegovina |  | [NAME] | $
 | Botswana |  | CNY | ¥
 | Bouvet Island |  | COP | $
 | Brazil |  | CRC | ₡
 | British Indian Ocean Territory |  | CUP | $
 | [NAME] |  | CVE | Esc
 | Bulgaria |  | CZK | Kč
 | [NAME] |  | DJF | Fr
 | Burundi |  | DKK | kr
 | Cambodia |  | DOP | $
 | Cameroon |  | DZD | د.ج
 | Canada |  | EGP | £
 | Cape Verde |  | ERN | Nfk
 | Cayman Islands |  | ETB | Br
 | Central African Republic |  | EUR | €
 | Chad |  | FJD | $
 | Chile |  | FKP | £
 | China |  | GBP | £
 | Christmas Island |  | GEL | ლ
 | Cocos (Keeling) Islands |  | GHS | ₵
 | Colombia |  | GIP | £
 | Comoros |  | GMD | D
 | Congo |  | GNF | Fr
 | Congo, the Democratic Republic of the |  | GTQ | Q
 | Cook Islands |  | GYD | $
 | Costa Rica |  | HKD | $
 | Côte d'Ivoire |  | HNL | L
 | Croatia |  | HRK | kn
 | Cuba |  | HTG | G
 | Cyprus |  | HUF | Ft
 | Czech Republic |  | IDR | Rp
 | Denmark |  | ILS | ₪
 | Djibouti |  | INR | ₹
 | Dominica |  | IQD | ع.د
 | Dominican Republic |  | IRR | ﷼
 | Ecuador |  | ISK | kr
 | Egypt |  | JMD | $
 | El Salvador |  | JOD | د.ا
 | Equatorial Guinea |  | [NAME] | ¥
 | Eritrea |  | KES | Sh
 | Estonia |  | KGS | лв
 | Ethiopia |  | [NAME] | ៛
 | Falkland Islands (Malvinas) |  | KMF | Fr
 | Faroe Islands |  | KPW | ₩
 | Fiji |  | KRW | ₩
 | Finland |  | KWD | د.ك
 | France |  | KYD | $
 | French [NAME] |  | LAK | ₭
 | French Polynesia |  | LBP | ل.ل
 | French Southern Territories |  | LKR | Rs
 | Gabon |  | LRD | $
 | Gambia |  | LSL | L
 | Georgia |  | LYD | ل.د
 | Germany |  | MAD | د. م.
 | Ghana |  | MDL | L
 | Gibraltar |  | MGA | Ar
 | Greece |  | MKD | ден
 | Greenland |  | MMK | Ks
 | Grenada |  | MNT | ₮
 | Guadeloupe |  | MOP | P
 | Guam |  | MRO | UM
 | Guatemala |  | MUR | ₨
 | Guernsey |  | MVR | .ރ
 | Guinea |  | [NAME] | MK
 | Guinea-Bissau |  | [NAME] | $
 | Guyana |  | MYR | RM
 | Haiti |  | MZN | MT
 | Heard Island and McDonald Islands |  | [NAME] | ₦
 | Holy See (Vatican City State) |  | NIO | C$
 | Honduras |  | NOK | kr
 | Hong Kong |  | NPR | ₨
 | Hungary |  | NZD | $
 | Iceland |  | OMR | ر.ع.
 | India |  | PAB | B/.
 | Indonesia |  | PEN | S/.
 | Iran, Islamic Republic of |  | PGK | K
 | Iraq |  | PHP | ₱
 | Ireland |  | PKR | ₨
 | Isle of Man |  | PLN | zł
 | Israel |  | PYG | ₲
 | Italy |  | QAR | ر.ق
 | Jamaica |  | RON | lei
 | Japan |  | RSD | din.
 | Jersey |  | RWF | Fr
 | Jordan |  | RUB | ₽
 | Kazakhstan |  | SAR | ر.س
 | Kenya |  | SBD | $
 | Kiribati |  | SCR | ₨
 | Korea, Democratic People's Republic of |  | SDG | ج.س.
 | South Korea |  | SEK | kr
 | Kuwait |  | SGD | $
 | Kyrgyzstan |  | SHP | £
 | Lao People's Democratic Republic |  | SLL | Le
 | Latvia |  | SOS | Sh
 | Lebanon |  | SRD | $
 | [NAME] |  | SSP | £
 | Liberia |  | STD | Db
 | Libya |  | SYP | £
 | [NAME] |  | SZL | L
 | Lithuania |  | TJS | ЅМ
 | Luxembourg |  | [NAME] | m
 | Macao |  | TND | د.ت
 | Macedonia, the former Yugoslav Republic of |  | TOP | T$
 | Madagascar |  | TTD | $
 | [NAME] |  | TWD | $
 | Malaysia |  | TZS | Sh
 | Maldives |  | UAH | ₴
 | [NAME] |  | UGX | Sh
 | Malta |  | USD | $
 | Marshall Islands |  | UYU | $
 | Martinique |  | VEF | [NAME]
 | Mauritania |  | VND | ₫
 | [NAME] |  | VUV | Vt
 | Mayotte |  | WST | T
 | Mexico |  | XAF | Fr
 | Micronesia, Federated States of |  | XCD | $
 | Moldova, Republic of |  | XOF | Fr
 | Monaco |  | XPF | Fr
 | Mongolia |  | XPF | Fr
 | Montenegro |  | XPF | Fr
 | Montserrat |  | YER | ﷼
 | Morocco |  | ZAR | R
 | Mozambique |  | ZMW | ZK
 | Myanmar
 | Namibia
 | Nauru
 | Nepal
 | Netherlands
 | New Caledonia
 | New Zealand
 | Nicaragua
 | [NAME]
 | Nigeria
 | Niue
 | Norfolk Island
 | Northern Mariana Islands
 | Norway
 | Oman
 | Pakistan
 | Palau
 | Panama
 | [NAME]
 | Paraguay
 | Peru
 | Philippines
 | Pitcairn
 | Poland
 | Portugal
 | Puerto Rico
 | Qatar
 | Réunion
 | Romania
 | Russia
 | Rwanda
 | [NAME], [NAME] and [NAME]
 | [NAME] Nevis
 | [NAME]
 | [NAME] and Miquelon
 | Saint Vincent and the Grenadines
 | Samoa
 | [NAME]
 | Sao Tome and Principe
 | Saudi Arabia
 | Senegal
 | Serbia
 | Seychelles
 | Sierra Leone
 | Singapore
 | Slovakia
 | Slovenia
 | Solomon Islands
 | Somalia
 | South Africa
 | South Georgia and the South Sandwich Islands
 | South Sudan
 | Spain
 | [NAME]
 | Sudan
 | Suriname
 | [NAME] and [NAME]
 | Swaziland
 | Sweden
 | Switzerland
 | Syrian Arab Republic
 | Taiwan
 | Tajikistan
 | Tanzania, United Republic of
 | Thailand
 | Timor-Leste
 | Togo
 | Tokelau
 | Tonga
 | Trinidad and Tobago
 | Tunisia
 | Turkey
 | Turkmenistan
 | Turks and Caicos Islands
 | Tuvalu
 | Uganda
 | Ukraine
 | United Arab Emirates
 | United Kingdom
 | USA
 | United States Minor Outlying Islands
 | Uruguay
 | Uzbekistan
 | [NAME]
 | Venezuela
 | Vietnam
 | Virgin Islands, British
 | Virgin Islands, U.S.
 | [NAME]
 | Western Sahara
 | Yemen
 | Zambia
 | Zimbabwe
 | (Add Country 1)
 | (Add Country 2)
 | (Add Country 3)
 | (Add Country 4)
 | (Add Country 5)