Our Services

Get 15% Discount on your First Order

[rank_math_breadcrumb]

Feasibility Study

Competencies
  • Interpret how the components of a balance sheet and income statement communicate the financial position of an organization.
  • Interpret the components of a cash-flow statement to describe the liquidity of an organization.
  • Evaluate financial ratios to differentiate profitability and liquidity across organizations.
  • Analyze leverage and activity ratios to review operating performance across organizations.
  • Determine current values of cash streams utilizing discounted cash flow techniques.
  • Critique organizational investments using forecasting scenarios.
Student Success Criteria

View the grading rubric for this deliverable by selecting the “This item is graded with a rubric” link, which is located in the Details & Information pane

.

Scenario

You recently went to a dealership for an oil change on your vehicle, as no independent oil change companies or auto repair shops are within 50 miles of your home. You paid $250 for this oil change on your Chevy Camaro.

Given your entrepreneurial spirit and frustration with the cost of the oil change, you have an idea for a mobile oil change company. You have completed a marketing survey to determine potential interest in such a company. The marketing survey results suggested that 50% of vehicle owners would entertain using a mobile oil change company for oil changes if such a company existed.

You live in a town with 30,000 registered vehicles, of which their owners take 15,000 to the dealerships for oil changes. Most owners take their vehicles to the dealership three times a year.

You will need the following to start this business and to gain funding from investors.:

  • 3 Mobile Oil Change Trucks (General Modifiable Flatbed Commercial Trucks)
  • Oil Changing Supplies (i.e., motor oil, clean cloths, drip pans, and oil filters)
  • Oil Changing Tools (i.e., Motor Oil Tank, Motor oil extractor, and a Fluid Flush Machine Mobile Oil Dispensing Kit)
  • Insurance (i.e., Auto for all three trucks and General Liability Insurance for the Business)
  • Budget for 3 Employees (Hourly Pay)

Pro forma financial statements, a financial plan, and a business plan are required for all potential investors and creditors. Prepare a 10-15 slide PowerPoint presentation and include financial proforma statements with the above information to present to potential investors and creditors.

Instructions

Using PowerPoint (or similar) and this Module 7 Feasibility Calculations Template – 2023, you have been asked to develop a feasibility study presentation to determine the feasibility of this idea for a new company.

Module 7 Feasibility Calculations Template  – 2023.xlsx

 Your feasibility study presentation should include the following:

  • Develop a conservative forecasted sales budget based on the survey results using the Excel template. Make sure your price is less than what the dealership charges.
  • Within the Excel spreadsheet, Identify fixed and variable costs for each oil change. Using these values, develop an operating budget to determine the contribution margin for an individual oil change and the total amount for the forecasted sales budget.
  • Develop a proforma income statement, balance sheet, and statement of cash flows for the first year of business. The business Tax Rate is 20%.
  • Based on these proforma financial statements, calculate one financial ratio in each category of profitability, liquidity, and solvency ratios.
  • Based on a 40-hour work week, estimate how many oil changes one person can realistically perform. Given the projected sales forecast, develop a capital investment proposition for additional trucks with anticipated useful lives of 5 years. Use the discounted cash flow method at an interest rate of 6%. Develop a 10-15 slide PowerPoint presentation summarizing these figures above and provide a recommendation to invest in this mobile oil-changing business based on the feasibility report provided.

NOTE – Be sure the documents display proper grammar, spelling, punctuation, and sentence structure.

Assessment Requirements/Submission Requirement:
  • Submit a 10-15 slide PowerPoint presentation, including attribution for outside sources.
  • Submit the Excel Feasibility Spreadsheet to show all calculations used for the scenario.

A – 4 – Mastery

Accurate and appropriately conservative forecasted sales budget based on the survey results.

A – 4 – Mastery

Correctly identifies fixed and variable costs for each oil change and develops a realistic operating budget.

A – 4 – Mastery

Accurate and complete proforma income statement, balance sheet, and statement of cash flows for the first year of business.

A – 4 – Mastery

Accurately calculates all profitability, liquidity, and solvency ratios.

A – 4 – Mastery

Accurately develops a capital investment proposition and PowerPoint presentation for potential investors.

Share This Post

Email
WhatsApp
Facebook
Twitter
LinkedIn
Pinterest
Reddit

Order a Similar Paper and get 15% Discount on your First Order

Related Questions

New Question Operations Management

