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

Download the financials of Shoprite , study them, then, using ratio analysis, the cash flow statement, and the segmental breakdown of the results, prepare a statement outlining the

I need an explanation of how a bin card is done

An industrial drill costs $60.000 to purchase and $10,000 to install seven years ago. The market value now is $33.000 and this will decline by 12% of current value each year for th

#question techniques of payment under group bonus plan .

10% of the finished castings were to be defective in manufacture and were rectified by expenditure of additional works overhead charges to the extent of 20% on the proportionate di

A  firm of printers  is contemplating  joining  the uniform  costing  system operated by  its Trade Association but the Managing Director is dubious about the benefits of becoming

under which type of asset the investment comes

The income statement of Holly Enterprises shows operating revenues of $134,800, selling expenses of $38,310, general and administrative expenses of $36,990, interest expense of $58

Labour Costs and Overhead costs Labour Costs Labour costs can be indirect or direct labour costs. Direct labour cost refers to wages paid to workers who such are directly