balance each year. Prepare one table showing the Roth IRA and one showing the Traditional IRA. Both tables and the input variable section should easily t on a single page if set to print in landscape mode see sample format below. Remember, a professional presentation includes proper titles and headings, is centered on the page when printed, and is a reasonable size on the page. Test the appearance of the worksheet by using the print preview function in Excel. Professional appearance counts so don't overlook this part of the assignment. A contribution to a traditional IRA provides a deduction for the taxpayer. This means there is no tax paid on the amount contributed so the full \"Amount Available to Contribute\" is deposited in the IRA account. A contribution to a Roth IRA is subject to tax. This means the amount available to contribute is reduced by the tax paid on it (Date of Contribution Tax Rate). Since a Roth IRA contribution is taxed, the net of tax amount of the contribution will be the starting point for the Roth IRA table. All numbers in the output section must be formulas for this to work. Check figure: If you have prepared the worksheet correctly, the net of tax distribution amount will be the same for the traditional and Roth IRA if the tax rate on contribution and the tax rate on distribution are the same. Page two of your Excel model should be a chart showing the history of each contribution. Be sure to end with the net of tax dollar amounts. Note labelling: titles, legend, etc. Assignment Summary: You are expected to submit a working Excel model with the Traditional vs Roth IRA tables (page 1) with the chart (page 2). Be sure to include your observation regarding choosing a Roth versus a Traditional IRA at the bottom of the tables. Can you make a generalization about when it is best to use one over the other? Use your model to make this determination. Hint: The answer is NOT \"use the traditional IRA\" or \"use the ROTH IRA\"- there is a bit more to it than that