Attach an excel file please
Financial Modelling, I: Assignment #1 Notes: 1. You should submit your assignment electronically using the drop-box on the D2L page for the course. Look under the assignments tab on the course page. 2. Every student should submit their own individual assignment. However, feel free to work with other students in the class to construct your model. You may work with students from other sections of the course. Make sure that you place your name and student number on the assignment. Also, only submit one file, with a title such as: Assignment #2 - Your Name.xlsx" Assignment #1: Retirement Planning Model Open Excel and look for the Retirement Planer Template. You may have to search for this template using the search box at the top of the page. I would like you to recreate a simplified version of this model. First don't worry about the uncertainty" part of this model - just build the basic model, which will generate the table of cash flows shown at the bottom of the model and the chart at the top of the page. I think this should be straight forward except that the table length will have to update to deal with both i) different retirement ages and ii) years in retirement. This slightly more complicated than the Amortization Table problem we looked at in class since each calculation will depend on which of three time buckets you are in i) working phase of life cycle, ii) retirement phase of life cycle and iii) uh - post retirement (that is to say, "dead"). Notes: We are not trying to replicate the techniques used in the template (Multiple sheets and named formulas). Your model should be on one sheet and use if statements to allow for an adjusting table length. You should never hide sheets on any assignment. In addition to a completed, tested, well formatted and well documented model, the Basic outputs that I will be looking for: 1) A well formatted chart showing a. Savings Account balance (use a scatter chart type to show this series) b. Savings deposited into the account. (use a column chart type to show this series) Withdrawals from the account. (again use a column chart but with a different color) d. A dynamic chart title similar to the one in the template. 2) A well formatted table, similar to the one in the Excel Template. C. Financial Modelling, I: Assignment #1 Notes: 1. You should submit your assignment electronically using the drop-box on the D2L page for the course. Look under the assignments tab on the course page. 2. Every student should submit their own individual assignment. However, feel free to work with other students in the class to construct your model. You may work with students from other sections of the course. Make sure that you place your name and student number on the assignment. Also, only submit one file, with a title such as: Assignment #2 - Your Name.xlsx" Assignment #1: Retirement Planning Model Open Excel and look for the Retirement Planer Template. You may have to search for this template using the search box at the top of the page. I would like you to recreate a simplified version of this model. First don't worry about the uncertainty" part of this model - just build the basic model, which will generate the table of cash flows shown at the bottom of the model and the chart at the top of the page. I think this should be straight forward except that the table length will have to update to deal with both i) different retirement ages and ii) years in retirement. This slightly more complicated than the Amortization Table problem we looked at in class since each calculation will depend on which of three time buckets you are in i) working phase of life cycle, ii) retirement phase of life cycle and iii) uh - post retirement (that is to say, "dead"). Notes: We are not trying to replicate the techniques used in the template (Multiple sheets and named formulas). Your model should be on one sheet and use if statements to allow for an adjusting table length. You should never hide sheets on any assignment. In addition to a completed, tested, well formatted and well documented model, the Basic outputs that I will be looking for: 1) A well formatted chart showing a. Savings Account balance (use a scatter chart type to show this series) b. Savings deposited into the account. (use a column chart type to show this series) Withdrawals from the account. (again use a column chart but with a different color) d. A dynamic chart title similar to the one in the template. 2) A well formatted table, similar to the one in the Excel Template. C
