Attachment # 00003530 - 2300023.docx
2300023.docx (23.12 KB)
Raw Preview of Attachment:
(refer to the detailed question and attachment below)
Your Company NameBudget ProposalFor[Enter Years Here]BUSN-278[Term]Professor[name]DeVry UniversityTable of Contents SectionTitleSubsectionTitlePage Number1.0Executive summary2.0Sales Forecast2.1Sales Forecast2.2Methods and Assumptions3.0Capital Expenditure Budget4.0Investment Analysis4.1Cash flows4.2NPV Analysis4.3Rate of Return Calculations4.4Payback Period Calculations5.0Pro Forma Financial Statements5.1Pro Forma Income Statement5.2Pro-Forma Cash flow Statement5.3Pro-Forma Balance Sheets6.0Works Cited7.0Appendices7.1Appendix 1: [description]7.2Appendix 2:[description] etc[Please put page numbers in the last column of the table of contents above, as they apply to your finished assignment. Do this after your project is complete. Also, remove this text and all text that is in italics in this template when finished your project.][Also, please submit your Excel Spreadsheet which shows your supporting calculations]1.0 Executive SummaryThe first paragraph of this executive summary should give a brief description of the business to which this budget applies. Very briefly describe the products and services of this company, the geographical or demographics of the customers it serves, and why people purchase the main product of this business. Much or all of this will be found in the Business Profile provided to you. Please use your own words, and please do not simply copy and paste the explanation in the course materials. Make assumptions if necessary.Also, provide a second paragraph which describes how the budget supports the company’s strategy.Finally, provide a third paragraph where you summarize the key points from your budget, including the planning horizon, the amount of up-front investment, the NPV, Payback and IRR of the project, as well as key figures from your income statement, cash flow statement, and balance sheet. Remember, this is not a thesis or introduction of what you will talk about – it contains the major, specific content of each section. The second and third paragraph should be written after you have completed all other sections of this template.As you complete sections of this template, please remove all italicized text in all sections of this template and replace it with your own or you will lose points!2.0 Sales ForecastBriefly introduce the sales forecast section.2.1 Sales ForecastHere you should include a simple table showing the years and the total sales for each year, along with a brief explanation of why sales are expected to rise, fall, change, or stay the same in certain years. Provide a brief explanation of the sales forecast, indicating why you expect sales to rise or fall during the planning horizon. Your explanation should be consistent with the trends and changes in sales found in your table:Year 1Year 2Year 3Year 4Year 5Sales2.2 Methods and AssumptionsHere you should describe how you arrived at your sales forecast in section 2.1. You should also provide any detailed calculations that led you to the sales forecast values. You should also summarize any research or figures that led you to make this sales forecast.3.0 Capital Expenditure BudgetHere you should provide a screenshot of your capital expenditure budget, also listing the sources of data and assumptions that led to each line item in table format. Briefly describe the total investment and, if necessary, why major items are necessary to achieve the company’s strategy.4.0 Investment AnalysisBriefly describe the NVP, IRR, accounting rate of return, and payback period for this analysis. Indicate the discount rate you used, and how you arrived at it.4.1 CashflowsProvide an excel spreadsheet screenshot that shows how you arrive at the net cash flows for each period in your planning horizon and describe its highlights.4.2 NPV AnalysisProvide a screen shot of your Excel NPV Analysis here, and describe its highlights.4.3 Rate of ReturnProvide a screen shot of your IRR and Accounting Rate of Return calculations here, and explain the highlights.4.4 Payback PeriodProvide a screen shot of your Excel calculation of the payback period for this venture.5.0 Pro-Forma Financial StatementsBriefly introduce this section here.5.1 Pro-Forma Income StatementDescribe key figures and assumptions from the income statement, such as important profit or sales figures and their causes. Also, provide a screen shot of your pro-forma income statement.5.2 Pro-Forma Cash Flow StatementProvide a screen shot of the cash flow statement and describe the impact of the budget on cash balances.5.3 Pro-Forma Balance SheetsProvide a screen shot of your balance sheets, and describe key figures they contain.6.0 Works CitedList any sources you cited in the body of your report. 7.0 AppendicesNOTE: Start this section at the top of a new page.This section of the budget proposal is where you’ll attach all of the supporting materials that you’ve referenced in the preparation of your plan, and that is too detailed or extensive to be included in the body of the report. Use this page to separate the appendices from the text in the body of your report. Make certain that you update the table of contents to include the title of each exhibit in the appendix and its page number.7.1 Appendix 1: [put a description here]7.2 Appendix 1: [put a description here]7.3 Appendix 1: [put a description here]

Business related assignment

Question # 00058025 Posted By: solutionshere Updated on: 03/29/2015 08:52 AM Due on: 03/29/2015
Subject General Questions Topic General General Questions Tutorials:
Question
Dot Image

