## Answers

**NPV = $1,578,899.47**

Excel formula:

A B C D E F ear 0 احرام با ما با داد | Cash flow PV factor @10% Present value -11850000 1 -11850000 1900000 0.909090909 1727272.727 1900000 0.826446281 1570247.934 1900000 0.751314801 1427498.122 19000001 0.683013455 1297725.565 1900000 0.620921323 1179750.514 1900000 0.56447393 1072500.467 1900000 0.513158118 975000.4246 1900000 0.46650738 886364.0224 1900000 0.424097618 805785.4749 6450000 0.385543289 2486754.217 NPV 1578899.47 101 14 15

D Year Cash flow PV factor @10% - 11850000 1900000 =1/(1+0.1)^B4 1900000 =1/(1+0.1)^B5 1900000 =1/(1+0.1)^B6 1900000 =1/(1+0.1)^B7 1900000 =1/(1+0.1)^B8 1900000 =1/(1+0.1)^B9 1900000 =1/(1+0.1)^B10 1900000 =1/(1+0.1)^B11 1900000 =1/(1+0.1)^B12 =(5250000+1900000)-(2000000*0.35)=1/(1+0.1)^B13 Present value =C3*D3 =C4*D4 =C5*D5 =C6*D6 =C7*D7 =C8*D8 =C9*D9 =C10*D10 =C11*011 =C12*D12 =C13*D13 =SUME3:E13) 10 NPV

.
#### Similar Solved Questions

1 answer

##### Water bottle question you decide to take an international adventure to the locations shown below. During...

Water bottle question you decide to take an international adventure to the locations shown below. During this trip yc rry a bottle of water with you made of cheap plastic so its walls are really flexible. (Guess you must not be flying with today's restrictions). you don't drink any of the ...

1 answer

##### What are the 5 missions listed in the Quadrennial Homeland Security Review?

What are the 5 missions listed in the Quadrennial Homeland Security Review?...

1 answer

##### Do not round intermediate calculations. Give your final answer(s) to three significant figures. Two cylindrical rods,...

Do not round intermediate calculations. Give your final answer(s) to three significant figures. Two cylindrical rods, one of steel and the other of brass, are joined at C and restrained by rigid supports at.A and E. For the loading shown and knowing that Es200 GPa and E b 105 GPa, determine the defl...

1 answer

##### Grant has 4 hours of time in all to divide between studying for a physics exam...

Grant has 4 hours of time in all to divide between studying for a physics exam and a geology exam. Table 1 shows his estimates of the grades (on a scale of o to 100) that he could eam from studying a particular number of hours on each subject. If he plans on spending two hours studying physics and t...

1 answer

##### A hot air balloon is 100m in the air and ascending at a constant rate of...

A hot air balloon is 100m in the air and ascending at a constant rate of 3.50m/s. At the moment, a passenger throws a coin horizontally, relative to herself, with an initial speed of 18.0 m/s. When she lands where will she find the coin? I am having a hard time accounting for the ascending portion ...

1 answer

##### (C++ Microsoft Visual Studio) [15 Points] Write a while loop to calculate the average of numbers...

(C++ Microsoft Visual Studio) [15 Points] Write a while loop to calculate the average of numbers entered by the user: Ask the user to enter an integer number or -1 to stop Add the entered numbers Compute the average of the numbers outside the loop after termination ...

1 answer

##### 9.33 Determine the z-transform and the conmesponding ROC of the following sequences given in Table 92:...

9.33 Determine the z-transform and the conmesponding ROC of the following sequences given in Table 92: (a) ln)-Qm.(b) son-"costoAn...

1 answer

##### Corporations on January 1, 2017, just before they entered into a business combination: 13 The following...

Corporations on January 1, 2017, just before they entered into a business combination: 13 The following Statement of Financial Position were prepared for Red and Blue So Problem 13-6 Blue Corporation Fair Value P 50,000 245,000 250,000 Items Cash and Receivables Inventory Buildings and Equipment Les...

