Question: Kindly explain me how to fill the attached excel file. ''DETERMINING AMOUNT OF INVESTMENT CAPITAL for financial goal'' A. B. 1. Targeted Financial Goal (see
Kindly explain me how to fill the attached excel file.
''DETERMINING AMOUNT OF INVESTMENT CAPITAL for financial goal''

A. B. 1. Targeted Financial Goal (see Note 1) 2. Projected Average Return on Investments Finding a Lump Sum Investment: 3. Future Value Factor, from Appendix A based on years to target date and a projec return on investment of % 4. Required Lump Sum Investment line 1 line 3 $ Making a Series of Investments over Time: 5. Amount of Initial Investment, if any (see Note 2) 6. Future Value Factor, from Appendix A based on years of target date and a projec return on investment of % 7. Terminal Value of Initial Investment line 5 line 6 $ 8. Balance to Come from Savings Plan line 1 - line 7 $ 9. Future Value Annuity Factor, from Appendix B based on years to target date and a projec return on investment of % 10. Series of Annual Investments Required over Time line 8 line 9 $ $ $ % 1.000 $ - 1.000 $ - $ - 0.00 $
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
