AutoSave OFF AH ? C ... HW1 template.xIs - Compatibility Mode Home Insert Draw Page Layout Formulas Data Review View Automate ? Tell me Comments LE Share E20 X V fx =SUM(E7:E10, E12:[19) A B C D E F H I J K M N P Q R As of: December 31, 2021 ASSETS 2021 LIABILITIES AND OWNER EQUITY 2021 Cash on hand and in checking account CURRENT ASSETS CURRENT LIABILITIES Market value of all equipment Cash 113,000 a. Accounts payable 2020 Income taxes paid in 2021 Savings & short-term deposits Notes payable within 1 year Cash operating expenses paid in 2021 Marketable securities (at market) Current portion of all term debt Principal portion of 15-year loan due in 2022 Accounts receivable Accrued interest Principal paid on 15-year loan during 2021 Inventories: Accrued expenses nventories: Supplies Supplies and other Accrued taxes Insurance premiums for 2022 paid in Dec. 202 Raw Inputs Accrued business expenses investment in local brewery made in 2016 for $50,000, Intermediate goods Other accrued items estimated market value of $70,000 as of 12/31/21 Completed Goods Current portion-deferred taxes Change in accounts payable during 2021 Cash investment in work-in-progress Other current liabilities - business nventories: Completed goods Prepaid expenses Other current liabilities - personal Principal balance on operating (short-term) loan Other current assets - business Accrued interest on 15-year note Other current assets - personal Accrued interest on operating (short-term) loan TOTAL CURRENT ASSETS 113,000 TOTAL CURRENT LIABILITIES Rent for January 2022, paid in Dec. 202 Accumulated depreciation on equipment Accrued income, social security, and payroll taxes NONCURRENT ASSETS NONCURRENT LIABILITIES 2022 liquor license fees, paid in Dec. 202 Intermediate assets (at market) Noncurrent portion of term business debt: Original cost of all equipment owned Machinery & equipment (at market) 175,000 b. Non-real estate debt: Legal/accountancy services used in 2021, bill not yet received Notes with original maturity less than 10 years Accounts payable Investments in capital leased assets Notes with original maturity greater than 10 years Total principal balance on 15-year loan Investments In cooperative Real estate debt W Mutual funds valued at $83,000 as of 12/31/21, book value of $70,000 Investments in other business entities Notes with original maturity less than 10 years X Capital originally contributed by owner(s) Notes with original maturity greater than 10 years Business real estate (at market) Noncurrent portion-deferred taxes Other: Land Other noncurrent liabilities - business Federal tax rate Buildings Other noncurrent liabilities - personal Self-employment tax rate State tax rate Other noncurrent assets -business (at market) TOTAL NONCURRENT LIABILITIES Other noncurrent assets-personal (at market) TOTAL NONCURRENT ASSETS 175,000 AL LIABILIT OWNER EQUITY Contributed capita 100,000 X. Retained earnings Valuation equity 0 TOTAL OWNER EQUITY 288,000 TOTAL ASSETS 288,000 TOTAL LIABILITIES & OWNER EQUITY 288,000 NOTES to accompany Financial Statements: Book values (cost less depreciation) Financial assets Other investments Machinery and equipment Real-estate land Real-estate buildings Info Balance Sheet Deferred Taxes and VE Short Answer + Ready ? Accessibility: Unavailable 90%AutoSave OFF AH ? C ... HW1 template.xls - Compatibility Mode Home Insert Draw Page Layout Formulas Data Review View Automate ? Tell me Comments LE Share 131 X fx =0.124*MIN(130,125)+0.029*125 A B C F G H J K L M N O P Q R S T U V w Market Value Tax Basis Difference Current Portion 6 10 00 Valuation of Specific Current Asset Items Marketable securities Inventories Accounts receivable Cash investment in work in progress Prepaid expenses 1. Excess of Market Value over Tax Basis of Current Assets (Sum) Deductions Accounts payable Accrued interest Accrued taxes Other accrued expenses 2. Total deductions $ 3. Current portion of deferred taxable income [1 -2, zero if negative] 4. Estimated federal and state income tax rate 30% 28 5. Deferred federal and state tax expense [3x4] o 6. Estimated self-employment tax rate 15.3% 7. Social Security Tax Income Limit 147,000 8. Deferred self-employment tax [the minimum of 3x6 or 7] 32 9. Total current portion of deferred income taxes [5+8] Noncurrent Portion Market Value Tax Basis Gain/Loss Deferred taxable income from noncurrent assets Real Estate - Land Machinery and equipment Real Estate - Buildings oo OO Other Noncurrent Assets 10. Noncurrent portion of deferred taxable income [sum, zero if negative] 0 11. Estimated federal and state income tax rate 30% 2. Total noncurrent portion of deferred taxes [10x11] Valuation Equity: Gain/Loss Real Estate - Land Machinery and equipment Real Estate - Buildings Other Noncurrent Assets Financial Assets/Marketable Securities Less: Personal Liabilities NonCurrent Deferred Taxes Other Total Valuation Equity $0 61 Info Balance Sheet Deferred Taxes and VE Short Answer + Ready Accessibility: Unavailable 100%AutoSave OFF AH ? C ... HW1 template.xls - Compatibility Mode Home Insert Draw Page Layout Formulas Data Review View Automate ? Tell me Comments LE Share B11 X fx B C D E F W N - Briefly explay why deferred taxes are included on the B/S. What would the implications of ignoring deferred taxes be for the B/S? (15 pts.) Type answer here Briefly explain/define Valuation Equity and its potential sources. (15 pts.) Type answer here 8 9 10 Extra Credit: For each unused line item, provide a brief description of why it was NOT used on the 12/31/21 Balance Sheet. (0.5 pts each) 11 Type answer here Info Balance Sheet Deferred Taxes and VE Short Answer + Ready Accessibility: Unavailable + 100%lECBEQJE Insert Table Chart Text Shape Media Instructions: (i) Use the Excel template provided in the Homework 1 folder on the Canvas website (\"HWl template") (ii) This assignment should submitted to Canvas by 5:00 pm on Wednesday September 6, 2023 (iii) You should submit the excel template with the 'Balance Sheet' and \"Deferred Taxes and VE' worksheets both completed, and answers to the short questions included on the 'Short Answer' worksheet, This semester we will be using a bar, \"The Illini Tap\11$E~E @ .9 Insert Table Chart Text Shape Media Collaborate Format Document Cash on hand and in checking account 113,000 b, Market value of all equipment 175,000 c. 2020 Income taxes paid in 2021 32,000 d. Cash operating expenses paid in 2021 618,000 Principal portion of 15year loan due in 2022 15,000 f. Principal paid on 15-year loan during 2021 14,000 g, Inventories: Supplies 9,000 Insurance premiums for 2022 paid in Dec. 2021 20,500 Investment in local brewery made in 2016 for $50,000, estimated market value of $70,000 as of 12/31/21 7?? j Change in accounts payable during 2021 1,500 k, Inventories: Completed goods 27,000 Principal balance on operating (short-term) loan 16,000 m, Accrued interest on 15yea.r note 9,000 Accmed interest on operating (shortterm) loan 1,000 0. Rent for January 2022, paid in Dec. 2021 5,000 p, Accumulated depreciation on equipment 110,000 Accrued income, social security, and payroll taxes 21,000 E 2022 liquor license fees, paid in Dec, 2021 4,000 s, Original cost of all equipment owned295,000 Legal/accountancy services used in 2021, bill not yet received 3,000 u, Accounts payable 39,000 . ct an ODJCCI or text to tormai v. Total principal balance on 15year loan 180,000 Mutual funds valued at $83,000 as of 12/31/21, book value of $70,000 '27? Capital originally contributed by owner(s) 100,000 Nothing selected, Federal tax rate 25% Self-employment tax rate 15.30% State tax rate 5% Note that a few items have already been added for you (a., b., and x.). There are subtotal calculations in some cells that will update as you enter values on the balance sheet or deferred tax worksheets (cells shaded in gray). The deferred tax value, current and non-current are shaded in red on both the balance sheet and the deferred tax worksheet. The valuation equity cells are shaded in blue on both the balance sheet and the valuation equity worksheet. These cells all contain formulas and references that should not be changed; they will update/compute automatically as you complete the assignment