Question
In: Finance
7. Please solve in Excel and round to 3 decimal places: YEAR DEPRECIATION FACTOR 1 33.33%...
7. Please solve in Excel and round to 3 decimal places:
| YEAR | DEPRECIATION FACTOR |
| 1 | 33.33% |
| 2 | 44.45% |
| 3 | 14.81% |
| 4 | 7.41% |
The original cost of the new production line is estimated at $3 million and falls into 3 year MACRS. This is a 3 year project. Expected annual sales are $2,950,000 per year, with associated annual costs of $1,250,000. The project requires a net working capital of $375,000. They can usually sell their production lines for 40% of their original costs at the end of the project. The tax rate is 32% and the relevant interest rate is 15%.
a. What is the relevant cash flow for year 0?
b. What is the OCF for year 1 (please solve in Excel)?
c. What is the after tax salvage value of the production line (please solve in Excel)?
Solutions
Expert Solution
a: Cash flow in year 0 = Cost of machine +net working capital
= -3000000-375000
=-3375000
b: OCF in year 1= (Sales-cost)*(1-Tax) +tax*depreciation
= (2950000-1250000)*(1-32%)+ 32%*33.33%*3000000
=1475968
c: After tax salvage = Salvage*(1-tax)
=40%*3000000*(1-32%)
= 816000
jeff jeffy answered 6 months agoRelated Solutions
11. Please solve in Excel and round to 3 decimal places: YEAR DEPRECIATION FACTOR 1 33.33%...
11. Please solve in Excel and round to 3 decimal
places:
YEAR
DEPRECIATION FACTOR
1
33.33%
2
44.45%
3
14.81%
4
7.41%
The original cost of the new production line is estimated at $3
million and falls into 3 year MACRS. This is a 3 year project.
Expected annual sales are $2,950,000 per year, with associated
annual costs of $1,250,000. The project requires a net working
capital of $375,000. They can usually sell their production lines
for 40% of their...
21. Please solve in Excel; round to 3 decimal places. Company A has a single bond...
21. Please solve in Excel; round to 3 decimal
places.
Company A has a single bond issue American bond (American bonds
pay out interest semiannually); the bond has a 6.5% coupon, 9 years
to maturity, trades at $1245 per $1000 face value with a face value
of $600,000. The cost of equity of 11%, cost of preferred stock of
8%. The company has 120,000 shares of common stock outstanding
selling at $30 per share. It has 50,000 shares of preferred...
Solve ΔABC. (Round your answers to two decimal places. If there is no solution, enter NO...
Solve ΔABC. (Round your answers to two decimal places.
If there is no solution, enter NO SOLUTION.)
α = 47.16°, a =
5.04, b = 6.17
smaller c:
c =
β =
°
γ =
larger c:
c =
β =
°
γ =
MACRS Depreciation Allowances Property Class Year 3-Year 5-Year 7-Year 1 33.33% 20.00% 14.29% 2 44.45 32.00 ...
MACRS Depreciation Allowances
Property Class
Year
3-Year
5-Year
7-Year
1
33.33%
20.00%
14.29%
2
44.45
32.00
24.49
3
14.81
19.20
17.49
4
7.41
11.52
12.49
5
11.52
8.93
6
5.76
8.92
7
8.93
8
4.46
Use the following information to answer the next three
questions:
Some new equipment under consideration will cost $2,600,000 and
will be used for 4 years. Net working capital will experience a one
time increase of $559,000 if the equipment is purchased. The
equipment is expected...
MACRS Depreciation Allowances Property Class Year 3-Year 5-Year 7-Year 1 33.33% 20.00% 14.29% 2 44.45 32.00 ...
MACRS Depreciation Allowances
Property Class
Year
3-Year
5-Year
7-Year
1
33.33%
20.00%
14.29%
2
44.45
32.00
24.49
3
14.81
19.20
17.49
4
7.41
11.52
12.49
5
11.52
8.93
6
5.76
8.92
7
8.93
8
4.46
Use the following information to answer the next three
questions:
Some new equipment under consideration will cost $2,600,000 and
will be used for 4 years. Net working capital will experience a one
time increase of $559,000 if the equipment is purchased. The
equipment is expected...
Express numerical answers in decimal form and round to 3 decimal places as needed (unless otherwise...
Express numerical answers in decimal form and round to 3 decimal
places as needed (unless otherwise stated).
[8] 1) The homework scores (out of 10 points) for a sample of 9
students are listed:
1, 7, 7, 8, 9, 9, 10, 10, 10
a) Find the five number summary (whole numbers, in order).
Five number summary: , , , ,
Please show all work for full credit! When performing calculations, round numbers to 3 decimal places...
Please show all work for full credit!
When performing calculations, round numbers to 3 decimal
places
The California Condor (Gymnogyps californianus) is a critically
endangered species. In 1991, 48 adults individuals were released in
the wild from the captive breeding program. In 2016, there were
approximately 323 individuals in existence.
1.Calculate r for this time frame, assuming a continuous and
constant growth rate (2 pts).
2.What is the doubling time of this population (2 pts)?
3. 30 rabbits are introduced...
YEAR 0 YEAR 1 YEAR 2 YEAR 3 MACRS DEPRECIATION RATE 33.33% 44.45% 14.81% 7.41% A...
YEAR 0
YEAR 1
YEAR 2
YEAR 3
MACRS
DEPRECIATION RATE
33.33%
44.45%
14.81%
7.41%
A fast-food company invests $2.2 million to buy machines for
making Slurpees. These can be depreciated using the MACRS schedule
shown above. If the cost of capital is 10%, what is the increase in
the net present value (NPV) of the product gained by using MACRS
depreciation over straight-line depreciation for three years? A)
$28,559 B) $47,599 C) $76,158 D) $190,321
Please help me, I'm...
USING EXCEL FORMULA Round your answers to 4 decimal places. According to CBS Money Watch, the...
USING EXCEL FORMULA
Round your answers to 4 decimal places.
According to CBS Money Watch, the average monthly household
cellular phone bill is $100. Suppose monthly household cell phone
bills are normally distributed with a standard deviation of
$11.35.
What is the probability that a randomly selected monthly cell
phone bill is more than $127?
What is the probability that a randomly selected monthly cell
phone bill is between $87 and $110?
What is the probability that a randomly selected...
What is the firm's inventory turnover ratio, ROA (in %, round to 2 decimal places), ROE (in %, round to 2 decimal places), profit margin (in %, round to 2 decimal places), EPS($), P/E ratio, market-to-book ratio?
The balance sheet and income statement shown below are for
Pettijohn Inc. Note that the firm has no amortization charges, it
does not lease any assets, none of its debt must be retired during
the next 5 years, and the notes payable will be rolled over.
Balance Sheet (Millions of $)
Assets
2018
Cash and securities
$ 1,554.0
Accounts receivable
9,660.0
Inventories
13,440.0
Total current assets
$24,654.0
Net plant and equipment
17,346.0
Total assets
$42,000.0
Liabilities and Equity
Accounts payable...
ADVERTISEMENT
ADVERTISEMENT
Latest Questions
- TASK back to top In the contemporary management environment, mergers and acquisitions are hot topics; particularly...
- A room with 2.7-m-high ceilings has a metal plate on the floor with V = 0V...
- which of the following statements are true? a) the same nuclear changes (creation/destruction of specific nucleons)...
- Overview: Advances in technology have impacted many facets of the auditing process, from assessing risk and...
- Background: This course is all about data visualization. However, we must first have some understanding about...
- A rescue helicopter lifts a 70.6-kg person straight up by means of a cable. The person...
- Dolomite, [CaMg(CO3)2] is found in a soil sample. A geochemist titrates 24.65 g of soil with...
ADVERTISEMENT