Cash flow cost for the marcus engine

Assignment Help Financial Accounting
Reference no: EM13988306

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

Reference no: EM13988306

Questions Cloud

Internal operating schedules : This problem is a continuation of Problem 3. Assume you ramp up production to 1,000 units in both may and June. Repeat the calculations requested in Problem 3 for the second quarter of the year (April, may, and June).
Implement a database link cheap solution : My idea is to choose the distributed database management system because it is a solution for this small company and if this company plans to grow in the future de distributed database management system is the true solution. I want to develop more ..
Management tasks existed long before computers : The four management tasks (planning, organizing, directing, and evaluating) existed long before computers. Discuss how the use of computers and technology have changed the way managers perform these tasks.
Problem regarding the total costs of producing : Direct labor costs are $15 per hour and three units can be produced per hour. You intend to selleach unit at a 50 percent markup over the total costs of producing each unit. The plan is to produce 500 product units per month in January, February, ..
Cash flow cost for the marcus engine : 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 - Evaluate the quality of the project, by using appropriate capital budgeting techniques.
What do you want to do in the future : What do you want to do in the future? What is your dream job? What skills will you possess that will help you to reach those dreams?
How would you prevent further gang interaction : You are warden of a state correction facility and need to train your staff to prepare for crisis and violence. How would you prevent further gang interaction
Determine the minimum force p : Determine the minimum force P applied to the wedge required to start raising the crate. The crate weighs 154 lb and the coefficient of static friction for all surfaces is μs = 0.2. Neglect the weight of the wedge.
How would you try to keep gangs out of your school : If you were hired as a principal of a regional high school, how would you try to keep gangs out of your school

Reviews

Write a Review

Financial Accounting Questions & Answers

  What was is the balance of irving capital account

The partnership pays Gst $100,000 cash for her partnership interest.After Gast's retirement, what was is the balance of Irving's capital account ?

  Colorado business tools manufactures calculators

Colorado Business Tools, manufactures calculators.

  Question paul company had 112000 shares of general stock

question paul company had 112000 shares of general stock outstanding during 2013.paul also had 10000 share of

  Healthcare service is a nonprofit organization

Columbia healthcare service is a nonprofit organization. They have revenues of 22 million in 2014. In addition, they had personnel cost of 15.6 million, supplies of 1.4 million and depreciation of 1.2 million. All but 3 million of their revenue was r..

  Bonds are issued

If $2,000,000 of 10% bonds are issued at 97, the amount of cash received from the sale is

  Calculate the revenue for the year on cash basis

Using the accrual basis revenue on the income statement was $124,320. Accounts receivable were $3,320 on January 1 and $3,600 on December 31. Unearned revenue was $1,040 on January 1 and $1,690 on December 31. Calculate the revenue for the year on a ..

  Perpetual method for inventory and record purchases

ABC uses the perpetual method for inventory and record purchases at gross. in 2014, it has a total merchandise purchases of $324,000. It returns $19,000 of the merchandise for full credit and receives $7,000 in allowances from its vendors for defecti..

  Brief statement that expresses your thoughts

View the companys financial statements. What information/ratios should you, as the loan officer, use - describe how the information in the two scenarios is interrelated

  Prepare the journal entry to record the receipt of payment

Prepare the journal entries to record these transactions on the books of Masland Company. Masland uses a perpetual inventory system.

  Budgeted income statementnbsp static and flexible

budgeted income statementnbsp static and flexible budgeted income statement variable costing variance

  Meaning of residual dividend policy and comment on benefits

A position expressed in financial literature is that firms set their dividends as a residual after using income to support new investments. Explain the meaning of a residual dividend policy and comment on the benefits/drawbacks for the company and th..

  Margin of safety in units

Budgeted number of units 6624-What is margin of safety in units?

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