Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

All I know is that I am to use an imaginary company that I make up other than that I don't know what to do.

image text in transcribedimage text in transcribedimage text in transcribed

All I know is that I am to use an imaginary company that I make up other than that I don't know what to do. This is what I was given. This is all the information I was given. The company was not given nor were any numbers. I am trying to figure out what I need to do.

You should be able to stretch the image. It is a screenshot.

12 month profit and loss projection (2) - Excel (Product Activation Failed) ? - . X DRAWING TOOLS FORMAT PAGE LAYOUT FORMULAS DATA REVIEW VIEW mysweetmind Espitia X GS FILE HOME INSERT % Cut Arial Copy - Paste Format Painter Painter B I Clipboard D General Bad 7 i - 10 - AA === A E Wrap Text Merge & Center - U. $ %, too! Normal Conditional Format as Good Formatting Table Styles Neutral Insert Delete Format AutoSum A- Fill Sort & Find & Clear Filter - Select Editing Font Alignment Number Cells J K L M N O P Q R S T U V W X Y Z AA AB AC AD AE AF AG AH AI AJ AK A Text Box 5 x fx A B C D E F G H I Profit and Loss Projection (12 Months) 2 Notes on Preparation 1 3 You may want to print this information to use as reference later. To delete these instructions, click the border of this text box and then press the DELETE key. You should change "category 1, category 2", etc. labels to the actual names of your sales categories. Enter sales for each category for each month. The spreadsheet will add up eet will show the % of total sales contributed by each category COST OF GOODS SOLD (also called Cost of Sales or COGS): COGS are those expenses directly related to producing or buying your products or services. For example, purchases of inventory or raw materials, as well as the wages (and payroll taxes) of employees directly involved in producing your products/services, are included in COGS. These & expenses usually go up and down along with the volume of production or sales. Study your records to determine COGS for each sales category. Control of COGS is the key to profitability for most businesses, so approach this part of your forecast with great care. For each category of product/service, analyze the elements of COGS: how much for labor, for materials, for packing, for shipping, for sales commissions, etc.? Compare the Cost of Goods Sold and Gross Profit of your various sales categories. Which are most profitable, and which are least - and why? Underestimating COGS can lead to under pricing, which can destroy your ability to earn a profit. Research carefully and be realistic. Enter the COGS for each category of sales for each month. In the "%" columns, the spreadsheet will show the COGS as a % of sales dollars for that category. 9 GROSS PROFIT: Gross Profit is Total Sales minus Total COGS. In the "%" columns, the spreadsheet will show Gross Profit as a % of Total Sales. 18 15 OPERATING EXPENSES (also called Overhead): These are necessary expenses which, however, are not directly related to making or buying your products/services. Rent, 16 utilities, telephone, interest, and the salaries (and payroll taxes) of office and management employees are examples. Change the names of the Expense categories to suit your type of business and your accounting system. You may need to combine some categories, however, to stay within the 20 line limit of the spreadsheet. Most operating expenses remain reasonably fixed regardless of changes in sales volume. Some, like sales commissions, may vary with sales. Some, like utilities, may vary with the time of year. Your projections should reflect these fluctuations. The only rule is that the projections should simulate your financial reality as nearly as possible. In the "%" columns, the spreadsheet will show Operating Expenses as a % of Total Sales. 22 NET PROFIT: The spreadsheet will subtract Total Operating Expenses from Gross Profit to calculate Net Profit. In the "%" columns, it will show Net Profit as a % of Total Sales. 24 INDUSTRY AVERAGES: The first column, labeled "IND.%" is for posting average cost factors for firms of your size in your industry. Industry average data is commonly available from industry associations, major manufacturers who are suppliers to your industry, and local colleges, Chambers of Commerce, and public libraries. One common source is the 26 book Statement Studies published annually by Robert Morris Associates. It can be found in major libraries, and your banker almost surely has a copy. It is unlikely that your expenses will be exactly in line with industry averages, but they can be helpful in areas in which expenses may be out of line. Pnl projection Sheet1 + READY @ -- + 100% - 11:19 PM 1 Type here to search [ e M 8 9 wi x] ) al 4/5/2020 12 month profit and loss projection (2) - Excel (Product Activation Failed) ? - . X FORMULAS DATA REVIEW VIEW mysweetmind Espitia X GS FILE HOME INSERT PAGE LAYOUT % Cut Arial - 10 Copy - Paste Format Painter BI D A AA === E On O AutoSum : Normal Wrap Text General Bad SE Merge & Center - $ % 48.00 Neutral Insert Delete Format Conditional Format as Good Formatting Table Styles Clear Sort & Find & Filter - Select Editing Clipboard Font Alignment Number Cells M3 XV fic A B C D E F G H I 1 Profit and Loss Projection (12 Months) 2 Enter your Company Name here J K L M N O P Q R S T U V W X Y Z AA AB AC AD AE AF AG AH AI AJ AK A 3 4 Fiscal Year Begins 5 Jan-08 6 IND. % Jan-08 % B/A Feb-08 Mar-08 Apr-08 May-08 Jun-08 Jul-08 Aug-08 Sep-08 Od-08 Nov-08 Dec-08 YEARLY 8 Revenue (Sales) 9 Category 1 10 Category 2 11 Category 3 12 Category 4 13 Category 5 14 Category 6 15 Category 7 16 Total Revenue (Sales) 0.0 0 0.0 0 0. 00 0. 00 0. 00 0.0 0 0.0 0 0.0 0 0.0 0 0 OL TTTTTTIII 18 Cost of Sales 19 Category 1 20 Category 2 21 Category 3 22 Category 4 23 Category 5 24 Category 6 25 Category 7 26 Total Cost of Sales 21 28 Gross Profit I 291 30 Expenses 31 Salary expenses 32 Payroll expenses 33 Outside services Supplies (office and 31 onoratinal Pnl projection 0 0- 0-1 0- 0- 0- 0- 0- 0- 0 0- 0 0- 0 0- 0-| || Sheet1 + READY @ -- + 100% - 11:18 PM 1 Type here to search D e M @ 9 wi x] Bb 3 4/5/2020 12 month profit and loss projection (2) - Excel (Product Activation Failed) ? - . X FORMULAS DATA REVIEW VIEW mysweetmind Espitia AA === On AutoSum : General Bad Wrap Text Merge & Center - A $ % 898 Normal Conditional Format as Good Formatting Table Styles Neutral Insert Delete Format Clear Sort & Find & Filter - Select Editing Alignment Number Cells fx F G H I K M N O P Q R S T - U V W X Y Z AA AB AC 0 AD AE AF AG AH AI AJ AK A J - L - L - - - - - L - - - L - - - L - L - - 1 | - - - X GS FILE HOME INSERT PAGE LAYOUT Cut Arial - 10 Copy - Paste Format Painter Painter B I U - Clipboard Font M3 X A B C D E 23 Category 5 L - 24 Category 6 - 25 Category 7 - 26 Total Cost of Sales 0 0 28 Gross Profit I 0 | 0 29 30 Expenses 31 Salary expenses L 32 Payroll expenses 33 Outside services Supplies (office and 34 operating) Repairs and 35 maintenance 36 Advertising 37 Car, delivery and travel 38 Accounting and legal 39 Rent 40 Telephone 41 Utilities 42 Insurance 27 0 0 0 0 0 0 0 0 0 0 0 0 1 | 0 0 0 0 - 1 | 0 0 0 0 1 | | | | | | | | T TTTTTTTTTTT 43 Taxes (real estate, etc.) 44 Interest 45 Depreciation Other expenses 46 (specify) Other expenses 47 (specify) Other expenses 48 (specify) 49 Misc. (unspecified) 50 Total Expenses 52 Net Profit 51 - 01- 01 - | 0 - | 0 - | 0 - | 0 - | 0 - | 0 - | 0 - | 0 - | 0 - | 0 I | 64 1 READY Pnl projection Sheet1 + @ -- + 100% 11:18 PM 1 Type here to search [ e M 8 9 wi x] ) al 4/5/2020 12 month profit and loss projection (2) - Excel (Product Activation Failed) ? - . X DRAWING TOOLS FORMAT PAGE LAYOUT FORMULAS DATA REVIEW VIEW mysweetmind Espitia X GS FILE HOME INSERT % Cut Arial Copy - Paste Format Painter Painter B I Clipboard D General Bad 7 i - 10 - AA === A E Wrap Text Merge & Center - U. $ %, too! Normal Conditional Format as Good Formatting Table Styles Neutral Insert Delete Format AutoSum A- Fill Sort & Find & Clear Filter - Select Editing Font Alignment Number Cells J K L M N O P Q R S T U V W X Y Z AA AB AC AD AE AF AG AH AI AJ AK A Text Box 5 x fx A B C D E F G H I Profit and Loss Projection (12 Months) 2 Notes on Preparation 1 3 You may want to print this information to use as reference later. To delete these instructions, click the border of this text box and then press the DELETE key. You should change "category 1, category 2", etc. labels to the actual names of your sales categories. Enter sales for each category for each month. The spreadsheet will add up eet will show the % of total sales contributed by each category COST OF GOODS SOLD (also called Cost of Sales or COGS): COGS are those expenses directly related to producing or buying your products or services. For example, purchases of inventory or raw materials, as well as the wages (and payroll taxes) of employees directly involved in producing your products/services, are included in COGS. These & expenses usually go up and down along with the volume of production or sales. Study your records to determine COGS for each sales category. Control of COGS is the key to profitability for most businesses, so approach this part of your forecast with great care. For each category of product/service, analyze the elements of COGS: how much for labor, for materials, for packing, for shipping, for sales commissions, etc.? Compare the Cost of Goods Sold and Gross Profit of your various sales categories. Which are most profitable, and which are least - and why? Underestimating COGS can lead to under pricing, which can destroy your ability to earn a profit. Research carefully and be realistic. Enter the COGS for each category of sales for each month. In the "%" columns, the spreadsheet will show the COGS as a % of sales dollars for that category. 9 GROSS PROFIT: Gross Profit is Total Sales minus Total COGS. In the "%" columns, the spreadsheet will show Gross Profit as a % of Total Sales. 18 15 OPERATING EXPENSES (also called Overhead): These are necessary expenses which, however, are not directly related to making or buying your products/services. Rent, 16 utilities, telephone, interest, and the salaries (and payroll taxes) of office and management employees are examples. Change the names of the Expense categories to suit your type of business and your accounting system. You may need to combine some categories, however, to stay within the 20 line limit of the spreadsheet. Most operating expenses remain reasonably fixed regardless of changes in sales volume. Some, like sales commissions, may vary with sales. Some, like utilities, may vary with the time of year. Your projections should reflect these fluctuations. The only rule is that the projections should simulate your financial reality as nearly as possible. In the "%" columns, the spreadsheet will show Operating Expenses as a % of Total Sales. 22 NET PROFIT: The spreadsheet will subtract Total Operating Expenses from Gross Profit to calculate Net Profit. In the "%" columns, it will show Net Profit as a % of Total Sales. 24 INDUSTRY AVERAGES: The first column, labeled "IND.%" is for posting average cost factors for firms of your size in your industry. Industry average data is commonly available from industry associations, major manufacturers who are suppliers to your industry, and local colleges, Chambers of Commerce, and public libraries. One common source is the 26 book Statement Studies published annually by Robert Morris Associates. It can be found in major libraries, and your banker almost surely has a copy. It is unlikely that your expenses will be exactly in line with industry averages, but they can be helpful in areas in which expenses may be out of line. Pnl projection Sheet1 + READY @ -- + 100% - 11:19 PM 1 Type here to search [ e M 8 9 wi x] ) al 4/5/2020 12 month profit and loss projection (2) - Excel (Product Activation Failed) ? - . X FORMULAS DATA REVIEW VIEW mysweetmind Espitia X GS FILE HOME INSERT PAGE LAYOUT % Cut Arial - 10 Copy - Paste Format Painter BI D A AA === E On O AutoSum : Normal Wrap Text General Bad SE Merge & Center - $ % 48.00 Neutral Insert Delete Format Conditional Format as Good Formatting Table Styles Clear Sort & Find & Filter - Select Editing Clipboard Font Alignment Number Cells M3 XV fic A B C D E F G H I 1 Profit and Loss Projection (12 Months) 2 Enter your Company Name here J K L M N O P Q R S T U V W X Y Z AA AB AC AD AE AF AG AH AI AJ AK A 3 4 Fiscal Year Begins 5 Jan-08 6 IND. % Jan-08 % B/A Feb-08 Mar-08 Apr-08 May-08 Jun-08 Jul-08 Aug-08 Sep-08 Od-08 Nov-08 Dec-08 YEARLY 8 Revenue (Sales) 9 Category 1 10 Category 2 11 Category 3 12 Category 4 13 Category 5 14 Category 6 15 Category 7 16 Total Revenue (Sales) 0.0 0 0.0 0 0. 00 0. 00 0. 00 0.0 0 0.0 0 0.0 0 0.0 0 0 OL TTTTTTIII 18 Cost of Sales 19 Category 1 20 Category 2 21 Category 3 22 Category 4 23 Category 5 24 Category 6 25 Category 7 26 Total Cost of Sales 21 28 Gross Profit I 291 30 Expenses 31 Salary expenses 32 Payroll expenses 33 Outside services Supplies (office and 31 onoratinal Pnl projection 0 0- 0-1 0- 0- 0- 0- 0- 0- 0 0- 0 0- 0 0- 0-| || Sheet1 + READY @ -- + 100% - 11:18 PM 1 Type here to search D e M @ 9 wi x] Bb 3 4/5/2020 12 month profit and loss projection (2) - Excel (Product Activation Failed) ? - . X FORMULAS DATA REVIEW VIEW mysweetmind Espitia AA === On AutoSum : General Bad Wrap Text Merge & Center - A $ % 898 Normal Conditional Format as Good Formatting Table Styles Neutral Insert Delete Format Clear Sort & Find & Filter - Select Editing Alignment Number Cells fx F G H I K M N O P Q R S T - U V W X Y Z AA AB AC 0 AD AE AF AG AH AI AJ AK A J - L - L - - - - - L - - - L - - - L - L - - 1 | - - - X GS FILE HOME INSERT PAGE LAYOUT Cut Arial - 10 Copy - Paste Format Painter Painter B I U - Clipboard Font M3 X A B C D E 23 Category 5 L - 24 Category 6 - 25 Category 7 - 26 Total Cost of Sales 0 0 28 Gross Profit I 0 | 0 29 30 Expenses 31 Salary expenses L 32 Payroll expenses 33 Outside services Supplies (office and 34 operating) Repairs and 35 maintenance 36 Advertising 37 Car, delivery and travel 38 Accounting and legal 39 Rent 40 Telephone 41 Utilities 42 Insurance 27 0 0 0 0 0 0 0 0 0 0 0 0 1 | 0 0 0 0 - 1 | 0 0 0 0 1 | | | | | | | | T TTTTTTTTTTT 43 Taxes (real estate, etc.) 44 Interest 45 Depreciation Other expenses 46 (specify) Other expenses 47 (specify) Other expenses 48 (specify) 49 Misc. (unspecified) 50 Total Expenses 52 Net Profit 51 - 01- 01 - | 0 - | 0 - | 0 - | 0 - | 0 - | 0 - | 0 - | 0 - | 0 - | 0 I | 64 1 READY Pnl projection Sheet1 + @ -- + 100% 11:18 PM 1 Type here to search [ e M 8 9 wi x] ) al 4/5/2020

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

Step: 3

blur-text-image

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

Managerial Accounting Manufacturing And Service Applications

Authors: Arnold Schneider, Harold M. Sollenberger

4th Edition

0759350426, 978-0759350427

More Books

Students also viewed these Accounting questions

Question

b. A workshop on stress management sponsored by the company

Answered: 1 week ago