Spirit Freightways is a leader in transporting agricultural products in the western provinces of Canada. Reese Brown, a financial analyst at Spirit Freightways, is studying the behav- ior of transportation costs for budgeting purposes. Transportation costs at Spirit are of two types: (a) operating costs (such as labor and fuel) and (b) maintenance costs (primarily overhaul of vehicles). Brown gathers monthly data on each type of cost, as well as the total freight miles traveled by Spirit vehicles in each month. The data collected are shown below (all in thousands): ITI Month Operating Costs $ 942 Maintenance Costs Freight Miles $ 974 January February March 1,710 1,008 776 2,655 1,218 686 2,705 April May 1,380 694 4,220 1,484 588 4,660 June 1,548 422 4,455 1,568 352 July August September 4,435 1,972 420 4,990 1,190 564 2,990 October 788 1,302 962 2,610 November 762 2,240 December 772 1,028 1,490

Spirit Freightways is a leader in transporting agricultural products in the western provinces of Canada. Reese Brown, a financial analyst at Spirit Freightways, is studying the behav- ior of transportation costs for budgeting purposes. Transportation costs at Spirit are of two types: (a) operating costs (such as labor and fuel) and (b) maintenance costs (primarily overhaul of vehicles). Brown gathers monthly data on each type of cost, as well as the total freight miles traveled by Spirit vehicles in each month. The data collected are shown below (all in thousands): ITI Month Operating Costs $ 942 Maintenance Costs Freight Miles $ 974 January February March 1,710 1,008 776 2,655 1,218 686 2,705 April May 1,380 694 4,220 1,484 588 4,660 June 1,548 422 4,455 1,568 352 July August September 4,435 1,972 420 4,990 1,190 564 2,990 October 788 1,302 962 2,610 November 762 2,240 December 772 1,028 1,490

FINANCIAL ACCOUNTING

10th Edition

ISBN:9781259964947

Author:Libby

Publisher:Libby

Chapter1: Financial Statements And Business Decisions

Section: Chapter Questions

Problem 1Q

See similar textbooks

Similar questions

