Calculate the payback period.

Question

Want to see more full solutions like this?

Answer 1

Question

Chapter 13, Problem 32P

(a):

To determine

Calculate the payback period.

(a):

Expert Solution

Explanation of Solution

Investment (C) is $245,000. Expense (AE) is $38,000 per year. Income (AI) is $92,000. MARR (i) is 15%. Salvage value (SV) is 15% of the first cost.

Payback period (n) can be calculated as follows:

(AI−AE)((1+i)n−1i(1+i)n)+SV(1+i)n=C(92,000−38,000)((1+0.15)n−10.15(1+0.15)n)+0.15×245,000(1+0.15)n=245,00054,000((1+0.15)n−10.15(1+0.15)n)+36,750(1+i)n=245,00054,000((1+0.15)n−10.15(1+0.15)n)+36,750(1+i)n=245,000

Substitute n as 7 by trial and error method to verify the time period in the above calculation.

−54,000((1+0.15)7−10.15(1+0.15)7)+36,750(1+0.15)7=−245,000−54,000(2.6600−10.15(2.6600))+36,7502.6600=−245,000−54,000(1.66000.399)+36,7502.6600=−245,000−54,000(4.1604)+13,815.79=−245,000−224,661.6+13,815.79=−245,000−210,845.81<−245,000

Since the calculated present value of the cost is less than the initial cost, increase the payback period to 8.

−54,000((1+0.15)8−10.15(1+0.15)8)+36,750(1+0.15)8=−245,000−54,000(3.05902−10.15(3.05902))+36,7503.05902=−245,000−54,000(2.059020.45885)+12,013.65=−245,000−54,000×4.4873+12,013.65=−245,000−242,314.2+12,013.65=−245,000−230,300.55≈−245,000

Since the calculated value is nearly equal to the initial cost, it is verified that the payback period is 8 years.

(b):

To determine

Calculate the payback period using spreadsheet.

(b):

Expert Solution

Explanation of Solution

The spreadsheet function for payback period is given below:

= NPER(15%,54000,-245000,0.15*245000)

The above function gives the value of 7.4 years.

Want to see more full solutions like this?

Subscribe now to access step-by-step solutions to millions of textbook problems written by subject matter experts!

Students have asked these similar questions

A linear programming computer package is needed. As part of the settlement for a class action lawsuit, Hoxworth Corporation must provide sufficient cash to make the following annual payments (in thousands of dollars). Year 1 2 3 4 5 6 Payment 170 195 220 265 295 440 The annual payments must be made at the beginning of each year. The judge will approve an amount that, along with earnings on its investment, will cover the annual payments. Investment of the funds will be limited to savings (at 4% annually) and government securities, at prices and rates currently quoted in The Wall Street Journal. Hoxworth wants to develop a plan for making the annual payments by investing in the following securities (par value = $1,000). Funds not invested in these securities will be placed in savings. Security Current Price Rate (%) Years to Maturity 1 $1,055 6.750 3 2 $1,000 5.125 4 Assume that interest is paid annually. The plan will be submitted to the judge and, if approved,…

On the 1st of April 2018, the South African National Treasury increase the value-added tax rate from 14% to 15%. This policy change had a wide-ranging impact on society. Discuss some of the benefits and drawbacks of making use of this type of tax to generate government revenue and what we may expect in terms of its impact on inflation and GDP growth within the economy. Please use some of the economics graphs to explain some scenarios

Eskom is South Africa’s monopoly power producer which the majority of South Africans depend on. Suppose there is extensive deregulation in the power industry. What is the impact of this deregulation on the industry? Help me on discussing the new market structure as well as the impact on supply and demand. Use the relevant diagrams.

Answer 2

Question

Chapter 13, Problem 32P

(a):

To determine

Calculate the payback period.

(a):

Expert Solution

Explanation of Solution

Investment (C) is $245,000. Expense (AE) is $38,000 per year. Income (AI) is $92,000. MARR (i) is 15%. Salvage value (SV) is 15% of the first cost.

Payback period (n) can be calculated as follows:

(AI−AE)((1+i)n−1i(1+i)n)+SV(1+i)n=C(92,000−38,000)((1+0.15)n−10.15(1+0.15)n)+0.15×245,000(1+0.15)n=245,00054,000((1+0.15)n−10.15(1+0.15)n)+36,750(1+i)n=245,00054,000((1+0.15)n−10.15(1+0.15)n)+36,750(1+i)n=245,000