1 answer

##### Interim Reporting please choose the correct choice. Macy’s sales traditionally peak in November and December for...

Interim Reporting please choose the correct choice. Macy’s sales traditionally peak in November and December for the holiday season and then decline sharply in January and February due to the inclement wintry-weather. According to the interim reporting standards, Macy’s 1Q 2020 (Januar...

1 answer

##### Preston Manufacturing produces self-watering planters for use in upscale retail establishments. Sales projections for the first...

Preston Manufacturing produces self-watering planters for use in upscale retail establishments. Sales projections for the first five months of the upcoming year show the estimated unit sales of the planters each month to be as follows: EE (Click the icon to view additional information.) at the start...

1 answer

##### 1) Calculate the freezeing point (Tf) of an aqueous solution 0.50m (molal) of BaCl2. (Usea: kf=1.86...

1) Calculate the freezeing point (Tf) of an aqueous solution 0.50m (molal) of BaCl2. (Usea: kf=1.86 C/m) 2) Is true that the solubility of a substance: a. always depend of the temperature b. depend of the intermolecular forces that are presents. c. is an exothermic process d. all the options are co...

1 answer

##### A pyramid has a parallelogram shaped base and a peak directly above its center. Its base's sides have lengths of #6 # and #7 # and the pyramid's height is #2 #. If one of the base's corners has an angle of #(5pi)/6#, what is the pyramid's surface area?

A pyramid has a parallelogram shaped base and a peak directly above its center. Its base's sides have lengths of #6 # and #7 # and the pyramid's height is #2 #. If one of the base's corners has an angle of #(5pi)/6#, what is the pyramid's surface area?...

1 answer

##### Question 3 When a sealed bulb containing a gas is immersed in an ice bath, it...

Question 3 When a sealed bulb containing a gas is immersed in an ice bath, it has a gas pressure of 334 Torr. When the same bulb is placed in an oven, the pressure of the gas rises to 755 Torr. What is the temperature of the oven in Celsius? °C...

1 answer

##### Solve the system of equations using the addition (elimination) method

Solve the system of equations using the addition (elimination) method. If the answer is a uqique solution or infinitely many solutions 9x + 2y =2 3x + 5y = 5...

1 answer

##### Pleases help me thanks. 5 kg of liquid water at 100°C was converted to steam at...

Pleases help me thanks. 5 kg of liquid water at 100°C was converted to steam at 100°C by boiling at standard atmospheric pressure, in the arrangement of the figure below. The volume of the water changed from an initial value of 0.005 mº as a liquid to 8.355 mº as steam. Latent hea...

1 answer

##### Please provide correct answer for part B. A manager is trying to decide whether to buy...

Please provide correct answer for part B. A manager is trying to decide whether to buy one machine or two. If only one is purchased and demand proves to be excessive, the second machine can be purchased later. Some sales will be lost, however, because the lead time for producing this t...

1 answer

##### Need all to be answered 26.Melanin: A)occurs in individuals with light skin tone. B)is advantageous because...

Need all to be answered 26.Melanin: A)occurs in individuals with light skin tone. B)is advantageous because it provides protection from solar radiation. C)is a chemical that decreases the possibility of a tan. D)develops more with age. 27.The logic of evolutionary psychology begins with the precept ...

1 answer

##### 8. Solve the right triangle with the given information (round to the nearest tenth): b /27...

8. Solve the right triangle with the given information (round to the nearest tenth): b /27 200 angle B = a 3= TI - BIU EE...

1 answer

##### Two balls, of masses m and 2m, travelling in a vacuum with initial velocities 2v and...

Two balls, of masses m and 2m, travelling in a vacuum with initial velocities 2v and v respectively, collide with each other head-on, as shown. m 2v v 2m After the collision, the ball of mass m rebounds to the left with velocity v. What is the loss of kinetic energy in the collision? A 3/4 mv^2 B 3/...