FREE Trial
Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Accounting Depreciation Opening accounting net book value 0.00 8,112.00 7,316.25 6,450.04 5,504.78 4,478.07 12,322.87 9,633.33 6,854.81 3,984.64 1,020.06 8,339.98 3,447.73 0.00 0.00 One-off capex $m

image text in transcribed

Accounting Depreciation
Opening accounting net book value 0.00 8,112.00 7,316.25 6,450.04 5,504.78 4,478.07 12,322.87 9,633.33 6,854.81 3,984.64 1,020.06 8,339.98 3,447.73 0.00 0.00
One-off capex $m 8,840.00 0.00 0.00 0.00 0.00 10,447.94 0.00 0.00 0.00 0.00 12,112.02 0.00 0.00 0.00 0.00
Regular capex $m 624.00 648.96 674.92 695.17 716.02 737.50 759.63 782.42 805.89 830.06 854.97 880.62 907.03 934.24 962.27
Capital expenditure incurred (nominal) $m 9,464.00 648.96 674.92 695.17 716.02 11,185.44 759.63 782.42 805.89 830.06 12,966.99 880.62 907.03 934.24 962.27
PP&E - accounting (straight line) years 7.00
Capital expenditure assumed to be made on the first day of the period.
Year
1 1,352.00 1,352.00 1,352.00 1,352.00 1,352.00 1,352.00 1,352.00 1,352.00 1,352.00 1,352.00 1,352.00 1,352.00 1,352.00 1,352.00 1,352.00
2 0.00 92.71 92.71 92.71 92.71 92.71 92.71 92.71 92.71 92.71 92.71 92.71 92.71 92.71 92.71
3 0.00 0.00 96.42 96.42 96.42 96.42 96.42 96.42 96.42 96.42 96.42 96.42 96.42 96.42 96.42
4 0.00 0.00 0.00 99.31 99.31 99.31 99.31 99.31 99.31 99.31 99.31 99.31 99.31 99.31 99.31
5 0.00 0.00 0.00 0.00 102.29 102.29 102.29 102.29 102.29 102.29 102.29 102.29 102.29 102.29 102.29
6 0.00 0.00 0.00 0.00 0.00 1,597.92 1,597.92 1,597.92 1,597.92 1,597.92 1,597.92 1,597.92 1,597.92 1,597.92 1,597.92
7 0.00 0.00 0.00 0.00 0.00 0.00 108.52 108.52 108.52 108.52 108.52 108.52 108.52 108.52 108.52
8 0.00 0.00 0.00 0.00 0.00 0.00 0.00 111.77 111.77 111.77 111.77 111.77 111.77 111.77 111.77
9 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 115.13 115.13 115.13 115.13 115.13 115.13 115.13
10 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 118.58 118.58 118.58 118.58 118.58 118.58
11 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 1,852.43 1,852.43 1,852.43 1,852.43 1,852.43
12 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 125.80 125.80 125.80 125.80
13 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 129.58 129.58 129.58
14 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 133.46 133.46
15 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 137.47
Accounting depreciation 1,352.00 1,444.71 1,541.13 1,640.43 1,742.72 3,340.64 3,449.16 3,560.94 3,676.06 3,794.64 5,647.07 5,772.87 4,354.76 934.24 962.27
Closing accounting net book value 0.00 8,112.00 7,316.25 6,450.04 5,504.78 4,478.07 12,322.87 9,633.33 6,854.81 3,984.64 1,020.06 8,339.98 3,447.73 0.00 0.00 0.00
Taxation Depreciation
Opening tax net book value 0.00 8,112.00 7,316.25 6,450.04 5,504.78 4,478.07 12,322.87 9,633.33 6,854.81 3,984.64 1,020.06 8,339.98 3,447.73 0.00 0.00
Capital expenditure incurred 9,464.00 648.96 674.92 695.17 716.02 11,185.44 759.63 782.42 805.89 830.06 12,966.99 880.62 907.03 934.24 962.27
Tax depreciation 1,892.80 1,752.19 1,598.23 1,429.04 1,244.16 3,132.70 2,616.50 2,083.15 1,532.14 962.94 2,797.41 1,844.12 870.95 186.85 192.45
Closing tax net book value 0.00 7,571.20 7,008.77 6,392.94 5,716.17 4,976.64 12,530.81 10,466.00 8,332.60 6,128.56 3,851.76 11,189.64 7,376.48 3,483.81 747.40 769.82

Question 5

Analyst comment: Our accounting specialist thinks our year 15 closing net book value (from an accounting perspective) is understated [Error(s) in Calculations!91:120]

What is the closing accounting net book value ($m) in the Year ending June 2030?

  1. 6,211.04

  2. 6,211.14

  3. 6,211.27

  4. 6,211.39

  5. 6,211.57

  6. 6,211.62

