problem #11 please Class Number Printed Name ENGR 222 Final Study Guide Fall 201
ID: 2804427 • Letter: P
Question
problem #11 please
Class Number Printed Name ENGR 222 Final Study Guide Fall 2017 Observe the weights for each problem!! #1-12 (4 Points Each) #15(52 Points) VARIABLE AND DISTRIBUTION TYPE annual profit-triangular 55,000.00 567500.00 $85,000.00 1 INPUT DATA Values Minimum Mode Maximum salvage value-triangular $60,000.00 $75,000.00 $85,000.00 initial investment- uniform $200,000.00 $300,000.00 CALCULATION OF MOST LIKELY VALUES-MEAN $69,166.67 $73,333.33 Mean $250,000.00 H FLOW (CF) TABLES (RANGE APPROACH-CHANGING ALL VARIABLES SIMULTANEOUSLY 10 Most pessimistic CF Most likely Most Optimistic CF PV at 15% PV at 15% PV at 15% 12 13 14 15 16 17 18 ($200,00.00 (S200,000.00) ($250,00.00 ($250,00.00 (530,000.0)($300,000.00 $60,14493$55,000.00 $47,826.09 1$85,000.00 $73,913.04 $69,166.67 $85,000.00 | s64,272.21 s69,166.671 s52,299.94 ss5,000.00 | sai,587,90 $85,000.008 55,000.00 $36,13.39 $85,000.00 $4.03 $69,166.67 $39,546. $55,000.00 $31,446.43 $85,000.00 $42,260.02 $69,166.67 $34,388.06 $55,000.00 $27,344.72 $85,000.00 $37.85 $63,166.67 $29,02.66 $55,000.00 $23,778.02 $10000.00 $63 909.30 $142,500.00$53,57103 $15000.00$43.232.76 8888 $69,166.67 $45,478.21 20 211 IRR/NPV| $185,590.33 22.62%) $65,331.08 9.87%) ($48,620.09) 40.10% #11 and #12 refer to the above table. 11. Show the work using financial notations (P/F·196, n) to calculate the value in Row 15 Column E. Show the logic first and then replace the logic with values from the interest tables. 12. Show the work to calculate the values in the cell number identified below. (Please use actual numerical values instead of cell values i.e. Do not use row or columns numbers in your response) a. Row 14 Column C.: b. Row 14 Column D c. Row 14 Column E: d. Row 20 Column B: e. Row 20 Column D: f. Row 20 ColumnF:Explanation / Answer
11. Row 15 column E:
the values are present value of future cash flows, discounted at 15%
discount factor is calculated using the fourmal = 1/ [1+r]^n
where r= rate of interest= 15%
n= EOY
For instance for year 0 discount factor= 1/ [1+0.15]^0 = 1/1= 1
The value in cell E13 comes by multiplying D13 with discount factor= -250000 *1= -250000
For year 1 discount factor= 1/ [1+0.15]^1 = 1/1.15 = 0.869565
and the value in E14 = 69166.67 *0.869565= 60164.93
Below is the table:
12.
Row 14 column C:
Most optimistic annual cash flow= amount given in cell D5, maximum annual profit= 85000
Row 14 column D:
Present value of 85000 discounted at 15% , EOY 1= 85000* 0.869565 = 73913.04
Row 14 column E:
Most Likely annual cash flow:
Mean of minimum, mode, maximum annual profit= (55000+67500+85000)/3= 69166.67
Row 20 column B:
Most optimisitic cash flow in year 7= Most optimisitic annual profit + Most optimisitic salvage value= 85000+85000= 170000
Row 20 column D:
Most likely cash flow in year 7= Most likely annual profit + Most likely salvage value= 69166.67+73333.33= 142500
Row 20 column F:
Most pessimistic cash flow in year 7= Most pessimistic annual profit + Most pessimistic salvage value= 55000+60000= 115000
CF P/F PV at 15% a b c=a*b (250,000.00) 1 -250000 69,166.67 0.869565 60144.93 69,166.67 0.756144 52299.94 69,166.67 0.657516 45478.21 69,166.67 0.571753 39546.27 69,166.67 0.497177 34388.06 69,166.67 0.432328 29902.66 142,500.00 0.375937 53571.03 65331.09Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.