Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

make balance sheet Learn Your Voice Inc We help you learn the voice you want to communicate to the world your dre Group CEO's Name

image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
make balance sheet
Learn Your Voice Inc We help you learn the voice you want to communicate to the world your dre Group CEO's Name Shane Funnell CEO 910998 Proforma Income Statement Today's date 17072020 2023 Year End Source of Revenue (Personal Savings) Source of Revenue (Investors) Source of Revenue (Online Sales) Total Revenue Gross Margin 2021 120000 50000 0 170000 170000 2022 0 0 910000 9100001 910000 0 1050000 1050000 1050000 Other Expenses Marketing... Salaries Legal & admin Equipment Internet Versioning Server Website Server Insurance Office Supplies Utilities Bookkeeping Mise. 3000 120000 2000 2300 180 325 0 1200 360 360 3225 240 131400 396000 1200 0 192 352 352 1320 396 396 3547 264 210000 435600 1320 0 211.2 387.2 387.2 1452 435.6 435.6 3902 290.4 Non-Cash Expenses Equipment Depreciation - Straight Line Purchase/5 years Total Expenses 460 133650 460 535879 460 654881 Net Operating Income 36350 374121 3951191 Income Taxes Net Income 0 0 93530 280591 98780 296339 0 Dividends Retained Earnings 0 280591 0 296339 Proforma Cash Flow Worksheet Proforma Income Stateme Learn Your Voice Inc We help you learn the voice you want to communicate to Group CEO's Name Shane Funnell CEO 910998 Proforma Income Statement Today's date 17072020 2021 2023 Year End Source of Revenue (Personal Savings) Source of Revenue (Investors) Source of Revenue (Online Sales) Total Revenue Less: Cost of Goods Sold (COGS) Gross Margin 90000 50000 779000 9190001 0 0 9190001 2 0 Other Expenses Marketing... Salaries Legal & admin Equipement Internet Website Insurance Office Supplies Utilities Bookkeeping Misc. 135400 468000 3200 2300 180 325 1200 560 720 3225 240 Non-Cash Expenses Equipment Depreciation - Straight Line Purchase 5 years Vehicle Depreciation - Straight Line Purchase 3 years Total Expenses Net Operating Income Income Taxes Net Income Net Income Less: Debt Amortization Dividends Retained Earnings Learn Your Voice Inc We help you learn the voice you want to communicate to the world your drea Proforma Income Statement Today's date 17072020 CEO 910998 Group CEO's Name Shane Funnell Year End Source of Revenue (Personal Savings) Source of Revenue (Investors) Source of Revenue (Online Sales) Total Revenue Gross Margin 2021 120000 50000 0 170000 170000 2022 0 0 910000 910000 910000 2023 0 0 1050000 1050000 1050000 Other Expenses Marketing... Salaries Legal & admin Equipment Internet Versioning Server Website Server Insurance Office Supplies Utilities Bookkeeping Misc. 3000 120000 2000 2300 180 325 0 1200 360 360 3225 240 131400 396000 1200 0 192 352 352 1320 396 396 3547 264 210000 435600 1320 0 211.2 387.2 387.2 1452 435.6 435.6 3902 290.4 Non-Cash Expenses Equipment Depreciation - Straight Line Purchase/5 years Total Expenses Net Operating Income 460 133650 460 535879 460 654881 36350 374121 395119 98780 Income Taxes Net Income 0 0 93530 280591 296339 0 Dividends Retained Earnings 0 0 280591 296339 Learn Your Voice Inc We help you learn the voice you want to communicate to the world your drea CEO Group CEO's Name Shane Funnell Proforma Income Statement Today's date 17072020 910998 2023 Year End Source of Revenue (Personal Savings) Source of Revenue (Investors) Source of Revenue (Online Sales) Total Revenue Gross Margin 2021 120000 50000 0 170000 170000 2022 0 0 910000 910000 910000 0 1050000 1050000 1050000 Other Expenses Marketing... Salaries Legal & admin Equipment Internet Versioning Server Website Server Insurance Office Supplies Utilities Bookkeeping Misc 3000 120000 2000 2300 180 325 0 1200 360 360 3225 240 131400 396000 1200 0 192 352 352 1320 396 210000 435600 1320 0 211.2 387.2 387.2 1452 435.6 435.6 3902 290.4 396 3547 264 Non-Cash Expenses Equipment Depreciation - Straight Line Purchase/5 years Total Expenses 460 133650 460 535879 460 654881 Net Operating Income 36350 374121 3951191 Income Taxes Net Income 0 0 93530 280591 98780 296339 Dividends Retained Earnings 0 0 0 280591 296339 Proforma Cash Flow Worksheet 21 Proforma Cash Flow Worksheet 22 Proforma Income Statemer Management 150 Intro to Entrepreneurship and Small Business Management First year Cashflow Forecast Learn Your Voice Inc. (Voice Teaching Software) Feb Mar Apr May Jun Jul AWE Sep Oct Nov Sources of Cash Opening Month Sources Jan Personal Savings 120000 Investors 50000 Total Sources of Cash 170000 0 D 0 0 0 0 0 0 0 0 0 0 0 0 D 12 Month Total 120000 S0000 170000 0 0 0 D D 0 0 0 0 0 0 0 0 0 D 0 0 0 0 1000 1000 10000 0 0 1000 0 Uses of Cash Marketing Expense 0 Salaries Legal & admin 2000 Equipment 2300 Internet Versioning Server D Insurance D omice Supplies Utilities Bookkeeping D Misc D Total Uses of Cash 4300 Net Cash-flow 165700 Cumulative Cash-flow 165700 3000 120000 2000 2200 180 325 1200 100 D 0 0 10000 10000 10000 D 0 D 0 0 15 15 15 25 25 25 100 100 30 30 30 30 30 30 250 250 475 20 20 20 10470 10470 10693 -10470 -10470 -10695 143735 133265 122570 0 0 10000 10000 0 0 0 0 15 15 25 25 100 100 30 30 30 250 250 20 20 10470 10470 -10470 -10470 112100 1016301 15 25 100 30 0 10000 0 0 15 25 100 30 30 250 20 10470 -10470 91160 15 50 100 30 30 250 201 11495 - 11495 154205 0 10000 0 0 15 25 100 30 30 250 20 10470 -10470 58750 0 10000 0 9 15 25 100 30 30 250 20 10470 -10470 48280 0 15 25 100 30 30 250 20 11470 - 11470 79690 160 1000 10000 0 0 15 25 100 30 30 250 20 11470 -11470 36810 D 160 3225 240 10 250 20 10470 -10470 69220 Notes SALARIES is for one software engineer (refer to a John) at $6000 per month and myself (another software engineer) at $3000 per month for 1 year to develop software. SALARIES for each month after opening consists of owner's salary, consulting software engineer, and four VP's. LEGAL & ADMIN is incorporating business with a cost of $2000 and monthly meeting of 1 hour with cost of $100 EQUIPMENT is a computer from best buy. INTERNET is unlimited internet from telus for video chat meetings with John. VERSIONING SERVER is cost of domain and hosting from versioning server provider WEBSITE is cost of domain and hesting from go daddy. INSURANCE cost is additional cost of running business from home. OFFICE SUPPLIES is pens, paper, ink cartridges, etc. UTILITIES is additional costs for developing and maintaining software. BOOKKEEPING is the cost hourly salary of $50 for five hours on a monthly basis to keep hooks up to date and 1 hour meeting monthly. Also, an additional S275 for doing taxes in april. Proforma Cash Flow Worksheet 21 Proforma Cash Flow Worksheet 22 Proforma Income Statement Mests are se pred mesia Learn Your Voice Inc. (Voice Teaching Software) F Ver Total WE 1 71 29 21 1 11 1 1 Ne . 15 Rolete SALARIES Baterias LEGAL A ADMIN EQUIPMENT SERANCE contri cont of resin bir CYKENPFLIES. Partiet Shades Learn Your Voice Inc We help you learn the voice you want to communicate to the world your dre Group CEO's Name Shane Funnell CEO 910998 Proforma Income Statement Today's date 17072020 2023 Year End Source of Revenue (Personal Savings) Source of Revenue (Investors) Source of Revenue (Online Sales) Total Revenue Gross Margin 2021 120000 50000 0 170000 170000 2022 0 0 910000 9100001 910000 0 1050000 1050000 1050000 Other Expenses Marketing... Salaries Legal & admin Equipment Internet Versioning Server Website Server Insurance Office Supplies Utilities Bookkeeping Mise. 3000 120000 2000 2300 180 325 0 1200 360 360 3225 240 131400 396000 1200 0 192 352 352 1320 396 396 3547 264 210000 435600 1320 0 211.2 387.2 387.2 1452 435.6 435.6 3902 290.4 Non-Cash Expenses Equipment Depreciation - Straight Line Purchase/5 years Total Expenses 460 133650 460 535879 460 654881 Net Operating Income 36350 374121 3951191 Income Taxes Net Income 0 0 93530 280591 98780 296339 0 Dividends Retained Earnings 0 280591 0 296339 Proforma Cash Flow Worksheet Proforma Income Stateme Learn Your Voice Inc We help you learn the voice you want to communicate to Group CEO's Name Shane Funnell CEO 910998 Proforma Income Statement Today's date 17072020 2021 2023 Year End Source of Revenue (Personal Savings) Source of Revenue (Investors) Source of Revenue (Online Sales) Total Revenue Less: Cost of Goods Sold (COGS) Gross Margin 90000 50000 779000 9190001 0 0 9190001 2 0 Other Expenses Marketing... Salaries Legal & admin Equipement Internet Website Insurance Office Supplies Utilities Bookkeeping Misc. 135400 468000 3200 2300 180 325 1200 560 720 3225 240 Non-Cash Expenses Equipment Depreciation - Straight Line Purchase 5 years Vehicle Depreciation - Straight Line Purchase 3 years Total Expenses Net Operating Income Income Taxes Net Income Net Income Less: Debt Amortization Dividends Retained Earnings Learn Your Voice Inc We help you learn the voice you want to communicate to the world your drea Proforma Income Statement Today's date 17072020 CEO 910998 Group CEO's Name Shane Funnell Year End Source of Revenue (Personal Savings) Source of Revenue (Investors) Source of Revenue (Online Sales) Total Revenue Gross Margin 2021 120000 50000 0 170000 170000 2022 0 0 910000 910000 910000 2023 0 0 1050000 1050000 1050000 Other Expenses Marketing... Salaries Legal & admin Equipment Internet Versioning Server Website Server Insurance Office Supplies Utilities Bookkeeping Misc. 3000 120000 2000 2300 180 325 0 1200 360 360 3225 240 131400 396000 1200 0 192 352 352 1320 396 396 3547 264 210000 435600 1320 0 211.2 387.2 387.2 1452 435.6 435.6 3902 290.4 Non-Cash Expenses Equipment Depreciation - Straight Line Purchase/5 years Total Expenses Net Operating Income 460 133650 460 535879 460 654881 36350 374121 395119 98780 Income Taxes Net Income 0 0 93530 280591 296339 0 Dividends Retained Earnings 0 0 280591 296339 Learn Your Voice Inc We help you learn the voice you want to communicate to the world your drea CEO Group CEO's Name Shane Funnell Proforma Income Statement Today's date 17072020 910998 2023 Year End Source of Revenue (Personal Savings) Source of Revenue (Investors) Source of Revenue (Online Sales) Total Revenue Gross Margin 2021 120000 50000 0 170000 170000 2022 0 0 910000 910000 910000 0 1050000 1050000 1050000 Other Expenses Marketing... Salaries Legal & admin Equipment Internet Versioning Server Website Server Insurance Office Supplies Utilities Bookkeeping Misc 3000 120000 2000 2300 180 325 0 1200 360 360 3225 240 131400 396000 1200 0 192 352 352 1320 396 210000 435600 1320 0 211.2 387.2 387.2 1452 435.6 435.6 3902 290.4 396 3547 264 Non-Cash Expenses Equipment Depreciation - Straight Line Purchase/5 years Total Expenses 460 133650 460 535879 460 654881 Net Operating Income 36350 374121 3951191 Income Taxes Net Income 0 0 93530 280591 98780 296339 Dividends Retained Earnings 0 0 0 280591 296339 Proforma Cash Flow Worksheet 21 Proforma Cash Flow Worksheet 22 Proforma Income Statemer Management 150 Intro to Entrepreneurship and Small Business Management First year Cashflow Forecast Learn Your Voice Inc. (Voice Teaching Software) Feb Mar Apr May Jun Jul AWE Sep Oct Nov Sources of Cash Opening Month Sources Jan Personal Savings 120000 Investors 50000 Total Sources of Cash 170000 0 D 0 0 0 0 0 0 0 0 0 0 0 0 D 12 Month Total 120000 S0000 170000 0 0 0 D D 0 0 0 0 0 0 0 0 0 D 0 0 0 0 1000 1000 10000 0 0 1000 0 Uses of Cash Marketing Expense 0 Salaries Legal & admin 2000 Equipment 2300 Internet Versioning Server D Insurance D omice Supplies Utilities Bookkeeping D Misc D Total Uses of Cash 4300 Net Cash-flow 165700 Cumulative Cash-flow 165700 3000 120000 2000 2200 180 325 1200 100 D 0 0 10000 10000 10000 D 0 D 0 0 15 15 15 25 25 25 100 100 30 30 30 30 30 30 250 250 475 20 20 20 10470 10470 10693 -10470 -10470 -10695 143735 133265 122570 0 0 10000 10000 0 0 0 0 15 15 25 25 100 100 30 30 30 250 250 20 20 10470 10470 -10470 -10470 112100 1016301 15 25 100 30 0 10000 0 0 15 25 100 30 30 250 20 10470 -10470 91160 15 50 100 30 30 250 201 11495 - 11495 154205 0 10000 0 0 15 25 100 30 30 250 20 10470 -10470 58750 0 10000 0 9 15 25 100 30 30 250 20 10470 -10470 48280 0 15 25 100 30 30 250 20 11470 - 11470 79690 160 1000 10000 0 0 15 25 100 30 30 250 20 11470 -11470 36810 D 160 3225 240 10 250 20 10470 -10470 69220 Notes SALARIES is for one software engineer (refer to a John) at $6000 per month and myself (another software engineer) at $3000 per month for 1 year to develop software. SALARIES for each month after opening consists of owner's salary, consulting software engineer, and four VP's. LEGAL & ADMIN is incorporating business with a cost of $2000 and monthly meeting of 1 hour with cost of $100 EQUIPMENT is a computer from best buy. INTERNET is unlimited internet from telus for video chat meetings with John. VERSIONING SERVER is cost of domain and hosting from versioning server provider WEBSITE is cost of domain and hesting from go daddy. INSURANCE cost is additional cost of running business from home. OFFICE SUPPLIES is pens, paper, ink cartridges, etc. UTILITIES is additional costs for developing and maintaining software. BOOKKEEPING is the cost hourly salary of $50 for five hours on a monthly basis to keep hooks up to date and 1 hour meeting monthly. Also, an additional S275 for doing taxes in april. Proforma Cash Flow Worksheet 21 Proforma Cash Flow Worksheet 22 Proforma Income Statement Mests are se pred mesia Learn Your Voice Inc. (Voice Teaching Software) F Ver Total WE 1 71 29 21 1 11 1 1 Ne . 15 Rolete SALARIES Baterias LEGAL A ADMIN EQUIPMENT SERANCE contri cont of resin bir CYKENPFLIES. Partiet Shades

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Options Futures And Other Derivatives

Authors: John C. Hull

9th Edition

0133456315, 9780133456318

More Books

Students also viewed these Finance questions