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...
-
What is treasury stock? Why is it deducted from stockholders equity?
-
Which of the following best exemplifies the truth mentioned in line 18? A) Many great artists find it difficult to achieve renown in their own lifetimes. B) Painters and musicians from all cultures...
-
If the probability of event A is p, then the odds that it will occur are given by the ratio of p to 1p. Odds are usually given as a ratio of two positive integers having no common factor, and if an...
-
Transactions related to revenue and cash receipts completed by Main Line Inc. during the month of August 2012 are as follows: Aug. 2. Issued Invoice No. 512 to Boston Co., $780. 4. Received cash from...
-
Question C5 [7.5 marks]: The Hastelloy-X plate stock cost from the supplier is $61 /kg and has a material density of 8,220 kg/m3 . The recoverable cost of scrap Hastelloy-X machining chips is $7.8...
-
In your final project, you will assume the role of an accountant and complete the year-end adjustment process for your company using a provided workbook. This workbook is the first deliverable (Part...
-
A bond is available for purchase that has a face value of $ 2000, a 6.50% coupon payable semiannually, and 10 years of its original 30 years left of maturity. Approximately how much would you pay for...
-
Speculate about the level of technology available across countries. Do you think that better health care is available in the United States than in Canada? Do international health indices suggest...
-
Consider the parameters R, S, S, w, and C(I) in equation (24.1). Find and explain the effect of an increase in each one. II S.R(S)-w-C(I) (24.1)
-
What could cause strain softening and strain hardening in a deforming rock?
-
What is the difference between syntaxial and antitaxial veins?
-
Would the damage zone be visible on good 3-D seismic data?
-
The half year call choice has a strike cost of $38. On the off chance that the stock has a standard deviation of 0.15 and the constant danger free rate is 4%, what is the Black-Scholes delta of this...
-
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 political pollster approaches people on the street and asks them to describe their political affiliation. Twenty-eight people describe themselves as Democrats, 25 as Republicans, 8 people provide a...
-
Listed below are a number of hypothetical research hypotheses. For each hypothesis, identify the independent and dependent variable. a. Male drivers are more likely to exhibit road rage behaviors...
-
Listed below are a number of research questions and hypotheses from actual published articles. For each hypothesis, identify the independent and dependent variable. a. The use of color in a Yellow...
Study smarter with the SolutionInn App