Construct cash flow statements for each vehicle

Assignment Help Finance Basics
Reference no: EM132314814

Assignment -

Introduction - Ruby needs to purchase some new vehicles to make local deliveries. Fedex currently has approximately 7,000 vehicles. Historically, Fedex purchased vehicles that ran on conventional energy sources such as gasoline. New technologies have become available, including Compressed Natural Gas (CNG) power trains, electric power trains and technologies to make new vehicle designs that are more fuel efficient.

What is best choice for Fedex and is looking for your input.

CNG - CNG has several appealing qualities. Firstly, local, state and federal tax credits are available for these vehicles. Tax credits directly offset any tax liability. CNG vehicles are also more energy efficient than the conventional gas or diesel vehicles. More importantly, CNG is considered a 'clean' technology. Given the recent attention to climate change and environmental responsibility, CNG would allow FEDEX to differentiate itself from other delivery firms with consumers.

Electric - Like CNG, electric vehicles also have several appealing qualities. Firstly, local, state and federal tax credits are available for these vehicles. Tax credits directly offset any tax liability. Electric vehicles, since they don't consume any gas, are not subject to the same operational cost risk as traditional fossil fuel vehicles when it comes to fuel costs. Electric prices are generally regulated by the government and change more slowly. As with CNG, electric is considered a 'clean' technology.

Redesigned Vehicle - One way to increase the efficiency of the delivery fleet is to use new technologies to improve Fedex's vehicles that use traditional powerplants. Fedex could use more modern materials, such as light way composite materials. For example, these changes could save 1,000 pounds in weight. The vehicles could also utilize newer engine technology, which would reduce engine size, leading to increased efficiency as well.

CNG vehicles have a higher initial cost. There are Federal, (and some) State and Local tax incentives for alternative fuel vehicles and alternative fuel expense.

CNG per gallon is cheaper than both gas and diesel (approx $2.08/gallon currently versus $2.85 for diesel).

There are not many CNG fueling stations in the area.

It takes longer to fuel a CNG vehicle than a traditional gas or diesel vehicle.

Annual Maintenance is somewhat higher.

Electric vehicles have a higher initial cost.

There are Federal, (and some) State and Local tax incentives for alternative fuel vehicles and alternative fuel expense.

Rather than fuel costs, electric vehicles have a cost measured in KW/hour.

To charge in a reasonable amount of time, special charging stations need to be installed, which cost $2,500 per station. Each station works for 2 vehicles.

Because electric vehicles simply charge overnight, there is no fueling time required by the driver.

Annual Maintenance is somewhat lower because less moving parts.

Redesigned vehicles run on gas

They get 40% more MPG than traditional gas vehicles.

They hold 25% less packages than the other vehicles, which means they have shorter routes, which requires more vehicles to deliver the same number of packages.

Take 25% less time to fuel.

Have 35% lower maintenance costs because the new materials are easier to maintain.

 

Diesel

Gas

CNG

Electric

Redesign

Purchase Price ?(excluding 7.5% tax)

$46,000

$34,500

$135,000

$137,000

$63,900

Available Tax Credits?

 

 

$9,000

$7,000

 

 

Fuel Costs

CNG

Electric

Redesign

Miles Driven (per day)

52

52

39

MPG/MPKW

7.07

1.10

9.72

Current Fuel Expense (per gallon/KW)

$2.08

$0.23

$2.86

Avg. daily time to fuel vehicle (mins)

2.17

0.00

0.39

 

Fuel Site Costs and Tax Credits

CNG

Electric

Redesign

Fuel Site Maintenance Agreement Cost (per gallon)

0.38

 

 

Fuel Tax Credit (per gallon)

0.50

 

 

 

Fuel Costs

Diesel

Gas

Miles Driven (per day)

52

52

MPG

9.85

6.94

Fuel Expense (per gallon)

$2.85

$2.86

Avg. daily time to fuel vehicle (mins)

0.47

0.52

 

Fuel Site Costs and Tax Credits

Diesel

Gas

Fuel Site Maintenance Agreement Cost (per gallon)

 

 

Fuel Tax Credit (per gallon)

 

 

Your tax department has instructed you that tax credits should be applied to the purchase price after tax in your costing model prior to calculating depreciation.

You average 252 working days annually.

Use the 7 year MACRS depreciation schedule.

You have a 12% weighted cost of capital (discount rate).

Your company is in a 36.3% tax bracket.

All tax savings are realized in the year they accrue.

There is a 7.5% sales tax on each vehicle type.

Assume delivery of the vehicles would take place at the beginning of 2020.

Assume selection is based on costs over a 10 year period (i.e. vehicle life is 10 years).

Assume vehicles 10% salvage value.

Make models based on yearly time periods (rather than days/months).

Total driver cost, including both wages and benefits, is $62.19 per hour.

In 2018, maintenance costs/mile for the CNG, Electric, Redesigned, Diesel and Gas vehicles were estimated to be $0.2697, $0.1753, $0.1802, $0.2511, and $0.2773 respectively.

Maintenance expenses are projected to increase at 3.5% annually through 2025 and then 4.5% per year after that

Gasoline is expected to cost $3.65 next year, with prices changing 3.75%, 2.15%, 2.45% and 4.25% over the subsequent 4 years with constant prices thereafter.

CNG and Diesel are expected to cost $2.59 and $4.09 per gallon next year, respectively.

Prices of both are expected to change by 8%, 5%, 2%, and 1% over the subsequent 4 years with constant prices thereafter.

Electricity Prices are currently $0.23/KW. These prices are expected to rise by 7% per year for the foreseeable future.

Besides cost differences, expect vehicle choice will affect package volume due to good/bad press.

Any profits/losses from volume changes have tax implications (independent from vehicle costs).

Expect volume changes as follows:

Important: Revenue/cost data only apply to these volume changes.

Decision Time -

1. Based on the collected data, construct cash flow statements for each vehicle. Which of the vehicles would you purchase?

2. Based on your solution to the 1st question, what part of the total cost of each vehicle is the initial cost, fuel costs and other operating expenses? Deduct tax credits where appropriate before your analysis.

3. How much do the tax incentives lower the total costs of CNG and Electric vehicles?

4. How much do the revenue changes impact your decision?

Reference no: EM132314814

Questions Cloud

Develop and incorporate a neural network : 300056 - Robotics - Western Sydney University - Neural networks for robot control - implement a given computed-torque controller (CTC) in Simulink for robot
Describe the nature of the eCRM initiative : ISY3001/ISY301 E-Business Fundamentals and Systems Assignment - Australian Institute of Higher Education. Describe the nature of the eCRM initiative
Evaluate ethical dilemmas in the global environment : MGT3001 Governance and Business Ethics Assignment - Case Study Report, Australian Institute of Higher Education. Evaluate ethical dilemmas in global environment
Plot the probability function of exact sampling distribution : Plot the probability function of the exact sampling distribution for P, assuming a sample size of n = 10 and population prevalence of 0.5
Construct cash flow statements for each vehicle : Based on the collected data, construct cash flow statements for each vehicle. Which of the vehicles would you purchase
What are top rated digital asset management software product : BBC Digital Media Initiative Revisited - Do research online to identify the capabilities of digital asset management software. What are the top rated digital.
Define federal and state case using standard legal notation : In the same document, please post one federal and one state case using standard legal notation and a hyperlink to each case. Need 300 words with 2 references.
What amounts of size and amenities will the consumer choose : Create a graph with Size on the x-axis and Amenities on the y-axis. Plot a point on the graph for each of the houses in the table above. Draw 4 indifference
Discuss about real world applications based on the problem : Your group can choose one from the following problems or your group can choose to come up with your own. However, after forming group and deciding on the topic.

Reviews

Write a Review

Finance Basics Questions & Answers

  Conditions on the business software and services industry

For Microsoft Corporation, what are the implications of the current economic conditions on the Business Software and Services Industry?

  What is the return on assets

The Lighting Store has sales of $364,000, depreciation of $28,000, and taxable income of $58,000. The capital intensity ratio is 1.2, the debt-equity ratio is 0.45, and the tax rate is 34%. What is the return on assets?

  How does jefferson derive the amount

How does Jefferson derive the amount of 22,500 pounds sterling per annum, and what does he mean by the statement "we have a right to say that only 22,500 pounds

  Forces analysis on the following two industries

The pharmaceutical industry consists of firms that develop, patent, and distribute drugs. Although this industry does not have significant production economies

  Percentage of senior technical researchers

(i) Determine the probability that someone selected at random from this group received a bonus of $20, 000 or higher. (ii) If a bonus of $100, 000 or higher is considered a "Jumbo" bonus, what percentage of senior technical researchers receive..

  Calculate the 13 basic ratios found in the chapter

Using the financial statements for the Niara Calendar Company, calculate the 13 basic ratios found in the chapter.

  What is the volume variance

Actual data show a 4.5% reduction in errors at a cost of $19,000. What is the volume variance, and is it favorable or unfavorable?

  Expected yields to maturity of the bonds

A 10-year bond of a firm in severe financial distress has a coupon rate of 10% and sells for $900. The firm is currently renegotiating the debt

  Draw the three-period stock tree

(a) Draw the three-period stock tree and the corresponding trees for the call and the put.  (b) Compute the price of these options using the three-period trees.  (c) Explain when, if ever, each option should be exercised.

  Question regarding the glentech manufacturing

Glentech Manufacturing is considering the purchases of an automated parts handler for theassembly and test area of its Phoenix, Arizona, plant. The handler will costs $250,000 topurchase plus $10,000 for installation and employee training.

  Present value of cash flows

Hassan Ali has made an investment that will pay him $11,455, $16,376, and $19,812 at the end of the next three years. His investment was to fetch him a return of 14 percent. What is the present value of these cash flows? (Round to the nearest doll..

  How inflation affect the comparability of financial ratios

What specific effects can the use of alternative accounting procedures have on the validity of comparative financial analyses?- How can inflation affect the comparability of financial ratios between firms?

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