Spreadsheet: 158720d1338373714-calculate-capitalised-interest-complicated-issue-for-the-ultimate-excel-champion-uec-test
Sheet: testing

Summary calculation of interest for capitalisation
Inputs
Reporting month | 2012-04-01 00:00:00
Group borrowing rate % | 0.08
 | Inputs |  |  | old format
Project no. |  | P-0100000
Project title |  | xxxxxx
Equity share % |  | 0.3
CAPEX as at 31 Dec of prior year | [project to date, A$,100%] | 5000000
Interest exp as at 31 Dec of prior year | [project to date, A$,100%] | 400000
 |  |  | Total
 |  |  | mthly
 |  | days
 |  |  |  |  |  |  |  | neglect here first, not woring.
CAPEX | ytd | A$, 100% |  | 600000 | 300000 | 200000 | 100000
CAPEX | mthly | A$, 100%
Interest exp | mthly | A$, 100%
CAPEX | project to date | A$, 100%
Interest exp | project to date | A$, Co. share
CAPEX | mthly | A$, Co. share
CAPEX | project to date | 6500000
Interest exp | mthly | 150000
Interest exp | project to date | 450000
testing
CAPEX | ytd | A$, 100%
CAPEX | mthly | A$, 100%
Interest exp | mthly | A$, 100%
CAPEX | project to date | A$, 100%
Interest exp | project to date | A$, Co. share
CAPEX | mthly | A$, Co. share
CAPEX | project to date | 26384113.08757881
Interest exp | mthly | 107560
Interest exp | project to date | 482724.8866865294
new model |  |  |  |  | ytd, cumulative | net | project to date, cumulative | net | ytd, cumulative | net | YTD
Project no. | Project title | Co. equity share % | CAPEX as at 31 Dec of prior year | Interest exp as at 31 Dec of prior year | Capitalised interest | Capitalised interest | adjusted asset bal | Capitalised interest | Capitalised interest | CAPEX
 |  |  | [project to date, A$,100%] | [project to date, A$,100%] | [ytd,A$, Co. share] | [mthly,A$, Co. share] | [project to date, A$, 100%] | [mthly,A$, 100%] | [ytd,A$, 100%] | [mthly,A$, 100%]
P-0100000 | xxxx | 0.3 | 5000000 | 100000 | ok if column H, I, K fixed. |  | need help | need help | need help |  | 150000 | 300000 | 301000
P-0100001 | xxxx | 0.3 | 5000000 | 100000 |  |  | need help | need help | need help |  | 150000
P-0100002 | xxxx | 0.3 | 5000000 | 100000 |  |  | need help | need help | need help |  | 120000
P-0100003 | xxxx | 0.3 | 5000000 | 100000 |  |  | need help | need help | need help |  | 30000
P-0100004 | xxxx | 0.3 | 5000000 | 100000 |  |  | need help | need help | need help |  | 150000
P-0100005 | xxxx | 0.3 | 5000000 | 100000 |  |  | need help | need help | need help |  | 150000
 |  |  |  |  | Thanks for your help!!!!
 |  |  |  |  | issues | issues | issues | issues | issues
 |  |  |  |  | this is ok, once column H&I are fixed. | this is ok, once column H&I are fixed. | automate to showing the latest project to date (prior year+ytd capitalised interest + ytd capex). | same as the issues on the right. What it needs to ensure is that it can ensure the calculation can consiedr the effect of previously capitalised interest into the calculation of current month capitalised interest. | Rather than as method shown in current practise. I want one automated formula in the cell that automatically calculated YTD capitalised interest (interest expense) - base on the reporting month (cell B4). If from the example show in current practise, the ideal result is $816k.
 |  |  |  |  |  |  |  |  |  | current practise
 |  |  |  |  |  |  |  |  |  | assume | 2012-01-01 00:00:00 | 2012-02-01 00:00:00 | 2012-03-01 00:00:00
 |  |  |  |  |  |  |  |  |  | prior year bal Icapex+capitalised interest
 |  |  |  |  |  |  |  |  |  | capex (YTD), download
 |  |  |  |  |  |  |  |  |  | net mthly capex
 |  |  |  |  |  |  |  |  |  | capitalised interest YTD
 |  |  |  |  |  |  |  |  |  | asset adj bal (project to date)