Qwikshare is a new not-for-profit organization

Assignment Help Financial Management
Reference no: EM13846780

QwikShare

QwikShare is a new not-for-profit organization that will rent low-emissions automobiles at QwikStops in suburban areas in order to provide an environmentally friendly transportation option to its customers. The organization plans to rent automobiles by the day only, and it will operate 7 days a week, 365 days per year.

On the first day of FY 2016, QwikShare will take out a pre-approved loan of $240,000. The loan will have an annual interest rate of 4%, with annual principal repayments of $30,000 per year to begin in FY 2017. Principal repayments and interest payments will be due the last day of each fiscal year. The organization will immediately use the loan to purchase its first fleet of 15 automobiles. Each automobile will be purchased for $16,000, will have a useful life of 7 years, and can be sold for $2,000 at the end of its useful life.

QwikShare will have full-time staffs that include a Chief Executive Office, a Chief Financial Officer, an Operations Manager, two customer service agents, and two automotive technicians. Full-time staff salaries will total $550,000 in FY 2016, and health benefits will equate to 30% of full-time staff salaries. The organization will also employ 10 part-time staff members who will earn an average of $12.50 per hour in wages and will work an average of 20 hours per week. QwikShare will lease its office and QwikStop spaces for $9,000 per month, it will use $1,000 per month in water and electrical utilities, and it will use $2,500 in supplies per month. In addition, the organization will incur $800 per month per automobile in maintenance and insurance expenses. QwikShare will also cover the cost of fuel at a discounted rate; the organization anticipates that it will cost $30 per car per day that a car is rented. All expenses will be paid as resources are consumed, except supplies, for which the organization will pay with a two-month lag.

In the first month of FY 2016, QwikShare expects supporters will pledge a total of $1,000,000 in donations to help support its first year of operations. QwikShare will charge $65 per day for an automobile rental, and rental fees are collected via pre-stored credit cards the moment customers enter the vehicles they have reserved. In addition, the organization will be supported by a new federal grant that will pay QwikShare $0.50 for every pound of carbon dioxide (CO2) emissions its rentals prevent during FY 2016. QwikShare estimates that each of its low-emissions automobiles will prevent 50 pounds of CO2 emissions per day they are in use during FY 2016. Revenues from the federal grant will be received with a one-month lag.

Using break-even analysis, calculate the minimum number of automobiles QwikShare must rent per day in FY 2016 in order to break even. (Hint: Since the problem is asking for the break-even volume of rentals “per day,” you should make certain all of your values for each variable are expressed accordingly.)

Note: There is no template for this assignment. To receive full credit for this problem, you must use Excel (not Word), use break-even analysis (not an operating budget), and carefully show each step of your calculation in solving this problem.

b. Using target profit analysis, calculate the minimum number of automobiles QwikShare must rent per day in FY 2016 in order to earn an annual profit of $109,500.

c. Prepare an annual operating budget for FY 2016, assuming the organization will rent 10 cars per day, on average, in FY 2016.

d. Prepare a quarterly cash budget for FY 2016 (showing each of the four quarters and the annual total), assuming the organization will rent 10 cars per day, on average, in FY 2016. Since this is a new organization, the beginning cash balance should be $0.

Do the reading assignment for the next class (Chapter 4 p. 136-end and Chapter 8 up to p. 283) and then answer the following reading comprehension question: Suppose that it is now the end of FY 2016 and QwikShare’s fuel expenses turned out to be significantly higher than expected. Briefly describe the three potential reasons why this unfavorable cost variance might have occurred. You may enter your answers in an Excel spreadsheet or in a Word document.

Reference no: EM13846780

Questions Cloud

Discuss the rule in sharp v. dawes and the exceptions thereo : Discuss the rule in sharp v. Dawes and the exceptions thereof
Explain how investigator prepares a criminal case for trial : 1) Explain how an investigator prepares a criminal case for trial. 2) Explain the proper courtroom demeanor needed for an investigator and how his/her demeanor, looks, and body language can affect a trial. 3) Find an article from the Web in which an ..
What is the present value of that annuity if discount rate : An investment will provide you with $100 at the end of each year for the next 10 years. What is the present value of that annuity if the discount rate is 8% annually? What is the present value of the above if the payments are received at the beginnin..
State a clear and concise legal issue statement : State a clear and concise legal issue statement, which describes the primary legal issue you've been asked to research. Your legal issue statement ought to be in the form of a question that can be answered yes or not.
Qwikshare is a new not-for-profit organization : QwikShare is a new not-for-profit organization that will rent low-emissions automobiles at QwikStops in suburban areas in order to provide an environmentally friendly transportation option to its customers.
Describe real-life situations to which normal distribution : Normal 0 false false false EN-US X-NONE X-NONE describe real-life situation..
A recently formed committee to deal with numerous : Scenario: You are a member of a recently formed committee to deal with numerous complaints against police and correction officers in your town and are asked to determine if there is merit to these allegations and develop a protocol to address the cur..
Determine the range of interest rates : Moussa Sangare is purchasing a used car and has the option of two possible paymentplans: Determine the range of interest rates for which Plan B is better for Moussa.
Considering both federal and state personal taxes : George and Margaret Wealthy are in the 42 percent tax bracket, considering both federal and state personal taxes. Norman Briggs, then CEO of Community General Hospital, has been aggressively pursuing the couple to contribute $400 thousand to the hosp..

Reviews

Write a Review

Financial Management Questions & Answers

  Explain what does the market believe will be the stock price

The dividend is expected to grow at some constant rate g, the stock currently sells for $33 a share. Assuming the market is in equilibrium, what does the market believe will be the stock price at the end of 3 years (i.e.,what is P^3)?

  Estimate its optimal capital structure

Simon Software Co. is trying to estimate its optimal capital structure. Right now, Simon has a capital structure that consists of 20% debt and 80% equity, based on market values. (Its D/S ratio is 0.25.) The risk-free rate is 6% and the market risk p..

  Which firms shareholders are wealthier

Which firm's shareholders are wealthier? Explain why. The following are selected financial information on Firm A and Firm B. You are asked to complete the table by methodically calculating the missing information. You will assume that Cost of Goods S..

  How does corporate strategy differ from business

please answer the following questions. please refer to some of the following individual companies for examples ge

  The treasurer is currently considering two alternatives

The treasurer of a middle market, import-export Company has approached you for advice on how to best invest some of the firm’s short-term cash balances. The company, which has been a client of the bank that employs you for a few years, has $250,000 t..

  Prepare a statement showing the incremental cash flows

Prepare a statement showing the incremental cash flows for this project over an 8-year period and calculate the payback period (P/B) and the net present value (NPV) for the project.

  Incremental cash inflow from proposed credit policy switch

A supplier grants your firm credit terms of 3/10, net 50. What is the effective annual rate of the discount if the firm purchases $1,000 worth of merchandise? What is the incremental cash inflow from the proposed credit policy switch?

  Depreciated straight-line to zero over its six-year life

Your firm is contemplating the purchase of a new $630,000 computer-based order entry system. The system will be depreciated straight-line to zero over its six-year life. It will be worth $42,000 at the end of that time.

  What was the approximate real return

A stock had a return of 5.7 percent last year. If the inflation rate was 1.6 percent, what was the approximate real return?

  Treasury bill rate

Suppose the real rate is 3.5 percent and the inflation rate is 5.1 percent. What rate would you expect to see on a Treasury bill? (Round your answer to 2 decimal places. (e.g., 32.16))

  Evaluate the role and function of finance

Evaluate the role and function of finance, including the presentation and analysis of financial information, in sustaining and contributing towards the competitive advantage of organisations.

  Retirement account rate

A 40-year-old individual establishes a retirement account that is expected to earn 7 percent annually. Contributions will be $2,000 annually at the beginning of each year. Initially, the saver expects to start drawing on the account at age 60.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd