Balance sheet & debt schedule

This model represents 3 legal entities; a holding company and 2 trading companies. The model is a consolidated view, so we are 'constructing' a balance sheet that represents the holding company.

Check the balance sheet in the attached xl, which is connected to the rest of the model, and add the following opening balances: -

Current Assets
Cash at bank and in hand
Current Account £16,702.59
Savings Account £42,002.87

Total Cash at bank and in hand £58,705.46

Total Current Assets £58,705.46

The only liabilities relate to the debt, which is as follows: -

Separate loans linked to tranches of an M&A deal. They are only drawn down as required, so we need a debt schedule that is connected to the rest of the model and shows each tranche coming 'live' on the assumption that every tranche will be drawn down (ie worst case scenario).

o Tranche 1 = £305k x 6 yrs from 01-08-2016
o T2 = - £100k x 5 yrs wef 01-08-2017
o T3 - £100k x 4 yrs wef 01-08-2018
o T4 - £100k x 3 yrs wef 01-08-2019
o T5 - £100k x 2 yrs wef 01-08-2020
o T6 - £100k x 1 yr wef 01-08-2021

Assume all of the above are capital and interest repayment, charged at 10% pa coupon - stick this assumption figure on the Key Assumptions tab so i can change it later if required.

Finally, there's also a debt of £239,400 @ 3.5% pa over base, with no capital repayment at present. So i will need 2 rows for this one, so we can start the capital repayment element at some stage in the future.

Can you let me have a quote first?

Thanks