Assignment 2: Tax Issues Associated with Financial PlanningUnderstanding the tax consequences of your financial planning decisions is very important. These decisions may sometimes have life-long consequences in addition to a one-time result.For example, when a person decides to save for retirement, there are tax consequences for each year when money is added to the account as well as when it grows. There are additional consequences later when that person decides to retire and use the money to live on.This assignment looks at another example of tax issues associated with financial planning. You will look at the use of tax-exempt investment instruments such as municipal bonds, as an alternative to traditional investments, and corporate bonds or stocks.Consider the following:Bill Smith, a manager of a restaurant/bar in Los Angeles, is in the 25% marginal tax bracket and pays an additional 5% in taxes to the state of California. Bill has $20,000 invested in corporate bonds which is currently earning an average annual return of 7.5%.Additionally, Bill also has another $20,000 invested in municipal bonds from the city of Los Angeles that are being used to redevelop depressed areas downtown. These bonds pay an average return of 5.4%.Assume that in both cases, Bill earns the same returns as calculated on both the corporate and municipal bonds each year for the next 15 years.Answer the following:What is the after-tax return on Bills corporate bonds for the current year?
What is the after-tax return on his municipal bonds for the current year?
Which investment earns more returns: corporate or municipal bonds?
What would the balance in each account be at the end of the fifteenth year?Present the calculations and answers in Excel spreadsheet format or in Word format. Write the interpretation of results in a Word document. Apply APA standards to citation of sources. Use the following file naming convention: LastnameFirstInitial_M2_A2.xls and LastnameFirstInitial_M2_A2.doc.By Wednesday, October 14, 2015, deliver your assignment to the M2: Assignment 2 Dropbox.
Assignment 2 Grading Criteria
Maximum Points
Correctly computed the tax calculations showing the formulae and the necessary steps.
32
Analyzed the calculations to draw valid conclusions on the investments.
48
Wrote in a clear, concise, and organized manner; demonstrated ethical scholarship in accurate representation and attribution of sources; displayed accurate spelling, grammar, and punctuation.