FINANCIAL ACCOUNTING
FINANCIAL ACCOUNTING
10th Edition
ISBN: 9781259964947
Author: Libby
Publisher: MCG
Bartleby Related Questions Icon

Related questions

Question
Domco manufactures small gasoline engines for the home gardening
power tool industry. Their production line for 8hp engines is very labor
intensive. The company has an opportunity to produce 8hp engines for all
of Sears CraftsmanⓇ small garden power products that require an 8
horsepower rating.
In order to increase production Domco will have to install a new automated
production line. The engineering estimate for the cost of the new
production facility is $12,500,000. If the new production line is installed, it
is estimated that Domco will save $1,000,000 per year in direct labor cost.
All other variable cost per unit will remain the same.
The Sear's contract is for 5 years and will be renewed at the end of that
time if both parties agree. The Sear's contract will increase sales in 8hp
engines by 30% per year. The current sales price per engine is $48 with a
total volume of 800,000 units sold per year.
Variable cost amount to 32% of the sales price per engine exclusive of
direct labor cost. If the new production line is installed the old production
line will be dismantled and scraped (sold) for $45,000 and will have a
realize loss for tax purposes of $280,000. If the old line were not sold
today it could be sold for $25,000 at the end of its life in five years.
The old production line was put into servers 10 years ago at a cost of
$975,000 and was being depreciate over a 15 year life using straight line
depreciation without taking salvage value into consideration. The new
production line will be depreciated over 5 years using straight line
depreciation without taking salvage value into consideration.
If Domco goes ahead with the project, the company will use funds
currently available to pay for the new line. The new production line can be
scraped (sold) for $175,000 five years from today. Since no salvage value
has been use in the depreciation calculation for the equipment the entire
amount a taxable gain,
Required: Use the provided Excel spreadsheet to calculate the after tax
cash flows assuming a 48% marginal tax bracket for Domco.
Do not total the cash flows and do not calculate the present
values of the after-tax cash flows
expand button
Transcribed Image Text:Domco manufactures small gasoline engines for the home gardening power tool industry. Their production line for 8hp engines is very labor intensive. The company has an opportunity to produce 8hp engines for all of Sears CraftsmanⓇ small garden power products that require an 8 horsepower rating. In order to increase production Domco will have to install a new automated production line. The engineering estimate for the cost of the new production facility is $12,500,000. If the new production line is installed, it is estimated that Domco will save $1,000,000 per year in direct labor cost. All other variable cost per unit will remain the same. The Sear's contract is for 5 years and will be renewed at the end of that time if both parties agree. The Sear's contract will increase sales in 8hp engines by 30% per year. The current sales price per engine is $48 with a total volume of 800,000 units sold per year. Variable cost amount to 32% of the sales price per engine exclusive of direct labor cost. If the new production line is installed the old production line will be dismantled and scraped (sold) for $45,000 and will have a realize loss for tax purposes of $280,000. If the old line were not sold today it could be sold for $25,000 at the end of its life in five years. The old production line was put into servers 10 years ago at a cost of $975,000 and was being depreciate over a 15 year life using straight line depreciation without taking salvage value into consideration. The new production line will be depreciated over 5 years using straight line depreciation without taking salvage value into consideration. If Domco goes ahead with the project, the company will use funds currently available to pay for the new line. The new production line can be scraped (sold) for $175,000 five years from today. Since no salvage value has been use in the depreciation calculation for the equipment the entire amount a taxable gain, Required: Use the provided Excel spreadsheet to calculate the after tax cash flows assuming a 48% marginal tax bracket for Domco. Do not total the cash flows and do not calculate the present values of the after-tax cash flows
A
B
C
D
E
F
G
H
1 PROB.2
2
Tax rate
48%
3
4 CASH IN FLOWS
CFBT
CFAT
TODAY
YR1
YR2
YR3
YR4
YR5
5
3
6
7
8
3
9
10
11
3
3
12
13
14 CASH OUT FLOWS
15
16
17
18
19
21
3
$
45,000
22 CALCULATION OF GAIN OR LOSS ON SALE OF OLD EQUIP
CASH REC WHEN SOLD:
LESS BOOKVALUE OF OLD EQUIP. S 325,000
975,000-((975000/15)*10)
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
40
41
42
43
45
47
48
LOSS
$
(280,000)
3
3
3
3
K
M
N
+
R
S
LIST OF CASH FLOWS AND THEIR AFTER-TAX EFFECT
ITEM OF CASH FLOW
AFTER TAX EFFECT
A. CASH IN FLOWS-ACTUAL CASH:
1 Increase to a revenueX
(1-TR)
2 Decrease to an experX
(1-TR)
3 Sale of an Asset:
X
4 Avoid an cX
1
5 Avoid an cx
(1-TR)
6 Decrease X
1
B. CASH IN FLOWS-TAX GENERATED:
1 Increase in depreciat X
(TR)
2 Loss on sale of Assel X
(TR)
3 Investmen
1
4 Tax saved from gain on future sale of an
asset that X
(TR)
C. CASH OUT FLOWS-ACTUAL CASH:
1 Investment (cash from non intr
bearing source):
X
1
2 Repaymer X
1
3 Interest on debt:
X
(1-TR)
4 Increase in expenses X
(1-TR)
5 Loss of sale of asset: X
6,
Increase ir X
D. CASH OUT FLOWS-TAX GENERATED:
1 Tax on gai X
(TR)
2 Loss of de (TR)
3 Loss of de X
(TR)
expand button
Transcribed Image Text:A B C D E F G H 1 PROB.2 2 Tax rate 48% 3 4 CASH IN FLOWS CFBT CFAT TODAY YR1 YR2 YR3 YR4 YR5 5 3 6 7 8 3 9 10 11 3 3 12 13 14 CASH OUT FLOWS 15 16 17 18 19 21 3 $ 45,000 22 CALCULATION OF GAIN OR LOSS ON SALE OF OLD EQUIP CASH REC WHEN SOLD: LESS BOOKVALUE OF OLD EQUIP. S 325,000 975,000-((975000/15)*10) 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 40 41 42 43 45 47 48 LOSS $ (280,000) 3 3 3 3 K M N + R S LIST OF CASH FLOWS AND THEIR AFTER-TAX EFFECT ITEM OF CASH FLOW AFTER TAX EFFECT A. CASH IN FLOWS-ACTUAL CASH: 1 Increase to a revenueX (1-TR) 2 Decrease to an experX (1-TR) 3 Sale of an Asset: X 4 Avoid an cX 1 5 Avoid an cx (1-TR) 6 Decrease X 1 B. CASH IN FLOWS-TAX GENERATED: 1 Increase in depreciat X (TR) 2 Loss on sale of Assel X (TR) 3 Investmen 1 4 Tax saved from gain on future sale of an asset that X (TR) C. CASH OUT FLOWS-ACTUAL CASH: 1 Investment (cash from non intr bearing source): X 1 2 Repaymer X 1 3 Interest on debt: X (1-TR) 4 Increase in expenses X (1-TR) 5 Loss of sale of asset: X 6, Increase ir X D. CASH OUT FLOWS-TAX GENERATED: 1 Tax on gai X (TR) 2 Loss of de (TR) 3 Loss of de X (TR)
Expert Solution
Check Mark
Knowledge Booster
Background pattern image
Similar questions
SEE MORE QUESTIONS
Recommended textbooks for you
Text book image
FINANCIAL ACCOUNTING
Accounting
ISBN:9781259964947
Author:Libby
Publisher:MCG
Text book image
Accounting
Accounting
ISBN:9781337272094
Author:WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:Cengage Learning,
Text book image
Accounting Information Systems
Accounting
ISBN:9781337619202
Author:Hall, James A.
Publisher:Cengage Learning,
Text book image
Horngren's Cost Accounting: A Managerial Emphasis...
Accounting
ISBN:9780134475585
Author:Srikant M. Datar, Madhav V. Rajan
Publisher:PEARSON
Text book image
Intermediate Accounting
Accounting
ISBN:9781259722660
Author:J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:McGraw-Hill Education
Text book image
Financial and Managerial Accounting
Accounting
ISBN:9781259726705
Author:John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:McGraw-Hill Education