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...
-
Young Corporation has bonds on the market with 10.5 years to maturity, a YTM of 6.9 percent, and a current price of $1,070. The bonds make semiannual payments. What must the coupon rate be on the...
-
1. You have been dispatched to 123 Anywhere St. for a neighbour dispute.The complainant is the homeowner, Amanda. As you arrive, Matteo, the basement tenant, is waiting for you outside.Matteo tells...
-
Find the indicated z-score(s) shown in the graph. Area = 0.05 Area = 0.05 z = ? 0 z=? Z
-
Dana Johnson Corp. is considering adding a fourth plant to its three existing facilities in Decatur, Minneapolis, and Carbondale. Both St. Louis and East St. Louis are being considered. Evaluating...
-
Melanie is employed full-time as an accountant for a national hardware chain. She also has recently started a private consulting practice, which provides tax advice and financial planning to the...
-
RZNY, LP., is a calendar-year, cash-basis limited partnership. Marc Liu, an individual, owns a 55% interest in RZNY as a general partner. During Year 1, RZNY had the following results: 1. Sales -...
-
What types of restructuring processes are used to improve production logistics?
-
One of the social trends identified in the chapter is the increasing number of people going back to school or retraining for new jobs. Propose a business idea, which isnt a near duplicate of an idea...
-
The stock of Richmond Corp. is owned 60 percent by Sid and 40 percent by Mark, who are unrelated individuals. During 2018, Sid transferred land (basis of $300,000; EMV of $260,000) as a contribution...
-
Reynolds Corp. acquired the assets of Putvan Corp. in a nontaxable merger transaction on December 1, 2019. On the date of acquisition, Putvan had a net operating loss carryover of $500,000. Reynolds...
-
Prior to being acquired, a transferor corporation spins off its unwanted assets to shareholders. It subsequently transfers its remaining assets to the acquiring corporation solely for voting stock of...
-
Merten Corp. is 100% owned by Carmen. Merten owns one asset, a building worth $550,000 with a $90,000 basis. Carmens stock basis is $150,000. A plan of complete liquidation is adopted. What are the...
-
A company's perpetual preferred stock currently sells for $64.11 per share, and it pays a $2.12 annual dividend. What is the firm's cost of preferred stock? Express your answer as a percent rounded...
-
Havel says the grocer doesnt believe what is on the sign and indeed, he says the grocers customers will barely notice it. But Havel maintains that the sign serves a specific function. How would you...
-
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...
-
How are the identifiable assets and liabilities acquired in a business combination measured?
-
What is meant by deferred consideration and how is it accounted for?
-
Distinguish between a business combination and a non-business acquisition.
Study smarter with the SolutionInn App