Kibata

Sign In

Our Services

Get 15% Discount on your First Order

Order Now
[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

Order Now

Related Questions

Documentation Practice

Create Documentation Practice Daily Grade 8: More Documentation Practice Purpose: The main purpose of this assignment is to continue practicing documentation skills. Directions: Log on to Google Drive using your NSU credentials, and save a copy of this document there, renaming it DG8 JDoe *** (use your first initial and

Real Estate Articles (Week 3)

Participation will consist of locating, submitting and commenting on current articles related to real estate. Links to these articles are to be posted to Article Participation under the Discussion Board. Do not post the article itself, just its link. You are to read these articles and then post your comments/thoughts

Blue 6

SEE ATTACHED Teachers Creating an Equitable Classroom Climate: · Teachers acknowledge their own biases and inequitable actions · Teachers make an effort to learn about their students’ cultural backgrounds. · Teachers examine curriculum and learning materials for bias. · Teachers build caring, cooperative classroom environments. · Teachers build relationships with

P&L statement completed

I need the following P&L statement completed please see attached items. Need it completed by tonight 9/19 11 pm (CST)  this is for a business or no later than 5 am CST 9/20

Business Finance – Management Financial management assignment

I need to answer the attached file with professional teacher. FINANCIAL MANAGMENT SBS – MBA Assignment STUDENT ID UNIT TITLE: NAME (in Full): GENERAL INSTRUCTIONS • All assignments are to be submitted on 17th October 2024 on • Any Assignment submission extension request must come to Azra Fatima (Assistant Vice

Waiting in Line

   Describe a waiting line situation that you regularly face in your daily life. Explain how you would improve the structure of that system by applying waiting line analysis.

Solving Problems

   Describe a current problem facing your department (Training Department at Diesel Engine School), that would indicate the need for a simulation model. How best could this problem be solved by simulation versus the other modeling techniques covered in the course? 

Economic cost/Waiting line

   What are the economic costs of waiting in lines? How might these costs be measured? What decision criteria can be used to justify expanding services to reduce waiting times?

Optimal solution

    Create a simple 0, 1 integer model for a situation or problem you face in your life. Is there an optimal solution for your problem? What type of model would you use to create an optimal solution? Explain.

brenda

  Discussion #5 – Brenda Berkman – First Female Firefighter Brenda Berkman was the first female firefighter for the New York City Fire Department and to achieve that she single-handedly sued the City of New York for unfair labor practices and discrimination in not allowing women to become a  firefighter.

Moonstay Corporation

Please, answer questions #1 and #2 only. I attached the whole assignment but only need answer for question #1 and #2. I also attached the book so you can use it as reference (The Scheutze speech is at p. 226 of the text).

mgt2

Select one (only one) from the four categories of identity below and write a short essay (300 to 500 words) offering reasons and evidence for your choice. Start by asking yourself “Who am I?” 1. I am a person defined mostly by race, ethnic group, or country of origin. I

w3

i need some help! Business-process outsourcing (BPO) is a type of outsourcing that consists of contracting operations and responsibilities of a specific business process (e.g., human resources) to a third-party service provider. Such outsourcing generally began with manufacturing firms outsourcing their supply chain but has grown into a much wider

Blue 4

See attached Over the course of many years observing teachers in their classrooms, these experts report that teachers who use culturally responsive teaching practices, regardless of the content they are teaching, consistently demonstrate that they: • value students’ cultural and linguistic resources and view this knowledge as capital to build

Affordable Expertise for All Your Accounting Needs

MMBA Chartered Accountants & Registered Auditors established in 2009, is your trusted source for expert financial advice across the UK, with offices in Preston, Luton, Cambridge, and London.    Visit-> https://www.mmba.co.uk/  Call->  01772378020