Question

In: Accounting

Predicted Cash Inflows (outflows) (A) Year(s) of Cash Flows (B) 12% Present Value Factor (C) Present...

Predicted Cash Inflows (outflows) (A)

Year(s) of Cash Flows (B)

12% Present Value Factor (C)

Present Value of Cash Flows (A * C)

Initial Investment

Fixed Assets

($810,000)

0

1

($810,000)

Working Capital

-$100,000.00

0

1

($100,000)

Operations

$0

Annual taxable income without depreciation

310,000

1-5

3.605

$1,117,550

Taxes on income ($310,000*.40)

-124,000

1-5

3.605

($447,020)

Depreciation tax shield

64,800

1-5

3.605

$233,604

Disinvestment

$0

Site restoration

80,000

5

0.567

($45,360)

Tax shield of restoration ($80,000*.40)

32,000

5

0.567

$18,144

Working Capital

100,000

5

0.567

$56,700

Net present value of all cash flows

$23,618

*Computation of depreciation tax shield:

Annual straight-line depreciation ($810,000/5) . . . . . . . . . . . . . . $162,000

Tax rate . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3 0.40

Depreciation tax shield . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . $ 64,800

Because the proposal had a positive net present value when discounted at Sunshine’s cost of capital of 12 percent, the project was approved; all investments were made at the end of 2017. Shortly after production began in January 2018, a government agency notified Sunshine of required additional expenditure totaling $200,000 to bring the plant into compliance with new federal emission regulations. Sunshine has the option either to comply with the regulations by Dec 31, 2018, or to sell the entire operation (fixed assets and working capital) $250,000 on December 31, 2018. The improvements will be depreciated over the remaining four-year life of the plant using straight-line depreciation. The cost of site restoration will not be affected by the improvements. If Sunshine elects to sell the plant, any book loss can be treated as an offset against taxable income on other operations. This tax reduction is an additional cash benefit of selling.

Required – 20 points

a. Should Sunshine sell the plant or comply with the new federal regulations? To simplify calculations, assume that any additional improvements are paid for on December 31, 2018.

b. Would Sunshine have accepted the proposal in 2017 if it had been aware of the forthcoming federal regulations?

c. Do you have any suggestions that might increase the project’s net present value? (No calculations are required.)

Solutions

Expert Solution

0 1 2 3 4 5
Initial Investment         (810,000)
Working Capital         (100,000)
Annual Taxable Income without depreciation           310,000           310,000           310,000           310,000           310,000
Taxes on Income         (124,000)         (124,000)         (124,000)         (124,000)         (124,000)
Depreciation tax shield              64,800              64,800              64,800              64,800              64,800
Additional Investment         (200,000)
Depreciation tax shield Improvements              20,000              20,000              20,000              20,000
Disinvestment
Site restoration           (80,000)
Tax shiled on restoration              32,000
Working Capital           100,000
Net Cash Inflow/( Outflow)         (910,000)              50,800           270,800           270,800           270,800           322,800
Present Value Factor 1 0.8929 0.7972 0.7118 0.6355 0.567
Net Present value of all cash flow         (910,000)              45,357           215,880           192,750           172,098           183,028 (100,887)
0 1
Initial Investment         (810,000)
Working Capital         (100,000)
Annual Taxable Income without depreciation           310,000
Taxes on Income         (124,000)
Depreciation tax shield              64,800
Cash receipt from sale of Assets           250,000
Tax Gain from sale of Assets and release of Working Capital
((810000+100000-162000)-250000)*40%           199,200
Net Cash Inflow/( Outflow)         (910,000)           700,000
Present Value Factor 1 0.8929
Net Present value of all cash flow         (910,000)           625,000         (285,000)

Sunshine should comply with the Federal requirements instead of selling the plant. If he sells the plant, he will loose $ 285,000 , however if he continues to run the plant, the loss would be $100,887.

Snshine would have not accepted the offer, had he been aware of the forthcoming Federal regulations since the Net present value of the project was negative.

