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

Assessing Organizational Viability

  Scenario You are the CFO of a rural hospital. During a recent review of the organization’s financial status, the hospital was deemed “at risk” for closure. Several factors contribute to the at-risk designation, including the state’s decision to opt-out of the Medicaid expansion program, the aging population which requires

Deliverable 1 – Community Needs Assessment

  Scenario Your local health system is planning to launch its new population health management (PHM) program for the community and population it serves. You are the Chief Population Officer for this system, and you were tasked by your system CEO to develop key performance indicators for this program. One of the

Case Scenario

The company you work for has spent years developing a new, innovative product. The company has spent large sums on a product which management believes will be cutting edge. Forecasts look promising and indicate the device will be highly profitable. It goes without saying the company will gain a dominant position

HRM 6304 Unit I DBR

2 Labor Relations and Collective Bargaining HRM 6304 Unit I Discussion Board Reply Posts to others should be a minimum of 250 words. You should also include at least two references. Reply to the below Top of Form The structural landscape of the American labor movement changed significantly in 2005

Business Finance – Management Week 9 Assignment- Managerial Finance

Module 3 Assignment: Capital Budget Decision Making for an Organization Report prepared by: Replace this text with your name. Date: Replace this text with the submission date. Walden University MBAX 6070: Managerial Finance 1 Executive Summary Replace this text with your executive summary. Part 1: Short-Term Working Capital Considerations Replace

Logistics

see attached  BUSI 615 Integrated Learning Project Assignment Instructions Overview The integrated learning assignment is a series of 6 assignments and a final course consolidated submission. All assignments and the compilation of the final consolidated submission is managed as an individual assignment. Purpose The purpose of the ILP is for

HRM 6304 Unit I DB

2 Labor Relations and Collective Bargaining HRM 6304 Unit I Discussion Board In your opinion, does having two different existing labor federations (i.e., American Federation of Labor and Congress of Industrial Organizations [AFL-CIO] and Change to Win) strengthen or weaken the ability of organized labor to represent the interests of

Which of the following is a topic of macroeconomics?

 Which of the following is a topic of macroeconomics? A) why nations have different rates of growth B) what causes inflation and what can be done about it C) why unemployment periodically reaches very high levels D) all of the above

Business Finance – Management Week 9 Assignment- Delivery of Healthcare

Delivery of Healthcare Week 9 Assignment Improvement Plan- Part 2 This week, you should continue your Improvement Plan: Part 2. As you work on your Improvement Plan, be sure to incorporate peer-review feedback (as appropriate). This week, focus on the areas of: · Information technology (value-based care model) · Be

Business Finance – Accounting Assignment Week 2

 Tax Research using Code and Administrative Sources. Facts: You are a slightly over-confident  CPA who advises Changling Industries, LLC, a Florida Manager Managed  LLC a small start up limited liability that has garnered the attention  of several Angel Financing organizations. The founder, Nodan Idiote, of  middle-eastern origin and three of

Ecosystems

   Do you think the introduction of non-native species to an ecosystem always pose a threat to that ecosystem? 

Innovative and Strategic Thinking

Market entry, discussing details.  Market Entry The Impact of Innovation The graduate identifies the impact of innovation in personal and professional settings. Techniques of Strategic Management The graduate utilizes evidence-based techniques to make strategic decisions. Business Strategy and Analysis The graduate applies appropriate business practices to formulate recommendations that impact

Week 3 pj

 wood-based shipping container and a plastic-based shipping  Instructions:  You are going to compare and contrast the advantages and disadvantages of a paper- based shipping container, a wood-based shipping container and a plastic-based shipping container for use as a distribution package (a non-retail shipping package). You must consider the entire supply chain in

Week 3 MGMT618

 Workplace scenario involving an observed unethical  Assignment Directions This assignment assesses  CO-3 [content page].  Students will provide a workplace scenario involving an observed unethical practice. Submission Instructions: Write a 5–7 page report analyzing the situation, evaluating potential responses, and recommending the most ethically sound course of action. Requirements: Use at least

A22- Discussion

 Additionally, you will explore the concept of Relationship Marketing and, in particular, you will focus on Differentiating Customers by Their Needs. Please answer these questions and use scholarly support for your answers: 

Week 8

 building blocks from the business model canvas where modification  Assignment Directions: Goal: Conduct/construct an experiential evaluation/assessment of your organization’s business model (or one with which you are closely familiar) using the business model canvas and related text. Introduction: Managers who want to improve the effectiveness of their business model and

SEMCO Case study 1.0

Please see rubric, instruction and questions for the assignment that needs to be address attached. BMAL 710 Disorganization at Semco Case Study Assignment Instructions Overview Please read the Integrative Case 1.0 in Daft text and respond to all four questions at the end of the case study. Instructions Please make