Substitute n as 7 by trial and error method to verify the time period in the above calculation.

−54,000((1+0.15)7−10.15(1+0.15)7)+36,750(1+0.15)7=−245,000−54,000(2.6600−10.15(2.6600))+36,7502.6600=−245,000−54,000(1.66000.399)+36,7502.6600=−245,000−54,000(4.1604)+13,815.79=−245,000−224,661.6+13,815.79=−245,000−210,845.81<−245,000

Since the calculated present value of the cost is less than the initial cost, increase the payback period to 8.

−54,000((1+0.15)8−10.15(1+0.15)8)+36,750(1+0.15)8=−245,000−54,000(3.05902−10.15(3.05902))+36,7503.05902=−245,000−54,000(2.059020.45885)+12,013.65=−245,000−54,000×4.4873+12,013.65=−245,000−242,314.2+12,013.65=−245,000−230,300.55≈−245,000

Since the calculated value is nearly equal to the initial cost, it is verified that the payback period is 8 years.

(b):

To determine

Calculate the payback period using spreadsheet.

(b):

Expert Solution

Explanation of Solution

The spreadsheet function for payback period is given below:

= NPER(15%,54000,-245000,0.15*245000)

The above function gives the value of 7.4 years.

Want to see more full solutions like this?

Subscribe now to access step-by-step solutions to millions of textbook problems written by subject matter experts!

Answer 3

Question

Chapter 13, Problem 32P

(a):

To determine

Calculate the payback period.

(a):

Expert Solution

Explanation of Solution

Investment (C) is $245,000. Expense (AE) is $38,000 per year. Income (AI) is $92,000. MARR (i) is 15%. Salvage value (SV) is 15% of the first cost.

Payback period (n) can be calculated as follows:

(AI−AE)((1+i)n−1i(1+i)n)+SV(1+i)n=C(92,000−38,000)((1+0.15)n−10.15(1+0.15)n)+0.15×245,000(1+0.15)n=245,00054,000((1+0.15)n−10.15(1+0.15)n)+36,750(1+i)n=245,00054,000((1+0.15)n−10.15(1+0.15)n)+36,750(1+i)n=245,000

Substitute n as 7 by trial and error method to verify the time period in the above calculation.

−54,000((1+0.15)7−10.15(1+0.15)7)+36,750(1+0.15)7=−245,000−54,000(2.6600−10.15(2.6600))+36,7502.6600=−245,000−54,000(1.66000.399)+36,7502.6600=−245,000−54,000(4.1604)+13,815.79=−245,000−224,661.6+13,815.79=−245,000−210,845.81<−245,000

Since the calculated present value of the cost is less than the initial cost, increase the payback period to 8.

−54,000((1+0.15)8−10.15(1+0.15)8)+36,750(1+0.15)8=−245,000−54,000(3.05902−10.15(3.05902))+36,7503.05902=−245,000−54,000(2.059020.45885)+12,013.65=−245,000−54,000×4.4873+12,013.65=−245,000−242,314.2+12,013.65=−245,000−230,300.55≈−245,000

Since the calculated value is nearly equal to the initial cost, it is verified that the payback period is 8 years.

(b):

To determine

Calculate the payback period using spreadsheet.

(b):

Expert Solution

Explanation of Solution

The spreadsheet function for payback period is given below:

= NPER(15%,54000,-245000,0.15*245000)

The above function gives the value of 7.4 years.

Want to see more full solutions like this?

Subscribe now to access step-by-step solutions to millions of textbook problems written by subject matter experts!

Answer 4

Question

Chapter 13, Problem 32P

(a):

To determine

Calculate the payback period.

(a):

Expert Solution

Explanation of Solution

Investment (C) is $245,000. Expense (AE) is $38,000 per year. Income (AI) is $92,000. MARR (i) is 15%. Salvage value (SV) is 15% of the first cost.

Payback period (n) can be calculated as follows:

(AI−AE)((1+i)n−1i(1+i)n)+SV(1+i)n=C(92,000−38,000)((1+0.15)n−10.15(1+0.15)n)+0.15×245,000(1+0.15)n=245,00054,000((1+0.15)n−10.15(1+0.15)n)+36,750(1+i)n=245,00054,000((1+0.15)n−10.15(1+0.15)n)+36,750(1+i)n=245,000

Substitute n as 7 by trial and error method to verify the time period in the above calculation.

−54,000((1+0.15)7−10.15(1+0.15)7)+36,750(1+0.15)7=−245,000−54,000(2.6600−10.15(2.6600))+36,7502.6600=−245,000−54,000(1.66000.399)+36,7502.6600=−245,000−54,000(4.1604)+13,815.79=−245,000−224,661.6+13,815.79=−245,000−210,845.81<−245,000

Since the calculated present value of the cost is less than the initial cost, increase the payback period to 8.

−54,000((1+0.15)8−10.15(1+0.15)8)+36,750(1+0.15)8=−245,000−54,000(3.05902−10.15(3.05902))+36,7503.05902=−245,000−54,000(2.059020.45885)+12,013.65=−245,000−54,000×4.4873+12,013.65=−245,000−242,314.2+12,013.65=−245,000−230,300.55≈−245,000

Since the calculated value is nearly equal to the initial cost, it is verified that the payback period is 8 years.

(b):

To determine

Calculate the payback period using spreadsheet.

(b):

Expert Solution

Explanation of Solution

The spreadsheet function for payback period is given below:

= NPER(15%,54000,-245000,0.15*245000)

The above function gives the value of 7.4 years.

Want to see more full solutions like this?

Subscribe now to access step-by-step solutions to millions of textbook problems written by subject matter experts!

Answer 5

Chapter 13, Problem 32P

(a):

To determine

Calculate the payback period.

(a):

Expert Solution

Explanation of Solution

Investment (C) is $245,000. Expense (AE) is $38,000 per year. Income (AI) is $92,000. MARR (i) is 15%. Salvage value (SV) is 15% of the first cost.

Payback period (n) can be calculated as follows:

(AI−AE)((1+i)n−1i(1+i)n)+SV(1+i)n=C(92,000−38,000)((1+0.15)n−10.15(1+0.15)n)+0.15×245,000(1+0.15)n=245,00054,000((1+0.15)n−10.15(1+0.15)n)+36,750(1+i)n=245,00054,000((1+0.15)n−10.15(1+0.15)n)+36,750(1+i)n=245,000

Substitute n as 7 by trial and error method to verify the time period in the above calculation.

−54,000((1+0.15)7−10.15(1+0.15)7)+36,750(1+0.15)7=−245,000−54,000(2.6600−10.15(2.6600))+36,7502.6600=−245,000−54,000(1.66000.399)+36,7502.6600=−245,000−54,000(4.1604)+13,815.79=−245,000−224,661.6+13,815.79=−245,000−210,845.81<−245,000

Since the calculated present value of the cost is less than the initial cost, increase the payback period to 8.

−54,000((1+0.15)8−10.15(1+0.15)8)+36,750(1+0.15)8=−245,000−54,000(3.05902−10.15(3.05902))+36,7503.05902=−245,000−54,000(2.059020.45885)+12,013.65=−245,000−54,000×4.4873+12,013.65=−245,000−242,314.2+12,013.65=−245,000−230,300.55≈−245,000

Since the calculated value is nearly equal to the initial cost, it is verified that the payback period is 8 years.

(b):

To determine

Calculate the payback period using spreadsheet.

(b):

Expert Solution

Explanation of Solution

The spreadsheet function for payback period is given below:

= NPER(15%,54000,-245000,0.15*245000)

The above function gives the value of 7.4 years.

Answer 6

Chapter 13, Problem 32P

(a):

To determine

Calculate the payback period.

(a):

Expert Solution

Explanation of Solution

Investment (C) is $245,000. Expense (AE) is $38,000 per year. Income (AI) is $92,000. MARR (i) is 15%. Salvage value (SV) is 15% of the first cost.

Payback period (n) can be calculated as follows:

(AI−AE)((1+i)n−1i(1+i)n)+SV(1+i)n=C(92,000−38,000)((1+0.15)n−10.15(1+0.15)n)+0.15×245,000(1+0.15)n=245,00054,000((1+0.15)n−10.15(1+0.15)n)+36,750(1+i)n=245,00054,000((1+0.15)n−10.15(1+0.15)n)+36,750(1+i)n=245,000

