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

Problem 3-ABC Challenges: Attrition, Balance and ComplianceCan television inform people about public affairs? Political scientists Bethany Albertson and Adria Lawrence (2009) conducted an experiment in which they randomly assigned people to treatment and control groups to evaluate the effect of watching TV on a person’s information level. Those assigned to the treatment group were told to watch a specific television broadcast and were later asked questions related to what they watched. Those in the controlgroup were not shown the TV broadcast but were asked questions related to the material in the TV broadcast. The dataset contains the following variables: : Dummy variable which =1 if a person reads news and 0 otherwise. : interest in political affairs (not interested=1 to very interested=4) : years of education : female dummy variable (female=1; male=0) : family income in thousands of dollars : information level (low information level=1 to high information level=4) =1 if the…

Problem 2-Experiments/Randomized Control Trial Suppose you are interested in studying the effect of academic counselling on the years it takes for a student to obtain an undergraduate degree. You conduct a randomized control trial to answer the question. You randomly assign 2500 individuals in a university in New York to receive academic counselling and 2500 students to not receive any academic counselling. a. Which people are a part of the treatment group and which people are a part of thecontrol group? b. What regression will you run? Define the variables where required. c. Suppose you estimate = -0.3. Interpret it. d. You test for balance using the variables mentioned in the table below. Based on the results do you think that the treatment and control group are balanced? If your answer is “yes” then explain why. If your answer is “no”, then explain why and mention how will you address the issue of imbalance. e. Suppose that some unmotivated students in the control group decided to…

How to calculate total cost?

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