You anticipate needing $40,000 for a down payment on a home in five years. If you earn 8%, how much must you set aside now to achieve this?
Referring to 2, how much would you have to set aside at the end of each year, instead of now, to achieve the $40,000 objective?
Please complete assingment in excel with screenshots.