Homework Answers
Cash Flow table
| Year | Investment | Annual income | Annual maint. | salvage value | software upgrade | income | Net Cash Flow |
| 0 | -10000 | -10000 | |||||
| 1 | 2000 | 0 | 750 | 2750 | |||
| 2 | 2000 | -400 | 1600 | ||||
| 3 | 2000 | -400 | 1600 | ||||
| 4 | 2000 | -400 | 1600 | ||||
| 5 | 2000 | -400 | 1600 | ||||
| 6 | 2000 | -400 | 1600 | ||||
| 7 | 2000 | -400 | 1600 | ||||
| 8 | 2000 | -400 | -2500 | -900 | |||
| 9 | 2000 | -400 | 1600 | ||||
| 10 | 2000 | -400 | 1500 | 3100 |
CFD
We will use NPV function and FV function in Excel to find value of F12
| Year | Investment | Annual income | Annual maint. | salvage value | software upgrade | income | Net Cash Flow |
| 0 | -10000 | -10000 | |||||
| 1 | 2000 | 0 | 750 | 2750 | |||
| 2 | 2000 | -400 | 1600 | ||||
| 3 | 2000 | -400 | 1600 | ||||
| 4 | 2000 | -400 | 1600 | ||||
| 5 | 2000 | -400 | 1600 | ||||
| 6 | 2000 | -400 | 1600 | ||||
| 7 | 2000 | -400 | 1600 | ||||
| 8 | 2000 | -400 | -2500 | -900 | |||
| 9 | 2000 | -400 | 1600 | ||||
| 10 | 2000 | -400 | 1500 | 3100 | |||
| F12 | 3,648.55 |
Showing formula in excel
| Year | Investment | Annual income | Annual maint. | salvage value | software upgrade | income | Net Cash Flow |
| 0 | -10000 | =E2+F2+G2+H2+I2+J2 | |||||
| 1 | 2000 | 0 | 750 | =E3+F3+G3+H3+I3+J3 | |||
| 2 | 2000 | -400 | =E4+F4+G4+H4+I4+J4 | ||||
| 3 | 2000 | -400 | =E5+F5+G5+H5+I5+J5 | ||||
| 4 | 2000 | -400 | =E6+F6+G6+H6+I6+J6 | ||||
| 5 | 2000 | -400 | =E7+F7+G7+H7+I7+J7 | ||||
| 6 | 2000 | -400 | =E8+F8+G8+H8+I8+J8 | ||||
| 7 | 2000 | -400 | =E9+F9+G9+H9+I9+J9 | ||||
| 8 | 2000 | -400 | -2500 | =E10+F10+G10+H10+I10+J10 | |||
| 9 | 2000 | -400 | =E11+F11+G11+H11+I11+J11 | ||||
| 10 | 2000 | -400 | 1500 | =E12+F12+G12+H12+I12+J12 | |||
| F12 | =FV(7%,12,,-(NPV(7%,K3:K12)+K2)) |
Add Answer to:
80 Points Draw and solve the Cash Flow Diagram for Future Value “F12". The data below...
7) (30 points) First draw a cash flow diagram for the cash flow series given below....
7) (30 points) First draw a cash flow diagram for the cash flow series given below. Then, write an expression (e.g., F-500(PA 5%, 3) + 100(FIG 5%, 3)) to compute the future value of the cash flow series at the end of year 10. You must use at least one uniform series factor, one arithmetic gradient series factor, and one geometric gradient series factor and 10% per year compounded annually. No calculations are needed. 10 Cash 1,000 3,000 3,300 -3,600...
Future Value of Uneven Cash Flow 22. You expect to receive $300, $400, $500, $300, $400...
Future Value of Uneven Cash Flow 22. You expect to receive $300, $400, $500, $300, $400 and $500 at the end of each year over the next 6 years. If an annual interest rate is 4 percent, what is the future value of this uneven cash flow stream? a. $2,636 23. You expect to receive $300, $400, $500, $300, $400 and $500 at the end of each year over the next 6 years. If an annual interest rate is 2...
Future Value and Present Worth (DRAW the Cash Flow Diagram) a) MARTA is buying a new...
Future Value and Present Worth (DRAW the Cash Flow Diagram)
a) MARTA is buying a new ticketing system. The price the vendor
and MARTA has agreed to is $200,000. The city will also pay 8%
interest compounded annually for the ability to not make any
payment on the system until the 5 year warranty period is up. So,
the agency is going to install the new system in December 2018 but
they do not have to pay the vendor until...
Present and Future Value of an Uneven Cash Flow Stream An investment will pay $200 at...
Present and Future Value of an Uneven Cash Flow Stream An investment will pay $200 at the end of each of the next 3 years, $400 at the end of Year 4, $500 at the end of Year 5, and $600 at the end of Year 6. If other investments of equal risk earn 9% annually, what is this investment's present value? Its future value? Do not round intermediate calculations. Round your answers to the nearest cent. Present value: $ ...
Present and Future Value of an Uneven Cash Flow Stream An investment will pay $100 at...
Present and Future Value of an Uneven Cash Flow Stream An investment will pay $100 at the end of each of the next 3 years, $400 at the end of Year 4, $600 at the end of Year 5, and $800 at the end of Year 6. If other investments of equal risk earn 6% annually. What is its present value? Round your answer to the nearest cent. What is its future value? Round your answer to the nearest cent....
solve with (cash flow diagram) (Don't not use excel) A remotely located air sampling station can...
solve with (cash flow diagram)
(Don't not use excel)
A remotely located air sampling station can be powered by solar cells or by running an electric line to the site and using conventional power. Solar cells will cost $12.600 to install and will have a useful life of 4 years with no salvage value. Annual costs for inspection, cleaning, etc. are expected to be $1400. A new power line will cost $11,000 to install, with power costs expected to be...
Given the following tabulated cash flow diagram for a series of investments, what is the future...
Given the following tabulated cash flow diagram for a series of investments, what is the future value at the end of year 10, if the interest rate is 5.4%? 10 -500 1200 150 375 -150 150 900 0
Refer to the Cash Flow Diagram below to calculate the value of F at the end...
Refer to the Cash Flow Diagram below to calculate the value of F at the end of year 10: 0______1____2______3_____4________5_____6______7________8_______9________________10 F=? i=5% at 0) 6000 at 2) 3,000 at 5)4,000 These values have a downward arrow at 10 the arrow is up
please draw the cash flow diagram Q2: A person invests 1000$ in the first year, 1500$...
please draw the cash flow diagram
Q2: A person invests 1000$ in the first year, 1500$ in the second year, 1800$ in the third year, 1200$ in the fourth year and 2000% in the fifth year. At an annual compound interest rate of 8%: 1. Calculate present worth (P). 2. Calculate future worth (F). Note: solve by either the equations or tables.
Solve the cash flow equivalence below for the unknown value of Q assuming an 7% annual...
Solve the cash flow equivalence below for the unknown value of Q assuming an 7% annual interest rate. 1. 800 4i Q 70 o0 i23 2 2, You borrowed $6,000.00 for 5 years at 7% annual interest rate. The banker said that to repay the total loan amount you have to pay $1,463 at the end of each year. a) Draw a time line depicting this cash low b) Build a table to determine how much of the annual payment...
7) (30 points) First draw a cash flow diagram for the cash flow series given below. Then, write an expression (e.g., F-500(PA 5%, 3) + 100(FIG 5%, 3)) to compute the future value of the cash flow series at the end of year 10. You must use at least one uniform series factor, one arithmetic gradient series factor, and one geometric gradient series factor and 10% per year compounded annually. No calculations are needed. 10 Cash 1,000 3,000 3,300 -3,600...
Future Value of Uneven Cash Flow 22. You expect to receive $300, $400, $500, $300, $400 and $500 at the end of each year over the next 6 years. If an annual interest rate is 4 percent, what is the future value of this uneven cash flow stream? a. $2,636 23. You expect to receive $300, $400, $500, $300, $400 and $500 at the end of each year over the next 6 years. If an annual interest rate is 2...
Future Value and Present Worth (DRAW the Cash Flow Diagram)
a) MARTA is buying a new ticketing system. The price the vendor
and MARTA has agreed to is $200,000. The city will also pay 8%
interest compounded annually for the ability to not make any
payment on the system until the 5 year warranty period is up. So,
the agency is going to install the new system in December 2018 but
they do not have to pay the vendor until...
solve with (cash flow diagram)
(Don't not use excel)
A remotely located air sampling station can be powered by solar cells or by running an electric line to the site and using conventional power. Solar cells will cost $12.600 to install and will have a useful life of 4 years with no salvage value. Annual costs for inspection, cleaning, etc. are expected to be $1400. A new power line will cost $11,000 to install, with power costs expected to be...
Given the following tabulated cash flow diagram for a series of investments, what is the future value at the end of year 10, if the interest rate is 5.4%? 10 -500 1200 150 375 -150 150 900 0
please draw the cash flow diagram
Q2: A person invests 1000$ in the first year, 1500$ in the second year, 1800$ in the third year, 1200$ in the fourth year and 2000% in the fifth year. At an annual compound interest rate of 8%: 1. Calculate present worth (P). 2. Calculate future worth (F). Note: solve by either the equations or tables.
Solve the cash flow equivalence below for the unknown value of Q assuming an 7% annual interest rate. 1. 800 4i Q 70 o0 i23 2 2, You borrowed $6,000.00 for 5 years at 7% annual interest rate. The banker said that to repay the total loan amount you have to pay $1,463 at the end of each year. a) Draw a time line depicting this cash low b) Build a table to determine how much of the annual payment...
Most questions answered within 3 hours.
-
The peak voltage of the source from problem 4 is 12 V. You
notice that the...
asked 4 minutes ago -
scientist have determined that some people are born with a very
small hole in their heart....
asked 7 minutes ago -
Calculate [H3O+] in the following aqueous solution at 25 ∘C:
[OH−]= 1.0×10−9 M .
Calculate [H3O+]...
asked 11 minutes ago -
The total vapor pressure above a binary solution of components A
and B is found to...
asked 9 minutes ago -
Intensity level is given by b = 10 log(I/I0) with I0 = 10−12
W/m2. The usual...
asked 19 minutes ago -
For each of the following product pairs, what would you guess
about their cross price elasticity...
asked 22 minutes ago -
GreyCo collected $17,200 of customer deposits on cans and
bottles. As of the end of the...
asked 25 minutes ago -
Please, I am evaluating an error term y = 5^(n+1)*(n+1)
and wish to find the number...
asked 34 minutes ago -
calculate the ph of the sodium after the addition of following
amounts of 0.0663M HNO3 to...
asked 38 minutes ago -
What is the path of a carbon atom during photosynthesis , light
dependent and non dependent,...
asked 41 minutes ago -
The balanced equation for the combustion of butane,
C4H10, is
2 C4H10(g) + 13
O2(g) →...
asked 42 minutes ago -
Q1 At depths of 2000 m in the sea, the pressure is about 200
times atmospheric...
asked 57 minutes ago