Ch 8 Ex 1. Basic present value calculations Calculate the present value of the following cash flows, rounding to the nearest dollar: a. A single cash inflow of $12,600 in 5 years, discounted at a 12% rate of return.
Ch 8 Ex 1. Basic present value calculations
Calculate the present value of the following cash flows, rounding to the nearest dollar:
- A single cash inflow of $12,600 in 5 years, discounted at a 12% rate of return.
- An annual receipt of $16,600 over the next 12 years, discounted at a 14% rate of return.
- A single receipt of $15,600 at the end of Year 1 followed by a single receipt of $10,000 at the end of Year 3. The company has a 10% rate of return.
- An annual receipt of $8,750 for 3 years followed by a single receipt of $10,000 at the end of Year 4. The company has a 16% rate of return.
| Single cash flow: | |
| (Note: Use Excel NPV, enter rate and use a column with a zero amount for years 1-4(row 1-4)and 12000 entered in year 5(row 5) | |
| Annual receipt: | |
| (Note: Use Excel PV function.) | |
| Single receipt: | |
| (Note: use NPV and same approch as above.) | |
| Annual receipt: | |
| (Note: use NPV and same approch as above.) |
Ch 8 Ex 3 Straightforward net present value calculations
Contempo Inc. is considering the acquisition of some new labor-saving equipment. Management estimates that the equipment will cost $42,000 and will produce the following savings in cash operating costs during the next 5 years: Year 1, $18,500; Year 2, $13,000; Year 3, $10,000; Year 4, $10,000; and Year 5, $6,000. The company uses the net present value method to analyze investments and desires a minimum rate of return of 12%.
- Compute the net present value of the proposed investment. Ignore income taxes and round to the nearest dollar.
- Considering the time value of money , should Contempo acquire the new equipment? Why?
| Compute the net present value of the proposed investment. | |
| Considering the time value of money , should Contempo acquire the new equipment? Why? |
Ch 8 Pb 3 Straightforward net present value and payback computations
The Calgary Eskimos play in the Canadian Hockey
League. Although the Eskimos will soon be moving to a modern arena, management
is studying the possibility of expanding the team’s present facility to
accommodate increased crowds. A $2.4 million expansion is planned that has a
$200,000 residual value and will be depreciated by the straight-line method
over four seasons. Information about the expansion follows:
| Number of seats | Occupancy rate | Ticket price | ||||
| Class 1 seats | 2,500 | 80% | $6 | |||
| Class 2 seats | 2,000 | 60 | 4 |
The team will play 62 home games each season. Total added operating costs per game (ushers, cleanup, and depreciation) are expected to average $11,800. All such costs, except depreciation, require cash outlays.
Instructions
- By using the net present value method and a 16% desired rate of return, determine whether the expansion should be undertaken.
- In addition to the cash flows presented here, what other cash flows might change if the Eskimos add on to the arena?
| Revenue per year-class 1 | |
| Revenue per year-class 2 | |
| Total revenue | |
| Total yearly expenses (Added extra costs per game minus depreciation) X (# of games) | |
| Cash flow year 1(Inflows- expenses) | |
| Cash flow year 2 | |
| Cash flow year 3 | |
| Cash flow year 4 | |
| Net Present value | |
| Present value of residual: | |
| Year 1 | |
| Year 2 | |
| Year 3 | |
| Year 4 | |
| NPV | |
| Total Present value Calculation: | |
| NPV Cash Inflows | |
| NPV of residual: | |
| Cost of Arena | |
| Total Net Present Value | |
| In addition to the cash flows presented here, what other cash flows might change if the Eskimos add on to the arena? |
Ch 8 Pb 4 Equipment replacement decision
Columbia Enterprises is studying the replacement
of some equipment that originally cost $74,000. The equipment is expected to
provide 6 more years of service if $8,700 of major repairs are performed in 2
years. Annual cash operating costs total $28,400. Columbia can sell the
equipment now for $36,000; the estimated residual value in 6 years is $5,000.
New equipment is available that will reduce annual cash operating costs to $23,100. The equipment costs $103,000, has a service life of 6 years, and has an estimated residual value of $13,000. Company sales will total $430,000 per year with either the existing or the new equipment.
Columbia has a minimum desired return of 12% and depreciates all equipment by the straight-line method.
Instructions
- By using the net present value method, determine whether Columbia should keep its present equipment or acquire the new equipment. Round all calculations to the nearest dollar, and ignore income taxes.
- Columbia’s management believes that the time value of money should be considered in all long-term decisions. Briefly discuss the rationale that underlies management’s belief.
| Keep Equipment: | |
| Year 1 costs | |
| Year 2 cost | |
| Year 3 costs | |
| Year 4 costs | |
| Year 5 costs | |
| Year 6 costs | |
| Net Present Value of costs | |
| Note: Disregard the sale amount, that will be used if we buy new equipment. Instead treat the residual value as the final cash inflow. | |
| Buy Equipment: | |
| Year 1 costs | |
| Year 2 costs | |
| Year 3 costs | |
| Year 4 costs | |
| Year 5 costs | |
| Year 6 costs | |
| Net Present Value of costs | |
| Add purchase amount | |
| Add sale amount | |
| Net Present Value of costs | |
| Note: The yearly costs are added and are a negative cash flow. The cost of the new machine is also negative and the sale of the equipment is positive. Both the purchase and sale are treated as cash flows as of today. | |
| Columbia’s management believes that the time value of money should be considered in all long-term decisions. Briefly discuss the rationale that underlies management’s belief. |
Looking for a Similar Assignment? Order now and Get 10% Discount! Use Coupon Code "Newclient"
