10
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).