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


Related 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
ADVERTISEMENT