6 questions 494814

Writing Style: APA All questions done in excel For this assignment, you will be submitting an Excel worksheet with solutions (and corresponding work) for the problems detailed below. The purpose of this assignment is for you to apply tax planning principles to relevant scenarios. These problems should be submitted in an Excel worksheet, with each problem on a separate tab. Please label the tabs accordingly. You must show your work for each problem. Correct solutions without corresponding work will not be accepted. The Excel document should be labeled as follows: lastname_problems2.xls.  As this is not a formal writing assignment, APA format is not required. Furthermore, there is no need to submit a title page or research page. Just include your full name at the top of first sheet. Problems:  1. Julia currently is considering the purchase of some land to be held as an investment. She and the seller have agreed on a contract under which Julia would pay $1,000 per month for 60 months, or $60,000 total. The seller, not in the real estate business, acquired the land several years ago by paying $10,000 in cash. Two alternative interpretations of this transaction are (1) a price of $51,726 with 6 percent interest and (2) a price of $39,380 with 18 percent interest. Which interpretation would you expect each party to prefer? Why?  2. Assume that a taxpayer can choose when he is to receive $10,000 of fully taxable income. If the taxpayer receives the income at the end of Year 1, he will receive exactly $10,000. If he delays receipt of the income until the end of Year 2, the amount will grow to $11,000. If the taxpayer takes the money at the end of Year 1, he can invest the proceeds and earn a pre- tax return of 10 percent over the next year.  a. If the taxpayer faces a marginal tax rate of 31 percent in both Year 1 and Year 2, when should he elect to receive the income?  b. At what pre- tax rate of return, will the taxpayer be indifferent to taking the money in Year 1 and…