- Create an Income Statement (Statement of Profit or Loss) that covers the first quarter of 2020. All the data is in the spreadsheet; you can find the spreadsheet in week 3.
- Use the same format from Chapter 3 of your text book.
- What is the net surplus/loss of your business for the first three months?
Assignment 3 Worksheet (2) (Protecte File Home Insert Page Layout Formulas Data Review View i Protected View This file originated from an Internet location and might be unsafe. Click for more details. Enab K18 f A B D 4 5 6 Angeles. It is now March 31st 2020 and you are curious to know how well or ba three months. Below are you bank account receipts and payments summary. 7 8 9 Date Transaction Description Receipts Payments 10 1/1/2020 Cash deposit to start business 11 1/1/2020 Three month's rent $ 2,400.00 12 1/1/2020 Cash register paid for $ 450.00 13 1/1/2020 Store furniture paid for $ 8,500.00 14 1/31/2020 Recei for sales in January 2020 $ 6,500.00 15 2/7/2020 Widgets supplied in January paid for $ 4,500.00 16 2/25/2020 Cash withdrawn for your own expenses $ 3,000.00 17 2/29/2020 Receipts for sales in February 2020 $ 9,000.00 18 3/15/2020 Widgets supplied in February paid for $ 6,000.00 19 3/16/2020 Store utility charges for Jan, Feb, Mar 2020 $ 300.00 20 3/31/2020 Receipts for sales March 2020 21 3/31/2020 Balance in bank on March 31st 2020 22. 23 24 25 Assignment: | 26 Create an income statement that covers the first quarter of 2020. Use the same format from Chapter 3 of your text book. What is the net 29 surplus/loss of your business for the three months? Use this spreadsheet to complete your assignment; do not submit a PDF file! 27 28 30 31 >> Sheet1 Ready Type here to search Assignment 3 Worksheet (2) (Protecte File Home Insert Page Layout Formulas Data Review View i Protected View This file originated from an Internet location and might be unsafe. Click for more details. Enab K18 f A B D 4 5 6 Angeles. It is now March 31st 2020 and you are curious to know how well or ba three months. Below are you bank account receipts and payments summary. 7 8 9 Date Transaction Description Receipts Payments 10 1/1/2020 Cash deposit to start business 11 1/1/2020 Three month's rent $ 2,400.00 12 1/1/2020 Cash register paid for $ 450.00 13 1/1/2020 Store furniture paid for $ 8,500.00 14 1/31/2020 Recei for sales in January 2020 $ 6,500.00 15 2/7/2020 Widgets supplied in January paid for $ 4,500.00 16 2/25/2020 Cash withdrawn for your own expenses $ 3,000.00 17 2/29/2020 Receipts for sales in February 2020 $ 9,000.00 18 3/15/2020 Widgets supplied in February paid for $ 6,000.00 19 3/16/2020 Store utility charges for Jan, Feb, Mar 2020 $ 300.00 20 3/31/2020 Receipts for sales March 2020 21 3/31/2020 Balance in bank on March 31st 2020 22. 23 24 25 Assignment: | 26 Create an income statement that covers the first quarter of 2020. Use the same format from Chapter 3 of your text book. What is the net 29 surplus/loss of your business for the three months? Use this spreadsheet to complete your assignment; do not submit a PDF file! 27 28 30 31 >> Sheet1 Ready Type here to search
