Question
In: Accounting
Calculate the following from the chart below. 1. Net present value 2. Accounting rate of return...
Calculate the following from the chart below.
1. Net present value
2. Accounting rate of return
3. Internal rate of return (using average annual cash flows)
4. Present value index
5. Payback
Use 8% as the hurdle rate, and assume a salvage value of $50,000.
| Alternative A | Alternative B | Alternative C | |
| Cost | $4,200.00 | $4,400.00 | $4,600.00 |
| Setup Costs | $50,000.00 | $22,000.00 | $30,000.00 |
| Training Costs | $22,000.00 | $25,000.00 | $30,000.00 |
| Annual Maintenance Costs | $32,000.00 | $10,000.00 | $15,000.00 |
| Anticipated annual savings | $535,000.00 | $475,000.00 | $495,000.00 |
| Annual Labor savings | $20,000.00 | $0.00 | $40,000.00 |
| Expected useful life in years | $9.00 | $9.00 | $8.00 |
| Overhaul costs in year 4 | $10,000.00 | $18,000.00 | $30,000.00 |
| Annual Operating costs | $22,000.00 | $25,000.00 | $27,000.00 |
Solutions
Expert Solution
Please hit LIKE button if this helped. For any further explanation, please put your query in comment, will get back to you.
| A | B | C | ||||||||
| Intial Investment: | ||||||||||
| Cost | -4200 | -4400 | -4600 | |||||||
| Set Up Cost | -50000 | -22000 | -30000 | |||||||
| Training Cost | -22000 | -25000 | -30000 | |||||||
| Initial Investment at period 0 | -76200 | -51400 | -64600 | |||||||
| Annual Net Cash Flow: | ||||||||||
| Period | A | B | C | |||||||
| Annual Maintenance Cost | Full Life | -32000 | -10000 | -15000 | ||||||
| Annual Operating Cost | Full Life | -22000 | -25000 | -27000 | ||||||
| Anticipated Labor Saving | Full Life | 20000 | 0 | 40000 | ||||||
| Anticipated Annual Saving | Full Life | 535000 | 475000 | 495000 | ||||||
| Annual Net Cash inflow | 501000 | 440000 | 493000 | |||||||
| 1. Net Present Value | ||||||||||
| A | B | C | ||||||||
| Actual Cash Flow | PV Factor | Present Value | Actual Cash Flow | PV Factor | Present Value | Actual Cash Flow | PV Factor | Present Value | ||
| Initial Investment | -76200 | 1 | -76200 | -51400 | 1 | -51400 | -64600 | 1 | -64600 | |
| Annual Net Cash Inflow | Full Life | 501000 | 6.2469 | 3129697 | 440000 | 6.2469 | 2748636 | 493000 | 5.7466 | 2833074 |
| Overhaul Cost | Period 4 | -10000 | 0.735 | -7350 | -18000 | 0.735 | -13230 | -30000 | 0.735 | -22050 |
| Salvage Value | 9 and 8 | 50000 | 0.5002 | 25010 | 50000 | 0.5002 | 25010 | 50000 | 0.5402 | 27010 |
| Net Present Value | 3071157 | 2709016 | 2773434 | |||||||
| 2. Accounting Rate of Return | Net Profit/Investment | |||||||||
| Net Profit: | ||||||||||
| Anticipated Labor Saving | Full Life | 20000 | 0 | 40000 | ||||||
| Anticipated Annual Saving | Full Life | 535000 | 475000 | 495000 | ||||||
| Annual Maintenance Cost | Full Life | -32000 | -10000 | -15000 | ||||||
| Annual Operating Cost | Full Life | -22000 | -25000 | -27000 | ||||||
| Overhaul Cost | -10000 | -18000 | -30000 | |||||||
| Net Profit | A | 491000 | 422000 | 463000 | ||||||
| Investment | B | 76200 | 51400 | 64600 | ||||||
| Accounting Rate of Return | A/B | 644% | 821% | 717% | ||||||
| 3. Internal Rate of Return | ||||||||||
| A | B | C | ||||||||
| -76200 | -51400 | -64600 | ||||||||
| 501000 | 440000 | 493000 | ||||||||
| -10000 | -18000 | -30000 | ||||||||
| 50000 | 50000 | 50000 | ||||||||
| =IRR(C47:C50) | =IRR(D47:D50) | =IRR(E47:E50) | ||||||||
| 557% | 753% | 658% | ||||||||
| 4. Present Value Index | (NPV+Initial Investment)/Intial Investment | |||||||||
| A | B | C | ||||||||
| Intial Investment | A | 76200 | 51400 | 64600 | ||||||
| NPV | 3071157 | 2709016 | 2773434 | |||||||
| Total | B | 3147357 | 2760416 | 2838034 | ||||||
| Present Value INDES | B/A | 41.30 | 53.70 | 43.93 | ||||||
| 5. Payback Period | ||||||||||
| A | B | C | ||||||||
| Intial Investment | A | 76200 | 51400 | 64600 | ||||||
| Annual Net Cash Flow (with overhaul cost) | B | 491000 | 422000 | 463000 | ||||||
| Payback Period | A/B | 0.16 | 0.12 | 0.14 | ||||||
| Year | Year | Year | ||||||||
ekkarill92 answered 1 year agoRelated Solutions
PAYBACK, ACCOUNTING RATE OF RETURN, PRESENT VALUE, NET PRESENT VALUE, INTERNAL RATE OF RETURN All four...
PAYBACK, ACCOUNTING RATE OF RETURN, PRESENT VALUE, NET
PRESENT VALUE, INTERNAL RATE OF RETURN
All four parts are independent of all other parts. Assume that
all cash flows are after-tax cash flows:
a. Randy Willis is
considering investing in one of the following two projects. Either
project will require an investment of $10,000. The expected cash
flows for the two projects follow. Assume that each project is
depreciable.
Year Project
A Project B
1
$ 3,000
$3,000
2 ...
Accounting Rate of Return Payback Period Net Present Value Internal Rate of Return Profitability Index 1)...
Accounting Rate of Return Payback Period Net Present Value
Internal Rate of Return Profitability Index 1) Select three of the
analytical tools and provide supportive statements explaining how
each can be used to screen and/or rank future available projects.
2) Select one of the analytical tools listed and provide supportive
statements explaining why you believe it provides the most
important information in the decision process.
Calculate the discounted payback, net present value, and internal rate of return for the following cash...
Calculate the discounted payback, net present value, and
internal rate of return for the following cash flows. -60, -50, 6,
45, 60, 70, 60, 45, 20. Discount rate at 7%. Please show work for
the internal rate of return calculation.
PA11-1 Calculating Accounting Rate of Return, Payback Period, Net Present Value, Estimating Internal Rate of Return...
PA11-1 Calculating Accounting Rate of Return, Payback Period,
Net Present Value, Estimating Internal Rate of Return [LO 11-1,
11-2, 11-3, 11-4]
Balloons By Sunset (BBS) is considering the purchase of two new
hot air balloons so that it can expand its desert sunset tours.
Various information about the proposed investment
follows:
Initial investment (for two hot
air balloons)
$
402,000
Useful life
9
years
Salvage value
$
51,000
Annual net income generated
34,572
BBS’s cost of capital
8
%
Assume...
PA11-1 Calculating Accounting Rate of Return, Payback Period, Net Present Value, Estimating Internal Rate of Return...
PA11-1 Calculating Accounting Rate of Return, Payback Period,
Net Present Value, Estimating Internal Rate of Return [LO 11-1,
11-2, 11-3, 11-4]
Balloons By Sunset (BBS) is considering the purchase of two new
hot air balloons so that it can expand its desert sunset tours.
Various information about the proposed investment
follows:
Initial investment (for two hot air balloons)
$
332,000
Useful life
6
years
Salvage value
$
50,000
Annual net income generated
30,876
BBS’s cost of capital
10
%
Assume...
PA11-1 Calculating Accounting Rate of Return, Payback Period, Net Present Value, Estimating Internal Rate of Return...
PA11-1 Calculating Accounting Rate of Return, Payback Period,
Net Present Value, Estimating Internal Rate of Return [LO 11-1,
11-2, 11-3, 11-4]
Balloons By Sunset (BBS) is considering the purchase of two new
hot air balloons so that it can expand its desert sunset tours.
Various information about the proposed investment
follows:
Initial investment (for two hot air balloons)
$
402,000
Useful life
9
years
Salvage value
$
42,000
Annual net income generated
35,778
BBS’s cost of capital
10
%
Assume...
PA11-1 Calculating Accounting Rate of Return, Payback Period, Net Present Value, Estimating Internal Rate of Return...
PA11-1 Calculating Accounting Rate of Return, Payback Period,
Net Present Value, Estimating Internal Rate of Return [LO 11-1,
11-2, 11-3, 11-4]
Balloons By Sunset (BBS) is considering the purchase of two new
hot air balloons so that it can expand its desert sunset tours.
Various information about the proposed investment
follows:
Initial investment (for two hot
air balloons)
$
437,000
Useful life
9
years
Salvage value
$
41,000
Annual net income generated
39,767
BBS’s cost of capital
10
%
Assume...
PA11-1 Calculating Accounting Rate of Return, Payback Period, Net Present Value, Estimating Internal Rate of Return...
PA11-1 Calculating Accounting Rate of Return, Payback Period,
Net Present Value, Estimating Internal Rate of Return [LO 11-1,
11-2, 11-3, 11-4]
Balloons By Sunset (BBS) is considering the purchase of two new
hot air balloons so that it can expand its desert sunset tours.
Various information about the proposed investment follows:
Initial investment (for two hot air balloons)
$ 432,000
Useful life 9 years
Salvage value $ 45,000
Annual net income generated
37,152 ...
PA11-1 Calculating Accounting Rate of Return, Payback Period, Net Present Value, Estimating Internal Rate of Return...
PA11-1 Calculating Accounting Rate of Return, Payback Period,
Net Present Value, Estimating Internal Rate of Return [LO 11-1,
11-2, 11-3, 11-4]
Balloons By Sunset (BBS) is considering the purchase of two new
hot air balloons so that it can expand its desert sunset tours.
Various information about the proposed investment
follows:
Initial investment (for two hot air balloons)
$
529,000
Useful life
9
years
Salvage value
$
43,000
Annual net income generated
48,139
BBS’s cost of capital
9
%
Assume...
PAYBACK, ACCOUNTING RATE OF RETURN, NET PRESENT VALUE, INTERNAL RATE OF RETURN Ripit Company wants to...
PAYBACK, ACCOUNTING RATE OF RETURN, NET PRESENT VALUE,
INTERNAL RATE OF RETURN
Ripit Company wants to buy a numerically controlled (NC) machine
to be used in producing specially machined parts for manufacturers
of tractors The outlay required is $480,000. The NC equipment will
last five years with no expected salvage value. The expected
after-tax cash flows associated with the project follow:
Year
Cash Revenues Cash Expenses
1
$780,000
$600,000
2
780,000
600,000
3
780,000 ...
ADVERTISEMENT
ADVERTISEMENT
Latest Questions
- The current asset section of the Excalibur Tire Company’s balance sheet consists of cash, marketable securities,...
- Write a program that uses a two-dimensional array to store the highest and lowest temperatures for...
- Question 1. What aspects of Michelangelo’s David (1501-1504) are characteristic of Italian Renaissance art? Question 2....
- I cant not seem to get this right. I have tried and tried can I please...
- By using Java language, Complete the StackArray.java by using.stackArrayDemo.java. 1.Read the StackArrayDemo.java. 2. Use the demo...
- Regardless of the legal issues, do you feel it is fair for an employer to require...
- An investor believes that there will be a big jump in a stock price, but is...
ADVERTISEMENT