I will like a tutor to explain this to me. I am getting myself confused on the instructions. Someone that could have time to provide me the steps on how to fill out the 1065. I am having trouble form 1a-22 in the for 1065. The information provided has been attached. I don't know if I need to calculate the information on the Excel that has (##############) sign on it.
\fOrdinary lncomefExpen se Income 43700 - Fee for Service Income W 47300 - Refunds -17,633.00 Total Income WWW Expense 60000 - Advertising and Promotion 1,252.00 60200 - Automobile Expense 11,061.00 604-00 - Bank Service Charges 6,606.00 61000 - Business Licenses and Permits 5,611.00 61100 - Charitable Contributions {Cash} 100,000.00 61700 - Computer and Internet Expenses 13,575.00 6240-0 - Depreciation Expense 626,702.00 62500 - Dues and Subscriptions 6,327.00 62600 - Equipment Rental 62610 - Laser Facility Rent 14,070.00 62600 - Equipment Rental - Other 201,106.00 Total62600 - Equipment Rental 216,065.00 63300 - Insurance Expense 55,356.00 63400 - Interest Expense 63,676.00 63600 - Laboratory Testing Fees 121,653.00 64300 - Meals and Entertainment 6,362.50 644-00 - Medical Records and Supplies 103,456.00 66700 - Professional Fees 123,045.00 67200 - Repairs and Maintenance 16,655.00 67600 - Salaries and Wages 67610 - Guaranteed Payments 040,000.00 67600 - Salaries and Wages - Other 321,560.00 Total 67600 - Salaries and Wages W 66000 - Taxes 66010 - Payroll Taxes 206,103.00 66020 - State Tax 30,652.00 Total 66000 - Taxes 236,755.00 66500 - Uniforms 16,121.00 66600 - Utilities 30,364.00 Total Expense m Net Ordinary Income W Other IncomerExpense Other Income 70200 - Interest Income 633.00 70222 - Tax Exempt Interest 0.00 70300 - Sublease Rents 240,000.00 71000 - Dividends 60,000.00 75000 - Gain on Sale of As sets 75,000.00 Total Other Income 305,633.00 Other Expense \"1 AC - III1 Accrual to Cash Adjustment 13,507.00 Total Other Expense 13, 507.00 Het Other Income 362,236.00 Income W Schedule M-1 Line 10 SEI'S Current Assets CheckingtSavings 10001 - Checking 10010 - Savings 10020 - Cash Maximizer Total C heckinthavinqs Accounts Receivable 11000 - Accounts Receivable Total Accounts Receivable Other Current As sets 15100 - Loan to Shareholder Total Other Current As sets Total Current Assets Fixed As sets 15000 - Furniture and Equipment 15500 - Leasehold lm provements 13100 - Medical Equipment 17000 - Accumulated Depreciation Total Fixed As sets Other Assets 15001 - Investment in Big Labs 13050 - Investment in RED Company Total Other Assets 'AL ASSETS BILITIES 5 E".'.II.|I'|"'Ir Liabilities Current Liabilities Accounts Payable 20001 - Accounts Payable Total Accounts Payable Credit Cards 20100 - Credit Cards Total Credit Cards Other Current Liabilities 20200 - Accrued Salaries Total Other Current Liabilities Total Current Liabilities Long Term Liabilities 23001 - Business Loan Total Long Term Liabilities Total Liabilities Equity 30100 - Capital Stock 31400 - Shareholder Distributions 32000 - Retained Earnings Net Income Total Equity 'AL LIABILITIES 3 EQUI'I'Y Dec31,15 Dec31,14 SChange 309,342.00 277,131.00 332,711.00 557,392.23 325,541.23 231,351.00 553,330.05 39,372.05 433,703.00 55555555555 372,344.23 W 230,990.00 323,113.00 535,123.00 230,990.00 323,113.00 -535,123.00 75,000.00 0.00 75,000.00 75,000.00 0.00 75,000.00 WWW 15555555555 533,147.00 40,313.00 40,313.00 0.00 503,339.00 503,339.00 0.00 55555555555 m 239,333.00 55555555555 m -323,702.00 373,203.00 437,022.00 -53,314.00 55555555555 m 900,000.00 333,507.20 334,352.20 502,155.00 W W W W W W 122,301.00 107,245.00 15,353.00 122,301.00 107,245.00 15,353.00 39,035.51 34,742.51 4,323.00 35,555.51 34,?42.51 4,523.55 0.00 23,375.00 -23,375.00 0.00 23,375.00 -23,375.00 151 ,55551 155,552.51 5.55-5.55 m m 123,022.00 m m -123,022.00 m m 132,713.00 1,000.00 1,000.00 0.00 400,000.00 0.00 400,000.00 55555555555 m 0.00 m 0.00 mm m W W W W w . University of Phoenix Material Phoenix Medical Worksheet Week 5: Prepare Form 1065: 1. You are provr ed with the nancial reports [2 year balance sheet and current year prol'll and loss in Microsoft Excelj along with the supplemental information that provldes the details required to prepare a tax retum foryour new tax cllent Phoenix Medical, LLC. 2. Fill out pages 1 through 5 of Form 1065 US Return of Partnership Income Include as many details as you can. Utilize the PDF Form 1065 provided and consult the lonn in- stru ctions where needed. 3. Util ng the "Member Detail\" tab in the spreadsheet, calculate the beginning capital and ending capital for each member 4. Utilizing your capital account calculations and the infonnatlon below, ll out the PDF Schedule K71 (Form 1065) provided 5. Upload the completed tax return, Kits. and capital account workpaper to the assignment tab. Supplemental information ior Phoenix Medical LLC. FORM 1065 Information: Page 1 Information: Calendar year ending 121311201 4: Co or pany N ame: Phoenix Medical, LLC. 1122 Three Ave Phoenix, AZ 85001 A. Business Activity Code: 621111 E. Business Activity: Medical C. Product or Services: Skin Care D. EIN: 246673901 E. Dale Incorporated: 312712005 H. Cash Sdledule B Page 2 3. 3 Information: 02 Individuals account for 100% ownership. 03 No changes in ownership in 2014. Q! The LLC is not a 20% or greater owner in any other entity. 05 No. Qd. No. 01-17. No. 018. Yes. 019-20. No Screens 1-2 of 3 0 Type here to search