Homework Answers
| Year | Receipt | Expenses | Net Cash Flow | |
| 0 | 0 | -3000 | -3000 | |
| 1 | 2900 | -1500 | 1400 | |
| 2 | 5700 | -4000 | 1700 | |
| 3 | 5500 | -2000 | 3500 | |
| 4 | 1100 | -1300 | -200 | |
| IRR | 42.05% | |||
| a) The number of IRRs equals the number of changes in the sign of the cash flow. In this case, from negative to positive and then back to negative.There are 2 possible rate of return values | ||||
| b) | ||||
| IRR | NPV | |||
| 0.00% | 3400 | |||
| 1.00% | 3257.511346703 | |||
| 2.00% | 3119.895033422 | |||
| 3.00% | 2986.934744651 | |||
| 4.00% | 2858.425825426 | |||
| 5.00% | 2734.174546614 | |||
| 6.00% | 2613.997422971 | |||
| 7.00% | 2497.720579726 | |||
| 8.00% | 2385.179163821 | |||
| 9.00% | 2276.216796279 | |||
| 10.00% | 2170.685062496 | |||
| 11.00% | 2068.4430375 | |||
| 12.00% | 1969.356843503 | |||
| 13.00% | 1873.299237269 | |||
| 14.00% | 1780.149225071 | |||
| 15.00% | 1689.791703146 | |||
| 16.00% | 1602.117121766 | |||
| 17.00% | 1517.021171194 | |||
| 18.00% | 1434.404487908 | |||
| 19.00% | 1354.172379644 | |||
| 20.00% | 1276.234567901 | |||
| 21.00% | 1200.504946655 | |||
| 22.00% | 1126.901356155 | |||
| 23.00% | 1055.345370724 | |||
| 24.00% | 985.762099617 | |||
| 25.00% | 918.08 | |||
| 26.00% | 852.230701263 | |||
| 27.00% | 788.14883986 | |||
| 28.00% | 725.771903992 | |||
| 29.00% | 665.04008746 | |||
| 30.00% | 605.896152096 | |||
| 31.00% | 548.285298182 | |||
| 32.00% | 492.155042368 | |||
| 33.00% | 437.455102572 | |||
| 34.00% | 384.137289434 | |||
| 35.00% | 332.155403892 | |||
| 36.00% | 281.465140504 | |||
| 37.00% | 232.023996138 | |||
| 38.00% | 183.791183715 | |||
| 39.00% | 136.727550674 | |||
| 40.00% | 90.795501874 | |||
| 41.00% | 45.958926666 | |||
| 42.00% | 2.183129876 | |||
| 43.00% | -40.565233535 | |||
| 44.00% | -82.318220355 | |||
| 45.00% | -123.10665775 | |||
| 46.00% | -162.960198838 | |||
| 47.00% | -201.907375381 | |||
| 48.00% | -239.97564777 | |||
| 49.00% | -277.191452444 | |||
| 50.00% | -313.580246914 | |||
| 51.00% | -349.166552509 | |||
| 52.00% | -383.973994982 | |||
| 53.00% | -418.025343096 | |||
| 54.00% | -451.342545301 | |||
| 55.00% | -483.946764611 | |||
| 56.00% | -515.858411777 | |||
| 57.00% | -547.097176855 | |||
| 58.00% | -577.682059249 | |||
| 59.00% | -607.631396318 | |||
| 60.00% | -636.962890625 | |||
| 61.00% | -665.693635891 | |||
| 62.00% | -693.840141738 | |||
| 63.00% | -721.418357273 | |||
| 64.00% | -748.443693575 | |||
| 65.00% | -774.931045154 | |||
| 66.00% | -800.894810417 | |||
| 67.00% | -826.348911208 | |||
| 68.00% | -851.306811462 | |||
| 69.00% | -875.78153502 | |||
| 70.00% | -899.785682643 | |||
| 71.00% | -923.331448278 | |||
| 72.00% | -946.4306346 | |||
| 73.00% | -969.094667865 | |||
| 74.00% | -991.334612131 | |||
| 75.00% | -1013.161182841 | |||
| 76.00% | -1034.584759835 | |||
| 77.00% | -1055.615399801 | |||
| 78.00% | -1076.262848182 | |||
| 79.00% | -1096.536550599 | |||
| 80.00% | -1116.445663771 | |||
| 81.00% | -1135.999065991 | |||
| 82.00% | -1155.20536716 | |||
| 83.00% | -1174.072918403 | |||
| 84.00% | -1192.609821291 | |||
| 85.00% | -1210.823936684 | |||
| 86.00% | -1228.722893212 | |||
| 87.00% | -1246.314095412 | |||
| 88.00% | -1263.604731539 | |||
| 89.00% | -1280.601781061 | |||
| 90.00% | -1297.312021854 | |||
| 91.00% | -1313.742037114 | |||
| 92.00% | -1329.898221993 | |||
| 93.00% | -1345.786789979 | |||
| 94.00% | -1361.413779019 | |||
| 95.00% | -1376.78505741 | |||
| 96.00% | -1391.906329464 | |||
| 97.00% | -1406.783140946 | |||
| 98.00% | -1421.420884311 | |||
| 99.00% | -1435.824803744 | |||
| 100.00% | -1450 | |||
| 101.00% | -1463.951435068 | |||
| 102.00% | -1477.683936659 | |||
| 103.00% | -1491.202202528 | |||
| 104.00% | -1504.510804631 | |||
| 105.00% | -1517.614193132 | |||
| 106.00% | -1530.516700265 | |||
| 107.00% | -1543.222544045 | |||
| 108.00% | -1555.73583186 | |||
| 109.00% | -1568.060563915 | |||
| 110.00% | -1580.200636566 | |||
| 111.00% | -1592.159845528 | |||
| 112.00% | -1603.941888967 | |||
| 113.00% | -1615.55037049 | |||
| 114.00% | -1626.988802018 | |||
| 115.00% | -1638.260606569 | |||
| 116.00% | -1649.369120937 | |||
| 117.00% | -1660.317598279 | |||
| 118.00% | -1671.109210611 | |||
| 119.00% | -1681.747051225 | |||
| 120.00% | -1692.234137013 | |||
| 121.00% | -1702.573410715 | |||
| 122.00% | -1712.767743098 | |||
| 123.00% | -1722.819935048 | |||
| 124.00% | -1732.732719603 | |||
| 125.00% | -1742.508763908 | |||
| 126.00% | -1752.150671117 | |||
| 127.00% | -1761.660982219 | |||
| 128.00% | -1771.04217781 | |||
| 129.00% | -1780.296679807 | |||
| 130.00% | -1789.426853106 | |||
| 131.00% | -1798.435007179 | |||
| 132.00% | -1807.323397631 | |||
| 133.00% | -1816.094227695 | |||
| 134.00% | -1824.749649687 | |||
| 135.00% | -1833.291766409 | |||
| 136.00% | -1841.722632511 | |||
| 137.00% | -1850.044255807 | |||
| 138.00% | -1858.258598554 | |||
| 139.00% | -1866.36757868 | |||
| 140.00% | -1874.373070988 | |||
| 141.00% | -1882.276908309 | |||
| 142.00% | -1890.08088263 | |||
| 143.00% | -1897.786746179 | |||
| 144.00% | -1905.39621248 | |||
| 145.00% | -1912.910957377 | |||
| 146.00% | -1920.332620024 | |||
| 147.00% | -1927.662803843 | |||
| 148.00% | -1934.903077461 | |||
| 149.00% | -1942.054975609 | |||
| 150.00% | -1949.12 |  |
Add Answer to:
Use Excel
For example.. I want it looks like that
53 Faro laser trackers are portable...
Use excel For example.. I want it looks like that. A car is purchased with a...
Use excel
For example.. I want it looks like that.
A car is purchased with a 48 month and 9%/year compounding monthly rate with an initial balance of $15000. What is the balance due half way through the 4 years? 01 cf 150000 -1000 -1000 -1000 -1000 4000 cf -200000 -1500 1500 1500 1500 5500 0 2 4 ($535.27) ($1,159.39) pv ($150,535.27) ($201,159.39)
Use Excel For example.. I want it looks like that. An engineer wanted to celebrate graduating...
Use
Excel
For example.. I want it looks like that.
An engineer wanted to celebrate graduating and getting a job by buying a new furniture $2400 Luckily the store was offering 6-month financing at an interest of 6%/year compounding monthly. Calculate the monthly payment. 01 cf 150000 -1000 -1000 -1000 -1000 4000 СТ 200000 1500 1500 1500 1500 5500 0 1 2 4 5 npv pv ($535.27) 1,159.39) ($150,535.27) ($201,159.39) I -
Use Excel For example.. I want it looks like that Two years ago, you bought 100...
Use Excel
For example.. I want it looks like that
Two years ago, you bought 100 shares of XYZ stock at $60 per share. The stock paid a dividend of $6 per share per quarter. If you sell the shares now for $98 per share, what is your annual ROR on this investment? cf 150000 -1000 -1000 -1000 -1000 4000 cf -200000 1500 1500 1500 1500 5500 0 1 2 ($535.27)($1,159.39) pv ($150,535.27) ($201,159.39) npv pv
Use Excel For example.. I want it looks like that 7.21 From the following data, calculate...
Use Excel
For example.. I want it looks like that
7.21 From the following data, calculate the (a) conven tional and (b) modified benefit/cost ratios using a discount rate of 6% per year and a very long (in nite) project life. To the People To the Government Benefits:$300,000 now Costs: $1.5 million novw and $100,000 per year thereafter $40,000 per year and $200,000 three years from now Disbenefits: Savings: $70,000 per year 0 1 2 3 4 cf 150000 -1000...
Use Excel For example.. I want it looks like that 6.37 A small manufacturing company expects...
Use Excel
For example.. I want it looks like that
6.37 A small manufacturing company expects to expand its operation by adding new product lines. Any or all of four new lines can be added. If the company uses a MARR of 15% per year and a 5-year project period, which products, if any, should the company manufacture? Monetary terms are in $1000. Product 3 Initial cost, $ Annual cost, S/year Annual savings, S/year 40-500 64 180 190 570-620 70...
Use Excel For example.. I want it looks like that 6.38 A WiMAX wireless network integrated...
Use Excel
For example.. I want it looks like that
6.38 A WiMAX wireless network integrated with a satellite network can provide connectivity to any location within 10 km of the base station. The number of sectors per base station can be varied to increase the bandwidth. An independent cable operator is considering the three bandwidth alter- natives shown below (monetary values in $1000 units). Assume a life of 20 years and a MARR of 25% per year to determine...
Use Excel For example.. I want it looks like that At the end of 1987, you...
Use Excel
For example.. I want it looks like that
At the end of 1987, you bought a piece of land for $35,000. In addition to the $35,000, you paid $1,700 in closing costs (costs associated with the purchase and title registration). For the years 1988 through 2002, you paid, on average, $950 in property taxes at the end of each year. At the end of 2003, you sold the land for $120,000. A sale time, you paid a 6%...
Use excel
For example.. I want it looks like that.
A car is purchased with a 48 month and 9%/year compounding monthly rate with an initial balance of $15000. What is the balance due half way through the 4 years? 01 cf 150000 -1000 -1000 -1000 -1000 4000 cf -200000 -1500 1500 1500 1500 5500 0 2 4 ($535.27) ($1,159.39) pv ($150,535.27) ($201,159.39)
Use
Excel
For example.. I want it looks like that.
An engineer wanted to celebrate graduating and getting a job by buying a new furniture $2400 Luckily the store was offering 6-month financing at an interest of 6%/year compounding monthly. Calculate the monthly payment. 01 cf 150000 -1000 -1000 -1000 -1000 4000 СТ 200000 1500 1500 1500 1500 5500 0 1 2 4 5 npv pv ($535.27) 1,159.39) ($150,535.27) ($201,159.39) I -
Use Excel
For example.. I want it looks like that
Two years ago, you bought 100 shares of XYZ stock at $60 per share. The stock paid a dividend of $6 per share per quarter. If you sell the shares now for $98 per share, what is your annual ROR on this investment? cf 150000 -1000 -1000 -1000 -1000 4000 cf -200000 1500 1500 1500 1500 5500 0 1 2 ($535.27)($1,159.39) pv ($150,535.27) ($201,159.39) npv pv
Use Excel
For example.. I want it looks like that
7.21 From the following data, calculate the (a) conven tional and (b) modified benefit/cost ratios using a discount rate of 6% per year and a very long (in nite) project life. To the People To the Government Benefits:$300,000 now Costs: $1.5 million novw and $100,000 per year thereafter $40,000 per year and $200,000 three years from now Disbenefits: Savings: $70,000 per year 0 1 2 3 4 cf 150000 -1000...
Use Excel
For example.. I want it looks like that
6.37 A small manufacturing company expects to expand its operation by adding new product lines. Any or all of four new lines can be added. If the company uses a MARR of 15% per year and a 5-year project period, which products, if any, should the company manufacture? Monetary terms are in $1000. Product 3 Initial cost, $ Annual cost, S/year Annual savings, S/year 40-500 64 180 190 570-620 70...
Use Excel
For example.. I want it looks like that
6.38 A WiMAX wireless network integrated with a satellite network can provide connectivity to any location within 10 km of the base station. The number of sectors per base station can be varied to increase the bandwidth. An independent cable operator is considering the three bandwidth alter- natives shown below (monetary values in $1000 units). Assume a life of 20 years and a MARR of 25% per year to determine...
Use Excel
For example.. I want it looks like that
At the end of 1987, you bought a piece of land for $35,000. In addition to the $35,000, you paid $1,700 in closing costs (costs associated with the purchase and title registration). For the years 1988 through 2002, you paid, on average, $950 in property taxes at the end of each year. At the end of 2003, you sold the land for $120,000. A sale time, you paid a 6%...
Most questions answered within 3 hours.
-
A 0.0510 M solution of an organic acid has an
[H+] of 7.50×10-4M .
What is...
asked 1 minute ago -
The completed Lewis structure of CO2 contains a total
of 0,1,2,3,4,5,6,7,8 covalent bonds
and 0,1,2,3,4,5,6,7,8 lone pairs.
NOTE:...
asked 4 minutes ago -
what is the profit-maximizing output condition that a
monopolistically competitive firm must satisfy? a) price charged...
asked 5 minutes ago -
Consider the set of ordered pairs shown below. Assuming that the
regression equation is y=3.513+0.429x and...
asked 27 minutes ago -
1. (A) Write two
structural (constitutional)
isomers of C4H8F2?
Please show all of
the
asked 29 minutes ago -
Objective: Practice converting a Boolean logic
expression into it’s truth table and to show the implementation...
asked 26 minutes ago -
1) Name the three holes located in the greater wing of the
sphenoid bone in order...
asked 29 minutes ago -
For the following reaction set-up, which type of hydrocarbon
product would form? 1,4-hexadiene + two Cl2...
asked 32 minutes ago -
Consider the following method that is intended to determine if
the double values d1 and d2...
asked 44 minutes ago -
could someone please post clear drawings of the three structures
in the equilibrium mixture of D-glucose...
asked 51 minutes ago -
Using the Properties of Order show that 5n5 +
4n4 + 6n3 + 2n2+ n +...
asked 55 minutes ago -
What is experiential learning and how is it helpful for teaching
leadership, and interpreting group dynamics?...
asked 54 minutes ago