Excel assignment
Paper details:
these were notes provided
1. in this project Goodwill is called “intangibles” and amortized over a period of time
2. Project : focus on the worksheet for 2004 – this has intercompany sales, use 2ox3 as an example. (once you
do x4, you can make progress on x5 & x6 – you can leave the bond for last)
3. To start the project – you should do some preliminary calculations: figure out 100% value of the subsidiary,
allocation of FV-BV schedule this out for the 2ox3-6. then calculate the controlling % of these items and non-
controlling
4. Bonds affect 2ox5 and 2ox6 – calculations need to be done
5. Basic worksheet adjustments:
Steps needed to be done on the worksheets:
1. remove income from Sub
2. remove the sub capital and r/e
3. remove dividend payable/recieviable
4. intercompany sales – i.e.
Gross Profit in ending inventory
this is for the worksheet
bonds are a special intercompany item
5. amortization of differences FV-BV
1. in this project Goodwill is called “intangibles” and amortized over a period of time
2. Project : focus on the worksheet for 2004 – this has intercompany sales, use 2ox3 as an example. (once you
do x4, you can make progress on x5 & x6 – you can leave the bond for last)
3. To start the project – you should do some preliminary calculations: figure out 100% value of the subsidiary,
allocation of FV-BV schedule this out for the 2ox3-6. then calculate the controlling % of these items and non-
controlling
4. Bonds affect 2ox5 and 2ox6 – calculations need to be done
5. Basic worksheet adjustments:
Steps needed to be done on the worksheets:
1. remove income from Sub
2. remove the sub capital and r/e
3. remove dividend payable/recieviable
4. intercompany sales – i.e.
Gross Profit in ending inventory
this is for the worksheet
bonds are a special intercompany item
5. amortization of differences FV-BV
