Question
Calculating Profitability Index What is the profitability index for the following set of cash flows if...
Calculating Profitability Index What is the profitability index for the following set of cash flows if the relevant discount rate is 10 percent? What if the discount rate is 15 percent? If it is 22 percent? Year Cash Flow -$29,500 16,900 13,600 8,300
Answers
To calculate the PI, we need to calculate the NPV:
When discount rate = 10%
Year CF Discount Factor Discounted CF 0 $ -29,500.00 1/(1+0.1)^0= 1 1*-29500= $ -29,500.00 1 $ 16,900.00 1/(1+0.1)^1= 0.909090909 0.909090909090909*16900= $ 15,363.64 2 $ 13,600.00 1/(1+0.1)^2= 0.826446281 0.826446280991735*13600= $ 11,239.67 3 $ 8,300.00 1/(1+0.1)^3= 0.751314801 0.751314800901578*8300= $ 6,235.91 NPV = Sum of all Discounted CF $ 3,339.22 Profitability Index 1.11
When discount rate = 15%
Year CF Discount Factor Discounted CF 0 $ -29,500.00 1/(1+0.15)^0= 1 1*-29500= $ -29,500.00 1 $ 16,900.00 1/(1+0.15)^1= 0.869565217 0.869565217391304*16900= $ 14,695.65 2 $ 13,600.00 1/(1+0.15)^2= 0.756143667 0.756143667296787*13600= $ 10,283.55 3 $ 8,300.00 1/(1+0.15)^3= 0.657516232 0.657516232431988*8300= $ 5,457.38 NPV = Sum of all Discounted CF $ 936.59 Profitability Index 1.03
When discount rate = 22%
Year CF Discount Factor Discounted CF 0 $ -29,500.00 1/(1+0.22)^0= 1 1*-29500= $ -29,500.00 1 $ 16,900.00 1/(1+0.22)^1= 0.819672131 0.819672131147541*16900= $ 13,852.46 2 $ 13,600.00 1/(1+0.22)^2= 0.671862403 0.671862402579952*13600= $ 9,137.33 3 $ 8,300.00 1/(1+0.22)^3= 0.550706887 0.550706887360616*8300= $ 4,570.87 NPV = Sum of all Discounted CF $ -1,939.35 Profitability Index 0.93
NPV Profitability Inder =1+ Initial investment 3339.22 Profitability Inder =1+ 29500 Profitability Index = 1.11NPV Profitability Inder =1+ Initial investment 963.59 Profitability Index =1+ 29500 Profitability Inder = 1.03NPV Profitability Inder =1+ Initial investment 1939.35 Profitability Index =1+ 29500 Profitability Inder = 0.93
Similar Solved Questions
1 answers
The management of Gibraltar Brokerage Services anticipates a capital expenditure of $20,000 in 3 yr for...
The management of Gibraltar Brokerage Services anticipates a capital expenditure of $20,000 in 3 yr for the purpose of purchasing new computers and has decided to set up a sinking fund to finance this purchase. If the fund earns interest at the rate of 10%/year compounded quarterly, determine the si...
1 answers
Pratt Company acquired all of Spider, Inc.’s outstanding shares on December 31, 2018, for $507,950 cash....
Pratt Company acquired all of Spider, Inc.’s outstanding shares on December 31, 2018, for $507,950 cash. Pratt will operate Spider as a wholly owned subsidiary with a separate legal and accounting identity. Although many of Spider’s book values approximate fair values, several of its acc...
1 answers
A 500g mass is hung on a spring. Then it is pulled down 4cm and released...
A 500g mass is hung on a spring. Then it is pulled down 4cm and released from rest. It takes 8.45s to complete 10 full oscillations. What is the spring constant of the spring? Show your work....
1 answers
Hi, Please explain the steps needed to get the answer. Thank you Constants Two small spheres...
Hi, Please explain the steps needed to get the answer. Thank you Constants Two small spheres with mass m 14.9 g are hung by silk threads of length L 1.12 m from a common point (Figure 1). When the spheres are given equal charges so that q 2q. each thread hangs at an angle 0 28.0 from the vertical. w...
1 answers
Suppose the following table represents the market demand and supply: Price per apple (P) Quantity demanded...
Suppose the following table represents the market demand and supply: Price per apple (P) Quantity demanded ( $2 $4.5 $8 Quantity supplied (Q) 10 35 70 64 16 a (10 points) Calculate the linear demand function: Q-a -bP. Draw the linear demand in a graph with price in the vertical axis and quantity dem...
1 answers
How do you write 3/2 + 5/4 + 9/8 + 17/16 + 33/32 in summation notation?
How do you write 3/2 + 5/4 + 9/8 + 17/16 + 33/32 in summation notation?...
1 answers
Northwoods Backpackers is a retail catalog store in Vermont that specializes in outdoor clothing and camping...
Northwoods Backpackers is a retail catalog store in Vermont that specializes in outdoor clothing and camping equipment. Phone orders are taken each day by a large pool of computer operators, some of whom are permanent and some temporary. A permanent operator can process an average of 76 orders per d...
1 answers
5. Discount Fumiture, Inc. completed the following treasury stock transactions in 2018: (Click the icon to...
5. Discount Fumiture, Inc. completed the following treasury stock transactions in 2018: (Click the icon to view the transactions.) Requirements 1. Journalize these transactions. Explanations are not required. 2. How will Discount Furniture, Inc. report treasury stock on its balance sheet as of Decem...
1 answers
5. A confidence interval for Poisson variables Bookmark this page (a) 2 points possible (graded) Let...
5. A confidence interval for Poisson variables Bookmark this page (a) 2 points possible (graded) Let X1,..., Xn bei.i.d. Poisson random variables with parameter 1 > 0 and denote by Xn their empirical average, Xn=1 İx; and (bn), such that an (Xn-bn) converges in distribution to a standard Gau...
1 answers
Match the pka (determined in an unknown mixture of water and an organic solvent) with the...
Match the pka (determined in an unknown mixture of water and an organic solvent) with the correct acid: NECH ol OH A F3C OH H3C B E Eto OEt O2N-CH3 F I. 0.8 II. 19.4 Ill. 28 What is the pka of A? What is the pka of B? What is the pka of C? What is the pka of D? What is the pka of E? What is the pka ...
1 answers
A charge configuration with two charges of opposite sign but the same magnitude, q, and a...
A charge configuration with two charges of opposite sign but the same magnitude, q, and a separation distance, d, is called an electric dipole. The electric dipole moment, or EDM, is a vector, p, with a magnitude p = qd and a direction from the negative charge towards the positive charge. When such ...
1 answers
Manufacturers Southern leased high-tech electronic equipment from International Machines on January 1, 2021. International Machines manufactured...
Manufacturers Southern leased high-tech electronic equipment from International Machines on January 1, 2021. International Machines manufactured the equipment at a cost of $105,000. Manufacturers Southern's fiscal year ends December 31. (FV of $1. PV of $1. EVA of $1. PVA of $1. FVAD of $1 and P...
1 answers
A) Find and sketch the domain of f b) Find ) c) Find the directional derivative of f in the direction of 3i +4j at (2,3) d) Find an equation of the plane tangent to the surface-f(z, y) at (2,3,3)...
a) Find and sketch the domain of f b) Find ) c) Find the directional derivative of f in the direction of 3i +4j at (2,3) d) Find an equation of the plane tangent to the surface-f(z, y) at (2,3,3) a) Find and sketch the domain of f b) Find ) c) Find the directional derivative of f in the direction o...
1 answers
(1 point) Given the function f(t) = {sine if 0 <t< 61 if 61 <t. sint...
(1 point) Given the function f(t) = {sine if 0 <t< 61 if 61 <t. sint 61) Express f(t) in terms of the shifted unit step function uſt – a) f(t) = Now find the Laplace transform F(s) of f(t) F(s) =...