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
Material Handling The objective is to ensure about the goods are delivered to the right places at the right instance and in aright manner to ignore delays, unnecessary and con

Contract Accounts It is a separate account such is maintained and opened for every contract undertaken for the reasons of accumulating cots.  Every contract is given a number

QUESTION 1: PART A Swatathon Inc. has two production departments (A and B) and two service departments (maintenance and stores). Details of next year's budgeted overheads

B REAK EVEN ANALYSIS Break even analysis is a broadly used technique to study cost-volume-profit relationship.  It can be explained as - 'a system for determination of that le

A company wishes to devise a fair means of allocating funds to its four main departments, namely Accounts, Production, Sales and Transport. The total allocation is to be £100,000.

Over And Under Absorption of Production Overhead Costs This may be analyzed beneath a) Activity This is level of the business or cost center. Expenditure on several item

Eagle Company is considering the purchase of an asset for $100,000. It is expected to produce the following net cash flows. The cash flows occur evenly throughout each year. Comput

maintenance costs at a hospital

The manufacturing division of an electronics company uses activity-based costing. The company has identified three activities and the related cost drivers for indirect production c

Question Hornsby Manufacturing has four categories of overheads. The four categories and the expected overhead costs for each category for next year are as follows: