Answers:
a.
Payback Period | ||
Project F | 2.46 | years |
Project G | 3.20 | years |
b.
Net Present Value | |
Project F | $ 54,654.14 |
Project G | $ 71,529.91 |
Notes:
a. Payback Period = ( Last Year with a Negative Cash Flow ) + [( Absolute Value of negative Cash Flow in that year)/ Total Cash Flow in the following year)]
Project F , Payback Period = 2+ (28000/61500)
= 2.46 Years
Note:
Year | Investment | Cash Inflow | Net Cash Flow | |
0 | -1,38,000.00 | - | -1,38,000 | (Investment + Cash Inflow) |
1 | - | 58,500.00 | -79,500 | (Net Cash Flow + Cash Inflow) |
2 | - | 51,500.00 | -28,000 | (Net Cash Flow + Cash Inflow) |
3 | - | 61,500.00 | 33,500 | (Net Cash Flow + Cash Inflow) |
4 | - | 56,500.00 | 90,000 | (Net Cash Flow + Cash Inflow) |
5 | - | 51,500.00 | 1,41,500 | (Net Cash Flow + Cash Inflow) |
Project G, Payback Period = 3+24,500/121,500
= 3.20 years
Note:
Year | Investment | Cash Inflow | Net Cash Flow | |
0 | -2,08,000.00 | - | -2,08,000 | (Investment + Cash Inflow) |
1 | - | 38,500.00 | -1,69,500 | (Net Cash Flow + Cash Inflow) |
2 | - | 53,500.00 | -1,16,000 | (Net Cash Flow + Cash Inflow) |
3 | - | 91,500.00 | -24,500 | (Net Cash Flow + Cash Inflow) |
4 | - | 1,21,500.00 | 97,000 | (Net Cash Flow + Cash Inflow) |
5 | - | 1,36,500.00 | 2,33,500 | (Net Cash Flow + Cash Inflow) |
----------
b. Net Present Value = Present Value of Cash Inflows - Present Value of Cash Outflows
Project F:
Net Present Value = [58500*1/(1.14)^1+51500*1/(1.14)^2+61500*1/(1.14)^3+56500*1/(1.14)^4+51500*1/(1.14)^5]-138000
= $ 54,654.14
Project G:
Net Present Value = [38500*1/(1.14)^1+53500*1/(1.14)^2+91500*1/(1.14)^3+121500*1/(1.14)^4+136500*1/(1.14)^5 ]-208000
= $ 71,529.91
Year Kaleb Konstruction, Inc., has the following mutually exclusive projects available. The company has historically used...
Kaleb Konstruction, Inc., has the following mutually exclusive projects available. The company has historically used a three year cutoff for projects. The required return is 10 percent. Year U AWN- Project F -$ 195,000 98,400 86,300 81,600 72,000 64,800 Project G $298,000 71,600 94,500 123,600 166,800 187,200 a. Calculate the payback period for both projects. (Do not round intermediate calculations and round your answers to 2 decimal places, e.g., 32.16.) b. Calculate the NPV for both projects. (Do not round...
Kaleb Konstruction, Inc., has the following mutually exclusive projects available. The company has historically used a three-year cutoff for projects. The required return is 10 percent. Year Project F Project G o-NM $140,000 57,500 52,500 62,500 57,500 52,500 $210,000 37,500 52,500 92,500 122,500 137,500 a. Calculate the payback period for both projects. (Do not round intermediate calculations and round your answers to 2 decimal places, e.g., 32.16.) b. Calculate the NPV for both projects. (Do not round intermediate calculations and...
Kaleb Konstruction, Inc., has the following mutually exclusive projects available. The company has historically used a three-year cutoff for projects. The required return is 13 percent Year Project FProject G -S127,000 197,000 44,000 59.000 86,000 116,000 131,000 64,000 46,000 56,000 51,000 46,000 a. Calculate the payback period for both projects. (Do not round intermediate calculations and round your answers to 2 decimal places, e.g., 32.16.) Project F Project G years years b. Calculate the NPV for both projects. (Do not...
Kaleb Konstruction, Inc., has the following mutually exclusive projects available. The company has historically used a three year cutoff for projects. The required return is 10 percent. Year Project F Project G 0 –$ 195,000 –$ 298,000 1 98,400 71,600 2 86,300 94,500 3 81,600 123,600 4 72,000 166,800 5 64,800 187,200 a. Calculate the payback period for both projects. (Do not round intermediate calculations and round your answers to 2 decimal places, e.g., 32.16.) b. Calculate the NPV for...
Please include formulas Problem 8-21 NPV and Payback Period [LO 1, 4] Kaleb Konstruction, Inc., has the following mutually exclusive projects available. The company has historically used a three-year cutoff for projects. The required return is 11 percent. Year WN Project F -$ 144,000 55,500 54,500 64,500 59,500 54,500 Project G -$ 214,000 35,500 50.500 94,500 124,500 139,500 Required: (a) Calculate the payback period for both projects. (Do not round intermediate calculations. Round your answers to 2 decimal places (e.g.,...
please round the numbers to 2 decimal places Problem 8-21 NPV and Payback Period (LO 1, 4] Kaleb Konstruction, Inc., has the following mutually exclusive projects available. The company has historically used a three-year cutoff for projects. The required return is 10 percent Year Project F Project G O-NM $140,000 57,500 52,500 62,500 57,500 52,500 $210,000 37,500 52,500 92,500 122,500 137,500 a. Calculate the payback period for both projects. (Do not round intermediate calculations and round your answers to 2...
Consider the following two mutually exclusive projects Year Cash Flow (A) Cash Flow (B) -422,000 - 38,500 45,500 60,500 77,500 537,000 20,100 13,600 17,100 13,900 2 The required return on these investments is 13 percent. a. What is the payback period for each project? (Do not round intermediate calculations and round your answers to 2 decimal places, e.g., 32.16.) Payback period Project A Project B years years b. What is the NPV for each project? (Do not round intermediate calculations...
Novell, Inc., has the following mutually exclusive projects. Year Project A Project B 0 –$21,000 –$24,000 1 12,500 13,500 2 9,000 10,000 3 3,000 9,000 a-1. Calculate the payback period for each project. (Do not round intermediate calculations and round your answers to 3 decimal places, e.g., 32.161.) a-2. If the company's payback period is two years, which, if either, of these projects should be chosen? Project A Project B...
Novell, Inc., has the following mutually exclusive projects. Year Project A Project B 0 –$16,000 –$19,000 1 10,000 11,000 2 6,500 7,500 3 2,500 6,500 a-1. Calculate the payback period for each project. (Do not round intermediate calculations and round your answers to 3 decimal places, e.g., 32.161.) a-2. If the company's payback period is two years, which, if either, of these projects should be chosen? Project A Project...
Tri Star, Inc., has the following mutually exclusive projects: Year Project A -$13,900 8,500 7,100 2,100 Project B -$9,300 4,000 3,500 5,900 Calculate the payback period for each project. (Do not round intermediate calculations and round your answers to 2 decimal places, e.g., 32.16.) Project A Project B Payback Period 1.76 years 2.932 years