Please see attached On February 1, 2011, Enzo Natale, head of Finance and Operations at Altimus Brands in London (UK), received the latest monthly report and, as he feared, costs of purchases had increased again. He knew that by the end of the month he would have to present recommendations

Week 7 Discussion Response- Improving Business Performance

   Improving Business Performance Week 7 Learning Resources Landel, R. D. & Timoshin, D. (2001, March 8).  Rise and demise of the innovative entrant . Darden Business Publishing. Note: This resource will be used for this week’s Discussion.

Selection of Company and Problem

Criteria Choose a company from the Fortune 500 list. Your choice must be below the top 100 (101-500) in the ranking at https://www.zyxware.com/articles/4344/list-of-fortune-500-companies-and-their-websites#rank-101-400 or you can utilize Google to find a list of Fortune 500 companies. Determine a business challenge this company faces that could be addressed through business analysis techniques,

DB II

See attached Management Applications of Accounting DB II •   Your initial post should be at least 300 words in length. •   Your initial post should include at least one APA-formatted scholarly, professional, or textbook reference with accompanying in-text citation to support any paraphrased, summarized, or quoted material. Post 2: Response post to

Unit VII Ess

se attached Unit VII Essay Choose a well-known global organization (e.g., Amazon, McDonald’s, Zara, Unilever) that operates in multiple international markets. Research how the chosen organization distributes its products across different markets. Consider both physical (retail, wholesale) and digital (e-commerce, direct-to-consumer) channels. Describe the marketing distribution channels and explain whether

WK2MBA599

SEE ATTACHED Please cite 2 outside scholarly authors. TEXTBOOK: Required Textbook: David, F. R., David, F. R. & David, M.E. (2023). Strategic management: a competitive advantage approach, concepts and cases (18th ed.). Upper Saddle River: Pearson. ISBN: 9780137897667 Develop a Competitive Matrix for McDonald’s Textbook Learning Exercise 3B Steps 1-3

Business & Finance homework

HSE470 Legal Issues of Security 1 of 2 1/3/2021, 12:51 PM HSE470 Legal Issues of Security 2 of 2 1/3/2021, 12:51 PM

Business Finance – Management homework

see attached HOMEWORK 1: 5 pages with 2 references Instructions: This homework assignment is meant to ensure understanding of the material contained within the module and reading assignments. Utilizing information contained within the module, text, and additional research, answer the following questions. 1. Describe each part of the DMAIC model.

share your definition of critical thinking

share your definition of critical thinking. Give an example of how you have utilized critical thinking in the workplace. In addition, search the open job listings on the web. Identify and post one new open position that requires business analysis skills. Cite the source about the job opening. Describe and

BUSINESS( NO PLAGARISM A+ WORK, ON TIME)

3 business economics questions 1. ASSIGNMENT ( NO MORE THAN 300 WORDS) Why study managerial economics? The most important task of a business manager is to make decisions. Decisions are the means by which organizations turn ideas into action and can have a positive or a negative impact. However, decision

Journal Article 1

See attachments  BUSI 613 Journal Article Review Assignment Instructions Overview MBA programs around the country are starting to require their students to become more effective writers. This is in response to industry’s urging for grad schools to improve the writing skills of graduate students. Writing at the MBA level should

Prof Double R

 Electronic Health Record  Answer the following questions: What is an EHR? What types of information are found in an EHR? Who manages an EHR? How is it used? Does an EHR follow the patient to other health facilities? Explain.

Microeconomics 6

Assignment in attachment  1. The following graph shows a firm operating in a monopolistically competitive market. How many haircuts will the firm perform in the short term, and at what price? At this point, what will its total revenue, total cost, and total profit be? Given your answers, what would

Microeconomics 7

Assignment in attachment  1. What are the four most important ways a firm becomes a monopoly? Will a monopoly that maximizes profit also be maximizing revenue? Will it be maximizing output? Explain. 2. Assume the graph below represents the market for a monopolist. What quantity will the monopolist produce, and

Microeconomics 2

Assignment in attachment  1. The graph below represents the market for flank steak in a specific town. Calculate the value of consumer surplus: A. When the market price is allowed to prevail, and B. When the town passes a law setting a price ceiling for flank steak of $13 per

MBA 699 4-2 Milestone 2

   1. Current employee demographics: Summarize the current employee demographics for the organization from the course scenario. a. Use Tableau to visualize the demographic data such as age, sex, marital status, education, and experience, and include the corresponding screenshots in your summary. Choose the graphs or charts that are best