PP&E Accounting Depreciation Opening accounting net book value 0.00 8,112.00 7,316.25 6,450.04 5,504.78 4,478.07 12,322.87 9,633.33 6,854.81 3,984.64 1.020.06 8,339.98 3,447.73 0.00 0.00 One-off capex Regular capex Capital expenditure incurred (nominal) 8.840.00 624.00 9,464.00 $m 0.00 648.96 648.96 0.00 674.92 674.92 0.00 695.17 695.17 0.00 716.02 716.02 10,447.94 737.50 11,185.44 0.00 759.63 759.63 0.00 782.42 782.42 0.00 805.89 805.89 0.00 830.06 830.06 12, 112.02 854.97 12,966.99 0.00 880.62 880.62 0.00 907.03 907.03 0.00 934.24 934.24 0.00 962.27 962.27 PP&E - accounting (straight line) years 7.00 Capital expenditure assumed to be made on the first day of the period. Year 1,352.00 1,352.00 92.71 0.00 0.00 0.00 0.00 0.00 1,352.00 92.71 96.42 0.00 ooooooooooo 1,352.00 92.71 96.42 99.31 102.29 0.00 0.00 8 8 8 8 1.352.00 92.71 96.42 99.31 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 1.640.43 OOOOOooooo 1,352.00 92.71 96.42 99.31 102.29 1,597.92 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 3,340.64 1,352.00 92.71 96.42 99.31 102.29 1,597.92 108.52 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 3,449.16 1.352.00 92.71 96.42 99.31 102.29 1,597.92 108.52 111.77 0.00 0.00 0.00 0.00 0.00 0.00 0.00 3,560.94 1,352.00 92.71 96.42 99.31 102.29 1,597.92 108.52 111.77 115.13 0.00 0.00 0.00 0.00 0.00 0.00 3,676.06 1,352.00 92.71 96.42 99.31 102.29 1,597.92 108.52 111.77 115.13 118.58 0.00 0.00 0.00 0.00 0.00 3.794.64 1,352.00 92.71 96.42 99.31 102.29 1,597.92 108.52 111.77 115.13 118.58 1,852.43 0.00 0.00 0.00 0.00 5,647.07 1.352.00 92.71 96.42 99.31 102.29 1,597.92 108.52 111.77 115.13 118.58 1,852.43 125.80 1,352.00 92.71 96.42 99.31 102.29 1,597.92 108.52 111.77 115.13 118.58 1,852.43 125.80 129.58 0.00 0.00 4,354.76 1,352.00 92.71 96.42 99.31 102.29 1,597.92 108.52 111.77 115.13 118.58 1,852.43 125.80 129.58 133.46 0.00 934.24 1,352.00 92.71 96.42 99.31 102.29 1,597.92 108.52 111.77 115.13 118.58 1,852.43 125.80 129.58 133.46 137.47 962.27 8 8 8 0.00 0.00 0.00 0.00 0.00 0.00 1,444.71 0.00 0.00 0.00 1,352.00 0.00 0.00 0.00 0.00 1,742.72 15 Accounting depreciation 0.00 1,541.13 0.00 0.00 5,772.87 Closing accounting net book value 0.00 8,112.00 7.316.25 6.450.04 5,504.78 4.478.07 1 2,322.87 9 ,633.33 6,854.81 3.984.64 1,020.06 8,339.98 3.447. 73 0 .00 0.00 0.00 PP&E Accounting Depreciation Opening accounting net book value 0.00 8,112.00 7,316.25 6,450.04 5,504.78 4,478.07 12,322.87 9,633.33 6,854.81 3,984.64 1.020.06 8,339.98 3,447.73 0.00 0.00 One-off capex Regular capex Capital expenditure incurred (nominal) 8.840.00 624.00 9,464.00 $m 0.00 648.96 648.96 0.00 674.92 674.92 0.00 695.17 695.17 0.00 716.02 716.02 10,447.94 737.50 11,185.44 0.00 759.63 759.63 0.00 782.42 782.42 0.00 805.89 805.89 0.00 830.06 830.06 12, 112.02 854.97 12,966.99 0.00 880.62 880.62 0.00 907.03 907.03 0.00 934.24 934.24 0.00 962.27 962.27 PP&E - accounting (straight line) years 7.00 Capital expenditure assumed to be made on the first day of the period. Year 1,352.00 1,352.00 92.71 0.00 0.00 0.00 0.00 0.00 1,352.00 92.71 96.42 0.00 ooooooooooo 1,352.00 92.71 96.42 99.31 102.29 0.00 0.00 8 8 8 8 1.352.00 92.71 96.42 99.31 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 1.640.43 OOOOOooooo 1,352.00 92.71 96.42 99.31 102.29 1,597.92 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 3,340.64 1,352.00 92.71 96.42 99.31 102.29 1,597.92 108.52 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 3,449.16 1.352.00 92.71 96.42 99.31 102.29 1,597.92 108.52 111.77 0.00 0.00 0.00 0.00 0.00 0.00 0.00 3,560.94 1,352.00 92.71 96.42 99.31 102.29 1,597.92 108.52 111.77 115.13 0.00 0.00 0.00 0.00 0.00 0.00 3,676.06 1,352.00 92.71 96.42 99.31 102.29 1,597.92 108.52 111.77 115.13 118.58 0.00 0.00 0.00 0.00 0.00 3.794.64 1,352.00 92.71 96.42 99.31 102.29 1,597.92 108.52 111.77 115.13 118.58 1,852.43 0.00 0.00 0.00 0.00 5,647.07 1.352.00 92.71 96.42 99.31 102.29 1,597.92 108.52 111.77 115.13 118.58 1,852.43 125.80 1,352.00 92.71 96.42 99.31 102.29 1,597.92 108.52 111.77 115.13 118.58 1,852.43 125.80 129.58 0.00 0.00 4,354.76 1,352.00 92.71 96.42 99.31 102.29 1,597.92 108.52 111.77 115.13 118.58 1,852.43 125.80 129.58 133.46 0.00 934.24 1,352.00 92.71 96.42 99.31 102.29 1,597.92 108.52 111.77 115.13 118.58 1,852.43 125.80 129.58 133.46 137.47 962.27 8 8 8 0.00 0.00 0.00 0.00 0.00 0.00 1,444.71 0.00 0.00 0.00 1,352.00 0.00 0.00 0.00 0.00 1,742.72 15 Accounting depreciation 0.00 1,541.13 0.00 0.00 5,772.87 Closing accounting net book value 0.00 8,112.00 7.316.25 6.450.04 5,504.78 4.478.07 1 2,322.87 9 ,633.33 6,854.81 3.984.64 1,020.06 8,339.98 3.447. 73 0 .00 0.00 0.00

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Globalization Gating And Risk Finance

