Ask Financial Accounting Expert

The assignment

It has the Cash Flow cost for the Marcus Engine.

I need a Cash flow sheet for the Detroit Engine so I have a comparison to submit.

I. Below is a list of items that is needed to identify and quantify:

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 Detroit Engines or Marcus Engine)

3. Selling, General & Administrative 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 See attached spreadsheet example
1. Company's weighted average cost of capital (WACC) see Exhibit 3

2. Appropriate cost of capital for this project

II. Include a spreadsheet containing all relevant calculations and answers to these 7 questions based from the Exhibit information above.
See attached spreadsheet for Cash Flow and Cost of Capital examples

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.

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

7) Should the company do or not do the bus production project? What is the appropriate support for the decision (think NPV and IRR).

Road King Trucks - Assessment Project

The Transit Bus Opportunity

The company currently builds trucks and is considering building buses. A cost assessment should be done to see if the bus manufacturing will be at a reasonable cost.

Company Profile

The company starting manufacturing school buses and account for about 50% of Road King Trucks' revenues.

The Decision

Management presented the sales and cost forecasts shown in the Exhibits below. 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.
Which engine should be used?

Issues and Analyses
Management feels the transit bus project will be a great opportunity but an analysis and report needs to be produced for the proposed project.

Exhibit 1: Sales and Cost Forecast

The sales forecast is based on projected 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.

 

Two Engine Choices:

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 would cost a total of $1 billion to build the factory and purchase the necessary equipment to produce the buses. The other $200 million investment, divided equally in years

 1 and 2 is for non-depreciable labor training costs.

Such investment is treated as regular business expenses.

 

Straight line 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

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 beta is 1.15.

Attachment:- Homework.xlsx

Financial Accounting, Accounting

  • Category:- Financial Accounting
  • Reference No.:- M91698161
  • Price:- $70

Guranteed 36 Hours Delivery, In Price:- $70

Have any Question?


Related Questions in Financial Accounting

Case study - the athletes storerequiredonce you have read

Case Study - The Athletes Store Required: Once you have read through the assignment complete the following tasks in order and produce the following reports Part 1 i. Enter the business information including name, address ...

Scenario assume that a manufacturing company usually pays a

Scenario: Assume that a manufacturing company usually pays a waste company (by the pound to haul away manufacturing waste. Recently, a landfill gas company offered to buy a small portion of the waste for cash, saving the ...

Lease classification considering firm guidance issues

Lease Classification, Considering Firm Guidance (Issues Memo) Facts: Tech Startup Inc. ("Lessee") is entering into a contract with Developer Inc. ("Landlord") to rent Landlord's newly constructed office building located ...

A review of the ledger of oriole company at december 31

A review of the ledger of Oriole Company at December 31, 2017, produces these data pertaining to the preparation of annual adjusting entries. 1. Prepaid Insurance $19,404. The company has separate insurance policies on i ...

Chelsea is expected to pay an annual dividend of 126 a

Chelsea is expected to pay an annual dividend of $1.26 a share next year. The market price of the stock is $24.09 and the growth 2.6 percent. What is the cost of equity?

Sweet treats common stock is currently priced at 3672 a

Sweet treats common stock is currently priced at $36.72 a share. The company just paid $2.18 per share as its annual dividend. The dividends have been increasing by 2,2 percent annually and are expected to continue doing ...

Highway express has paid annual dividends of 132 133 138

Highway Express has paid annual dividends of $1.32, $1.33, $1.38, $1.40, and $1.42 over the past five years, respectively. What is the average divided growth rate?

An investment offers 6800 per year with the first payment

An investment offers $6,800 per year, with the first payment occurring one year from now. The required return is 7 percent. a. What would the value be today if the payments occurred for 20 years?  b. What would the value ...

Oil services corp reports the following eps data in its

Oil Services Corp. reports the following EPS data in its 2017 annual report (in million except per share data). Net income $1,827 Earnings per share: Basic $1.56 Diluted $1.54 Weighted average shares outstanding: Basic 1 ...

At the start of 2013 shasta corporation has 15000

At the start of 2013, Shasta Corporation has 15,000 outstanding shares of preferred stock, each with a $60 par value and a cumulative 7% annual dividend. The company also has 28,000 shares of common stock outstanding wit ...

  • 4,153,160 Questions Asked
  • 13,132 Experts
  • 2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

Why might a bank avoid the use of interest rate swaps even

Why might a bank avoid the use of interest rate swaps, even when the institution is exposed to significant interest rate

Describe the difference between zero coupon bonds and

Describe the difference between zero coupon bonds and coupon bonds. Under what conditions will a coupon bond sell at a p

Compute the present value of an annuity of 880 per year

Compute the present value of an annuity of $ 880 per year for 16 years, given a discount rate of 6 percent per annum. As

Compute the present value of an 1150 payment made in ten

Compute the present value of an $1,150 payment made in ten years when the discount rate is 12 percent. (Do not round int

Compute the present value of an annuity of 699 per year

Compute the present value of an annuity of $ 699 per year for 19 years, given a discount rate of 6 percent per annum. As