Identify and quantify to complete the road king trucks case

Assignment Help Financial Management
Reference no: EM13995327

Question:1. Complete the case study analysis with financial calculations and analysis on an Excel spreadsheet to support your analysis.

MEMORANDUM

Subject: Road King Trucks:

1. A report broken down into the following sections:
- Summary results and recommendations-up front, concise, and to the point.
- Answers to the 6 questions asked-devote a paragraph to each, with individual headings
- Attached exhibits which are readable and understandable (I suggest using Calibri font in 11 pitch for the spreadsheet(s), because it is plain and easy to read)
• Spreadsheet printout(s) showing your derivation of
o Operating Cash Flows
o Incremental Cash Flows, including investment and salvage o Warranty costs o WACC
o NPV, IRR, Payback, and Profitability Index
• Any other supporting exhibits you feel are relevant
- A file containing your spreadsheet file, including all supporting elements. I want to get a sense of how well you used the power of the Excel program to make your calculations.

2. A simple typed report is adequate. I do not need fancy graphics or covers.
- Use 12 pitch, Times Roman font for the body of the report.
- Single spacing is preferred, and will allow you more than enough space to complete your report in less than 5 pages.
- You should refer back to your exhibits for data or calculations, keeping them out of the main body of the report.
- Make sure name is listed on a cover sheet, as well as the project title and the date. The cover page does not count against the 5 page limit.

Subject: Road King Trucks: Stuff to Figure Out

Below is a list of items you need to identify and quantify to complete the Road King Trucks case
A. For Each Year
1. Revenue
2. Variable costs
a. Labor cost per bus
b. Parts cost per bus
c. Engine costs per bus (2 options)

3. SG&A costs
4. Training costs
5. Warranty costs
a. Bus
b. Engine (2 options)
6. Depreciation
7. Working Capital needs
B. Project Related
1. Investment costs
C. Cost of Capital
1. Company's weighted average cost of capital (WACC)
2, Appropriate cost of capital for this project

And, after doing this, you have to form a basis for a go/no go decision on the project, with appropriate support for your decision (think NPV and IRR).

Your final report, limited to 5 pages plus exhibits, should include a spreadsheet containing all relevant calculations, and answers to the 6 questions listed on page 2 of the case statement. Keep in mind that an answer or recommendation is only as good as the supporting analysis performed to reach it. What you "think" is irrelevant, unless it can be supported with facts.

Road King Trucks

Introduction

Michael Livingston has recently been hired as the CEO of Road King Trucks, Inc. Previously he had been the marketing manager for a large manufacturing company and had established a reputation for identifying new consumer trends. Road King Trucks Inc. is a California-based truck manufacturing company. The company is well known for manufacturing large, heavy-duty trucks at a reasonable cost. One of its greatest achievements is that its trucks can be easily modified or customized for different applications. Road King Trucks also builds school buses.

The company is considering an expansion of its current product line to include transit buses. Mr. Livingston feels that due to high gasoline prices, commuters will be more willing to consider using mass transit instead of using their cars to commute to work.

Company Profile

Road King Trucks, Inc. was established by the Smith brothers in 1880 as the California Wagon Company. The firm started manufacturing horse-drawn wagons to serve the growing population in California. The brothers quickly realized that the times were changing, so they started looking for the technologies that would keep them at the forefront of their field of business. In 1915, the Smith brothers decided that they needed to make trucks as replacements for the wagons, because trucks were starting to serve the same uses as wagons, and the wagon industry was not going to be viable in the longer term.

The company started making school buses in the early 1940's. Most manufacturers had been commissioned by the government to produce different large vehicles to support World War II operations. Road King Trucks opted to produce buses. It was an easy decision to make, since the buses would use common parts with the company's trucks, and the customers were local governments. Starting in the 1950's, the school bus business accounted for about 50% of Road King Trucks' revenues.

The Transit Bus Opportunity

Mr. Livingston arranged a meeting with the firm's top management, as well as the chief design and manufacturing engineers to propose his new product. He presented an argument that more individuals in the United States and Canada would be willing to use public transportation than before, because people were becoming more environmentally conscious. Also, recent increases in fuel costs seemed to be long lasting. This was an opportunity to get people hooked on transit buses, as he put it.

The proposal under consideration was for the introduction of a large, public transport bus. To distinguish Road King Trucks from other manufacturers, the proposal included details about the level of comfort, air-conditioning, efficiency, and quietness of operation that needed to be developed.