BUSN278 Course Project.

Project Overview:

This is an individual project where you will be acting as a consultant to an entrepreneur who wants to start a new business. As the consultant, you’ll create a 5 year budget that supports the entrepreneur’s vision and strategy, as well as the needs for equipment, labor, and other startup costs.

You can choose from one of three types of new business startups -- a landscaping company, a restaurant, or an electronics store that sells portable computing devices. Each business has its own Business Profile detailed in the sections below. The purpose of the Business Profile is to guide you in understanding the scope of the business, the entrepreneur’s startup costs, and financial assumptions.

The project requires you to create a written budget proposal, a supporting Excel Workbook showing your calculations, and a PowerPoint presentation summarizing the key elements of the budget proposal, which you assume will be presented to a management team.

This is an individual project. Each week you will complete a section of the project in draft form. In Week 7, you will submit the final version of the project’s Budget Proposal, Budget Workbook, and Budget Presentation in PowerPoint.

Deliverables Schedule / Points

Week

Deliverable

Points

1

Section 1.0 Executive Summary (Draft)

10

2

Section 2.0 Sales Forecast (Draft)

10

3

Section 3.0 Capital Expenditure Budget (Draft)

10

4

Section 4.0 Investment Analysis (Draft)

10

5

Section 5.1 Pro Forma Income Statement (Draft)

10

6

Section 5.2 Pro Forma Cash Flow Statements (Draft)

10

7

Final Budget Proposal

90

7

Final Presentation w/ PowerPoint

30

Total project points

180


Business Profile:Papa Geo’s– Restaurant

Vision

The vision of the entrepreneur is to create a single-location, sit-down Italian restaurant called Papa Geo’s. The goal is to generate an income of $40,000 per year, starting sometime in the second year of operation, as wells as profit that is at least 2% of sales.

Strategy

a) Market Focus/Analysis

The restaurant targets middle to lower-middle class families with children, as well as adults and seniors, located in Orlando, Florida. The area within 15 minutes of the store has 10,000 families, mostly from lower to middle class neighborhoods. Average family size is 4 people per household. There is no direct competition; however, there are fast food restaurants like McDonald’s, Taco Bell and Wendy’s in the geographical target market. The lower to middle class population is growing at about 6% per year over the next five years in this area.

b) Product

The product is Italian food served buffet style, in an all-you-can-eat format, with a salad bar, pizza, several different types of pasta with three or four types of sauces, soup, desserts, and a self-serve soda bar. The restaurant is also to have a 500 square foot gaming area which has game machines that children would be interested in using.

c) Basis of Competition

Customers come to this restaurant because of the good Italian food at a low price – you can get a meal for $7, including drinks. Customers also eat at Papa Geo’s due to the cleanliness of the facility, the speed of getting their seat and food, and the vending machines which keep the children busy while adults enjoy their meal.

Startup Requirements*

Given Costs

· The cost of registering a limited liability company in Florida – filing fees listed at the bottom of the application for located at:http://form.sunbiz.org/pdf/cr2e047.pdf

· Renovation of the facility expected to cost $15,000

· Business insurance, estimated at $1,000 per year

· Health and other benefits are 20% of the salaries of the manager and assistant manager

Costs you should estimate through research, experience or other methods

  • Soda fountain bar
  • 2 pizza ovens
  • Salad and pizza/dessert bar
  • Approximately 100 square foot commercial refrigerator
  • 2 cash registers
  • 6 video game vending machines
  • Management office with desk and lower-priced laptop computer
  • Staff lunchroom equipment such as microwave, sink, cupboards and refrigerator
  • 20 four-seater tables with chairs
  • Busing cart for transporting dirty dishes from the dining area to the dishwashing area
  • 140 sets of dishes, including cutlery and drinking cups
  • Commercial dishwasher
  • Miscellaneous cooking and food handling equipment like trays, lifters, spoons, pots etcetera
  • The cost of an average of 7 employees on the payroll.
  • All operating costs, such as advertising, rent for a 3,500 square foot facility with male and female washrooms (already installed), utilities, maintenance, and annual depreciation

*If you have questions about startup requirements, or think other startup costs necessary for the business are missing, then make an assumption and state it in the relevant section of the report.

