1
xlsx
School
Florida International University *
*We aren’t endorsed by this school
Course
1
Subject
Accounting
Date
Feb 20, 2024
Type
xlsx
Pages
7
Uploaded by DukeFireWolf26
cost
190000
rate
7%
tax
25%
Afer tax cost of capital
5.25%
1.0525
Year
Cost
Depreciation
tax rate
Pv factor
A
B
A*B
1
190000
0.3333
63327
25%
15831.75 0.95011876
2
190000
0.4445
84455
25%
21113.75 0.90272567
3
190000
0.1481
28139
25%
7034.75
0.8576966
4
190000
0.0741
14079
25%
3519.75 0.81491363
Cost ofborrowing
146996.06
Cost of Borrowing
Comey Products has decided to acquire some new equipment having a $190,000 purchase price. T
equipment will last 4 years and is in the MACRS 3-year class. (The depreciation rates for Year 1 thr
are equal to 0.3333, 0.4445, 0.1481, and 0.0741.) The firm can borrow at a 7% rate and pays a 25%
plus-state tax rate. Comey is considering leasing the property but wishes to know the cost of borro
should use when comparing purchasing to leasing and has hired you to answer this question. Wha
correct answer to Comey’s question? (Hint: Use the shortcut method to find the after-tax cost of t
payments.) Do not round intermediate calculations. Round your answer to the nearest dollar.
Depreciatin rate
Depreciation tax benefit
15042.0428
19059.9241
6033.68113
2868.29225
43003.9402
The rough Year 4 % federal-
owing that it at is the he loan PV os dep on tax benefit
$
?
$
?
Lease versus Buy
Big Sky Mining Company must install $1.5 million of new machinery in its Nevada mine. It c
can lease the machinery. Assume that the following facts apply:
1. The machinery falls into the MACRS 3-year class. (The depreciation rates for Year 1 thr
0.0741.)
2. Under either the lease or the purchase, Big Sky must pay for insurance, property taxes
3. The firm's tax rate is 25%.
4. The loan would have an interest rate of 12%. It would be nonamortizing, with only inte
principal repaid at Year 4.
5. The lease terms call for $390,000 payments at the end of each of the next 4 years.
6. Big Sky Mining has no use for the machine beyond the expiration of the lease, and the
end of the 4th year.
What is the cost of owning? Enter your answer as a positive value. Do not round interme
example, 5 million should be entered as 5,000,000. Round your answer to the nearest do
What is the cost of leasing? Enter your answer as a positive value. Do not round interme
example, 5 million should be entered as 5,000,000. Round your answer to the nearest do
What is the NAL of the lease? Do not round intermediate calculations. Write out your an
as 5,000,000. Round your answer to the nearest dollar.
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
$
?
Purchase price
1,500,000.00 Tax rate
25%
After tax rate
75.00%
interest loan
12% compute hand
after tax cost of debt
9%
1.09
Residual value
$ 250,000.00 Lase term call
$ 390,000.00 LEASING
0
1
Lease paymemt
$ (390,000.00)
Less: Tax at 25%
$ (97,500.00)
Cash flows
$ (292,500.00)
PV of lesing
($947,618.06)
OWNING
0
1
0.3333
Principal payment
Interest
(180,000.00)
Less: Depreciation expense
499,950.00 Earning before tax
(679,950.00)
Less: Tax at 25%
(169,987.50)
Net income
(509,962.50)
add: Depreciation expense
499,950.00 add: after tac salvae value
Cash Flows
(10,012.50)
PV of purchasing at 9%
($1,049,634.80)
NAL
$102,016.74
can obtain a bank loan for 100% of the purchase price, or it rough Year 4 are equal to 0.3333, 0.4445, 0.1481, and s, and maintenance.
erest paid at the end of each year for four years and the e machine has an estimated residual value of $250,000 at the ediate calculations. Write out your answer completely. For ollar.
ediate calculations. Write out your answer completely. For ollar.
nswer completely. For example, 5 million should be entered
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
compute hand
0.09
2
3
4
$ (390,000.00) $ (390,000.00)
$ (390,000.00)
$ (97,500.00)
$ (97,500.00) $ (97,500.00)
$ (292,500.00) $ (292,500.00)
$ (292,500.00)
2
3
4
0.4445
0.1481
0.0741
(1,500,000.00)
(180,000.00) (180,000.00) (180,000.00)
666,750.00 222,150.00 111,150.00 (846,750.00) (402,150.00) (291,150.00)
(211,687.50) (100,537.50) (72,787.50)
(635,062.50) (301,612.50) (218,362.50)
666,750.00 222,150.00 111,150.00 $ 187,500.00 31,687.50 (79,462.50) (1,419,712.50)
en positivo
Related Documents
Related Questions
Effective income tax rate
After-tax MARR
EOY
BTCF
0$ (95,000.00) -
1$
37,000.00 $
2 $
3 $
4 $
Depreciation Taxable Income Income Taxes ATCF
37,000.00 $
37,000.00 $
50%
12%
23,750.00 $
23,750.00 $
37,000.00 $ 23,750.00 $
$ (95,000.00)
23,750.00 $ 13,250.00 -$6,625.00 $ 30,375.00
13,250.00
-$6,625.00 $ 30,375.00
13,250.00
-$6,625.00 $
30,375.00
13,250.00
-$6,625.00 $ 30,375.00
For the given table, find the EVA in year 3 (please round the result to integer, e.g., if the result is $ 5,732.07, fill in 5732);
Should this project be invested based on the annual/present/future equivalent EVA (fill in "1" if the answer is "yes", otherwise fill in "0")?
arrow_forward
Taxable Income
$0-$50,000
Marginal Tax Rate
15%
$50,001 - $75,000
25%
$75,001 - $100,000
34%
$100,001 - $335,000
39%
$335,001-$10,000,000
34%
$10,000,001 - $15,000,000
35%
$15,000,001 - $18,333,333
38%
Over $18,333,333
35%
(Click on the icon in order to copy its contents into a spreadsheet.)
arrow_forward
Data table
Taxable Income
Marginal Tax Rate
$0-$50,000
15%
$50,001 - $75,000
25%
$75,001 - $100,000
34%
$100,001 - $335,000
39%
$335,001-$10,000,000
34%
$10,000,001 - $15,000,000
35%
$15,000,001 - $18,333,333 38%
Over $18,333,333
35%
(Click on the icon in order to copy its contents into a spreadsheet.)
arrow_forward
↑
(Corporate income tax) G. R. Edwin Inc had sales of $6.09 million during the past year. The cost of goods sold amounted to $2.5 million Operating expenses totaled
$2.54 million, and interest expense was $25,000. Use the corporate tax rates shown in the popup window to determine the firm's tax liability What are the firm's
average and marginal tax rates?
The firm's tax liability for the year is $ (Round to the nearest dollar)
arrow_forward
Buy Van
Lease Van
Buy/Lease Term
Depreciation
Term
Tax Rate
Interest Rate
After-Tax
Interest Rate
Buy
Year
Payment
Depreciation
Tax Deduction
Net Payment
Lease
Year
Payment
Tax Deduction
Net Payment
$31,648
$14,065 Per Year
3 Years
1
10 Years
21.0%
7.8%
6.2%
$12,236
$3,165
$665
$11,571
1
$14,065
$2,954
$11,111
2
$12,236
$3,165
$665
$11,571
2
$14,065
$2,954
$11,111
3
$12,236
$3,165
$665
$11,571
3
$14,065
$2,954
$11,111
arrow_forward
Initial Equipment Cost, $M
12.0
Depreciation, %
75.00%
Current Equipment Value, $M
4.0
Marginal Tax Rate
40.00%
Current Book Value, $M
?
Profit/Loss On Sale, $M
?
Taxes Owed (Saved) On Sale, $M
?
After-Tax Net Salvage Value, $M
?
arrow_forward
prn.2
arrow_forward
Taxable Income
$0-$50,000
Marginal Tax Rate
15%
25%
¥34%
39%
34%
$10,000,001-$15,000,000 35%
$15,000,001-$18,333,333
38%
Over $18,333,333
35%
$50,001-$75,000
$75,001-$100,000
$100,001 - $335,000
$335,001 - $10,000,000
arrow_forward
Calculating Taxable Income
Taxable income
Rate
$0 — $9,525
10.0%
$9,526 — $38,700
12.0%
$38,701 — $82,500
22.0%
$82,501 — $157,500
24.0%
$157,501 — $200,000
32.0%
$200,001 — $500,000
35.0%
$500,001 or more
37%
Using the previous tax table, compute the tax liability for the individual in the scenario presented, rounding the liability to the nearest dollar. In addition, use the dropdown lists to identify the marginal tax rate and average tax rate for the individual in the scenario.
Shen’s Tax Scenario
Shen is a young professional with taxable income of $116,500 as an advertising account executive.
What is Shen’s total tax liability?
(Note: Round your answer to the nearest cent, if necessary.)
What is Shen’s top marginal tax rate?
What is Shen's average tax rate?
arrow_forward
H1.
Account
I would need to calculate with the following information provided. This is all that was provided to me.
COGS: 68% - SGA: 13% - R&D: 2% - Depreciation, Interest expenses are fixed as stated. Tax rate is 19%
***Please do provide a step by step calculations and explanation***
arrow_forward
NCF practice
a) What is the ncf from the sale of this asset - purchased for $250,000, 7-year property, sold at end of year 6 for $50,000, tax rate = 21%?
basis = MACRS depreciation (as decimal) * sale price
step 1: sales price - basis = gain/loss
step 2: gain * loss tax rate = tax
step 3: sales price - tax = ncf
arrow_forward
Simple Accounting - Property Tax.
Market Value
Tax Policy
Rate
Property Tax
$1,370,980.00
50.75%
4.39571
a. $3,058,413.48
O b. $29,680.17
O c. $30,584.13
d. $60,264.30
arrow_forward
Question 2
Full explain this question
arrow_forward
LO 2
4. Calculating OCF Consider the following income statement:
Sales
$537,200
Costs
346,800
Depreciation
94,500
EBIT
?
Taxes (21%)
?
Net income
Fill in the missing numbers and then caicrlate e F What is the depreci-
ation tax shield?
5. Calculating Depreciation A piece of new p
equipment
arrow_forward
Working need
arrow_forward
Question number 39
arrow_forward
$
O-
Taxable Income
50,000
50,001-
75,001-
Y 100,001-
75,000
100,000
335,000
335,001- 10,000,000
Tax Rate
15%
25
34
39
34
Bait and Tackle has taxable income of $411,562. How much do
a. $128,603.33
b. $134,611.27
c. $138,542.79
d. $139,931.08
e. $141,35674.82
tin
arrow_forward
1. Use the following information to answer the following questions: Taxable income Tax rate $ 0 – $ 50,000 15% $ 50,001 – $ 75,000 25% $ 75,001 – $100,000 34% $ 100,001 – $335,000 39% $ 335,001 – $10.000 million 34% $10,000,001 – $15.000 million 35% $15,000,001 – $18.333 million 38% $18,333,334 and above 35%
A. If a firm has taxable income of $16.2 million, its marginal tax rate is .
B. If a firm has taxable income of $16.2 million, its average tax rate is _____.
arrow_forward
(Corporate income tax) Sales for J. P. Hulett Inc. during the past year
amounted to $3.7 million. Gross profits totaled $1.04 million, and operating
and depreciation expenses were $494,000 and $352,000, respectively.
Dividend income for the year was $10,000, which was paid by a firm in
which Hulett owns 85 percent of the shares. Use the corporate tax rates
shown in the popup window, , to Comcute the corporation's tax liability.
What are the firm's average and marginal tax rates?
The firm's tax liability for the year is $. (Round to the nearest dollar.)
arrow_forward
Accenting Loss before tax
ADD
LESS
600100 Dep Expense
60010 ENTERTAINMENT
Total
Depr
11
Tax losss carry forwarding
100.00
500.00
200.00
(305,600.00)
600.00
200.00
(305,200.00)
20% (61,040.00)
arrow_forward
not use excel
arrow_forward
SEE MORE QUESTIONS
Recommended textbooks for you
Related Questions
- Effective income tax rate After-tax MARR EOY BTCF 0$ (95,000.00) - 1$ 37,000.00 $ 2 $ 3 $ 4 $ Depreciation Taxable Income Income Taxes ATCF 37,000.00 $ 37,000.00 $ 50% 12% 23,750.00 $ 23,750.00 $ 37,000.00 $ 23,750.00 $ $ (95,000.00) 23,750.00 $ 13,250.00 -$6,625.00 $ 30,375.00 13,250.00 -$6,625.00 $ 30,375.00 13,250.00 -$6,625.00 $ 30,375.00 13,250.00 -$6,625.00 $ 30,375.00 For the given table, find the EVA in year 3 (please round the result to integer, e.g., if the result is $ 5,732.07, fill in 5732); Should this project be invested based on the annual/present/future equivalent EVA (fill in "1" if the answer is "yes", otherwise fill in "0")?arrow_forwardTaxable Income $0-$50,000 Marginal Tax Rate 15% $50,001 - $75,000 25% $75,001 - $100,000 34% $100,001 - $335,000 39% $335,001-$10,000,000 34% $10,000,001 - $15,000,000 35% $15,000,001 - $18,333,333 38% Over $18,333,333 35% (Click on the icon in order to copy its contents into a spreadsheet.)arrow_forwardData table Taxable Income Marginal Tax Rate $0-$50,000 15% $50,001 - $75,000 25% $75,001 - $100,000 34% $100,001 - $335,000 39% $335,001-$10,000,000 34% $10,000,001 - $15,000,000 35% $15,000,001 - $18,333,333 38% Over $18,333,333 35% (Click on the icon in order to copy its contents into a spreadsheet.)arrow_forward
- ↑ (Corporate income tax) G. R. Edwin Inc had sales of $6.09 million during the past year. The cost of goods sold amounted to $2.5 million Operating expenses totaled $2.54 million, and interest expense was $25,000. Use the corporate tax rates shown in the popup window to determine the firm's tax liability What are the firm's average and marginal tax rates? The firm's tax liability for the year is $ (Round to the nearest dollar)arrow_forwardBuy Van Lease Van Buy/Lease Term Depreciation Term Tax Rate Interest Rate After-Tax Interest Rate Buy Year Payment Depreciation Tax Deduction Net Payment Lease Year Payment Tax Deduction Net Payment $31,648 $14,065 Per Year 3 Years 1 10 Years 21.0% 7.8% 6.2% $12,236 $3,165 $665 $11,571 1 $14,065 $2,954 $11,111 2 $12,236 $3,165 $665 $11,571 2 $14,065 $2,954 $11,111 3 $12,236 $3,165 $665 $11,571 3 $14,065 $2,954 $11,111arrow_forwardInitial Equipment Cost, $M 12.0 Depreciation, % 75.00% Current Equipment Value, $M 4.0 Marginal Tax Rate 40.00% Current Book Value, $M ? Profit/Loss On Sale, $M ? Taxes Owed (Saved) On Sale, $M ? After-Tax Net Salvage Value, $M ?arrow_forward
- prn.2arrow_forwardTaxable Income $0-$50,000 Marginal Tax Rate 15% 25% ¥34% 39% 34% $10,000,001-$15,000,000 35% $15,000,001-$18,333,333 38% Over $18,333,333 35% $50,001-$75,000 $75,001-$100,000 $100,001 - $335,000 $335,001 - $10,000,000arrow_forwardCalculating Taxable Income Taxable income Rate $0 — $9,525 10.0% $9,526 — $38,700 12.0% $38,701 — $82,500 22.0% $82,501 — $157,500 24.0% $157,501 — $200,000 32.0% $200,001 — $500,000 35.0% $500,001 or more 37% Using the previous tax table, compute the tax liability for the individual in the scenario presented, rounding the liability to the nearest dollar. In addition, use the dropdown lists to identify the marginal tax rate and average tax rate for the individual in the scenario. Shen’s Tax Scenario Shen is a young professional with taxable income of $116,500 as an advertising account executive. What is Shen’s total tax liability? (Note: Round your answer to the nearest cent, if necessary.) What is Shen’s top marginal tax rate? What is Shen's average tax rate?arrow_forward
- H1. Account I would need to calculate with the following information provided. This is all that was provided to me. COGS: 68% - SGA: 13% - R&D: 2% - Depreciation, Interest expenses are fixed as stated. Tax rate is 19% ***Please do provide a step by step calculations and explanation***arrow_forwardNCF practice a) What is the ncf from the sale of this asset - purchased for $250,000, 7-year property, sold at end of year 6 for $50,000, tax rate = 21%? basis = MACRS depreciation (as decimal) * sale price step 1: sales price - basis = gain/loss step 2: gain * loss tax rate = tax step 3: sales price - tax = ncfarrow_forwardSimple Accounting - Property Tax. Market Value Tax Policy Rate Property Tax $1,370,980.00 50.75% 4.39571 a. $3,058,413.48 O b. $29,680.17 O c. $30,584.13 d. $60,264.30arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you