Mr. Phillips and Mr. Lopez, the two engineers, reacted enthusiastically and quickly pointed out that the bus could be based on the company's trucks. The frame currently used for building the trucks could be modified to accommodate buses at a relatively low cost. The marketing vice president, Mr. Chen, pointed out that a marketing analysis could be done quickly, and at a reasonable cost. At this point, Mr. Livingston charged the participants in the meeting to produce a financial plan for the development and production of a transit bus.

Public Transportation

The use of public transportation had declined steadily since the 1950's. Most people were opting to use their personal vehicles for all of their transportation needs. Recently, however, most of the metropolitan areas in the United State and Canada, the target markets for the new bus, had become more and more congested; and parking, which was already very expensive, was becoming scarce.

This combination of trends has renewed the public's interest in good and reliable public transportation. Several municipalities have been campaigning to their residents and commuters that they should use public transportation for business commuting, and only use their cars for shopping and weekend activities. However, such campaigns need to be supported by making high quality public transportation available to the target riders.

The Decision

Three weeks after the initial meeting, the vice presidents presented the sales and cost forecasts shown in the attached exhibits. The information presented contains the cost of production, financing information, and warranty cost estimates. The proposals also contained two engine options for the engines: The Detroit engine, and the Marcus engine. The Detroit engine was more expensive to install, but had a lower warranty cost. The Marcus engine was less expensive to install, but had a higher warranty cost. This begged the question: Which engine should be used?

Issues and Analyses

Mr. Livingston noticed that there was a great deal of enthusiasm among the management group about the transit bus opportunity, but his cautious nature told him to also seek a more objective viewpoint. Consequently, he sought out you to analyze the proposed project and provide your recommendations directly to him. The issues he wants you to address in your analysis and report are the following:

1) How much importance should be given to the energy cost situation?

2) What are the project's cash flows for the next twenty years? What assumptions did you use?

3) What is the company's cost of capital? What is the appropriate discount factor (which may be different) for you to use in evaluating the bus project?

4) If you decide to go ahead with the project, which of the two engines should be used in the bus, and why?

5) Evaluate the quality of the project, by using appropriate capital budgeting techniques.

Would you recommend that Road King Trucks accept or reject the project? What are the key factors on which you base your recommendation?

2. Answer the 6 questions with a 1 paragraph analysis for each of the 6 questions.

3. The data information can be found on Exhibits 1, 2 & 3 to support our financial analysis of the project. Please show all relevant excel financial calculations to support our analysis for the 6 questions.

Exhibit 1: Sales and Cost Forecast

The sales forecast is based on proj ected levels of demand. All the numbers are expressed in today's dollars. The forecasted average inflation per year is 3.5%

Price per bus

$220,000

 

 

Units sold per year

11,000

 

 

Labor cost per bus

$50,000

 

 

Components & Parts per bus

$95,000

 

 

Selling General &

Administrative

(fixed)

$250,000,000

 

 

NOTE: Average warranty cost per year per bus for the first five years is $1,000. The present value of this cost will be used as a cost figure for each bus. Afterwards, the bus operator will become responsible the repairs on the buses.

The buses can be produced for twenty years. Afterwards, the designs become obsolete.

Engine choices

Engine

Detroit engines

Marcus engines

Price per engine, including installation

$20,000

$18,000

Average annual warranty cost per year for five years. Afterwards, the bus operator will become responsible for the repairs on the buses.*

$1,000

$1,500

The chosen engine will be installed in every bus and will become a cost figure for each bus.

NOTE: The engine manufacturers are not providing Road King Trucks with any warranty. However, Road King Trucks will provide a warranty to its customers. After the initial five years, the bus operators may purchase an extended warranty from any insurance company that offers such packages.

Exhibit 2: Investment Needs

To implement the project, the firm has to invest funds as shown in the following table:

Year 0

Year 1

Year 2

 

$1 billion*

$100 million*

$100 million*

 

* Road King Trucks estimated that it woul and purchase the necessary equipment to investment, divided equally in years 1 anc Such investment is treated as regular busin<

d cost a total of $ produce the buse 2, is for non-depr 2ss expenses.

billion to build the factory s. The other $200 million eciable labor training costs.

Straight fine depreciation will be used for the sake of simplicity.

To facilitate the operation of manufacturing the transit buses, the company will have to allocate funds to net working capital (NWC) equivalent to 10% of annual sales. The investment in NWC will be recovered at the end of the project.

The equipment will be sold for salvage at about $15,000,000 at the end of the project.

