i need help with creating monthly (12 months) projections, for the months oct 2020-oct2021 such as: monthly projections balance sheet, monthly projections income statement, monthly projections statement of cash flows, monthly projections statement of owners equity, monthly payroll projection, monthly sales forecast. i also added the company start up expenses.
Cr Journal Entries Particulars Dr Computer A/c Dr. $500 To Credit Card A/C $500 being computer purchased) Internet Expenses A/c Dr. $100 To Credit Card Alc $100 (being internet expenses paid) Office Supplies A/c Dr. $100 To Credit Card A/C $100 (being office supplies purchases) Office Equipment A/c Dr. $500 To Credit Card A/C $500 (being office equipment purchased) Quickbooks Course Expense A/c Dr $177 To Credit Card A/C $177 (being quickbooks course expense paid) Insurance Down-payment A/c Dr $200 To Credit Card A/C $200 (being error & commission Insurance down payment paid) Business License A/c Dr $70 To Credit Card A/C $70 (being business license expense paid) Quickbooks Software A/c Dr To Credit Card A/C $300 (being quickbooks online software purchased) Website Domain A/c Dr $50 To Credit Card A/C $50 (being website domain purchased) Cellphone Bill A/c Dr $50 To Credit Card A/C $50 (being cellphone bill paid) File Storage A/c Dr $200 To Credit Card A/C $200 (being file storage purchased) Advertisement Expenses A/c Dr $20 To Credit Card A/C $20 (being advertisement expenses paid) CC Processing Charges A/c Dr $32.42 To Credit Card A/C $32.42 (being CC processing charges recorded @ 1.43% of $2,267) Total $2,267 $2,267 Balance Sheet Liabilities Amount Assets Amount Credit card outstanding S 2.299.42 Computer S 500.00 $300 Office Equipment S 500,00 Insurance Down payments 200.00 Quickbooks Software S 300.00 Website Domain S 502 50.00 File Storage S 200.00 Accumulated Deficit S 549.42 Total S 2,299.42 Total S 2,299.42 . Company Expenses A computer that is compatible with excel, spreadsheet, and quickbooks. $500 Access to high-speed internet. $100 Office Supplies. $100 Office equipment (scanners, fax machines, desk and chair. $500 Quickbooks course at a Dallas Community college. $177 Errors & ommissions insurance downpayment (used for any damages, omitions or errors. $200 Business license. $70 Quickbooks online software. $300 Website domain name. $50 Cellphone bill cellphone will be used to speak with any future clients.) $50 File/Storage Cabinets $200 Advertising expense (100 cards for $20) $20 Office at home $0 Credit Card Processing 1.43% of Sales TOTAL: $2,267 . . I Cr Journal Entries Particulars Dr Computer A/c Dr. $500 To Credit Card A/C $500 being computer purchased) Internet Expenses A/c Dr. $100 To Credit Card Alc $100 (being internet expenses paid) Office Supplies A/c Dr. $100 To Credit Card A/C $100 (being office supplies purchases) Office Equipment A/c Dr. $500 To Credit Card A/C $500 (being office equipment purchased) Quickbooks Course Expense A/c Dr $177 To Credit Card A/C $177 (being quickbooks course expense paid) Insurance Down-payment A/c Dr $200 To Credit Card A/C $200 (being error & commission Insurance down payment paid) Business License A/c Dr $70 To Credit Card A/C $70 (being business license expense paid) Quickbooks Software A/c Dr To Credit Card A/C $300 (being quickbooks online software purchased) Website Domain A/c Dr $50 To Credit Card A/C $50 (being website domain purchased) Cellphone Bill A/c Dr $50 To Credit Card A/C $50 (being cellphone bill paid) File Storage A/c Dr $200 To Credit Card A/C $200 (being file storage purchased) Advertisement Expenses A/c Dr $20 To Credit Card A/C $20 (being advertisement expenses paid) CC Processing Charges A/c Dr $32.42 To Credit Card A/C $32.42 (being CC processing charges recorded @ 1.43% of $2,267) Total $2,267 $2,267 Balance Sheet Liabilities Amount Assets Amount Credit card outstanding S 2.299.42 Computer S 500.00 $300 Office Equipment S 500,00 Insurance Down payments 200.00 Quickbooks Software S 300.00 Website Domain S 502 50.00 File Storage S 200.00 Accumulated Deficit S 549.42 Total S 2,299.42 Total S 2,299.42 . Company Expenses A computer that is compatible with excel, spreadsheet, and quickbooks. $500 Access to high-speed internet. $100 Office Supplies. $100 Office equipment (scanners, fax machines, desk and chair. $500 Quickbooks course at a Dallas Community college. $177 Errors & ommissions insurance downpayment (used for any damages, omitions or errors. $200 Business license. $70 Quickbooks online software. $300 Website domain name. $50 Cellphone bill cellphone will be used to speak with any future clients.) $50 File/Storage Cabinets $200 Advertising expense (100 cards for $20) $20 Office at home $0 Credit Card Processing 1.43% of Sales TOTAL: $2,267
