madsdalgaard
New Member
- Joined
- Feb 14, 2018
- Messages
- 2
Hey guys.
I was recommended you guys by my friend, who said you guys were geniuses - Hopefully you can help me with my problem!
Question:
I have a cash flow question within the subject of financing. In here I have a time series of Costs in my cash flow with -6m in each period (Could be quarterly or yearly), e.g.
Costs:
A1 = -6m, B1 = -6m, C1 = -6m, D1 = -6m, E1 = -6m, F1 = -6m etc. etc.
To finance all of these costs I am using three type of loans. The idea is that the first loan is used in full before I draw upon the second loan. Lets say I have the following loans:
Loan1 = 9m
Loan2 = 7.5m
Loan3 = 19.5m
I am then looking to have a row with the loan needed in each period and the loan balance in each period for all of the three loans. The tricky part is to make the worksheet draw automatically on loan2 when loan1 is depleted.
For example it should look something like this:
A1 = "Costs", B1 = -6m, C1 = -6m, D1 = -6m, E1 =-6m, F1 = -6m etc. etc.
A2 = "Loan1", B2 = 6m, C2 = 3m, D2 = 0, E2 = 0, F2 = 0 etc. etc.
A3 = "Loan1 Balance", B3 = 3m, C3 =0m, D3 = 0, E3 = 0, etc. etc.
A4 = "Loan2", B4 = 0, C4 = 3m, D4 = 4.5m, E4 = 0m, etc. etc.
A5 = "Loan2 Balance", B5 = 7.5m, C5 = 4.5m, E5 = 0m etc. etc.
A6 = "Loan 3", B2 = 0m, C2 = 0m, D2 = 1.5m, E2 = 6m, F2 = 6m etc. etc.
A7 = "Loan3 Balance", B2 = 19.5m, C2 = 19.5m, D2 = 18m, E2 = 12m, F2 = 6m etc. etc.
The big issue I have, is to make this automatically adjust if the loan sizes changes, or if I suddenly have fewer or more loans than 3.
Hopefully you are able to help out!
I know this can be a mouthful, so any help is much appreciated!
Kind regards,
Mads
I was recommended you guys by my friend, who said you guys were geniuses - Hopefully you can help me with my problem!
Question:
I have a cash flow question within the subject of financing. In here I have a time series of Costs in my cash flow with -6m in each period (Could be quarterly or yearly), e.g.
Costs:
A1 = -6m, B1 = -6m, C1 = -6m, D1 = -6m, E1 = -6m, F1 = -6m etc. etc.
To finance all of these costs I am using three type of loans. The idea is that the first loan is used in full before I draw upon the second loan. Lets say I have the following loans:
Loan1 = 9m
Loan2 = 7.5m
Loan3 = 19.5m
I am then looking to have a row with the loan needed in each period and the loan balance in each period for all of the three loans. The tricky part is to make the worksheet draw automatically on loan2 when loan1 is depleted.
For example it should look something like this:
A1 = "Costs", B1 = -6m, C1 = -6m, D1 = -6m, E1 =-6m, F1 = -6m etc. etc.
A2 = "Loan1", B2 = 6m, C2 = 3m, D2 = 0, E2 = 0, F2 = 0 etc. etc.
A3 = "Loan1 Balance", B3 = 3m, C3 =0m, D3 = 0, E3 = 0, etc. etc.
A4 = "Loan2", B4 = 0, C4 = 3m, D4 = 4.5m, E4 = 0m, etc. etc.
A5 = "Loan2 Balance", B5 = 7.5m, C5 = 4.5m, E5 = 0m etc. etc.
A6 = "Loan 3", B2 = 0m, C2 = 0m, D2 = 1.5m, E2 = 6m, F2 = 6m etc. etc.
A7 = "Loan3 Balance", B2 = 19.5m, C2 = 19.5m, D2 = 18m, E2 = 12m, F2 = 6m etc. etc.
The big issue I have, is to make this automatically adjust if the loan sizes changes, or if I suddenly have fewer or more loans than 3.
Hopefully you are able to help out!
I know this can be a mouthful, so any help is much appreciated!
Kind regards,
Mads
