Determine internal rate of return and cash flow statement , Cost Accounting

A local delivery company has purchased a delivery truck for $15,000.  The truck will be depreciated under MACRS as a five year property.  The trucks market value (salvage value) is expected to decrease by $2,500 per year.  It is expected that the purchase of the truck will increase revenue by $10,000 annually.  The operations and maintenance cost are expected to be $3,000 per year.  The firm is in a 40% tax bracket and its MARR is 15%. The company plans to keep the truck for only two years. The Income statement  is shown below and attached.  

a.  Prepare a cash flow statement for this proposal.

b.  Determine the equivalent present worth  and the internal rate of return.

c.  Should the project be approved?


 

Purchase Cost

($15,000)

year 1

year 2

 

Depreciation MACRS

5

20%

32%

 

Depreciation $

 

$3,000

$2,400

 

Book Value

 

$12,000

$9,600

 

Salvage decrease

$2,500

annually

 

 

Salvage Value

 

$12,500

$10,000

 

Gain

 

 

$400

 

Revenue Increase

$10,000

annually

 

 

O & M costs

($3,000)

annually

 

 

Taxes

40%

 

 

 

MARR

15%

 

 

 

Time span

2

years

 

 

 

 

 

 

Income Statement

0

1

2

Revenue

 

$10,000

$10,000

Direct Costs

 

 

 

 

Labor

 

 

 

 

Material

 

 

 

 

Overhead

 

 

 

 

Cost of Goods Sold (COGS)

 

($3,000)

($3,000)

 

Gross Margin

 

$7,000

$7,000

 

Depreciation

 

($3,000)

($2,400)

Earnings Before Interest and Taxes (EBIT)

$11,000

$11,600

 

Income Tax

 

($4,400)

($4,640)

 

Net Income

 

$6,600

$6,960

 

Question 9-A

Q8a.  (buy option).  The Jacobs company needs to acquire a new lift truck for transporting its final product to the warehouse.

One alternative is to purchase the truck for $45,000. Maintenance of the truck will be an annual cost of $1,200.  The truck falls into the 5-year MACRS classification and it has a salvage value of $10,000, which is the expected market value after 4 years, at which time Jacob plans to replace the truck, irrespective of whether it is purchased or leased.

Alternatively, Jacob could lease the truck under a four-year contract for a lease payment of $15,000 per year.  Each annual lease payment must be made at the beginning of the year.  This is an operating lease, so the truck would be maintained by the lessor (the leasing company).  

The Jacobs company has a marginal tax rate of 40% and a MARR of 15%.

a,  Prepare an Income for the "Buy" cost-only option.  
b.  Prepare Cash flow statement for the "Buy" option.  
c.  What is the present worth of the cost of purchasing the truck?

Question 9-B Lease
Q8b.  (lease option).  The Jacobs company needs to acquire a new lift truck for transporting its final product to the warehouse.

One alternative is to purchase the truck for $45,000. Maintanence of the truck will be an annual cost of $1,200.  The truck falls into the 5-year MACRS classification and it has a salvage value of $10,000, which is the expected market value after 4 years, at which time Jacob plans to replace the truck, irrespective of whether it is purchased or leased.

Alternatively, Jacob could lease the truck under a four-year contract for a lease payment of $15,000 per year.  Each annual lease payment must be made at the beginning of the year.  This is an operating lease, so the truck would be maintained by the lessor (the leasing company).  

The Jacobs company has a marginal tax rate of 40% and a MARR of 15%.

a,  Prepare an Income for the "Lease" cost-only option.  
b.  Prepare Cash flow statement for the "Lease" option.  
c.  What is the present worth of the cost of leasing?

Question 9-9

 Q9.  An industrial engineer proposed the purchase of a RFID Fixed Asset Tracking System for the company's warehouse and weave rooms.  The engineer though that the system would provide a better system of locating cartons in the warehouse by recording the locations of the cartons and storing the data in the computer.  The annual operating and maintenance (O&M) costs and expected annual savings are as follows:

 

Cost of equipment and installation

$85,500

 

 

 

Project life (years)

6

 

 

 

Estimated salvage value

$5,000

in year 6

 

 

Investment in working capital

$15,000

 (fully recoverable at end of project)

Expected savings on labor/material

$65,800

annual 

 

 

Expected Expenses

$9,150

annual 

 

 

Depreciation MACRS years

