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
From  the  following  data  write the  standard  cost  card  for  one  unit  of  the  sole  product manufactured.                                    Standard Cost card for One U

General Motors has to raise new capital in one of the following three ways. Using the income tax rate of 32%, find the after-tax cost of new capital in each case. (A) Sell commo

Lindon Company is the exclusive distributor for an automotive product that sells for $43 per unit and has a CM ratio of 35%. The company''s fixed expenses are $421,400 per year. Th

Ed Mettway was concerned about his firm's ability to acquire the necessary property, plant, and equipment to take advantage of steadily increasing sales. Touring Enterprises, estab

Constant Gross Margin Rate This method assumes that every product contributes an equal percentage of gross profit for every shilling of sales. It works back from gross margin

Balance Sheet                                                                      2010                2011             Assets Cash

1. when using the internal rate of return method to evaluate capital spending on a new project, the project will be accepted if the internal rate of return is equal to or greater t

Batch Costing This is a kind of job costing that is utilized when production consists of limited repetitive work and definite number of item manufactured in one batch.  A batc

In the beach city of Santa Barbara, California, there are seven bathing suit stores, each with the same schedule of costs and each facing an identical demand curve. Swim N Style is

explain one operation: unit or output cost