1. Using the information below, construct a Statement of Owner's Equity for the period Jan. 1, 2019 to Dec. 31, 2019 for the Illini Tap. Some of the items may not be used, some are completed for you, and others may require additional calculation before entering onto the form. Complete the SOE and worksheet using the information below. Change Excess of Market over Book Values (Market - Book) Item: 12/31/2018 12/31/2019 Machinery and Equipment -$10,000 $5,000 Land $0 $5,000 Buildings $0 $10,000 Marketable Securities $13,000 $5,000 Other Investments (local brewery) $20,000 $22,000 Selected Account Balances: Current Deferred Taxes Non-current Deferred Taxes Non-real estate long-term loan balance Total Equity $2,492 $3,000 $165,000 $232,009 $1,359 $12,601 $220,000 $323,041 $91,032 Other Information: 2019 Net Income for Illini Tap was: $151,633 No capital contributions or distributions were made in 2019 The cells shaded in gray in the Excel file already include the subtotal calculations needed for those areas, and a few values have been completed for you. Subtotals will update as you add items. Hint: Complete the Change in Market Valuation section first, then complete the change in Contributed Capital and Retained Earnings section. This is very similar to the in-class example we did for the SOE. 2. Using the information below, construct the 2019 Statement of Cash Flows for the Illini Tap. Some of the items may not be used, a few are completed for you as examples, and other items may require intermediate calculations before entering on the CFS. Remember, you need to calculate Family Living Withdrawals on the SOE, and then use the same value on the Cash Flow Statement. Record which section each item is recorded on the SCF worksheet (Operating, Investing, or Financing). Note any assumptions that you make in the notes section of the SCF worksheet. Section on CFS Notes a 2019 Transactions Land and building purchase Land Cost Building Cost Down Payment Remainder financed on 30-year loan 140,000 300,000 110,000 ??? b Bar Equipment Purchase Cost of new equipment Down Payment Remainder financed on 5-year loan 85,000 15,000 ??? 15,000 20,000 d Sold equipment Sale price Tax basis of equipment sold Investment in local brewery Original cost Current value Dividends received in 2019 50,000 72,000 5,000 f g h i j k 1 Other items: Principal paid on short-term loans Interest paid on short-term loans Family Living Withdrawals Operating Total Cash Sales Principal paid on long-term loans Operating Total Cash Operating Expenses Interest paid on long-term loans in cash Cash Tax Expenses 16,000 2,500 ??? 910,000 Operating inflow 15,000 650,000 Operating outflow 14,500 48,000 Beginning Cash Balance 113,000 Beginning Cash Balance The cells shaded in gray in the Excel file already include the subtotal calculations needed, and a few values have been included for you. Subtotals will update as you add items. Hint: Family Living Withdrawals needs to come from the value you calculated on the SOE. STATEMENT OF OWNER EQUITY for Illini Tap For the period: December 31, 2018 to: December 31, 2019 Item Subtotal Total Change Beginning of period owner equity $ 232,009 a Excess of Market over Book Values (Market - Book) Item: 12/31/18 Machinery and Equipment -$10,000 Land SO Buildings SO Marketable Securities $13.000 Other Investments (local brewery) $20,000 12/31/19 S5,000 $5,000 $10,000 S5,000 $22.000 151,633 b d Changes in contributed capital and retained earnings: Net Income Withdrawals owner/family living Capital Contributions: Debt forgiveness Gifts Inheritances Capital Distributions: Dividends Gifts Inheritances 0 0 0 Selected Account Balances Current Deferred Taxes Non-current Deferred Taxes Non-real estate long-term loan balance Total Equity $2,492 $3,000 $165.000 $232,009 $1,359 $12,601 $220,000 f $323.041 $91,032 9 0 0 h 0 i Other Information: 2019 Net Income for Illini Tap was: $151,633 No capital contributions or distributions were made in 2019 Total change in contributed capital and retained earnings $ >$ 0 k 1 m n Change in market valuation (market value over cost/basis) of: Marketable securities Other business investments Machinery and equipment Land Buildings Other capital assets Personal assets Personal liabilities Total change in market valuation o P g 0 3 Change in noncurrent portion of deferred taxes 4 0 >$ u Total change in valuation equity Total Change in Owner Equity End of period owner equity V 91,032 323,041 W STATEMENT OF CASH FLOWS for Illini Tap Section on CFS Notes a 2019 Transactions Land and building purchase Land Cost Building Cost Down Payment Remainder financed on 30-year loan 140,000 300,000 110,000 ??? Subtotal Total 910,000 Bar Equipment Purchase Cost of new equipment Down Payment Remainder financed on 5-year loan 85,000 15,000 ??? 910,000 >> $ 910,000 For the period: December 31, 2018 to: December 31, 2019 Item CASH FLOWS FROM OPERATING ACTIVITIES Inflows Cash received from business sales/receipts Cash received from net nonbusiness income Total cash inflows from operating activities Outflows Cash paid for operating expenses Cash paid for operating & s.t. loan interest Cash paid for long-term loan interest Cash paid for purchased inputs Cash paid for other items purchased for resale Cash paid for income and social security taxes Cash withdrawals for owner/family living Total cash outflows from operating activities Net cash flows provided by operating activities 650,000 Sold equipment Sale price Tax basis of equipment sold 15,000 20,000 d Investment in local brewery Original cost Current value Dividends received in 2019 50,000 72,000 5,000 650,000 >> $ 650,000 $ 260,000 g h i Other items: Principal paid on short-term loans Interest paid on short-term loans Family Living Withdrawals Operating Total Cash Sales Principal paid on long-term loans Operating Total Cash Operating Expenses Interest paid on long-term loans in cash Cash Tax Expenses 16,000 2,500 ??? 910,000 15,000 650,000 14,500 48,000 Operating inflow Operating outflow CASH FLOWS FROM INVESTING ACTIVITIES Inflows Cash received on sale of machinery/equipment/real estate Cash received from sale of internally transferred capital Cash received from withdrawals of savings Cash received from sale of personal assets/retirement accts. Total cash inflows from investing activities Outflows Cash paid to purchase machinery/equipment/real estate Cash paid to purchased productive capital items Cash paid for deposits to savings accounts Cash paid to purchase marketable securities Cash paid to purchase personal assets/retirement accts. Total cash outflows from investing activities Net cash flows provided by investing activities Beginning Cash Balance 113,000 Beginning Cash Balance CASH FLOWS FROM FINANCING ACTIVITIES Inflows Proceeds from operating loans and short-term notes Proceeds from term debt financing Cash received from capital contributions Total cash inflows from financing activities Outflows Cash repayment of operating and short-term loans Cash repayment of term debt-scheduled Cash repayment of term debt-unscheduled Cash repayment of capital leases Cash payments of dividends and other capital distributions Total cash outflows from financing activities Net cash flows provided by financing activities >> Net increase (decrease) in cash flows Beginning of year cash balance End of year cash balance $ 260,000 $ 113,000 $ 373,000 1. Using the information below, construct a Statement of Owner's Equity for the period Jan. 1, 2019 to Dec. 31, 2019 for the Illini Tap. Some of the items may not be used, some are completed for you, and others may require additional calculation before entering onto the form. Complete the SOE and worksheet using the information below. Change Excess of Market over Book Values (Market - Book) Item: 12/31/2018 12/31/2019 Machinery and Equipment -$10,000 $5,000 Land $0 $5,000 Buildings $0 $10,000 Marketable Securities $13,000 $5,000 Other Investments (local brewery) $20,000 $22,000 Selected Account Balances: Current Deferred Taxes Non-current Deferred Taxes Non-real estate long-term loan balance Total Equity $2,492 $3,000 $165,000 $232,009 $1,359 $12,601 $220,000 $323,041 $91,032 Other Information: 2019 Net Income for Illini Tap was: $151,633 No capital contributions or distributions were made in 2019 The cells shaded in gray in the Excel file already include the subtotal calculations needed for those areas, and a few values have been completed for you. Subtotals will update as you add items. Hint: Complete the Change in Market Valuation section first, then complete the change in Contributed Capital and Retained Earnings section. This is very similar to the in-class example we did for the SOE. 2. Using the information below, construct the 2019 Statement of Cash Flows for the Illini Tap. Some of the items may not be used, a few are completed for you as examples, and other items may require intermediate calculations before entering on the CFS. Remember, you need to calculate Family Living Withdrawals on the SOE, and then use the same value on the Cash Flow Statement. Record which section each item is recorded on the SCF worksheet (Operating, Investing, or Financing). Note any assumptions that you make in the notes section of the SCF worksheet. Section on CFS Notes a 2019 Transactions Land and building purchase Land Cost Building Cost Down Payment Remainder financed on 30-year loan 140,000 300,000 110,000 ??? b Bar Equipment Purchase Cost of new equipment Down Payment Remainder financed on 5-year loan 85,000 15,000 ??? 15,000 20,000 d Sold equipment Sale price Tax basis of equipment sold Investment in local brewery Original cost Current value Dividends received in 2019 50,000 72,000 5,000 f g h i j k 1 Other items: Principal paid on short-term loans Interest paid on short-term loans Family Living Withdrawals Operating Total Cash Sales Principal paid on long-term loans Operating Total Cash Operating Expenses Interest paid on long-term loans in cash Cash Tax Expenses 16,000 2,500 ??? 910,000 Operating inflow 15,000 650,000 Operating outflow 14,500 48,000 Beginning Cash Balance 113,000 Beginning Cash Balance The cells shaded in gray in the Excel file already include the subtotal calculations needed, and a few values have been included for you. Subtotals will update as you add items. Hint: Family Living Withdrawals needs to come from the value you calculated on the SOE. STATEMENT OF OWNER EQUITY for Illini Tap For the period: December 31, 2018 to: December 31, 2019 Item Subtotal Total Change Beginning of period owner equity $ 232,009 a Excess of Market over Book Values (Market - Book) Item: 12/31/18 Machinery and Equipment -$10,000 Land SO Buildings SO Marketable Securities $13.000 Other Investments (local brewery) $20,000 12/31/19 S5,000 $5,000 $10,000 S5,000 $22.000 151,633 b d Changes in contributed capital and retained earnings: Net Income Withdrawals owner/family living Capital Contributions: Debt forgiveness Gifts Inheritances Capital Distributions: Dividends Gifts Inheritances 0 0 0 Selected Account Balances Current Deferred Taxes Non-current Deferred Taxes Non-real estate long-term loan balance Total Equity $2,492 $3,000 $165.000 $232,009 $1,359 $12,601 $220,000 f $323.041 $91,032 9 0 0 h 0 i Other Information: 2019 Net Income for Illini Tap was: $151,633 No capital contributions or distributions were made in 2019 Total change in contributed capital and retained earnings $ >$ 0 k 1 m n Change in market valuation (market value over cost/basis) of: Marketable securities Other business investments Machinery and equipment Land Buildings Other capital assets Personal assets Personal liabilities Total change in market valuation o P g 0 3 Change in noncurrent portion of deferred taxes 4 0 >$ u Total change in valuation equity Total Change in Owner Equity End of period owner equity V 91,032 323,041 W STATEMENT OF CASH FLOWS for Illini Tap Section on CFS Notes a 2019 Transactions Land and building purchase Land Cost Building Cost Down Payment Remainder financed on 30-year loan 140,000 300,000 110,000 ??? Subtotal Total 910,000 Bar Equipment Purchase Cost of new equipment Down Payment Remainder financed on 5-year loan 85,000 15,000 ??? 910,000 >> $ 910,000 For the period: December 31, 2018 to: December 31, 2019 Item CASH FLOWS FROM OPERATING ACTIVITIES Inflows Cash received from business sales/receipts Cash received from net nonbusiness income Total cash inflows from operating activities Outflows Cash paid for operating expenses Cash paid for operating & s.t. loan interest Cash paid for long-term loan interest Cash paid for purchased inputs Cash paid for other items purchased for resale Cash paid for income and social security taxes Cash withdrawals for owner/family living Total cash outflows from operating activities Net cash flows provided by operating activities 650,000 Sold equipment Sale price Tax basis of equipment sold 15,000 20,000 d Investment in local brewery Original cost Current value Dividends received in 2019 50,000 72,000 5,000 650,000 >> $ 650,000 $ 260,000 g h i Other items: Principal paid on short-term loans Interest paid on short-term loans Family Living Withdrawals Operating Total Cash Sales Principal paid on long-term loans Operating Total Cash Operating Expenses Interest paid on long-term loans in cash Cash Tax Expenses 16,000 2,500 ??? 910,000 15,000 650,000 14,500 48,000 Operating inflow Operating outflow CASH FLOWS FROM INVESTING ACTIVITIES Inflows Cash received on sale of machinery/equipment/real estate Cash received from sale of internally transferred capital Cash received from withdrawals of savings Cash received from sale of personal assets/retirement accts. Total cash inflows from investing activities Outflows Cash paid to purchase machinery/equipment/real estate Cash paid to purchased productive capital items Cash paid for deposits to savings accounts Cash paid to purchase marketable securities Cash paid to purchase personal assets/retirement accts. Total cash outflows from investing activities Net cash flows provided by investing activities Beginning Cash Balance 113,000 Beginning Cash Balance CASH FLOWS FROM FINANCING ACTIVITIES Inflows Proceeds from operating loans and short-term notes Proceeds from term debt financing Cash received from capital contributions Total cash inflows from financing activities Outflows Cash repayment of operating and short-term loans Cash repayment of term debt-scheduled Cash repayment of term debt-unscheduled Cash repayment of capital leases Cash payments of dividends and other capital distributions Total cash outflows from financing activities Net cash flows provided by financing activities >> Net increase (decrease) in cash flows Beginning of year cash balance End of year cash balance $ 260,000 $ 113,000 $ 373,000