1. For a new product, sales volume in the first year is estimated to be 75,000 units and is projected to grow at a rate of 6.6% per year. The selling price is $100 and will increase by $10 each year. Per-unit variable costs are $20 and annual fixed costs are $1,000,000. Per-unit costs are expected to increase 4.25% per year. Fixed costs are expected to increase 10% per year. Develop a spreadsheet model to predict the net present value of profit over a three-year period, assuming a 4% discount rate. Note: Please include the Excel worksheet with all the details with your answer.
You have estimated that the initial revenues will be $100million per year and grow at a rate of 45% per year for four years. Due to political risk,you decide to use only a four-year horizon for planning purposes. Variable costs areexpected to be 70% of sales; fixed costs are projected to be $10 million per year. Initialcost of machinery, land, equipment, and other things amounts to $110 million. This $110million will be depreciated straight-line to zero over a seven-year accounting life.However, the expected market value of the fixed assets at the end of four years is $50million. Net working capital requirements are minimal, just $10 million at the beginningof the project, all of which will be recovered at termination. Tax rate of your company is30%. This project will be financed with both debt and equity. The plan is to mirror thefirm’s target capital structure by issuing 15 million shares of stock priced at $10.00 a shareand $170 million face value of 10-year bonds which will be…
You are responsible to manage an IS project with a 4-year horizon. The annal cost of the project is estimated at $40,000 per year, and a one-time costs of $120,000. The annual monetary benefit of the project is estimated at $96,000 per year with a discount rate of 6 percent. a. Calculate the overall return on investment (ROI) of the project. b. Perform a break-even analysis (BEA). At what year does break-even occur?
Grady Precision Measurement Tools has forecasted the following sales and costs for a new GPS system: annual sales of 40,000 units at $21 a unit, production costs at 38% of sales price, annual fixed costs for production at $160,000, and straight-line depreciation expense of $210,000 per year. The company tax rate is 30%. What is the annual operating cash flow of the new GPS system?
We are examining a new project. We expect to sell 8,800 units per year at $191 net cash flow apiece (including CCA) for the next 16 years. In other words, the annual operating cash flow is projected to be $191 × 8,800 = $1,680,800. The relevant discount rate is 10%, and the initial investment required is $5,590,000. Suppose you think it is likely that expected sales will be revised upward to 9,550 units if the first year is a success a. If success and failure are equally likely, what is the NPV of the project? Consider the possibility of abandonment in answering. (Do not round intermediate calculations. Round the final answer to 2 decimal places. Omit $ sign in your response.) NPV $ b. After the first year, the project can be dismantled and sold for $2,846,000. What is the value of the option to abandon? (Negative answer should be indicated by a minus sign. Do not round intermediate calculations. Round the final answer to 2 decimal places. Omit $ sign in your response.) The value…
The ABC Corporation is considering introducing a new product, which will require buying new equipment for a monthly payment of $5,000. Each unit produced can be sold for $20.00. ABC incurs a variable cost of $10.00 per unit. Suppose that ABC would like to realize a monthly profit of $50,000. How many units must they sell each month to realize this profit?
A new process for a manufacturing process will have a first cost of $45,000 with annual costs of $38,000. Extra income associated with the new process is expected to be $62,000 per year. What is the discounted payback period at i = 12% per year? 2.84 3.23 2.25 4.52
A machine having a first cost of $20,000 is expected to save $1500 in the first year of operation, and the savings should increase by $200 every year until (and including) the 9th year; thereafter, the savings will decrease by $150 until (and including) the 16th year. Using equivalent uniform annual worth, is this machine economical? Assume a MARR of 10%.
The Elite Car Rental Corporation is contemplating expanding its short-term rental fleet by 30 automobiles at a cost of $900,000. It expects to keep the autos for only two years and to sell them at the end of that period for 60 percent, on average, of what they cost. The plan is to generate $21,000 of incremental revenue per additional auto in each year of operation. The controller estimates that other costs will amount to 20 cents per kilometre on an average of 40,000 kilometres per car per year. She also estimates that the new business will require an investment of $10,000 in additional working capital. The firm is in a 30 percent tax bracket and uses 12 percent as a cost of capital a. Calculate the NPV (Do not round the intermediate calculations. Round the final answer to the nearest whole dollar. Negative answer should be indicated by a minus sign. Omit $ sign in your response.) b. Should Elite purchase the automobiles? O a. a)NPV = $82,286 ± 0.1% and b)NO O b. a)NPV = -$72,386 ±…
A project requires an initial investment in equipment of $96,600 and then requires an initial investment in working capital of $14,400 (at t= 0). You expect the project to produce sales revenue of $131,000 per year for three years. You estimate manufacturing costs at 60 percent of revenues. (Assume all revenues and costs occur at year-end [i.e., t= 1, t= 2, and t=3]). The equipment depreciates using straight-line depreciation over three years. At the end of the project, the firm can sell the equipment for $12,420 and recover the investment in net working capital. The corporate tax rate is 21 percent and the cost of capital is 15 percent. Calculate the NPV of the project. Multiple Choice O O O $4,679 -$3,574 $13,573
The following material costs are anticipated over a 5-year period: $9,000, $11,000, $14,000, $18,000, and $23,000. It is estimated that a 4% inflation rate will apply over the time period in question. The material costs given above are expressed in then-current dollars. The time value of money, excluding inflation, is estimated to be 7%. Determine the present worth equivalent for material cost using the following: a. Then-current costs. b. Constant-worth costs.
Thunderbolt Corporation is considering an investment project to produce electric gadgets. Cathie Wood projected unit sales of these gadgets to be 10,000 in the first year, with growth of 6.5 percent each year over the subsequent five years (so the total project life is six years). Production of these gadgets will require $1,200,000 in net working capital to start. The net working capital will be recovered at the end of the project. Total fixed costs are $3,000,000 per year, variable production costs are $350 per unit, and the units are priced at $850 each. The equipment needed to begin production will cost $8,400,000. The equipment will be depreciated using the straight-line method over a six-year life and has a pre-tax salvage value of $520,000 when the project closes. The tax rate is 25%. a) Using Excel, set up a table that shows your detailed calculation with formulas of the project cash flows for each year throughout the life of the project.