ACCTG 211 Lecture Notes - Lecture 25: Net Present Value, Cash Flow, Earnings Before Interest And Taxes
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!!
QUESTION 1
Which of the following statements is correct regarding thepayback method as a capital budgeting technique?
The payback method considers the time value of money. | ||
An advantage of the payback method is that it indicates if aninvestment will be profitable. | ||
The payback method provides the years needed to recoup theinvestment in a project. | ||
Payback is calculated by dividing the annual cash inflows by thenet investment. |
0.625 points
QUESTION 2
Taxes are not an important consideration indeveloping cash flow assessments.
True
False
0.625 points
QUESTION 3
USE THE FOLLOWING INFORMATION TO ANSWER THE NEXT (2)QUESTIONS:
Parkways Inc. is considering the purchase of a new machine. Themachine will cost $60,000 to purchase and will generate $15,000 ofcash revenues per year for the next 8 years. The machine will cost$1,000 per year to operate & maintain. At the end of it'suseful life, it has an estimated salvage value of $5,000. Parkwaysrequires a minimum rate of return of 14% for this class of asset.Determine the Net Present Value of this investment proposal.
PV of $1 (14%, 8n) is .351; PVOA (14%, 8n) is 4.639
$6,701 | ||
$57,000 | ||
$1,166 | ||
$0 |
0.625 points
QUESTION 4
Sun Devil Corporation is adding a new product line that willrequire an investment of $138,000. The product line is estimated togenerate net cash flows of $25,000 the first year, $23,000 thesecond year, and $18,000 each year thereafter for ten more years.What is the payback period?
7.26 | ||
5.52 | ||
7.00 | ||
7.67 |
0.625 points
QUESTION 5
Sparky Company invested in an asset with a useful life of 5years. The companys required rate of return is 10% for this classof asset. The net cash flows are estimated to be $7,610 per yearfor the next 5 years and no salvage value is anticipated.
If the asset generates a positive net present value of $2,000,what was the amount of the original investment? (Roundyour answer to the nearest whole dollar. Do not use $signs or commas in recording youranswer. EXAMPLE: If you answer is $22,516,enter your answer as 22516).
Present Value of $1 | |||
Periods | 10% | 12% | 14% |
5 | .621 | .567 | .519 |
8 | .467 | .404 | .351 |
10 | .386 | .322 | .270 |
Present Value of Ordinary Annuity | |||
Periods | 10% | 12% | 14% |
5 | 3.791 | 3.605 | 3.433 |
8 | 5.335 | 4.968 | 4.639 |
10 | 6.145 | 5.650 | 5.216 |
0.625 points
QUESTION 6
Suppose Whole Foods is considering investing inwarehouse-management software that costs $500,000, has $60,000residual value and should lead to cash cost savings of $130,000 peryear for its five-year life. Determine the NPV of the investment ifmanagement uses a 12% discount rate. (Round to the nearest wholenumber for your final answer. When recording your answer, do notuse $ dollar signs or commas. EXAMPLE: If you answer is $12,251,enter 12251)
Present Value of $1 | |||
Periods | 10% | 12% | 14% |
5 | .621 | .567 | .519 |
8 | .467 | .404 | .351 |
10 | .386 | .322 | .270 |
Present Value of Ordinary Annuity | |||
Periods | 10% | 12% | 14% |
5 | 3.791 | 3.605 | 3.433 |
8 | 5.335 | 4.968 | 4.639 |
10 | 6.145 | 5.650 | 5.216 |
0.625 points
QUESTION 7
ABC, Corporation is looking to purchase a new piece of equipmentfor $121,505. The equipment has a useful life of 8 years and noexpected salvage value.
The minimum desired rate of return is 10%. ABC is uncertain asto the annual net cash flows the equipment will generate.
What is the minimum annual net cashflow ABC must achieve in order to justify the purchase of this newequipment?
(Round your answer to the nearest whole dollar. Do not use $dollar signs or commas when recording your answer.)
Present Value of $1 | |||
Periods | 10% | 12% | 14% |
5 | .621 | .567 | .519 |
8 | .467 | .404 | .351 |
10 | .386 | .322 | .270 |
Present Value of Ordinary Annuity | |||
Periods | 10% | 12% | 14% |
5 | 3.791 | 3.605 | 3.433 |
8 | 5.335 | 4.968 | 4.639 |
10 | 6.145 | 5.650 | 5.216 |
0.625 points
QUESTION 8
Sparky Company is considering the replacement of an old machinewith the purchase of a new piece of production equipment that willreduce labor and maintenance costs by $45,000 peryear. If Sparky purchases the new machine, the companywill sell the old equipment for an estimated $20,000 salvage value.Data related to the new machine follows:
InitialInvestment $300,000
UsefulLife 10years
Salvagevalue (newmachine) $30,000
HurdleRate 12%
Assume all cash flows occur at the end of the year and ignoreincome taxes. Calculate the net present value of theinvestment in the new machine. (Round your answer to the nearestwhole dollar. If you have a negative NPV, record youranswer using () parenthesis. EXAMPLE: If yourNPV is ($2,000), enter your answer as (2000).
Present Value of $1 | |||
Periods | 10% | 12% | 14% |
5 | .621 | .567 | .519 |
8 | .467 | .404 | .351 |
10 | .386 | .322 | .270 |
Present Value of Ordinary Annuity | |||
Periods | 10% | 12% | 14% |
5 | 3.791 | 3.605 | 3.433 |
8 | 5.335 | 4.968 | 4.639 |
10 | 6.145 | 5.650 | 5.216 |