proj10.xls

Sheet1

Module 7 Course Project - Westchester Wood Ordinary,
Necessary &
1 Income Description Amount Reasonable
sales of unfinished furniture 65,000
services to stain/paint furniture 12,000
sales of paint and stain products 1,000
Total Income 78,000
Expenses
Cost of furniture 38,000
Cost of stains and paints 2,500
Depreciation expense on building 7,000
Advertising 1,200
Auto expenses (delivering furniture) 900
Utilities 4,000
Insurance 3,500
Labor (to stain/paint furniture) 9,800
Property taxes 5,000
Bank fees 2,000
Telephone 2,500
Meals and entertainment 900
Accounting 6,000
Landscaping 1,600
Maintenance 1,200
Total Expenses 86,100
Net Income/Loss -8,100 Correct
Capital Assets Description Amount
Loading dock (new) 22000
Delivery truck (used truck) 9500
Computer 1,300
Total Capital Assets 32,800
2 Hobby
Income Description Amount Expense Tier
sales of unfinished furniture 65,000
services to stain/paint furniture 12,000
sales of paint and stain products 1,000
Total Income 78,000
Expenses Description Amount
Cost of furniture 38,000 Tier 1 Tier 2
Cost of stains and paints 2,500 Tier 1 Tier 2
Advertising 1,200 Tier 1 Tier 2
Auto expenses (delivering furniture) 900 Tier 1 Tier 2
Utilities 4,000 Tier 1 Tier 2
Insurance 3,500 Tier 1 Tier 2
Labor (to stain/paint furniture) 9,800 Tier 1 Tier 2
Property taxes 5,000 Tier 1 Tier 1
Bank fees 2,000 Tier 1 Tier 2
Telephone 2,500 Tier 1 Tier 2
Meals and entertainment 900 Tier 2 Tier 2
Accounting 6,000 Tier 1 Tier 2
Landscaping 1,600 Tier 2
Maintenance Limited to 100, if more use then a loss 100 Tier 2 Tier 2
Total Expenses 78,000
Net income 0
Things to remember: 1. The amount for utilities includes the personal residence and business. You may need to adjust this number. 2. Meals and Entertainment expenses always have an automatic 50% disallowance. 3. Landscaping expense includes the personal residence and the business. You may need to adjust this number. 4. You need to determine what expenses are actually capital assets. Do not include these in your expenses in Part 1 or 2. List these items under the capital assets section that starts on Line 28 of this spreadsheet. There are 3 capital assets. 5. For part 2, Hobby Income/Deductions, you will use the same list of income and expenses as in part 1. You have to assign a Deduction Tier to each expense. Remember, hobby expenses may not exceed income. Hobbies do not report a loss. You need to tell me which expenses will be used to offset the hobby income. You may not have to use all the expenses. 6. The work on Part 1 of this project will be what you input onto the Schedule C for Westchester Wood when you do the final course project. The amount you have now on Line 13 of the Brock's 1040 will change to the amount you calculate this week plus one more entry that you have to do when we move Pamela's miscellaneous income of $1,500 to a Schedule C in a later module. The Brocks will have a loss on the Westchester Wood (HINT).

Sheet2

Sheet3