I am looking to purchase a business and then multiple businesses.
I have all the basic numbers and have attempted my own spreadsheet to do some financial forcasting on how many businesses I can purchase over time.
I am not an accountant and not great with numbers so would like someone to help me put together a basic spreadsheet to do some planning.
Please see attached example (I have started the project myself but not very good at it and probably have numbers in all the wrong places)
The attached spreadsheet is the basic format I am looking for.
MUST SPEAK FLUENT ENGLISH: So we can discuss via skype messenger or phone call.
Please see the basics of my plan below:
I am starting my business with $500,000.
$300,000 capital and $200,000 on finance (7 year loan at 12% pa).
From day 1 the business will return $150,000 pa.
I want to calculate loan repayments for the first 12 months and see how much money i have "in the bank" after 12 months.
At the 12 month mark I will purchase business 2 (same price $500,000) same return pa ($150,000)
I will use the funds from the business 1 ($150,000 minus loan 1 repayments) as the deposit for the next business.
The second 12 months will return $150k from business 1 (minus loan repayments) and $150k from business 2 (minus loan repayments) leaving x for a deposit for business 3 at the 24 month mark.
At the 24 month mark I will purchase business 3 (same price $500,000) same return pa ($150,000)
I will use the funds from Business 1 ($150,000 minus loan 1 repayments) and business 2 ($150k minus loan 2 repayments) as the deposit towards business 4
The third 12 months will return $150k from business 1 (minus loan 1 repayments) plus $150k from business 2 (minus loan 2 repayments) plus $150k from business 3 (minus loan 3 repayments) leaving x for a deposit for business towards business 4 at the 36 month mark.
Purchase business 4 (same details) and continue to year 7
Please clearly indicate in your proposal that you fully understand the task and are able to speak with me via phone or skype to discuss any details and can converse in FLUENT ENGLISH
More work available in the future for the right person that can do the job quickly and easily
PLEASE NOTE: the attached spreadsheet is just my own work that is not likely to be correct, I am simply providing it as an example of the style of layout I am looking for
I would also like the starting amount ($300,000 capital and $200,000 deposit) to be positioned at the top so I can use this cell as "variable data" If I change these numbers the remaining spreadsheet should adjust accordingly.