Laura’s grandparents helped her purchase a small self-serve laundry business to make extra money during her five college years. When she completed her electrical engineering degree, she sold the business and her grandparents told her to keep the money as a graduation present. For the net cash flows (NCF) listed, determine:a. if the total income exceeded the total amount invested in 5 years (i = 0%).b. the actual rate of return over the 5-year period. c. how long it took to pay back the $75,000 investment plus a 7% per year return.d. answers to all three questions above using a spreadsheet.Year 0 1 2 3 4 5NCF, $1000 per year -75 -10.5 18.6 -2 28 105
Laura’s grandparents helped her purchase a small self-serve laundry business to make extra money during her five college years. When she completed her electrical engineering degree, she sold the business and her grandparents told her to keep the money as a graduation present. For the net cash flows (NCF) listed, determine:
a. if the total income exceeded the total amount invested in 5 years (i = 0%).
b. the actual
c. how long it took to pay back the $75,000 investment plus a 7% per year return.
d. answers to all three questions above using a spreadsheet.
Year 0 1 2 3 4 5
NCF, $1000 per year -75 -10.5 18.6 -2 28 105
Step by step
Solved in 2 steps with 6 images