5

 

 

 

Marginal Tax rate

35%

 

 

 

a Determine the net after-tax cash flows over the project life.
b Compute the IRR for this investment.
c At MARR = 18%, is the project acceptable?

Question 9-9

Q10 Consider a five-year MACRS asset purchase for $80,000. The applicable year end salvage values are estimated as $20,000 in year 3, $5,000 in year 5, $3,000 in year 6, and $2,000 in year 8. Fill in the table below by computing the depreciation, book value, gain/loss amounts and taxes to be paid/received (indicate which) on this gain or loss for the alternative situations of the asset being sold for the salvage value in year 3, 5, 6 and 8. The MACRS from Table 9.3 page 448 are shown below. Use 30% for the capital gains tax rate.

Year

1

2

3

4

5

6

7

8

MACRS rate

20%

32%

19.20%

11.52%

11.52%

5.76%

0.00%

0.00%

Depreciation

 

 

 

 

 

 

 

 

 

Sold in year

Year

1

2

3

4

5

6

7

8

3

Salvage Value

 

 

 

 

 

 

 

 

 

Book Value

 

 

 

 

 

 

 

 

 

Taxable Income

 

 

 

 

 

 

 

 

 

Taxes

 

 

 

 

 

 

 

 

5

Salvage Value

 

 

 

 

 

 

 

 

 

Book Value

 

 

 

 

 

 

 

 

 

Taxable Income

 

 

 

 

 

 

 

 

 

Taxes

 

 

 

 

 

 

 

 

6

Salvage Value

 

 

 

 

 

 

 

 

 

Book Value

 

 

 

 

 

 

 

 

 

Taxable Income

 

 

 

 

 

 

 

 

 

Taxes

 

 

 

 

 

 

 

 

8

Salvage Value

 

 

 

 

 

 

 

 

 

Book Value

 

 

 

 

 

 

 

 

 

Taxable Income

 

 

 

 

 

 

 

 

 

Taxes

 

 

 

 

 

 

 

 

 

Question 9-11

Q11.   You are earning 5.2 percent on a certificate of deposit. Inflation is running 3.5 percent. What is the real rate of return on your investment?

Question 9-12

Q12.  Search for a definition of one of the following economic indexes (or other one) and describe its purpose and how it is calculated: CPI, PPI, HEPI CPI-U.

Question 9-13

Q13.  Is the corporate income tax system unfair?  Why or why not? Should it be changed?  Is a flat tax the answer?  Is no corporate tax, like LLCs, the answer (where owners pay personal income tax on the distribution of earnings).   This is not a question on the merits of taxes, government, the constitution, or related issues.  The goal is to better  understand corporate taxation.

Posted Date: 2/15/2013 1:03:44 AM | Location : United States







Related Discussions:- Determine internal rate of return and cash flow statement , Assignment Help, Ask Question on Determine internal rate of return and cash flow statement , Get Answer, Expert's Help, Determine internal rate of return and cash flow statement Discussions

Write discussion on Determine internal rate of return and cash flow statement
Your posts are moderated
Related Questions
annual usage rs 160000@ 40 per unit, cost of placing and receiving one order rs 200:annual carrying cost ; 25% of inventory value

Product and period costs; CGM; CGS On August 1, 2013, Sietens Corporation had the following account balances: Raw Material Inventory (both direct and indirect) :- $ 72,000 WIP Inve

Multiple Products, Selling Costs, and Margin Management Selling charge are oftentimes variable. For instance, a salesperson can be paid a designated percentage of entire sales

Waterloo Machining, Inc. paid $1,800,000 for factory equipment on January 1, 2012. It paid $100,000 for delivery and $220,000 for installation and modifications.  Waterloo received

Bubble Corporation manufactures two products, I and II, from a joint process. A single production costs $4,000 and results in 100 units of I and 400 units of II. To be ready for sa

The difference among "cost accounting" and "financial accounting are terms demote to the accounting techniques used internally by a company's management to explain the costs of run

what are importance of cost classification

Quicksilver Compnay has set the follwoing standards for one unit of product: Direct material Quantity: 6.2 lbs per unit Price per lb: $11 per lb Direct Labor Quantity: 6 hrs

maintenance costs at a hospital

Marginal Costing and Marginal Cost Marginal Costing is an optionally method of costing to absorption costing , In marginal costing, merely variable costs are charged like a