Instructions - Simulation Replacement Assignment FinStrit & Budget-1 - Saved to this PC yout References Mailings Review View Help Search A A A A.P.A.E E 2. EEE.. . T Normal To Spec Heading! Heading 2 Heading 3 Tele Paragraph Styles Required: Use the list of transactions on the following page to complete the following: 1. Complete the Horizontal Balance Sheet (excel file available in Canvas) by recording all activity reported by your client lolowing page). 2. Using the completed Horizontal Balance Sheet create an income Statement & Vertical Balance Sheet by using the template provided in the excel file in Canvas). 3. Create a fleable budget that shows expected revenues and expenses at three different volumes of ice cream bors sold (using the excel template). Show budgeted notincore using actual sales in units, med increase in sales of 25.000 units and assumed increase in sales of 50,000 units a. This should include a profoma income statement with the following om Sales Revenue at a projected sales price of $3.50 per unit at each volume level ii. Cost of Goods sold using average purchase price per unit ill. Gross Profit iv. Operating Expenses - Food Costs puled from your Horizontal Balance Sheet V. Net income V. Check Figure/Reflection - Does your calculated Net Income agree to your Horizontal Bolonce Shoot for your actual scles column Why or why not? 4. Purchases for desired ending inventory of $25.000, assuming your ending inventory from the horizontal balance sheet is your beginning inventory for budgeting purposes. 5. A breakeven calculation show your work on the excel file) of how many bons you need to selin order to break even All of these items should be clearly identifiable in your submitted file Instructions - Simulation Replacement A M ENIL PIIT uuuyet-ULUI Search ences Mailings Review View Help Aa- PO E EEEE 211T 2.A. . . . AaBbccDc AaBbcc AaBbc AaBb AaBbCcD 1 Normal 1 No Spac. Heading 1 Heading 2 Heading 3 Styles Paragraph Transaction List: 1. Acquired $500,000 by signing a note payable with a local bank 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 20,000 units at $3.50 on Account 6. Collected $70,000 of accounts receivable 7. Paid $17.250 of Accounts Payable 8. Purchased 150,000 Units of Inventory on Account at $1.05 per unit 9. Sold 153.000 units at $3.50 on Account 10. Colected $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 215,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 (poid in cash) 21. Record Advertising Expenses of $87.500 (paid in cash) 22. Made the yearly required payment on the note payable. The note corries a 7% 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 and useful life of 7 yrs. (straight-line depreciation) 24. Declared a $10,000 cash dividend for stockholders 25. Paid o $10.000 cash dividend for stockholders O Instructions - Simulation Replacement Assignment FinStrit & Budget-1 - Saved to this PC yout References Mailings Review View Help Search A A A A.P.A.E E 2. EEE.. . T Normal To Spec Heading! Heading 2 Heading 3 Tele Paragraph Styles Required: Use the list of transactions on the following page to complete the following: 1. Complete the Horizontal Balance Sheet (excel file available in Canvas) by recording all activity reported by your client lolowing page). 2. Using the completed Horizontal Balance Sheet create an income Statement & Vertical Balance Sheet by using the template provided in the excel file in Canvas). 3. Create a fleable budget that shows expected revenues and expenses at three different volumes of ice cream bors sold (using the excel template). Show budgeted notincore using actual sales in units, med increase in sales of 25.000 units and assumed increase in sales of 50,000 units a. This should include a profoma income statement with the following om Sales Revenue at a projected sales price of $3.50 per unit at each volume level ii. Cost of Goods sold using average purchase price per unit ill. Gross Profit iv. Operating Expenses - Food Costs puled from your Horizontal Balance Sheet V. Net income V. Check Figure/Reflection - Does your calculated Net Income agree to your Horizontal Bolonce Shoot for your actual scles column Why or why not? 4. Purchases for desired ending inventory of $25.000, assuming your ending inventory from the horizontal balance sheet is your beginning inventory for budgeting purposes. 5. A breakeven calculation show your work on the excel file) of how many bons you need to selin order to break even All of these items should be clearly identifiable in your submitted file Instructions - Simulation Replacement A M ENIL PIIT uuuyet-ULUI Search ences Mailings Review View Help Aa- PO E EEEE 211T 2.A. . . . AaBbccDc AaBbcc AaBbc AaBb AaBbCcD 1 Normal 1 No Spac. Heading 1 Heading 2 Heading 3 Styles Paragraph Transaction List: 1. Acquired $500,000 by signing a note payable with a local bank 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 20,000 units at $3.50 on Account 6. Collected $70,000 of accounts receivable 7. Paid $17.250 of Accounts Payable 8. Purchased 150,000 Units of Inventory on Account at $1.05 per unit 9. Sold 153.000 units at $3.50 on Account 10. Colected $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 215,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 (poid in cash) 21. Record Advertising Expenses of $87.500 (paid in cash) 22. Made the yearly required payment on the note payable. The note corries a 7% 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 and useful life of 7 yrs. (straight-line depreciation) 24. Declared a $10,000 cash dividend for stockholders 25. Paid o $10.000 cash dividend for stockholders O