Answered step by step
Verified Expert Solution
Question
1 Approved Answer
please help with numbers 3-7 Assume that you are starting a new small business. Select a business where you either provide a service or manufacture
please help with numbers 3-7
Assume that you are starting a new small business. Select a business where you either provide a service or manufacture a product (a service business would be much easier). Give the business a name. (4 points) 2. Prepare a detailed explanation of your business. (10 points) 3. Revenue section - all possible sources of revenue are inserted for all 12 months of the year (12 points) 4. Necessary Expenses section - all necessary expenses are inserted for 12 months of the year (12 points) 5. Discretionary Expenses section - all discretionary expenses are inserted for 12 months of the year (12 points) 6. Excel software - all rows and columns are totaled using the Excel software; no manual calculations are entered into the cells. Formulas are built where applicable and/or the auto sum feature is used. (12 points) 7. Cash Flow Budget - (14 points) Prepare a budget for one quarter showing when cash will be received. Assume that you will extend credit to some customers and that some customers will pay cash when services are rendered. Research what percentage of Accounts Receivable for your type of business will not be collected and factor this in to the cash budget 8. Analysis - a one-page summary is prepared that will address the following questions: What categories were the most challenging to budget for and why were these categories difficult? (12 points) . Based on the results of your cash flow budget, do you need to tighten or loosen your credit policy and how will you go about doing this? (12 points) Business Budget Name of Business: Jan Feb Mar Apr May Jun Total Jul Aug Sept Oct Nov Dec Annual Revenue: Source #1 Source #2 Source #3 Source #4 Source 85 Total revenue Expenses Necessary Expenses Insert all expenses Total Nec. Expenses Discretionary Expenses insert al expenses Total Disc. Expenses Expected Profit Assume that you are starting a new small business. Select a business where you either provide a service or manufacture a product (a service business would be much easier). Give the business a name. (4 points) 2. Prepare a detailed explanation of your business. (10 points) 3. Revenue section - all possible sources of revenue are inserted for all 12 months of the year (12 points) 4. Necessary Expenses section - all necessary expenses are inserted for 12 months of the year (12 points) 5. Discretionary Expenses section - all discretionary expenses are inserted for 12 months of the year (12 points) 6. Excel software - all rows and columns are totaled using the Excel software; no manual calculations are entered into the cells. Formulas are built where applicable and/or the auto sum feature is used. (12 points) 7. Cash Flow Budget - (14 points) Prepare a budget for one quarter showing when cash will be received. Assume that you will extend credit to some customers and that some customers will pay cash when services are rendered. Research what percentage of Accounts Receivable for your type of business will not be collected and factor this in to the cash budget 8. Analysis - a one-page summary is prepared that will address the following questions: What categories were the most challenging to budget for and why were these categories difficult? (12 points) . Based on the results of your cash flow budget, do you need to tighten or loosen your credit policy and how will you go about doing this? (12 points) Business Budget Name of Business: Jan Feb Mar Apr May Jun Total Jul Aug Sept Oct Nov Dec Annual Revenue: Source #1 Source #2 Source #3 Source #4 Source 85 Total revenue Expenses Necessary Expenses Insert all expenses Total Nec. Expenses Discretionary Expenses insert al expenses Total Disc. Expenses Expected Profit Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started