Globalization Gating And Risk Finance

Authors: Unurjargal Nyambuu, Charles S. Tapiero

1st Edition

1119252652, 978-1119252658

More Books

Students also viewed these Finance questions

Question

Make a timeline of the development of theory of mind in human children. As you read on, add important milestones on this timeline. You may want to use one of the many infographic tools available...

Answered: 1 week ago

Question

★★★★★
On August 1, 2017, the following were the account balances of B&B Repair Services. During August, the following summary transactions were completed. Aug. 1 Paid S400 cash for advertising in local...

Answered: 1 week ago

Question

★★★★★
Accounting Depreciation Opening accounting net book value 0.00 8,112.00 7,316.25 6,450.04 5,504.78 4,478.07 12,322.87 9,633.33 6,854.81 3,984.64 1,020.06 8,339.98 3,447.73 0.00 0.00 One-off capex $m...

Answered: 1 week ago

Question

★★★★★
Create an array of five S t = 1 nas containing the first names of people in your family. Write a program that counts and displays the total number of vowels ( a , e , i , 0 , u ) in all five you...

Answered: 1 week ago

Question

★★★★★
You are working with ABC Corp. on its data analytics. The company asks you to compile a ranking of its to performing products over the past five years. What two questions must you ask? "Where is the...

Answered: 1 week ago

Question

★★★★★
tring to build the program that takes the sphere class layout to be able to create a new sphere Create an \"Sphere\" class that has the following: Attributes diameter - double that is the diameter of...

Answered: 1 week ago

Question

★★★★★
5. A lozenge initially weighing 2.95 g is dissolved in 85 mL of water. Given the experimental data below, find the best fit value of k and D/h using linear regression for both the spherical and...

Answered: 1 week ago

Question

★★★★★
The first sheet on QMB3200-Homework#1Data.xlsx is named Commute Time. It lists the average commute time (in minutes) it takes citizens of 379 metropolitan areas to travel to work and back home each...

Answered: 1 week ago

Question

★★★★★
I need help figuring out the rest of my network tables before I start on configuring everything. There's a section wanting an interface, IP address, mask, and gateway for the switches and subnets. I...

Answered: 1 week ago

Question

★★★★★
(Appendices) How do the periodic and perpetual inventory accounting systems differ from each other? LO64

Answered: 1 week ago

Question

★★★★★
(Appendices) Write the formulas for the calculation of accounts receivable turnover and inventory turnover. What do these calculations tell us about accounts receivable and inventory? LO53

Answered: 1 week ago

Question

★★★★★
(Appendices) EFFECTS OF SALES DISCOUNTS. Castore Security Systems makes all sales on credit, with terms 2/10, n/30. During 19x9, the list price (prediscount) of goods sold was $720,000. Customers...

Answered: 1 week ago

Previous Question Next Question