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 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.

This was all the information given. I was not given any numbers. I just need to know how to fill it out with made up numbers. Like an example so I can get an idea of how it is done.

? - X mysweetmind Espitia Bad Neutral Insert Delete Format AutoSum A Fill Sort & Find & Clear Filter - Select Editing Cells J K L M N O P Q R who has then he key Doser Startup expenses (1) - Excel (Product Activation Failed) DRAWING TOOLS FILE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW FORMAT % Cut -8 AA === Arial D LE Wrap Text Normal General Copy - Paste Painter Format Painter B I U. - A E Merge & Center - $ %, too! Conditional Format as Good Formatting Table Clipboard Font Alignment E Number Styles Text Box 7 - x for A G H I Notes on Preparation 1 Startup Expenses Note: 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 2 Enter your company name here DELETE key. Nearly everyone who has ever started a business has underestimated the costs, and then faced the danger of running with inadequate capital reserves. The key to avoiding this pitfall is to adopt a rigorous approach to your 5 Sources of Capital research and planning. Our Startup Expenses worksheet will lead you through the process. Owners' Investment (name and EXPENSES - Begin by estimating expenses. What will it cost you to get your 7 percent ownership) business up and running? The key to accuracy here is attention to detail. For each category of expense, draw up a list of everything you will need to 8 Your name and percent ownership purchase. This will include both tangible assets (for example, equipment, 9 Other investor inventory) and services (for example, remodeling, insurance). Then 10 Other investor determine where you might purchase these goods or services. Research more than one vendor, i.e.: comparison shop. Do not look at price alone; 11 Other investor terms of payment, delivery, reliability, and service are also important. 12 Total Investment CONTINGENCIES - Add a reserve for contingencies. Be sure to explain in your narrative how you decided on the amount you are putting into this 13 reserve 14 Bank Loans WORKING CAPITAL - You cannot open with an empty bank account. You 15 Bank 1 need a cash cushion to meet expenses while the business gets going. Eventually you should do a 12-month cash flow projection. This is where you 16 Bank 2 will work out your estimate of working capital needs. For now, either leave 17 Bank 3 this line blank or put in your best rough quess. After you have done your cash! 18 Bank 4 flow, you can come back and enter the carefully researched figure. SOURCES - Now that you have estimated how much capital will be needed 19 Total Bank Loans to start, you should turn your attention to the top part of this worksheet. Enter the amounts you will put in yourself, how much will be injected by partners or investors, and how much will be supplied by borrowing. 21 Other Loans COLLATERAL - If you will be using this plan to support a bank loan request, 22 Source 1 use the section near the bottom to show what assets are offered as collateral 23 Source 2 to secure the loan, and give your estimate of the value of these items. Be prepared to offer some proof of your estimates of collateral values. 24 Total Other Loans 25 20 26 27 Startup Expenses 28 29 Buildings/Real Estate 30 Purchase 31 Construction 32 Remodeling 22. Oboe > Startup Expenses READY @ -- 100% + 11:53 PM 1 Type here to search [ e M 8 9 wi x] Bb 4/5/2020 ? - X Startup expenses (1) - Excel (Product Activation Failed) PAGE LAYOUT FORMULAS DATA REVIEW DRAWING TOOLS FORMAT VIEW mysweetmind Espitia Doser FILE HOME INSERT % Cut Arial Copy - Paste Format Painter Painter B I D LE Normal General Bad -8 - AA === A E Wrap Text Merge & Center - U. $ %, too! Neutral Insert Delete Format Conditional Format as Good Formatting Table Styles AutoSum A Fill Sort & Find & Clear Filter - Select Editing Clipboard Font Alignment Number Cells Text Box 7 - x .fr F G H I J K L M N O P Q R 29 Buildings/Real Estate 30 Purchase 31 Construction 32 Remodeling 33 Other 34 Total Buildings/Real Estate 35 36 Leasehold Improvements 37 Item 1 38 Item 2 39 Item 3 40 Item 4 41 Total Leasehold Improvements 42 43 Capital Equipment List 44 Furniture 45 Equipment 46 Fixtures 47 Machinery 48 Other 49 Total Capital Equipment 50 51 Location and Admin Expenses 52 Rental 53 Utility deposits 54 Legal and accounting fees 55 Prepaid insurance 56 Pre-opening salaries 57 Other 58 Total Location and Admin Expenses 59 60 Opening Inventory 61 Category 1 62 Category 2 63 Category 3 64 Catogon Startup Expenses READY @ -- 100% + 11:53 PM 1 Type here to search [ e M 8 9 wi x] Bb 4/5/2020 ? - X Startup expenses (1) - Excel (Product Activation Failed) PAGE LAYOUT FORMULAS DATA REVIEW DRAWING TOOLS FORMAT VIEW mysweetmind Espitia Doser FILE HOME INSERT % Cut Arial Copy - Paste Format Painter Painter B I D LE Normal General Bad -8 - AA === A E Wrap Text Merge & Center - U. $ %, too! Neutral Insert Delete Format Conditional Format as Good Formatting Table Styles AutoSum A Fill Sort & Find & Clear Filter - Select Editing Clipboard Font Alignment E Number Cells fr B C D E F G H I J K L M N O P Q R LA Text Box 7 X A 60 Opening Inventory 61 Category 1 62 Category 2 63 Category 3 64 Category 4 65 Category 5 66 Total Inventory 67 $ . 68 Advertising and Promotional Expenses 69 Advertising 70 Signage 71 Printing 72 Travel/entertainment 73 Other/additional categories Total Advertising/Promotional 74 Expenses 75 76 Other Expenses 77 Other expense 1 78 Other expense 2 79 Total Other Expenses 80 81 Reserve for Contingencies 82 83 Working Capital 84 85 Summary Statement 86 87 Sources of Capital 88 Owners' and other investments 89 Bank loans 90 Other loans 91 Total Source of Funds 92 + Startup Expenses READY + @ -- + 100% 11:54 PM 1 Type here to search [ e M 8 9 wi x] Bb G 4/5/2020 ? - X Startup expenses (1) - Excel (Product Activation Failed) PAGE LAYOUT FORMULAS DATA REVIEW DRAWING TOOLS FORMAT VIEW mysweetmind Espitia Doser FILE HOME INSERT % Cut Arial Copy - Paste Format Painter Painter B I D LE Normal General Bad -8 - AA === A E Wrap Text Merge & Center - U. $ %, too! Neutral Insert Delete Format Conditional Format as Good Formatting Table Styles AutoSum A Fill Sort & Find & Clear Filter - Select Editing Clipboard Font Alignment E Number Cells D E F G H I J K L M N O P Q R LA C $_ Text Box 7 X fr A B 90 Other loans 91 Total Source of Funds 92 93 Startup Expenses 94 Buildings/real estate 95 Leasehold improvements 96 Capital equipment 97 Location/administration expenses 98 Opening inventory 99 Advertising/promotional expenses 100 Other expenses 101 Contingency fund 102 Working capital 103 Total Startup Expenses 104 105 106 Security and Collateral for Loan Proposal 107 108 Collateral for Loans 109 Real estate 110 Other collateral 111 Other collateral 112 Other collateral 113 114 115 Owners 116 Your name here 117 Other owner 118 Other owner 119 120 121 Loan Guarantors (other than owners) 122 Loan guarantor 1 123 Loan guarantor 2 124 Loan guarantor 3 125 Startup Expenses READY Value Description @ -- + 100% - 11:54 PM 4 O Type here to search e M @ o wi x] Bb G 4/5/2020 ? - X mysweetmind Espitia Bad Neutral Insert Delete Format AutoSum A Fill Sort & Find & Clear Filter - Select Editing Cells J K L M N O P Q R who has then he key Doser Startup expenses (1) - Excel (Product Activation Failed) DRAWING TOOLS FILE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW FORMAT % Cut -8 AA === Arial D LE Wrap Text Normal General Copy - Paste Painter Format Painter B I U. - A E Merge & Center - $ %, too! Conditional Format as Good Formatting Table Clipboard Font Alignment E Number Styles Text Box 7 - x for A G H I Notes on Preparation 1 Startup Expenses Note: 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 2 Enter your company name here DELETE key. Nearly everyone who has ever started a business has underestimated the costs, and then faced the danger of running with inadequate capital reserves. The key to avoiding this pitfall is to adopt a rigorous approach to your 5 Sources of Capital research and planning. Our Startup Expenses worksheet will lead you through the process. Owners' Investment (name and EXPENSES - Begin by estimating expenses. What will it cost you to get your 7 percent ownership) business up and running? The key to accuracy here is attention to detail. For each category of expense, draw up a list of everything you will need to 8 Your name and percent ownership purchase. This will include both tangible assets (for example, equipment, 9 Other investor inventory) and services (for example, remodeling, insurance). Then 10 Other investor determine where you might purchase these goods or services. Research more than one vendor, i.e.: comparison shop. Do not look at price alone; 11 Other investor terms of payment, delivery, reliability, and service are also important. 12 Total Investment CONTINGENCIES - Add a reserve for contingencies. Be sure to explain in your narrative how you decided on the amount you are putting into this 13 reserve 14 Bank Loans WORKING CAPITAL - You cannot open with an empty bank account. You 15 Bank 1 need a cash cushion to meet expenses while the business gets going. Eventually you should do a 12-month cash flow projection. This is where you 16 Bank 2 will work out your estimate of working capital needs. For now, either leave 17 Bank 3 this line blank or put in your best rough quess. After you have done your cash! 18 Bank 4 flow, you can come back and enter the carefully researched figure. SOURCES - Now that you have estimated how much capital will be needed 19 Total Bank Loans to start, you should turn your attention to the top part of this worksheet. Enter the amounts you will put in yourself, how much will be injected by partners or investors, and how much will be supplied by borrowing. 21 Other Loans COLLATERAL - If you will be using this plan to support a bank loan request, 22 Source 1 use the section near the bottom to show what assets are offered as collateral 23 Source 2 to secure the loan, and give your estimate of the value of these items. Be prepared to offer some proof of your estimates of collateral values. 24 Total Other Loans 25 20 26 27 Startup Expenses 28 29 Buildings/Real Estate 30 Purchase 31 Construction 32 Remodeling 22. Oboe > Startup Expenses READY @ -- 100% + 11:53 PM 1 Type here to search [ e M 8 9 wi x] Bb 4/5/2020 ? - X Startup expenses (1) - Excel (Product Activation Failed) PAGE LAYOUT FORMULAS DATA REVIEW DRAWING TOOLS FORMAT VIEW mysweetmind Espitia Doser FILE HOME INSERT % Cut Arial Copy - Paste Format Painter Painter B I D LE Normal General Bad -8 - AA === A E Wrap Text Merge & Center - U. $ %, too! Neutral Insert Delete Format Conditional Format as Good Formatting Table Styles AutoSum A Fill Sort & Find & Clear Filter - Select Editing Clipboard Font Alignment Number Cells Text Box 7 - x .fr F G H I J K L M N O P Q R 29 Buildings/Real Estate 30 Purchase 31 Construction 32 Remodeling 33 Other 34 Total Buildings/Real Estate 35 36 Leasehold Improvements 37 Item 1 38 Item 2 39 Item 3 40 Item 4 41 Total Leasehold Improvements 42 43 Capital Equipment List 44 Furniture 45 Equipment 46 Fixtures 47 Machinery 48 Other 49 Total Capital Equipment 50 51 Location and Admin Expenses 52 Rental 53 Utility deposits 54 Legal and accounting fees 55 Prepaid insurance 56 Pre-opening salaries 57 Other 58 Total Location and Admin Expenses 59 60 Opening Inventory 61 Category 1 62 Category 2 63 Category 3 64 Catogon Startup Expenses READY @ -- 100% + 11:53 PM 1 Type here to search [ e M 8 9 wi x] Bb 4/5/2020 ? - X Startup expenses (1) - Excel (Product Activation Failed) PAGE LAYOUT FORMULAS DATA REVIEW DRAWING TOOLS FORMAT VIEW mysweetmind Espitia Doser FILE HOME INSERT % Cut Arial Copy - Paste Format Painter Painter B I D LE Normal General Bad -8 - AA === A E Wrap Text Merge & Center - U. $ %, too! Neutral Insert Delete Format Conditional Format as Good Formatting Table Styles AutoSum A Fill Sort & Find & Clear Filter - Select Editing Clipboard Font Alignment E Number Cells fr B C D E F G H I J K L M N O P Q R LA Text Box 7 X A 60 Opening Inventory 61 Category 1 62 Category 2 63 Category 3 64 Category 4 65 Category 5 66 Total Inventory 67 $ . 68 Advertising and Promotional Expenses 69 Advertising 70 Signage 71 Printing 72 Travel/entertainment 73 Other/additional categories Total Advertising/Promotional 74 Expenses 75 76 Other Expenses 77 Other expense 1 78 Other expense 2 79 Total Other Expenses 80 81 Reserve for Contingencies 82 83 Working Capital 84 85 Summary Statement 86 87 Sources of Capital 88 Owners' and other investments 89 Bank loans 90 Other loans 91 Total Source of Funds 92 + Startup Expenses READY + @ -- + 100% 11:54 PM 1 Type here to search [ e M 8 9 wi x] Bb G 4/5/2020 ? - X Startup expenses (1) - Excel (Product Activation Failed) PAGE LAYOUT FORMULAS DATA REVIEW DRAWING TOOLS FORMAT VIEW mysweetmind Espitia Doser FILE HOME INSERT % Cut Arial Copy - Paste Format Painter Painter B I D LE Normal General Bad -8 - AA === A E Wrap Text Merge & Center - U. $ %, too! Neutral Insert Delete Format Conditional Format as Good Formatting Table Styles AutoSum A Fill Sort & Find & Clear Filter - Select Editing Clipboard Font Alignment E Number Cells D E F G H I J K L M N O P Q R LA C $_ Text Box 7 X fr A B 90 Other loans 91 Total Source of Funds 92 93 Startup Expenses 94 Buildings/real estate 95 Leasehold improvements 96 Capital equipment 97 Location/administration expenses 98 Opening inventory 99 Advertising/promotional expenses 100 Other expenses 101 Contingency fund 102 Working capital 103 Total Startup Expenses 104 105 106 Security and Collateral for Loan Proposal 107 108 Collateral for Loans 109 Real estate 110 Other collateral 111 Other collateral 112 Other collateral 113 114 115 Owners 116 Your name here 117 Other owner 118 Other owner 119 120 121 Loan Guarantors (other than owners) 122 Loan guarantor 1 123 Loan guarantor 2 124 Loan guarantor 3 125 Startup Expenses READY Value Description @ -- + 100% - 11:54 PM 4 O Type here to search e M @ o wi x] Bb G 4/5/2020

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered 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

Students also viewed these Accounting questions