Question
In: Finance
1. Sports Company limited built and equipped a $4,800,000 plant and brought into operations early in...
1.
Sports Company limited built and equipped a $4,800,000 plant and
brought into operations early in year 1. Earnings of the company
(before depreciation and income taxes) is estimated at $2,200,000
in year 1, $ 2,500,000, in year 2, $2,700,000 in year 3, $3,500,000
in year 4, $ 3,900,000 in year 5, and $ 4,000,000 in year 6. The
company can use straight line method, double declining balance
method, or sum of the years’ digits depreciation method for the new
plant. Assume the plants’ useful life is 9 years (salvage value $
300,000) and Income tax rate of 45%.
Compute the separate effect that each of these three methods of
depreciation would have on
A.
Depreciation (all three methods)
B.
Income taxes
C. Net
Income
D.
Cash Flow (assumed equal to net income before depreciation) (all
the four in sheet1)
2.
Show the graph for A, B, C, and D. (One graph for depreciation,
Income tax, etc.) in sheet 2
3.
Comment on Items A to D in sheet 3Sports Company limited
built and equipped a $4,800,000 plant and brought
Solutions
Expert Solution
A. Depreciation for all three methods is presented below:
i) Staight line method
| Year | Depreciable base | Dep factor | Dep exp |
| 1 | $45,00,000 | 11.11% | $5,00,000 |
| 2 | $45,00,000 | 11.11% | $5,00,000 |
| 3 | $45,00,000 | 11.11% | $5,00,000 |
| 4 | $45,00,000 | 11.11% | $5,00,000 |
| 5 | $45,00,000 | 11.11% | $5,00,000 |
| 6 | $45,00,000 | 11.11% | $5,00,000 |
ii) Double declining balance method
Depreciation rate = straight line dep rate * 2
= 11.11%*2 = 22.22%
| Year | Book value | Depreciation | Ending book value |
| 1 | $48,00,000.0 | $10,66,666.7 | $37,33,333.3 |
| 2 | $37,33,333.3 | $8,29,629.6 | $29,03,703.7 |
| 3 | $29,03,703.7 | $6,45,267.5 | $22,58,436.2 |
| 4 | $22,58,436.2 | $5,01,874.7 | $17,56,561.5 |
| 5 | $17,56,561.5 | $3,90,347.0 | $13,66,214.5 |
| 6 | $13,66,214.5 | $3,03,603.2 | $10,62,611.3 |
iii) Sum of year digits method
Sum of year digits = 9(9+1) / 2 = 45
Depreciation = depreciable base * remaining useful life / sum of year digit
| Year | Depreciable base | Dep factor | Dep exp |
| 1 | $45,00,000 | 0.20 | $9,00,000 |
| 2 | $45,00,000 | 0.18 | $8,00,000 |
| 3 | $45,00,000 | 0.16 | $7,00,000 |
| 4 | $45,00,000 | 0.13 | $6,00,000 |
| 5 | $45,00,000 | 0.11 | $5,00,000 |
| 6 | $45,00,000 | 0.09 | $4,00,000 |
B) Income taxes
As a result of depreciation, the income taxes to be paid would be reduced to the extent of depreciation.
i) Straight line method
| Year | Depreication | Reduction in taxes |
| 1 | $5,00,000 | $2,25,000 |
| 2 | $5,00,000 | $2,25,000 |
| 3 | $5,00,000 | $2,25,000 |
| 4 | $5,00,000 | $2,25,000 |
| 5 | $5,00,000 | $2,25,000 |
| 6 | $5,00,000 | $2,25,000 |
ii) Double declining method
| Year | Depreication | Reduction in taxes |
| 1 | $10,66,666.7 | $4,80,000.0 |
| 2 | $8,29,629.6 | $3,73,333.3 |
| 3 | $6,45,267.5 | $2,90,370.4 |
| 4 | $5,01,874.7 | $2,25,843.6 |
| 5 | $3,90,347.0 | $1,75,656.1 |
| 6 | $3,03,603.2 | $1,36,621.4 |
iii) Sum of year digits
| Year | Depreication | Reduction in taxes |
| 1 | $9,00,000 | $4,05,000 |
| 2 | $8,00,000 | $3,60,000 |
| 3 | $7,00,000 | $3,15,000 |
| 4 | $6,00,000 | $2,70,000 |
| 5 | $5,00,000 | $2,25,000 |
| 6 | $4,00,000 | $1,80,000 |
C) The net income would reduce as a result of depreciation. The net income under the three methods is:
i) Straight line method
| EBIT | $22,00,000 | $25,00,000 | $27,00,000 | $35,00,000 | $39,00,000 | $40,00,000 |
| Depreciation | $5,00,000 | $5,00,000 | $5,00,000 | $5,00,000 | $5,00,000 | $5,00,000 |
| EBT | $17,00,000 | $20,00,000 | $22,00,000 | $30,00,000 | $34,00,000 | $35,00,000 |
| Income tax | $7,65,000 | $9,00,000 | $9,90,000 | $13,50,000 | $15,30,000 | $15,75,000 |
| Net income after tax | $9,35,000 | $11,00,000 | $12,10,000 | $16,50,000 | $18,70,000 | $19,25,000 |
ii) Double declining method
| 1 | 2 | 3 | 4 | 5 | 6 | |
| EBIT | $22,00,000 | $25,00,000 | $27,00,000 | $35,00,000 | $39,00,000 | $40,00,000 |
| Depreciation | $10,66,667 | $8,29,630 | $6,45,267 | $5,01,875 | $3,90,347 | $3,03,603 |
| EBT | $11,33,333 | $16,70,370 | $20,54,733 | $29,98,125 | $35,09,653 | $36,96,397 |
| Income tax | $5,10,000 | $7,51,667 | $9,24,630 | $13,49,156 | $15,79,344 | $16,63,379 |
| Net income after tax | $6,23,333 | $9,18,704 | $11,30,103 | $16,48,969 | $19,30,309 | $20,33,018 |
iii) Sum of year digits
| 1 | 2 | 3 | 4 | 5 | 6 | |
| EBIT | $22,00,000 | $25,00,000 | $27,00,000 | $35,00,000 | $39,00,000 | $40,00,000 |
| Depreciation | $9,00,000 | $8,00,000 | $7,00,000 | $6,00,000 | $5,00,000 | $4,00,000 |
| EBT | $13,00,000 | $17,00,000 | $20,00,000 | $29,00,000 | $34,00,000 | $36,00,000 |
| Income tax | $5,85,000 | $7,65,000 | $9,00,000 | $13,05,000 | $15,30,000 | $16,20,000 |
| Net income after tax | $7,15,000 | $9,35,000 | $11,00,000 | $15,95,000 | $18,70,000 | $19,80,000 |
D) Cash flow will increase as a result of depreciation
| 1 | 2 | 3 | 4 | 5 | 6 | |
| EBIT | $22,00,000 | $25,00,000 | $27,00,000 | $35,00,000 | $39,00,000 | $40,00,000 |
| Depreciation | $5,00,000 | $5,00,000 | $5,00,000 | $5,00,000 | $5,00,000 | $5,00,000 |
| EBT | $17,00,000 | $20,00,000 | $22,00,000 | $30,00,000 | $34,00,000 | $35,00,000 |
| Income tax | $7,65,000 | $9,00,000 | $9,90,000 | $13,50,000 | $15,30,000 | $15,75,000 |
| Net income after tax | $9,35,000 | $11,00,000 | $12,10,000 | $16,50,000 | $18,70,000 | $19,25,000 |
| Net cash flow | $14,35,000 | $16,00,000 | $17,10,000 | $21,50,000 | $23,70,000 | $24,25,000 |
ii) Double declining method
| 1 | 2 | 3 | 4 | 5 | 6 | |
| EBIT | $22,00,000 | $25,00,000 | $27,00,000 | $35,00,000 | $39,00,000 | $40,00,000 |
| Depreciation | $10,66,667 | $8,29,630 | $6,45,267 | $5,01,875 | $3,90,347 | $3,03,603 |
| EBT | $11,33,333 | $16,70,370 | $20,54,733 | $29,98,125 | $35,09,653 | $36,96,397 |
| Income tax | $5,10,000 | $7,51,667 | $9,24,630 | $13,49,156 | $15,79,344 | $16,63,379 |
| Net income after tax | $6,23,333 | $9,18,704 | $11,30,103 | $16,48,969 | $19,30,309 | $20,33,018 |
| Net cash flow | $16,90,000 | $17,48,333 | $17,75,370 | $21,50,844 | $23,20,656 | $23,36,621 |
iii) Sum of year digits
| 1 | 2 | 3 | 4 | 5 | 6 | |
| EBIT | $22,00,000 | $25,00,000 | $27,00,000 | $35,00,000 | $39,00,000 | $40,00,000 |
| Depreciation | $9,00,000 | $8,00,000 | $7,00,000 | $6,00,000 | $5,00,000 | $4,00,000 |
| EBT | $13,00,000 | $17,00,000 | $20,00,000 | $29,00,000 | $34,00,000 | $36,00,000 |
| Income tax | $5,85,000 | $7,65,000 | $9,00,000 | $13,05,000 | $15,30,000 | $16,20,000 |
| Net income after tax | $7,15,000 | $9,35,000 | $11,00,000 | $15,95,000 | $18,70,000 | $19,80,000 |
| Net cash flow | $16,15,000 | $17,35,000 | $18,00,000 | $21,95,000 | $23,70,000 | $23,80,000 |
jeff jeffy answered 1 year agoRelated Solutions
Edwards Company contracted on 4/1/17 to construct a building for $4,800,000. The project was completed in...
Edwards Company contracted on 4/1/17 to construct a building for
$4,800,000. The project was completed in 2019. Additional data
follow: 2017 2018 2019 Costs incurred to date $1,120,000 $2,700,000
$3,800,000 Estimated cost to complete 2,080,000 900,000 — Billings
to date 1,000,000 3,800,000 4,800,000 Collections to date 800,000
2,600,000 4,400,000 Instructions (a) Calculate the income
recognized by Edwards under the percentage-of-completion method of
accounting in each of the years 2017, 2018, and 2019. (b) Prepare
all necessary entries for the year...
Hello, Looking to compare! Thanks, The East Wind Company has a power plant designed and built...
Hello,
Looking to compare!
Thanks,
The East Wind Company has a power plant designed and built to
serve its three manufacturing plants. Data for 2010 are as follows:
Usage in Kilowatt-Hours
Factory location
Budget
Actual
Pictou
100,000
80,000
Amherst
60,000
120,000
Yarmouth
40,000
40,000
Budgeted fixed costs for the year were $1,000,000. Actual fixed
costs for th year were $1,100,000.
Variable costs were budgeted as $10 per kilowatt-hour. The
actual total variable costs were
$2,200,000.
1. Calculate the amount of...
1. On the 1 January 2014, Lucky Limited opened a new plant in New Delhi. The...
1. On the 1 January 2014, Lucky Limited opened a new
plant in New Delhi. The following costs were incurred during
January 2014 with regards to the new PPE, excluding taxes:
invoiced price of the PPE 60
000 000
• costs of testing of plant to ensure that it is
operating in the manner intended by management 2 000 000
• proceeds from the sale of the goods produced in
testing (600 000)
• costs incurred in selling the scrap...
QUESTION 1 Douglas oversees the financial operations at The Green Zone. He was recently brought on...
QUESTION 1
Douglas oversees the financial operations at The Green Zone. He
was recently brought on because the business is in a high growth
and the owners wanted extra financial expertise. He is responsible
for planning and managing The Green Zone’s financial resources,
including developing plans that outline its financial short-term
and long-term needs, raising capital for further growth and
expansion, and evaluating financial outcomes and expectations.
Which of the following is most likely Douglas’s job title?
A.
CIO
B....
A company called Worldwide Development Ltd from Europe, had an electronic software manufacturing plant built for...
A company called Worldwide Development Ltd from Europe, had an
electronic software manufacturing plant built for them by
Electronic Merchandise Ltd, a company from the United States of
America (USA). The amount that Worldwide Development Ltd owes to
Electronic Merchandise Ltd for the manufacturing plant is
$10,000,000. Worldwide Development Ltd Electronic agreed to pay
Electronic Merchandise Ltd six months from now for the
manufacturing plant. The current spot rate is €0.8573/$, the three
month forward rate is €0.8617/$ and the...
Gem Limited commences operations on 1 January 2019. During 2019 Gem Limited explores three areas and...
Gem Limited commences operations on 1 January 2019. During 2019
Gem Limited explores three areas and incurs the following costs:
Exploration and Evaluation expenditure ($) Desirable 25,000,000
Undesirable 20,000,000 Neutral 28,000,000 In 2020 oil is discovered
at Desirable Site. Undesirable Site is abandoned. Neutral Site has
not yet reach a stage that permits a reasonable assessment at the
existence or otherwise of economically recoverable reserves, and
active and significant operations in the area of interest are
continuing. In relation to...
Gem Limited commences operations on 1 January 2019. During 2019 Gem Limited explores three areas and...
Gem Limited commences operations on 1 January 2019. During 2019
Gem Limited explores three areas and incurs the following costs:
Exploration and Evaluation expenditure ($) Desirable 25,000,000
Undesirable 20,000,000 Neutral 28,000,000 In 2020 oil is discovered
at Desirable Site. Undesirable Site is abandoned. Neutral Site has
not yet reach a stage that permits a reasonable assessment at the
existence or otherwise of economically recoverable reserves, and
active and significant operations in the area of interest are
continuing. In relation to...
The? Sudbury, South? Carolina, plant of Shannon Sports Company has the following standards for its soccer...
The? Sudbury, South? Carolina, plant of Shannon Sports Company
has the following standards for its soccer ball? production:
Standards:
0.1 yard
Material (leather) per soccer ball
$21
Material price per yard
0.40 Hour
Direct labor hours per soccer ball
$11 per hour
Wage rate per direct labor hour
$12 per direct labor hour
Variable support cost rate
Actual results for October:
Used 13500 yards of raw material, purchased for $280,530.00.
Paid for 8,200 direct labor hours at $11.30 per hour....
Fireflies Limited began retail operations on 1/1/2010. On that date, it issued 10,000 shares of $1...
Fireflies Limited began retail operations on 1/1/2010. On that
date, it issued 10,000 shares of $1 par value common stock for
$50,000. On 1/1/2010, Fireflies also borrowed $20,000 from a local
bank. The loan will be due in three years, with 8% interest rate.
Fireflies pays interests every quarter. On 1/31, Fireflies used
$36,000 of the proceeds to rent a store, paying in advance for the
next one year. Fireflies also purchased $12,000 of merchandise on
credit, agreeing to pay...
BBTalk Company Limited sells tiles and other decoration products. Data of the store's operations are as...
BBTalk Company Limited sells tiles and other decoration
products. Data of the store's operations are as follow:
• Sales are budgeted at $340,000 for November 2019, $320,000 for
December 2019, and $330,000 for January 2020.
• Collections are expected to be 85% in the month of sale, 14%
in the month following the sale, and 1% uncollectible will be
recorded as bad debt expense.
• The cost of goods sold is 60% of sales.
•The company purchases 78% of its...
ADVERTISEMENT
ADVERTISEMENT
Latest Questions
- Paymaster Enterprises has arranged to finance its seasonal working-capital needs with a short-term bank loan. The...
- TOWS matrix of WOW MOMO
- Write an anecdotal lead with a person focus from the following information; include a nut graph....
- Step 1 Picture yourself as a Senior Product Manager in your favorite industry. This could be...
- Gauss Jordan elimination using python for a 2d list (3x3) without using any library. Thanks
- What are some of the greatest barriers preventing our schools from meeting the educational goals for...
- What aspect of the materials used in nanotechnology differentiates it from the nanoscale devices that the...
ADVERTISEMENT