Exhibit 3: Financing Assumptions

The following assumptions are used to determine the cost of capital.

Historically, the company has maintained a debt ratio is 40%. This ratio was used, because lowering the debt implies giving up the debt tax shield, and increasing it makes debt service a burden on the firm's cash flow. In addition, increasing the debt level may cause a reduced rating of the company's bonds. The marginal tax rate is 40%. All the numbers are expressed in today's dollars. The forecasted average inflation per year is 3.5%.

Cost of debt:

The company's bond rating is roughly at the high end of the A range. Surveying the debt market yielded the following information about the cost of debt for different rating levels:

Bond rating

AA

A

BBB

Interest cost range

5.5% ~ 6.5%

6.25%-7.5%

7.5% - 9%

The company's current bonds have a yield to maturity of about 6.5%.

Cost of equity:

The current 10-year Treasury notes have a yield to maturity of 2.25% and the forecast for the S&P 500 market premium is 8.75%. The company's overall p is 1.15.

Reference no: EM13995327

Questions Cloud

What is ethical and socially responsible marketing : What is ethical and socially responsible marketing and why should marketers be concerned about CSR and sustainability?What factors contributed to the marketing success of Fiji Water?
What should the long-run inflation rate be : If the money supply is growing at 8%, the real rate of growth of GDP is 2%, and financial innovations are reducing the demand for money by 0.5% per year, what should the long-run inflation rate be?
How far from the right end of the beam should support b : In the same diagram construct two graphs showing the upward forces FA and FB exerted on the beam at points A and B as functions of the coordinate x of the boy. Let 1 cm = 100 N vertically, and let 1 cm = 1.00 m horizontally.
Penny is making pipecleaner flowers : Penny is making pipecleaner flowers to sell on Etsy for $1 each. Penny and her friends become more efficient as they gain practice in flower production. The first 100 flowers cost $1.35 each. All the rest cost $0.40 each. What is the marginal cost of..
Identify and quantify to complete the road king trucks case : Complete the case study analysis with financial calculations and analysis on an Excel spreadsheet to support your analysis - How much importance should be given to the energy cost situation and what are the project's cash flows for the next twenty ye..
The strategic officers steering committee : Describe the process that you plan to use to conduct research, identify findings, and develop the Comprehensive Project that is due in Unit 5. Unit 5 is a final report on ToolsCorp located it in Tennessee. As a team we have been tasked to put togethe..
How does this approach differ from united state gaap : BA's inventories are valued at the lower of cost and net realizable value. How does this approach differ from U.S. GAAP?
Independent of estimation accuracy : At the 0.025 level of significance, test whether customer size might be independent of estimation  accuracy.
Public Policy-the local governments operational budget : Develop a four- to five-page APA-style paper that assesses a public policy of your choice that directly impacts the local government in the area where you reside. You must include the details of the public policy and analyze the effects (positive and..

Reviews

Write a Review

Financial Management Questions & Answers

  Foreign company acquisition

Acquisition by a foreign company and the effects of that decision and the results of foreign exchange in Euro and the exchange rate differences.

  Financial management for profit and non profit organizations

In this essay, we are going to discuss the issues of financial management in a non-profit organisation.

  Method for estimating a venture''s value

Evaluate venture's present value, cash and surplus cash and basic venture capital.

  Replacement analysis

This document show the Replacement Analysis of modling machine. Is replacement give profit to company or not?

  Business finance task - capital budgeting

Your company is considering using the payback period for capital-budgeting. Discuss the advantages and disadvantages of this technique.

  Analysis of the investment

In this project, you will focus on one of these: the additional cost resulting from the purchase of an apple press (a piece of equipment required to manufacture apple juice).

  Conduct a what-if analysis

Review the readings and media for this unit, including the Anthony's Orchard case study media. Familiarise yourself with the Anthony's Orchard company and its current situation.

  Determine operational expenditures

Organisations' behaviour is guided by financial data. In the short term, such data will help determine operational expenditures; in the long term, historical data may help generate forecasts aimed at determining strategic plans. In both instances.

  Personal financial management

How much will you have left over each half year if you adopt the latter course of action?

  Sources of finance for expansion into new foreign markets

A quoted company is considering several long-term sources of finance for expansion into new foreign markets.

  Long term financial planning

This assignment is designed for analyze Long term financial planning begins with the sales forecast and the key input in the long term fincial planning.

  Explain the role of fincial manager

This assignment explain the role of fincial manager, function of manger. And what are the motives of financial manager.

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