Question

In: Accounting

Given the following information, calculate the Net Present Value for a capital budget proposal? Show your...

Given the following information, calculate the Net Present Value for a capital budget proposal? Show your work. Machine Cost: $6,000,000 Salvage Value: $50,000 Setup Costs: $45,000 Training Costs: $25,000 Annual maintenance costs: $45,000 Anticipated annual savings: $560,000 Annual labor savings: $25,000 Expected useful life in years: 12 Overhaul costs in year 4: $50,000 Annual operating costs: $25,000 Hurdle rate: 8%

Solutions

Expert Solution

NPV
Initial Investment
Machine Cost $6,000,000.00
Setup Cost $45,000.00
Training Cost $25,000.00
Initial Investment $6,070,000.00
Anticipated annual savings $560,000.00
Annual labor savings $25,000.00
Less:
Annual maintenance costs -$45,000.00
Annual operating costs -$25,000.00
Net Annual Savings $515,000.00
Year Cash Flow PV @ 8% PV
0 -$6,070,000.00 1.0000 -$6,070,000.00
1 $515,000.00 0.9259 $476,851.85
2 $515,000.00 0.8573 $441,529.49
3 $515,000.00 0.7938 $408,823.60
4 $465,000.00 0.7350 $341,788.88
5 $515,000.00 0.6806 $350,500.35
6 $515,000.00 0.6302 $324,537.36
7 $515,000.00 0.5835 $300,497.55
8 $515,000.00 0.5403 $278,238.48
9 $515,000.00 0.5002 $257,628.22
10 $515,000.00 0.4632 $238,544.65
11 $515,000.00 0.4289 $220,874.67
12 $565,000.00 0.3971 $224,369.27
NPV -$2,205,815.63
Year 4 Cash flow = $515000 - 50000 = $465000
Year 12 Cash flow = $515000 + 50000 = $565000

Related Solutions

Given the following information, calculate the Present Value Index for a capital budget proposal. Show your...
Given the following information, calculate the Present Value Index for a capital budget proposal. Show your work. Machine Cost: $6,000,000 Salvage Value: $50,000 Setup Costs: $45,000 Training Costs: $25,000 Annual maintenance costs: $45,000 Anticipated annual savings: $560,000 Annual labor savings: $25,000 Expected useful life in years: 12 Overhaul costs in year 4: $50,000 Annual operating costs: $25,000 Hurdle rate: 8%
Given the following information, calculate the Payback for a capital budget proposal. Show your work. Machine...
Given the following information, calculate the Payback for a capital budget proposal. Show your work. Machine Cost: $6,000,000 Salvage Value: $50,000 Setup Costs: $45,000 Training Costs: $25,000 Annual maintenance costs: $45,000 Anticipated annual savings: $560,000 Annual labor savings: $25,000 Expected useful life in years: 12 Overhaul costs in year 4: $50,000 Annual operating costs: $25,000 Hurdle rate: 8%
Net present value Using a cost of capital of 11​%, calculate the net present value for...
Net present value Using a cost of capital of 11​%, calculate the net present value for the project shown in the following table and indicate whether it is​ acceptable, Initial investment ​(CF 0CF0​) negative 1 comma 143 comma 000−1,143,000 Year ​(t​) Cash inflows ​(CF Subscript tCFt​) 1 $81,000 2 $138,000 3 $193,000 4 $258,000 5 $311,000 6 $377,000 7 $270,000 8 $98,000 9 $45,000 10 $29,000 The net present value​ (NPV) of the project is _____​$ ​(Round to the nearest​...
Net present value. Independent projects Using a 14% cost of capital, calculate the net present value...
Net present value. Independent projects Using a 14% cost of capital, calculate the net present value for each of the independent projects shown in the following table, and indicate whether each is acceptable. Project A Project B Project C Project D Project E Initial investment $26,000 $500,000 $170,000 $950,000 $80,000 Year Cash inflows 1 $4,000 $100,000 $20,000 $230,000 $ 0 2 4,000 120,000 19,000 230,000 0 3 4,000 140,000 18,000 230,000 0 4 4,000 160,000 17,000 230,000 20,000 5 4,000...
Net present value. Independent projects Using a 14% cost of capital, calculate the net present value...
Net present value. Independent projects Using a 14% cost of capital, calculate the net present value for each of the independent projects shown in the following table, and indicate whether each is acceptable. Project A Project B Project C Project D Project E Initial investment $26,000 $500,000 $170,000 $950,000 $80,000 Year Cash inflows 1 $4,000 $100,000 $20,000 $230,000 $ 0 2 4,000 120,000 19,000 230,000 0 3 4,000 140,000 18,000 230,000 0 4 4,000 160,000 17,000 230,000 20,000 5 4,000...
Calculate the amount of the change in net working capital given the following information: The company...
Calculate the amount of the change in net working capital given the following information: The company had current assets of $77,000 and current liabilities of $88,000. One year later, the current assets are $99,000 and the current liabilities are $91,000. The depreciation for the period is $8,800 and the interest paid is $7,700.
Using a cost of capital of 13​%, calculate the net present value for the project shown...
Using a cost of capital of 13​%, calculate the net present value for the project shown in the following table and indicate whether it is​ acceptable, LOADING.... The net present value​ (NPV) of the project is ​$ Initial investment   -1,151,000 Year   Cash inflows 1   84,000 2   136,000 3   192,000 4   255,000 5   318,000 6   382,000 7   277,000 8   100,000 9   42,000 10   25,000
 Using a cost of capital of 11​%, calculate the net present value for the project shown...
 Using a cost of capital of 11​%, calculate the net present value for the project shown in the following table and indicate whether it is​ acceptable, Initial investment ​(CF 0CF0​) negative $−$1149 Year ​(t​) Cash inflows ​(CF Subscript tCFt​) in thousands 1 ​$8080 2 ​$130 3 ​$189 4 ​$256 5 ​$312 6 ​$376 7 ​$280 8 ​$102 9 ​$42 10 ​$20 The net present value​ (NPV) of the project is ​$-75,817.60.  ​(Round to the nearest​ cent.) Is the project​ acceptable?
Using a cost of capital of 11​%, calculate the net present value for the project shown...
Using a cost of capital of 11​%, calculate the net present value for the project shown in the following table and indicate whether it is​ acceptable Initial investment ​(CF 0CF0​) -$1149 Year ​(t​) Cash inflows ​(CF Subscript tCFt​) in thousands 1 ​$80 2 ​$130 3 ​$189 4 ​$256 5 ​$312 6 ​$376 7 ​$280 8 ​$102 9 ​$42 10 ​$20
Using a cost of capital of 15​%, calculate the net present value for the project shown...
Using a cost of capital of 15​%, calculate the net present value for the project shown in the following table and indicate whether it is​ acceptable Initial investment   $-1,145 Year   Cash inflows 1   $76 2   $132 3   $185 4   $256 5   $316 6   $383 7   $277 8   $98 9   $43 10   $25 The net present value​ (NPV) of the project is $_____ Please show all work and what inputs would be in a financial calculator
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT