1
.xlsx
keyboard_arrow_up
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
Related Questions
ements
What is the total Wealth Accumulation of the following investment assuming the
available after tax reinvestment rate is 5%?
IRR 10.70%
O $4,690,000
O $4,821,078
O $4,848,844
$4,905.989
n
0 $
1 S
2
$
3 $
AS
5 $
Investment
$
(3,000,000)
240,000
250,000
260,000
266,000
3,674,000
arrow_forward
Fill in Xs'
arrow_forward
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
j.
calculate the EBIT:
calculate the net income:
calculate the OCF:
what is the depreciation tax shield:
arrow_forward
Company C had the following investment. Help them determine the financial statement implications of the investment.
Tax rate
Estimated tax payment
21%
21,000
Investment cost and ending fair values for 20X1 and 20X2:
20X1
20X2
Cost
Fair value
Total gain
100,000
110,000
10,000
100,000
134,000
34,000
20X1 income statement information:
Sales
Expenses
1,670,200
1,536,600
Assuming the investement is short-term, what is the deferred taxes payable on the 20X1 balance sheet?
arrow_forward
a. Fill in the following table assuming MACRS depreciation rates (10 points)
Year
0
1
2
3
4
5
6
Pretax
income
MACRS
Taxable
Depreciation income
Tax owed
After tax
income
Inflation
adjustment
factor
Real after
tax income
b. If MARR = 18%, should you purchase this system based on your real after-tax
income? Why or why not? (5 points)
arrow_forward
Year 1
Year 2
Year 3
Premiums
120
110
100
Investment Income
0
10
20
Claims
55
55
100
Expenses
75
5
5
Solvency Reserve
100
125
0
Benefit Reserve
50
60
0
DAC
70
40
0
Required Capital
5
10
0
Assume reserves, DAC, and required capital are EOY amounts
No taxes
Required capital investment income rate = 0%
Calculate the ROE (as percentage) at the end of year 1.
arrow_forward
F Question Viewer
Cost of Goods Sold
- Depreciation
= EBIT
- Taxes (20%).
= Unlevered net income
+ Depreciation
- Additions to Net Working Capital
- Capital Expenditures
= Free Cash Flow
Year 0
A. 17%
B. 30%
C. 25%
D. 22%
_-400000_
Year 1
424897.541
- 165000
- 85000
174897.541
- 34979.508
139918.033
85000
- 20000
Year 2
424897.541
- 165000
- 85000
174897.541
- 34979.508
139918.033
85000
- 20000
Year 3
424897.541
- 165000
- 85000
174897.541
- 34979.508
139918.033
85000
- 20000
204918.033
204918.033
204918.033
Visby Rides, a livery car company, is considering buying some new luxury cars. After extensive research, they come up with the above estimates of free cash flow from this project. By how much could the
discount rate rise before the net present value (NPV) of this project is zero, given that it is currently 8%?
arrow_forward
Georgetown Berbice
Income before tax. 20,000 75,000Required rate of return. 12% 12%Investment 100,000 500,000
Calculate the residual income for Georgetown
a. 1,500
b. 150,000
c. 15,000
d. 8,000
arrow_forward
Consider the following income statement:
Sales $ 383,208Costs 249,312Depreciation 56,700Taxes 25%
Calculate the EBIT.
Calculate the net income.
Calculate the OCF.
What is the depreciation tax shield? Pls fast
arrow_forward
9. $177,400
60
$106,440
10. $2,330,000
100
11. $342,900
77
$264,033
Level 2
Chapter 18- Section II - Exercise 9, 10, 11
Calculate the assessed value and the property tax due on the following properties:
Note: Refer to these problems in the text for input data.
Fair Market
Value
Assessment
Rate
Assessed
Value
EXCEL2
EXCEL2
EXCEL2
$2.13 per $100
13.22 mills
5.3%
Property tax rate (enter only in appropriate column)
%
per 100
per 1000
mills
$2,267.17
$13,993.75
Property Tax
Due
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
N1
arrow_forward
Question 13
Refer to the following financial information of Scholz Company:
NOPAT
8,250,000.00
EBITDA
17,725,000.00
Net Income
5,050,000.00
Capital
Expenditures
6,820,000.00
After tax capital
costs
6,280,000.00
Tax rate
40%
Calculate the Company's depreciation and amortization expense
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
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
Years
Revenue
Cash Expense
Book
Depreciation
Book Income
Pre-Tax
Book Tax at
32%
After Tax Book
Income
Financial
Measures
Profit Margin
%
Net Assets
ROA %
Cashflow
Revenue
Cash Expense
Tax
Depreciation
Pretax Income
Tax at 32%
After Tax
Income
After Tax
Cashflow
Cumulative
Cashflow
Payback
Period
Present Worth
10
PW12
PW15
IRR
PV Index(15)
Facility Cost
Income Tax
Rate
0
C. -9.5
d. -12.4
$ 100,000.00
2.2 Years
91740.92679
0.395702526
1
0.684350818
$ 100,000.00
32%
$30,000.00
$100,000.00 $120,000.00 $140,000.00 $150,000.00 $150,000.00
$50,000.00 $60,000.00 $70,000.00 $75,000.00 $75,000.00
2
$20,000.00 $20,000.00 $20,000.00 $20,000.00 $20,000.00
$0.20
$20,400.00 $27,200.00
$0.26
$9,600.00 $12,800.00 $16,000.00 $17,600.00 $17,600.00
$20,400.00
($100,000.00) $40,400.00 $51,040.00
($100,000.00) -$59,600.00 -$8,560.00
$40,000.00 $50,000.00 $55,000.00 $55,000.00
$0.23
3
$0.45
$36,727.27
$80,000.00 $60,000.00 $40,000.00 $20,000.00
$0.85
$1.87
4
$19,040.00
5
$34,000.00 $37,400.00
$0.24…
arrow_forward
Find FCFFRevenue =247
cost =12
depreciation = 13
tax rate = 25%
Capex =123
change in working capital = -5
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
Old MathJax webview
please due by hand
1. 878252. 30480
arrow_forward
Keith Urban Bookstores is considering a major expansion of its business. The details of
the proposed expansion project are summarized below:
The company will have to purchase $600,000 in equipment at t = 0. This is the
depreciable cost.
The project has an economic life of four years.
The cost can be depreciated on a MACRS 3-year basis, which implies the
following depreciation schedule:
MACRS
Depreciation
Rates
Year
1
0.33
0.45
0.15
0.07
2
3
4
At t = 0, the project requires that inventories increase by $40,000 and accounts
payable increase by $5,000. The change in net operating working capital is
expected to be fully recovered at t = 4. (Hint: NWC = CA-CL)
The project's salvage value at the end of four years is expected to be $0.
The company forecasts that the project will generate $700,000 in sales the first
two years (t = 1 and 2) and $400,000 in sales during the last two years (t = 3 and
4).
Each year the project's operating costs excluding depreciation are expected to
be 55% of…
arrow_forward
Pertinent information for two alternatives A and B is shown below. If
i=10% / year and the effective income tax rate is 35%, answer the
following true/false questions.
Alt. A
Alt.B
Basis, $
Gross Income (GI), $
Operating Expense
(OE), $
Salvage Value, $
MARCS Depreciation
Method
O True
150,000
100,000
30,000
O False
225,,000
100,000
10,000
The depreciation charge at the end of year 7 for Alt. A is zero.
15,000
22,500
ADS-6: Years Recovery GDS: 5-Years Recovery
Period
Period
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
13
arrow_forward
Q9.
Pertinent information for two alternatives A and B is shown below. If i=10%/year and the effective income tax rate is 35%, answer the following true/false questions.
Alt. A
Alt.B
Basis, $
150,000
225,,000
Gross Income (GI), $
100,000
100,000
Operating Expense (OE), $
30,000
10,000
Salvage Value, $
15,000
22,500
MARCS Depreciation Method
ADS-6: Years Recovery Period
GDS: 5-Years Recovery Period
The TI (taxable income) of Alt. B at the end of year 1 is $45,000.
Group of answer choices
True
False
arrow_forward
Consider the following income statement:
$ 529,192
344,288
78,300
23%
Sales
Costs
Depreciation
Taxes
Calculate the EBIT.
EBIT
arrow_forward
SEE MORE QUESTIONS
Recommended textbooks for you
Related Questions
- ements What is the total Wealth Accumulation of the following investment assuming the available after tax reinvestment rate is 5%? IRR 10.70% O $4,690,000 O $4,821,078 O $4,848,844 $4,905.989 n 0 $ 1 S 2 $ 3 $ AS 5 $ Investment $ (3,000,000) 240,000 250,000 260,000 266,000 3,674,000arrow_forwardFill in Xs'arrow_forwardEffective 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
- j. calculate the EBIT: calculate the net income: calculate the OCF: what is the depreciation tax shield:arrow_forwardCompany C had the following investment. Help them determine the financial statement implications of the investment. Tax rate Estimated tax payment 21% 21,000 Investment cost and ending fair values for 20X1 and 20X2: 20X1 20X2 Cost Fair value Total gain 100,000 110,000 10,000 100,000 134,000 34,000 20X1 income statement information: Sales Expenses 1,670,200 1,536,600 Assuming the investement is short-term, what is the deferred taxes payable on the 20X1 balance sheet?arrow_forwarda. Fill in the following table assuming MACRS depreciation rates (10 points) Year 0 1 2 3 4 5 6 Pretax income MACRS Taxable Depreciation income Tax owed After tax income Inflation adjustment factor Real after tax income b. If MARR = 18%, should you purchase this system based on your real after-tax income? Why or why not? (5 points)arrow_forward
- Year 1 Year 2 Year 3 Premiums 120 110 100 Investment Income 0 10 20 Claims 55 55 100 Expenses 75 5 5 Solvency Reserve 100 125 0 Benefit Reserve 50 60 0 DAC 70 40 0 Required Capital 5 10 0 Assume reserves, DAC, and required capital are EOY amounts No taxes Required capital investment income rate = 0% Calculate the ROE (as percentage) at the end of year 1.arrow_forwardF Question Viewer Cost of Goods Sold - Depreciation = EBIT - Taxes (20%). = Unlevered net income + Depreciation - Additions to Net Working Capital - Capital Expenditures = Free Cash Flow Year 0 A. 17% B. 30% C. 25% D. 22% _-400000_ Year 1 424897.541 - 165000 - 85000 174897.541 - 34979.508 139918.033 85000 - 20000 Year 2 424897.541 - 165000 - 85000 174897.541 - 34979.508 139918.033 85000 - 20000 Year 3 424897.541 - 165000 - 85000 174897.541 - 34979.508 139918.033 85000 - 20000 204918.033 204918.033 204918.033 Visby Rides, a livery car company, is considering buying some new luxury cars. After extensive research, they come up with the above estimates of free cash flow from this project. By how much could the discount rate rise before the net present value (NPV) of this project is zero, given that it is currently 8%?arrow_forwardGeorgetown Berbice Income before tax. 20,000 75,000Required rate of return. 12% 12%Investment 100,000 500,000 Calculate the residual income for Georgetown a. 1,500 b. 150,000 c. 15,000 d. 8,000arrow_forward
- Consider the following income statement: Sales $ 383,208Costs 249,312Depreciation 56,700Taxes 25% Calculate the EBIT. Calculate the net income. Calculate the OCF. What is the depreciation tax shield? Pls fastarrow_forward9. $177,400 60 $106,440 10. $2,330,000 100 11. $342,900 77 $264,033 Level 2 Chapter 18- Section II - Exercise 9, 10, 11 Calculate the assessed value and the property tax due on the following properties: Note: Refer to these problems in the text for input data. Fair Market Value Assessment Rate Assessed Value EXCEL2 EXCEL2 EXCEL2 $2.13 per $100 13.22 mills 5.3% Property tax rate (enter only in appropriate column) % per 100 per 1000 mills $2,267.17 $13,993.75 Property Tax Duearrow_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_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you