REQUIRED Analyze the data about the machine. Use the following evaluation approaches in your analysis: The net present value method (Round to the nearest dollar.) The accounting rate-of-return method. (Round percentage to one decimal place.) The payback period method (Round to one decimal place.) [Hint: Use Tables 1 and 2 in Appendix C.] ACCOUNTING CONNECTION> Summarize the information generated in requirement 1, and make a recommendation.

Excel Applications for Accounting Principles
4th Edition
ISBN:9781111581565
Author:Gaylord N. Smith
Publisher:Gaylord N. Smith
Chapter1: Business Transactions (ptrans)
Section: Chapter Questions
Problem 7R
icon
Related questions
Question

Edge Company’s production vice president believes keeping up-to-date with technological changes is what makes the company successful and feels that a machine introduced recently would fill an important need.  The machine has an estimated useful life of four years, a purchase price of $250,000, and a residual value of $25,000.  The company controller has estimated average annual net income of $11,250 and the following cash flows for the new machine:

Cash Flow Estimates

Year

Cash Inflows

Cash Outflows

Net Cash Inflows

1

$325,000

$250,000

$75,000

2

320,000

250,000

70,000

3

315,000

250,000

65,000

4

310,000

250,000

60,000

 

The company uses a 12 percent minimum rate of return and a three-year payback period for capital investment evaluation purposes.

 

REQUIRED

  1. Analyze the data about the machine. Use the following evaluation approaches in your analysis:
    1. The net present value method (Round to the nearest dollar.)
    2. The accounting rate-of-return method. (Round percentage to one decimal place.)
    3. The payback period method (Round to one decimal place.) [Hint: Use Tables 1 and 2 in Appendix C.]
  2. ACCOUNTING CONNECTION> Summarize the information generated in requirement 1, and make a recommendation.
Enter the appropriate amount or item in the shaded cells. Use the drop-down lists when available.
An asterisk (*) will appear next to an incorrect entry in the outlined cells.
Leave no cell blank. Ensure to enter "0" wherever applicable. Round PV factors to three decimal places.
Net present value method
a.
Year
Net Cash Inflows
12% Factor
Present Value
1
75,000
70,000
%3!
2
%3D
3
65,000
%3D
4
60,000
%3D
25,000
Total present value
Less purchase price of machine
4
!3!
250,000
Net present value
b.
Accounting Rate of Return
Average Annual Net Income
Average Investment Cost
%3D
11,250
137,500
%3D
8.2%
%3D
Transcribed Image Text:Enter the appropriate amount or item in the shaded cells. Use the drop-down lists when available. An asterisk (*) will appear next to an incorrect entry in the outlined cells. Leave no cell blank. Ensure to enter "0" wherever applicable. Round PV factors to three decimal places. Net present value method a. Year Net Cash Inflows 12% Factor Present Value 1 75,000 70,000 %3! 2 %3D 3 65,000 %3D 4 60,000 %3D 25,000 Total present value Less purchase price of machine 4 !3! 250,000 Net present value b. Accounting Rate of Return Average Annual Net Income Average Investment Cost %3D 11,250 137,500 %3D 8.2% %3D
Payback period method
Total cash investment
Less cash flow recovery:
$ 250,000
Year
$ 75,000
2
70,000
3
65,000
40,000
Unrecovered investment
Payback period is
3.7
years
Net present value
Accounting rate of return
Payback period
8.2%
3.7
years
Transcribed Image Text:Payback period method Total cash investment Less cash flow recovery: $ 250,000 Year $ 75,000 2 70,000 3 65,000 40,000 Unrecovered investment Payback period is 3.7 years Net present value Accounting rate of return Payback period 8.2% 3.7 years
Expert Solution
steps

Step by step

Solved in 5 steps with 4 images

Blurred answer
Knowledge Booster
Product life cycle
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Excel Applications for Accounting Principles
Excel Applications for Accounting Principles
Accounting
ISBN:
9781111581565
Author:
Gaylord N. Smith
Publisher:
Cengage Learning