Project NPV can be increased if the cash inflow increases, it can be achieved if the company can increase its sales revenue, alternatively decreasing the costs of sales can also incrrease the inflow and thereby Net Present value.


Related Solutions

Forecast the Net Present Value of a project given the cash inflows and cash outflows of...
Forecast the Net Present Value of a project given the cash inflows and cash outflows of the project. Then use this information to simulate the uncertainty of forecasting a project’s NPV. A likely scenario might be: Project A is a multi-year project; it begins on January 1, 2011 and is scheduled to end on December 31, 2014 (fixed cost is $215,000) The cash outflow for Project A is estimated at $100,000 at the beginning in the first year of the...
10. Analyze the following cash inflows and cash outflows. Star Pharmaceuticals Statement of Cash Flows For...
10. Analyze the following cash inflows and cash outflows. Star Pharmaceuticals Statement of Cash Flows For the Years Ended December 31, 2015 and 2014 (in millions) 2015 2014 Cash flows from operating activities (CFO): Net income $5,800 $3,300 Adjustments to reconcile net income to CFO:      Depreciation and amortization 550 360         Deferred income taxes 10 (580)      Stock-based compensation 590 170 (Increase) decrease in operating assets and liabilities:      Accounts receivable (490) (380)      Inventories (6,900) (1,960)      Other...
The operating activities section of the Statement of Cash Flows shows the inflows and outflows from...
The operating activities section of the Statement of Cash Flows shows the inflows and outflows from our day to day operations. Why is it that cash flows from operating activities does not equal net income? Is it possible for a company to have net income for the year and have a negative cash flow from operating activities in the same year? Why or why not?
Calculate the present value of the following cash flows given a discount rate of 12%: Year...
Calculate the present value of the following cash flows given a discount rate of 12%: Year 1 Year 2 Year 3 Year 4 Cash Flows $1,500 $4,500 $8,500 $12,000
If the discount rate is 12%, what is the present value of the following cash flows:...
If the discount rate is 12%, what is the present value of the following cash flows: Year Cash Flow 1 $10,000 2 $11,000 3 $12,000 4 $13,000 5 $14,000 6-15 $15,000 each year a. $144,618 b. $90, 537 c. $127,923 d. $127,197
2) i: In analysing cash flows, where would you find inflows and outflows? ii: How is...
2) i: In analysing cash flows, where would you find inflows and outflows? ii: How is short term finance generally used? iii: What is an Asset-based Loan?
The discount rate that equates the present value of a project’s cash inflows with the present...
The discount rate that equates the present value of a project’s cash inflows with the present value of the project’s outflows is:
Prepare the cash budget and determine the cash inflows, cash outflows, and the expected change in...
Prepare the cash budget and determine the cash inflows, cash outflows, and the expected change in cash each month. The management estimates total sales for the period January, 2019 through June 2019 based on actual sales from the immediate past six months. The following assumptions are made:  The Sales were $125,000 in July 2018 and then the sales grew by 8% each month for the first three months (i.e., August to October 2018) and by 6% for the next...
Determine the total cash inflows, the total cash outflows, and the expected change in cash for...
Determine the total cash inflows, the total cash outflows, and the expected change in cash for each month from January to July, 2019. Show your work in excel using excel functions. Based the findings, explain in your own words whether the company should borrow/invest and how much and in which months. The management estimates total sales for the period January, 2019 through June 2019 based on actual sales from the immediate past six months. The following assumptions are made: The...
a. What is the present value of end-of-year cash flows of $7,000 per year, with the...
a. What is the present value of end-of-year cash flows of $7,000 per year, with the first cash flow received five years from today and the last one 40 years from today? Assume interest rate of 10%. $41,271.67 $44,496.49 $45,733.15 $46,264.30 $50,218.30 b. What is the value of a 30-year annuity that pays $1250 a year? The annuity’s first payment will be received on year 11. Also, assume that the annual interest rate is 6 percent for years 1 through...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT