Survey of Accounting Comprehensive Assignment - Financial Statements & Flexible Budget As a team for the comprehensive problem, complete the following: 1. Review the completed horizontal balance sheet and correct the entries that contain errors. Background - You are a member of the company's executive team. As a team, you'll need to designate a role for each team member based on your declared major and relevant work and course experience. For example, an accounting major may be designated as the CFO, while a marketing major may be designated as the VP of marketing for the firm. Click here for a great article about who makes up an executive team. Remember - you have some flexibility here depending on your team's makeup. This document was provided by your accounting team for your review. As part of the executive team of this company, you will correct any errors and use the corrected version to construct a full set of financial statements, which will help guide your decision-making process. Your will use the CORRECTE alance sheet and templates provided to complete the following financial statements: Income Statement Vertical Balance Sheet Cash Flow Statement Statement on Stockholder's Equity 3. Use the complete set of financial statements as a basis for your management team's Advisory Board Meeting 4. Flexible budget (using template provided) to include the following assumptions: Three sales volume levels Sales Revenue at a projected sales price of $3.50 per unit at each volume level Cost of Goods Sold using weighted average method for the budget (Use inventory tracking sheet in template to calculate COGS using FIFO for the financial statements. Weighted average method is for the budget ONLY) Operating Expenses - Fixed Costs pulled from your Horizontal Balance Sheet Calculate purchases for desired ending inventory of $35,000, assuming your ending inventory from the horizontal balance sheet is your beginning inventory for budgeting purposes. A breakeven calculation (show your work on the excel file) of how many bars you need to sell in order to break even. . . . These items should be clearly identifiable in your submitted file: 1. Corrected horizontal balance sheet, 2. Complete set of financial statements, & 3. Flexible budget. Survey of Accounting Comprehensive Assignment - Financial Statements & Flexible Budget Executive Team Board Meeting Expectations Deliverable: recorded Executive Team Board Meeting Update (7-10 minutes) & summary of board meeting minutes Background - You are a member of the company's executive team. As a team, you'll need to designate a role for each team member based on your declared major and relevant work and course experience. The makeup of each team will vary based on the diversity of experience and area of focus within each team. For example, an accounting major may be designated as the CFO, while a marketing major may be designated as the VP of marketing for the firm. Be creative with this portion of your project. Your summary of the board meeting minutes should include a list of each member in attendance, including the position they hold with the company, along with a summary of your discussion points during the meeting. You should also record a more formal delivery of the content using Zoom or Microsoft Teams. Each member of your team should share the report related to their area of expertise. Discussion points may include, but are not limited to: How would the errors you identified have impact the financial statements had they been created based on the original document rather than your corrected version? Sales numbers for the past three years are provided below: o One year ago: 410,000 units Two years ago: 395.000 units Three years ago: 380,000 units Does your team agree or disagree with the flexible budget template provided by the accounting team? Use the practice homework #10 problems as a guide for this portion of your discussion. Provide supporting arguments for/against your conclusion. Relevant executives be sure to "weigh in" on the conversation with your thoughts. What trends do you see in these sales numbers when compared to the flexible budget? How could your team invest your cash flow differently to increase profits? Where would you invest and how would that impact your expenses Is there any additional information that could be provided by the accounting team that could be helpful What types of decisions will each executive team member make using this information Explain. . C . o o o . NOTE: You will need to plan for one or more meetings with your group to discuss these points before being prepared to record your summary. This is where the strategic planning meeting with your TA becomes so important. Meet with them early, if possible to be sure you have plenty of time to execute your team's assignment well! If unsure about who makes up an executive team, click here for a great article that provides some additional information you may find useful. Remember - you have some flexibility here depending on your team's makeup, be creative! There are bonus points available on this assignment as addressed in the grading rubric. . . Year 1 Transaction List: 1. Acquired $550,000 by signing a note payable with a local bank on Jan 1. 2. Sold 25,000 shares of $22 par value Common Stock for $1,500,000 3. Purchased Equipment for $300,000 cash 4. Purchased 25,000 Units of Inventory on Account at $1.15 per unit 5. Sold 15,000 units at $3.50 on Account 6. Collected $70,000 of accounts receivable 7. Paid $17,250 of Accounts Payable 8. Purchased 170,000 Units of Inventory on Account at $1.50 per unit 9. Sold 175,000 units at $3.50 on Account 10. Collected $472,500 of accounts receivable 11. Paid $118,600 of Accounts Payable 12. Purchased 275,000 units of Inventory on Account at $1.35 per unit 13. Sold 200,000 units at $3.50 on Account 14. Collected $735,000 of accounts receivable 15. Paid $294,150 of Accounts Payable 16. Purchased 300,000 Units of Inventory on Account at $1.15 per unit 17. Record Sales & Marketing Expenses of $30,000 (paid in cash) 18. Record Operating Expenses of $75,708 (paid in cash) 19. Record Wage Expenses of $40,000 (paid in cash) 20. Record Product Line Research & Development Expenses of $150,000 (paid in cash) 21. Record Advertising Expenses of $87,500 (paid in cash) 22. Made the yearly required payment on the note payable. The note carries a 7% interest rate and requires payments of $50,000 plus interest each December 31. 23. Record Year 1 Depreciation on Equipment with Salvage Value of $38,000 and useful life of 7 Years (straight-line depreciation) 24. Declared a $10,000 cash dividend for stockholders 25. Paid a $10,000 cash dividend for stockholders B F H L M N 0 Q R Balance Sheet Events Assets Inventory Equipment Land Building Liab Notes Payable Equity APIC Cash Acct Rec Accum Depr Acct Payable Div Payable Wages Payable Common Stock Retained Earnings Account Titles for Retained Earnings 5 6 10 11 12 14 15 18 1.Acquired $550,000 by signing a note payable with a local bank 2. Sold 25,000 shares of $22 Common Stock for $1,500,000 7 3. Purchased Equipment 8 4. Purchased Inventory on Account - 25,000 Units at $1.15 per unit 9 5a. Sold 15,000 units at $3.50 on Account 5b. COGS for Sales on Account 6. Collect $70,000 on Account 7. Paid $17,250 of Accounts Payable 13 8. Purchased Inventory on Account - 170,000 Units at $1.50 per unit 9a. Sold 175,000 units at $3.50 on Account 9b. COGS for Sales on Account 16 10. Collect $472,500 on Account 17 11. Paid $118,600 of Accounts Payable 12. Purchased Inventory on Account - 275,000 Units at $1.35 per unit 19 13a. Sold 200,000 units at $3.50 on Account 20 13b. COGS for Sales on Account 21 14. Collect $735,000 on Account 15. Paid $294,150 of Accounts Payable 23 16. Purchased Inventory on Account - 300,000 Units at $1.15 per unit 24 17. Record Sales & Marketing Expenses of $30,000 25 18. Record Operating Expenses of $75,708 26 19. Record Wage Expenses of $40,000 27 20. Record Product Line Research & Development Expenses of $150,000 28 21. Record Advertising Expenses of $87,500 22. Made the yearly required payment on the note payable. The note carries a 7% 29 interest rate and requires payments of $50,000 plus interest each December 31. 23. Record Yr 1 Depreciation on Equipment with Salvage Value of $38,000 & Useful life 30 of 7 yrs 31 24. Declared a $10,000 cash dividend for stockholders 32 25. Paid a $10,000 cash dividend for stockholders 33|| Balance at end of Yr 3 $ 34 35 Total Assets $ Total Liabilities & Equity $ 22 36 37 38 39 A B F G . 1 J L 1 D E Goods Available for Sale Price/ Units Unit Total Cost of Goods Sold Price/ Units Unit Total Ending Inventory Price/ Units Unit Total 2 3 Beg Bal 4 Purchases: 5 6 7 8 9 10 11 12 13 Total 14 15 NOTE: You will need to calculate your estimated COGS for the budget template tab using the 16 Weighted Avergae method discussed in LO5-6 B D F G H 1 1 2 Flexible Budget 3 4 Master Budget at Actual Units Sold in Year 1 Actual Units Sold + 25,000 Actual Units Sold + 50,000 5 6 Sales Revenue Cost of Goods Sold 7 8 9 10 11 12 Gross Profit Operating Expenses Sales & Marketing Operating costs Wages Research & Development Expense Advertising Expense Depreciation Exp Interest Expense 13 14 15 16 17 Net Income 18 19 Inventory Production 20 Beginning Inventory *use ending inventory from CORRECTED horizontal balance sheet for beginning inventory for the 21 22 23 + Purchases Estimated COGS = Desired Ending *actual units at weighted average COGS/unit 24 25 26 Purchases = 27 Note: Calculate next year's estimated purchases for desired ending inventory of $35,000, assuming your ending inventory from the horizontal balance sheet is your beginning inventory for the next year. For Estimated COGS, use the previously calculated weighted average COGS and last years actual units Breakeven Calcuation 28 29 30 31 BE = FC/(CM/Unit) A B 1 Income Statement Year 1 2 3 4 Sales Revenue 5 Less: Cost of Goods Sold 6 Gross Margin $ 7 9 10 8 Less: Expenses Sales & Marketing Operating Costs 11 Wages 12 Research & Development Expense Advertising Expense Depreciation Expense Interest Expense 16 Total Operating Expenses 13 14 15 $ 17 18 Net Income (Loss) $ 19 20 D 1 2 Balance Sheet Year 1 3 4 5 Assets 6 Cash 7 8 9 10 11 12 13 Total Assets $ 14 15 Liabilities 16 Accounts Payable 17 18 19 20 Total Liabilities $ 21 22 Stockholders Equity $ 23 24 25 26 Total Stockholders Equity $ 27 28 29 Total Liabilities and Stockholders Equity $ 30 31 A B D 1 2. Statement on Stockholders' Equity Year 1 3 4 5 6 Beginning Common Stock 7 Plus: common stock issued 8 Plus: additional paid in capital 9 Ending Common Stock $ 10 11 Beginning Retained Earnings 12 Plus: Net Income 13 Less: Dividends 14 Ending Retained Earnings $ 15 16 Total Stockholders' Equity $ 17 Survey of Accounting Comprehensive Assignment - Financial Statements & Flexible Budget As a team for the comprehensive problem, complete the following: 1. Review the completed horizontal balance sheet and correct the entries that contain errors. Background - You are a member of the company's executive team. As a team, you'll need to designate a role for each team member based on your declared major and relevant work and course experience. For example, an accounting major may be designated as the CFO, while a marketing major may be designated as the VP of marketing for the firm. Click here for a great article about who makes up an executive team. Remember - you have some flexibility here depending on your team's makeup. This document was provided by your accounting team for your review. As part of the executive team of this company, you will correct any errors and use the corrected version to construct a full set of financial statements, which will help guide your decision-making process. Your will use the CORRECTE alance sheet and templates provided to complete the following financial statements: Income Statement Vertical Balance Sheet Cash Flow Statement Statement on Stockholder's Equity 3. Use the complete set of financial statements as a basis for your management team's Advisory Board Meeting 4. Flexible budget (using template provided) to include the following assumptions: Three sales volume levels Sales Revenue at a projected sales price of $3.50 per unit at each volume level Cost of Goods Sold using weighted average method for the budget (Use inventory tracking sheet in template to calculate COGS using FIFO for the financial statements. Weighted average method is for the budget ONLY) Operating Expenses - Fixed Costs pulled from your Horizontal Balance Sheet Calculate purchases for desired ending inventory of $35,000, assuming your ending inventory from the horizontal balance sheet is your beginning inventory for budgeting purposes. A breakeven calculation (show your work on the excel file) of how many bars you need to sell in order to break even. . . . These items should be clearly identifiable in your submitted file: 1. Corrected horizontal balance sheet, 2. Complete set of financial statements, & 3. Flexible budget. Survey of Accounting Comprehensive Assignment - Financial Statements & Flexible Budget Executive Team Board Meeting Expectations Deliverable: recorded Executive Team Board Meeting Update (7-10 minutes) & summary of board meeting minutes Background - You are a member of the company's executive team. As a team, you'll need to designate a role for each team member based on your declared major and relevant work and course experience. The makeup of each team will vary based on the diversity of experience and area of focus within each team. For example, an accounting major may be designated as the CFO, while a marketing major may be designated as the VP of marketing for the firm. Be creative with this portion of your project. Your summary of the board meeting minutes should include a list of each member in attendance, including the position they hold with the company, along with a summary of your discussion points during the meeting. You should also record a more formal delivery of the content using Zoom or Microsoft Teams. Each member of your team should share the report related to their area of expertise. Discussion points may include, but are not limited to: How would the errors you identified have impact the financial statements had they been created based on the original document rather than your corrected version? Sales numbers for the past three years are provided below: o One year ago: 410,000 units Two years ago: 395.000 units Three years ago: 380,000 units Does your team agree or disagree with the flexible budget template provided by the accounting team? Use the practice homework #10 problems as a guide for this portion of your discussion. Provide supporting arguments for/against your conclusion. Relevant executives be sure to "weigh in" on the conversation with your thoughts. What trends do you see in these sales numbers when compared to the flexible budget? How could your team invest your cash flow differently to increase profits? Where would you invest and how would that impact your expenses Is there any additional information that could be provided by the accounting team that could be helpful What types of decisions will each executive team member make using this information Explain. . C . o o o . NOTE: You will need to plan for one or more meetings with your group to discuss these points before being prepared to record your summary. This is where the strategic planning meeting with your TA becomes so important. Meet with them early, if possible to be sure you have plenty of time to execute your team's assignment well! If unsure about who makes up an executive team, click here for a great article that provides some additional information you may find useful. Remember - you have some flexibility here depending on your team's makeup, be creative! There are bonus points available on this assignment as addressed in the grading rubric. . . Year 1 Transaction List: 1. Acquired $550,000 by signing a note payable with a local bank on Jan 1. 2. Sold 25,000 shares of $22 par value Common Stock for $1,500,000 3. Purchased Equipment for $300,000 cash 4. Purchased 25,000 Units of Inventory on Account at $1.15 per unit 5. Sold 15,000 units at $3.50 on Account 6. Collected $70,000 of accounts receivable 7. Paid $17,250 of Accounts Payable 8. Purchased 170,000 Units of Inventory on Account at $1.50 per unit 9. Sold 175,000 units at $3.50 on Account 10. Collected $472,500 of accounts receivable 11. Paid $118,600 of Accounts Payable 12. Purchased 275,000 units of Inventory on Account at $1.35 per unit 13. Sold 200,000 units at $3.50 on Account 14. Collected $735,000 of accounts receivable 15. Paid $294,150 of Accounts Payable 16. Purchased 300,000 Units of Inventory on Account at $1.15 per unit 17. Record Sales & Marketing Expenses of $30,000 (paid in cash) 18. Record Operating Expenses of $75,708 (paid in cash) 19. Record Wage Expenses of $40,000 (paid in cash) 20. Record Product Line Research & Development Expenses of $150,000 (paid in cash) 21. Record Advertising Expenses of $87,500 (paid in cash) 22. Made the yearly required payment on the note payable. The note carries a 7% interest rate and requires payments of $50,000 plus interest each December 31. 23. Record Year 1 Depreciation on Equipment with Salvage Value of $38,000 and useful life of 7 Years (straight-line depreciation) 24. Declared a $10,000 cash dividend for stockholders 25. Paid a $10,000 cash dividend for stockholders B F H L M N 0 Q R Balance Sheet Events Assets Inventory Equipment Land Building Liab Notes Payable Equity APIC Cash Acct Rec Accum Depr Acct Payable Div Payable Wages Payable Common Stock Retained Earnings Account Titles for Retained Earnings 5 6 10 11 12 14 15 18 1.Acquired $550,000 by signing a note payable with a local bank 2. Sold 25,000 shares of $22 Common Stock for $1,500,000 7 3. Purchased Equipment 8 4. Purchased Inventory on Account - 25,000 Units at $1.15 per unit 9 5a. Sold 15,000 units at $3.50 on Account 5b. COGS for Sales on Account 6. Collect $70,000 on Account 7. Paid $17,250 of Accounts Payable 13 8. Purchased Inventory on Account - 170,000 Units at $1.50 per unit 9a. Sold 175,000 units at $3.50 on Account 9b. COGS for Sales on Account 16 10. Collect $472,500 on Account 17 11. Paid $118,600 of Accounts Payable 12. Purchased Inventory on Account - 275,000 Units at $1.35 per unit 19 13a. Sold 200,000 units at $3.50 on Account 20 13b. COGS for Sales on Account 21 14. Collect $735,000 on Account 15. Paid $294,150 of Accounts Payable 23 16. Purchased Inventory on Account - 300,000 Units at $1.15 per unit 24 17. Record Sales & Marketing Expenses of $30,000 25 18. Record Operating Expenses of $75,708 26 19. Record Wage Expenses of $40,000 27 20. Record Product Line Research & Development Expenses of $150,000 28 21. Record Advertising Expenses of $87,500 22. Made the yearly required payment on the note payable. The note carries a 7% 29 interest rate and requires payments of $50,000 plus interest each December 31. 23. Record Yr 1 Depreciation on Equipment with Salvage Value of $38,000 & Useful life 30 of 7 yrs 31 24. Declared a $10,000 cash dividend for stockholders 32 25. Paid a $10,000 cash dividend for stockholders 33|| Balance at end of Yr 3 $ 34 35 Total Assets $ Total Liabilities & Equity $ 22 36 37 38 39 A B F G . 1 J L 1 D E Goods Available for Sale Price/ Units Unit Total Cost of Goods Sold Price/ Units Unit Total Ending Inventory Price/ Units Unit Total 2 3 Beg Bal 4 Purchases: 5 6 7 8 9 10 11 12 13 Total 14 15 NOTE: You will need to calculate your estimated COGS for the budget template tab using the 16 Weighted Avergae method discussed in LO5-6 B D F G H 1 1 2 Flexible Budget 3 4 Master Budget at Actual Units Sold in Year 1 Actual Units Sold + 25,000 Actual Units Sold + 50,000 5 6 Sales Revenue Cost of Goods Sold 7 8 9 10 11 12 Gross Profit Operating Expenses Sales & Marketing Operating costs Wages Research & Development Expense Advertising Expense Depreciation Exp Interest Expense 13 14 15 16 17 Net Income 18 19 Inventory Production 20 Beginning Inventory *use ending inventory from CORRECTED horizontal balance sheet for beginning inventory for the 21 22 23 + Purchases Estimated COGS = Desired Ending *actual units at weighted average COGS/unit 24 25 26 Purchases = 27 Note: Calculate next year's estimated purchases for desired ending inventory of $35,000, assuming your ending inventory from the horizontal balance sheet is your beginning inventory for the next year. For Estimated COGS, use the previously calculated weighted average COGS and last years actual units Breakeven Calcuation 28 29 30 31 BE = FC/(CM/Unit) A B 1 Income Statement Year 1 2 3 4 Sales Revenue 5 Less: Cost of Goods Sold 6 Gross Margin $ 7 9 10 8 Less: Expenses Sales & Marketing Operating Costs 11 Wages 12 Research & Development Expense Advertising Expense Depreciation Expense Interest Expense 16 Total Operating Expenses 13 14 15 $ 17 18 Net Income (Loss) $ 19 20 D 1 2 Balance Sheet Year 1 3 4 5 Assets 6 Cash 7 8 9 10 11 12 13 Total Assets $ 14 15 Liabilities 16 Accounts Payable 17 18 19 20 Total Liabilities $ 21 22 Stockholders Equity $ 23 24 25 26 Total Stockholders Equity $ 27 28 29 Total Liabilities and Stockholders Equity $ 30 31 A B D 1 2. Statement on Stockholders' Equity Year 1 3 4 5 6 Beginning Common Stock 7 Plus: common stock issued 8 Plus: additional paid in capital 9 Ending Common Stock $ 10 11 Beginning Retained Earnings 12 Plus: Net Income 13 Less: Dividends 14 Ending Retained Earnings $ 15 16 Total Stockholders' Equity $ 17