Dear all,
I have a issue with my spreadsheet. It is a big budget for a 10 year period...
I have just take a few rows from the spreadsheet and attached it here.
In the document I have tried to explain my need in the example.
I also paste the text here, below.
Looking forward to youre valuable help,
Roger
Note.
In the example I sell rooms. I have two rooms per one units.
When client want to rent rooms from me I add number of rooms he/she need in row 8.
In row 9 I can see how many units it will be needed.
In G11 I can add my percent of clients need. In example I get the whole deal.
Therefore 100 %.
In Janyary clients need 84 units (168 rooms) and I need therefore to delivery 84 units in January (K15). In April clients wants 200 rooms, so I need to build 16 more units (N15).
(84 room units x 2 rooms per units = 168 rooms + another 16 room units x 2 rooms per units = 32 rooms. Total 168 + 32 = 200 rooms).
In August year 2 I need to add 50 more units (100 rooms) (AG15) and so on.
Issue 1:
I need to go to the bank to finance the project. But I do not want to loan money beforeI need them. So in I29 I have the total amount for the first purchase. Cell I29 picks the value from K15. Only. It will therefore be wrong amount of money I need to loan. I will need more money becouse N15 and AG15 and so on.
Issue2:
I need a multiple of different loans. Maybe up to five different loans.
Different loans will have different interests. And some of the loans will I not pay for the first year.
I will therefore be able to choose how many loans I will get from bank.
What intresest each and every loan will have.
I will also be able to choose how many years each loan will be.
Example:
Year 1: 0 kr Depreciation/Amortazition.
Year 2: 5 000 000 Depreciation/Amortazition.
Year 3: 10 000 000 Depreciation/Amortazition.
Year 4: 10 000 000 Depreciation/Amortazition.
As you can see from row 27 to 45 I have tried to solve the issues. But I do not succed in a good way.
Looking forward to you kind help and solutions.
Best regards,
Roger
