1
answer
0
watching
59
views
28 Sep 2019
Use the provided Excel spreadsheet for the Critical ThinkingAssignment for this week. In column A, you will find a list oftransactions that may (or may not be deductible). Columns B throughH have options from which you are to select the appropriate taxtreatment of the transaction. Once you have made all of yourselections, upload the completed spreadsheet for grading.
In eachindependent item below, assume that a single taxpayer earned$30,000 in W-2 income. Show the appropriate amount that shouldappear under each heading. More than one option may beselected Item Amount Include in Gross Income Exclude form Gross Income Deduction for AGI Deduction from AGI Appears on Schedule A Appears on Schedule B Appears on Schedule D Interest from Savings Account $60 Dividends from stock investment $500 Bad Debt from an Unpaid Loan $6,000 Donation of automobile to charity $600 Cash donation to church $500 Cash donation to charity $3,000 Student loan interest $1,200 Alimony $12,000 Loss on the sale of stock purchased 5years ago $900 Gain of the sale of stock purchased 6years ago $1,200 Traditional IRA contributions $4,500 Net loss on real estate rentalproperties $6,000 Home business (sole proprietorship)profit $12,000 Moving expenses $2,500
Use the provided Excel spreadsheet for the Critical ThinkingAssignment for this week. In column A, you will find a list oftransactions that may (or may not be deductible). Columns B throughH have options from which you are to select the appropriate taxtreatment of the transaction. Once you have made all of yourselections, upload the completed spreadsheet for grading.
In eachindependent item below, assume that a single taxpayer earned$30,000 in W-2 income. Show the appropriate amount that shouldappear under each heading. More than one option may beselected | ||||||||
Item | Amount | Include in Gross Income | Exclude form Gross Income | Deduction for AGI | Deduction from AGI | Appears on Schedule A | Appears on Schedule B | Appears on Schedule D |
Interest from Savings Account | $60 | |||||||
Dividends from stock investment | $500 | |||||||
Bad Debt from an Unpaid Loan | $6,000 | |||||||
Donation of automobile to charity | $600 | |||||||
Cash donation to church | $500 | |||||||
Cash donation to charity | $3,000 | |||||||
Student loan interest | $1,200 | |||||||
Alimony | $12,000 | |||||||
Loss on the sale of stock purchased 5years ago | $900 | |||||||
Gain of the sale of stock purchased 6years ago | $1,200 | |||||||
Traditional IRA contributions | $4,500 | |||||||
Net loss on real estate rentalproperties | $6,000 | |||||||
Home business (sole proprietorship)profit | $12,000 | |||||||
Moving expenses | $2,500 |
Reid WolffLv2
28 Sep 2019