Math  /  Algebra

QuestionUsing Microsoft Excel, create an investment cash-flow diagram that will have a present worth of zero using MARR =12%=12 \%. The study period needs to be exactly 9\underline{9} years and each year should have at least one unique cash-flow that is different from the cash-flows over the other years. Your answer should contain a table showing the cash-flows for each year and a graphical representation of the cash-flows (cash-flow diagram).

Studdy Solution
The cash flows that give us a present worth of zero at 12% interest are: - Year 1: $1000\$1000 - Year 2: $800\$800 - Year 3: $600\$600 - Year 4: $400\$400 - Year 5: $200\$200 - Year 6: $200-\$200 - Year 7: $400-\$400 - Year 8: $800-\$800 - Year 9: $1200-\$1200
[Note: A cash flow diagram would be included in Excel showing these values on a timeline]

View Full Solution - Free
Was this helpful?

Studdy solves anything!

banner

Start learning now

Download Studdy AI Tutor now. Learn with ease and get all help you need to be successful at school.

ParentsInfluencer programContactPolicyTerms
TwitterInstagramFacebookTikTokDiscord