Question

In: Accounting

After-Tax Cash Flows Using the data that is shown below - (a) calculate the individual after-tax...

After-Tax Cash Flows

Using the data that is shown below - (a) calculate the individual after-tax cash flow effect of each relevant item in each independent situation, and (b) sum the individual after-tax cash flows in each situation to determine the overall net after-tax cash flow.

A B C
Cash revenue received 220,000 1,050,000 550,000
Cash operating expenses paid 128,000 770,000 330,000
Depreciation on tax return 28,000 64,000 50,000
Income tax rate 30% 25% 20%

Do not use negative signs with any of your answers below.

A B C
(a) Cash revenue Answer Answer Answer
Cash operating expenses Answer Answer Answer
Depreciation expense Answer Answer Answer
(b) Net after-tax cash flow Answer Answer Answer

Solutions

Expert Solution

Solution:
(a) A B C
Cash Revenue (A) $154,000 $787,500 $440,000
[$220,000*(1-0.30)] [$1,050,000*(1-0.25)] [$550,000*(1-0.20)]
Cash Operating expenses(B) $89,600 $577,500 $264,000
[$128,000*(1-0.30)] [$770,000*(1-0.25)] [$330,000*(1-0.20)]
Depreciation ( C) $8,400 $16,000 $10,000
[$28,000*30%] [$64,000*25%] [$50,000*20%]
(b) Net after tax cash flows A-B+C $72,800 $226,000 $186,000
Working note:
After tax revenue = Revenue(1-tax rate)
After tax Operating expenses = Operating expenses(1-tax rate)
After tax depreciation = Depreciation * tax rate
After tax cash flow = After tax revenue - after tax operating expenses+depreciation tax sheild
Please upvote , if found the answer useful.
For any clarification, Feel free to reach at comment Section

Related Solutions

Using the data that is shown below - (a) calculate the individual after-tax cash flow effect of each relevant item in each independent situation
After-Tax Cash FlowsUsing the data that is shown below - (a) calculate the individual after-tax cash flow effect of each relevant item in each independent situation, and (b) sum the individual after-tax cash flows in each situation to determine the overall net after-tax cash flow.ABCCash revenue received$110,000$525,000$275,000Cash operating expenses paid64,000385,000165,000Depreciation on tax return14,00032,00025,000Income tax rate30%25%20%Do not use negative signs with any of your answers below.ABC(a)Cash revenueAnswerAnswerAnswerCash operating expensesAnswerAnswerAnswerDepreciation expenseAnswerAnswerAnswer(b)Net after-tax cash flowAnswerAnswerAnswer
Calculate the Net Present Value of the cash flows depicted in the table below using a...
Calculate the Net Present Value of the cash flows depicted in the table below using a cost of capital of {r81d}percent. year Cash Flow 0 -60 1 40 2 40 3 0
Each of the following scenarios is independent. Assume that all cash flows are after-tax cash flows....
Each of the following scenarios is independent. Assume that all cash flows are after-tax cash flows. Campbell Manufacturing is considering the purchase of a new welding system. The cash benefits will be $480,000 per year. The system costs $2,050,000 and will last 10 years. Evee Cardenas is interested in investing in a women's specialty shop. The cost of the investment is $330,000. She estimates that the return from owning her own shop will be $45,000 per year. She estimates that...
XYZ Inc. is considering Projects S and L, whose cash flows are shown below. Calculate NPV...
XYZ Inc. is considering Projects S and L, whose cash flows are shown below. Calculate NPV and MIRR of these projects and if these are mutually exclusive which one you choose under each method? WACC: 8.75% Year           0       1       2       3       4 CFS          -$1,100   $375    $375    $375    $375 CFL          -$2,200   $725    $725    $725    $725
Using the prices and cash flows of Treasury coupon bonds shown below, determine the par bond...
Using the prices and cash flows of Treasury coupon bonds shown below, determine the par bond yield for each of the Treasury securities. Bond Price Year 1 Year 2 Year 3 1 99.50 105 2 101.25 6 106 3 100.25 7 7 107 Using Excel, solve the above problem and graph the resulting Treasury par bond yield curve (show formula). Suppose that the 6-month, 12-month, 18-month, and 24-month zero rates are 5%, 6%, 6.5%, and 7% respectively. What is the...
Use the following information to answer the next two questions. Consider the after-tax cash flows below:...
Use the following information to answer the next two questions. Consider the after-tax cash flows below: Year 0 1 2 3 4 Cash Flow -$75,000 $5,100 -$1,100 $498,000 -$272,000 The required rate of return is 12 percent. Find an internal rate of return (IRR) for these cash flows. Should you use the IRR you calculated in the previous question to decide whether the project is acceptable? Explain show work please
Calculate the durations and volatilities of securities A, B, and C. Their cash flows are shown...
Calculate the durations and volatilities of securities A, B, and C. Their cash flows are shown below. The interest rate is 8%. (Do not round intermediate calculations. Round "Duration" to 3 decimal places and "Volatility" to 2 decimal places.) Period 1 Period 2 Period 3 Duration Volatility   A 40        40        40       years      B 20        20        120       years   C 10        10        110       years
Calculate the durations and volatilities of securities A, B, and C. Their cash flows are shown...
Calculate the durations and volatilities of securities A, B, and C. Their cash flows are shown below. The interest rate is 10%. (Do not round intermediate calculations. Round "Duration" to 4 decimal places and "Volatility" to 2 decimal places.) Period 1 Period 2 Period 3 Duration Volatility   A 50 50 60   years   B 30 30 140 years   C 20 20 130 years
Calculate the durations and volatilities of securities A, B, and C. Their cash flows are shown...
Calculate the durations and volatilities of securities A, B, and C. Their cash flows are shown below. The interest rate is 9%. Pd 1 Pd 2 Pd 3 Duration Volatility A. 45 45 50 yrs B. 25 25 130 yrs C. 15 15 120 yrs
Calculate the durations and volatilities of securities A, B, and C. Their cash flows are shown...
Calculate the durations and volatilities of securities A, B, and C. Their cash flows are shown below. The interest rate is 6%. (Do not round intermediate calculations. Round "Duration" to 4 decimal places and "Volatility" to 2 decimal places.) Period 1 Period 2 Period 3 Duration Volatility   A 85 85 130   years   B 65 65 210 years   C 55 55 200 years
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT