1file ----ACC3701 question: Assignment: Complete the following Federal tax return problem. Do not prepare a state income tax return. ? Print out the attached two-page set of facts for Mr. & Mrs. Stevens. ? Using forms available at the IRS web site, manually prepare a federal income tax return for 2013 for the Stevens. Please complete your entire assignment and scan it into a pdf file for submission (as an email attachment) through the Blackboard platform. 2&3 files:question: Prepare a balance sheet, income statement, and statement of cash flows as of December 31. for Arborista, Inc. in an Excel workbook from the attached PDF and Excel Reports Worksheet, submit by May 9th. Saturday evening. 4 Pts.

ACC 3701 SPRING 2014 TAX RETURN PROJECT Dave Stevens, age 34, is a self-employed physical therapist. His wife Sarah, age 31, teaches English as a Second Language at a local language school. Dave's Social Security number is 11111-1111. Sarah's Social Security number is 222-22-2222. Sarah and Dave have three children Andrew, age 8; Isaac, age 6; and Mira, age 3. The children's Social Security numbers are, respectively, 333-33-3333, 444-44-4444, and 555-55-5555. They live at 12637 Pheasant Run, West Bend, Oregon 74658. They paid $8,900 in qualified residence interest and $2,400 in property taxes on their home. They had cash charitable contributions of $14,000. They also paid $180 to a CPA for preparing their federal and state income tax returns for the prior year, $100 of which was for the preparation of Dave's Schedule C. Sarah and Dave earned interest on CDs of $3,200. Sarah's salary for the year is $32,000, from which $9,600 in federal income tax and $1,400 in state income tax were withheld. Dave's office is located at Suite 402, 942 Woodview Drive, Portland, Oregon 74624, and his employer ID number is 11-1111111. Dave has been practicing for four years, and he uses the cash method of accounting. During the current year, Dave recorded the following items of income: Revenue from patient visits Interest earned on the office checking balance $300,000 225 The following expenses were recorded on the office books: Property taxes on the office $ 4,500 Mortgage interest on the office 12,000 Depreciation on the office Malpractice insurance Utilities 4,500 37,500 3,750 Office staff salaries 51,000 Rent payments on equipment 15,000 Office magazine subscriptions Office supplies Medical journals 150 24,000 330 ACC 3701 SPRING 2014 TAX RETURN PROJECT Dave pays $50 annually for use of a safety deposit box to store certain confidential documents related to his business. In addition to his medical practice, Dave spends 15 hours every week managing his real estate investments. To make sure he is aware of all current investment strategies and best practices, he subscribes to the following journals: Wall Street Journal $150 U.S. News & World Report 55 Money Magazine 45 Dave also paid $33,000 in estimated federal income taxes evenly during the year. These payments were made on the required due dates. REQUIRED: Prepare Dave and Sarah's federal income tax return (Form 1040, Schedules A, B, C, and SE) for the 2013 tax year. Disregard any tax credits for which they may be eligible. Do not prepare a state income tax return. Please complete this project without using tax software utilizing forms and worksheets available from the IRS web site. Show supporting calculations, including those found in worksheets to the instructions to Form 1040. If you make any assumptions, so state. This is an individual effort. Once you have completed the entire project, please scan into one pdf file and submit to me as instructed in Blackboard. Arborista, Inc. 12/31/2013 Worksheets No. 1 CF Date Event 12/1/2013 1 Issued 10,000 shares of stock 2 Bank Loan Proceeds Due on 12/31/2015 2a Interest 6% per yr accrues ea mo 3 Purchased 2 pick-up trucks last 5 yrs and be worth 2,000 total 12/7/13 12/14/13 12/21/13 12/28/13 50,000 20,000 50,000 20,000 -14,000 -14,000 Frank is hired paid when work completes Francois is hired paid in advance Tree Revenue = $75 per Tree Wage paid = $20 per Tree 12/18/2013 4 Imaprimadonna 20 trees for 12/19 Frank plants cust. pay terms 3 weeks from 12/19 cust. pays on 1/8/2014 Frank paid on 1/5/14 12/18/2013 5 Bonappetit 30 trees planted Francois plants Schedule for planting on 1/18/2014 cust. pays on 12/18/2013 Francois paid on 12/18/14 2,250 -600 56,000 0 1,650 0 Mo/Yr end 12/31/13 1/4/14 1/11/14 50,000 20,000 Arborista, Inc. Cash Flow Statement year ended 12/31/2013 Cash at Beginning Operating Activities: Net Income Add (Deduct) items not affecting cash Depreciation expense Increase in accounts receivable Increase in other current assets Increase in current liabilities Cash used for Operating Activities -14,000 0 wages payable, unearned reve 0 Investing Activities: Payments for Property, Plant Equipment Cash used by Investing Activities 0 Financing Activities: Proceeds from issuance of common stock 1,500 -400 2,250 -600 57,650 0 1,100 Proceeds from Bank Loan Cash provided by Financing Activities 0 Cash at End 0 wages payable, unearned revenue, & accrued interest Arborista, Inc. 12/31/2013 Worksheets No. 1 IS Date Event 12/1/2013 1 Issued 10,000 shares of stock 2 Bank Loan Proceeds Due on 12/31/2015 2a Interest 6% per yr accrues ea mo 3 Purchased 2 pick-up trucks last 5 yrs and be worth 2,000 total 3a Depr. S.l. 12,000/60 mos. 12/7/13 12/14/13 12/21/13 12/28/13 50,000 20,000 50,000 20,000 -14,000 -14,000 Frank is hired paid when work completes Francois is hired paid in advance Tree Revenue = $75 per Tree Wage paid = $20 per Tree 12/18/2013 Imaprimadonna 20 trees for 12/19 Frank plants cust. pay terms 3 weeks from 12/19 cust. pays on 1/8/2014 Frank paid on 1/5/14 12/18/2013 Bonappetit 30 trees planted Francois plants Schedule for planting on 1/18/2014 cust. pays on 12/18/2013 Francois paid on 12/18/14 2,250 56,000 0 -600 1,650 0 Income Statement 12/31/13 1/4/14 1/11/14 Accounts 50,000 20,000 Interest Expense -100 -14,000 Depreciation Expense -200 1,500 Revenue 1,500 -400 Wages -400 2,250 -600 57,650 0 1,100 Net Income 800 Arborista, Inc. Income Statement year ended 12/31/2013 Sales Less Cost of Goods Sold Gross Margin 0 Operating Expenses 0 Interest Expense Net Income 0 wages Arborista, Inc. 12/31/2013 Worksheets No. 1 BS Date Event 12/1/2013 1 Issued 10,000 shares of stock 2 Bank Loan Proceeds Due on 12/31/2015 Interest 6% per yr accrues ea mo 3 Purchased 2 pick-up trucks last 5 yrs and be worth 2,000 total Depr. S.l. 12,000/60 mos. 12/7/13 12/14/13 12/21/13 12/28/13 50,000 50,000 20,000 20,000 -14,000 -14,000 Frank is hired paid when work completes Francois is hired paid in advance Tree Revenue = $75 per Tree Wage paid = $20 per Tree 12/18/2013 Imaprimadonna 20 trees for 12/19 Frank plants cust. pay terms 3 weeks from 12/19 cust. pays on 1/8/2014 Frank paid on 1/5/14 12/18/2013 Bonappetit 30 trees planted Francois plants Schedule for planting on 1/18/2014 cust. pays on 12/18/2013 2,250 Francois paid on 12/18/14 -600 56,000 0 1,650 0 Arborista, Inc. Balance Sheet 12/31/2013 Balance Sheet 12/31/13 1/4/14 1/11/14 Accounts 50,000 Common Stock Cash Note Payable Cash Accrued Interest 20,000 -14,000 Fixed Assets Cash Accumulated Depr. -50,000 50,000 -20,000 20,000 -100 14,000 -14,000 -200 Cash Accounts Receivable Prepaids Total Current Assets 0 Fixed Assets Accumulated Depr. Net Fixed Assets 0 Total Assets 0 Accrued Expenses Unearned Revenue Total Current Liabilities 0 Notes Payable 1,500 Accounts Receivable -400 Wages Payable 2,250 Unearned Revenue Cash Cash Prepaid Wages -600 57,650 0 1,100 Retained Earnings 1,500 -400 -2,250 2,250 -600 600 800 -800 0 Total Long Term Debt 0 Common Stock Retained Earnings Total Stockholders Equity 0 Total Liab. & Stkhldrs Equity 0 Accrued wages & accrued interest Arborista, Inc. plants trees and shrubs for homeowners. The trees are purchased from and delivered by a sister company, Trees-R-Us, Inc.; Arborista specializes in planting. Arborista obtained capital from family members in exchange for common stock, which provides an ownership interest to the family members. On December 1, a total of $50,000 was raised by issuing 10,000 shares of stock. An additional $20,000 was borrowed from their hometown bank, also on December 1. The principal must be repaid at the end of two years, along with 6 percent interest annually, which accrues as time passes. Also on December 1, Arborista took delivery of, and began using in the business, two previously owned Ford F-250 pick-ups for which it paid cash of $7,000 each. These trucks are expected to last for five more years, and the best guess is that each will be worth $1,000 at the end of the five-year period. Arborista hired two employees to do the planting: Frank and Francois. Frank is extremely knowledgeable, but a bit taciturn. Francois is generally ebullient and has a lovely accent, and so his services were in high demand by the customers of his former employer. As a result of his popularity, Francois negotiated a deal with Arborista that he will be paid in advance for every job (i.e., at the time the job is scheduled). Frank is happy to follow the more generally accepted method of being paid after he does the work. The employees furnish their own tools (i.e., shovels and picks). Arborista decides to charge $75 for planting each tree. The worker planting the tree (i.e., Frank or Francois) will receive $20 per tree as his wage. On December 18, two clients came into the office to arrange to have trees planted on their property. The first client, Ms. Imaprimadonna, was insistent that her 20 trees/shrubs be planted the next day, as it was critical that the work be completed before the holidays. Furthermore, she insisted that Frank do the planting, as she had heard Francois was the chatty type and she did not want to pay someone to chat. In addition, she insisted that Frank must arrive at her house before the clock struck 8:00 a.m., or the order was cancelled. Finally, Ms. Imaprimadonna insisted that she be billed for the job and allowed to pay in three weeks. The second client, Ms. Bonappetit, wanted 30 trees/shrubs planted. She was flexible about when the work would be completed, as long as it was scheduled after the first of the year. However, she did ask that Francois do the work, as she had heard wonderful things about his charming manner from her friend. Ms. Bonappetit insisted on paying in advance, and immediately wrote a check for the total amount. Arborista scheduled Francois to do the work in four weeks and, per their agreement, paid him immediately. Frank arrived at Ms. Imaprimadonna's home at 7:59 a.m. on December 19 and completed the planting to her satisfaction. His next payday is January 5. Ms. Imaprimadonna paid promptly on January 8. Francois performed the work for Ms. Bonappetit on January 15. Both customers promised to recommend Arborista, Inc. to their friends. Required Prepare a balance sheet, income statement, and statement of cash flows as of December 31