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

Assignment Help:

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.


Related Discussions:- Determine internal rate of return and cash flow statement

Product versus period costs, Product Versus Period Costs Another way to...

Product Versus Period Costs Another way to look at manufacturing costs is to think of them as attaching to a product. In other words, goods result from the manufacturing proces

Cost accounting, raw an organization chart of any actual or hypothetical ma...

raw an organization chart of any actual or hypothetical manufacturing organization to show the position of management/cost accounting department within an organization and discuss

Assessment item 2, QUESTION 1 Job costing Create a spreadsheet solution to...

QUESTION 1 Job costing Create a spreadsheet solution to the following problem. Follow the template provided. Play the Job cost podcasts and work through the example problem in tho

Accounts payable, Accounts Payable or sundry creditors are generally unsecu...

Accounts Payable or sundry creditors are generally unsecured debts owed through the firm. These are also considered to as payables on open accounts. They may not be evidenced throu

Variance, What is a standard and acceptable variance

What is a standard and acceptable variance

Contract costing, Contract Costing It is a form of exact order costing...

Contract Costing It is a form of exact order costing, which is applied to relatively large cost units that normally get a considerable length of time to complete as an example

Valuation of work in progress, Valuation of Work In Progress The con...

Valuation of Work In Progress The concept of Equivalent units It is a notional quantity of completed goods in the production process. This is a collection of work applic

What is life-cycle costing, Consider the following information, prepared ba...

Consider the following information, prepared based on a capacity of 40,000 units: Category Cost per Unit Variable manufacturing costs

Assumptions of break-even analysis, Assumptions of Break-Even Analysis ...

Assumptions of Break-Even Analysis 1. The break-even chart is fundamentally a static analysis; commonly changes can merely be displayed by drawing a new chart or a series of c

Write Your Message!

Captcha
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd