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

  Financial reporting and analysis

Finance is about Gunns Ltd, a company in dealing with forestry products in Australia. The company has also been listed in Australian Stock Exchange. As many companies producing forestry products, even Gunns Ltd is facing various problems. Due to the ..

  A report on financial accounting

This report is specific for a core understanding for Financial Accounting and its relevant factors.

  Describe the types of financial ratios

Describe the types of financial ratios and other financial performance measures that are used during venture's successful life cycle.

  Differences between sole proprietorship and corporation

Briefly describe the major differences between a sole proprietorship and a corporation

  Prepare a cash budget statement

Calculate the expected value of the apartment in 20 years' time. What is the mortgage loan repayment at the beginning of each month

  What are the implied interest rates

What are the implied interest rates in Europe and the U.S.?

  State pricing theory and no-arbitrage pricing theory

State pricing theory and no-arbitrage pricing theory

  Small business administration

Identify the likely stage for each venture and describe the type of financing each venture is likely to be seeking and identify potential sources for that financing.

  Effect of financial leverage

The Effect of Financial Leverage and working capital management

  Evaluate the basis for the payment to the lender

Evaluate the basis for the payment to the lender and basis for the payment to the company-counterparty.

  Importance of opps, ipps, mpfs and dmepos

Research and discuss the differences and importance of : OPPS, IPPS, MPFS and DMEPOS.

  Time value of money

Time Value of Money project

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