ACC 202 Chapter Notes - Chapter 13: Earnings Before Interest And Taxes, Capital Budgeting, Investment
Get access
Related Documents
Related Questions
Capital Budgeting | |||||||||||
Glacier Creek Textiles is planning to purchase new manufacturing equipment. The equipment has an acquisition cost of $100,000, an estimated useful life of five years and no residual value. The company uses a 12% rate of return to evaluate capital projects. The cash flows for the five years: | |||||||||||
Year | Net Cash Outflows | Net Cash Inflows | |||||||||
Amount invested | |||||||||||
0 | ($100,000) | ||||||||||
1 | 25,000 | ||||||||||
2 | 29,000 | ||||||||||
3 | 26,000 | ||||||||||
4 | 28,000 | ||||||||||
5 | 35,000 | ||||||||||
Requirements | |||||||||||
1. Compute the accounting rate of return. | |||||||||||
2. Compute the net present value of the investment using Excel's PV function. | |||||||||||
3. Compute the net present value of the investment using Excel's NPV function. | |||||||||||
4. Compute the profitability index, rounded to two decimal places. | |||||||||||
5. Compute the internal rate of return of the investment using Excel's IRR function. Display to two decimal places, but do not round. | |||||||||||
Excel Skills | |||||||||||
1. Function PV | |||||||||||
2. Function NPV | |||||||||||
3. Function IRR | |||||||||||
Evaluate Glacier Creek Textiles' new manufacturing equipment. | ||||||
Data | ||||||
Annual discount Rate | 0.12 | |||||
Cash Flow Year 0 (Cost) | (100,000) | |||||
Cash Flow Year 1 | 25,000 | |||||
Cash Flow Year 2 | 29,000 | |||||
Cash Flow Year 3 | 26,000 | |||||
Cash Flow Year 4 | 28,000 | |||||
Cash Flow Year 5 | 35,000 | |||||
Useful Life in years | 5 | |||||
Residual value | 0 | |||||
Requirement 1 | Compute the Accounting Rate of Return | |||||
Average annual operating income | Average amount invested | Accounting Rate of Return - ARR | ||||
xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx | xxxxxxxxxxxxxx | xxxxxxxxxxxxxxxxx | ||||
Requirement 2 | Compute the net present value of the investment using Excel's PV function. | |||||
Period | Cash Flows | |||||
1 | (22,321) | Note: The first period is shown as an example. | ||||
2 | xxxxxxxx | |||||
3 | xxxxxxxx | |||||
4 | xxxxxxxx | |||||
5 | xxxxxxxx | |||||
Present value of net cash flows | xxxxxxxx | Note: PV calculates the present value as a negative amount. | ||||
Cost of Asset | xxxxxxxx | |||||
Net Present Value | xxxxxxxx | |||||
Requirement 3 | Compute the net present value of the investment using Excel's NPV function | |||||
Present value of net cash flows | xxxxxxxxxx | |||||
Cost of asset | xxxxxxxxxx | |||||
Net Present Value | xxxxxxxxxx | |||||
Requirement 4 | Compute the profitability index, rounded to two decimal places. | |||||
Profitability index | xxxxxxxxxx | |||||
Requirement 5 | Compute the internal rate of return of the investment using Excel's IRR function. | |||||
Display to two decimal places, but do not round. | ||||||
IRR | xxxxxxxxx | Note: IRR requires a negative amount for the investment. |
Places with xxxxx's are what needs to be filled in, and it's for excel so if I could see the references to which numbers and the formula used that would be helpful. Thank you!!
Supreme Chips is a manufacturer of prototype chips based in​ Dublin, Ireland. Next​ year, in 2018​,Supreme Chips expects to deliver 575 prototype chips at an average price of $90,000. Supreme Chips' marketing vice president forecasts growth of 55 prototype chips per year through 2024.
That​ is, demand will be 575 in 2018​,630 in 2019​,685 in 2020​, and so on.
The plant cannot produce more than 545 prototype chips annually. To meet future ​demand,Supreme Chips must either modernize the plant or replace it. The old equipment is fully depreciated and can be sold for $4,700,000. if the plant is replaced. If the plant is​ modernized, the costs to modernize it are to be capitalized and depreciated over the useful life of the updated plant. The old equipment is retained as part of the modernize alternative. The following data on the two options are​ available:
Modernize | Replace | ||
Initial investment in 2018 | $34,800,000 | $66,100,000 | |
Terminal disposal value in 2024 | $6,600,000 | $16,800,000 | |
Useful life | 7 years | 7 years | |
Total annual cash operating cost per prototype chip | $74,500 | $65,000 |
Supreme Chips uses​ straight-line depreciation, assuming zero terminal disposal value. For​ simplicity, we assume no change in prices or costs in future years. The investment will be made at the beginning of 2018​, and all transactions thereafter occur on the last day of the year.Supreme ​Chips' required rate of return is 6​%.There is no difference between the modernize and replace alternatives in terms of required working capital. Supreme Chips has a special waiver on income taxes until 2024.
Requirement 1. Sketch the cash inflows and outflows of the modernize and replace alternatives over the 2018​-2024 period.
​First, determine the cash inflows and outflows of the modernize alternative over the 2018 to 2024 period. ​(Use a minus sign or parentheses for a cash outflows. Leave unused cells​ blank.)
Units | Net cash | Initial | Proceeds from | |
Year | sold | contributions | investments | sale of equipment |
Jan 1, 2018 | $(34,800,000) | |||
Dec 31, 2018 | 575 | $8,912,500 | ||
Dec 31, 2019 | 630 | 9,765,000 | ||
Dec 31, 2020 | 685 | 10,617,500 | ||
Dec 31, 2021 | 740 | 11,470,000 | ||
Dec 31, 2022 | 795 | 12,322,500 | ||
Dec 31, 2023 | 850 | 13,175,000 | ||
Dec 31, 2024 | 905 | 14,027,500 | $6,600,000 |
​Next, determine the cash inflows and outflows of the replace alternative over the 2018 to 2024 period. ​(Use a minus sign or parentheses for a cash outflows. Leave unused cells​ blank.)
Units | Net cash | Initial | Proceeds from | |
Year | sold | contributions | investments | sale of equipment |
Jan 1, 2018 | $(66,100,000) | $4,700,000 | ||
Dec 31, 2018 | 575 | $14,375,000 | ||
Dec 31, 2019 | 630 | 15,750,000 | ||
Dec 31, 2020 | 685 | 17,125,000 | ||
Dec 31, 2021 | 740 | 18,500,000 | ||
Dec 31, 2022 | 795 | 19,875,000 | ||
Dec 31, 2023 | 850 | 21,250,000 | ||
Dec 31, 2024 | 905 | 22,625,000 | $16,800,000 |
Requirement 2. Calculate payback period for the modernize and replace alternatives. ​(Round your answers to two decimal​ places.)
The payback period for the investment assuming the modernize alternative is ____ years.
3. | Calculate net present value of the modernize and replace alternatives |