Substitute n as 7 by trial and error method to verify the time period in the above calculation.

−54,000((1+0.15)7−10.15(1+0.15)7)+36,750(1+0.15)7=−245,000−54,000(2.6600−10.15(2.6600))+36,7502.6600=−245,000−54,000(1.66000.399)+36,7502.6600=−245,000−54,000(4.1604)+13,815.79=−245,000−224,661.6+13,815.79=−245,000−210,845.81<−245,000

Since the calculated present value of the cost is less than the initial cost, increase the payback period to 8.

−54,000((1+0.15)8−10.15(1+0.15)8)+36,750(1+0.15)8=−245,000−54,000(3.05902−10.15(3.05902))+36,7503.05902=−245,000−54,000(2.059020.45885)+12,013.65=−245,000−54,000×4.4873+12,013.65=−245,000−242,314.2+12,013.65=−245,000−230,300.55≈−245,000

Since the calculated value is nearly equal to the initial cost, it is verified that the payback period is 8 years.

Answer 7

Chapter 13, Problem 32P

(a):

To determine

Calculate the payback period.

Answer 8

(a):

Expert Solution

Explanation of Solution

Investment (C) is $245,000. Expense (AE) is $38,000 per year. Income (AI) is $92,000. MARR (i) is 15%. Salvage value (SV) is 15% of the first cost.

Payback period (n) can be calculated as follows:

(AI−AE)((1+i)n−1i(1+i)n)+SV(1+i)n=C(92,000−38,000)((1+0.15)n−10.15(1+0.15)n)+0.15×245,000(1+0.15)n=245,00054,000((1+0.15)n−10.15(1+0.15)n)+36,750(1+i)n=245,00054,000((1+0.15)n−10.15(1+0.15)n)+36,750(1+i)n=245,000

Substitute n as 7 by trial and error method to verify the time period in the above calculation.

−54,000((1+0.15)7−10.15(1+0.15)7)+36,750(1+0.15)7=−245,000−54,000(2.6600−10.15(2.6600))+36,7502.6600=−245,000−54,000(1.66000.399)+36,7502.6600=−245,000−54,000(4.1604)+13,815.79=−245,000−224,661.6+13,815.79=−245,000−210,845.81<−245,000

Since the calculated present value of the cost is less than the initial cost, increase the payback period to 8.

−54,000((1+0.15)8−10.15(1+0.15)8)+36,750(1+0.15)8=−245,000−54,000(3.05902−10.15(3.05902))+36,7503.05902=−245,000−54,000(2.059020.45885)+12,013.65=−245,000−54,000×4.4873+12,013.65=−245,000−242,314.2+12,013.65=−245,000−230,300.55≈−245,000

Since the calculated value is nearly equal to the initial cost, it is verified that the payback period is 8 years.

Answer 9

(a):

Expert Solution

Answer 10

(a):

Expert Solution

Answer 11

Expert Solution

Answer 12

(b):

To determine

Calculate the payback period using spreadsheet.

(b):

Expert Solution

Explanation of Solution

The spreadsheet function for payback period is given below:

= NPER(15%,54000,-245000,0.15*245000)

The above function gives the value of 7.4 years.

Answer 13

(b):

To determine

Calculate the payback period using spreadsheet.

Answer 14

(b):

Expert Solution

Explanation of Solution

The spreadsheet function for payback period is given below:

= NPER(15%,54000,-245000,0.15*245000)

The above function gives the value of 7.4 years.

Answer 15

(b):

Expert Solution

Answer 16

(b):

Expert Solution

Answer 17

Expert Solution

Answer 18

Ch. 13 - Prob. 1P Ch. 13 - Prob. 2P Ch. 13 - Prob. 3P Ch. 13 - Prob. 4P Ch. 13 - Prob. 5P Ch. 13 - Prob. 6P Ch. 13 - Prob. 7P Ch. 13 - Prob. 8P Ch. 13 - Prob. 9P Ch. 13 - Prob. 10P

Calculate the payback period.

Calculate the payback period.

Explanation of Solution

Calculate the payback period using spreadsheet.

Explanation of Solution

Want to see more full solutions like this?

Chapter 13 Solutions