Given Financial Assumptions*

  • The owner will be granted a loan for the initial startup, repayable over 10 years at current interest rates for small business loans.
  • The owner will use personal funds to operate the business until it generates enough cash flow to fund itself.
  • Essentially, all sales are made by credit card. All credit card sales are paid to the restaurant daily by the credit card company.
  • 2.5% of sales is paid to the credit card company in fees.
  • Food suppliers give 30 days of trade credit.
  • Inventories are expected to be approximately 10% of the following month’s sales.
  • The average meal costs $4.00 in materials and labor.
  • The average family spends $4.00 on vending machine tokens.
  • Equipment is depreciated on a straight-line basis over 5 years.
  • Managers have health benefits, other workers do not. The company will operate from 10:00 am to 9:00 pm, 7 days a week.
  • The entrepreneur will manage the store and draw a salary.
  • Every shift has one person on the cash register, one keeping the food bars stocked with food, two cooking the food, one on busing and table cleaning, a manager, and assistant manager.

*If you believe any other assumptions are necessary, please state them in your budget proposal.


Business Profile: The Cutting Edge– Landscaping

Vision

The vision of the entrepreneur is to create a 5-team landscaping business that caters to upscale neighborhoods in Miami, Florida. The company is to be called “The Cutting Edge”. The goal of the entrepreneur is to generate income of at least $42,000 per year as his personal salary, as well as profits of 4% after tax sometime no later than the second year of operation. The entrepreneur intends to buy a route of 100 homes from a lawn service company whose owner is retiring.

Strategy

a) Market Focus/Analysis

The landscaping business targets upscale neighborhoods with home associations which demand lawns to be manicured and well-cared for. Customers tend to be upper middle, to upper-class individuals with household income levels of $110,000 or more. The geographic focus is Miami and its surrounding area. The area is expected to show slow economic growth of about 1% per year over the next five years.

b) Product

The product is lawn maintenance and landscaping services as well as minor irrigation equipment repair. The primary source of income is expected to be in the form of lawn-cutting, debris-blowing, and edge trimming services. However, the company will also do reseeding, landscaping and foliage/tree planting, tree trimming, and light irrigation system repair when necessary to keep their customer’s lawns watered and healthy.

c) Basis of Competition

Customers hire the Cutting Edge due to its reliability in showing up when they are supposed to, quality lawn service, as well as their ability to keep lawn sprinkler systems in good repair, sparing the homeowner of the inconvenience of calling a sprinkler repair for minor repairs such as broken or clogged sprinkler heads, or other minor sprinkler system repairs.

Startup Requirements*

Given Costs

· The cost of registering a limited liability company in Florida – filing fees listed at the bottom of the application for located at:http://form.sunbiz.org/pdf/cr2e047.pdf

· Business insurance, estimated at $1,000 per year

· No health benefits except for the owner of the business

· Workman’s compensation fees

· The cost of the initial route of 100 homes, at a cost of $120,000

Costs you should estimate through research, experience or other methods

  • Team equipment for lawn cutting, which includes equipment for a two-person team:
    • A pickup truck
    • A trailer
    • A large riding lawnmower
    • A smaller riding lawnmower
    • A push lawnmower
    • Two gas-powered lawn trimmers
    • Two gas-powered lawn edgers
    • Safety equipment for eye and ear protection
    • Tools for minor equipment repair on the job
    • A drink cooler
    • 2 gas powered blowers
    • 2 tree/hedge trimmers
    • 2 long ladders
    • Buck saws for cutting branches
  • The cost of 10 workers, two per team
  • All operating costs such as advertising, phone, a small 400 square foot office complete with utilities, internet, laptop computer, accounting software like QuickBooks, office supplies, and annual depreciation on equipment.

*If you have questions about startup requirements, or think other startup costs necessary for the business are missing, then make an assumption and state it in the relevant section of the report. This list is not necessarily complete.

Given Financial Assumptions*

  • The owner will be granted a loan for the initial startup, repayable over 10 years at current interest rates for small business loans.
  • The owner will use personal funds to operate the business until it generates enough cash flow to fund itself.
  • Essentially, 60% sales are made by credit card and 40% are made by check. All credit card sales are a paid to the company daily by the credit card company.
  • 2.5% of credit card sales is paid to the credit card company in fees.
  • The average lawn service costs $150 per month. Irrigation repairs are minimal at an average of $50 per customer per year, landscaping and other services are about $200 per customer per year.
  • Equipment is depreciated on a straight-line basis over 5 years.
  • The owner has health benefits, other workers do not.
  • Each lawn takes about 1.5 hours to cut and manicure, as well as any other repairs or extra services like tree or shrub trimming.

· The entrepreneur will manage the company and draw a salary, but will not service lawns or perform other services.

*If you believe any other assumptions are necessary, please state them in your budget proposal.


Dot Image
Tutorials for this Question
  1. Tutorial # 00053907 Posted By: solutionshere Posted on: 03/29/2015 08:53 AM
    Puchased By: 3
    Tutorial Preview
    different risks pertaining to a particular decision particularly in respect ...
    Attachments
    6970011.xlsx (29.76 KB)
    6970012.docx (53.86 KB)
Whatsapp Lisa