Prepare a cash flow statement , Finance Basics

Assignment Help:

Q1.  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


Related Discussions:- Prepare a cash flow statement

The income statement and the balance sheet, Conduct research and explain th...

Conduct research and explain the companies, their operations, locations, markets, and lines of business. Collect financial statements for the past three years, fiscal or calendar .

Depreciation, Which depreciation method would produce the higher NPV and ho...

Which depreciation method would produce the higher NPV and how much higher would it be?

project on financial planning, Financial Planning Project Instructions: ...

Financial Planning Project Instructions: You will serve as a financial advisor for your client to develop a financial plan. You can compile all the worksheets introduced in eac

Memo 1, Mr. de Ville, the owner of Tasman Ian de Ville Holdings Ltd. (TIDH)...

Mr. de Ville, the owner of Tasman Ian de Ville Holdings Ltd. (TIDH) has asked you to evaluate five investment projects. TIDH has a $10,000,000 investment budget, an investment hurd

Cvxcv, #questioxcvxcvn..

#questioxcvxcvn..

#lpp, Solve the following Linear Programming Problem using Simple method. M...

Solve the following Linear Programming Problem using Simple method. Maximize Z= 3x1 + 2X2 Subject to the constraints: X1+ X2 = 4 X1 - X2 = 2 X1, X2 = 0

After tax return, Bill Smith, a manager of a restaurant/bar in Los Angele, ...

Bill Smith, a manager of a restaurant/bar in Los Angele, is in the 25% marginal tax bracket and pays additional 5% in taxes to the state of California. Bill has 20,000 invested in

Stock market index, Stock Market Index Definition of Stock Market Ind...

Stock Market Index Definition of Stock Market Index An index is a numerical figure that measures relative change in variables between two type of durations. Examples

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