Use Goal Seek on this worksheet

1. Use Goal Seek on this worksheet to calculate what annual return should be to achieve a Net Present Value of $100,000 with an initial payment of $500,000 and the same annual return coming at the end of the first, second, third, and fourth years. Use a 10% discount rate. Note that a single cell can be referenced for each year's annual return.

2. Then generate a data table on another worksheet of Net Present Value for Discount Rates of 7%, 8%, 9%, 10%, 11% and 12%, and the Year Return for each of four years following the investment of $150K, $175K, $200K, $225K, $250K and $275K. (K represents a thousand). The initial investment remains $500,000.

Get Help from Experts

If you’re still asking yourself, “Who can help me write my paper from scratch", don’t hesitate to use us. Experienced writers will immediately write, proofread, or improve your academic paper. They can also help you choose a topic and edit your references into APA or MLA format. So, what are you waiting for?

Find your writer