How to calculate the payback period in excel (can you provide the excel formula) year 0 1
Fantastic news! We've Found the answer you've been seeking!
Question:
How to calculate the payback period in excel (can you provide the excel formula)
Transcribed Image Text:
year 0 1 2 3 4 5 6 7 NPV IRR B/C PB K K K K K K K K K K TR Cash flow 10,139,700,000.00 K 2,614,800,000.00 K -7,524,900,000.00 801,600,000.00 K 2,614,800,000.00 K 1,813,200,000.00 834,000,000.00 K 2,614,800,000.00 K 1,780,800,000.00 866,400,000.00 K 2,614,800,000.00 K 1,748,400,000.00 920,400,000.00 K 2,614,800,000.00 K 1,694,400,000.00 952,800,000.00 K 2,614,800,000.00 K 1,662,000,000.00 K 2,614,800,000.00 K 1,608,000,000.00 K 2,614,800,000.00 K 1,575,600,000.00 K 20,918,400,000.00 TC 1,006,800,000.00 1,039,200,000.00 16,560,900,000.00 814,273,219.76 13% 1.26 Discount rate 10% 1.0000 K 0.9091 K 0.8264 K 0.7513 K 0.6830 K 0.6209 0.5645 K 0.5132 *** K PV -7,524,900,000.00 1,648,363,636.36 1,471,735,537.19 accumulated cash flow K -7,524,900,000.00 K -5,876,536,363.64 K 4,404,800,826.45 1,313,598,797.90 K -3,091,202,028.55 1,157,297,998.77 K -1,933,904,029.78 1,031,971,238.92 -901,932,790.86 907,674,079.53 K 808,531,931.08 5,741,288.67 814,273,219.76 K K year 0 1 2 3 4 5 6 7 NPV IRR B/C PB K K K K K K K K K K TR Cash flow 10,139,700,000.00 K 2,614,800,000.00 K -7,524,900,000.00 801,600,000.00 K 2,614,800,000.00 K 1,813,200,000.00 834,000,000.00 K 2,614,800,000.00 K 1,780,800,000.00 866,400,000.00 K 2,614,800,000.00 K 1,748,400,000.00 920,400,000.00 K 2,614,800,000.00 K 1,694,400,000.00 952,800,000.00 K 2,614,800,000.00 K 1,662,000,000.00 K 2,614,800,000.00 K 1,608,000,000.00 K 2,614,800,000.00 K 1,575,600,000.00 K 20,918,400,000.00 TC 1,006,800,000.00 1,039,200,000.00 16,560,900,000.00 814,273,219.76 13% 1.26 Discount rate 10% 1.0000 K 0.9091 K 0.8264 K 0.7513 K 0.6830 K 0.6209 0.5645 K 0.5132 *** K PV -7,524,900,000.00 1,648,363,636.36 1,471,735,537.19 accumulated cash flow K -7,524,900,000.00 K -5,876,536,363.64 K 4,404,800,826.45 1,313,598,797.90 K -3,091,202,028.55 1,157,297,998.77 K -1,933,904,029.78 1,031,971,238.92 -901,932,790.86 907,674,079.53 K 808,531,931.08 5,741,288.67 814,273,219.76 K K
Expert Answer:
Answer rating: 100% (QA)
To calculate the payback period in Excel you can use a formula that considers the initial investment ... View the full answer
Related Book For
Posted Date:
Students also viewed these finance questions
-
8. Reselect all cases. Then select only those cases for which X < 2, Y < 2, and Z < 2. Report the mean value of M for this sub-sample. O 1.31 O 0.375 O 840 3.36 Question 9 Q09. Reselect all cases....
-
After completing the Blue Ray Excel Simulation (as shown in class), you will write a brief response about your experience and submit it in Bb Learn. The Excel file needed, is attached here....
-
Financial planners may make broad assumptions when building a retirement plan for their clients. This exercise is intended to show one danger in making a blind general assumption when designing a...
-
Find the indicated quantities for the appropriate arithmetic sequence. The sum of the angles inside a triangle, quadrilateral, and pentagon are 180, 360, and 540, respectively. Assuming this pattern...
-
A system consists of a thin charged wire ring of radius and a very long uniformly charged thread oriented along the axis of the ring, with one of its ends coinciding with the centre of the ring. The...
-
Explain the read uncommitted isolation level. Give an example of its use.
-
In many corporations, managers are asked not to pursue blindly their quantitative goals, but to 'do what's best for the company' in taking their decision. Is this a motivational contract? If not, why...
-
Using the information in Problem 3-9A, complete the following: In problem 3-9A 1. Set up balance column accounts for Rainmaker Environmental Consultants and enter the balances listed in the...
-
= Week 3 Homework Question 20 of 20 (1 point) Question Attempt: 2 of Unlimited 8 9 10 11 12 13 14 15 16 17 18 19 A researcher believes that about 72% of the seeds planted with the aid of a new...
-
Mr. M has been employed as an engineer by A Ltd., a company incorporated in Hong Kong. During the year ended 31 March 2019, Mr. M had the following income and expenditure. A monthly salary of...
-
2. Consider f(x): (x+2)(x+5) a. (2 pts) Find the domain of f(x). Give your answer in interval notation. (2 pts) State any vertical asymptotes. Remember, vertical asymptotes should be written as an...
-
Questions based on the following scenario. Questions 1. If General Hospital implemented a new online patient portal that allowed patients to request disclosure of their medical information online,...
-
You're about to buy a new car for $10,000. The dealer offers you a one-year loan where you pay $849.67 every month for the next 12 months. Since you pay $849.67* 12 = $10,196 in total, the dealer...
-
Employment law 2) Robert is diagnosed with diabetes, and you overhear him telling his wife the condition is actually a blessing in disguise, because one he tells his boss he's disabled, he will have...
-
In a scene from a classic cartoon, a hungry coyote is chasing a roadrunner, as shown in the figure below. To aid in his quest, he has donned a pair of ACME brand rocket-propelled roller skates. The...
-
5.29 Given F = AB'D' + A'B+ A'C + CD. (a) Use a Karnaugh map to find the maxterm expression for F (express your answer in both decimal and algebric notation). (b) Use a Karnaugh map to find the...
-
Calculate Anaheim Corporation's excess net passiveincome tax in each of the following alternativescenarios:a. Passive investment income, $100,000;expenses associated with passive investment income 2...
-
On April 29, 2015, Auk Corporation acquires 100% of the outstanding stock of Amazon Corporation (E & P of $750,000) for $1.2 million. Amazon has assets with a fair market value of $1.4 million (basis...
-
Toyz is a large discount toy store in Valley Wood Mall. The store typically has slow sales in the summer months that increase dramatically and rise to a peak at Christmas. During the summer and fall,...
-
When Tracy McCoy wakes up on Saturday morning, she remembers that she promised the PTA she would make some cakes and/or homemade bread for its bake sale that afternoon. However, she does not have...
-
The Matsusaki Company near Nashville, Tennessee, is a direct auto parts supplier for the nearby Neptune auto manufacturing plant. In order to gain a competitive advantage and meet quality...
-
A The relationship between income/cost/volume suggests that there are four ways by which profit can be increased. These are: 1 Increase unit selling price. 2 Decrease unit variable cost. 3 Decrease...
-
A You are employed by Monarch Ltd which manufactures specialist hydraulic seals for the aircraft industry. The company has developed a new seal with the following budgeted data. Certain departmental...
-
Magwitch Limited's finance director produced the following forecast break-even chart for the year ending 31 May 19X1: During the year the company produced and sold 20,000 units, and both revenue and...
Study smarter with the SolutionInn App